Transaction reconciliation report
The Transaction reconciliation report details every confirmed financial transaction in your Airwallex account, including those that are pending at the time the report is generated. This report helps you to reconcile your transactions to your own internal records.
Note that financial transactions are recorded on the date that they are created.
The Transaction reconciliation 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 financial transaction in the report.
- Payouts for which the currency that the recipient receives (the transaction currency) is different from the currency sender pays in (the settlement currency) will be recorded as a single record rather than as a Conversion Sell record, a Conversion Buy record and a Payout record. The payout record will now include the Transaction Currency, Transaction Amount and Exchange Rate.
- The Beneficiary Bank Account Name column has been renamed to Beneficiary Name.
- The Note field has been added.
For details on the legacy version, see Transaction reconciliation report v1.0.0.
All transaction types are confirmed immediately at the time they are created, except Payments. Payments will be typically confirmed within 2 business days after capture with the exception of Klarna, which are confirmed within 8 days of capture. We recommend that you wait 2 business days (or 8 days for Klarna) before generating the report to ensure all transactions are included.
Report data
You can download the report in Excel (.xlsx readable with Microsoft Excel or equivalent) or CSV formats.
The report includes a header with information described below.
| Field name | Description |
|---|---|
| Legal Entity | The legal entity that owns the account. Only included in Transaction Reconciliation Reports generated by Account Groups. |
| Account Name | Name of your account as registered with Airwallex. |
| Account Id | Identity of your account assigned by Airwallex. |
| Time Zone | The time zone used for all dates and times in the report (in the IANA time zone identifier format). |
| Date Range | The date field from the report used to select which financial transactions will be included in the report. Currently only Created at is supported.
|
| From Date | The date and time when the report starts (in YYYY-MM-DD hh:mm:ss format). |
| To Date | The date and time when the report ends (in YYYY-MM-DD hh:mm:ss format). |
The Transaction Details contains the details of each financial transaction. The columns are described below.
| Field name | Description |
|---|---|
| Type | The type of the transaction. Possible values: Payout, Batch Payout, Conversion, Deposit, Adjustment, Fee, Payin, Charge, Transfer, Yield, Card, Purchase.
|
| Transaction Id | The reference identifier associated with the financial transaction. |
| Financial Transaction Type | The type of the financial transaction. Possible values: Payment, Payment Reserve Hold, Payment Reserve Release, Dispute, Dispute Reversal, Dispute Lost, Refund, Refund Reversal, Refund Failure, Payout, Payout Failure, Payout Reversal, Conversion Sell, Conversion Buy, Conversion Reversal, Deposit, Issuing Authorisation Hold, Issuing Authorisation Release, Issuing Capture, Issuing Refund, Purchase, Transfer, DD Credit, DD Debit, DC Credit, DC Debit.
|
| Source Id | The reference identifier for the overall transaction to which the financial transaction is related. |
| Source Entity | The overall transaction to which the financial transaction is related. Possible values: Payout, Conversion, Deposit, Adjustment, Fee, Payment Attempt, Refund, Refund Reversal, Dispute, Charge, Transfer, Yield, Batch Payout, Card Purchase, Card Refund, Purchase.
|
| Request Id | The unique identifier specified in the transaction creation request. |
| Created At | The date and time at which the financial transaction was created (in YYYY-MM-DD hh:mm:ss format). |
| Estimated settled At | The estimated settlement date and time for the financial transaction (in YYYY-MM-DD hh:mm:ss format). |
| Settled At | The date and time that the financial transaction was settled (in YYYY-MM-DD hh:mm:ss format). |
| Status | The status of the financial transaction at the time the report was generated. This can be Pending, Settled or Cancelled.
|
| Settlement Currency | The currency in which the financial transaction was, or will be, settled in the Wallet. |
| Settlement Amount | The amount to be settled in the Wallet before fees are applied. |
| Fee | Any fees on the transaction, specified in the Settlement Currency. |
| Net Amount | The amount to be settled in the Wallet after fees are applied. |
| Transaction Currency | The currency in which the external sender paid or the external recipient received funds, in cases where this is different from the Settlement Currency. |
| Transaction Amount | The amount paid by the external sender or received by the external recipient, in the Transaction Currency. |
| Exchange Rate | The exchange rate used to convert funds from the Settlement Currency to the Transaction Currency. |
| Settlement Type | Whether the financial transaction will be settled individually (Single) or in a daily batch (Batch). None for all Card financial transactions.
|
| Batch Id | For financial transactions in a batch, the identifier for the batch. |
| Payment Method | The method used to pay the transaction. For Payments, the payment method used by the end customer. For Card transactions, the card used in the transaction. For Payouts, the method used to send the payout. |
| Payment Attempt Id | The identifier for the Payment Attempt that resulted in the financial transaction. Only available for Payments. |
| Payment Intent Id | The identifier for the Payment Intent that resulted in the financial transaction. Only available for Payments. |
| Order Id | The order ID created in the merchant’s order system and provided in the Payment Intent. Only available for Payments. |
| Reference | The shared reference for the transaction. For Deposits, Payouts and Transfers, the bank reference set by the sender. For Card transactions, the Retrieval Reference Number and Authorization Code. |
| Reason | The reason for an Adjustment. |
| Note | The internal transaction description for a Payout. Only available for Payouts. |
| Beneficiary Name | The beneficiary or recipient in the financial transaction. For Payouts and Transfers, the recipient of the payout. For Card transactions, the merchant. |
| Beneficiary Bank Account Number | The Bank Account Number of the beneficiary. Only available for Payouts. |
| Remitting Bank | The bank that sent the deposit. Only available for Deposits. |
| Remitter Name | The external sender of the deposit. Only available for Deposits. |
Reports for Account Groups
When Transaction reconciliation 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 file.
In addition to the standard content of the report, Transaction reconciliation 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.
Transaction reconciliation report v1.0.0
Version 1.0.0 of the report includes a header with information described below.
| Field name | Description |
|---|---|
| Legal Entity | The legal entity that owns the account. Only included in Transaction Reconciliation Reports generated by Organisations or Account Groups. |
| Account Name | Name of your account as registered with Airwallex. |
| Account Id | Identity of your account assigned by Airwallex. |
| Time Zone | The time zone used for all dates and times in the report (in the IANA time zone identifier format). |
| Date Range | The date field from the report used to select which financial transactions will be included in the report. Currently only Created at is supported.
|
| From Date | The date and time when the report starts (in YYYY-MM-DD hh:mm:ss format). |
| To Date | The date and time when the report ends (in YYYY-MM-DD hh:mm:ss format). |
In version 1.0.0 of the report, the Transaction details contains the details of each Financial Transaction. The columns are described below.
| Field name | Description |
|---|---|
| Type | The type of the transaction. Possible values: Payout, Batch Payout, Conversion, Deposit, Adjustment, Fee, Payin, Charge, Transfer, Yield, Card, Purchase.
|
| Transaction Id | The reference identifier associated with the financial transaction. |
| Financial Transaction Type | The type of the financial transaction. Possible values: Payment, Payment Reserve Hold, Payment Reserve Release, Dispute, Dispute Reversal, Dispute Lost, Refund, Refund Reversal, Refund Failure, Payout, Payout Failure, Payout Reversal, Conversion Sell, Conversion Buy, Conversion Reversal, Deposit, Issuing Authorisation Hold, Issuing Authorisation Release, Issuing Capture, Issuing Refund, Purchase, Transfer, DD Credit, DD Debit, DC Credit, DC Debit.
|
| Source Id | The reference identifier for the overall transaction to which the financial transaction is related. |
| Source Entity | The overall transaction to which the financial transaction is related. Possible values: Payout, Conversion, Deposit, Adjustment, Fee, Payment Attempt, Refund, Refund Reversal, Dispute, Charge, Transfer, Yield, Batch Payout, Card Purchase, Card Refund, Purchase.
|
| Request Id | The unique identifier specified in the transaction creation request. |
| Created At | The date and time at which the financial transaction was created (in YYYY-MM-DD hh:mm:ss format). |
| Estimated settled At | The estimated settlement date and time for the financial transaction (in YYYY-MM-DD hh:mm:ss format). |
| Settled At | The date and time that the financial transaction was settled (in YYYY-MM-DD hh:mm:ss format). |
| Status | The status of the financial transaction at the time the report was generated. This can be Pending, Settled or Cancelled.
|
| Settlement Currency | The currency in which the financial transaction was, or will be, settled in the Wallet. |
| Settlement Amount | The amount to be settled in the Wallet before fees are applied. |
| Fee | Not used in v1.0.0. |
| Net Amount | The amount to be settled in the Wallet after fees are applied. |
| Transaction Currency | The currency in which the external sender paid or the external recipient received funds, in cases where this is different from the Settlement Currency. |
| Transaction Amount | The amount paid by the external sender or received by the external recipient, in the Transaction Currency. |
| Exchange Rate | The exchange rate used to convert funds between the Settlement Currency and Transaction Currency. |
| Settlement Type | Whether the financial transaction will be settled individually (Single) or in a daily batch (Batch). None for all Card financial transactions.
|
| Batch Id | For financial transactions in a batch, the identifier for the batch. |
| Payment Method | The method used to pay the transaction. For Payments, the payment method used by the end customer. For Card transactions, the card used in the transaction. For Payouts, the method used to send the payout. |
| Payment Attempt Id | The identifier for the Payment Attempt that resulted in the financial transaction. Only available for Payments. |
| Payment Intent Id | The identifier for the Payment Intent that resulted in the financial transaction. Only available for Payments. |
| Order Id | The order identifier created in the merchant’s order system and provided in the Payment Intent. Only available for Payments. |
| Reference | The shared reference for the transaction. For Deposits, Payouts and Transfers, the bank reference set by the sender. For Card transactions, the Retrieval Reference Number and Authorization Code. |
| Reason | The reason for an Adjustment. |
| Beneficiary Bank Account Name | The beneficiary or recipient in the financial transaction. For Payouts and Transfers, the recipient of the payout. For Card transactions, the merchant. |
| Beneficiary Bank Account Number | The Bank Account Number of the beneficiary. Only available for Payouts. |
| Remitting Bank | The bank that sent the deposit. Only available for Deposits. |
| Remitter Name | The external sender of the deposit. Only available for Deposits. |