Question

In: Accounting

You are the lead auditor performing a walkthrough of the bank reconciliation performed by the company...

You are the lead auditor performing a walkthrough of the bank reconciliation performed by the company controller. What is the design deficiency of the control below ? What additional steps should the Controller perform ?

The Controller says, "I first review the sorted list of returned checks and find which numbers are missing. Second I determine the amount uncleared checks by referring to the cash disbursements journal. If the bank accounts reconcile at that point, the review is done. If it does not reconcile I search for in transit deposits, checks from the beginning outstanding checks list that still have not cleared, other reconciling items and bank errors until it reconciles."

Solutions

Expert Solution

There is a major design deficiency of the control and steps performed buy the controller in reconciling the bank statement.

The Controller says, "I first review the sorted list of returned checks and find which numbers are missing. Second I determine the amount uncleared checks by referring to the cash disbursements journal.”

In simple words the controller first looks for the cheques deposited but not cleared or dishonoured cheques and then looks for the cheques issued by looking on the cash disbursements journal. If cash book and bank statement reconciles at this point, his work is done.

Now such steps may cause a major deficiency as explained by the example below:

Suppose the Cash book balance is 10000/- previous month and Bank Balance is 12000/-

Lets make a bank reconciliation statement

Balance as per Cash book

10000

Cheques issued but not cleared

5000

Cheques deposited but not isssued

-3000

Balance as per Bank Statement

12000

           

Now coming to next month let’s suppose Entity receives Rs 5000/- worth of cheques and issued Rs 5000/- cheques and there is no other entry in Bank. Then Balance of cash book shall be Rs 10000.(10000+5000-5000)

Also assume that previous month cheques are reflecting now in bank statement and from current month the Rs 2000/- worth of cheques are returned and 4000/- worth of cheques issued are not cleared and Cheque printing, service charges and other charges of banks amount to 500/-.Interest credited is also 500/-. Balance in bank statement will reflect 12000/-. (12000+3000-5000+3000-1000-500+500)

As per the design followed by the Controller bank reconciliation shall be prepared as follows:

Balance as per Cash book

10000

Cheques issued but not cleared

4000

Cheques deposited but not isssued

-2000

Balance as per Bank Statement

12000

           

As we can see above balances are reconciled but previous cheques which were reflecting in bank reconciliation statement are not taken into account Bank charges and Interest credited is also not taken. If this design is followed it will result in major inaccuracies and omission of bank transactions in books of accounts.

The steps which should be followed by the controller are:

  1. He should check whether entries appearing in previous month reconciliation are now cleared in the bank statement.
  2. Then He should look for current month cheques dishonoured, issued but not cleared.
  3. He should then look for deposits in transits and make appropriate entry in Bank reconciliation.
  4. Then he should also check the bank statement for any Interest credited and charges debited and make appropriate entries in books of accounts.

With this, his reconciliation will be correct.

Hope this answers the question.

Good Luck!


Related Solutions

Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the...
Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the month of June. It reconciles the bank balance and the book balance to the correct balance. For each of the following items, indicate whether the item is an addition to the bank balance, an addition to the book balance, a deduction from the bank balance, a deduction from the book balance, or would not appear on the June reconciliation. Also, choose Yes or No...
when performing a reconciliation between the bank statement and the cash book, which TWO of the...
when performing a reconciliation between the bank statement and the cash book, which TWO of the following would require an entry in the cash book? a. Deposits credited after date b. Direct debit on bank statement only c. Bank charges d. Bank error
1- Identify 4 of the 6 tests an auditor uses on the bank reconciliation? ( Accounting...
1- Identify 4 of the 6 tests an auditor uses on the bank reconciliation? ( Accounting Auditing)
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31: The balance on the May 31 bank statement is $8,432.11. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31. A comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at May 31: No. 123 $23.40 No. 127 145.00...
Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed:...
Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed: Deposit in transit of $1,100 Outstanding checks no.797 $450 no.804 $890 The reconciled cash balance on March 31 was $11,720 The following bank statement is available for April 2012. Bank Statement TO Sandler Company April 30 Fairbanks, AK FAIRBANKS NATIONAL BANK Date Deposits No. Date Charges Date Balance Apr. 1 $1,100 804 Apr. 2 $890 Mar. 31 $11,960 3 1,680 807 3 730 Apr....
The bank portion of the bank reconciliation for the Fixar Company at January 31,2018 is as...
The bank portion of the bank reconciliation for the Fixar Company at January 31,2018 is as follows:                                                                                        FIXAR COMPANY                                                                                                                                                                                                       Bank Reconciliation                                                                                                                                                                         January 31, 2018                                                                                                                                                                                                                                                                                                                              Cash balance per bank                                                                                                                 $13,581.90                   Add: Deposits in transit                                                                                                                       1,432.80                                                                                                                                                                                       15,014.70 Less:        Outstanding checks                                                    Check Number Check Amount                                                                      3351        $1,089.20                                                                      3370                930.40                                                                      3371                844.50                                                                      3372                734.90                                                                      3374            1,050.00                                                                      3375            1,396.60                                                                                   6,045.60                                                                                                                                Adjusted cash balance per bank                                                                                                             $8,969.10 The...
Bank Reconciliation In-Class Team Case. You received the client prepared bank reconciliation presented below and are...
Bank Reconciliation In-Class Team Case. You received the client prepared bank reconciliation presented below and are auditing Simply Soups Inc’s cash; control risk over cash is assessed at the maximum level. For each item select the one or more procedures she could perform to gather evidence in support of it. Note that since many of the procedures are redundant with one another, they would not all necessarily be included in one particular audit program. For purposes of this problem you...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris Company at August 31, 2017, was as follows: KATSARIS COMPANYBank Reconciliation August 31, 2017 Cash balance per bank $13,229 Add: Deposits in transit 2,350 15,579 Less: Outstanding cheques #4451 $1,740 #4460 549 #4461 723 #4462 1,840 #4464 620 5,472 Adjusted cash balance per bank $10,107 The unadjusted cash balance per books on September 30, 2017, was $10,228. The September bank statement showed the following:...
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
The bank portion of the bank reconciliation for Sheridan Company at November 30, 2020, was as...
The bank portion of the bank reconciliation for Sheridan Company at November 30, 2020, was as follows. Sheridan COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank $14,677.90 Add: Deposits in transit 2,530.20 17,208.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,052.50 6,304.30 Adjusted cash balance per bank $10,903.80 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT