In: Accounting
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank Reconciliation For the Month Ended June 30, 20Y7 Cash balance according to bank statement $16,185 Adjustments: Outstanding Check No.1067 $575 Outstanding Check No.1106 470 Outstanding Check No.1110 1,050 Outstanding Check No.1113 910 Deposit of June 30 not recorded by bank (6,600) Total adjustments (3,595) Adjusted balance $12,590 Cash balance according to company’s records $8,985 Adjustments: Proceeds of note collected by bank: Face value $6,000 Proceeds of note collected by bank: Interest 300 Service charges 15 Check returned because of insufficient funds (890) Error in recording June 17 deposit of $7,150 as $1,750 (5,400) Total adjustments 25 Adjusted balance $9,010 a. Identify the errors in the following bank reconciliation: Item Correct Heading Outstanding checks Deposit of June 30 Service charges Error in June 17 deposit Adjusted balance per the bank b. Prepare a corrected bank reconciliation. Poway Co. Bank Reconciliation June 30, 20Y7 Cash balance according to bank statement $ Adjustments: $ Total adjustments Adjusted balance $ Cash balance according to company's records $ Adjustments: $ Total adjustments Adjusted balance $
Bank Reconciliation
The following bank reconciliation was prepared as of June 30, 20Y7:
Poway Co. | |||||
Bank Reconciliation | |||||
For the Month Ended June 30, 20Y7 | |||||
Cash balance according to bank statement | $16,185 | ||||
Adjustments: | |||||
Outstanding Check No.1067 | $575 | ||||
Outstanding Check No.1106 | 470 | ||||
Outstanding Check No.1110 | 1,050 | ||||
Outstanding Check No.1113 | 910 | ||||
Deposit of June 30 not recorded by bank | (6,600) | ||||
Total adjustments | (3,595) | ||||
Adjusted balance | $12,590 | ||||
Cash balance according to company’s records | $8,985 | ||||
Adjustments: | |||||
Proceeds of note collected by bank: Face value | $6,000 | ||||
Proceeds of note collected by bank: Interest | 300 | ||||
Service charges | 15 | ||||
Check returned because of insufficient funds | (890) | ||||
Error in recording June 17 deposit of $7,150 as $1,750 | (5,400) | ||||
Total adjustments | 25 | ||||
Adjusted balance | $9,010 |
a.
Identify the errors in the following bank reconciliation:
Item | Correct |
Heading | |
Outstanding checks | |
Deposit of June 30 | |
Service charges | |
Error in June 17 deposit | |
Adjusted balance per the bank |
b. Prepare a corrected bank reconciliation.
Poway Co. | ||
Bank Reconciliation | ||
June 30, 20Y7 | ||
Cash balance according to bank statement | $ | |
Adjustments: | ||
$ | ||
Total adjustments | ||
Adjusted balance | $ | |
Cash balance according to company's records | $ | |
Adjustments: | ||
$ | ||
Total adjustments | ||
Adjusted balance | $ |
a | Item | Error | |
Heading | June 30, 20Y7 | ||
Outstanding checks | It should be deducted | ||
Deposit of June 30 | It should be Added | ||
Service Charges | It should be deducted | ||
Error in June 17 deposit | It should be Added | ||
Adjusted balance per the bank | $19,780 | ||
b | Poway Co Bank Reconciliation For the month ended june 30, 20Y7 |
||
Cash Balance According to Bank Statement | $16,185 | ||
Adjustments: | |||
Less: Outstanding checks No. 1067 | ($575) | ||
Outstanding checks No. 1106 | ($470) | ||
Outstanding checks No. 1110 | ($1,050) | ||
Outstanding checks No. 1113 | ($910) | ||
Add: Deposit of June 30, not recorded by bank | $6,600 | ||
Total Adjustments | $3,595 | ||
Adjusted Balance per bank | $19,780 | ||
Cash Balance According to Company's records | $8,985 | ||
Adjustments: | |||
Proceeds of note collected by bank - Face Value | $6,000 | ||
Proceeds of note collected by bank - Interest | $300 | ||
Service Charges | ($15) | ||
Check returned because of insufficient funds | ($890) | ||
Error in recording June 17 deposit of $7,150 as $1,750 | $5,400 | ||
Total Adjustments | $10,795 | ||
Adjusted Balance per company's records | $19,780 | ||