Bank reconciliation statement May extremely Extremely Board Bank Reconciliation Statement May 31, 2021 00000000000 $74,722 Balance per bank: Add: deposit in transit from The Locker Room deposit in transit from Balls 'n All $3,192 1,400 4,592 79,314 Deduct: outstanding check outstanding check Adjusted balance per bank No. 886 $6,500 No. 887 1,920 8,420 $70,894 $70,595 Balance per book: Add: interest earned 0000000000000000000000 311 70,906 Deduct: bank service charge Adjusted balance per book 12 $70,894 Bank statement June CASTPAC Houston branch Imogen Jensen 303 Garrard Boulevard Houston, TX 77003 Account No. 80008454 Page No 1 Extremely Board Debit Credit $6,500 $9,000 53,192 $55,000 $1.400 $1,920 $1.885 $552 $833 $3,368 Date Particulars JUN 1 BALANCE BROUGHT FORWARD JUN 1 886 JUN 3 888 JUN 3 DEPOSIT - The Locker Room JUN 4 LOAN JUN 4 DEPOSIT - Balls 'n Al JUN 4 887 JUN 6 891 JUN 6 889 JUN 7 890 JUN 8 DEPOSIT - Great Sports JUN 9 892 JUN 12 894 JUN 14 893 JUN 18 895 JUN 18 DEPOSIT - Jump Around JUN 18 DEPOSIT - Cash sales JUN 19 896 JUN 19 DEPOSIT - Balls in Al JUN 20 NSF CHECK- Jump Around JUN 20 897 JUN 23 DEPOSIT -Cash sales JUN 27 898 JUN 29 DEPOSIT - Cash sales $4,722 $2.201 $4,542 $3.316 Balance $74,722 CR $68,222 CR $59,222 CR $62,414 CR $117.414 CR $118,814 CR $116,894 CR $115,009 CR $114,457 CR $113,624 CR $116,990 CR $112.268 CR $110,067 CR $105,525 CR $102,209 CR $104,109 CR $106.845 CR $103.120 CR $104.938 CR $103.038 CR $100,890 CR $118.170 CR $115,934 CR $122, 718 CR $1,900 $2,736 $3.725 $1,818 $1,900 $2.148 $17.280 $2.236 $6,784 Extremely Board Debit Credit Balance $6,500 $9,000 $3,192 $55,000 $1,400 $1,920 $1,885 $552 $833 $3,366 $4,722 $2,201 Date Particulars JUN 1 BALANCE BROUGHT FORWARD JUN 1 886 JUN 3 888 JUN 3 DEPOSIT - The Locker Room JUN 4 LOAN JUN 4 DEPOSIT - Balls 'n All JUN 4 887 JUN 6 891 JUN 6 889 JUN 7 890 JUN 8 DEPOSIT - Great Sports JUN 9 892 JUN 12 894 JUN 14 893 JUN 18 895 JUN 18 DEPOSIT - Jump Around JUN 18 DEPOSIT - Cash sales JUN 19 896 JUN 19 DEPOSIT - Balls 'n All JUN 20 NSF CHECK - Jump Around JUN 20 897 JUN 23 DEPOSIT - Cash sales JUN 27 898 JUN 29 DEPOSIT - Cash sales JUN 30 DEPOSIT - The Locker Room JUN 30 DEPOSIT - Cash sales JUN 30 INTEREST JUN 30 SERVICE CHARGE $4,542 $3,316 $74,722 CR $68,222 CR $59,222 CR $62,414 CR $117,414 CR $ 118,814 CR $116,894 CR $115,009 CR $114,457 CR $113,624 CR $116,990 CR $112,268 CR $110,067 CR $105,525 CR $102,209 CR $104,109 CR $106,845 CR $103.120 CR $104,938 CR $103,038 CR $100,890 CR $118,170 CR $115,934 CR $122,718 CR $124,787 CR $146,675 CR $147,238 CR $147,226 CR $1,900 $2,736 $3.725 $1,818 $1,900 $2.148 $17,280 $2,236 $6,784 $2,069 $21,888 $563 $12 Last statement to this statement to 05/31/21 06/30/21 Total debits Total credits Final balance $45,492 $117,996 $147,226 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 CASH RECEIPTS JOURNAL Debit Date Account Post Ref. Cost of Goods Sold Cash Sales Discounts Credit Sales Accounts Other Revenue Receivable Accounts 55,000 3,366 Jun 250 Jun Jun 55,000 3,366 1,818 2,736 202 2,020 110-5 110-1 X 110-6 2,736 1,296 mmmmmmmm Jun Jun 1 Bank Loan Payable 6 ARC - Great Sports 13 ARC - Bails 'n All 13 Sales Revenue 17 ARC-Jump Around 20 Sales Revenue 26 ARC.Mick's Sporting Goods 27 Sales Revenue 29 ARC - The Locker Room 29 Sales Revenue 1,900 17.280 X 110-3 11,872 16,346 Jun X 6,784 1,900 17,280 16,346 6,784 2,069 21,888 129,187 (100) 4,096 Jun 110-4 X 2.069 Jun 21,888 Total 202 48,688 25,701 Post reference 55,000 (X) 11,824 29,088 (500)/(120) (402) (400) (110) CASH PAYMENTS JOURNAL Credit Date Account Check No. Post Ref. Cash Debit Accounts Merchandise Wages Other Payable Inventory Expense Accounts 9,000 552 9,000 888 140 889 130 552 221 833 890 891 220 769 1,116 833 1,885 4,722 4,542 892 210-6 4,722 4,542 210-2 2.201 Jun 1 Prepaid Rent Jun 2 Office Supplies Jun 4 Electricity Payable Jun 4 Wages Payable Jun 7 APC -J.J. Spud Jun 10 APC - Hike Jun 11 Wages Exponse Jun 12 APC - Sport Borders Jun 13 APC - Sports R Us Jun 18 Wages Expenso Jun 25 Wages Expense Jun 28. APC - Sport Borders Jun 29 Merchandise Inventory Jun 30 Salary Expense Total Post reference 893 894 895 896 897 898 899 210-1 210-5 3,316 3,725 x 2,148 2,236 2.201 3,316 3,725 2,148 2,236 4,560 3.264 4,600 47,584 (100) 210-1 4,560 900 3,264 901 545 4,600 16,101 3,264 20,865 (210) 7,354 (516) (120) (X) Drint Gla Now that you have completed the end of month posting procedure, you are required to prepare a bank reconciliaton as at June 30, 2021. The purpose of the bank reconciliation process is to reconcile the balance of cash shown in the company's ledger account against the balance of cash reported in the bank statement. Instructions for bank reconciliation 1) Prepare the bank reconciliation statement as at June 30, 2021. 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. Back-On-Track functionality Please note that any answers from previous pages carried through onto this page (either on the page or in a popup information page) have been reset, if necessary, to the correct answers. Your particular answers from previous pages are no longer shown. Remember: Enter all answers to the nearest whole dollar. . There may be entries in the general journal that require posting to both a control account and a subsidiary ledger. In these cases, after you have posted to both ledgers, you should enter the reference for both the general ledger account and the subsidiary ledger account in the Post Ref. column to indicate that you have posted to both accounts. For example, if the reference number for the control account is 110 and the reference number for the subsidiary ledger account is 110-1, you should type '110/110-1' into the Post Ref. column. You are also required to apply the journals and ledgers instructions provided in previous weeks. Before pressing the Submit answers button, we recommend that you click the Show All tab and check that all relevant accounting records have been completed. extremely Extremely Board Bank Reconciliation Statement June 30, 2021 Balance per bank: Add: Deduct: No. No. 4) No. Adjusted balance per bank Balance per book Add: IN Deduct: No. No. No. Adjusted balance per bank Balance per book Add: Deduct: Adjusted balance per book