Part B 7 Hackers R Us Ltd (HRU) Ltd performs systems consulting. HRU's February Cash Account from its general ledger is as follows: Dr Cr 4,300 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 Chg 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 825 1,455 Balance 23,115 18,815 21,745 24,545 23,720 22,265 27,065 30,755 30,565 30,015 30,015 4,800 3,690 190 550 HRU's bank statement dated 28 February 2020, is as follows: 31 Jan 1-Feb 2-Feb 2-Feb 8-Feb 14-Feb 18-Feb 19-Feb 20-Feb 22-Feb 28-Feb 28-Feb 28-Feb 28-Feb Opening balance Deposit # Direct payment for an amount owing. Chg 206 Deposit Deposit Chg 207 Chg 209 Direct Deposit to bank-Gremlins a customer@ Deposit Interest revenue Direct payment to Sydney Water Chq 208 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. Select blue Entry ??? cells & pick an account from the listbox displayed. Enter values to cells in columns E&F. Date Account Name Post Ref Credit Debit Value?? Narrations not required Post Ref's not required 28-Feb 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?? 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. $ 23,510 400 Value?? Bank - Bank Balance Add: Direct Deposit to bank - Gremlins Item ??? Less: Item ??? Item ??? Item ??? Final Bank Balance Value?? Value?? Value?? Value?? Value?? Book - Book Balance Add: Item ??? Item ??? Item ??? Less: Item ??? Item ??? Item ??? Value?? Value?? Value?? Value?? Value?? Value?? Value?? Final Book Balance