The StruFin team of three professionals worked along with the IT/Automation team to automate the conversion the bank statements to formatted Excel files, which allowed the reconciliation to be done in double-quick time. The Automation team created a Macros to convert the HTML bank statements to excel format which had help the team to the reconciliation faster with control.

The accounting and IT teams worked together to complete the reconciliation and finalization of the books of the 26 companies, across 120 bank accounts, within 3 weeks – signed off on the first presentation. The books were presented with easy to read reports for each company, which made the review process quick and simple for the management. The relevant reconciliation was then also done in Oracle ERP.