Reporting and reconciliation
A range of reports is available containing information about payments and accounts. Each report’s detailed documentation includes:
- Use case and purpose
- API endpoints and parameters
- Field specifications
- Technical limitations
Data Retention PolicyOnly data from the current and previous year is available in the reports. Older data is available upon request.
Report Access Methods
Reports can be accessed in two ways:
1. (Obsolete) Direct API Access (Synchronous)
Most reports are available through direct API endpoints. When using direct access:
- Reports are downloaded immediately if available
- There is typically a limit of 50,000 payments per report
- Best for real-time access and smaller datasets
- Uses GET endpoints for immediate retrieval
2. Cursor-based Pagination (Synchronous)
Some reports are available through synchronous GET endpoints that support cursor-based pagination. This method is designed for retrieving larger result sets in smaller, sequential pages while maintaining immediate access to available data. When using cursor-based pagination:
- Reports are retrieved synchronously, one page at a time
- Pagination is based on cursors returned from a previous response
- The initial request can define page size and sort order
- Subsequent requests must use the returned cursor to navigate forward or backward through the result set
- Best for larger datasets that need to be processed incrementally without submitting an asynchronous report request
- Uses GET endpoints with cursor-based pagination support
3. Reports on Request (Asynchronous)
Some reports (marked as "via reports on request") require using specific request endpoints. This method:
- Initiates a report generation job that you can poll for completion
- Supports larger datasets exceeding 50,000 payments
- Better for bulk data retrieval and historical reports
- Uses POST endpoints to request generation, followed by polling for completion
Report Types
Our reports are organized into the following categories:
Cash Management Reports
These reports provide detailed information about transactions and balance movements on your accounts.
Report Name | Description | Available Formats | Documentation |
|---|---|---|---|
Bank To Customer Account Report | Provides a comprehensive, structured intraday data of account activity for reconciliation, cash management, and financial reporting. | JSON, CSV, CAMT.052 | |
Bank To Customer Statement | An End-of-day statement that provides detailed information about the transactions and balances on specified accounts for a given day. It includes credits, debits, opening and closing balances, and transaction metadata, allowing reconciliation of account activity and monitoring of cash flow. | CAMT.053 | |
Bank Statement | Provides a PDF-formatted account statement that includes company details and transaction information for audit and regulatory purposes. This report is designed for formal documentation requirements and external reporting needs. |
Payment Status Reports
Reports designed to provide visibility into a payment throughout its lifecycle.
Report Name | Description | Available Formats | Documentation |
|---|---|---|---|
Customer Payment Status Report | Provides information on the processing status of previously submitted payment or direct debit instructions. It informs whether the individual transaction has been accepted, rejected, or is pending processing. | JSON |
Reconciliation Reports
These reports help you reconcile account movements and transactions.
| Report Name | Description | Available Formats | Documentation |
|---|---|---|---|
| Reconciliation Report | Account movements for a given date or date range | JSON, CSV | Learn more |
| Paged Reconciliation Report | Single-day reconciliation data in paginated format | JSON, CSV | Learn more |
| Paged Intraday Reconciliation Report | Intraday movements with specific time ranges | JSON, CSV | Learn more |
Exception Reports
These reports help you track and manage payment exceptions.
| Report Name | Description | Available Formats | Documentation |
|---|---|---|---|
| Rejection Report | Details of unprocessed or rejected payments | JSON, CSV | Learn more |
Other Reports
| Report Name | Description | Available Formats | Documentation |
|---|---|---|---|
| Held Payments – Sanctions Screening report | Provides details of all payments, which are held in sanctions screening | JSON, CSV | Learn more |
