Identify the input edit control available in access

Assignment Help Financial Accounting
Reference no: EM132873187

You are an accountant with MASCHA Enterprises, Inc. and are newly hired. Your first assignment is to review the processes in the EXPENDITURE cycle for internal control weaknesses.

You encounter the following scenarios in the Expenditure Cycle at MASCHA.

A. Purchases are made via telephone. Purchases are on credit-with the supplier extending the credit. Purchase order data are entered into the system by a clerk who inputs the supplier name, price, part number, and quantity into the system. The Purchasing clerk manually totals the order and the Purchase Order is generated.

B. The clerk then sends a copy of the purchase order to the receiving department. Upon receipt of the purchase order, receiving department inputs the information found on the packing slip and enters it into the system. The system then generates a receiving ticket. A copy of the receiving ticket is sent to accounts payable for reference. The parts are then loaded on a pallet and placed in the incoming goods (raw materials) warehouse by the clerk who received them.
Occasionally, the parts remain on the receiving dock until the next business day because of absent workers.

C. The accounts payable clerk enters the receiving data into the system along with the supplier invoice. The same clerk manually updates the Purchase Order. The clerk waits to receive the supplier invoice until performing the "three way match'. Upon approving the invoice for payment, the clerk files the documents in a folder, sorted by data. The clerk then send the approved invoice to the treasury department who generates the check. The signed check is returned to accounts payable for mailing.

Required:

Question 1: List the internal control threats in the above scenarios and list the internal controls that would prevent and/or detect the threat. Be specific as to the nature of the control; for example, "segregation of duties" is not acceptable. you need to specify what duties need to be separate. You need other controls besides segregation of duties; use this control only once. Identify both preventive and detective controls. ALSO identify the input edit control available in Access that would address the threat. Note: not all controls can be done in Access. Organize your answer as follows:

  • LETTER THREATS
  • INTERNAL CONTROLS
  • INPUT EDIT CONTROLS

Reference no: EM132873187

Questions Cloud

What amount should be reported as noncurrent deferred tax : On December 31,2017, what amount should be reported as noncurrent deferred tax liability? The entity anticipated that 10,000 of the deferred tax liability.
Outline four assumptions underlying consumer equilibrium : 1. Outline four assumptions underlying consumer equilibrium 2. Examine five factors that are likely to influence the cost behavior of a firm
What are the significant transactions and accounts : What are some of the questions you would have for Michael before accepting his audit plan? What are the significant transactions and accounts
How often should the company order from the supplier : Carrying cost per unit is $1.00, and its order costs are $100 per order. Given this information, how often should the company order from its supplier?
Identify the input edit control available in access : Identify the input edit control available. List internal control threats in scenarios and list internal controls that would prevent and/or detect the threat.
Records the incurrence of conversion costs : Fun 'N' Games manufactures various board games. Which of the journal entries properly records the incurrence of conversion costs
What is the maximum amount the firm can initially invest : Deep Mines, What is the maximum amount the firm can initially invest in this project to avoid a negative net present value for the project?
What was the net income for the period for hunt inc : Hunt Inc. had total assets and total liabilities, What was the net income for the period if there were no other changes affecting Stockholders Equity?
Calculate Marie annual automobile taxable benefit : Of the 33,884 kilometres driven, 16,114 kilometres were for business purposes. Calculate Marie annual automobile taxable benefit

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd