Hi i need help creating the bank reconciliation statement

CASH RECEIPTS JOURNAL Credit Cost of Goods Sold Date Account Sales Sales Accounts Other as Discounts RevenueReceivable Accounts 57,000 250 110-5 110-1 Jun1 Bank Loan Payable Jun ARC Jandesh's Hot Spot Jun 11 ARC Quick Bolt Coffee Jun12 Sales Revenue Jun 19 Sales Revenue Jun21 ARC Revamp Coffee Carts Jun 23 ARC KavaJava Jun 26 Sales Revenue Jun 29 Sales Revenue Jun 30 ARC Central Coffee 57,000 4,338 4,820 1,360 7.440 2,200 24,354 34,200 6,600 4,922 146,648 7.440 5,652 2,200 24.354 110-3 34,200 21,280 6,600 110-4 4.922 Total 482 50,640 39,490 57,000 32,412 Post reference (402) (400) (500 (120) CASH PAYMENTS JOURNAL CheckPost Account No. Ref. Accounts Merchandise Wages Other Payable Inventory Expense Accounts 8.900 Jun1Prepaid Rent 8,900 1 Office Supplies 845 846 Jun 3 Electricity Payable Jun4 Wages Payable Jun 5 APC Klam Wholesalers Jun 10 APC East Tangiers Cooperative Jun11Wages Expense Jun12 APC - Brazil Imports Group Jun 13 APC Jordo Gourmet Coffee Jun18 Wages Expense Jun 25 Wages Expense Jun 28 APC - Brazil Imports Group Jun29 Merchandise Inventory Jun30 Salary Expense 2.284 848 210-6 849 210-2 4,669 4,669 2.261 4,531 2.261 4,531 851 210-1 852 210-5 853 854 855 210-1 2,464 1,972 1,972 3,000 2.160 4.900 2,1607,23616,10943,625 3,000 2,160 857 545 4,900 Total 18,120 Post reference