Xargaar ToolsTurn Checkout.com Settlement Breakdown CSVs into totals per payout, type and payment method.
Drop in the Settlement Breakdown report CSVs from Checkout.com. See each payout by Type and payment method: gross, deduction, processing fee, scheme fee, interchange, tax, reserve and net in the holding currency, added up exactly as written to 7 decimals. The pack adds a rows CSV and a payout totals CSV. Nothing is uploaded.
Tested only on made-up files, never on a real Checkout.com report. Column names and the ISO date layout come from Checkout.com's Settlement Breakdown Report documentation and its sample CSV, which has amounts with up to 7 decimals. The documentation gives no formula tying Gross, Deduction and Net together and no sign rule, so nothing is checked and amounts are summed as written. References, entity names, card details and user-defined fields 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.
Gross, deduction, the fee columns, tax, reserve and net for each payout, split by Type and payment method.
The pack adds a rows CSV and a payout totals CSV you can open in any spreadsheet.
Pay once. Summarize every Checkout.com payout.
- All payouts in your files instead of the first 3.
- A rows CSV and a payout totals CSV, ready for your spreadsheet.
- One folder that opens in your browser with no internet. Your Checkout.com data stays on your computer.
Questions
Which file do I use?
The Settlement Breakdown Report. Checkout.com creates one CSV per settlement, and you can download it from the dashboard, the API or SFTP. Drop one or many.
Why up to 7 decimals?
Checkout.com's own sample report has amounts such as -14.934506 and -0.4893708. The tool keeps all of them and shows them as written, so nothing is rounded before you see it.
Why no checks?
Checkout.com explains each column but publishes no formula tying Gross, Deduction and Net together, and no sign rule. So the tool adds each column as written and never adds different currencies together.
What counts as a repeat?
The same Payout ID, Type, Payment ID and Processed On. Rows with no Payment ID are not tested. Repeats are counted, not removed, and the downloads wait until you tick the box.