Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository her banking hours. The data required to reconclete back statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are painted in capital letters. All checks were written for payments on account CASH ACCOUNT Balance as of June 1 CASH RECEIPTS FOR MONTH OF JUNE 59,317.40 59,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 8996.61 June 22 5897 34 3 854 17 15 88295 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 $237.50 Check No. 747 Amount $449.75 740 Void 754 741 495.15 748 $450.90 755 272.75 742 50190 749 640.13 756 113.95 743 761.30 750 276.77 757 407.95 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 748 495.15 $450.90 755 272.75 742 501.90 749 640.13 756 113.95 743 761.30 750 276.77 407.95 757 744 506.88 259.60 751 299.37 758 745 752 759 117.25 537 01 901.50 746 298.66 486.39 753 380.95 760 Total amount of checks issued in June: $8,395.66 BEELER FURNITURE COMPANY Bank Reconciliation May 2012 1 according to bitement 594070 69035 Adid deposito 31. not recorded by te Deducting ches Na 751 1 5562.15 345.95 N 756 N738 2514 Na 159 6055 2005 5931140 de ce 59357.50 05.10 Cashbanceading to company records sa Deo ank service changes Med balance 59.317.40 Click here to view Required: 1. Prepare a bank reconciliation as of June 30, 2012 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. Al checks are written to satisy accounts payable Be sure to complete the statement heading. Refer to the instructions, Labels and Amount Descriptions ist provided for the exact wording of the answer choice for test entries. To enter the Check number, please enter "No proceeding the number, "Deduct, 'Add or calons() wl automatically appear if required Enter all amounts as positive numbers. Round your answers to two decimal places. 2 Journalize the necessary entries. The accounts have not been closed Refer to the chart of accounts for the exact wording of the accounts CNOW journals do not use lines for journal explanations. Every ine on a journal page is used for debt or credit entries CNOW journals wir automatically indent a credit entry when a credit amount is entered Round your answers to two decimal places. 3. What is the amount of Cash that should appear on the balance sheet June 302 4. Assume that a canceled check for $390 has been incorrectly recorded by the bank as $930 Breny explain how the error would be included in a bank reconciliation and how it should be corrected art of auto PAGE 1 MEMBER FDIC AMERICAN NATIONAL BANK OF CHICAGO ACCOUNT NUMBER FROM 6/01/2012 TO 6/30/2012 CHICAGO, IL 60603 (312) 441-1299 BALANCE 9,447 20 9 DEPOSITS 8,891.77 20 WITHDRAWALS 7,699.26 BEELER FURNITURE COMPANY 4 OTHER DEBITS AND CREDITS 3,086.00CR NEW BALANCE 13,624.71 CHECKS AND OTHER DEBITS ----DEPOSITS -- .- DATE --- -- BALANCE-- No.731 162.15 No.936 346.98 890.25 6/01 9,629.36 No.739 80.66 No. 740 237.50 1,080.50 8/02 10,411.80 No.741 496.16 No.742 601.90 854.17 6/04 10,268.92 No.743 871.30 No.744 606.88 840.50 B/09 9,931.24 No.748 117.26 No.746 298.66 MS 3,500.00 6/09 13,016.33 No.748 450.90 No.749 840.13 MS 210.00 8/09 12, 134.30 No.750 276.77 No.781 299.37 898.61 B/11 12,464.77 No.752 537.01 No.753 380.96 882.96 8/16 12,419.78 No.784 449.75 No.756 272.75 1,606.74 8/18 13,304.00 No.787 407.95 No.780 486.39 897.34 8/23 13,307.00 942.71 6/26 14,249.71 NSP 550.00 8/28 13,699.71 75.00 13,624.71 EC |-- ERROR CORRECTION OD - OVERDRAFT MS - MISCELLANEOUS PS PAYMENT STOPPED NSP NOT SUPPICIENT FUNDS SC - SERVICE CHARGE SC 8/30 --- THE RECONCILEMENT OP THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY. Labels and Amount Descriptions Labels Cash and cash equivalents For the Year Ended June 30, 2012 June 30, 2012 Outstanding checks Amount Descriptions Adjustod balance Bank service charges Check returned because of insuficient funds Depost of June (insert day, not recorded by bank Error in recording Check Noise check lium Error in recording June (innt day deposit Interest Note and interest corected by bank Principal (Check numbers are vald Amount Description Please enter"No proceeding the Check number Shaded cels have feedback BEELER FURNITURE COMPANY Bank Recon June 30, 2012 Score 78/143 Cash balance according to bank statement Add Deposit of June 30, not recorded by bank Deduct: Outstanding checks No.758 1.117.74 3 No 756 525140 Ne: 759 1159 No. 758 90150 Adjusted balance 25960 10 Cash balance according to company's records Add: Note and interest collected by bank 12 15 Deduct: Check returned because of insufficient funds 14 15 1. Bank service charges Ons 3. What is the amount of Cash that should appear on the balance sheet as of June 307 Side Galicia S