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 record payouts as a journal entry instead of importing every sale?

Your bank receives one deposit per payout, already reduced by fees and refunds. If each sale goes into the bank account separately, the bank feed shows one deposit you cannot match to dozens of entries. A journal entry per payout records gross sales, fees and refunds in their own accounts, and a bank line of exactly the deposit amount.

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.

Which accounts should the journal entry use?

Every account named in the file has to exist in your QuickBooks chart of accounts already, so set the account names in the options to the ones you use: sales, fees, payments you sent, the clearing account for money still held by the platform, the bank account that receives transfers, and the card account for payments the export clearly marks as paid from a card. This is not accounting advice; ask whoever prepares your return if you are unsure.

Etsy payouts to a QuickBooks journal entry

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. A payout journal entry records each payout as what it was: money received as gross sales, fees and refunds on their own lines, and only the amount that actually reached your bank on the bank line, balanced to the cent. Drop the file below. It is converted on your device and never uploaded.

Convert your file

Etsy to QuickBooks journal entry

Choose file

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.

1. Export the file 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.

Why a raw Etsy export fails in QuickBooks Online (journal entry import)

Your bank receives deposits from Etsy that are sales minus a long list of fees. Etsy does not say which sales each deposit pays, so the converter writes one journal entry per month with sales, each kind of fee and refunds in their own lines, and that month's deposits on the bank line.

Importing every sale from a payment platform straight into the bank account never matches the bank, because the platform pays out one net amount after taking its fees and refunds. The usual fix is one summary journal entry per payout (or per month when the export does not link sales to payouts): gross sales counts only money received, payments you sent get their own line, fees on a payout or instant transfer are expensed so the bank line is only what arrived, payments the export clearly marks as funded by a card go to a card account instead of the bank (unclear funding labels go to the bank, with a note), and a chargeback you win reduces refunds. You then match the bank line against the deposit in your bank feed.

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 (journal entry import) requires

Each entry shares one Journal No. and date, and its debits equal its credits.
Lines show gross sales (money received), refunds, fees, taxes, payments you sent (on their own line, not deducted from sales), transfers between the platform and your bank (booked as transfers, never as income or expense), and the deposit that hit your bank.
Account names must match your chart of accounts exactly; subaccounts as Parent:Sub.
Up to 1,000 lines per file (we split bigger files without breaking an entry).

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 (journal entry import) receives

After: etsy-journal-month-2025-03-31-to-2025-03-31.csv
Journal No.	Journal Date	Account Name	Debits	Credits	Description
BR-20250331-1	03/31/2025	Sales of Product Income		1250.00	Gross sales - Etsy activity 2025-03
BR-20250331-1	03/31/2025	Sales of Product Income	17.37		Refunds - Etsy activity 2025-03
BR-20250331-1	03/31/2025	Bank Charges & Fees	4.83		Fees - Etsy activity 2025-03
BR-20250331-1	03/31/2025	Sales of Product Income	2.06		Sales tax collected by marketplace - Etsy activity 2025-03
BR-20250331-1	03/31/2025	Checking	1208.35		Deposit - Etsy activity 2025-03
BR-20250331-1	03/31/2025	Uncategorized Asset	17.39		Kept in Etsy balance - Etsy activity 2025-03

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 (journal entry import)

Make sure every account named in the file exists in your chart of accounts (or change the account names before downloading).
In QuickBooks Online go to Settings (gear) > Import data > Journal entries.
Upload this CSV and map Journal No., Journal Date, Account Name, Debits, Credits, Description and Name.
Review and import. Each payout (or month) becomes one balanced entry.

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 record payouts as a journal entry instead of importing every sale?: Your bank receives one deposit per payout, already reduced by fees and refunds. If each sale goes into the bank account separately, the bank feed shows one deposit you cannot match to dozens of entries. A journal entry per payout records gross sales, fees and refunds in their own accounts, and a bank line of exactly the deposit amount.
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.
Which accounts should the journal entry use?: Every account named in the file has to exist in your QuickBooks chart of accounts already, so set the account names in the options to the ones you use: sales, fees, payments you sent, the clearing account for money still held by the platform, the bank account that receives transfers, and the card account for payments the export clearly marks as paid from a card. This is not accounting advice; ask whoever prepares your return if you are unsure.

Etsy payouts to a QuickBooks journal entry

Convert your file

Your file

1. Export the file from Etsy

Why a raw Etsy export fails in QuickBooks Online (journal entry import)

What is unusual about the Etsy file

What QuickBooks Online (journal entry import) requires

2. Before and after

Before: the Etsy monthly statement CSV as downloaded

After: what QuickBooks Online (journal entry import) receives

3. Import the converted file into QuickBooks Online (journal entry import)

Questions

Other ways to convert Etsy

Other exports to QuickBooks journal entry

Common import problems