Question

In: Accounting

Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...

Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $22,130. Cash balance according to the bank statement at July 31, $23,520. Checks outstanding, $4,490. Deposit in transit, not recorded by bank, $3,610. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $30. a. Prepare a bank reconciliation, using the format shown in Exhibit 14. Mathers Co. Bank Reconciliation July 31 Cash balance according to bank statement $ 23,520 -4,490 3,610 Adjusted balance $ Cash balance according to company's records $ Adjusted balance $ b. If the balance sheet is prepared for Mathers Co. on July 31, what amount should be reported for cash? $ c. Must a bank reconciliation always balance (reconcile)?

Solutions

Expert Solution

Solution:
a. Mathers Co
Bank Reconciliation
July 31
Cash balance according to bank statement $23,520
Deduct: Checks outstanding ($4,490)
Add :Deposit in transit, not recorded by bank $3,610
Adjusted balance $22,640
Cash balance according to company's records $22,130
Deduct: Bank service charges ($30)
Add : error of check recording $540
Adjusted balance $22,640
Working Notes:
Mathers Co
Bank Reconciliation
July 31
Cash balance according to bank statement $23,520 a
Deduct: Checks outstanding ($4,490) b
[deducted since it is already deducted in cash book as it is outstanding it is not deducted in bank balance ]
Add :Deposit in transit, not recorded by bank $3,610 c
[ Added since it is already added in cash book as it is deposit in transit it is not reflected in bank balance ]
Adjusted balance $22,640 d=a-b+c
Cash balance according to company's records $22,130 e
Deduct: Bank service charges ($30) f
[deducted since it is already charged in bank statement & not deducted in cash book ]
Add : error of check recording $540 g
[payment check of $170 is recorded as $710 means cash book is over charged by ($710 - $170 =$540) , hence added back]
Adjusted balance $22,640 h=e-f+g
b. $22,640 should be reported as cash balance in balance sheet for Mathers Co. on July 31 as calculated in above bank reconciliation
Notes: Bank reconciliation helps to know the true cash of firm as it adjust all the mis matching of payments & cash deposit and other cash & bank account error of book keeping
c. Yes, a bank reconciliation must always balance (reconcile) to an adjusted balance.
Notes: Yes, a bank reconciliation must always balance (reconcile) to an adjusted balance.
If not , there is chances of error in books of accounts or fraud done by employee of the firm
Please feel free to ask if anything about above solution in comment section of the question.

Related Solutions

Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $20,300. Cash balance according to the bank statement at August 31, $21,600. Checks outstanding, $4,120. Deposit in transit, not recorded by bank, $3,310. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $50. a....
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $20,180. Cash balance according to the bank statement at August 31, $21,020. Checks outstanding, $4,100. Deposit in transit, not recorded by bank, $3,290. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $60. a....
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $14,900. Cash balance according to the bank statement at August 31, $15,900. Checks outstanding, $3,020. Deposit in transit, not recorded by bank, $2,430. A check for $270 in payment of an account was erroneously recorded in the check register as $720. Bank debit memo for service charges, $40. a....
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea...
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea Company: Balance per bank $ 17,300 Balance per company records 8,170 Bank service charges 20 Deposit in transit 3,050 Note collected by bank with $150 interest 4,750 Outstanding checks 7,450 a. What is the adjusted balance on the bank reconciliation? $ b. Journalize any necessary entries for Azalea Company based on the bank reconciliation. If an amount box does not require an entry, leave...
The following data were accumulated for use in reconciling the bank account of Creative Design Co....
The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: 1. Cash balance according to the company’s records at August 31, $20,014. 2. Cash balance according to the bank statement at August 31, $28,514. 3. Checks outstanding, $14,232. 4. Deposit in transit, not recorded by bank, $6,214. 5. A check for $55 in payment of an account was erroneously recorded in the check register as $550. 6. Bank debit memo for...
Chapter 7 ex 07-18 The following data were accumulated for use in reconciling the bank account...
Chapter 7 ex 07-18 The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: 1. Cash balance according to the company’s records at August 31, $24,556. 2. Cash balance according to the bank statement at August 31, $31,856. 3. Checks outstanding, $13,280. 4. Deposit in transit, not recorded by bank, $6,392. 5. A check for $48 in payment of an account was erroneously recorded in the check register as $480. 6....
Which of the following is a reconciling item on the bank side of a bank reconciliation?...
Which of the following is a reconciling item on the bank side of a bank reconciliation? 1. Cancelled cheques 2. Outstanding cheques 3. both outstanding cheques and NSF cheques 4. NSF cheques A cheque returned by a bank because the issuer's cash account balance could not cover the cheque is called: 1. a blank cheque 2. a certified cheque 3. a NSF cheque 4. an outstanding cheque On 1 January, Bochao Properties establishes a petty cash fund for $200. On...
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance...
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance before reconciliation                           $23,000 Note receivable collected by bank                                 7,500 Outstanding checks                                                     15,000 Deposits in transit                                                          8,000 Bank service charge                                                          100 NSF check                                                                        1,800 Determine the cash balance per books (before adjustments) for Kreiger. 2. Kendall Corporation had a 1/1/19 balance in the Allowance for Doubtful Accounts of $18,000. During 2019, it wrote off $11,500 of accounts and collected...
Gunnar Company gathered the following reconciling information in preparing its September bank reconciliation. Calculate the adjusted...
Gunnar Company gathered the following reconciling information in preparing its September bank reconciliation. Calculate the adjusted cash balance per books on September 30. Cash balance per books, September 30 $ 3,181 Deposits in transit 421 Notes receivable and interest collected by bank 888 Bank charge for check printing 29 Outstanding checks 1,347 NSF check 144 a.$2,970 b.$3,896 c.$2,255 d.$3,114 Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance...
Derek Company gathered the following reconciling information in preparing its September bank reconciliation: Cash balance per...
Derek Company gathered the following reconciling information in preparing its September bank reconciliation: Cash balance per books, 9/30 $2,190 Deposits in transit 572 Notes receivable and interstate's collected by bank. 879 Bank charge for check printing   29 Outstanding checks 1,322 NSF 178 Find the adjusted cash balance per books on September 30. Select the correct answer. $2,862 $2,112 $1,440 $2,290
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT