Etsy Xero Integration: Automated Accounting for Etsy Sellers

For Etsy sellers using Xero — particularly in the UK, Australia, and New Zealand where Xero dominates small business accounting — the core bookkeeping problem is the same: Etsy deposits a net payout that bundles gross sales, listing fees, transaction fees, payment processing fees, Offsite Ads costs, and refunds into a single number. Recording that lump sum as Xero revenue overstates income and hides your true Etsy cost structure.

TL;DR: SyncTools connects Etsy to Xero — automatically mapping sales, listing fees, transaction fees, payment processing fees, and payout settlements to the correct Xero accounts. Reconciles to your Etsy deposit. Setup takes under 30 minutes.

SyncTools automates the translation from Etsy Payments to Xero — so every payout reconciles cleanly and your Xero P&L shows true Etsy profitability.

The Etsy Accounting Problem SyncTools Solves

Each Etsy payout includes revenue from multiple orders offset by a stack of Etsy-specific fees:

Listing fee — $0.20 per item listed (auto-renewed every four months)
Transaction fee — 6.5% of the sale price including shipping and gift wrap
Payment processing fee — varies by country (3% + $0.25 in the US; 4% + £0.20 in the UK; 3% + $0.25 in Australia)
Offsite Ads fee — 12–15% of an order’s sale price if the buyer arrived via an Etsy-promoted link
Refunds — full or partial refunds deducted from the next payout

The net amount lands in your bank without a structured breakdown Xero can interpret directly. Without automation, you need to manually split each Etsy payment CSV into Xero — calculating gross sales, each fee type, and refund amounts for every settlement period. SyncTools reads the raw Etsy transaction data and creates properly structured Xero entries automatically.

What SyncTools Syncs from Etsy to Xero

Sales invoices — individual order invoices or daily/period-level summaries
Credit notes — Etsy refunds mapped to Xero credit notes against the original sale account
Listing fees as bills — $0.20 per-item fees mapped to a dedicated Xero advertising or marketplace fee account
Transaction fees — 6.5% selling fees posted to a separate Xero merchant fee expense account
Payment processing fees — Etsy Payments processing costs categorized to Xero payment processing expense
Offsite Ads fees — 12–15% ad fees posted to Xero advertising expense, separate from transaction fees
Sales tax / VAT — Etsy-collected marketplace facilitator tax and VAT mapped to the correct Xero tax rate, separate from revenue
Payout reconciliation — Etsy payout deposits matched to Xero bank transactions via a clearing account
Multi-currency — GBP, AUD, EUR, and other currencies synced using Xero’s multi-currency feature
COGS — cost-of-goods synced for gross margin visibility in Xero profit and loss

Setting Up the Etsy Xero Integration

Step 1: Authorize Etsy Connect SyncTools to your Etsy shop. SyncTools requests read-only access to your order data, fee statements, and payout history via the Etsy API — it never writes to your Etsy store.

Step 2: Connect Xero Authorize SyncTools via Xero’s OAuth flow. Choose whether transactions post as invoices and bills (granular per-order) or as journal entries (summarized by period).

Step 3: Map accounts Map Etsy revenue categories to Xero income accounts, each fee type to expense accounts, and Etsy-collected tax to Xero tax rates. SyncTools provides sensible defaults you can adjust to match your existing chart of accounts.

Step 4: Set sync schedule and go live Choose daily sync or per-payout sync. SyncTools runs automatically and emails you a summary report after each run.

Etsy Xero Integration: Feature Comparison

Feature	Included
Sales revenue sync (individual orders)	Yes
Sales revenue sync (summarized)	Yes
Listing fee categorization	Yes
Transaction fee categorization	Yes
Payment processing fee categorization	Yes
Offsite Ads fee categorization	Yes
Refund / return credit notes	Yes
Payout-to-bank reconciliation	Yes
Sales tax / VAT mapping	Yes
Multi-currency support	Yes
COGS sync	Yes (Standard plan+)
Historical data backfill	Up to 24 months
Sync frequency	Daily / per payout

Etsy Payout Reconciliation in Xero

Etsy Payments consolidates every order, fee, and refund into a single payout deposited to your bank typically every 1–3 business days after order completion. For UK and Australian Etsy sellers on Xero, this creates a reconciliation mismatch: Xero sees a single ACH or BACS deposit, while the underlying Etsy transaction detail lives in Etsy’s payment account — not in Xero.

SyncTools solves this with a clearing account approach: each Etsy transaction (sale, refund, fee) posts to a dedicated Etsy clearing account in Xero as it occurs. When the payout lands in your bank, it matches the net clearing account balance exactly — one-click reconciliation, no CSV required.

Etsy Fees in Xero: Why Separation Matters

Etsy’s fee structure is more granular than most marketplaces. A single Etsy order can generate four or five distinct fee lines — listing, transaction, payment processing, Offsite Ads, and regulatory operating fees in some markets. Without SyncTools, these fees are either lumped together or ignored, making it impossible to know which Etsy fee category is eroding margin the most.

SyncTools maps each fee type to a separate Xero expense account, giving you a fee-level breakdown in your Xero P&L. UK and Australian sellers find this particularly useful for VAT return preparation — Etsy’s UK VAT on seller fees is a recoverable input tax, and having it properly coded in Xero removes a manual step at quarter end.

Multi-Currency Etsy Sales in Xero

Etsy sellers in the UK receive GBP payouts; Australian sellers receive AUD; European sellers receive EUR. SyncTools syncs each transaction in its originating currency and applies exchange rates using Xero’s multi-currency feature, keeping your foreign-currency income and expense accounts clean and your base-currency reporting accurate.

For UK sellers running both a Xero GBP base and selling to international buyers, SyncTools handles the currency split — Etsy-collected international sales in foreign currencies are converted at the prevailing rate, posted to the correct Xero account, and reconciled against the GBP payout without manual FX calculation.

Why Xero Users Choose SyncTools for Etsy

Xero’s bank rules cannot decode Etsy payout reports. SyncTools fills that gap — reading the full Etsy statement detail, splitting it into structured Xero transactions, and leaving your bank rules free for simpler matching tasks.

The result: a Xero P&L that shows true Etsy profitability by fee category, a balance sheet that’s clean at month-end, and VAT accounts that don’t require manual adjustment before each return.

Start your 30-day free trial — no credit card required

Schedule a demo

Related integrations:

Etsy QuickBooks Online Integration — for Etsy sellers using QuickBooks
eBay Xero Integration — for multi-channel sellers also on eBay
Amazon Xero Integration — for Amazon sellers using Xero
Shopify Xero Integration — for Shopify sellers using Xero

Related guides:

Etsy Xero Integration: Step-by-Step Setup Guide — detailed walkthrough covering chart of accounts, fee mapping, VAT handling, and payout reconciliation
Etsy Accounting for Sellers: From Payout to P&L
Accounting Challenges in eCommerce Business

FAQ: Etsy + Xero Integration

How does SyncTools sync Etsy data to Xero?

SyncTools connects to your Etsy shop via the Etsy API and pushes transaction data into Xero as invoices, credit notes, or journal entries — covering gross sales, listing fees, transaction fees, payment processing fees, Offsite Ads fees, refunds, and payout settlements, all mapped to your Xero chart of accounts.

Can SyncTools separate Etsy fees from revenue in Xero?

Yes. SyncTools maps each Etsy fee category — listing fees ($0.20 per item), transaction fees (6.5% of sale price), payment processing fees (3% + $0.25 in the US), and Offsite Ads fees (12–15%) — to separate Xero expense accounts, giving you a granular breakdown of Etsy selling costs and an accurate gross margin in your Xero P&L.

How does the integration handle Etsy sales tax and VAT for Xero?

Etsy collects and remits marketplace facilitator tax in most US states, and VAT on cross-border digital and physical goods in the UK and EU. SyncTools maps Etsy-collected tax to the correct Xero tax rate — separate from your revenue — so your Xero tax accounts are accurate and your VAT returns require no manual adjustment.

How are Etsy payout settlements reconciled in Xero?

SyncTools posts Etsy transactions to a clearing account in Xero. Each Etsy payout (typically every 1–3 business days after order completion for Etsy Payments sellers in the UK and Australia) matches the net clearing account balance, so reconciling the bank deposit in Xero is a one-click match rather than a manual calculation across dozens of orders and fee lines.

Does SyncTools support Etsy refunds in Xero?

Yes. Etsy refunds and returns are synced to Xero as credit notes against the original revenue account, keeping your gross sales and returns correctly separated in your Xero P&L.

Does SyncTools support multi-currency Etsy sales in Xero?

Yes. SyncTools supports Etsy sellers operating across multiple currencies — GBP for UK sellers, AUD for Australian sellers, EUR for European sellers, and USD for US sellers. Transactions are synced to Xero using Xero’s multi-currency feature, with exchange rates applied per transaction, so your base-currency reporting stays accurate.

Can I sync historical Etsy data to Xero?

Yes. SyncTools supports backfilling historical Etsy transaction data into Xero on Standard and Plus plans, covering up to 24 months of sales, fees, and refunds from before your SyncTools setup date.

Is there a free trial for the Etsy Xero integration?

Yes. SyncTools offers a 30-day free trial with no credit card required. You can connect Etsy and Xero, run a sync, and verify your data in Xero before subscribing.

How to Connect Etsy to Xero in 5 Steps

Connecting Etsy to Xero with SyncTools takes under 20 minutes and requires no developer access.

Step 1 — Connect your Etsy shop to SyncTools In SyncTools, navigate to eCommerce Platform and select Etsy. Complete the Etsy OAuth flow to grant SyncTools access to your Etsy shop orders, payments, fees, and refund data.

Step 2 — Connect your Xero account In SyncTools, navigate to Accounting System and select Xero. Complete the Xero OAuth flow. SyncTools reads your chart of accounts, tracking categories, and bank accounts, then pre-fills a recommended mapping.

Step 3 — Map Etsy transaction types to Xero accounts Assign each Etsy transaction component — gross sales, listing and transaction fees, refunds, taxes, and Etsy payouts — to the correct Xero account. SyncTools pre-fills a recommended mapping.

Step 4 — Choose your sync mode Select whether SyncTools reconciles by settlement period (one journal entry per payout — ideal for marketplace sellers) or by individual order. Settlement mode ensures your books match your bank deposit exactly.

Step 5 — Run your first sync and verify Click Sync Now. Etsy data posts to Xero automatically. Check the SyncTools sync log and verify that the posted entries appear correctly in Xero with the right account mapping.

See also: Xero eCommerce Accounting Guide — how to structure Xero for multi-channel eCommerce.

Etsy Xero Integration

Ready to automate your accounting sync?