Question

In: Accounting

Background Information Note the following: Acme Corporation is a publicly listed company ACME’s Fiscal year end...

Background Information Note the following:

  • Acme Corporation is a publicly listed company

  • ACME’s Fiscal year end is December 31

  • In addition to the cash account being reconcile here; ACME has a separate Revolving Credit account.

    This is a revolving credit facility where interest is accrued on the average balance outstanding during the month. The interest amount is required to be paid on a monthly basis. The correct is amount calculated and taken from the account automatically by the bank.

  • The facility has an annual interest rate of 4%

  • Management has set-out in the Financial Statements that the average balance outstanding in this

    revolving credit facility is normally at around $ 150,000.

  • The Audit Committee has also informed the Partner that the CRA audited ACME in the previous year

    and levied a penalty of $50,000 and has informed the Board that they plan continue their audit in the new year.

    Required

    Part 1

  1. a) From the information provided in EXHIBIT A, perform and document a Bank Reconciliation. - 20 marks

  2. b) From the Background info. provided above, identify potential errors and disclosure requirements - 5 marks

Part 2

  1. a) Identify the financial assertions relating to the Cash account addressed by the Bank Reconciliation and explain how. – 5 marks

  2. b) Identify what type of activity the Bank Reconciliation is. – 5 marks

  3. c) Identify the 6 possible characteristics (of the activity above) and which apply to the Bank Rec. – 5 marks

BONUS
How would the Auditor test the identified characteristics. – 4 marks

EXHIBIT A

ABC Bank Statement Exerpt for Acme Corporartion Bank Account

for December 201X

Date

Description

Cash Out

Cash In

Balance

January 7, 2021

Cheque 1415

$ 2,500.00

$ 103,390.00

January 6, 2021

Cheque 1416

$ 3,000.00

$ 105,890.00

January 5, 2021

Cheque 1414

$ 2,000.00

$ 108,890.00

January 4, 2021

$ 110,890.00

January 3, 2021

EFT

$ 7,500.00

$ 110,890.00

January 2, 2021

EFT

$ 6,000.00

$ 118,390.00

January 1, 2021

Foreign Wire

$ 5,250.00

$ 124,390.00

December 31, 2020

Loan Interest - Dec.

$ 1,500.00

$ 119,140.00

December 30, 2020

Bank Charges - Dec.

$ 250.00

$ 120,640.00

December 29, 2020

Returned Cheque 1412

$ 500.00

$ 120,890.00

December 28, 2020

Cheque 1413

$ 1,500.00

$ 120,390.00

December 27, 2020

CRA Appropriation

$ 50,000.00

$ 121,890.00

December 26, 2020

Cheque 1412

$ 500.00

$ 171,890.00

December 25, 2020

$ 172,390.00

December 24, 2020

$ 172,390.00

$ 74,750.00

$ 5,750.00

$ 172,390.00

Acme Corporation

General Ledger Cash Account Excerpt

Date

Transaction Detail

Type

Debit

Credit

GL Acct. Balance

January 7, 2021

$ 103,390.00

January 6, 2021

Payment to Supplier #11

Cheque 1418

$ 103,390.00

January 5, 2021

Payment to Supplier #12

Cheque 1417

$ 103,390.00

January 4, 2021

Loan Interest - Re: Dec.

Taken by Bank

$ 1,500.00

$ 103,390.00

January 3, 2021

CRA Appropriation

Taken by CRA

$ 50,000.00

$ 104,890.00

January 2, 2021

Returned Cheque (Supplier Account Closed)

Cheque 1412

$ 500.00

$ 154,890.00

January 1, 2021

Bank Charges - Re: Dec.

Taken by Bank

$ 250.00

$ 154,390.00

December 31, 2020

Payment to Supplier #4

EFT

$ 6,000.00

$ 154,640.00

December 30, 2020

Payment to Supplier #5

Cheque 1416

$ 3,000.00

$ 160,640.00

December 29, 2020

Payment to Supplier #1

EFT

$ 7,500.00

$ 163,640.00

December 28, 2020

Payment to Supplier #2

Cheque 1415

$ 2,500.00

$ 171,140.00

December 27, 2020

Receipt from Customer B

Foreign Wire

$ 5,250.00

$ 173,640.00

December 26, 2020

Receipt from Customer A

Cheque 1414

$ 2,000.00

$ 168,390.00

December 25, 2020

Payment to Supplier #2

Cheque 1413

$ 1,500.00

$ 170,390.00

December 24, 2020

Payment to Supplier #3

Cheque 1412

$ 500.00

$ 171,890.00

$ 5,750.00

$ 74,750.00

$ 172,390.00

Solutions

Expert Solution

Part 1

Answer to Part (a)

In the given question, The Bank statement provided by the bank and the general cash ledger of the Acme Corporation is already tallying with each other. Therefore there is no need of performing Bank Reconciliation Statement.

Answer to Part (b)

Detecting errors: A bank reconciliation helps you in spotting accounting errors which are common to every business. These mistakes include errors such as addition and subtraction, missed payments and double payments.

Tracking Interest and Fee: Banks might add interest payments, fees or penalties on your account. Monthly bank reconciliation allows you to add or subtract such amounts in your books.

Detecting Fraud: You may not be able to prevent employees from stealing your money once, however, you could prevent it in future. Bank reconciliations statement helps you in detecting and spotting fraudulent transactions. It is advisable to employ an independent person to perform the reconciliations for preventing the accounting employee from falsifying your books and reconciliations.

Tracking Receivables: BRS allows you to confirm all your receipts, assisting you to avoid awkward situations and also identifying entries for receipts which you didn’t deposit.

Part-B

Answer to Part (b)

Businesses maintain cash book to record both the cash as well as bank transactions. A Cashbook has a cash column which shows cash available with the business and a bank column which shows cash at bank.
Bank also keeps an account for every customer in their books. All the deposits are recorded on credit side of customer’s account and withdrawals are on the debit side of their account. An account statement is sent regularly to the customers by the bank.

Sometimes the bank balances as per cash book and bank statement doesn’t match. In case balance available in the passbook doesn’t match the bank column of the cash book, the business should identify the reasons for the same. It is important to reconcile the differences.

For reconciling the balances as shown in the Cash Book and passbook a reconciliation statement is prepared known as Bank Reconciliation Statement or BRS. In other words, BRS is a statement which is prepared for reconciling the difference between balances as per cash book’s bank column and passbook on a given date.

It‘s not compulsory to prepare a BRS and there’s no fixed date for preparing BRS. BRS is prepared on a periodical basis for checking that bank related transactions are recorded properly in cash book’s bank column and also by the bank in their books. BRS helps to detect errors in recording transactions and determining the exact bank balance as on a specified date.

Answer to Part (c)

1. Firstly, it’s essential to have all the required documentation and information in hand. That means, if all the required documentation and information are at your disposal you get a better view of things.

2. Avoiding common errors, such as:

a. Error relating to duplication of entries.

b. Not accounting for a transaction that would cause a difference equal to the missed amount

c. Errors while entering commas and dots, which cause discrepancies that, could be of significant value. For instance, instead of entering INR 2,401.30, entering INR 240.13.

d. Transposition errors while entering figures in the books. For instance, instead of entering INR 221,200, entering INR 212,200.

3. Banks can make mistakes too: It is possible that your bank might have committed a mistake. They might debit incorrect amounts from your account, or credit deposits which doesn’t belong to you. For this reason, in case you find errors for which you don’t find any explanations, or for which you’re in doubt, the best thing is to consult your bank.

4. Reconciling items: Listing differences and reconciling them and then forgetting it is possible. In case differences keep on accumulating with no action taken, your bank reconciliation would become meaningless. It is needed that a constant check is kept on the reconciled transactions so that they are reflected in the right way in the bank column of the cash book and in the bank statement.

5. Normally it is prepared on closing date of accounts, i.e., Dec. 31st. Jan. 31 March 31.

6. Sometimes it is prepared at the end of the every month after preparing Cash Book or regularly after certain interval to check the accuracy of Cash Book.


Related Solutions

Tesla Corporation is a publicly-traded company that has a December 31st year-end. For the 2015 fiscal...
Tesla Corporation is a publicly-traded company that has a December 31st year-end. For the 2015 fiscal year, there were 500,000 common shares outstanding all year. Net income for the year ended December 31, 2015, was $800,000. The company’s income tax rate is 30%. During 2014, the company issued a $6,000,000, 10% convertible bond at par. Each 2,000 bond is convertible into 10 common shares. No bonds have been converted as of December 31st, 2015. Also during 2014, Spade issued 200,000,...
Acme Corporation uses the calendar year as their fiscal year for reporting purposes. Acme Corporation is...
Acme Corporation uses the calendar year as their fiscal year for reporting purposes. Acme Corporation is owned 100% by Jesse Smith.   Jesse Smith is quite wealthy - he has over $3 million in a personal savings account which is currently earning 2 one hundredths of 1% interest (or .0002 rate resulting in $600 per year). He also has many other investments. Acme Corporation has $300,000 of current assets. Acme has Accounts Payable of $40,000 and various Payroll liabilities totaling $109,000....
Acme Corporation uses the calendar year as their fiscal year for reporting purposes. Acme Corporation is...
Acme Corporation uses the calendar year as their fiscal year for reporting purposes. Acme Corporation is owned 100% by Jesse Smith. Jesse Smith is quite wealthy - he has over $3 million in a personal savings account which is currently earning 2 one hundredths of 1% interest (or .0002 rate resulting in $600 per year). He also has many other investments. Acme Corporation has $300,000 of current assets. Acme has Accounts Payable of $40,000 and various Payroll liabilities totaling $109,000....
Acme Corporation uses the calendar year as their fiscal year for reporting purposes. Acme Corporation is...
Acme Corporation uses the calendar year as their fiscal year for reporting purposes. Acme Corporation is owned 100% by Jesse Smith. Jesse Smith is quite wealthy - he has over $3 million in a personal savings account which is currently earning 2 one hundredths of 1% interest (or .0002 rate resulting in $600 per year). He also has many other investments. Acme Corporation has $300,000 of current assets. Acme has Accounts Payable of $40,000 and various Payroll liabilities totaling $109,000....
The Foxboro Manufacturing Company provided you with the following information for the fiscal year end December...
The Foxboro Manufacturing Company provided you with the following information for the fiscal year end December 31 Work-in-process inventory, 12/31 57,900 Finished goods inventory, 1/1 307,400 Direct labor costs incurred 1,004,300 Manufacturing overhead costs 2,693,400 Direct materials inventory, 1/1 250,800 Finished goods inventory, 12/31 511,000 Direct materials purchased 1,750,200 Work-in-process inventory, 1/1 101,000 Direct materials inventory, 12/31 169,400 A) Compute the total manufacturing costs incurred during the year. B) Compute the total work-in-process during the year. C) Compute cost of...
The following December 31, 2021, fiscal year-end account balance information is available for the Stonebridge Corporation:...
The following December 31, 2021, fiscal year-end account balance information is available for the Stonebridge Corporation: Cash and cash equivalents $ 5,300 Accounts receivable (net) 23,000 Inventory 63,000 Property, plant, and equipment (net) 135,000 Accounts payable 42,000 Salaries payable 14,000 Paid-in capital 115,000 The only asset not listed is short-term investments. The only liabilities not listed are $33,000 notes payable due in two years and related accrued interest of $1,000 due in four months. The current ratio at year-end is...
The following December 31, 2021, fiscal year-end account balance information is available for the Stonebridge Corporation:...
The following December 31, 2021, fiscal year-end account balance information is available for the Stonebridge Corporation: Cash and cash equivalents $ 6,800 Accounts receivable (net) 38,000 Inventory 78,000 Property, plant, and equipment (net) 210,000 Accounts payable 57,000 Salaries payable 18,000 Paid-in capital 190,000 The only asset not listed is short-term investments. The only liabilities not listed are $48,000 notes payable due in two years and related accrued interest of $1,000 due in four months. The current ratio at year-end is...
Assume Acme Corporation is a typical monopoly: Construct a graph illustrating Acme’s average and marginal cost...
Assume Acme Corporation is a typical monopoly: Construct a graph illustrating Acme’s average and marginal cost curves and the demand curve facing it. Identify profit maximizing output and price, total revenues, total costs, and total profits.
Assume Acme Corporation is a typical monopoly: Construct a graph illustrating Acme’s average and marginal cost...
Assume Acme Corporation is a typical monopoly: Construct a graph illustrating Acme’s average and marginal cost curves and the demand curve facing it. Identify profit maximizing output and price, total revenues, total costs, and total profits. Assume the economy moves into a recession and the demand for Acme’s product falls. On the same graph, show the effect of the recession on equilibrium price, output, and profits. Your response should be one graph and an explanation for the graph.
Following is information provided about Acme United Company (and note the flow of time, from left...
Following is information provided about Acme United Company (and note the flow of time, from left to right):   12/31/17           12/31/18             Cash $   2,000 $ 4,000             Accounts receivable                                            10,000             18,000             Machinery 100,000           120,000             Accumulated depreciation (40,000)           (45,000)             Total Assets                                                     $ 72,000           $ 97,000             Accounts payable                                            $   3,000           $   1,000             Income taxes payable                                          15,000               3,000             Finance leases                                                     20,000             30,000             Common stock                                                      1,000             10,000             Retained earnings                                                33,000             53,000             Total liabilities and equity    ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT