Prepare the June bank reconciliation please in the format that given. 

Bank - Bank Balance $ 18,389.40 Add: Deposit in transit 27 June Deposit in transit 30 June 1,660.00 1,338.00 Less: 2,830.00 780.00 538.20 612.00 Unpresented Chq 2476 Unpresented Chq 2477 Unpresented Chq 2478 Unpresented Chq 2482 Unpresented Chq 2484 Unpresented Chq 2485 Unpresented Chq 2487 Final Bank Balance 829.50 974.80 398.00 14,424.90 12,876.90 Book - Book Balance Add: Interest revenue Unpresented Chq 2476 Unpresented Ch 2477 Less: 1,996.00 2,830.00 870.00 Bank collections Deposit in transit 27 June Correction of book error Cost of cheques Final Book Balance 3,090.20 1,560.00 1,530.20 72.00 14,424.90 Date Credit Debit 1,996.00 28-Feb 1,996.00 28 - Feb 72.00 Account Name Cash at Bank Interest Revenue Accounts Payable Cash at Bank Accounts Payable Cash at Bank Accounts Payable Cash at Bank 72.00 28 - Feb 1,560.00 1,560.00 28 - Feb 1,530.20 1,530.20 28-Feb 2,830.00 Cash at Bank Accounts Receivable 2,830.00 28-Feb Cash at Bank 870.00 Accounts Receivable 870.00 Narrations not required NOTE: Adjustments to errors in recording cheques should be made to accounts payable. Adjustments to errors relating to recording cash receipts should be made to accounts receivable ABC Enterprise Bank Statement - June ABC Enterprise Bank Reconciliation As at 30 May 2020 $ Cash Balance per bank Add: Outstanding Deposits $ 12,444.70 1,530.20 $ 13,974.90 Less: Unpresented Cheques Cheque # Amount 2451 $ 1,260.40 2470 $ 720.10 2471 $ 844.50 2472 $ 503.60 2474 $ 1,050.00 Date 1 - Jun 2-Jun 5-Jun 4-Jun 8-Jun 10-Jun 15-Jun 18-Jun 27-Jun Cheque# 2470 2471 2474 2475 2476 2477 2479 2480 2481 2483 2486 Amount 720.10 844.50 1,050.00 1,640.70 2,830.00 870.00 1,570.00 1,330.00 695.40 575.50 900.00 13,026.20 Deposits 1-Jun $ 1,530.20 4-Jun 1,211.60 8-Jun 990.10 13-Jun 2,575.00 18-Jun 1,472.70 21-Jun 3,954.00 25-Jun 2,567.30 28-Jun 1,560.00 30-Jun 1,186.00 30-Jun 29-Jun $ $ 17,046.90 4,378.60 9,596.30 Balance $ Chart of Accounts ABC Enterprise Cash Receipts Journal a/c # 101 Account Name Cash at Bank Accounts Receivable 102 Date Amount 103 3-Jun $ 7-Jun 104 201 12-Jun 202 17-Jun ABC Enterprise Cash Payments Journal Date Cheque # Amount 1-Jun 2475 $ 1,640.70 2-Jun 2476 2,830.00 2-Jun 2477 780.00 4-Jun 2478 538.20 8-Jun 2479 1,570.00 10-Jun 2480 1,330.00 15-Jun 2481 695.40 18-Jun 2482 612.00 20-Jun 2483 575.50 22-Jun 2484 829.50 23-Jun 2485 974.80 24-Jun 2486 900.00 29-Jun 2487 398.00 203 20-Jun 1,211.60 990.10 2,575.00 1,472.70 3,954.00 2,567.30 1,660.00 1,186.00 1,338.00 16,954.70 301 Inventory Notes Receivable Accounts Payable Loan Payable Salary Payable Capital Drawings Sales Revenue Interest Revenue Rent Revenue Wages Expense Bank Charges Additional Cheque Fees 24-Jun 302 401 27-Jun 29-Jun 30-Jun Total 402 403 $ 501 502 503 Total $ 13,674.10 Additional Information Additional Information 1. Received $1,996 for the collection of a $1,900 note from a customer for ABC Enterprise plus interest of $120 less a collection fee of $24. ABC Enterprise has not accrued any interest on the amount received. 2. A debit from the bank for printing of additional company cheques $72. 3. As at 30 June, the cash balance per books was $12,876.90 and per the bank statement was $18,389.40. 4. The bank did not make any errors. Bank - Bank Balance $ 18,389.40 Add: Deposit in transit 27 June Deposit in transit 30 June 1,660.00 1,338.00 Less: 2,830.00 780.00 538.20 612.00 Unpresented Chq 2476 Unpresented Chq 2477 Unpresented Chq 2478 Unpresented Chq 2482 Unpresented Chq 2484 Unpresented Chq 2485 Unpresented Chq 2487 Final Bank Balance 829.50 974.80 398.00 14,424.90 12,876.90 Book - Book Balance Add: Interest revenue Unpresented Chq 2476 Unpresented Ch 2477 Less: 1,996.00 2,830.00 870.00 Bank collections Deposit in transit 27 June Correction of book error Cost of cheques Final Book Balance 3,090.20 1,560.00 1,530.20 72.00 14,424.90 Date Credit Debit 1,996.00 28-Feb 1,996.00 28 - Feb 72.00 Account Name Cash at Bank Interest Revenue Accounts Payable Cash at Bank Accounts Payable Cash at Bank Accounts Payable Cash at Bank 72.00 28 - Feb 1,560.00 1,560.00 28 - Feb 1,530.20 1,530.20 28-Feb 2,830.00 Cash at Bank Accounts Receivable 2,830.00 28-Feb Cash at Bank 870.00 Accounts Receivable 870.00 Narrations not required NOTE: Adjustments to errors in recording cheques should be made to accounts payable. Adjustments to errors relating to recording cash receipts should be made to accounts receivable ABC Enterprise Bank Statement - June ABC Enterprise Bank Reconciliation As at 30 May 2020 $ Cash Balance per bank Add: Outstanding Deposits $ 12,444.70 1,530.20 $ 13,974.90 Less: Unpresented Cheques Cheque # Amount 2451 $ 1,260.40 2470 $ 720.10 2471 $ 844.50 2472 $ 503.60 2474 $ 1,050.00 Date 1 - Jun 2-Jun 5-Jun 4-Jun 8-Jun 10-Jun 15-Jun 18-Jun 27-Jun Cheque# 2470 2471 2474 2475 2476 2477 2479 2480 2481 2483 2486 Amount 720.10 844.50 1,050.00 1,640.70 2,830.00 870.00 1,570.00 1,330.00 695.40 575.50 900.00 13,026.20 Deposits 1-Jun $ 1,530.20 4-Jun 1,211.60 8-Jun 990.10 13-Jun 2,575.00 18-Jun 1,472.70 21-Jun 3,954.00 25-Jun 2,567.30 28-Jun 1,560.00 30-Jun 1,186.00 30-Jun 29-Jun $ $ 17,046.90 4,378.60 9,596.30 Balance $ Chart of Accounts ABC Enterprise Cash Receipts Journal a/c # 101 Account Name Cash at Bank Accounts Receivable 102 Date Amount 103 3-Jun $ 7-Jun 104 201 12-Jun 202 17-Jun ABC Enterprise Cash Payments Journal Date Cheque # Amount 1-Jun 2475 $ 1,640.70 2-Jun 2476 2,830.00 2-Jun 2477 780.00 4-Jun 2478 538.20 8-Jun 2479 1,570.00 10-Jun 2480 1,330.00 15-Jun 2481 695.40 18-Jun 2482 612.00 20-Jun 2483 575.50 22-Jun 2484 829.50 23-Jun 2485 974.80 24-Jun 2486 900.00 29-Jun 2487 398.00 203 20-Jun 1,211.60 990.10 2,575.00 1,472.70 3,954.00 2,567.30 1,660.00 1,186.00 1,338.00 16,954.70 301 Inventory Notes Receivable Accounts Payable Loan Payable Salary Payable Capital Drawings Sales Revenue Interest Revenue Rent Revenue Wages Expense Bank Charges Additional Cheque Fees 24-Jun 302 401 27-Jun 29-Jun 30-Jun Total 402 403 $ 501 502 503 Total $ 13,674.10 Additional Information Additional Information 1. Received $1,996 for the collection of a $1,900 note from a customer for ABC Enterprise plus interest of $120 less a collection fee of $24. ABC Enterprise has not accrued any interest on the amount received. 2. A debit from the bank for printing of additional company cheques $72. 3. As at 30 June, the cash balance per books was $12,876.90 and per the bank statement was $18,389.40. 4. The bank did not make any errors