In: Accounting
The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $89,775. The bank statement indicated a balance of $125,160 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 $31,540. |
b. | A deposit of $18,000, representing receipts of June 30, had been made too late to appear on the bank statement. |
c. | The bank collected $24,075 on a $22,500 note, including interest of $1,575. |
d. | A check for $1,700 returned with the statement had been incorrectly recorded by Pala Medical Co. as $170. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account. |
e. | A check drawn for $290 had been erroneously charged by the bank as $920. |
f. | Bank service charges for June amounted to $70. |
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? |
CHART OF ACCOUNTS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Pala Medical Co. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
General Ledger | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Amount Descriptions | |
Adjusted balance | |
Bank error in charging check as $920 instead of $290 | |
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,575 interest | |
Total additions | |
Total deductions |
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.
Pala Medical Co. |
Bank Reconciliation |
June 30, 20Y1 |
1 |
Cash balance according to bank statement |
||
2 |
|||
3 |
|||
4 |
|||
5 |
|||
6 |
|||
7 |
|||
8 |
Cash balance according to company’s records |
||
9 |
|||
10 |
|||
11 |
|||
12 |
|||
13 |
2. Journalize the necessary entries. Refer to the Chart of Accounts for exact wording of account titles.
PAGE 1
JOURNAL
ACCOUNTING EQUATION
DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT | ASSETS | LIABILITIES | EQUITY | |
---|---|---|---|---|---|---|---|---|
1 |
||||||||
2 |
||||||||
3 |
||||||||
4 |
||||||||
5 |
||||||||
6 |
Pala Medical Co. Bank Reconciliation June 30, 20Y1 |
||
Cash balance according to bank statement | $ 125,160 | |
Adjustments: | ||
Additions : | ||
Deposit of June 30, not recorded by bank | $ 18,000 | |
Bank error in charging check as $ 920 instead of $ 290 | $ 630 | |
Deductions : | ||
Outstanding checks | ($ 31,540 ) | |
Total Adjustments | ($ 12,910) | |
Adjusted balance | $ 112,250 | |
Cash balance according to company's records : | $ 89,775 | |
Adjustments: | ||
Additions : | ||
Proceeds of note collected by bank, including $170 interest | $ 24,075 | |
Deductions : | ||
Error in recording check ( $ 1,700 (-) $ 170 ) |
($ 1,530) | |
Bank service charges | ($ 70) | |
Total Adjustments | $ 22,475 | |
Adjusted balance | $ 112,250 |
Date | Account Titles and Explanation | Debit | Credit |
Jun-30 | Cash | $ 24,075 | |
Notes Receivable | $ 22,500 | ||
Interest Revenue | $ 1,575 | ||
(To record the Note ) | |||
Jun-30 | Accounts Payable - Skyline Supply Co. | $ 1,530 | |
Miscellaneous Expense | $ 70 | ||
Cash | $ 1,600 |
3) | |
Amount reported as Cash = | $ 112,250 |