Blog/Finance

How to record Etsy sales and fees in Xero

Xero's bank feed shows one Etsy deposit, but your books need the sales and fees behind it. The cleanest manual method uses an Etsy clearing account and one manual journal per deposit. It keeps income and expenses correct and makes every deposit easy to reconcile.

Etsy Payout Breakdown screenshot

Set up the accounts once

Create an "Etsy Clearing" account (a current asset or bank-type account) plus the income and expense accounts you want, such as Etsy Sales, Etsy Fees, Advertising and Postage. Keep them simple; you can always split them later.

Post one journal per deposit

For the activity covered by each deposit, create a manual journal that credits sales, debits refunds, debits each fee category and debits the Etsy Clearing account with the net. The journal must balance, which is a good check that nothing is missing.

Handle tax correctly

Exclude any sales tax or VAT that Etsy collected and remitted from your sales figure. If you are VAT-registered, check the tax rates you use on Etsy fees with your accountant-treatment depends on your country.

Reconcile the deposit

When the Etsy deposit appears in your Xero bank feed, record it as a transfer from Etsy Clearing to your bank account. If the clearing account is not zero afterwards, the remainder is money Etsy is still holding or will pay in the next deposit.

Importing journals instead of typing them

Xero can import manual journals from a CSV file using its template columns: Narration, Date, Description, AccountCode, TaxRate and Amount. Enter your own account codes before importing and review the drafts in Xero before posting them.

Generate the Xero file from your Etsy statement

zastech Etsy Payout Breakdown turns your Etsy monthly statement into Xero manual-journal CSV rows-one balanced journal per deposit-using the account names or codes you choose. No Etsy or Xero login is required. Try it free on three statements.

On this page
Set up the accounts oncePost one journal per depositHandle tax correctlyReconcile the depositImporting journals instead of typing themGenerate the Xero file from your Etsy statement
Free to try

Do this faster with Etsy Payout Breakdown.

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