A B D E F G H M 2 3 4 5 6 Comparing the May reconciliation, the June checking ledger and the lune bank statement, 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, Journalize the necessary entries in the space provided. What is the amount of cash that should appear on the balance sheet as of June 30. 7 8 9 10 11 12 13 14 15 16 17 18 19 20 > Debit 1,080.50 854.17 1 Account name: Checking 3 Date Vendor/source Purpose 4 1-Jun Beginning balance 5 1-Jun Cash Sales 6 1-Jun Check 740 ABC Company Supplies 7 Check 741 Trinity Roofing repair roof 8 Check 742 Sally Moore Payroll 9 Check 743 Atlanta Journal Advertising 10 3-Jun Cash Sales 11 Check 744 McGarrisons office equipment 12 Check 745 Verizon Telephone 13 Check 746 ABC Company Supplies 14 Check 747 Windstream Internet service 15 Check 748 lacob's Design Shop signs for advertising 16 8-Jun Cash sales 17 Check 749 Sally Moore Payroll 16 Check 750 HMC Electric utilities 19 10-Jun Cash Sales 20 Check 751 Windsor Furniture purchases 21 15-Jun EFT collection from customer payment on account 22 Check 752 Tammy's Design Store design scheme G H Account 1202 Balance Credit Debit Credit 9,317.40 10,397.90 237.50 10.160.40 495.15 9,665.25 501.90 9,163.35 761.30 8,402.05 9,256.22 506.88 8.749.34 117.25 8,632.09 298.66 8,333.43 8,333.43 450.90 7,882.53 8.723.03 540.13 8,082.90 276.77 7.806.13 8,802.74 299.37 8,503.37 9,386.32 53701 8.849.31 840.50 996.61 882.95 AL 1,606.74 897.34 23 Check 753 ABC Company Supplies 24 Check 754. Sally Moore Payroll 25 17-Jun EFT from customer payment on account 26 Check 755 Excess Training professional development 27 Check 756 Hector's meals for meeting 28 22-Jun Cash sales 29 Check 757 Sally Moore Payroll 30 24-Jun EFT collection from customer payment on account 31 Check 758 Allstate Insurance 32 Check 759 ABC Company Supplies 33 Check 760 Sally Moore Payroll 34 30-Jun Cash sales 35 36 37 38 JS.UI 0,0419.31 380.95 8,468.36 449.75 8,018.61 9,625.35 272.75 9,352.60 113.95 9,238.65 10,135.99 407.95 9,728.04 10,675.25 259.60 10.415.65 901.50 9,514.15 486.39 9,027.76 10,145.50 947.21 1.117.74 PAGE 1 ACCOUNT NUMBER AB MEMBER FDIC AMERICAN NATIONAL BANK OF CHICAGO FROM 8/01/2012 TO 6/30/2012 9,44720 CHICAGO, IL 60603 (312) 441-1229 BALANCE 9 DEPOSITS 8,801.77 20 WITHDRAWALS 7,599.26 BEELER FURNITURE COMPANY 4 OTHER DEBITS AND CREDITS 3,088.OOCR NEW BALANCE 13,624.71 --- CHECKS AND OTHER DEBITS ----- DEPOSITS No. 731 182.18 No. 736 348.98 890.26 No. 730 80.88 No. 240 237.50 1,080.50 No. 741 406.18 No. 142 801.90 884.17 No. 743 871.30 No. 744 808.88 840.50 Na 745 117.25 No. 748 298.88 MS 3,500.00 No 748 480.90 No. 240 840.13 MS 210.00 No. 780 278.77 No. 781 299,37 898.81 No. 782 637.01 No. 753 580 98 882.05 No. 764 440.75 No. 788 279.95 1.808.74 No. 787 407.05 No. 780 488.30 89734 94221 NSF 680.00 SO 18.00 -DATE-.-- BALANCE -. 8/01 9,629.38 6/02 10,411.80 8/04 10.288.92 8/09 9,031 24 6/09 13.018.33 8/09 12, 134.30 8/11 12,454.77 6/16 12,410.78 8/18 13,504.00 6/23 13,307.00 8/28 14.240.71 6728 13,899.92 8/30 13,62471 30 MS NSY - PS - ERROR CORRECTION MISCELLANEOUS NOT SUFFICIENT PUNDS Instructions Sheet1 OD-OVERDRAPT PAYMENT STOPPED SC SERVICE CHARGE Checking ledger June Bank state dy Beeler Furniture Company Bank Reconciliation May 31, 20Y2 Cash balance according to bank statement 9,447.20 Adjustments: 690.25 (162.15) (345.95) Deposit for May 31 not recorded by bank Outstanding Check No. 731 7 Outstanding Check No. 736 2 Outstanding Check No. 738 3 Outstanding Check No. 739 4 Total adjustments 5 Adjusted balance (251.40) (60.55) (129.80) 9,317.40 6 9,352.50 7 Cash balance according to company's records 8 Adjustments: 9 Bank service charges 0 Adjusted balance -1 (35.10) 9,317.40
