Question

In: Accounting

You have been assigned to audit the sales and accounts receivable balances of Coppero Engineering Ltd....

You have been assigned to audit the sales and accounts receivable balances of Coppero Engineering Ltd. for the year ended September 30, 2020. Coppero Engineering is a major manufacturer of steel parts and fixtures for other manufacturers in the engineering field. The interim work was undertaken in June 2020 and tests indicated that internal controls over sales and accounts receivable are effective and that therefore control risks are acceptable.

You observe that credit sales are made to a group of 2,500 active customers, located in Canada and the United States. Approximately 30 percent of the customers represent 70 percent of the balances, and although most of these customers are in Canada, a number are also based in the United States, England, and Ireland. The sales made into the United States are invoiced in Canadian dollars and you note that the value of the Canadian dollar has escalated by 30 percent in recent months. The total of the accounts receivable balances at September 30 is $95 million and the current allowance for doubtful accounts is $500,000.

Sales and receipts are recorded on the company's computerized accounting system, which simultaneously updates the accounts receivable balances and sales and cash receipts transactions journals on a daily basis. On a weekly basis, an aged trial balance is generated, which is reviewed by the credit manager for slow-paying accounts. Follow-up action is then taken as necessary. Sales returns and bad debt write-offs are processed and summarized weekly and any write-offs have to be approved by the chief financial officer, based on the recommendations of the credit manager. Documents to support these write-offs are kept on file.

After the end of the reporting period, the rising Canadian dollar and a financial crisis in two of the major American markets have caused some concern for the credit manager, who has recently joined the client after a number of years in the retailing industry. Also, rising interest rates in Canada and a slowing economy have affected sales growth in the Canadian market.

Required

You are asked to prepare an audit program to test Coppero Engineering's year-end accounts receivable. You are required to include in your program specific audit objectives you can test using the audit firm's new generalized audit software package. Your manager is particularly worried about the possible negative effects on the collectibility of accounts receivable because of the American financial crisis, the rising dollar, and the slowing Canadian economy.

Solutions

Expert Solution

Answer:

The audit program to test Coppero Engineering’s year-end accounts receivable would include the following:

  • Perform analytical procedures such as comparing current and previous year’s balances and seeking expert advice and credit analyses on what impact (if any) the Asian financial crisis and the rising Canadian dollar are likely to have on major customers in Asia.
  • Confirm accounts receivable balances by mail, with concentration on the 30% of customers with 70% of the dollar value balances.
  • Where necessary, undertake alternative follow-up procedures, to ensure payment has subsequently been received.
  • In relation to the adequacy of doubtful debts, examine evidence of collectability of accounts receivable, by reference to evidence such as the ageing of the accounts receivable, correspondence with customers, credit checks and discussions with the client’s credit manager.
  • Specific audit objectives that can be tested using the audit firm’s generalized audit software include:
  • Ensuring the totals on the accounts receivable master file agree with the accounts receivable control account in the general ledger
  • Extracting a complete listing of accounts receivable balances at year end
  • Ensuring the master file is made up of complete and accurate customer records through identifying and printing out listings of customer; records where information in the record is invalid or absent
  • Determining whether the aging of the customer’s accounts receivable has been correctly entered onto master file, which would require cross adding the file to ensure the individual aged amounts agree with the total amount owing
  • Determining whether the internal control procedure in relation to credit control has been correctly followed by identifying those customers who have exceeded their credit rating limits
  • Determining whether the client’s allowance for doubtful debts is adequate by identifying those records with long outstanding balances.

Related Solutions

You have been assigned to the audit or Grain Crops Ltd (Grain Crops), a company that...
You have been assigned to the audit or Grain Crops Ltd (Grain Crops), a company that produces wheat, flour, yeast and other baker products. As with many other businesses, Grain Crops has been finding it extremely difficult to recruit and retain skilled factory staff. As a result, Grain Crops decided that staff in the most difficult-to-retain award categories will be rewarded with annual bonuses. These are calculated using a relatively complex formula that takes into account the employee’s length of...
You have been assigned to audit the work-in-process accounts of a manufacturing firm. What are examples...
You have been assigned to audit the work-in-process accounts of a manufacturing firm. What are examples of how you can use machine learning to assist with your validation of balances?
You are audit senior at Bernstein and Griffiths and have been assigned to the audit of...
You are audit senior at Bernstein and Griffiths and have been assigned to the audit of Stockman Ltd (Stockman) for the current year. Stockman manufactures, wholesales and retails Australian outback clothing for sale both in Australia and overseas. During the planning stage of the audit, you have identified the following three key internal controls over the functioning of Stockman’s online inventory management system: Internal control 1 – the system will not allow a customer to place an order for an...
3. Planning a Performance Audit - You have been assigned to a performance audit of a...
3. Planning a Performance Audit - You have been assigned to a performance audit of a local government, focused on compliance with requirements for state grant funds. Assume that you are just beginning to plan your audit. Considering guidance in the GAO’s Yellow Book, summarize some of the most important steps you should take in this Planning phase of your audit.
You are completing analytical procedures (ratios) for the audit of sales and accounts receivable. Identify 3...
You are completing analytical procedures (ratios) for the audit of sales and accounts receivable. Identify 3 ratios and their trend (increased/decreased) which may indicate that net sales and/or net accounts receivable may be overstated. Explain. Item Ratio Increased/decreased - Explain 1 2 3 What are the effects of overstating ending inventory on Cost of Sales, and Profit (understate/overstate)?  Explain. Effect on Cost of Sales Effect on Profit
You have been recently assigned as the manager for the audit of Layton Co, a software...
You have been recently assigned as the manager for the audit of Layton Co, a software engineering company whose securities are publicly traded. You are filling in for your colleague, Luke Paolo, who has taken a sick leave at short notice. The company's audit for the financial year ended 30 June 20Y0 is nearing completion and its draft financial statements recognize a profit before tax of $65.4 million and total assets of $27.9 million. You are in the midst of...
Auditing the Revenue Process You have been assigned to the first audit of the Black Clover...
Auditing the Revenue Process You have been assigned to the first audit of the Black Clover company for the year ending March 31, 2019. Accounts receivable were confirmed on December 31, 2018, and at that date, the receivables consisted of approximately 200 accounts with balances totaling $956,750. Fifty of these accounts, with balances totaling $650,725, were selected for confirmation. All but 10 of the confirmation requests have been returned; 24 were returned without any exceptions, 6 had minor differences that...
You and your colleagues have been assigned to the audit of a private company, Rose Pty...
You and your colleagues have been assigned to the audit of a private company, Rose Pty Limited, which operates a plant nursery with a turnover of $6 million a year. The total number of full-time employees working for the company is 16, together with between five to seven casual employees as and when required on weekends. The company is run by a husband and wife team who are the directors and shareholders and a full-time accounts clerk, Sofia, who is...
You have been the partner in charge of the audit DamaiJaya Engineering Berhad for many years....
You have been the partner in charge of the audit DamaiJaya Engineering Berhad for many years. You have never given a qualified audit report because the internal control system of the company is satisfactory, the business in which the company engaged was quite stable and the results of compliance and substantive test indicated that the account balances were fairly stated. In the current year's audit, you assigned a recently recruited member of staff as senior in charge of the job...
You have decided to use positive confirmations as a substantive audit test of accounts receivable. Assume...
You have decided to use positive confirmations as a substantive audit test of accounts receivable. Assume you have selected balances to confirm from your client’s accounts receivable subsidiary ledger at year-end and you have sent letters directly to customers based on these selections. Answer and clearly explain each of the following: A.) What is a positive confirmation? B.) Is this a vouching or tracing test? C.) What will you do if no response is received from a customer? Be specific.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT