Finstem Consulting Bank Reconciliation Solution

Case Brief

The management of Finstem Consulting Ltd engaged us to develop a customized solution that helps streamline and improve the reconciliation of bank statements with general ledger bank accounts.

Solutions

• User Interface Design
• Information Architecture
• Custom Application development

Web Technologies

• PHP
• MySQL
• AJAX
• XHTML, CSS and XML

The Result

A robust and scalable solution was designed and developed for Finstem Consulting. This handles all aspect of Bank Reconciliation, which include but not limited to matching similarity and recording differences between ledger of a company and their monthly banking statement and deposit discrepancies between bank balance and checkbook balance. The solution was equipped with an array of functionality which cater for auto-matching, partial matching, probable matching, normal merge of monthly outstanding transactions, ledger contra merge, statement contra merge, one to many merge of outstanding transactions and OMT merge. Apart from the bank reconciliation statement report being generated from this system other reports that can be produced include the Monthly COT Report, Monthly Overdraft Interest report and the Monthly Credit Interest report