Xargaar ToolsTurn a Mercado Pago settlement report into monthly totals by type, fees and net.
Drop in the settlement report (Account money report) you download from Mercado Pago. See each month and currency by transaction type (approved payments, refunds, chargebacks and more): purchase amount, fees, taxes, shipping and the net amount that hit your balance. The pack adds a clean transactions CSV and a month totals CSV. Nothing is uploaded.
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.
The pack adds a transactions CSV and a month totals CSV you can open in any spreadsheet.
Pay once. Summarize every Mercado Pago month.
- All months in your files instead of the first 3 (counted per currency).
- A transactions CSV and a month totals CSV, ready for your spreadsheet.
- One folder that opens in your browser with no internet. Your Mercado Pago data stays on your computer.
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.