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."
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:
With this, his reconciliation will be correct.
Hope this answers the question.
Good Luck!
You are the lead auditor performing a walkthrough of the bank reconciliation performed by the com...
Prepare a bank reconciliation at August 31. (List items that increase balance as per bank & books first.) SAGE HILL INC. Bank Reconciliation Announcements CALCULATOR PRINTER VERSION Question 2 Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2017. gives the following information Balance, Augusti $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks deared in August 68,663 Service charge Bank credit memorandum: Balance, August 31 21,162 Interest earned A summary of...
Sage Hill Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,635 Bank debit memorandum: August deposits 71,235 Safety deposit box fee $ 40 Checks cleared in August 68,663 Service charge 65 Bank credit memorandum: Balance, August 31 21,162 Interest earned 60 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,935; receipts $74,235; disbursements $73,555; and balance, August 31, $19,615. Analysis reveals...
I couldn't add on the photo the missing part of Account titles and Explanation Solish Brothers Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information, $50 Balance, August 1 August deposits Checks cleared in August Bank credit memorandum: Interest earned $18,540 Bank debit memorandum 71,140 Safety deposit box foe 68,653 Service charge Balance, August 31 20,972 70 A summary of the Cash account in the ledger for August shows the following: balance, August 1,...
Prepare bank reconciliation and adjusting entries. (LO 3), AP Perth Inc.'s bank statement from Main Street Bank at August 31, 2017, gives the following information. Balance, August 1 $18,400 Bank debit memorandum: August deposits 71,000 Safety deposit box fee $ 25 Checks cleared in August 68,678 Service charge 50 Bank credit memorandum: Balance, August 31 20,692 Interest earned 45 A summary of the Cash account in the ledger for August shows the following: balance, August...
PS 5A Rodrid selected data from Prepare a bank reconciliation and adjusting entries. (L03) Rodriguez Company maintains a checking account at the Imura Bank. At July 31. data from the ledger balance and the bank statement are shown below. Cash in Bank Per Books Per Bank Balance, July 1 $17.600 $15,800 July receipts 81,400 July credits 83,470 July disbursements 77,150 July debits 74,756 Balance, July 31 $21,850 $24,514 Jusis of the bank data reveals that the credits consist of $79,000...
Rodriguez Company maintains a checking account at the Imura Bank. At July 31, selected data from the ledger balance and the bank statement are shown below. Cash in Bank Per Books Per Bank Balance, July 1 $17,770 $15,970 July receipts 81,570 July credits 83,649 July disbursements 77,320 July debits 74,926 Balance, July 31 $22,020 $24,693 Analysis of the bank data reveals that the credits consist of $79,000 of July deposits and a credit memorandum of $4,649 for the collection of...
Shamrock, Inc.'s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,590 Bank debit memorandum: August deposits 71,190 Safety deposit box fee $90 Checks cleared in August 68,613 Service charge 115 Bank credit memorandum: Balance, August 31 21,072 Interest earned 110 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,890; receipts $74,190; disbursements $73,505; and balance, August 31, $19,575. Analysis reveals that the...
Exercise 5-11 Marin Inc.'s bank statement from Main Street Bank at August 31, 2017, gives the following information $ 100 Balance, August 1 August deposits Checks cleared in August Bank credit memorandum: Interest eamed $18,685 Bank debit memorandum: 71,285 Safety deposit box fee 68,603 Service charge Balance, August 31 120 125 21,262 A summary of the Cash account for August shows the following: balance, August 1, $18,985; receipts $74,285; disbursements $73,495; and balance, August 31, $19,775. Analysis reveals that the...
Items a through frepresent the items that an auditor ordinarily would find on a client-prepared bank reconciliation. The accompanying List of Auditing Procedures represents substantive auditing procedures. For each item, select one or more procedures, as indicated, that the auditor most likely would perform to gather evidence in support of that item. The procedures on the list may be selected once, more than once, or not at all. Assume - The client prepared the bank reconciliation on 10/2/X5. • The...
Robert's Company gathered the following reconciling info. in preparing it's May bank reconciliation: Book balance at May 31, $4550, Bank balance at May, 31, $6025, Deposits in transit, not recorded by the bank of $425, Deposit of $650 incorrectly recorded by the as $560, Check #342 for $410 was incorrectly recorded by the company as $140, Outstanding checks of $2220, and NSF check of $140 was returned by the bank to the company. The adjusted cash balance according to the...