Bank reconciliation
- Yash Aryan (Unlicensed)
- Sara Jacobs
- Jack Bickerstaffe (Unlicensed)
Bank reconciliation
Overview
The Bank reconciliation page is a feature that enables you to match up the transactions you have made with the payment batches you have received from the acquirer on your bank account. Using Blink, you can view a list of all payments made from the acquirer, which can then be broken down into individual transactions. This includes details of refunds and service charges.
Navigation
Navigate to the Bank Reconciliation page by clicking on Transactions and selecting Bank Reconciliation from the left-hand navigation bar.
This feature is only available for live accounts.
How to use
Choose between the 2 viewing options.
The table displays the latest batches that have been funded by the acquirer. It includes the name of the acquirer that funded the batch, the date on which the funding was carried out, your unique Merchant ID (MID) for the acquirer, which may be more than one, the amount that was funded, and a View button to access more details.
If you click on the View button, a table will open either on the right side of your screen or as a pop-up. This table will show you the list of transactions that belong to the selected batch, including refunds. You will be able to see the Transaction date, Card brand, and Amount for each transaction. At the top of the table, you will find the information on the selected batches. Below that, you will see the Transaction amount, which is the total sum of all transactions in the batch, Refund, which is the total amount of refunds processed in this batch, and any Merchant Service Charges included by the acquirer in this batch.
Bank Reconciliation
AIB Specific
If you use AIB as your acquirer, you can access additional transaction data such as the Auth code, Terminal ID and Card type by selecting the drop-down icon.
Updates | The bank reconciliation process updates every weekday to display the most recent transaction data. This means that you can view Monday's transactions on Tuesday, Tuesday's transactions on Wednesday, and so on. You can check when the latest information was received by Blink by looking at the top of the screen. |
Filters | The filters available are
|
You can view individual transactions, their batch funding dates and total batch amount on the “All Card Transactions” page.
Export to CSV
You can find the Export to CSV button located at the top right corner of the page. This button allows you to export reconciliation data to a CSV file and add it to your database or accounting software.
To export, you must first filter the batches by date. After clicking on the export button, a prompt will appear, asking you to enter an email address to which to send the overview. The email field will already be filled with the email address associated with your account, but you can modify it if necessary.
After you click the Submit button, an email will be sent to you once the export process is complete. The email contains a link that you can use to download the CSV file. When you click the download button, you will be prompted to log in to Blink. Once you successfully log in, the download process will begin.
The CSV file is a list of all the transactions and their batch details. It has eleven columns:
MID | Transaction date | Transaction time |
Card brand | Transaction amount | Transaction currency |
Batch funding date | Batch funding amount | Batch funding currency |
Merchant service charge (of the batch) | Batch type |
|