Financial Actions by Date Range Report
Last updated: June 4, 2025
The Financial Actions by Date Range Report lists all actions during a payment’s lifecycle that impact your sub-account's Available balance. Understanding the financial impact of each action and any foreign exchange (FX) rates applied helps you accurately assess your cost of sale.
The report contains financial actions across a specified time frame, in chronological order. Every row features a unique financial action ID that can be linked to one of the following:
- A specific payment, using the payment ID
- A settlement payout, using the payout ID
Information
For information about the financial actions available in this report, see Breakdown types.
The report is updated between 3:00 AM and midnight in the settlement time zone you've configured in your entity account. You can generate it on a daily, weekly, or monthly basis.
For example, your settlement time zone is America/Los_Angeles Pacific Time (PT) and financial actions occur on August 3.
The daily report captures all financial movements from August 3 at midnight to 11:59 PM PT.
It is generated at midnight PT on August 4.
See instructions on how to download the report on demand or on a schedule:
The report is provided as a CSV file. The file name uses the following formats by default:
- API and SFTP –
financial-actions_{EntityID}_{Start Date: YYYYMMDD}_{End Date:YYYYMMDD}_1.csv - Dashboard scheduled reports –
financial-actions_{Your Entity-ID}_{Start Date Range:YYYYMMDD}_{End Date Range:YYYYMMDD}_1.csv
For SFTP, the report is uploaded in the following folder structure: {Entity_name} > reports-{Entity_name} > financial-actions > date-range
Download a sample Financial Actions by Date Range Report (CSV file).
Information
If you're using Safari, hold the Option key when you download.
Information
- To enable any optional fields for this report, contact your account manager or [email protected].
- Sub-accounts are referred to as currency accounts in the report fields.
- All decimal amounts are expressed in the major currency unit, with fixed-point notation with up to eight decimal places. For example, 500 USD is represented as
500.00.
The report can include the following fields in this order:
| Field name | Description |
|---|---|
Client Entity ID string | The unique identifier for the entity for which the payment was processed. |
Client Entity Name string | The name of the entity. |
Sub Entity ID string | The unique identifier for the sub-entity for which the payment was processed. |
Sub Entity Name string | The name of the sub-entity. |
Processing Channel ID string | The unique identifier for the processing channel configuration. |
Merchant Category Code string | The merchant's merchant category code. |
Currency Account ID string | The unique identifier for the sub-account the financial action amount was charged to. |
Currency Account Name string | The name of the sub-account. |
Currency Account Custom ID string | The custom identifier for the sub-account. |
Action Type string | The type of financial action. See Breakdown types. |
Action ID string | The unique identifier for the financial action. |
Payment ID string | The unique identifier for the payment the financial action is associated with. |
Requested On datetime | The date and time when the gateway request was made for the financial action, in UTC. |
Processed On datetime | The date and time when the financial action was processed and impacted your balances, in UTC. |
Processing Currency string | The currency the financial action was processed in. |
FX Rate Applied decimal | The foreign exchange rate applied to the financial action. If the processing currency and holding currency are the same, this value is |
Holding Currency string | The currency the financial action is held and paid out in. |
FX Trade ID string | The unique identifier for the foreign exchange trade executed for the financial action. |
Payout ID string | The unique identifier for the settlement the financial action was included in. This is the same value as the settlement ID. |
Reference string | An optional identifier used to track financial actions. |
Payment Method string | The payment method used for the financial action. |
Card Type string | The type of card type used to make the payment. This can be one of:
|
Card Category string | The category of card used to make the payment. This can be one of:
|
Issuer Country string | The country where the card was issued. |
Entity Country string | The country where the entity is registered. |
Region string | The region where the payment was made. This can be one of:
|
MID string | The merchant identifier used to segment your payments traffic with card schemes. |
Response Code string | The response code for the payment request. |
Response Description string | The description of the response code for the payment request. |
Breakdown Type string | The breakdown type of the fee or amount. |
Processing Currency Amount decimal | The amount of the financial action in the processing currency. |
Holding Currency Amount decimal | The amount of the financial action in the holding currency. |
Entity Country Tax Currency string | The currency of the country your entity resides in for tax purposes, if applicable. |
Tax FX Rate decimal | The foreign exchange rate between the holding currency and the tax currency when the financial action was processed. |
Tax Currency Amount decimal | The amount of tax applied, expressed in the tax currency. |
Transaction Currency string optional | The currency of the transaction. |
Transaction Currency Amount decimal optional | The amount of the transaction, expressed in the transaction currency. |
Processing to Transaction Currency FX Rate decimal optional | The foreign exchange rate between the processing currency and the transaction currency. |
Transaction to Holding Currency FX Rate decimal optional | The foreign exchange rate between the transaction currency and the holding currency. This rate is inferred from both the FX Rate and Processing to Transaction Currency FX Rate fields to account for foreign exchange rates from multiple rate ticks. |
Fee Detail string | The additional level of granularity for predicted scheme fees applied. |
Reserve Rate percentage optional | The percentage amount reserved from the payment. |
Reserve Deducted Date date optional | The date and time when the reserve was deducted from the payment. |
Reserve Release Date date optional | For a Rolling Reserve Deducted financial action, the date and time when the reserve is scheduled to be released. For a Rolling Reserve Released financial action, the date and time when the reserve was released. Format – ISO 8601 |
Processing Channel Name string optional | The name of the processing channel configuration. |
Acquirer Reference Number string optional | The unique 23-digit identifier for the payment as it moves through the payment flow between your bank and the cardholder’s bank. |
Account Funding Transaction string optional | A flag that the transaction debited funds from an account to fund a non-merchant account. For example, to load a prepaid card or add funds to a wallet. |
Entity Segment string optional | The name of the entity segment the payment is tagged to. |
Issuing Bank string optional | The bank that issued the card used to make the payment. |
BIN string optional | The identifier for the financial institution that issued the card. |
Payment Type string optional | The type of card payment used for the card-not-present (CNP) payment. For example, for a recurring payment or mail order. This value can be one of:
|
Requested On UTC Datetime optional | The date and time when the financial action was requested, in UTC. |
Processed On UTC Datetime optional | The date and time when the financial action was processed, in UTC. |