Bank reconcilation for Beeler Furniture Company
i need help with the reconciliation statement, below is attached information
Chart of Accounts Labels and Amount Descriptions Bank Reconciliation Instructions 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 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 CASH RECEIPTS FOR MONTH OF JUNE $9,317 40 89,223.76 DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June Date Date Amount Date Amount Amount Instructions CHECKS WRITTEN: Number and amount of each check issued in June: Check No. Amount Amount Check No. 740 Amount $237.50 Void Check No. 754 755 756 495.15 $450.90 741 742 501.90 761.30 $449.75 272.75 113.95 407.95 259.60 901.50 486.39 506.88 640.13 276.77 299.37 537.01 380.95 744 745 746 117.25 298.66 Total amount of checks issued in June: $8,395.66 BANK RECONCILIATION FOR PRECEDING MONTH: ank Reconciliation structions 11 Cash balance according to company's records 12 Deduct service charges $9,352.50 35.10 13 Adjusted balance $9,317.40 UNE BANK STATEMENT: Click here to view Required: 1. Prepare a bank reconciliation as of June 30, 2012. 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 Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries, To enter the Check number, please enter "No." preceeding the number. (Note: "Deduct", "Add", or colons () will automatically appear if required) 2. Journalize the necessary entries. The accounts have not been closed. Refer to the Chart of Accounts for exact wording of II PAGE 11 1 MEMBER FDIC AMERICAN NATIONAL BANK ACCOUNT NUMBER OF CHICAGO FROM 8/01/2012 CHICAGO, IL 60603 (312) 441-1239 BALANCE 9 DEPOSITS 20 WITHDRAWALS BEELER FURNITURE COMPANY 4 OTHER DEBITS AND CREDITS ES NEW BALANCE TO 8/30/20Y2 9,447.20 8,691.77 7 ,899.26 3,086.00CR 13,624.71 --- CHECKS AND OTHER DEBITS ----- DEPOSITS --.-DATE-.-- BALANCE-- No.731 162.18 No.738 348.00 800.286/01 9,629.35 No.73060.58 No.740 237.50 1,000.00 6/02 10,411.80 No.741 496.18 No.942 501.00 884.17 8/04 10,268.92 No.743871.30 - No.744808.88 840.B0 6/09 9,031.24 No.748 117.28 No.746 208.68 M8 3,800.00 6/09 13,018.33 No.748 480.00 No.749 840.13 MS 210.00 6/00 12,134.30 No.750 276.47 No.781 209.39 898.61 8/11 12,484.77 No.752 837.01 No.783 380.98 882.00 6/16 12,419.76 No.784 440.78 No.YBB 272.78 1,608.74 8/18 13,304.00 No. 787 407.98 No.780 486.30 897.34 8/23 13,307.00 942.71 8/26 14,240.91 NSP 350.00 6/28 13,690.71 90 98.00 8/30 13,624.71 BO - ERROR CORRECTION OD-OVERDRAPT MB - MISCELLANEOUS PS - PAYMENT STOPPED NSP - NOT SUPPICIENT FUNDS 8C - SERVICE CHARGE THE RODONCILEMENT OP THIS STATEMENT WITH YOUR RROORDE IS REENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMORDIATELY