Question

On May 31, JB Games Ltd. received its bank statement from the East Coast Savings Bank showing that JB had a balance of $13,100. The company’s general ledger showed a cash balance of $7,925 at that date. A comparison of the bank statement and the accounting records revealed the following information:

1.		A cheque from one of JB’s customers in the amount of $1,280 that had been deposited during the last week of May was returned with the bank statement as NSF.
2.		Bank service charges for the month were $50.
3.		The company had written and mailed out cheques with a value of $4,970 that had not yet cleared the bank.
4.		Cheque #791, which was a payment for advertising expenses of $120, was incorrectly recorded in the general ledger as $210.
5.		During the month, one of JB’s customers paid their account using an electronic funds transfer. Their payment was for $3,045.
6.		The cash receipts for May 31 amounted to $1,600 and had been deposited in the night drop slot at the bank on the evening of May 31. These were not reflected on the bank statement for May. Prepare the bank reconciliation for JB at May 31. (List items that increase balance as per bank & books first.)

Answer 1

Solution:

JB Games Ltd
Bank Reconciliation - May 31
Bank's Cash balance		Company's cash balance
Particulars	Amount	Particulars	Amount
Ending balance as per Bank Statements	$13,100.00	Ending Balance as per cash books	$7,925.00
Additions:		Additions:
Outstanding cash receipt	$1,600.00	Incorrect recording of check no 791 ($210 - $120)	$90.00
		EFT collection by bank	$3,045.00
Deductions:		Deductions:
Outstanding Checks	$4,970.00	NSF Check	$1,280.00
		Service Charge	$50.00
Up to date cash balance as per bank	$9,730.00	Up to date cash balance as per books	$9,730.00