Prepare Bank reconciliation for June with details that been provided at screenshots

Bank reconciliation statement ~ May Intermaweb Computer 0900 O Bank Reconciliation Statement As at 31/05/2024 Balance as per bank statement: 78,827 CR Add: deposit in transit from Jerry Technology 12, 166 deposit in transit from Handys Electronics 14,250 26,416 105,243 CR Less: unpresented cheque No. 742 6,100 unpresented cheque No. 743 1,930 8,030 Adjusted bank balance 97,213 CR 09090 Balance as per ledger account 97,213 DRShow All |Bank Reconciliation Special Journals Subsidiary Ledgers | General Ledger Intermaweb Computer Bank Reconciliation Statement As at 30/06/2024 Balance as per bank statement: CR Add: deposit in transit deposit in transit deposit in transit Total CR Less: unpresented cheque No. No. # ) No. No. Total Adjusted bank balance CR Balance as per ledger account DRDate Particulars Debit Credit Balance 1 JUN BALANCE BROUGHT FORWARD $78,827 CR 1 JUN 742 $6, 100 $72,727 CR 2 JUN DEPOSIT - Jerry Technology $12, 166 $84,893 CR 3 JUN 743 $1,930 $82,963 CR 4 JUN 744 $7,623 $75,340 CR 6 JUN 745 $14,014 $61,326 CR 6 JUN 747 $13,067 $48,259 CR 6 JUN DEPOSIT - Handys Electronics $ 14,250 $62,509 CR 9 JUN 746 $37, 180 $25,329 CR 10 JUN DEPOSIT - Cash sales $33,605 $58,934 CR 13 JUN 748 $1,298 $57,636 CR 13 JUN 750 $12,702 $44,934 CR 14 JUN DEPOSIT - Handys Electronics $7,821 $52,755 CR 16 JUN 749 $5,000 $47,755 CR 18 JUN 751 $3,520 $44,235 CR 19 JUN DEPOSIT - Turbo Tech $12,500 $56,735 CR 19 JUN DEPOSIT - Cash sales $7,238 $63,973 CR 19 JUN 752 $13,257 $50,716 CR 21 JUN CHEQUE RETURNED - Turbo Tech $12,500 $38,216 CR 25 JUN DEPOSIT - Cash sales $95, 128 $133,344 CR 27 JUN 753 $12,800 $120,544 CR 29 JUN 755 $59,880 $60,664 CR 29 JUN DEPOSIT - Cash sales $103,620 $164,284 CR 30 JUN 756 $8,613 $155,671 CR 30 JUN 757 $6,300 $ 149,371 CR 30 JUN TRANSACTION FEE $12 $149,359 CR 30 JUN INTEREST $794 $150, 153 CR Last statement to This statement to Total debits Total credits Final balance 31/05/2024 30/06/2024 $215,796 $287,122 $150,153 CRCASH PAYMENTS JOURNAL Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account', as indicated under the a instructions above. Since all transactions in this journal affect the Cash at Bank account, you are asked to enter the name of the appropriate accou transactions into the Account column so that the type of transaction can be determined by the name of the account entered into this column. The two GST columns in this journal refer to the same GST account (being the account that is used to record the GST related to applicable cash Debit Credit Account Cheque Post Date No Ref. Accounts Wages Other Cash at Discount Payable GST Inventory GST Expense Accounts Bank Received Jun 1 APC - JCN Electrical 744 210-2 7,700 7,623 70 3 APC - Big Telco 210-4 14,300 14,014 26 260 Jun 745 Jun 3 Inventory 746 X 3,380 33,800 37, 180 Jun 4 Wages Payable 747 220 6,567 6,500 13,067 MND Jun 9 Electricity Payable 748 22 118 1,180 1,298 Jun 11 APC - Moon Megasystems 749 210-5 5,000 5,000 Jun 11 Wages Expense 75 X 12,702 12,702 Jun 15 Prepaid Rent 751 140 320 3,200 3,520 Jun 18 Wages Expense 752 X 13,257 13,257 Jun 25 Wages Expense 753 X 12,800 12,800 Jun 27 APC - Pony 754 210-1 11,713 11,713 Jun 27 APC - Pear Technology 755 210-3 59,880 59,880 Jun 30 Inventory 756 X 783 7,830 8.613 Jun 30 Salary Expense 757 545 6,300 6,300 Jun 30 select Jun 30 select) Jun 30 (select) Jun 30 (select Jun 30 (select Jun 30 (select Total Post Reference (CASH RECEIPTS JOURNAL Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account', as indicated u instructions above. Since all transactions in this journal affect the Cash at Bank account, you are asked to enter the name of the appropr transactions into the Account column so that the type of transaction can be determined by the name of the account entered into this colu The two GST columns in this journal refer to the same GST account (being the account that is used to record the GST related to applica Debit Credit Post Cost of Date Account Ref. Cash at Discount Sales Accounts Other GST Sales Bank Allowed GST Revenue Receivable | Accounts Jun 5 Sales Revenue X 33,605 30,550 3,055 14, 170 Jun 12 ARC - Handys Electronics 110-1 7,821 79 790 8,690 Jun 12 Sales Revenue X 7,238 6,580 658 2,870 Jun 16 ARC - Hypertronics 110-3 65,671 65,671 Jun 17 ARC - Turbo Tech 110-6 12,500 12,500 Jun 19 Sales Revenue X 95, 128 86,480 8,648 59,800 Jun 26 Sales Revenue X 103,620 94,200 9,420 53,290 Jun 29 Sales Revenue X 14,476 13, 160 1,316 6,340 Jun 30 ARC - Jerry Technology 110-4 9,319 9,319 Jun 30 select Jun 30 (select) Jun 30 (select) 2 AB Jun 30 select) Jun 30 (select) Jun 30 select) Total Post Reference