? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial -12 - A A A - E.E.S. EE HT 21 BIU XX A. Ay.A = = = = S. AaBbCcl AaBbccl Aabbai AaBbccc AaB AabhCED AaBbcc AaBboca AaBBCD AaBb CD Normal No Space Heading 1 Heading Suhtle Fm Fmphasis Intense Strong # Find - Replace Select- Title Font Paragraph Styles Editing You are a Junior Accountant trainee in an accountancy firm which serves a number of clients with different financial needs. At the end of your training period your line manager wants to assess your ability and knowledge in handling some of the main financial accounting issues regarding the process of preparing a bank reconciliations statement and reconciling the control accounts, in order to do so he asked you to conduct some exams to demonstrate your ability and to reflect the knowledge and skills you have gain during your training period. In this exam you have been asked to handle the following financial problems. . : Task 3: learning outcome 3 Your line manager has provides 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. 3 (B) 3 Task | (A & B) 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) Activate Windows Gulu Sellings to activate Windows PAGE 1 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 100% O | Ae PS ws AENG 8:26 PM 1/25/2021 ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in AaBbcc AaBbCcl Aabbai AaBbcc AaB AabhCGD AaBbcca AaBbcc AaBbcc AaBb CD Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A BIU XX A. AYA EEEEETS 21 S. Paragraph # Find - Replace Select- Normal f No Spar... Heading 1 Heading ? Title Subtitle Subtle Fm Fmphasis Intense Strong Font Styles Editing Task 3: learning outcome 3 Your line manager las 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 cast 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. 3 Task . | (B & 4) Lastructions: in this task you have to: 1) Apply the bank reconciliation process for business (A) for the month cnded 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. | (1) 2013/11/30 4) 2) () 2019/11/30 5) 3) (deposit in transitioutstanding checks and Not sufficient Funds . Activate Windows Gulu Sellings to activate Windows PAGE 1 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 100% O | Ae PS w ] AENG 8:26 PM 1/25/2021 ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial -12 - A A A - E.E.S. EE HT 21 BIU XX A. AYA Paragraph AaBbCcl AaBbccl Aabbai AaBbccc AaB AabhCED AaBbcc AaBboca AaBBCD AaBb CD 1 Normal 1 No Space Heading 1 Heading ? Subtitle Suhtle Fm Fmphasis Intense Strong Styles # Find - Replace Select- Title Font Editing 5) Table 4: Business (A) Available information for bank reconciliation 1 Business A's bank statement dated Nov 30, 2017 shows a cash balance of 22500. 2 The business's cash records on the same date show a balance of 21949. 3 Following checks issued by the business to its suppliers are still outstanding: No. 846 issued on Nov 29 400. No. 875 issued on Nov 26 95. No. 878 issued on Nov 29 375. No. 881 issued on Nov 30 86 4 4 A deposit of 2600 made on Nov 30 does not appear on bank statement. 5 5 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. 7 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 8 A NSF check of 2000 was returned by the bank with the bank statement. 9 The bank charged 100 as service foc. Table 5: Business (B) Available information for bank reconciliation 1 2 3 The bank statement of business (B) company shows a balance of 12,000 on 31 Nov 2017 The business's ledger shows a balance of 9488on the same date. The following checks issued during the month of January have not yet been cleared by the hank Check No: 201. Issue 15 Nov 2017 200. Check No: 212. Issue date: 19 Nov 2017. Amount 420 Check No: 216, Issue date: 25 Nov 2017, Amount 640. An amount of 1880 sent to the bank for deposit on 30 Nov 2017 does not appear in the Activate Windows Gulu Sellings to activate Windows 4 PAGE 2 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 100% O | Ae Ps wi AENG 8:26 PM 1/25/2021 ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A BIU XX A. EEGEET 21 S. AaBbccl AaBbcl AaBbci AaBbcc AaB Aah CD AaB CD AaBDCD AaBbcc Aabbcc 1 Normal 1 No Spac. Heading 1 Heading ? Title Subtitle Subtle Fm Fmphasis Intense Strong Styles # Find - Replace Select- Font Paragraph Editing 5 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 carned 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. 7 8 9 The check no. 220 was issued to pay the business clectricity. The check was in the amount of 105 but was erroneously recorded in the cash payments joumal as 15. Activate Windows Gulu Sellings to activate Windows PAGE 2 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 + 100% 8:27 PM 1/25/2021 O | Ae Ps w ] 4 ENG ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A BIU XX A. AYA EEGEET 21 S. AaBbcc AaBbCcl Aabbai AaBbcc AaB AabhCGD AaBbcca AaBbcc AaBbcc AaBb CD Normal No Spar Heading 1 Heading Title Subtitle Subtle Fm Fmphasis Intense Strong # Find - Replace Select- Font Paragraph Styles Editing 1-Bank Reconciliation Company A Bank Statement Book Statement 1-Bank Reconciliation Company B Bank Statement Book Statement Activate Windows Go to Sellings to 2 of 24 - Clipboard Item not Collected: Delete items Es to increase available space 8:27 PM A4 ENG 1/25/2021 PAGE 2 OF 4 960 WORDS ENGLISH (UNTED KINGDOM O | Ae PS w ] ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A EEGEET 21 BIU XX A. Ay.A = = = = AaBbCcl AaBbCcl Aabba AaBbcc AaB AaBhord AaBBCD AaBbcc Aabac Aabbcc I Normal No Spar Heading 1 Heading Title Subtitle Subtle Fm Fmphasis Intense Strong Styles # Find - Replace Select- Font Paragraph 1 Editing Bank Reconciliation: Outstanding Checks : NFS Check: Deposit in transit: Why did you +/- Activate Windows Gulu Sellings to activate Windows PAGE 4 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 + 100% 8:27 PM 1/25/2021 O | Ae WE 4 ENG ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial -12 - A A A - E.E.S. EE HT 21 BIU XX A. Ay.A = = = = S. AaBbCcl AaBbccl Aabbai AaBbccc AaB AabhCED AaBbcc AaBboca AaBBCD AaBb CD Normal No Space Heading 1 Heading Suhtle Fm Fmphasis Intense Strong # Find - Replace Select- Title Font Paragraph Styles Editing You are a Junior Accountant trainee in an accountancy firm which serves a number of clients with different financial needs. At the end of your training period your line manager wants to assess your ability and knowledge in handling some of the main financial accounting issues regarding the process of preparing a bank reconciliations statement and reconciling the control accounts, in order to do so he asked you to conduct some exams to demonstrate your ability and to reflect the knowledge and skills you have gain during your training period. In this exam you have been asked to handle the following financial problems. . : Task 3: learning outcome 3 Your line manager has provides 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. 3 (B) 3 Task | (A & B) 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) Activate Windows Gulu Sellings to activate Windows PAGE 1 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 100% O | Ae PS ws AENG 8:26 PM 1/25/2021 ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in AaBbcc AaBbCcl Aabbai AaBbcc AaB AabhCGD AaBbcca AaBbcc AaBbcc AaBb CD Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A BIU XX A. AYA EEEEETS 21 S. Paragraph # Find - Replace Select- Normal f No Spar... Heading 1 Heading ? Title Subtitle Subtle Fm Fmphasis Intense Strong Font Styles Editing Task 3: learning outcome 3 Your line manager las 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 cast 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. 3 Task . | (B & 4) Lastructions: in this task you have to: 1) Apply the bank reconciliation process for business (A) for the month cnded 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. | (1) 2013/11/30 4) 2) () 2019/11/30 5) 3) (deposit in transitioutstanding checks and Not sufficient Funds . Activate Windows Gulu Sellings to activate Windows PAGE 1 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 100% O | Ae PS w ] AENG 8:26 PM 1/25/2021 ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial -12 - A A A - E.E.S. EE HT 21 BIU XX A. AYA Paragraph AaBbCcl AaBbccl Aabbai AaBbccc AaB AabhCED AaBbcc AaBboca AaBBCD AaBb CD 1 Normal 1 No Space Heading 1 Heading ? Subtitle Suhtle Fm Fmphasis Intense Strong Styles # Find - Replace Select- Title Font Editing 5) Table 4: Business (A) Available information for bank reconciliation 1 Business A's bank statement dated Nov 30, 2017 shows a cash balance of 22500. 2 The business's cash records on the same date show a balance of 21949. 3 Following checks issued by the business to its suppliers are still outstanding: No. 846 issued on Nov 29 400. No. 875 issued on Nov 26 95. No. 878 issued on Nov 29 375. No. 881 issued on Nov 30 86 4 4 A deposit of 2600 made on Nov 30 does not appear on bank statement. 5 5 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. 7 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 8 A NSF check of 2000 was returned by the bank with the bank statement. 9 The bank charged 100 as service foc. Table 5: Business (B) Available information for bank reconciliation 1 2 3 The bank statement of business (B) company shows a balance of 12,000 on 31 Nov 2017 The business's ledger shows a balance of 9488on the same date. The following checks issued during the month of January have not yet been cleared by the hank Check No: 201. Issue 15 Nov 2017 200. Check No: 212. Issue date: 19 Nov 2017. Amount 420 Check No: 216, Issue date: 25 Nov 2017, Amount 640. An amount of 1880 sent to the bank for deposit on 30 Nov 2017 does not appear in the Activate Windows Gulu Sellings to activate Windows 4 PAGE 2 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 100% O | Ae Ps wi AENG 8:26 PM 1/25/2021 ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A BIU XX A. EEGEET 21 S. AaBbccl AaBbcl AaBbci AaBbcc AaB Aah CD AaB CD AaBDCD AaBbcc Aabbcc 1 Normal 1 No Spac. Heading 1 Heading ? Title Subtitle Subtle Fm Fmphasis Intense Strong Styles # Find - Replace Select- Font Paragraph Editing 5 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 carned 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. 7 8 9 The check no. 220 was issued to pay the business clectricity. The check was in the amount of 105 but was erroneously recorded in the cash payments joumal as 15. Activate Windows Gulu Sellings to activate Windows PAGE 2 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 + 100% 8:27 PM 1/25/2021 O | Ae Ps w ] 4 ENG ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A BIU XX A. AYA EEGEET 21 S. AaBbcc AaBbCcl Aabbai AaBbcc AaB AabhCGD AaBbcca AaBbcc AaBbcc AaBb CD Normal No Spar Heading 1 Heading Title Subtitle Subtle Fm Fmphasis Intense Strong # Find - Replace Select- Font Paragraph Styles Editing 1-Bank Reconciliation Company A Bank Statement Book Statement 1-Bank Reconciliation Company B Bank Statement Book Statement Activate Windows Go to Sellings to 2 of 24 - Clipboard Item not Collected: Delete items Es to increase available space 8:27 PM A4 ENG 1/25/2021 PAGE 2 OF 4 960 WORDS ENGLISH (UNTED KINGDOM O | Ae PS w ] ? LOS BANK RECONCILIATION (1) - Word (Product Activation Failed) VIEW FILE HOME INSERT DESIGN PAGE LAYOUT REFERENCES MAILINGS REVIEW Sign in Copy X Cut Un Paste * Format Painter Clipboard Arial - 12 - A Aa - A EEGEET 21 BIU XX A. Ay.A = = = = AaBbCcl AaBbCcl Aabba AaBbcc AaB AaBhord AaBBCD AaBbcc Aabac Aabbcc I Normal No Spar Heading 1 Heading Title Subtitle Subtle Fm Fmphasis Intense Strong Styles # Find - Replace Select- Font Paragraph 1 Editing Bank Reconciliation: Outstanding Checks : NFS Check: Deposit in transit: Why did you +/- Activate Windows Gulu Sellings to activate Windows PAGE 4 OF 4 960 WORDS ENGLISH (UNTED KINGDOM 10 + 100% 8:27 PM 1/25/2021 O | Ae WE 4 ENG