You have been asked by a school to help automate their accounts processing. Every few days they receive a text file from the bank detailing payments received (BPAY sheet). This information must be matched to the system data that has been downloaded into Excel (SYS DATA sheet) and a report produced that will be uploaded to the school system.
1. Question 1 You have been asked by a school to help automate their accounts processing. Every few days they receive a text file from the bank detailing payments received…