Xargaar ToolsTurn Airwallex Settlement Details CSVs into totals per batch, transaction type and payment method.
Drop in the Settlement Details file from your Airwallex settlement report. See each settlement batch by Transaction type and payment method: gross amount, fees, taxes on fees and net amount in the settlement currency, added up exactly as written. The pack adds a rows CSV and a batch totals CSV. Nothing is uploaded.
Tested only on made-up files and on the sample report Airwallex publishes, never on a real merchant report. Column names come from Airwallex's settlement report documentation. Only the Settlement Details file is read, not the summary or fee files. Nothing is checked against the summary file and amounts are summed as written. Customer names, phone numbers, emails, shipping and card details are never read. This is not tax advice.
Set these to match your files before you drop them. Nothing is guessed. Limits: 20 files, 40 MB each, 200 MB in total, 60,000 rows per file and 300,000 in total.
What it does
Finds the documented columns by header name and checks the dates, currencies and every amount. A bad row stops the file with its row number.
Rows, gross amount, fees, taxes on fees and net amount for each batch, split by Transaction type and payment method.
The pack adds a rows CSV and a batch totals CSV you can open in any spreadsheet.
Pay once. Summarize every Airwallex batch.
- All batches in your files instead of the first 3.
- A rows CSV and a batch totals CSV, ready for your spreadsheet.
- One folder that opens in your browser with no internet. Your Airwallex data stays on your computer.
Questions
Which file do I use?
Airwallex says the settlement report is a zip with a settlement summary, settlement details, fee summary and fee details file. Unzip it and drop the Settlement Details file. The other three are not read.
Which dates does it accept?
Settled at as 2024-10-22 18:00:00, as in Airwallex's sample, with or without seconds. The tool shows the date as written and does not change time zones. Other layouts stop with the row number.
Why no checks?
Airwallex defines each column but the tool does not compare anything with the summary file or your wallet. It adds each column as written and never adds different currencies together.
What counts as a repeat?
The same settlement batch ID, Transaction ID, Source ID, Payment ID, Transaction type, Settled at and amounts. In Airwallex's own sample one Transaction ID appears on 13 different rows, so the Transaction ID alone is never treated as a repeat. Rows with neither a Transaction ID nor a Source ID are not tested. Repeats are counted, not removed, and the downloads wait until you tick the box.