Facility management company (Data Automation)

May 6, 2022
Facility management company (Data Automation)

Overview

A facility management company had a system set for reconciliation and account receivables/ payables. The current process is a poor set up and needed automation to get the right reconciliations at right time.

Challenge

The payment data were distributed across multiple csv’s, pdf’s, flat files etc. Cleaning the format of the files was time consuming and error prone, the data was then fed to the automated workflow. Although that was automated, the data wasn’t in right format causing the wrong reporting.

Implementation

Firstly, the folders were put into standard format so that it becomes a centralised repository for all the workflows extracting the data. All the flat files had different format, brought to one standard format using automation. Various calculations were used to reference one transaction to another which create an audit trail to the missing accounts. The differences of these accounts, if more or less than zero were reported in a different file. The financial controller would use these files to check if the payment dues whether its account receivables or accounts payable and then forward to the necessary parties.

Benefits Achieved

  • Zero error margin
  • Saved 180 hours annually
More Case Studies
Local Supermarket (Data Automation)
Overview A local supermarket had issues with cash inflow/outflow analysis. The owner wanted to ensure that the transactions are recorded […]
Audit company (Data Automation)
Overview An audit company was digitizing auditing by automating using data analytics solutions. Due to the nature of the work, […]
Event management company (Data Automation)
Overview: An event management company hosts at least 4 big events every quarter. In each of these events, at least […]
It’s free and easy to post your project

Get your data results fast and accelerate your business performance with the insights you need today.

close icon