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 Policy

Only 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

Learn more

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

Learn more

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.

PDF

Learn more

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

Learn more

Reconciliation Reports

These reports help you reconcile account movements and transactions.

Report NameDescriptionAvailable FormatsDocumentation
Reconciliation ReportAccount movements for a given date or date rangeJSON, CSVLearn more
Paged Reconciliation ReportSingle-day reconciliation data in paginated formatJSON, CSVLearn more
Paged Intraday Reconciliation ReportIntraday movements with specific time rangesJSON, CSVLearn more

Exception Reports

These reports help you track and manage payment exceptions.

Report NameDescriptionAvailable FormatsDocumentation
Rejection ReportDetails of unprocessed or rejected paymentsJSON, CSVLearn more

Other Reports

Report NameDescriptionAvailable FormatsDocumentation
Held Payments – Sanctions Screening reportProvides details of all payments, which are held in sanctions screeningJSON, CSVLearn more