Etsy to QuickBooks Online CSV Converter (Free, Private)

Etsy → QuickBooks Online in three steps

The cleanest way to get Etsy into QuickBooks Online is to treat Etsy like a bank account. Etsy collects your sales, takes its fees and then pays out the rest. Import that activity into a “Etsy Clearing” account and your books show gross income, real fees and payouts that match your checking deposits.

1. How to download your Etsy Monthly Statement CSV

Sign in to Etsy and open Shop Manager.
Go to Finances → Monthly statements (on some accounts: Finances → Payment account → View all monthly statements).
Choose the year and month, then select Download CSV / Generate CSV. Etsy may email you when the file is ready.
Save the file (it is named like etsy_statement_2026_9.csv). One file covers one calendar month, so repeat for each month you need.

Prefer the Monthly Statement. It contains every sale, fee, tax, ad charge, refund and deposit. The Sold Orders CSV (Shop Manager → Settings → Options → Download Data) is also supported, but it doesn't include listing fees, Etsy Ads, shipping labels or deposits, so it won't reconcile to your bank.

2. Convert it here

Drop the file into the converter above. The source is detected from the column headers, and the summary shows money in, money out and the net change so you can sanity-check against Etsy's own totals before downloading.

3. How to import the file into QuickBooks Online

Create a bank-type account for Etsy Clearing first: Settings ⚙ → Chart of accounts → New, account type Bank, name it “Etsy Clearing”. This holds your Etsy balance, the way a real bank account would.

Go to Transactions → Bank transactions. If you see a tile for Etsy Clearing, select it.
Select Link account ▼ → Upload from file (or Upload transactions if the account isn't connected to online banking).
Drag in the converted CSV and select Continue, then choose the Etsy Clearing account.
Map the columns: Date → Date, Description → Description, and Amount as one column with both positive and negative values (3-column file), or Credit/Debit as two columns (4-column file). Confirm the date format matches your choice in this tool.
Select the transactions to import, then Continue → Yes → Done. Categorize them in the For review tab. Bank rules (e.g. description contains “fee” → Merchant fees) save a lot of clicks.

QuickBooks Online accepts CSV uploads in English, up to 350 KB and 1,000 lines per file, with either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit). Zero amounts must be blank, and every date must use the same format. The converter applies all of this and splits large outputs into 1,000-row parts.

What each Etsy row becomes

Etsy row	In the QuickBooks file	Typical category
Sale (“Payment for Order #…”)	Money in: what the buyer paid, including Etsy-collected sales tax	Sales / Income
Tax (“Sales tax paid by buyer”)	Money out: Etsy removing the tax it remits for you	Sales Tax Payable, or offset against income (ask your accountant)
Fee (transaction, processing, listing, regulatory)	Money out, one line per fee	Merchant / Etsy fees expense
Marketing (Etsy Ads, Offsite Ads)	Money out	Advertising expense
Shipping (labels)	Money out	Shipping / postage expense
Refund and fee credits	Money out (refund) / money in (credits)	Refunds / contra-income; fee credits back to fees
Deposit (“$X sent to your bank account”)	Money out of the clearing account. The amount is read from the Title because Etsy leaves the number columns as “--”	Transfer to your checking account (not income!)

The QuickBooks format we produce

Column	Contents
`Date`	One consistent format (MM/DD/YYYY or DD/MM/YYYY)
`Description`	Text: platform, type, item/customer and the reference ID
`Amount`	Signed: positive = money in, negative = money out (3-column)
`Credit / Debit`	Positive numbers in one column each, the other left blank (4-column)

Etsy quirks the converter handles

Etsy writes amounts as text with currency symbols ($6.78, -$0.45, --). The converter turns them into plain signed numbers, which is what both QuickBooks and Xero require.
Sale rows include sales tax that Etsy collects and pays on your behalf. The matching “Sales tax paid by buyer” row takes it back out, so keep both lines and the clearing account still balances.
Statements are listed newest-first. The output is re-ordered oldest-first, and same-day rows stay in their real order (sale, then its fees).
Rows that are exactly zero are dropped, because QuickBooks rejects zero amounts.

Avoid double-counting. When the deposit reaches your bank, QuickBooks will also see it in your checking account's feed. Record that as a transfer from Etsy Clearing, not as income. The sales were already recorded from this file.

FAQ

Do my Etsy files get uploaded anywhere?

No. The conversion runs entirely in your browser with JavaScript, and the file is never sent to a server. You can check this by loading the page, switching off your Wi-Fi and converting a file. It still works. We don't use analytics or tracking scripts either.

Why are fees on separate lines instead of netted?

Your Etsy payout is gross sales minus fees. Recording both lets your books show true gross income (which is what a 1099-K reports) and a deductible fee expense. If you prefer net amounts, untick “Split fees into separate lines” in Options.

Won't this double-count income that already shows up in my bank feed?

Not if you use the clearing-account method. The Etsy statement goes into a “Etsy Clearing” account in QuickBooks. When Etsy pays out, the payout line leaving Etsy Clearing is matched as a transfer to the deposit in your checking account, so it isn't booked as new income.

What date format should I choose?

US companies normally use MM/DD/YYYY. Intuit's own guide recommends DD/MM/YYYY for regions that write day-first. What matters is that every row uses the same format and that you confirm it on the mapping screen.

Is it free?

Files that produce up to 20 rows convert and download for free, and you can preview any file. Bigger files need a Pro pass. You can download the first 20 rows to test the import before you buy.

Other converters

Last reviewed October 2026. Platform menus change from time to time. If a step looks different for you, email support@payouttobooks.com and we'll update the guide.

Convert Etsy CSV to QuickBooks Online

Etsy → QuickBooks Online in three steps

1. How to download your Etsy Monthly Statement CSV

2. Convert it here

3. How to import the file into QuickBooks Online

What each Etsy row becomes

The QuickBooks format we produce

Etsy quirks the converter handles

FAQ

Other converters

Simple pricing

Free

30-day pass

Pro monthly

Pro annual