Question

The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $97,456. The bank statement indicated a balance of $127,960 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 $30,050.
B.	A deposit of $19,720, representing receipts of June 30, had been made too late to appear on the bank statement.
C.	The bank collected $22,149 on a $20,700 note, including interest of $1,449.
D.	A check for $1,450 returned with the statement had been incorrectly recorded by Pala Medical Co. as $145. 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 $40.

	Instructions
1.	Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. 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?

Answer 1

Solution 1:

Pala Medical Co.
Bank Reconciliation - June 30
Bank's Cash balance		Company's cash balance
Particulars	Amount	Particulars	Amount
Ending balance as per Bank Statements	$127,960.00	Ending Balance as per cash books	$97,456.00
Additions:		Additions:
Outstanding Deposits	$19,720.00	Note collection (Including interest)	$22,149.00
Bank Error	$630.00
Deductions:		Deductions:
Outstanding Checks	$30,050.00	Incorrect recording of check	$1,305.00
		Service Charge	$40.00
Up to date cash balance as per bank	$118,260.00	Up to date cash balance as per books	$118,260.00

Solution 2:

Journal Entries - Pala Medical Co.
Date	Particulars	Debit	Credit
30-Jun	Cash Dr	$22,149.00
	To Note receivables		$20,700.00
	To Interest revenue		$1,449.00
	(To record note collection by bank)
30-Jun	Accounts payable Dr	$1,305.00
	To Cash		$1,305.00
	(To record correction entry for check)
30-Jun	Miscellenaeous expense Dr	$40.00
	To Cash		$40.00
	(Being service charge debited by bank)

Solution 3:

If a balance sheet were prepared for Pala Medical Co. on June 30, 20Y1, amount should be reported as cash = $118,260