In: Accounting
Bank Reconciliation and Entries
The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $14,380. The bank statement indicated a balance of $16,970 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items:
Checks outstanding totaled $6,110.
A deposit of $6,360, representing receipts of June 30, had been made too late to appear on the bank statement.
The bank collected $3,310 on a $3,140 note, including interest of $170.
A check for $770 returned with the statement had been incorrectly recorded by Pala Medical Co. as $700. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account.
A check drawn for $40 had been erroneously charged by the bank as $400.
Bank service charges for June amounted to $40.
Required:
1. Prepare a bank reconciliation.
| Pala Medical Co. | ||
| Bank Reconciliation | ||
| June 30, 20Y1 | ||
| 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 transaction, if an amount box does not require an entry, leave it blank.
| a. 20Y1 June 30 | |||
| b. June 30 | |||
3. If a balance sheet were prepared for Pala
Medical Co. on June 30, 20Y1, what amount should be reported as
cash?
$
| Bank reconciliation | |||
| Bank balance | 16970 | ||
| Add | Deposit in transit | 6360 | |
| Error by bank | 360 | ||
| Total | 23690 | ||
| Less | Outstanding checks | 6110 | |
| Adjusted bank balance | 17580 | ||
| Cash balance | 14380 | ||
| Add | Notes collected | 3140 | |
| Interest revenue | 170 | ||
| 3310 | |||
| Less | Error in recording | 70 | |
| Service charges | 40 | ||
| 110 | |||
| Adjusted cash balance | 17580 | ||
| Journal entry | |||
| Increase in cash | |||
| 1 | Cash | 3310 | |
| Notes receivable | 3140 | ||
| Interest revenue | 170 | ||
| Decrease in cash | |||
| 2 | Accounts payable | 70 | |
| Misc. expense | 40 | ||
| Cash | 110 | ||
| Misc. expense | 144 | ||
| Cash | 144 | ||
| 3 | Cash reported as | 17580 | |