Balance activity report
The Balance activity report is a detailed record of all settled transactions that affect the balance of your Airwallex account. This report helps you to track changes to your account balance and reconcile the balance at the end of each month.
Note that this report only includes transactions that have settled in your Wallet. Pending transactions (like card purchases) that might affect your available balance won't appear until they're settled.
The Balance activity report is currently on version 1.1.0, released in August 2024. Enhancements made in v1.1.0 to improve the usability of the reports include:
- Fees for payout transactions created after August 21, 2024 will be recorded as a separate balance change.
- When creating a report for multiple currencies, conversions will be shown as two records, one recording the debit in the sell currency and the other recording the credit in the buy currency.
- Amounts for batch settlements now show the change in your Account balance, consistent with other transaction types, enabling accurate reconciliation of your Account balance.
- New Reference and Note columns.
For details on the legacy version, see Balance activity report v1.0.0.
Report data
You can download the report in CSV, Excel and PDF formats. You have the flexibility to download the report for a single currency or for all currencies, and to filter based on the transaction type.
| Field name | Description |
|---|---|
| Time | The time of the balance change (in ISO 8601 format). |
| Type | The type of the transaction that led to this balance change. For example, PAYOUT, CONVERSION or CARD.
|
| Financial Transaction Type | The type of the financial transaction that changed the Account balance. For example PAYOUT, CONVERSION_SELL or CARD_PURCHASE. One transaction can involve multiple financial transactions, for example, a CONVERSION involves CONVERSION_SELL and CONVERSION_BUY financial transactions.
|
| Transaction Id | The identifier for the transaction. |
| Description | A description of the balance change. |
| Wallet Currency | The currency in which the balance change occurred (in 3-letter ISO-4217 format). |
| Target Currency | For transactions involving a conversion of funds, the non-Wallet currency (in 3-letter ISO-4217 format). Available for CONVERSION and multi-currency CARD transactions.
|
| Target Amount | The amount of the transaction in the Target Currency. |
| Conversion Rate | The rate used to convert funds between the Target Currency and Wallet Currency. |
| Mature Date | For CONVERSION transactions, the mature date of the conversion (in ISO 8601 format).
|
| Amount | The amount of the transaction, in the Wallet Currency, before fees are applied. Note: the amount is positive for both credit and debit transactions. |
| Fee | The amount of any fees included in the balance change, specified in the Wallet Currency. Note: for transactions where fees are recorded as a separate balance change, the fee will not be included in this field. |
| Debit Net Amount | For debit balance changes, the amount of the balance change in the Wallet Currency. |
| Credit Net Amount | For credit balance changes, the amount of the balance change in the Wallet Currency. |
| Available Balance | The Available balance, in the Wallet Currency, after the balance change. Note: the Balance Activity Report does not capture all changes in the Available balance. |
| Account Balance | The Account balance, in the Wallet Currency, after the balance change. |
| Created At | The date and time that the transaction was created (in ISO 8601 format). For transactions that settle instantly, this will be the time of the balance change (see Time field). For other transactions, this will be the time the transaction was initiated. |
| Request Id | The unique identifier specified in the transaction creation request. |
| Reference | The transaction reference visible to both parties. |
| Note | A transaction reference only visible to your account. |
Reports for Account Groups
When Balance activity reports are generated for an Account Group, one CSV or Excel file will be generated for each legal entity and these files will be returned in a .zip format.
In addition to the standard content of the report, Balance activity reports will include:
- A Legal Entity field in the header and one header row per account owned by the legal entity
- An Account Id field in the report’s content denoting the account associated with the financial transaction.
Balance Activity Report v1.0.0
Version 1.0.0 of the report contains details of each balance activity. The columns are described below.
| Field name | Description |
|---|---|
| Time | The time of the balance change (in ISO 8601 format). |
| Type | The type of the transaction that led to this balance change. For example, PAYOUT, CONVERSION or CARD.
|
| Financial Transaction Type | The type of the financial transaction that changed the Account balance. For example PAYOUT, CONVERSION_SELL or CARD_PURCHASE. One transaction can involve multiple financial transactions, for example, a CONVERSION involves CONVERSION_SELL and CONVERSION_BUY financial transactions.
|
| Transaction Id | The identifier for the transaction. |
| Description | A description of the balance change. |
| Wallet Currency | The currency in which the balance change occurred (in 3-letter ISO-4217 format). |
| Target Currency | For transactions involving a conversion of funds, the non-Wallet currency (in 3-letter ISO-4217 format). Available for CONVERSION and multi-currency CARD transactions.
|
| Target Amount | The amount of the transaction in the Target Currency. |
| Conversion Rate | The rate used for the conversion between the Target Currency and Wallet Currency. |
| Mature Date | For CONVERSION transactions, the mature date of the conversion (in ISO 8601 format).
|
| Amount | The amount of the transaction, in the Wallet Currency, before fees are applied. Note: the amount is positive for both credit and debit transactions. |
| Fee | The amount of any fees included in the balance change, specified in the Wallet Currency. Note: for transactions where fees are recorded as a separate balance change, the fee will not be included in this field. |
| Debit Net Amount | For debit balance changes, the amount of the balance change in the Wallet Currency. |
| Credit Net Amount | For credit balance changes, the amount of the balance change in the Wallet Currency. |
| Available Balance | The Available balance, in the Wallet Currency, after the balance change. Note: the Balance Activity Report does not capture all changes in the Available balance. |
| Account Balance | The Account balance, in the Wallet Currency, after the balance change. |
| Created At | The date and time that the transaction was created (in ISO 8601 format). For transactions that settle instantly, this will be the time of the balance change (see Time field). For other transactions, this will be the time the transaction was initiated. |
| Request Id | The unique identifier specified in the transaction creation request. |