LO3: Your line manager has provided you with the following information: Two different clients are facing regular monthly problems with matching the cash balance of the bank statement with the cash balance found on their business's records. For this, your line manager has asked you to help these clients to handle and solve this issue by performing bank reconciliations for these two businesses (A & B) by using the available information in table 4&5. Instructions: in this task you have to: 1) Apply the bank reconciliation process for business (A) for the month ended November.30.2019 by using information from table 4. 2) Apply the bank reconciliation process for business (B) for the month ended November.30.2019 by using information from table 5. 3) Demonstrate the use of deposit in transit, outstanding checks and Not Sufficient Funds (NSF) in the reconciliation process. 4) Show that the two bank reconciliations have been accurately prepared by using appropriate tools and techniques. 5) Check what accounts are affected in both general ledger accounts and balance sheets. This can be done through preparing the adjusting entries of the bank reconciliations or through listing the affected accounts and their effects on general ledger and balance sheets. Table 4: Business (A) Available information for bank reconciliation Business A's bank statement dated Nov 30, 2017 shows a cash balance of 22500. The business's cash records on the same date show a balance of 21949. 1 2 3 No. 846 issued on Nov 29 Following checks issued by the business to its suppliers are still outstanding: 95. 400. No. 875 issued on Nov 26 375. No. 881 issued on Nov 30 86 4 5 6 7 89 9. No. 878 issued on Nov 29 A deposit of 2600 made on Nov 30 does not appear on bank statement. Interest income earned on the business's average cash balance at bank was 1,007 A deposit of 341 was incorrectly entered as 143 in the business's cash records. The bank collected a note receivable on behalf of the business. Amount received by the bank on the note was 3000. This includes 100 interest income. The bank charged a collection fee of 10 A NSF check of 2000 was returned by the bank with the bank statement. The bank charged 100 as service fee. Table 5: Business (B) Available information for bank reconciliation 1 The bank statement of business (B) company shows a balance of 12,000 on 31 Nov 2017 2 The business's ledger shows a balance of 9488on the same date. 3 by The following checks issued during the month of January have not yet been cleared Check No: 201, Issue Check No: 212, Issue Check No: 216, Issue the date: 15 Nov 2017, Amount date: 19 Nov 2017, Amount date: 25 Nov 2017, bank. 200. 420. Amount 4 5 6 7 8 9 640. An amount of 1880 sent to the bank for deposit on 30 Nov 2017 does not appear in the bank statement. A note receivable amounting to 3,497 has been collected by bank for the business. The bank has charged 10 for the collection of note. The bank statement shows that interest amounting to 100 has been earned on average account balance during Nov A check of 450 deposited by the business has been charged back as NSF. An amount of 95 has been deducted by bank as service charges for the month of Nov. The check no. 220 was issued to pay the business electricity. The check was in the amount of 105 but was erroneously recorded in the cash payments journal as 15. 1) Company (A) Bank Reconciliation Statement: Bank Statement Book Statement Adjusted balance per bank = Adjusted balance per book= 2) Company (B) Bank Reconciliation Statement Bank Statement Book Statement Adjusted balance per bank = Adjusted balance per book=