QUESTION 2 14 marks Part A 7 marks Part B 7 marks Hackers R Us Ltd (HRU) Ltd performs systems consulting. HRU's February Cash Account from its general ledger is as follows: Dr Unprotected cells for your workings if desired 2,930 2,800 101 Cash at Bank Date Description Beginning Balance, 31 January 2020 1-Feb Chg 207 Electricity expense 6-Feb Revenue cash 13-Feb Revenue cash 14-Feb Cha 208 Rent expense 14-Feb Chq 209 Electricity expense 20-Feb Revenue cash 27-Feb Revenue cash 28-Feb Chq 210 Lease expense 28-Feb Chq 211 Telephone expense Ending Balance, 28th February 2020 Cr Balance 23,115 4,300 18,815 21,745 24,545 825 23,720 1,455 22,265 27,065 30,755 190 30,565 550 30,015 30,015 4,800 3,690 HRU's bank statement dated 28 February 2020, is as follows: 31-Jan Opening balance 1-Feb Deposit # 2-Feb Direct payment for an amount owing. 2-Feb Chq 206* 8-Feb Deposit 14-Feb Deposit 18-Feb Chq 207 19-Feb chq 209 20-Feb Direct Deposit to bank - Gremlins -a customer@ 22-Feb Deposit 28-Feb Interest revenue 28-Feb Direct payment to Sydney Water 28-Feb Chg 208 28-Feb Bank Service Charge 23,510 700 (9) (1,095) 2,930 2,800 (4,300) (1,455) 400 4,800 22 (85) (825) (18) 27,375 Notes * Chq 206 was recorded in the books in January 2020. # This was recorded in the books in January 2020. @ This was an amount owed by the customer. PART A REQUIRED: Prepare the February Bank Reconciliation. Complete the table below. 7 marks Select blue Item ??? cells & pick an item from the listbox displayed. And enter values for Value?? cells. Green cells don't need entries and are protected. Blue cells MAY require entries. You decide. Bank - Bank Balance Value?? Add: Item ??? Value?? Value?? Item ??? Less: Item ??? Value?? Value?? Item ??? Item ??? Final Bank Balance Value?? Value?? Book - Book Balance Value?? Add: Item ??? Item ??? Value?? Value?? Value?? Item ??? Less: Item ??? Value?? Item ??? Item ??? Final Book Balance Value?? Value?? Value?? PART B. Prepare all adjusting entries required, for the end of the month 28 February 2020. 7 marks Select blue Entry ??? cells & pick an account from the listbox displayed. Enter values to cells in columns E&F. Date Account Name Post Ref Debit Credit Narrations not required Post Ref's not required 28-Feb Value?? Value?? 28-Feb Value?? Value?? 28-Feb Value?? Entry??? Entry??? Entry??? Entry??? Entry??? Entry??? Entry??? Entry??? Entry??? Entry??? Value?? 28-Feb Value?? Value?? 28-Feb Value?? Value