80.2K

Verified Solution

Link Copied!

Bank reconcilliation

N June 30,2023 Balance A B D 1 E F H 2 ACTION Company - Bank Reconciliation FOR June 30, 2021 3 4 BANK STATEMENT 5 Action Company-June 30, 2023 Royal Bank General Ledger Bank Action Company 6 Date Desc # Dr Debit Credit Cr. 7 Cheque# 2023 Date Cheques! Deposits! Balance 8 31 May Balance Charges Credits 9 01 Jun Cheque 471 01-Jun 2275.00 10,500.00 10 471 01-Jun cheque 472 135.00 01 Jun 2,275.00 8,225.00 01-Jun Cheque 4731 11 Deposit EFT 1 137.45 01 Jun 500.00 8,725,00 03 Jun Deposit 12 472 3,100.00 01-Jun 135.00 8.590.00 05 Jun Cheque 474 13 474 1,100.00 02 Jun 1,100.00 7.490.00 06 Jun Cheque 475 1 132 50 14 473 03 Jun 1,137.45 6,352.55 10 Jun Cheque 476 765 85 15 475 04-Jun 1 13250 5,220.05 15 Jun Deposit 5,100.00 16 Deposit-EFT 04 Jun 3,100.00 8,320.05 17-Jun Cheque 477 75.00 17 476 17 Jun 765.85 7554.20 17 Jun Cheque 478 105.00 18 Direct Debit-BTIPP 17 Jun 155.00 7,399 20 17 Jun Cheque 479 1,250 02 19 Deposit-EFT 17 Jun 5,100.00 12 499 20 17. Jun Cheque 4801 250.00 20 477 20 Jun 75.00 12 424 20 17-Jun Deposit 1 850.00 21 479 20.Jun 1250.02 11,174 18 20 Jun cheque 482 12475 22 480 21-Jun 250 10.924.18 24 Jun Cheque 484 654.35 23 Deposit 21 Jun 550.00 11,474 18 20-Jun Cheque 485 237.65 21-Jun 24 Deposit 1,100.00 12,574.18 29 Jun Cheque 486 2,650.00 28 Jun 25 478 105.00 12.469.18 30 Jun Deposit 2.450.00 26 NSF-DM 28 Jun 320.01 12.149.17 28 Jun 15.00 12,134, 17 12,300.00 27 NSF Charge DM 11 892 57 28 Service Charge 30 Jun 55.00 12079.17 30 Jun 35.00 29 Interest 12.114.17 30 8,770.83 10,385.00 12.114.17 31 10,500 00 822500 8,090.00 6,952 55 10,052.55 8,95255 7,820.05 7,054.20 12 154 20 12,079 20 11,974.20 10724 18 10,474.18 12 124 18 11,999.43 11,345.08 11 101.43 8,45743 10.90743 10.907 43 Bank Reconciliation Statement Balance per Bank Statement Add: outstanding deposits Deduct: outstanding cheques Date Cho# Amount Adjustments Adjusted Bank Balance Balance Per General Ledger Add: Interest Income Direct Deposits Deduct: Bank Charges NSF Cheque NSF Charges Adjustments E 09

Answer & Explanation Solved by verified expert

See Answer