In: Accounting
Bank Reconciliation and Entries
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.
Required:
1. Prepare a bank reconciliation.
Stone Systems | ||
Bank Reconciliation | ||
July 31, 20Y5 | ||
Cash balance according to bank statement | $ | |
Adjustments: | ||
$ | ||
Total adjustments | ||
Adjusted balance | $ | |
Cash balance according to company's records | $ | |
Adjustments: | ||
$ | ||
Total adjustments | ||
Adjusted balance | $ |
2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. For a compound entry, if an amount box does not require an entry, leave it blank.
20Y5 July 31 | |||
July 31 | |||
3. If a balance sheet were prepared for Stone
Systems on July 31, 20Y5, what amount should be reported as
cash?
$
Part 1 | Stone Systems | |||||||
Bank reconciliation | ||||||||
July 31 20Y5 | ||||||||
Cash balance per bank statement | 33,650 | |||||||
Add : Deposit not yet recorded | 9,150 | |||||||
42,800 | ||||||||
Deduct : Outstanding checks | 17,865 | |||||||
Deduct : Bank error (1,810-1,180) | 630 | 18,495 | ||||||
Adjusted balance | 24,305 | |||||||
Cash balance per books | 17,750 | |||||||
Add : Proceeds of note collected by bank | 6,095 | |||||||
Add : Error in recording check (930-390) | 540 | 6,635 | ||||||
24,385 | ||||||||
Deduct : Bank service charge | 80 | |||||||
Adjusted balance | 24,305 | |||||||
Part 2 | Stone Systems | |||||||
Date | General Journal | Debit ($) | Credit ($) | |||||
July 31 20Y5 | Cash | 6,635 | ||||||
Notes Receivable | 5,750 | |||||||
Accounts Payable - Holland Co | 540 | |||||||
Interest revenue (6,095-5,750) | 345 | |||||||
July 31 20Y5 | Miscellaneous Expense | 80 | ||||||
Cash | 80 | |||||||
Part 3 | If a balance sheet were prepared for Stone Systems on July 31, 20Y5, $24,305 should be reported as cash. |