Beeler Furniture 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,20$Y$2,$ 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 account.

CASH ACCOUNT:

Balance as of June $1$ $$9,317\mathrm{.}40$

CASH RECEIPTS FOR MONTH OF JUNE $9,223\mathrm{.}76$

DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June:

Date

Amount

Date

Amount

Date

Amount

June $1$ $$1,080\mathrm{.}50$ June $10$ $$996\mathrm{.}61$ June $22$ $$897\mathrm{.}34$

$3854\mathrm{.}1715882\mathrm{.}9524947\mathrm{.}21$

$8840\mathrm{.}50171,606\mathrm{.}74301,117\mathrm{.}74$

CHECKS WRITTEN: Number and amount of each check issued in June:

Check No$.$

Amount

Check No$.$

Amount

Check No$.$

Amount

$740$ $$237\mathrm{.}50747$ Void $754$ $$449\mathrm{.}75$

$741495\mathrm{.}15748$ $$450\mathrm{.}90755272\mathrm{.}75$

$742501\mathrm{.}90749640\mathrm{.}13756113\mathrm{.}95$

$743761\mathrm{.}30750276\mathrm{.}77757407\mathrm{.}95$

$744506\mathrm{.}88751299\mathrm{.}37758259\mathrm{.}60$

$745117\mathrm{.}25752537\mathrm{.}01759901\mathrm{.}50$

$746298\mathrm{.}66753380\mathrm{.}95760486\mathrm{.}39$

Total amount of checks issued in June: $$8,395\mathrm{.}66$

BANK RECONCILIATION FOR PRECEDING MONTH:

Beeler Furniture Company

Bank Reconciliation

May $31,20$Y$2$

$1$

Cash balance according to bank statement

$$9,447\mathrm{.}20$

$2$

Add: Deposit in transit on May $31$

$690\mathrm{.}25$

$3$

Deduct: Outstanding Check No$.731$

$$162\mathrm{.}15$

$4$

Outstanding Check No$.736$

$345\mathrm{.}95$

$5$

Outstanding Check No$.738$

$251\mathrm{.}40$

$6$

Outstanding Check No$.739$

$60\mathrm{.}55$

$7$

Total deductions

$(820\mathrm{.}05)$

$8$

Adjusted balance

$$9,317\mathrm{.}40$

$9$

$10$

Cash balance according to company$$s records

$$9,352\mathrm{.}50$

$11$

Deduct: Bank service charges

$(35\mathrm{.}10)$

$12$

Adjusted balance

$$9,317\mathrm{.}40$

Prepare a bank reconciliation as of June $30,20$Y$2.$ If errors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales. All checks are written to satisfy accounts payable.