Reports overview
We offer a variety of different reports that contain information about your payments and accounts which can be retrieved via our Reporting API.
| Report | Description | Available format |
|---|---|---|
| Account activity report | Provides details of all bookings on a specific account within a given date range | JSON, CSV, MT940 |
| Paged account activity report | Provides details of all bookings on a specific account within a given date range, in a paginated version | JSON, CSV, MT940 |
| Account balance report aka Current balance report | Provides a list of all your accounts and their balances at the exact time the report is requested. | JSON, CSV |
| Reconciliation report | Provides details on all your account movements at the given date, or within a date range | JSON, CSV |
| Paged reconciliation report | Provides details on all your account movements at the given date in paginated version | JSON, CSV |
| Paged intraday reconciliation report | Provides details on all your account movements during the day or end of the day, at the given date, or within a date range, in paginated version | JSON, CSV |
| Rejection report | Provides unprocessed payments on a specific date | JSON, CSV |
| Bank statement report (Only via reports on request) | Provides the same data as the Account activity report. It includes our and your company details and can for example be used for audit purposes | |
| End-of-day balance report (Only via reports on request) aka Company account balance report | Provides a list of your accounts and their end-of-day balances on a specific date. The PDF version includes our and your company details and can for example be used for audit purposes | PDF, CSV, JSON |
| Bank to customer report (camt.053) | Provides details of all processed payments on all your accounts on the requested EOD in ISO standard CAMT053.001.02. | XML |
Note: Only data from current and previous year is available in the reports
Please contact our Client Services team to access older data
Account activity report
The account activity report endpoint contains details regarding all activity on the account, within a selected date range.
There is currently a limitation of 50,000 payments per report in this version. If you need a report for more than 50,000 payments on your account, a paginated endpoint is available, see below.
The MT940 is following SWIFT reporting standards:
{1:F01A1111111111}{2:O940XXXXXXXXXXXXN}{3:{108:XXXXXXXXX}}{4: Header
:25: Account id (IBAN)
:28C: Statement number, unique for each statement
:60F: Opening balance: C/DYYMMDDCCYAMOUNT
:61: Transaction: VD, TD, D/C ,AMOUNT ,TYPE ,BC Connect unique reference
:86: Transaction Information: counterpart name, counterparty address, counterparty account, remitter information line 1,2,3,4
:62F: Closing balance: C/DYYMMDDCCYAMOUNT
Paginated account activity report
The account activity report is available in a paginated version to allow a larger number of rows to be included in the report. Content of the file remains unchanged and above specification can be used.
Account balance report
The account balance report endpoint returns a report detailing all of your account balances at the exact time the report is requested.
Reconciliation report
The reconciliation endpoint is used to generate a report containing relevant information on all your account movements at the given transaction date, or within a transaction date range. The report can be used to perform financial reconciliation of bookings during the day, or at end-of-day. Note that the report does not allow you to specify timeframes – for this purpose we recommend using the paged intraday reconciliation report.
The report is available in CSV and JSON format. There is a limitation of 50,000 payments per report.
If the desired number of payments exceeds these limitations, you will need to use the paginated reconciliation endpoint.
Paginated reconciliation report
The reconciliation report is also available in a paginated version, to allow for a larger number of rows to be included in the report.
Date ranges not supported
The paginated version does not support date ranges, and will instead include data for the day requested and not a date set.
Paged intraday reconciliation report
The paged intraday reconciliation report is used to generate a report containing relevant information on all your payments at the given transaction date, within a specific time range indicating the time the transactions were created in the system. The report can contain one or all your accounts. The report can be used to perform reconciliation of transactions during the day.
Rejection report
The rejection report endpoint provides details of any payment that could not be processed on the selected transaction date. By default, the report contains any payments in the following status:
- Missing funding
- Pending processing
- Rejected
If all payments have been correctly processed, the report will be empty.
Payments in status 'missing funding' will be included in the report for 2 days, after which unless the balance of the account is funded for the amount required to process the payment, they will be sent to rejections.
End of day balance report/Company account balance report
The end of day balance report is used to generate a report detailing all of your account balances for date in the past. The report is available in JSON, CSV and PDF format and can be accessed via reports on request end point for company account balance report.
This report can be fetched for a specific account or list of accounts of a given company id for a specific date.
Bank statement report
The bank statement report is available in PDF format only, which gives similar details as account activity report by displaying transactions information for a specific account within given date range. This report can be accessed via reports on request endpoint bank statement report
Updated 2 days ago