In: Accounting
The cash account for American Medical Co. at April 30 indicated a balance of $84,457. The bank statement indicated a balance of $127,190 on April 30. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items:
A. | Checks outstanding totaled $33,310. |
B. | A deposit of $17,610, representing receipts of April 30, had been made too late to appear on the bank statement. |
C. | The bank collected $28,248 on a $26,400 note, including interest of $1,848. |
D. | A check for $1,100 returned with the statement had been incorrectly recorded by American Medical Co. as $110. The check was for the payment of an obligation to Targhee Supply Co. for a purchase on account. |
E. | A check drawn for $680 had been erroneously charged by the bank as $860. |
F. | Bank service charges for April amounted to $45. |
Instructions | |
1. | Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. “Deduct:” or “Add:” will automatically appear if it is required. |
2. | Journalize the necessary entries. The accounts have not been closed. Refer to the Chart of Accounts for exact wording of account titles. |
3. | If a balance sheet is prepared for American Medical Co. on April 30, what amount should be reported as cash? |
Solution 1:
American medical co. | ||
Bank Reconciliation | ||
Apr-30 | ||
Cash balance according to Bank Statement | $1,27,190.00 | |
Add: Deposit of April 30, not recorded by Bank | $17,610.00 | |
Add: Bank error in charging check as $860 instead of $680 | $180.00 | $17,790.00 |
$1,44,980.00 | ||
Deduct: Outstanding checks | $33,310.00 | |
Adjusted Balance | $1,11,670.00 | |
Cash balance according to Company's books | $84,457.00 | |
Add: Note collected by Bank (Including Interest) | $28,248.00 | |
$1,12,705.00 | ||
Deduct: Company's error in charging check as $110 instead of $1100 | $990.00 | |
Deduct: Bank Service Charges | $45.00 | $1,035.00 |
Adjusted Balance | $1,11,670.00 |
Solution 2:
Journal Entries | ||||
S.No | Date | Particulars | Debit | Credit |
(a) | 30-Apr | Cash Dr | $28,248.00 | |
To Note Receivable | $26,400.00 | |||
To Interest Revenue | $1,848.00 | |||
(To record increase in cash as note collected) | ||||
(b) | 30-Apr | Accounts Payable Dr | $990.00 | |
Bank Service Charges Dr | $45.00 | |||
To Cash | $1,035.00 | |||
(To record decrease in cash) |
Solution 3:
Cash to be reported on April 30 Balance Sheet = $111,670