What's a sensible Xero chart of accounts for an Etsy shop?

Product sales and shipping income on the revenue side, a refunds contra-revenue account, then separate accounts for transaction fees, payment processing, listing fees, Offsite Ads, onsite Etsy Ads, and postage. Add one balance sheet clearing account for the Etsy payment account. If you run more than one shop, use a tracking category for shop name rather than duplicating every account.

My Etsy deposit in Xero is much smaller than my sales. Is that right?

Usually yes. Fees are drawn from the Etsy payment account continuously as they occur, so by the time a deposit is swept the money has already left. Post sales gross, post each fee type to its own account, and let the deposit clear the payment account balance in Xero. What you should verify is that the clearing balance matches what Etsy shows in the payment account on the same date.

What's the difference between the Etsy deposit and the Etsy payment account?

The payment account is the running ledger where sales land and fees are drawn as they occur. The deposit is a sweep of available funds to your bank on whatever schedule you picked. Fees are already gone by the time the deposit happens, which is why the deposit is always smaller than sales and why the payment account statement, not the bank, is the document you close from.

Do Etsy listing fees belong in cost of sales?

Usually not, and this one is worth getting right. A listing fee is charged for having the listing, whether it sells or not, so it behaves like an operating cost of running the shop rather than a cost attached to a sale. The auto-renew charge on a sold item blurs the line, but keeping all listing fees in one selling-fees expense account keeps the treatment consistent and the trend readable.

Can Xero connect to a marketplace and code the fees on its own?

Not on its own. Xero's bank feed brings in the deposit as a single line, and connector apps vary widely in how much of a settlement they break out. Xero has no way to know that a deposit contains commission, advertising, refunds, and a reserve movement. Something has to parse the settlement file and hand Xero a balanced manual journal, then you match the deposit against the clearing account.

Do I actually need tracking categories in Xero for one sales channel?

If you sell on one channel and nothing else, separate accounts are simpler and you can skip tracking entirely. Tracking earns its place the moment you add a second channel or a second region, because it lets you run a profit and loss per channel without duplicating the chart of accounts. Just remember you only get two categories, so spend the first one on the dimension you will report on most.

Integrations

Etsy Xero integration, reconciled to the penny

BeanHawk turns every Etsy payout into a clean, summarized Xero journal: sales, fees, refunds, and taxes mapped to the right accounts, reconciled against the deposit that actually hit your bank.

Why Etsy books break in Xero

•Etsy deposits net out listing fees, transaction fees, payment processing, and Offsite Ads, so a single 'Etsy income' line hides your real margin.
•Etsy is a marketplace facilitator for sales tax in most states, and facilitator tax must bypass your revenue.
•Offsite Ads fees only hit on attributed sales, so they swing month to month and deserve their own line.

How the integration works

1
Connect Etsy
Secure, read-only authorization in about 60 seconds. Multiple accounts and marketplaces supported.
2
Connect Xero
OAuth connection with professional default account mappings you (or your accountant) can adjust.
3
Review the first journal
BeanHawk parses each payout line by line and builds one summarized journal that must balance to the penny, or it will not post.
4
Reconcile in one click
The net deposit lands in a clearing account that matches your bank feed exactly. Every Etsy payout, accounted for.

Where each Etsy payout line belongs in Xero

On the payout	Account	Why it matters
Item sales	Revenue: product sales	The Etsy payment account records the sale in full before fees are drawn against it. Booking only the deposit understates revenue and buries every fee type in one unexplained difference.
Shipping charged to the buyer	Revenue: shipping income	Etsy charges transaction fee on shipping as well as on the item. Without a separate line you cannot see whether shipping is priced above the label plus the fee it attracts.
Listing fees, including the auto-renew charge that fires when an item sells	Operating expense: listing and selling fees	Listing fees are charged per listing whether or not it sells, so they behave like a fixed cost of shop size. Buried in commission they make a large, slow-moving catalogue look cheaper to keep than it is.
Transaction fee on item price and shipping	Cost of sales: marketplace commission	This is the per-sale cut and it belongs against the sale. In overhead it disappears from unit economics, which for low-priced handmade items is where the entire margin question lives.
Etsy Payments processing fee	Cost of sales or operating expense: merchant fees	It is a separate charge from the transaction fee and it varies by country. Merged together, you lose the ability to check either rate against the current schedule when something looks off.
Offsite Ads fee on attributed orders	Operating expense: advertising	It only charges when a sale is attributed to an Etsy-placed external ad, so it lands unevenly and can attach to an order after the fact. Mixed into commission it makes fees look erratic instead of explainable. Keep onsite Etsy Ads, which charge against a daily budget whether anything sells or not, in a separate account again, because the two behave nothing alike.
Shipping labels purchased through Etsy	Cost of sales: shipping and postage	Labels are drawn from the payment account rather than billed to a card. Unmapped, postage looks understated and shipping income looks like profit.
Refunds issued to buyers	Contra-revenue: refunds and returns	Netting them against sales erases return rate per listing. On handmade and personalised items that rate is your quality signal, not just an accounting detail.
Marketplace facilitator sales tax collected by Etsy	Pass-through tax account that nets to zero	Etsy collects and remits it, so it is not income and not your liability. In revenue it overstates the shop's earnings and pollutes any tax estimate built from the profit and loss.
Payment account balance held before deposit	Balance sheet: Etsy payment account clearing (asset)	Money sitting in the Etsy payment account is yours and it is not in the bank. Without a clearing account, every month end leaves a difference that nobody can prove.

How a month actually closes on Etsy

Etsy works differently from a settlement marketplace, and that difference drives the whole close. Sales and fees flow continuously into your Etsy payment account, and a deposit is just a sweep of whatever is available on your chosen schedule. Deposits are not periods. The monthly statement from the payment account is the source document, and the deposit is only evidence the cash moved.

Download the monthly payment account statement and group rows by type: sale, fee, tax, refund, shipping label, deposit. Post a summarized journal for the month from those groups, and let the deposits clear the payment account clearing balance. That clearing balance at month end should equal the balance Etsy shows in your payment account on the same date, and it is worth checking that literally rather than assuming.

New shops and shops with a policy flag often have a hold or a longer deposit schedule, and sellers can choose daily, weekly, biweekly, or monthly deposits. All of those change when cash arrives and none of them change when the sale happened. If you switch deposit schedules mid-month, expect the clearing balance to jump, and expect it to be correct.

Offsite Ads is the line that breaks month comparisons. The fee only applies to orders Etsy attributes to an ad it placed, and attribution can land after the order date, so a quiet month for ads can carry fees from a busy one. Give it its own account, expect volatility, and resist the urge to smooth it, because the volatility is the information.

Listing fees accrue on a rhythm of their own. A listing renews when it expires or when it sells, so a shop with a big catalogue posts listing fee charges continuously regardless of sales. Comparing listing fees to revenue in a slow month is how sellers discover that catalogue size, not sales, is driving that cost.

The closing test is that item sales plus shipping income, minus fees, minus refunds, minus labels, minus tax passed through, equals the change in the payment account balance plus deposits taken. If the number is close but not exact, look at currency conversion rows first on international shops, and at refunds that crossed the month boundary second.

What Xero does well, and where it needs help

Xero calls the posting mechanism a Manual Journal, and it behaves differently from a QuickBooks journal entry in ways that matter. Manual journals can be saved as drafts for review before posting, they can be set to auto-reverse on a chosen date, and they carry a 'show journal on cash basis reports' option that changes whether the entry appears in cash-basis reporting. BeanHawk posts a summarized manual journal per settlement period with the settlement reference in the narration.

Tracking categories are Xero's answer to segmenting by channel, and the constraint is specific: an organisation gets two tracking categories, each with a capped number of options (Xero has adjusted the option limit over time, so check the current figure). Spend one on Channel and think hard before committing the second, because there is no third. Sellers who use both on channel and marketplace region find they have nothing left for department or brand later.

Bank reconciliation in Xero pushes you toward Find and Match, and that is exactly what a marketplace deposit needs: match it against the clearing account transaction the manual journal created. The danger is bank rules. A rule that auto-codes anything from Amazon or Shopify straight to a sales account will happily book net deposits as revenue forever, understating sales and erasing every fee. If you already have such a rule, delete it before connecting anything.

Xero has no native landed cost function, and its inventory uses average cost rather than FIFO. Tracked inventory items in Xero also come with limits that multi-channel sellers hit quickly. The practical answer is the same one that works in QuickBooks: keep perpetual SKU-level valuation in a subledger, push freight and duty into unit cost there, and post a periodic summarized inventory and cost of goods sold journal into Xero.

Xero's plans cap how many invoices, bills, and in some cases bank transactions you can process per month, and plan names and limits have changed by region and over time. Manual journals are not usually the binding constraint, but if you also invoice wholesale customers out of Xero, the cap can be. Multi-currency is another plan-dependent feature and it matters directly if you sell across marketplaces in more than one currency, so confirm your plan before designing the chart of accounts around it.

For a cross-border seller, set up one clearing account per currency and let Xero handle the revaluation rather than converting everything by hand. Xero will post unrealised gains and losses on foreign currency balances at period end, which means your clearing account balance moves for reasons that have nothing to do with the marketplace. Knowing that in advance saves an afternoon of hunting for a difference that is working exactly as designed.

Frequently asked questions

What's a sensible Xero chart of accounts for an Etsy shop?: Product sales and shipping income on the revenue side, a refunds contra-revenue account, then separate accounts for transaction fees, payment processing, listing fees, Offsite Ads, onsite Etsy Ads, and postage. Add one balance sheet clearing account for the Etsy payment account. If you run more than one shop, use a tracking category for shop name rather than duplicating every account.
My Etsy deposit in Xero is much smaller than my sales. Is that right?: Usually yes. Fees are drawn from the Etsy payment account continuously as they occur, so by the time a deposit is swept the money has already left. Post sales gross, post each fee type to its own account, and let the deposit clear the payment account balance in Xero. What you should verify is that the clearing balance matches what Etsy shows in the payment account on the same date.
What's the difference between the Etsy deposit and the Etsy payment account?: The payment account is the running ledger where sales land and fees are drawn as they occur. The deposit is a sweep of available funds to your bank on whatever schedule you picked. Fees are already gone by the time the deposit happens, which is why the deposit is always smaller than sales and why the payment account statement, not the bank, is the document you close from.
Do Etsy listing fees belong in cost of sales?: Usually not, and this one is worth getting right. A listing fee is charged for having the listing, whether it sells or not, so it behaves like an operating cost of running the shop rather than a cost attached to a sale. The auto-renew charge on a sold item blurs the line, but keeping all listing fees in one selling-fees expense account keeps the treatment consistent and the trend readable.
Can Xero connect to a marketplace and code the fees on its own?: Not on its own. Xero's bank feed brings in the deposit as a single line, and connector apps vary widely in how much of a settlement they break out. Xero has no way to know that a deposit contains commission, advertising, refunds, and a reserve movement. Something has to parse the settlement file and hand Xero a balanced manual journal, then you match the deposit against the clearing account.
Do I actually need tracking categories in Xero for one sales channel?: If you sell on one channel and nothing else, separate accounts are simpler and you can skip tracking entirely. Tracking earns its place the moment you add a second channel or a second region, because it lets you run a profit and loss per channel without duplicating the chart of accounts. Just remember you only get two categories, so spend the first one on the dimension you will report on most.

Connect Etsy to Xero free

Start with the free reimbursement audit, then flat all-channel pricing from $19/mo. No per-channel fees.

Also see: Amazon + QuickBooks Online · Amazon + Xero · eBay + QuickBooks Online · eBay + Xero · all guides