Beeler Funiture Company deposits all cash receipts each Wedn

Beeler Funiture Company deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours The data required to reconcile the bank statement as of June 30 have been taken from various documents and records and are reproduced as follows.The sources of the data are printed in capital letters. All checks were written for payments on CASH ACCOUNT Balance as of June 1 CASH RECEIPTS FOR MONTH OF JUNE $9,317.40 $9,223.76 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June: Date Amount Date Amount June 22 $897.34 24 947.21 30 1,117.74 Date June 1 $1,080.50 3 854.17 8 840.50 Amount June 10 $996.61 15 882.95 17 1,606.74 CHECKS WRITTEN: Number and amount of each check issued in June: Check No. Amount Check No. Amount Check No. Amount 740 $237.50 747 Void 754 $449.75 Check My Work ssignment Score: 43.92% All work saved. Sc F3 FS

Solution

Beeler furniture company

Bank Reconciliation

June 30 2016

Cash balance according to Bank statement		13624.71
Add: deposit of June 30, not recorded by bank		1117.74
		14742.45
Deduct: check no. 738	251.40
Deduct: check no. 756	113.95
Deduct: check no. 758	259.60
Deduct: check no. 759	901.50	1526.45
Adjusted balance		13216.00
Cash balance according to company’s record		10145.50
Add: principal of note collected	3500
Add: interest on note collected	210
Add: error in recording check no. 743	90	3800
		13945.50
Deduct: check returned due to insufficient funds	550
Deduct: error in recording June 10 deposits	100
Deduct: error in recording June 24 deposits	4.5
Deduct: service charges	75	729.50
Adjusted Balance		13216.00