please show answers and working out

ABC Enterprise Bank Statement - June ABC Enterprise Bank Reconciliation As at 30 May 2020 Joan Jackson is ABC Enterprise's owner. Joan seeks your assistance in preparing the bank reconciliation for ABC Enterprise. PART A REQUIRED: 12 marks Prepare the June bank reconciliation by completing the table below. Select blue Item ??? cells & pick an item from the listbox displayed. Enter formulas or values for Value?? cells. Green cells don't need entries and are protected. Blue cells MAY require entries. $ Cash Balance per bank Add: Outstanding Deposits $ 12,444.70 1530.20 $ 13,974.90 Date 1.Jun 2-Jun 5-Jun 4-Jun Chequel 2470 2471 2474 2475 2476 2477 2479 Amount 720.10 844.50 1,050.00 1,640.70 2,830.00 870.00 1.5 70.00 1,330.00 695.40 9 Jun Less: Unpresented Cheques Cheque # Amount 2451 $ 1.260.40 2470 $ 720.10 2471 $ 844.50 2472 $ 503.60 2474 $ 1,050.00 $ Balance $ 2480 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 10-Jun 15-Jun 18 Jun 27 Jun 30-Jun 29-Jun 2481 2483 2486 Value?? Value?? 575.50 900.00 $ 13,026.20 4378.60 $ 17.046.90 9,596.30 Value?? Bank - Bank Balance Add: Item ??? Item ??? Less: Item ??? item ??? Item 777 Item ??? Item ??? Item ??? Item ??? Final Bank Balance Value?? Valur?? Value?? Value?? Value?? Value? Value?? Value 77 Value?? Value?? Value? Book - Book Balance Add: Item ??? Item ??? Item ??? Less: Item ??? Item 272 Item ??? Item 222 Final Book Balance Chart of Accounts ABC Enterprise ABC Enterprise a/c# Account Name Cash Payments Journal Cash Receipts Joumal 101 Cash at Bank Date Cheque # Amount 102 Accounts Receivable 1-Jun 2475 $ 1,640.70 Date Amount 103 Inventory 2-Jun 2476 2,830,00 3. Jun $ 1,211.60 104 Notes Receivable 2-Jun 2477 780.00 7-Jun 7- 990.10 201 Accounts Payable 4-Jun 2478 538.20 12-Jun 2,575.00 202 Loan Payable 8-Jun 2479 1,570.00 17 Jun 1,472.70 203 Salary Payable 10-Jun 2480 1,330.00 20-Jun 3,954.00 301 Capital 15-Jun 2481 695.40 24-Jun 2,567 30 302 Drawings 18-Jun 2492 612.00 27-Jun 1,660.00 401 Sales Revenue 20-Jun 2483 575.50 29-Jun 1,186.00 402 Interest Revenue 22-Jun 2484 829.50 30-Jun 1,338.00 403 Rent Revenue 23-Jun 2485 974.80 Total $ 16,954.70 501 Wages Expense 24 Jun 2496 900.00 502 Bank Charges 29-Jun 2487 398.00 503 Additional Cheque Fees Total $ 13,674.10 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. Value?? Value?? Value?? Value?? Value?? PART B. Prepare adjusting entries for June. 7 marks Select blue Entry ??? cells & pick an account from the listbox displayed. Credit Date 28-Feb Account Name Entry??? Debit Value?? ABC Enterprise Bank Statement - June ABC Enterprise Bank Reconciliation As at 30 May 2020 Joan Jackson is ABC Enterprise's owner. Joan seeks your assistance in preparing the bank reconciliation for ABC Enterprise. PART A REQUIRED: 12 marks Prepare the June bank reconciliation by completing the table below. Select blue Item ??? cells & pick an item from the listbox displayed. Enter formulas or values for Value?? cells. Green cells don't need entries and are protected. Blue cells MAY require entries. $ Cash Balance per bank Add: Outstanding Deposits $ 12,444.70 1530.20 $ 13,974.90 Date 1.Jun 2-Jun 5-Jun 4-Jun Chequel 2470 2471 2474 2475 2476 2477 2479 Amount 720.10 844.50 1,050.00 1,640.70 2,830.00 870.00 1.5 70.00 1,330.00 695.40 9 Jun Less: Unpresented Cheques Cheque # Amount 2451 $ 1.260.40 2470 $ 720.10 2471 $ 844.50 2472 $ 503.60 2474 $ 1,050.00 $ Balance $ 2480 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 10-Jun 15-Jun 18 Jun 27 Jun 30-Jun 29-Jun 2481 2483 2486 Value?? Value?? 575.50 900.00 $ 13,026.20 4378.60 $ 17.046.90 9,596.30 Value?? Bank - Bank Balance Add: Item ??? Item ??? Less: Item ??? item ??? Item 777 Item ??? Item ??? Item ??? Item ??? Final Bank Balance Value?? Valur?? Value?? Value?? Value?? Value? Value?? Value 77 Value?? Value?? Value? Book - Book Balance Add: Item ??? Item ??? Item ??? Less: Item ??? Item 272 Item ??? Item 222 Final Book Balance Chart of Accounts ABC Enterprise ABC Enterprise a/c# Account Name Cash Payments Journal Cash Receipts Joumal 101 Cash at Bank Date Cheque # Amount 102 Accounts Receivable 1-Jun 2475 $ 1,640.70 Date Amount 103 Inventory 2-Jun 2476 2,830,00 3. Jun $ 1,211.60 104 Notes Receivable 2-Jun 2477 780.00 7-Jun 7- 990.10 201 Accounts Payable 4-Jun 2478 538.20 12-Jun 2,575.00 202 Loan Payable 8-Jun 2479 1,570.00 17 Jun 1,472.70 203 Salary Payable 10-Jun 2480 1,330.00 20-Jun 3,954.00 301 Capital 15-Jun 2481 695.40 24-Jun 2,567 30 302 Drawings 18-Jun 2492 612.00 27-Jun 1,660.00 401 Sales Revenue 20-Jun 2483 575.50 29-Jun 1,186.00 402 Interest Revenue 22-Jun 2484 829.50 30-Jun 1,338.00 403 Rent Revenue 23-Jun 2485 974.80 Total $ 16,954.70 501 Wages Expense 24 Jun 2496 900.00 502 Bank Charges 29-Jun 2487 398.00 503 Additional Cheque Fees Total $ 13,674.10 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. Value?? Value?? Value?? Value?? Value?? PART B. Prepare adjusting entries for June. 7 marks Select blue Entry ??? cells & pick an account from the listbox displayed. Credit Date 28-Feb Account Name Entry??? Debit Value