Xargaar Tools
Xargaar ToolsTurn a Mercado Pago settlement report into monthly totals by type, fees and net.
Tested only on made-up files, never on a real Mercado Pago export. Column names come from the Mercado Pago developer docs for the Account money (settlement) report fields, written as the English codes such as SETTLEMENT_NET_AMOUNT. If you set another header language, the tool stops with a message. Mercado Pago says the net amount is the purchase amount less all fees. It does not say how withheld taxes or negative amounts are shown, so nothing is checked and amounts are summed as written. Rows where the transaction currency is empty or differs from the settlement currency stop the file, because nothing is converted. Payer 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
Checks the report columns, the currency codes, the dates and every amount. A bad row stops the file with its row number.
Purchase amount, fees, taxes, shipping and settlement net amount for every month and currency, split by the transaction type Mercado Pago wrote on each row.
Questions
Which file do I use?
In your Mercado Pago account, open the reconciliation reports, choose the Account money (settlement) report and download it as CSV with English headers. Mercado Pago lets you change the separator and header language, so the tool has a Separator setting and expects English headers.
Why are there settings?
Separator, number style and which date sets the month are choices, not facts the file declares. Nothing is guessed.
Why is there no net amount check?
Mercado Pago says the net amount is the purchase amount less all fees. It does not say how withheld taxes or negative amounts are shown, so nothing is checked. The tool adds each column as written and does not decide whether a type is income or a cost.
What if the currencies differ?
If a row has an empty transaction currency, or one that differs from its settlement currency, the tool stops with the row number. It never converts currencies.