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, and 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.
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. This feature is not available for merchants using Elavon.
Updates
Bank reconciliation refreshes every weekday with the latest transaction information. You can see the last time details were received by Blink at the top of the screen.
Filters
The filters available are
Date - Batch (Funding) date
MID - For merchants with multiple acquirer MIDs
Exports
You can export the reconciliation data to CSV to add 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, along with 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