Question

The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items:
Checks outstanding totaled $17,865.
A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement.
The bank had collected $6,095 on a note left for collection. The face of the note was $5,750.
A check for $390 returned with the statement had been incorrectly recorded by Stone Systems as $930. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account.
A check drawn for $1,810 had been incorrectly charged by the bank as $1,180.
Bank service charges for July amounted to $80.

Prepare a bank reconciliation.

Answer 1

Answer:

The bank reconciliation statement is as shown below:

                                                Amount in $

Balance per bank statement     33,650.00  

Deposit in transit                               9,150.00  

Outstanding check                    (17,865.00)

Bank charges                                   80.00  

Note collected                             (6,095.00)

Returned check                                (540.00)

Check drawn                               (630.00)

Book balance                             17,750.00

Explanation:

Deposit in transit has been recorded in the books, thus the addition to the bank balance. Bank charges have been deducted from the bank balance but not in the cash book hence it is added back. Note collected is yet to be recognized in the books hence the deduction from the bank balance.

Amount recorded from the check returned is more than the actual by $540 hence the deduction. The check drawn has been over charged by the bank to the tune of $630 hence the deduction.