Overview
In this guide, you’ll learn how to perform a simple one-to-one reconciliation workflow with Blnk. This includes:- Preparing and uploading our data.
- Creating our matching rules.
- Running our reconciliation process.
- Review the reconciliation results.
Prerequisites
Before starting, ensure you have:- A running Blnk server instance (e.g. at
http://localhost:5001
). Version 0.10.0 or later.
Recording sample transactions
First, import the following sample transactions using the Bulk Transactions feature:Request body
Preparing the external data
Next, download the sample CSV file provided below. This file will act as our external data source and has already been formatted to meet Blnk’s specifications. See External Data Preparation for more details.External data source
Click to download sample CSV file.
Uploading the data
Upload your CSV file with the Upload Data endpoint:Response
Save the
upload_id
. You’ll need it to start the reconciliation.Setting our matching rules
We’ll define rules to match internal and external transactions. For this example, we want:- Amount Match: Exact amount match
- Currency Match: Exact matches for both fields.
- Reference Match: Exact matches for both references
Save the
rule_id
for the reconciliation step.Run reconciliation
With the external data uploaded and our matching rules configured, we’re ready to run our first reconciliation. In this example, we’ll use the Batch Reconciliation option and apply aone_to_one
strategy to ensure precise matching.
See Reconciliation Strategies for details.
Send this request to start the reconciliation:
View reconciliation results
Finally, you can view the status of your reconciliation with the following endpoint:Response
Field | Description |
---|---|
matched_transactions | Number of external records matched. |
unmatched_transactions | Number of external records not matched. |
Error handling
-
401 Unauthorized: Ensure your API key is correct and included in the
Authorization
header. - 400 Bad Request: Check your request body or file format. For uploads, ensure the CSV matches Blnk’s specifications.
-
404 Not Found: Verify the endpoint URL (e.g.,
/reconciliation/upload
for uploads,/reconciliation/start
for reconciliation).