1) Prepare the bank reconciliation statement as at June 30, 2020. To do this, you will need to use: the previous month's bank reconciliation" statement, and the current month's bank statement" and cash journals Note that the bank reconciliation statement provided below may contain more rows than required. 2)Use the bank reconciliation statement to record the relevant reconciling items in the general journal. 3)Post entries recorded in the general journal to the appropriate ledger accounts according to the company's accounting policies and procedures. 4) Record the updated balance of each ledger account in the Balance row of each ledger, even for ledgers with a balance of zero. Although each ledger already has a running balance, the Balance row must still be filled out in order to receive full points.Show All Bank Reconciliation General Journal Subsidiary Ledgers |General Ledger_onciliation - May Cover 2 Cover Bank statement - June Bank Reconciliation Statement Journals and ledgers June 30, 2020 instructions Special printing $ $ information Balance per bank: Cash journals Add: DEAN KOO SHELDON HAROLD ROUDIS THE ICK FRANCIS TO THE AT MOTT TIARA ON THE Deduct: + No. BURIAN No. + No. Adjusted balance per bank sheldon YSHELDON' Balance per book DEAN KOO Add: SHELDON HAROLD ROUDHHS TH MAN MOTT TIRAN RIAN Deduct: CROSS sheldon TELDON HAROLD ROUDHS Thi Men Adjusted balance per book MOTT TIRE (Q=823.generalJournalBankRec)GENERAL JOURNAL Post Date Account and Explanation Credit Ref. Debit Jun 9 Sales Returns and Allowances 401 5,204 Jun g ARC - Outlines 110/110-3 5,204 (sales return) DEAN NOO 210/210-3 HAROLD ROUnIHS Thi ment Jun 18 APC - Stompson 1,434 18 Purchase Returns and Allowances 501 1,434 (purchase return) ICK FRANCIS TO T MOTT TIRE KOONTZ CET Jun 30 (select (select Jun 30 select select DEAN NOO (select) HAROLD ROBBINS Times Jun 30 (select DICK FRANCIS TO THE AT Jun 30 (select (select) (Q=824-110-5.AcctsRec5_bankRec) SUBSIDIARY LEDGERS Account: ARC - Congo.com ay sheldon Account No. 110-5 ONEYSHELDON Date Description Ref. Debit Credit Balance May 31 Balance Jun Credit sale SJ 4,060 4,060 DR MOTT TIRED Jun 30 Jun 30 Jun 30 Jun 30 Balance (Q=824-110-6.AcctsRec6_bankRecAccount: ARC - Gimmicks ay sheldon Account No. 110-6 HEYSHELDON DEAN KOO Description Ref. Debit Credit Balance Date May 31 Balance Jun 13 Credit sale SJ 1,440 1,440 DR 1,000 440 DR Jun 19 Repayment CRJ 6,530 DR Jun 24 Credit sale SJ 6,090 Jun 30 Jun 30 Jun 30 Jun 30 Balance (Q=825-100.Cash_bankRec) PREY SHELDON GENERAL LEDGER Account: Cash Account No. 100 Description Ref. Balance Date Debit Credit 27,359 DR May 31 Balance Jun 30 Total from cash receipts journa CRJ 97,486 124,845 DR 34,483 90,362 DR Jun 30 Total from cash payments journal CPJ Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Balance KOTT TIRE (Q=825-110-0.ARControl_bankRec) Account: ARC - Accounts Receivable Control Account No. 110 Description Debit Credit Balance Date Ref. 10,456 DR May 31 Balance 9 Sales return from Outlines GJ 5,204 5,252 DR Jun SJ 16.665 21,917 DR Jun Total from sales journal 30 Total from cash receipts journal 10, 110 11,807 DR Jun CRJ Jun 30 Jun 30 MOTT TI RED Jun 30 Jun 30 Jun 30 Balance (Q=825-210-0.APControl_bankRec)Account: APC - Accounts Payable Control Account No. 210 Description Balance Date Ref. Debit Credit 11,473 CR May 31 Balance Jur 18 Purchase return to Stompson GJ 1,43 10,039 CR Total from purchases journal P 6,430 16,469 CR Jun 30 Total from cash payments journal CPJ 14.439 2,030 CR Jun Jur 30 Jur 30 Jun 30 Jun 30 Balance (Q=825-403.InterestRevenue_bankRec) Account: Interest Revenue DEAN KOO Account No. 403 NEY SHELDO Balance Date Description Ref. Debit Credit 0 May 31 Balance MOTT TIARA Jun 30 Jur 30 Jur 30 Jun 30 Balance (Q=825-571.InterestExpense_bankRec) Account: Interest Expense ay sheldon Account No. 571 HEYSHELDON Date Description Ref Debit Credit Balance 0 May 31 Balance DEM Jur 30 Jun 30 Jun 30 Jun Balance (Q=825-572.BankCharges_bankRec) Account: Admin. Expense - Bank Charges Account No. 572 ay sheldon Debit Balance Date Description Ref. Credit 0 May 31 Balance Jur 3 MOTT TERRA Jun 3 Jur 3 Jun 30 BalanceBank reconciliation statement ~ May Cover 2 Cover Bank Reconciliation Statement May 31, 2020 Balance per bank: $29,254 Add: deposit in transit from Cliff's Notes $3,715 deposit in transit from Attic Books 790 4,505 33,759 Deduct: outstanding check No. 901 $5,600 outstanding check No. 902 800 6,400 Adjusted balance per bank $27,359 Balance per book: $27,244 Add: interest earned 122 27,366 Deduct: bank service charge 7 3606006060 Adjusted balance per book $27,359 Print CloseBank statement ~ June CASTPAC Miami branch Account No. Neville Cooper 27900920 827 McGee Avenue Miami, FL 33109 Page No. Cover 2 Cover Date Particulars Debit Credit Balance JUN BALANCE BROUGHT FORWARD $29,254 CR JUN 4 LOAN $43,000 $72,254 CR JUN 5 902 $800 $71,454 CR JUN 6 DEPOSIT - Cliff's Notes $3,715 $75,169 CR JUN 6 DEPOSIT - Attic Books $790 $75,959 CR JUN 6 901 $5,600 $70,359 CR JUN 903 $1,787 $68,572 CR JUN 9 DEPOSIT - Cash sales $7,830 $76,402 CR JUN 10 904 $2,787 $73,615 CR JUN 13 DEPOSIT - Cash sales $11,394 $85,009 CR JUN 14 905 $3,750 $81,259 CR JUN 17 DEPOSIT - Attic Books $2,993 $84,252 CR JUN 19 907 $5,746 $78,506 CR JUN 20 DEPOSIT - Cash sales $9, 191 $87,697 CR JUN 21 DEPOSIT - Gimmicks $1,000 $88,697 CR JUN NSF CHECK - 24 Gimmicks $1,000 $87,697 CR JUN 27 DEPOSIT - Cash sales $9,595 $97,292 CR JUN 28 908 $4,227 $93,065 CR JUN 30 DEPOSIT - Cliff's Notes $3,027 $96,092 CR JUN 30 DEPOSIT - Cash sales $6,699 $102,791 CR JUN 30 910 $5,323 $97,468 CR JUN 30 INTEREST $231 $97,699 CR JUN 30 SERVICE CHARGE $7 $97,692 CR Last This Total Total Final balanceLast This Total Total statement to statement to debits Final balance credits 05/31/20 06/30/20 $31,027 $99,465 $97,692 CR Proceeds of checks will not be available until cleared. All entries for the last business day are subject to verification and authorization. Any items not paid, or withdrawn, will be adjusted by reversal entry on a later statement. NSF means Not Sufficient Funds.CASH RECEIPTS JOURNAL Debit Credit Post Date Account Ref. Sales Sales Accounts Other Cash Discounts Revenue | Receivable | Accounts Jun 1 Bank Loan Payable 250 43,000 43,000 Jun 5 Sales Revenue X 7,830 7.830 11 ARC - Attic Books 333 3,326 Jun 110-1 .993 12 Sales Revenue X 11.394 11.394 Jun Jun 19 ARC - Gimmicks 110-6 1,000 1,000 Jun 19 Sales Revenue X 9.191 9.191 20 ARC - Outlines 110-3 2,757 2,757 Jun Jun 26 Sales Revenue X 9,595 9,595 3,027 Jun 30 ARC - Cliff's Notes 110-4 3,027 Jun 30 Sales Revenue X 6,699 6,699 Total 17,486 333 44,709 10,110 43,000 Post reference (100 (402 (400) (110 (X) CASH PAYMENTS JOURNAL Debit Credit Check Post Date Account Ref. Accounts Other Cash Purchase No. Purchases Payable Accounts Discounts 903 1,787 18 Jun 2 APC - Albatross 210-2 1,805 Jun 4 APC - Booked Inn 904 210-4 2,844 2,787 57 Purchases 905 3,750 3,750 Jur Jun 13 APC - Books R Us 906 210-5 1,919 1,919 15 Wages Expense 907 516 5.746 5,746 Jun Jun 26 APC - Stompson 908 210-3 4,227 4.227 28 APC - Noir Novels 909 3,644 Jun 210-1 3,644 Jun 29 Wages Expense 910 516 5.323 5.323 30 Salary Expense 911 545 0,300 5,300 Jun Total 14,439 3,750 16,369 34,483 75 (210) 500) (X) 100 502 Post reference