Blog/Finance

How to record Etsy sales and fees in QuickBooks Online

Recording only the Etsy deposit in QuickBooks understates your sales and hides your fees, which matters at tax time. Recording the full picture is not hard with a clearing account and one journal entry per deposit.

Etsy Payout Breakdown screenshot

Why the deposit alone is wrong

The deposit is net of fees, ads, labels, refunds and sometimes tax. If you only record the deposit as income, your revenue is too low and your deductible Etsy expenses disappear from your profit and loss report.

Create a clearing account

Add an "Etsy Clearing" account in your chart of accounts. Every Etsy journal entry posts its net amount there, and every deposit moves money out of it to your bank. Over time it should stay close to zero.

Write one journal entry per deposit

Credit Etsy Sales with gross sales excluding Etsy-collected tax, debit Refunds, debit each fee type, and debit Etsy Clearing with the net. Use the deposit date so the entry sits next to the matching bank transaction.

Match the bank deposit

When the deposit arrives in your bank feed, categorise it as a transfer from Etsy Clearing. Differences usually come from reserves or timing and clear in the next period.

Import entries in bulk

QuickBooks Online can import journal entries from a spreadsheet with columns such as Journal No, Journal Date, Account, Debits, Credits and Description. Make sure the account names match your chart of accounts exactly, and check the date format matches your company settings.

Create the QuickBooks file automatically

zastech Etsy Payout Breakdown converts your Etsy monthly statement into QuickBooks journal-entry rows, one balanced entry per deposit, using your account names. It also shows a clear breakdown of sales, fees and tax. No Etsy or QuickBooks login is needed, and three breakdowns are free.

On this page
Why the deposit alone is wrongCreate a clearing accountWrite one journal entry per depositMatch the bank depositImport entries in bulkCreate the QuickBooks file automatically
Free to try

Do this faster with Etsy Payout Breakdown.

No signup, nothing to connect. Start with the free results and decide later.