Bank Reconciliation
Overview
Bank Reconciliation allows you to reconcile the transactions you have made with the payment batches you have received from the acquirer to your bank account. Blink will list every payment made from the acquirer, which can then be broken down into individual transactions - including the details of refunds and service charges.
Navigation
Navigate to your Bank Reconciliation page to Bank Reconciliation under the Transactions tab on the left-hand navigation bar.
This feature is only available for live accounts.
How to use
The table on the left shows the most recent batches that the acquirer has funded. It shows which acquirer is funding, the date the funding took place, your Merchant ID (MID) for the acquirer (you may have more than one), the amount funded, and a View button.
Clicking on the View button will open up a table on the right side of the screen with the list of transactions that make up the selected batch, including refunds. You can see the Transaction Date, Card Brand, and Amount for each transaction. The top of the table shows the selected batches' information. Below that is displayed the Transaction Amount - the sum of all transactions in the batch, Refund - the total amount of refunds in this batch, and any Merchant Service Charges that the acquirer included in this batch.
Bank Reconciliation
AIB Specific
If you use AIB as your acquirer, you can select the drop-down icon to see additional data for each transaction, including the Auth Code, Terminal ID and Card Type.
Updates | Bank reconciliation refreshes every weekday with the latest transaction information. This means you will be able to view Monday’s transactions on Tuesday etc. You can see the last time details were received by Blink at the top of the screen. |
Filters | The filters available are
|
You can filter your data by individual transactions on the “All Card Transactions” page. Allowing you to look at a single transaction and its Batch funding date and amount funded.
Export to CSV
You can export the reconciliation data to a CSV file, allowing you to add the data to your database or accounting software. The Export to CSV button is at the top right corner of the page.
Before exporting, you need to filter the batches by date. Once you click on the export button, you will be prompted to enter an email to send the overview. The field will be prefilled with the email associated with your account, but you can change the email.
After clicking Submit, you will receive an email once the export is complete. You will find a link to download the CSV file in the email. When clicking the download button, you will be prompted to login into Blink. Once the login is authorised, the download will take place.
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 |