Account reconciliation is defined as the process of comparing two related sets of financial records to find out if they are in agreement. It is an important internal control measure aiding entities for a smooth financial close and is mandated by various regulations such as the Sarbanes-Oxley Act in the US.
Businesses are required to reconcile all their balance sheet accounts to find out possible account misstatement. Timely reconciliation of balance sheet accounts allows entities to identify discrepancies and make necessary adjustments in the general ledger in a timely manner, ensuring the completeness and accuracy of financial statements.
Reconciliation of accounts can be done in different ways including manual reconciliation and the use of account reconciliation software. In this article, we will discuss various methods of account reconciliation along with their pros and cons.
Account reconciliation is normally carried out after the close of a financial period. Here are the steps involved in a general ledger reconciliation process:
Unlike earlier times, reconciliation cycle times in financial institutions have increased and processes have become inefficient, and costly today. It is difficult to manage and reconcile the growing size and complexity of data and adhere to ever-growing regulatory requirements. Regulations such as Basel III, Dodd-Frank and MiFID II mandate increased depth and breadth in the reconciliation process.
Given the situation, age-old reconciliation methods and rules-based solutions are poised to become ineffective and prone to numerous errors. Here, we will list out various reconciliation methods and find out their advantages and disadvantages.
This is the traditional way of account reconciliation with written accounts and dedicated staff. Here, accountants manually check all the written accounts to see if all entries are matching. While smaller firms with a limited amount of transactions can still employ this strategy. For large businesses, this method is no longer feasible in today’s scenario due to the ever-increasing data volumes.
This is done by using spreadsheet software solutions that have basic data arrangement and calculation features. A great tool for data analysis and streamlined calculations, spreadsheets are still used by a large number of organisations. In fact, recent studies suggest that almost 70% of the world’s financial institutions still use Microsoft Excel for reconciliation processes.
Spreadsheets, on the other hand, are not sustainable in the long run for the following reasons.
Through partially automating reconciliation processes, these software solutions could greatly reduce errors that came via manual processing. They could address matching of transactions more effectively with pre-set business matching rules and create cases around exceptions/breaks which need human intelligence to reconcile. These solutions can remove almost half of the costly and time-intensive manual intervention required in reconciliation.
Rule-based solutions generally lack in the following aspects:
There are also reconciliation software solutions powered by modern technologies such as artificial intelligence (AI) and machine learning (ML). These modern reconciliation software solutions came into play to address the drawbacks of rules-based solutions. Mixing and matching certain attributes of data across multiple files will help match records. It is not manually possible to figure out attribute-mix and create that many rules.
AI/Machine Learning can automatically identify attribute-mix/pattern and create rules for matching. They can also do exception handling, a key reconciliation process, which is completely manual today. The main advantages of these solutions are:
Thus, these new-age solutions can address the problems of rules-based solutions and make the reconciliation process more efficient. Solutions such as Tookitaki Reconciliation Suite are horizontally scalable to move hand-in-hand with ever-growing data sets and support flexible deployment options to minimise the cost of deployment.
By and large, they provide centralised control, better monitoring, operational cost savings, increased effectiveness and efficiency, better accessibility, improved data security and reduced audit risks.
In comparison to rules-based solutions, our solution goes a step ahead and enables completely automated reconciliation, while providing superior accuracy in matching and effective exceptions management.
Speak to a member of our team today to learn more about our market-leading reconciliation solution.