Engineers
Months
A SAAS automates tedious financial reconciliation processes. One of the largest tax advisory firms in India wanted to build an app that could automate the reconciliation process. We built an independent, fully integrated app that automated the process of identifying mismatches between large sets of accounting data, and simplified the management of these exceptions.
Reconciliation is an accounting process that compares two sets of records to check that figures are correct and in agreement. Account reconciliation requires manual analysis of huge amounts of data — often tens of thousands of transactions — to ensure consistency.
The client, one of the largest tax advisory firms in India, wanted to build an app that could automate the reconciliation process. It was to be developed as a SAAS product that could be offered to financial institutions and other large firms. The app was required to filter transactions from Excel or CSV files generated by accounting software, reconcile them, and handle all exceptions seamlessly.
The requirements were very high level and the scope of the project was not well defined. Our teams worked extensively to develop the idea, find solutions and create a detailed set of requirements. New requirements emerged throughout the project but were incorporated seamlessly thanks to our agile process.
We built an independent, fully integrated app that automated the process of identifying mismatches between large sets of accounting data, and simplified the management of these exceptions. The powerful app included the following features:
1. Fully automated reconciliation using Excel or CSV files from any accounting software
2. Exception management as per user-defined parameters
3. User management and login based on approval flow: Super Admin, Client Admin, Preparer, Reviewer, and Approver
4. Rolling recon: Recon data is saved and rolled to the next cycle, so users can address pending exceptions
5. Customisable dashboard that allows users to visualize the reconciliation data using bar graphs and pie charts for analysis and forecasting
With the file automation module customer could upload their financial data in an xls/csv format. The system automates the conciliation process and places the transactions in proper financial segments.
With the help of this module, the system detects any exceptions on the transactions based on user-defined parameters.
A customizable dashboard module was built, so that user can seamlessly view their progress as per their requirement.
1. Smart Recon reduces reconciliation time for 10 GB of financial data from a week to 4 hours
2. Human errors are minimized
3. Different data sets are matched automatically, so other parties don’t need to clean up the data
4. Rolling Recon function allows pending exceptions to be addressed without any rework
5. User management and approval flow prevents unauthorized usage, maintains quality control
6. Minimum APIs ensure exceptional performance and optimized database handles massive amounts of data effortlessly
