Choose where it is going
- QuickBooks journal entryEtsy payouts to a QuickBooks journal entry
- QuickBooks Online (CSV)Convert a Etsy monthly statement CSV to QuickBooks Online
- Xero (CSV)Import a Etsy monthly statement CSV into Xero
How to export from Etsy
- Best for your books: Shop Manager > Finances > Monthly statements > View all monthly statements.
- Pick the year and month and click Generate CSV; Etsy emails you when it is ready.
- Click Download Now in the email, then Download CSV.
- Sold Orders and Deposits CSVs: Shop Manager > Settings > Options > Download Data, choose the CSV type, month and year.
What to know about Etsy files
- The monthly statement has a byte-order mark, currency symbols in amounts ("-€0.19") and "--" for empty values.
- Dates are written out ("January 30, 2025" or "16 January, 2024" depending on your locale).
- Deposit rows have no amount in the amount columns; the amount is only in the title ("$120.00 sent to your bank account").
- Buyer-paid sales tax is included in the sale and removed again by a separate Tax row, because Etsy pays it to the state.
- Sold Orders has two-digit years (10/04/25) and no listing, transaction or ad fees.
- Etsy does not link deposits to the sales they pay out, so journal entries are grouped by month.
Questions
- Is the sales tax in my Etsy statement my income?
- Where Etsy collects and pays sales tax to the state itself, the statement adds that tax to the sale and removes it again with a separate Tax row, so it nets to zero in the converted file. Check with your tax preparer how to treat any tax you collect yourself.
- Why does my Etsy deposit not match my sales?
- Etsy deducts listing fees, transaction fees, payment processing fees, shipping labels and ads from your balance before it deposits. The journal entry lists each kind of fee, so the difference between sales and deposits is accounted for.