How to import an Etsy Payments statement into QuickBooks Online

Etsy's Payments statement can't be dropped into QBO like a bank feed. Here's why it needs a balanced journal entry instead of a transaction list, how to build one by hand, and the one-click shortcut if you'd rather skip it.

Why a bank-import CSV doesn't work for an Etsy statement

QuickBooks Online's bank-import tool expects a flat list of Date, Description, Amount rows — fine for a PayPal or Shopify payout, where money mostly just moves in or out. An Etsy Payments statement is different: over the course of a month it bundles many different things - sales, transaction fees, listing fees, marketing and Offsite Ads spend, shipping labels, VAT charged on Etsy's own fees, refunds, and several separate deposits paid out to your bank - and treating a deposit line as one "Sales income" entry hides every fee as if it never happened. Getting this right means a balanced double-entry journal entry that splits the statement back into its real pieces, not a transaction list.

Option 1: Build the journal entry by hand

Free, but easy to get wrong — and QBO won't tell you if it's wrong.

  1. In Etsy, go to Shop Manager → Settings → Options → Download Data and download your Etsy Payments statement CSV for the period you're booking.
  2. Every row carries a Type (Sale, Refund, Transaction, Listing, Marketing, Shipping Labels, VAT, Deposit) plus Amount, Fees & Taxes, and Net columns - the Type tells you which account the line belongs to, and Net is the actual signed amount to book.
  3. Credit Sales Income for every "Sale" line, and debit it for "Refund" lines.
  4. Debit Etsy Selling Fees: Transaction Fees for "Transaction" lines and Etsy Selling Fees: Listing Fees for "Listing" lines.
  5. Debit Etsy Selling Fees: Advertising & Marketing for "Marketing" lines (Offsite Ads, promoted listings) and Etsy Selling Fees: VAT on Etsy Fees for "VAT" lines.
  6. Debit Shipping Expenses: Etsy Shipping Labels for every "Shipping Labels" line.
  7. For "Deposit" lines, post straight to Cash - Business Checking Account rather than a fee or revenue account - that's money actually leaving Etsy for your real bank, not a sale or a fee.
  8. Every line above should also hit a clearing account (call it "Etsy Payments Clearing Account") on the opposite side - that's what makes the entry balance and represents what Etsy is holding for you pending payout.
  9. Unlike Amazon's one-settlement-per-file report, an Etsy statement can contain multiple Deposit rows in one period - date the journal entry to the end of the period, not a single settlement date.
  10. Before saving, add up every debit and every credit column separately. If they don't match to the penny, the entry is wrong — QuickBooks will let you save an unbalanced journal entry without warning you.
  11. In QuickBooks Online, go to + New → Journal Entry (or bulk-import via Settings → Import Data → Journal Entries on Advanced) and enter the lines above.

Option 2: Skip the manual math

Web App

Etsy to QuickBooks

Drop in your Etsy Payments statement export, get back a QuickBooks-ready journal entry CSV — sales, fees, marketing spend, shipping labels, and deposits split into their real accounts and balanced automatically. Refuses to output an entry that doesn't balance.

Free sample · from $9
Try it

Changed your mind? How to undo an import

Our apps never touch your QuickBooks file, and your original export is never changed. This export converts into journal entries, which become real entries in your books once you import them. To take them back out of QuickBooks Online:

  1. Find the journal entries the import created: open the Journal report for the dates you imported, or search for journal entries in that date range.
  2. Open each entry and choose More → Delete at the bottom of the screen.
  3. If you work in QuickBooks Online Accountant, you can remove many entries at once with its batch delete/void tool instead.
  4. Fix whatever needed fixing, convert your original export again, and re-import.

Tip: run the Journal report again afterward to confirm nothing from that batch is left.

Frequently asked questions

Can I import an Etsy Payments statement the same way as a bank export?
Not accurately. A bank import is a flat transaction list; an Etsy statement bundles sales, fees, marketing spend, and deposits into one export that needs a balanced double-entry journal entry to book correctly, which a bank-import CSV can't represent.

Which QuickBooks Online plan can bulk-import journal entries from a CSV?
Only QuickBooks Online Advanced has a native journal-entry CSV importer. Other tiers need manual entry or a third-party importer like Transaction Pro or SaasAnt.

What accounts does an Etsy Payments journal entry debit and credit?
Sales are credited as revenue; transaction fees, listing fees, marketing spend, and VAT on fees are debited as expenses; shipping labels post to a shipping expense account; deposits post straight to your real bank account. Every line balances against a clearing account.

How is this different from Amazon's settlement report?
Amazon settles once per period with a single deposit total. Etsy pays out more frequently, so one statement can contain several separate deposits within it.

Convert other exports

← Back to DigitalBuilds.org