Payment activity export

Settlement report

Transaction & fee types

Payments rounding logic

Reporting

A quick introduction to building with Airwallex APIs

Quickstart

Explore our comprehensive reference to integrate with Airwallex API endpoints

API Reference

Learn how to receive push notifications via webhooks

Webhooks

The payment activity export allows you to view itemized transactions alongside financial information and other payment details for your analysis and reconciliation based on the original transaction date.

The payment activity export can be accessed via your web app. To download, select the appropriate date range and click the Export button on the top right. Upon clicking the Export button, you can customize the data columns you wish to obtain.

Do note that there is a maximum limit of 10,000 transactions in a single download. 

![transactionlist](//images.ctfassets.net/c3n7jozh84hr/54wYqzTnH8042moKIIDwpl/7a497d4e178543f72b73febe5b84088a/image.png)

| Field name | Description |
| :---- | :---- |
| Account | Account name |
| Time zone | Time zone defined in Coordinated Universal Time (UTC) |
| Payment created time | Time at which the payment intent was created |
| Payment ID | Unique identifier for the payment intent |
| Payment attempt ID | Unique identifier for payment attempts associated with this payment. There could be multiple IDs if there were multiple attempts |
| Order ID | Unique identifier from your order system tagged to a payment intent |
| Request ID | Unique identifier from your system tagged to your request to Airwallex |
| Descriptor | Descriptor that you have specified for display to the shopper |
| Payment status | Status of the payment intent |
| Payment currency | Three-letter ISO code for the currency of the payment |
| Payment amount | Amount of the payment |
| Refunded amount | Amount of the total successful refunds made |
| Latest payment attempt status | The status of the latest payment attempt |
| Authorization response code | Authorisation response code from payment method provider. For more information, refer to [https://www.airwallex.com/docs/payments\_\_response-codes\_\_issuer-response-codes](https://www.airwallex.com/docs/payments__response-codes__issuer-response-codes) |
| Authorization code description | Authorisation code description from payment method provider. For more information, refer to [https://www.airwallex.com/docs/payments\_\_response-codes\_\_issuer-response-codes](https://www.airwallex.com/docs/payments__response-codes__issuer-response-codes) |
| Acquirer reference number | A unique number assigned to a card transaction as it moves through the payment flow. It can be used by banks to help trace a transaction if it appears to be missing. An ARN will be available for Visa and Mastercard charges |
| Payment method | The payment method used by the shopper for this transaction |
| Payer or billing name | Name of the person or entity associated with the payment method |
| Consent ID | Unique identifier of a payment consent used for this transaction, if applicable |
| Risk score | Score assigned by risk engine |
| Rule action | Action assigned by risk engine |
| Rule reason | Reasons applicable for the rule action, if available |
| CVC check | Results of card verification code checks. [https://www.airwallex.com/docs/payments\_\_response-codes\_\_cvc2cvv2-codes](https://www.airwallex.com/docs/payments__response-codes__cvc2cvv2-codes) |
| AVS check | Results of address verification service checks, if applicable [https://www.airwallex.com/docs/payments\_\_response-codes\_\_avs-codes](https://www.airwallex.com/docs/payments__response-codes__avs-codes) |
| 3DS triggered | Whether 3DS has been triggered for this transaction [https://www.airwallex.com/docs/payments\_\_native-api\_\_3d-secure-authentication](https://www.airwallex.com/docs/payments__native-api__3d-secure-authentication) |
| 3DS enrolled | Whether card supports 3DS |
| 3DS frictionless | Whether this transaction has undergone step up authentication requiring additional input from the shopper |
| 3DS authenticated | Whether this transaction has been successfully authenticated via 3DS |
| Payment method number or ID | Unique identifier for the payment method used, such as card BIN and last 4 digits or Alipay and WeChat Pay IDs |
| Payment method type | If applicable, type to help you identify the payment method, for example: Card brand when ApplePay or GooglePay are used: Visa, Mastercard, etc. Klarna: Pay Now, Pay Later, etc. |
| Card issuing or shopper country | Country the shopper’s payment method was issued in, if applicable |
| Issuing or originating bank | Name of financial institution that the shopper’s payment method was issued from, if applicable |
| Card funding | Card funding type, such as credit, debit, prepaid, if applicable |
| Card category | Card category, such as consumer, commercial, if applicable |
| Card expiration | Month and year of the card expiration |
| Charge type | Whether the transaction is a recurring or-one off payment |
| Billing phone number | Phone number of the payment method holder associated with this transaction, if applicable |
| Billing address | First line of the address of the payment method holder associated with this transaction, if applicable |
| Billing city | City of the payment method holder associated with this transaction, if applicable |
| Billing state | State of the payment method holder associated with this transaction, if applicable |
| Billing postal code | Postal code of the payment method holder associated with this transaction, if applicable |
| Billing country | Country of the payment method holder associated with this transaction, if applicable |
| Customer ID | Unique identifier of the customer in Airwallex, if applicable |
| Merchant customer ID | Unique identifier of the customer provided by you, if applicable |
| Customer name | Name of the customer, if applicable |
| Customer phone | Phone number of the customer, if applicable |
| Customer email | Email of the customer, if applicable |
| Shipping name | Name on the shipping address associated with this transaction, if applicable |
| Shipping phone number | Shipping phone number associated with this transaction, if applicable |
| Shipping method | Shipping method associated with this transaction, if applicable |
| Shipping address | First line of the shipping address associated with this transaction, if applicable |
| Shipping city | City of the shipping address associated with this transaction, if applicable |
| Shipping state | State of the shipping address associated with this transaction, if applicable |
| Shipping postal code | Postal code of the shipping address associated with this transaction, if applicable |
| Shipping country | Country of the shipping address associated with this transaction, if applicable |
| Channel type | For Wechat, identifies the channel the shopper paid from |
| Operating system | Operating system of the shopper, if available |
| Browser | Browser of the shopper, if available |
| Device | Device of the shopper, if available |
| Device IP address | IP address of the shopper, if available |
| Payment link reference | Reference for the payment link input by your customer, if applicable |
| Payment link message | Message for the payment link input by your customer, if applicable |
| Original payment currency | Three-letter ISO code for the currency of the original payment amount submitted by you on the payment intent |
| Original payment amount | Amount of the payment submitted by you on the payment intent |
| Product description | Product description provided by you, if applicable |
| Product name | Product name provided by you, if applicable |
| Product quantity | Product quantity provided by you, if applicable |
| Product unit price | Product unit price provided by you, if applicable |


Your settlement report includes a settlement file (summary and details) and a fee file (summary and details), all included in a zip file. 

The settlement file helps you match the settlements you receive in your wallet with the transactions that they relate to, while the fee file helps you identify detailed fees at a transaction level. These reports are recommended for merchants who wish to reconcile the transactions and fees included in a particular settlement batch. The fee files are especially relevant for merchants on interchange-plus pricing models.


If you started using Airwallex payments before October 2024, you may also have access to a legacy version of the settlement report. More information on the structure of this report can be found below in the legacy report section. 


Settlement section

Fee section

Legacy report

Transaction types

Fee types

On the web app and in settlement reports, Airwallex rounds gross, fees, taxes and net amounts to the smallest unit of currency before adding them up. To conduct the rounding, Airwallex uses banker’s rounding. Airwallex utilises banker’s rounding as it is more accurate and fairer than standard rounding to reduce the deviation from the actual result.


For fees, we charge a minimum fee of 0.01 for non-zero decimal currencies, and a minimum fee of 1 for zero decimal currencies.


## Banker’s rounding (Rounding half to even)
- When the number to be rounded is followed by 1, 2, 3, or 4, we round the number down
- When the number to be rounded is followed by 6, 7, 8, and 9, we round the number up
- When the number to be rounded is followed by 5, the rounding direction is determined by the number after 5:
  - When there is a number after 5, we round up.
  - When there is no number after 5:
    - If the number to be rounded before 5 is an odd number, round up to an even number
    - If the number to be rounded before 5 is an even number, round down to an even number

| Number following the number to be rounded     | Rounding direction     | Example     |
| ---------- | ---------- | ---------- |
| 0 to 4       | Rounded down       | 3.142->3.14       |
| 6 to 9       | Rounded up       | 3.146->3.15       |
| 5 (being the last digit) and the number to be rounded is an even number  | Rounded down       | 3.145->3.14       |
| 5 (being the last digit) and the number to be rounded is an odd number   | Rounded up       | 3.135->3.14       |
| 5 (not being the last digit)       | Rounded up       | 3.1451->3.15     |

For transactions occurring before banker’s rounding was implemented in July 2024, net settlement amounts were only rounded after the addition of its constituent parts. As such, your net settlement amount displayed in the web app or settlement reports will reflect what Airwallex is settling to you but may not be the sum of the gross amount and fees due to the previous rounding logic implemented. 


Why is my net settlement amount not equal to the sum of its parts?

## Smallest unit for currencies
All currencies will have 2 digit decimals as the smallest unit apart from zero decimal currencies. For non-zero decimal currencies, the minimum fee charged is 0.01. 

### Zero decimal currencies
All currencies in this list will not have any decimals for the smallest unit and will have a minimum fee of 1:

- BIF
- CLP
- DJF
- GNF
- HUF
- IDR
- ISK
- JPY
- KMF
- KRW
- MGA
- PYG
- RWF
- TWD
- UGX
- VND
- VUV
- XAF
- XOF
- XPF

Airwallex provides a variety of reports to meet your reconciliation and information needs. 

Refer to the table below to obtain the most appropriate one for your financial use case. 

| USE CASES | REPORT | HOW TO ACCESS |
| :---- | :---- | :---- |
| View all payment activities within a given period Access transaction details across many payments at once | Payment activity export | Download from the [**Payments** \> **Payment Activity**](https://www.airwallex.com/app/acquiring/list) tab on the web app. |
| View the details and summary of settlements and reserves Understand the transactions included in settlement batch(es) to your wallet, including payments, refunds, and disputes | Settlement report | For single settlement batches, you can download them from the web app [**Wallet** \> **Transactions**](https://www.airwallex.com/app/wallet/transactions) tab. For multiple settlements across a period, you can download them from the web app **[Reports](https://www.airwallex.com/app/reports)** page or from the [Settlements API](https://www.airwallex.com/docs/api?v=2020-04-30#/Finance/Settlements/). |
| View the details and summary of payment fees Understand the detailed fees for each transaction included in settlement batch(es) to your wallet | Fee report | Automatically downloaded as separate files when you choose to download settlement reports through the [**Wallet** \> **Transactions**](https://www.airwallex.com/app/wallet/transactions) tab, [**Reports**](https://www.airwallex.com/app/reports) page, or the [Settlements API](https://www.airwallex.com/docs/api?v=2020-04-30#/Finance/Settlements/). |
| View all your Airwallex pending and settled financial transactions, including conversions, payins, payouts, and online payments | Transaction reconciliation report | Download from the web app **[Reports](https://www.airwallex.com/app/reports)** page or from the [Financial Reports API](https://www.airwallex.com/docs/api?v=2020-04-30#/Finance/Financial_Reports/). |
| View list of settlements to your balance from Payments | Balance activity report | Download from the web app **[Reports](https://www.airwallex.com/app/reports)** page or from the [Financial Reports API](https://www.airwallex.com/docs/api?v=2020-04-30#/Finance/Financial_Reports/). |

USE CASES	REPORT	HOW TO ACCESS
View all payment activities within a given period Access transaction details across many payments at once	Payment activity export	Download from the Payments > Payment Activity tab on the web app.
View the details and summary of settlements and reserves Understand the transactions included in settlement batch(es) to your wallet, including payments, refunds, and disputes	Settlement report	For single settlement batches, you can download them from the web app Wallet > Transactions tab. For multiple settlements across a period, you can download them from the web app Reports page or from the Settlements API API.
View the details and summary of payment fees Understand the detailed fees for each transaction included in settlement batch(es) to your wallet	Fee report	Automatically downloaded as separate files when you choose to download settlement reports through the Wallet > Transactions tab, Reports page, or the Settlements API API.
View all your Airwallex pending and settled financial transactions, including conversions, payins, payouts, and online payments	Transaction reconciliation report	Download from the web app Reports page or from the Financial Reports API API.
View list of settlements to your balance from Payments	Balance activity report	Download from the web app Reports page or from the Financial Reports API API.