Financial Actions by Date Range Report
Last updated: July 10, 2024
The Financial Actions by Date Range Report lists all actions during a payment’s lifecycle that impact your currency account's available balance.
Understanding the financial impact of each action and any foreign exchange (FX) rates applied also allows you to accurately assess your cost of sale.
The report contains financial actions across a specified time period, in chronological order. Every row features a unique financial action ID that can be linked to a specific payment, using the payment ID, or a settled payout, using the payout ID.
This report comes in CSV format, with the file name using the following the template:
financial-actions_{Your Entity-ID}_{Start Date Range:YYYYMMDD}_{End Date Range:YYYYMMDD}_1.csv
The report is updated between 03:00:00 and 12:00:00 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, if you've set the settlement time zone to America/Los_Angeles
Pacific Time (PT) and financial actions occur on August 3, 2023, the daily Financial Actions by Date Range Report captures all financial movements from August 3, 2023, at 00:00:00 to 23:59:59 PT. This report is generated at 12:00:00 PT on August 4, 2023.
Download a sample Financial Actions by Date Range Report (CSV file)
Information
If you're using Safari, hold the Option key when you download.
Decimal fields with monetary amounts are expressed in their major currency unit, with up to 8 decimal places. For example, an authorization fee of $0.10 will be expressed as 0.1
Information
To enable one or more additional fields for your reports, contact your Account Manager.
The optional fields you choose are added to the report in the same order they appear in the table.
Field name | Description |
---|---|
Client Entity ID string | The unique ID of the entity for which the payment was processed. |
Client Entity Name string | The name of the entity for which the payment was processed. |
Sub Entity ID string | The unique ID of the sub-entity for which the payment was processed. |
Sub Entity Name string | The name of the sub-entity for which the payment was processed. |
Processing Channel ID string | The unique ID for processing channel configurations. |
Merchant Category Code string | The four-digit code for retail financial services expressed in ISO 18245 format to classify the types of goods or services provided by you. Learn more about MCCs. |
Currency Account ID string | The unique ID of the currency account to which the financial action amount was charged. |
Currency Account Name string | The name of the currency account to which the financial action amount was charged. |
Currency Account Custom ID string | The custom ID of the currency account to which the financial action amount was charged. |
Action Type string | The type of action processed. For example, authorization, capture, refund, chargeback, pay to card. |
Action ID string | The unique ID for a given action impacting your balances. For example, |
Payment ID string | The unique ID for the payment to which a financial action is associated. |
Requested On datetime | The timestamp of when a gateway request was made for an action, in ISO format in UTC ( |
Processed On datetime | The timestamp of when the action was processed and impacted your balances, in ISO format in UTC ( |
Processing Currency string | The three-digit ISO currency code of a financial action when processed. For example, USD for dollars. Learn more about ISO currency codes. |
FX Rate Applied decimal | The foreign exchange rate applied to a processed financial action. |
Holding Currency string | The three-digit ISO currency code of the currency a financial action is held and paid out in. For example, USD for dollars. Learn more about ISO currency codes. |
FX Trade ID string | The unique ID of the foreign exchange trade executed in fulfillment of a financial action. |
Payout ID string | The unique ID of the payout in which the financial action was included. |
Reference string | An optional ID used to track financial actions. |
Payment Method string | The payment method associated with the financial action. |
Card Type string | The card type used to make the payment. For example, credit or debit card. |
Card Category string | The card category used to make the payment. For example, consumer or commercial. |
Issuer Country string | The two-digit ISO country code of the country where the card was issued. For example, US. Learn more about ISO currency codes. |
Entity Country string | The two-digit ISO country code of a client entity. For example, US. Learn more about ISO currency codes. |
Region string | The region where this payment occurred. This could be Domestic, International, Intra, IntraEEA, or IntraEuropean_SEPA. |
MID string | An optional merchant ID used to segment your payments traffic with card schemes. |
Response Code string | The response code of the payment request. Learn more about API response codes. |
Response Description string | A description of the response code of the payment request. |
Breakdown Type string | A description of the type of fee or amount. For example, authorization fee. |
Processing Currency Amount decimal | The associated amount of the financial action in the processed currency. |
Holding Currency Amount decimal | The associated amount of the financial action in the held 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 at the point 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 transaction amount, 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 columns 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 the reserve was deducted from the payment. |
Reserve Release Date date optional | The date the reserve is either:
|
Processing Channel Name string optional | The name for the processing channel configurations that determine how payments are routed and processed. |
Acquirer Reference Number string optional | The unique number assigned to a transaction when it moves through the payment flow between the merchant bank and the cardholder’s bank. |
Account Funding Transaction string optional | A flag to mark if a transaction debited funds from an account to fund a non-merchant account. For example, to load a prepaid card or top up 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 timestamp of when the action was requested in ISO format in UTC ( |
Processed On UTC Datetime optional | The timestamp of when the action was processed in ISO format in UTC ( |