ghmentSessionLocator assignment-take&inprogress false y atter banking hours. The data required to Furniture Company deposits all cash receipts each wednesday and Friday in a night depository reconcile the bank staterment as of June 30 have been taken from vartous documents and records and are reproduced as folows. The 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 $9,223.76 CASH RECEIPTS FOR MONTH OF JUNE DUPLICATE DEPOSIT TICKETS: Date and amount of each deposit in June: Date Amount Date Amount DateAmount June 22 $897.34 24 947.21 1,117.74 June 1 $1,080.50 June 10 996.61 854.17 15 882.95 840.50 17 1,606.74 30 CHECKS WRITTEN: Number and amount of each check issued in June Check No.Amount $237.50 495.15 501.90 761.30 Check No. Amount 740 741 742 747 748 749 750 Check No. 754 755 756 757 Amount $449 75 272 75 113 95 407.95 Void $450 90 640.13 276.77 k My Work eBook Calculator 744 745 746 506.88 117.25 298.66 751 752 753 299 37 537.01 380 95 758 759 760 259.60 901.50 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 Cash balance according to bank statement Add deposit for May 31, not recorded by bank $9.44720 690.25 10,13745 f Deduct outstanding checks $16215 No. 756 y Work 1 eBook Calculator Bank May 31, 20Y2 Cash balance according to bank statement 2 Add deposit for May 31, not recorded by bank 9.447.20 690.25 $10,13745 4 Deduct outstanding checks s No.731 6 No. 736 1 No. 738 sNo. 739 162.15 345.95 251.40 60.55 820.05 Adusted balance $9,31740 # 1 cash balance according to company's records l Deduct service charges 1ellAd usted balance 5935250 35.10 $9.31740 JUNE BANK STATEMENT eBook Calculator 11 Cash balance according to company's records 12 Deduct service charges 13 Adjusted balance $9,352.50 35.10 9.31740 JUNE BANK STATEMENT Required: 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 wrtten to satisty accounts peyable 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 account tities 3. What is the amount of Cash that should appear on the balance sheet as of June 307 4 assume that a canceled check for $390 has been incorrectly recorded by the bank a5 S930 Briefly explain how the error would be included in a bank reconciiation and how it should be corrected eck My Work PAGE L MEMBER FDIC ACCOUNT NUMBER AMERICAN NATIONAL BANK OF CHICAGO FROM 8/01/20Y2 TO 8/30/ROY2 9447.20 8,891.77 7,899.26 CHICAGO, IL 60603 (312) 441-1239 9 DEPOSITS 20 WITHDRAWALS BEELER FURNITURE COMPANY 4 OTHER DEBITS AND CREDITS 3,088.00OR NEW BALANCE 13,624.71 CHBCKS AND OTHER DEBITS-DEPOSITS-.-DATE- .BALANCE-. No.731 162.18 No. 736 346.98 No.73960.88 No.740 237.80 No.741 498.18No.742 601.00 No. 743 671.30 No.744 608.88 890.26 6/01 1,080.606/0:2 9,629.38 10,411.80 10,268.92 9,931.24 13,016.33 12,134.30 12,464.77 12,419.76 13,304.00 13,307.00 14,240.71 13,699.1 13,624.71 884.17 6/04 840.806/09 No.748 117.28 No.746 298.86 MS 3,600.006/09 No.748 480.90 No.749 640.13 MS 210.00 6/09 896.818/11 6/18 1,808.74 6/18 6/23 942.716/26 No. 760 276.7 No.761 299.37 No.762 837.01No.783 380.98 No.764 449.78No.7BB 272.78 67 407.98 No.780 488.39 882.96 897.34 NSE 650.00 SC Y8.00 6/30 BC BRROR CORRECTION MSMISCELLANEOUS NSP NOT SUPPICIENT FUNDS OD OVERDRAPT P8- PAYMENT STOPPED SC SERVICE CHARGE TEE RECONCILEMENT OP THE STATEMENT wTTH YOUR RBOORD8 18 B88ENTIAL ANY BRROR OR EXCEPTION SHOULD BE REPORTED IMDMEDLATRLY