Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository ane banking hours. The data required to reconcile the Dank statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are pointed 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 59,223.76 DUPLICATE DEPOSIT TICKETS Date and amount of each deposit in June Date Amount Date Date Amount Amount $996 61 June 1 $1.080.50 June 10 June 22 589734 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. Check No. Amount Check No. Amount Amount $237.50 740 747 Void 754 $44975 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 CHECKS WRITTEN: Number and amount of each check issued in June Amount Check No. Check No. Amount Amount Check No. 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 407.95 757 744 506.88 751 299.37 758 259.60 745 117.25 901.50 752 537.01 759 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 Recolato Mayat 2012 59.40720 69025 1. Cance according to back statement Adid deposit 5, 31. not recorded by bank Deducting ches Na:751 $167.15 No 736 545.95 2514 6055 Na 59 (2005) 59,31160 tedance 59357.50 (5:10) Gish binding to company records Dextant service changes Musted balance 59,317.40 Click here to 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 satily 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 text entries. To enter the Check number, please enter "No proceeding the number. "Deduct'. Ada or colons () will automatically appear it 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 toe on a journal page is used for debt or crecte 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 5930. Briefly explain how the error would be included in a bank reconciliation and how it should be corrected. art of Anunt MEMBER AMERICAN NATIONAL BANK OF OCAGO CHICAGO, IL- AGE LANCE DO BEELER FURNITURE COMPANY ANDRO W BALANCE CHERCEGE AND OTHESE DATES 11 3489 DO 8/01 730 00.16 10 200 1.000 MO 100110 B010 85417 G4 TO Na 2012 0.00 0.00 11 2000 MS 3.000.00 6.00 ROSE 450.00 3.70 4018 310.00 113.30 750 26.77 3.71 200.37 11 12.6047 07.01 3 S000 12 74 GOLY 1.10074 13.000 40208 09234 15.307.00 04 11 ST 100.00 BE 1907 8.00 5/50 OR CORRECTION ODOVORARE MSME PAYMENT -TOTURUM 30RVICE CARE TERMENT OF TATOVT WORD ATEROR ORIENTE IMMAT Label and Amount Descriptions Labels Cash and cash equivalents For the Year Ended June 30, 2012 June 30, 2012 Outstanding checks Amount Descriptions Adiusted balance Bank service charges Check returned because of insufficient funds Depost of June (insert day. not recorded by bank Error in recording Check Noise check imba) Error in recording June (insert day deposit Interest Note and interest collected by bank Principal (Check numbers are vald Amount Descriptions Please enter 'Wo proceeding the Check number Shaded cats han 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. 738 1.11774 3 No 756 No. 759 525140 11395 20150 7 No. 758 * Adjusted balance 259 60 10 Cash balance according to company's records 1 Add: Note and interest collected by bank 12 15 Deduct: Check returned because of insufficient funds 14 15 1. Bank service charges 17 m your answers to two decimal places NOWJOne do not Credit CNOW on my owner waar Question not attempted JOURNAL WE DATE Score: 0/99 ACK CHI H KEM HATCH OPTION POSTE DEBIT COIT LABLE COUNTY 2 Pats 018 Feedbac #8 - Chpt 8 in dergement Session to progress 08.01 38.02 Final Questions 28.03 What mean the shores of 3.04 $ 05 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,44720 8,691.77 9 DEPOSITS 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 No.731 162.16 No.738 346.98 No.730 80.66 No. 740 237.50 No.741 496.16 No.742 601.90 No.743 871.30 No.744 606.88 No.748 117.26 No.746 298.68 No.748 450.90 No.749 840.13 No.750 276.77 No.781 299.37 No.752 537.01 No.753 380.95 No.784 449.75 No.756 272.75 No.767 407.95 No.780 486.39 -- DEPOSITS ---DATE ---- BALANCE--. 890.25 6/01 9,629.36 1,080.50 8/02 10,411.80 854.17 8/04 10,268.92 840.50 8/09 9,931.24 MS 3,500.00 6/09 13,016.33 MS 210.00 6/09 12,134.30 896.81 8/11 12,484.77 882.98 8/16 12,419.78 1,608.74 6/18 13,304.00 897.34 6/23 13,307.00 942.71 6/26 14,240.71 8/28 13,699.71 8/30 13,624.71 OD - OVERDRAFT PS PAYMENT STOPPED SC - SERVICE CHARGE SC NSP 550.00 75.00 EC - ERROR CORRECTION MS MISCELLANEOUS NSP NOT SUFFICIENT FUNDS - . THE RECONCILEMENT OP THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY. Beeler Furniture Company deposits all cash receipts each Wednesday and Friday in a night depository ane banking hours. The data required to reconcile the Dank statement as of June 30 have been taken from various documents and records and are reproduced as follows. The sources of the data are pointed 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 59,223.76 DUPLICATE DEPOSIT TICKETS Date and amount of each deposit in June Date Amount Date Date Amount Amount $996 61 June 1 $1.080.50 June 10 June 22 589734 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. Check No. Amount Check No. Amount Amount $237.50 740 747 Void 754 $44975 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 CHECKS WRITTEN: Number and amount of each check issued in June Amount Check No. Check No. Amount Amount Check No. 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 407.95 757 744 506.88 751 299.37 758 259.60 745 117.25 901.50 752 537.01 759 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 Recolato Mayat 2012 59.40720 69025 1. Cance according to back statement Adid deposit 5, 31. not recorded by bank Deducting ches Na:751 $167.15 No 736 545.95 2514 6055 Na 59 (2005) 59,31160 tedance 59357.50 (5:10) Gish binding to company records Dextant service changes Musted balance 59,317.40 Click here to 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 satily 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 text entries. To enter the Check number, please enter "No proceeding the number. "Deduct'. Ada or colons () will automatically appear it 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 toe on a journal page is used for debt or crecte 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 5930. Briefly explain how the error would be included in a bank reconciliation and how it should be corrected. art of Anunt MEMBER AMERICAN NATIONAL BANK OF OCAGO CHICAGO, IL- AGE LANCE DO BEELER FURNITURE COMPANY ANDRO W BALANCE CHERCEGE AND OTHESE DATES 11 3489 DO 8/01 730 00.16 10 200 1.000 MO 100110 B010 85417 G4 TO Na 2012 0.00 0.00 11 2000 MS 3.000.00 6.00 ROSE 450.00 3.70 4018 310.00 113.30 750 26.77 3.71 200.37 11 12.6047 07.01 3 S000 12 74 GOLY 1.10074 13.000 40208 09234 15.307.00 04 11 ST 100.00 BE 1907 8.00 5/50 OR CORRECTION ODOVORARE MSME PAYMENT -TOTURUM 30RVICE CARE TERMENT OF TATOVT WORD ATEROR ORIENTE IMMAT Label and Amount Descriptions Labels Cash and cash equivalents For the Year Ended June 30, 2012 June 30, 2012 Outstanding checks Amount Descriptions Adiusted balance Bank service charges Check returned because of insufficient funds Depost of June (insert day. not recorded by bank Error in recording Check Noise check imba) Error in recording June (insert day deposit Interest Note and interest collected by bank Principal (Check numbers are vald Amount Descriptions Please enter 'Wo proceeding the Check number Shaded cats han 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. 738 1.11774 3 No 756 No. 759 525140 11395 20150 7 No. 758 * Adjusted balance 259 60 10 Cash balance according to company's records 1 Add: Note and interest collected by bank 12 15 Deduct: Check returned because of insufficient funds 14 15 1. Bank service charges 17 m your answers to two decimal places NOWJOne do not Credit CNOW on my owner waar Question not attempted JOURNAL WE DATE Score: 0/99 ACK CHI H KEM HATCH OPTION POSTE DEBIT COIT LABLE COUNTY 2 Pats 018 Feedbac #8 - Chpt 8 in dergement Session to progress 08.01 38.02 Final Questions 28.03 What mean the shores of 3.04 $ 05 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,44720 8,691.77 9 DEPOSITS 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 No.731 162.16 No.738 346.98 No.730 80.66 No. 740 237.50 No.741 496.16 No.742 601.90 No.743 871.30 No.744 606.88 No.748 117.26 No.746 298.68 No.748 450.90 No.749 840.13 No.750 276.77 No.781 299.37 No.752 537.01 No.753 380.95 No.784 449.75 No.756 272.75 No.767 407.95 No.780 486.39 -- DEPOSITS ---DATE ---- BALANCE--. 890.25 6/01 9,629.36 1,080.50 8/02 10,411.80 854.17 8/04 10,268.92 840.50 8/09 9,931.24 MS 3,500.00 6/09 13,016.33 MS 210.00 6/09 12,134.30 896.81 8/11 12,484.77 882.98 8/16 12,419.78 1,608.74 6/18 13,304.00 897.34 6/23 13,307.00 942.71 6/26 14,240.71 8/28 13,699.71 8/30 13,624.71 OD - OVERDRAFT PS PAYMENT STOPPED SC - SERVICE CHARGE SC NSP 550.00 75.00 EC - ERROR CORRECTION MS MISCELLANEOUS NSP NOT SUFFICIENT FUNDS - . THE RECONCILEMENT OP THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY