Transaction Report
Definition
- The Transaction Report is a structured record of all transactions processed through the platform.
- It enables clients to review, reconcile, and audit payment activity associated with their settlement accounts.
- The report provides transparency over transaction flows, including statuses, amounts, fees, and counterparties.
How to Create the Report
At present, Transaction Reports can only be generated through the Client Portal:
- Open a Settlement Account details
- Navigate to the Report Reconciliation section.
- Create a new report by specifying the desired parameters (e.g., date range, transaction type, etc).
For a step-by-step guide, refer to the Client Portal Reconciliation Guide.
File Format
The Transaction Report is generated in CSV format with the following settings:
| Format Option | Value | Example |
|---|---|---|
| Data Separator | ; | field1;field2 |
| Decimal Symbol | . | 1000.00 |
| Date Format | dd.mm.yyyy | 2025-07-21 |
| Time Format | HH:MM:SS | 14:30:55.000 |
List of Fields
Below is the list of fields included in the report along with their descriptions:
| Field Name | Description | Example |
|---|---|---|
| transaction_id | Unique identifier for the transaction | 205630902832295855 |
| transaction_type | Type of transaction (e.g., payment, refund) | PAYMENT |
| auth_amount | Authorised amount of the transaction before any fees or conversions | 1157.39 |
| auth_currency | Currency in which the transaction was originally authorised (ISO 4217) | CAD |
| cost_amount | Final settled amount after fees and currency conversion (if applicable) | 17.36 |
| cost_currency | Currency in which the transaction was settled (ISO 4217) | USD |
| status | Final status of the transaction (e.g., CAPTURED, PAID_OUT) | CAPTURED |
| transaction_datetime | Date and time when the transaction was processed (UTC) | 2025-07-21T01:24:22.000 UTC+00:00 |
Time Zone Clarification
- The time zone for the Transaction Report is defined at the moment of report creation.
- This time zone is used to determine the time window for collecting transactions, with all date and time filters applied according to the selected time shift.
- All timestamps included in the final report (e.g., transaction_datetime) reflect this defined time zone and are not converted to UTC.
- Consumers of the report should interpret all time values based on the selected time zone during report generation.
Sample File
You can download a sample CSV file here to preview the structure and formatting of the report.
Updated 3 days ago
Useful links