Reconciliation and its importance

No matter the size of your business, reconciliation is one of the principal accounting issues for finance teams that takes a life of its own. Let’s find out why reconciliation is important for your company and what are the fundamental challenges associated with this internal control mechanism.

What is payment reconciliation and why is it so important?

The reconciliation process commences with files sent from acquirers to merchants, which contain all the processed transactions and the fees applied to each transfer. Subsequently, financial accountants utilize these files to match them against the company’s bank statements and/or transaction records.

Reconciliation constitutes an essential component of the reporting cycle, provides the complete picture on your business’ cash-flows, helps you to identify discrepancies and is a key indicator of a firm’s financial integrity. Overall, reconciliation is essential for faultless, cost-effective, prompt and compliant financial reporting and business planning.

Have you really received all of your money?

Before starting reconciliation it is crucial to first verify that the reconciliation files you have received from your bank are error-free. This entails making sure that the bank has not made any errors and that all of your money is paid out. This first step is especially crucial for service providers and e-commerce companies that are working with digital goods, as the lack of physical inventory makes it difficult to validate whether the amounts received actually match the services provided. Particularly, if you do not have extensive knowledge in payments or full visibility of all the transactions, you need to be aware that mistakes can happen. Hence, it is important to make sure that you have a good overview of the received payments, which can be achieved with a proper gateway technology, in order to eliminate the mistakes that could have been made by other parties.

Why is payment reconciliation such a challenge?

After you have validated that the money you have received matches against the services you have provided, you can continue with the reconciliation process. At first glance, payment reconciliation might appear to be a straightforward process, nevertheless, the process presents many challenges to the accountants and analysts. In fact, for small firms reconciliation ranks among the top three operational activities that demand most time and energy, while for large organizations this is the fifth most cumbersome activity. These challenges arise from having multiple acquirers, the different time frames of payment methods, diverse file formats, and refunds.

Now let’s take a closer look at all of the above-mentioned issues and how you can solve them.

Multiple acquirers, time-frame policies and file formats

Utilizing multiple acquirers is a common practice for both small and medium-sized enterprises. There are various benefits associated with having multiple acquiring relationships, such as cascading, robustness, reduced fees, and many other advantages. However, most acquirers have unique fee and settlement structures and while intelligent routing can aid in efficient fee distribution, this underlying structure heterogeneity complicates reconciliation.

Furthermore, different acquirers have various practices for sending reconciliation files, for instance via APIs, SFTP or email, and all of these files arrive at different times, based on the payment methods. For instance, reconciliation files for transactions based on iDeal and Giropay normally arrive within a few days, while files for credit card transactions arrive weekly or every other week. Lastly, the files are often sent in various formats such as Excel, CSV, PDF or even Text, which constitutes another tedious task for merchants of converting the files. Evidently, reconciliation files arrive at different time points and in bits, which makes reconciliation even more time consuming and convoluted.

Refunds and chargebacks

In the era of digital transactions, consumers value prompt refunds and hence businesses have recognized the significance of timely refunds in supporting their customer value proposition. However, refunds and chargebacks also add another layer of complexity to reconciliation, as expediting a refund without reconciling it first can substantially increase a company’s financial risk. For instance, fraudulent transactions or refunds for payments that did not go through in the first place can cause appreciable losses and require much effort to resolve. Moreover, refunds and chargebacks create a tangle of confusion between bank statements and reconciliation files, which the finance department is left to sort out.


In conclusion, it is vital to first ensure that reconciliation files are error-free and that you have collected all of your money. Moreover, payment reconciliation in itself poses many challenges and it is evident that a higher degree of automation can make the process more efficient. Therefore, one first needs a convenient mechanism to gather all of the reconciliation files from different acquirers and payment methods into one place. Thereafter, one should adopt a standard format to convert and consolidate all of the dispersed files into a single file. This file can now be utilized by the accountants for reconciliation.

No more unmatched transactions or missing funds!

Wouldn’t it be great if payment reconciliation could be done in a single click? WL Payments offers Automated Reconciliation as a part of our Payment Gateway service. Reach out to us at [email protected] to find out more about these features.