Skip to content

Financial actions reports

Last updated: June 08, 2022

Financial actions reports provide an accurate representation of all actions during a payment’s life-cycle that impact your currency account's available balance. Together with the payouts reports, you can reconcile payments and any associated fees against payouts paid out to you.

Understanding the financial impact of each action and any foreign exchange (FX) rates applied also allows you to accurately assess your cost of sale.


Understanding your financial actions reports

The reports come in two forms:

  • Financial actions by date range: contains financial actions across a specified time period.

  • Financial actions by payout ID: contains financial actions related to a specific payout ID—useful when reconciling financial actions with a payout paid out to your bank account.

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.

Both reports feature identical field names and list records chronologically.


Report format

Financial actions reports come in .csv format with the file name following these templates:

  • Financial actions by date range:

financial-actions_{Your Entity-ID}_{Start Date Range:YYYYMMDD}_{End Date Range:YYYYMMDD}_1.csv

  • Financial actions by payout ID:

financial-actions_{Your Entity-ID}_{Payout date: YYYYMMDD}_{PayoutID}_1.csv


When are my reports available?

The availability of your reports depends on the type of financial action report available to you.

Financial actions by date range

These reports are available from 12:00:00 UTC and include any financial actions that impacted your available balance between 00:00:00 UTC and 23:59:59 UTC the previous day.

For example, all financial actions that occur on August 3rd 2020 (from 00:00:00 UTC to 23:59:59 UTC) will be included in the daily financial actions by date range report generated and available from August 4th 2020 at 12:00:00 UTC.

Financial actions by date range can be made available on a daily, weekly or monthly basis.

Financial actions by payout ID

These reports are available from 15:00:00 UTC. The data includes any financial actions that have impacted your available balance and are linked to any settlements created between 12:00:00 UTC the previous day and 12:00:00 UTC on the same working day.

For example, for a settlement created on August 3rd 2020 at 07:00:00 UTC, any financial actions associated to the settlement will be included in the financial actions by payout ID report available on August 3rd 2020 at 15:00:00 UTC.


Report fields

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

Field nameDescription

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

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 financial action impacting your balances.

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 expressed in ISO format in UTC (YYYY-MM-DDTHH:mm:SS:sss).

Processed On

datetime

The timestamp of when the action was processed and had impacted your balances in ISO format in UTC (YYYY-MM-DDTHH:mm:SS:sss).

Processing Currency

string

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

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

Unique ID of the foreign exchange trade executed in fulfilment 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

Two-digit ISO country code of the country where the payment is processed. For example, US.

Learn more about ISO currency codes.

Entity Country

string

Two-digit ISO country code of entity. For example, US.

Learn more about ISO currency codes.

Region

string

The region where this payment occurred. This could be Domestic, EEA, or International.

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 [response codes].(/resources/codes/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.

Optional fields

You can contact your Customer Success Manager to enable one or more additional fields for your reports.

The optional fields you choose are appended to the report in the same order they appear in the table.

Field nameDescription

Transaction Currency

string

The currency of the transaction.

Transaction Currency Amount

decimal

The transaction amount, expressed in the transaction currency.

Processing to Transaction Currency FX Rate

decimal

The foreign exchange rate between the processing currency and the transaction currency.

Transaction to Holding Currency FX Rate

decimal

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.

Sample reports

Select the links below to download sample reports. If you're using Safari, hold the Option key when you download.