BooksReady

Convert a Etsy monthly statement CSV to QuickBooks Online

In short: Etsy's monthly statement CSV lists sales, listing fees, transaction fees, processing fees, ads, shipping labels and sales tax as separate rows, with dates written out and "--" where a value is empty. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Convert your file

Etsy to QuickBooks Online (CSV)

etsy_statement_YYYY_M.csv (best), EtsySoldOrdersYYYY-M.csv, EtsyDepositsYYYY-M.csv

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from Etsy

  1. Best for your books: Shop Manager > Finances > Monthly statements > View all monthly statements.
  2. Pick the year and month and click Generate CSV; Etsy emails you when it is ready.
  3. Click Download Now in the email, then Download CSV.
  4. Sold Orders and Deposits CSVs: Shop Manager > Settings > Options > Download Data, choose the CSV type, month and year.

Why a raw Etsy export fails in QuickBooks Online

Imported raw, QuickBooks Online cannot read dates written as words or amounts shown as "--", deposits carry their amount only in the title text, and the many small fee rows land in a bank account that only ever received the deposits.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

What is unusual about the Etsy file

  • 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.

What QuickBooks Online requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

2. Before and after

Before: the Etsy monthly statement CSV as downloaded

Date,Type,Title,Info,Currency,Amount,"Fees & Taxes",Net,"Tax Details"
"March 31, 2025",Deposit,"$1,208.35 sent to your bank account",,USD,--,--,--,--
"March 28, 2025",Marketing,"Etsy Ads","Bill for click-throughs to your shop on Mar 27, 2025",USD,--,-$0.86,-$0.86,--
"March 20, 2025",Refund,"Refund to buyer for Order #3600000002",,USD,-$17.37,--,-$17.37,--
"March 20, 2025",Fee,"Credit for processing fee","Order #3600000002",USD,--,$0.89,$0.89,--
"March 20, 2025",Tax,"Refund to buyer for sales tax","Order #3600000002",USD,--,$1.30,$1.30,--
"March 9, 2025",Fee,"Listing fee ($0.20 USD)","Listing #1500000001",USD,--,-$0.20,-$0.20,--
"March 8, 2025",Fee,"Transaction fee: Shipping","Order #3600000001",USD,--,-$0.31,-$0.31,--
"March 8, 2025",Fee,"Transaction fee: Hand-thrown mug, ""speckled"" glaze...","Order #3600000001",USD,--,-$2.73,-$2.73,--

After: what QuickBooks Online receives

After: etsy-2025-03-08-to-2025-03-31-quickbooks-3col.csv
DateDescriptionAmount
03/08/2025Payment for Order #36000000011250.00
03/08/2025Processing fee (Order #3600000001)-1.62
03/08/2025Sales tax paid by buyer (Order #3600000001)-3.36
03/08/2025Transaction fee: Hand-thrown mug, "speckled" glaze... (Order #3600000001)-2.73
03/08/2025Transaction fee: Shipping (Order #3600000001)-0.31
03/09/2025Listing fee ( 0.20 USD) (Listing #1500000001)-0.20

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

3. Import the converted file into QuickBooks Online

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

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.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
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.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert Etsy

Other exports to QuickBooks Online (CSV)

Common import problems