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, 20Y2, 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.40
CASH RECEIPTS FOR MONTH OF JUNE	$9,223.76

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

Date	Amount		Date	Amount		Date	Amount
June 1	$1,080.50		June 10	$996.61		June 22	$897.34
3	854.17		15	882.95		24	947.21
8	840.50		17	1,606.74		30	1,117.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
741	495.15		748	$450.90		755	272.75
742	501.90		749	640.13		756	113.95
743	761.30		750	276.77		757	407.95
744	506.88		751	299.37		758	259.60
745	117.25		752	537.01		759	901.50
746	298.66		753	380.95		760	486.39

Total amount of checks issued in June: $8,395.66

BANK RECONCILIATION FOR PRECEDING MONTH:

Beeler Furniture Company

Bank Reconciliation

May 31, 20Y2

1	Cash balance according to bank statement		$9,447.20
2	Adjustments:
3	Deposit for May 31 not recorded by bank	$690.25
4	Outstanding Check No. 731	(162.15)
5	Outstanding Check No. 736	(345.95)
6	Outstanding Check No. 738	(251.40)
7	Outstanding Check No. 739	(60.55)
8	Total adjustments		(129.80)
9	Adjusted balance		$9,317.40
10
11	Cash balance according to companys records		$9,352.50
12	Adjustments:
13	Bank service charges		(35.10)
14	Adjusted balance		$9,317.40

Refer to the

June Bank Statement

.

1.

Prepare a bank reconciliation as of June 30, 20Y2. 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. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. Round your answers to two decimal places. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

.

So far, this is done. All of the other work is just missing.

Beeler Furniture Company

Bank Reconciliation

June 30, 20Y2

1	Cash balance according to bank statement		13624.71
2	Adjustments:
3	Deposit of June 30, not recorded by bank		1117.74
4	Outstanding Check No. 756		*
5	Outstanding Check No. 759		*
6	Outstanding Check No. 738		*
7	Outstanding Check No. 758		*
8	Total adjustments		*
9	Adjusted balance		*
10
11	Cash balance according to companys records		10145.50
12	Adjustments:
13	Proceeds of note collected by bank: Principal		*
14	Proceeds of note collected by bank: Interest		*
15
16
17
18
19
20
21

JUNE BANK STATEMENT: PAGE 1 MEMBER FDIC AMERICAN NATIONAL BANK OF CHICAGO CHICAGO, IL 60603 (312) 441-1239 AB ACCOUNT NUMBER FROM 6/01/2012 TO 6/30/2012 BALANCE 9,447.20 8,691.7Y 7,699.26 BEELER FURNITURE COMPANY 9 DEPOSITS 20 WITHDRAWALS 4 OTHER DEBITS AND CREDITS NEW BALANCE 3,080.0OCR 13,624.71 +--- CHECKS AND OTHER DEBITS ----- DEPOSITS -- + - DATE --- BALANCE - No. 31 No. 939 No. 741 No. 743 No. 746 No. 748 No. 480 No. 782 No. 754 No. YBY 162.15 60.55 498.15 671.30 114.25 480.90 21Y6.77 537.01 449.95 407.95 No. Y36 No. 740 No. 742 No. 744 No. 746 No. 749 No. 951 No. 183 No. 785 No. 760 346.95 237.50 B01.90 506.88 298.66 640.13 299.37 380.95 272.75 486.39 690.26 6/01 9,629.35 1,080.50 6/02 10,411.80 864.17 6/04 10,268.92 840.80 6/09 9,931.24 MS 3,500.00 8/09 13,018.33 MS 210.00 6/09 12,134.30 896.61 6/11 12,484.YY 882.96 6/16 12,419.76 1,606.74 6/18 13,304.00 897.34 6/23 13,307.00 942.71 6/26 14,249.71 6/28 13,699.71 6/30 13,624.71 OD- OVERDRAFT PS - PAYMENT STOPPED SC - SERVICE CHARGE NSF 650.00 SC 75.00 BO ERROR CORRECTION MS - MISCELLANEOUS NSF - NOT SUFFICIENT FUNDS THE RECONCILEMENT OF THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY