Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Current »

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

The table on the left shows the most recent batches funded by the acquirer. 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

  • Date - Batch (Funding) date

  • MID - For merchants with multiple acquirer MIDs

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

  • No labels