Xargaar ToolsTurn a Lemon Squeezy orders CSV into monthly totals by country.
Drop in the orders CSV you export from Lemon Squeezy. See each month by country: subtotal, discount, tax and total, converted from USD cents and added up exactly as written. The pack adds a clean orders CSV and a month totals CSV. Nothing is uploaded.
Tested only on made-up files, never on a real Lemon Squeezy export. Column names and the USD-cents units come from Lemon Squeezy's documentation for exporting orders. The documentation says only that date_utc is in UTC, not its layout, so you choose the Date setting. It lists no refund or status column and no formula tying subtotal, discount_total, tax and total together, so nothing is checked and amounts are summed as written. Names, emails, cities, postcodes, card details and tax numbers 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 documented columns, every date and every amount. A bad row stops the file with its row number.
Subtotal, discount, tax and total for every month, split by the country column.
The pack adds an orders CSV and a month totals CSV you can open in any spreadsheet.
Pay once. Summarize every Lemon Squeezy month.
- All months in your files instead of the first 3.
- An orders CSV and a month totals CSV, ready for your spreadsheet.
- One folder that opens in your browser with no internet. Your Lemon Squeezy data stays on your computer.
Questions
Which file do I use?
On the Orders page of your Lemon Squeezy store, use the Export button. The CSV is emailed to the store owner. Drop one or many.
Why is there a Date setting?
Lemon Squeezy documents date_utc as "when the order was placed, in UTC" but not how it is written, so you tell the tool. Nothing is guessed. The month is the one in the file, with no time zone shift.
Why no refunds or checks?
The documented columns include no refund or status column, and no formula tying subtotal, discount_total, tax and total together. So the tool adds each column as written and does not decide what a row means.
What about the currency column?
Lemon Squeezy says payments are always made in USD and the money columns are in USD cents, so every amount is shown in USD. The currency column is only the one displayed at checkout and is not used.