Skip to main content
When transactions happen, you usually end up with two sets of records:
  • Internal records: Your ledger.
  • External records: Bank statements, card statements, payment processor statements, etc.
Reconciliation is the process that compares both records, matches them, identifies where they disagree. You then get a head start on identifying the root cause of the discrepancy and correcting it where necessary.

​
Before you start,

You need to do three things first:
  • Upload your external data: This is the data you want to compare against your ledger. We support CSV and JSON, but the file must follow our required format for reconciliation to work.
  • Set your matching rules: This tells Blnk how to match the two sets of records. For example, you can say that any entries with the same description, amount, and date in both files represent the same transaction and should be matched.
  • Define your reconciliation strategy: This tells Blnk how transactions are distributed between the two records. For example, one transaction in your ledger could correspond to one transaction in the external data (one-to-one).

External data

Prepare external data for reconciliation.

Matching rules

Rules for matching ledger and external records.

​
Run a reconciliation

To run a reconciliation: Run reconciliation
  1. Go to the Reconciliation page from your sidenav.
  2. Click on Run reconciliation on the top right corner.
  3. From the side panel:
Blnk starts the reconciliation right away and redirects you to the reconciliation table. Depending on the size of your data, the process can take anywhere from a second to a few minutes.

​
View reconciliation details

Once a reconciliation is completed, you can view its results from the reconciliation table. Reconciliation summary details To view its details, click on the reconciliation run you want to inspect, then click Full info at the top right of the side panel.

​
Summary section

The summary section gives you a quick overview of the reconciliation run.

​
Matched transactions

This section lists an overview of the external transactions matched to internal transactions. Click View ledger transactions to see all of the matched transactions and their individual reconciliation details. Reconciliation matched transactions When you view a transaction details page, you can see at a glance if it has been reconciled or not. For more information about its reconciliation, you can view its reconciliation metadata:

​
Unmatched transactions

This section lists the external transactions that had no matching internal transaction. Click Export as CSV to download a CSV file of the full list. Unmatched transactions

​
Need help?

We are very happy to help you make the most of Blnk, regardless of whether it is your first time or you are switching from another tool. To ask questions or discuss issues, please contact us or join our Discord community.