Financial data reconciliation

Project Type: Application Development

Industry: ATM management
Customer: Athena Industries llc

Business Challenge

One of our clients – ATM management company, was looking for a solution capable of gathering and reconciling vaulting data from several sources. Business workflow required major upgrade, as existing one consisted of several manual steps, including information flow from multiple vaulters and manual data reconciliation (using Excel) against data received from banks and 3-rd parties ATM reporting tools. After short business analyzing phase, Sprinterra proposed Terravault – fully automated solution for ATM management.

The biggest challenge was to build a simple and user-friendly page for the vaulters who work in the field and do not have any extra time. This was accomplished in several phases: starting with a list of ATMs shown to each vaulter for manual input and evolving into a weekly vaulting plan, providing easy 1-click reporting. Vaulting plan also helped managers to improve planning processes and simplify communication of planned transactions to vaulters.

Another big challenge was related to information gathering from 3-rd party sources. We have developed an ETL process to parse incoming files from particular FTP location and load data into Terravault database.

We used Django on Python for the web application and JasperReports for reporting. This approach helped us minimize our efforts and deliver the MVP in less than 2 months which was crucial deadline for our client.

Solution

The system is pretty simple and consists of few sets of pages, based on user role – vaulters are being redirected to corresponding page with their vaulting plan, managers are redirected to reporting part of application, managers/administrators have access to planning pages as well.

Project Highlights

• Vaulting planning / confirmation of vaulted amounts
• Confirmation of received cash
• ETL process for the 3-rd party data
• Reporting