Xargaar Tools
Xargaar ToolsTurn GoCardless payout breakdown CSVs into totals per payout, type and status.
Tested only on made-up files, never on a real GoCardless export. Column names come from GoCardless's support article on the Payout breakdown transactions report. That article does not document a date layout or a number format, so you choose them. It also documents no formula tying gross_amount, fees and net_amount together and no sign rule for refunds, so nothing is checked and amounts are summed as written. Customer names, emails, descriptions, references and metadata 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 arrival dates, currencies and every amount. A bad row stops the file with its row number.
Gross amount, GoCardless fees, app fees, surcharge fees, tax and net amount for each payout, split by resource type and status.
Questions
Which file do I use?
In the GoCardless dashboard, open Payments, then Payouts. Open one payout and choose Payout breakdown, Export Transactions, or use Payout Reconciliation to export several payouts. Drop one or many.
Why are there settings?
GoCardless documents the columns but not the date layout or number format, so you tell the tool. Nothing is guessed. Currency comes from the file, so each currency is kept apart.
Why no checks?
GoCardless explains each column but publishes no formula tying gross_amount, fees and net_amount together, and no sign rule for refunds. So the tool adds each column as written.
What counts as a repeat?
The same payouts.id, resources.type, payments.id and refunds.id when the file has them. Repeats are counted, not removed, and the downloads wait until you tick the box.