Xargaar ToolsAdd up your Etsy monthly statements.
Drop in your Etsy monthly statement CSVs. See the sale rows with the sales tax Etsy collected taken out, the main fee types on their own lines, refunds, ads, shipping labels and deposits, a month by month table, and a check against the Net column. The amounts in these files are text with currency signs, so adding them in a spreadsheet takes some cleaning. This does the cleaning on your device. Nothing is uploaded.
Supported-format preview: tested with synthetic files only, not a real Etsy export. Check these totals against Etsy before relying on them.
What it does with each row
Sale rows include the sales tax or VAT Etsy collected. We take the matching Tax rows back out and show both numbers.
Transaction, processing, listing, regulatory, Etsy Ads, Offsite Ads, shipping labels and VAT on fees, with credits netted off. Anything else goes to "Other fees".
The lines are added back up and compared with the sum of the Net column. Rows we do not recognise get their own line and mark the result incomplete.
Pay once. Do every month of the year.
- The whole year at once, plus a CSV of every statement line.
- The free version adds up 3 months.
- One folder that opens in your browser with no internet. Your shop data stays on your computer.
Questions
Is this tax advice?
No. It is arithmetic on the files Etsy gives you. It makes no tax or legal claims and does not tell you what to report. Your accountant or the tax agency decides how these numbers are used.
Can it check my 1099-K?
No. This tool reads the monthly statement, and Etsy says your 1099-K gross sales is the total of the Gross column in the Etsy Payments Sales CSV for the year (Etsy Help: How Is the Total on My 1099-K Calculated?). Statement totals are a different measure, so we do not compare them. Etsy also says the sales tax it collects and remits is not in the 1099-K. For your 1099-K, total that Gross column or ask your tax professional.
Which files does it read?
The monthly statement CSV from Shop Manager, Finances, Monthly statements. It reads the Date, Type, Title, Amount, Fees & Taxes, Net and Currency columns. We have not seen a real Etsy statement. It was tested only on made-up files that follow a third-party description of the format, so check the totals against Etsy before you rely on them. A file that does not match (a missing column, an amount or date it cannot read, mixed currencies) is rejected with a message, and rows with a type it does not know are shown on their own line. It does not read the order CSVs.
What if I download a month twice?
An identical file counts once. If two different files contain the same month, nothing is added up until you remove one of them.
Is anything uploaded?
No. The files are read on your device. They are limited to 5 MB and 20,000 rows each.
Format limits: UTF-8 CSV with English column names and row types. Dates: YYYY-MM-DD or English month names. Amounts: dot decimals, optional comma thousands, up to 2 decimal places and 100,000,000 per row. One currency at a time; no currency conversion. A missing or rejected file is not included. Monthly refunds include collected tax; the headline refund figure removes returned tax.