In: Accounting
The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $84,457. The bank statement indicated a balance of $127,190 on June 30, 20Y1. 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 June 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 Pala Medical Co. as $110. The check was for the payment of an obligation to Skyline 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 June 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. "Add:" & "Deduct:" will automatically appear if it is required. For those boxes in which you must enter subtracted or negative numbers use a minus sign. |
2. | Journalize the necessary entries. Refer to the Chart of Accounts for exact wording of account titles. |
3. | If a balance sheet were prepared for Pala Medical Co. on June 30, 20Y1, what amount should be reported as cash? |
Amount Descriptions | |
Adjusted balance | |
Bank error in charging check as $860 instead of $680 | |
Bank service charges | |
Deposit in transit on June 30 | |
Deposit of June 30, not recorded by bank | |
Error in recording check | |
Outstanding checks | |
Note collected by bank, including $1,848 interest | |
Total additions | |
Total deductions |
CHART OF ACCOUNTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pala Medical Co. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
General Ledger | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Pala Medical Co. Bank Reconciliation June 30, 20Y1 |
||
Cash balance according to bank statement | $127,190 | |
Adjustments: | ||
Add : Deposits of june 30 not recorded by bank | $17,610 | |
Add : Bank error in charging check as $860 instead of $680 | $180 | |
less : Checks outstanding | $33,310 | |
Total adjustments | ($15,520) | |
Adjusted balance | $111,670 | |
Cash balance according to company's records | $84,457 | |
Adjustments: | ||
Add: Proceeds of the note collected by Bank including Interest | $28,248 | |
Less : Error in recording
cheques ($1,100 (-) $110) |
($990) | |
Less : Bank service charges | ($45) | |
Total adjustments | $27,213 | |
Adjusted balance | $111,670 |
Answer: Preparation of Journal Entries | |||
Date | General Journal | Debit (in $) | Credit (in $) |
Jun-30 | Cash | $28,248 | |
Notes receivable | $26,400 | ||
Interest revenue | $1,848 | ||
Jun-30 | Accounts Payable | $990 | |
Miscellaneous Expense | $45 | ||
Cash | $1,035 | ||
The amount that will be reported as cash On June 30, 20Y1 the balance sheet would be $111,670 |