Etsy Seller Accounting with Zoho Books: Fees, Tax, and Payout Reconciliation
Etsy sellers deal with five or more fee types per transaction, weekly deposits that net everything out, and COGS calculations unique to handmade goods. Here's how to configure Zoho Books so the numbers are actually right.
# Etsy seller accounting with Zoho Books: fees, tax, and payout reconciliation
Etsy looks simple until you try to account for it correctly. Orders come in, Etsy processes the payment, a deposit lands in your bank every week. Record that deposit as revenue and your books are wrong, probably by 20–35% of actual gross sales, because what you receive is net of Etsy's transaction fee, payment processing fee, listing auto-renewal fees, and any offsite ads charges for that period.
There's also a COGS problem that doesn't apply to sellers who buy and resell finished goods. Handmade goods COGS comes from raw materials. Each product consumes specific inputs at specific quantities, and those costs need to flow through accounting correctly if your gross margin is going to mean anything.
TL;DR: Etsy sellers need accounting that records gross sales (not net deposits) as revenue, maps five fee types to the correct accounts, calculates COGS from raw material inputs for handmade goods, and handles multi-currency for international sales. Zoho Books does all of this when configured correctly. The setup is the work. Once done, the books run accurately from there.
What makes Etsy accounting different
The payout is not your revenue
Etsy's weekly (or on-demand) deposit is the number most sellers look at when they want to know what they made. It's not that number. It's net of:
- Etsy transaction fee (6.5% of the sale price including shipping)
- Etsy Payments processing fee (3% + $0.25 in the US, variable by country)
- Listing fees auto-renewed during the period ($0.20 per listing)
- Offsite ads fees if any sales came from Etsy's ad placements
- Regulatory operating fees in some markets
Say you had $10,000 in Etsy sales and all those fees totalled $2,200. Your deposit was around $7,800. Record $7,800 as revenue and you've understated gross sales by 22%. Your P&L looks like a smaller business than it is. Margins look healthier than they are because fees aren't visible as costs. And tax filings reflect the wrong gross income figure.
Etsy's fee structure has more categories than most sellers account for
| Fee type | Rate | Accounting category |
|---|---|---|
| Transaction fee | 6.5% of sale price + shipping | Cost of Sales |
| Payments processing fee | 3% + $0.25 (US) | Cost of Sales |
| Listing fee (initial) | $0.20 per listing | Operating expense |
| Listing auto-renewal fee | $0.20 per renewal | Operating expense |
| Offsite Ads fee | 12–15% on qualifying sales | Advertising expense |
| Pattern subscription | From $15/month | Operating overhead |
| Regulatory operating fee | Market-dependent | Operating expense |
Each belongs in a different account. Transaction and payments processing fees are variable costs of sale, specifically Cost of Sales. Offsite ads fees are paid acquisition costs, specifically advertising. Listing and renewal fees are overhead. Lump them all in a single "Etsy fees" bucket and you lose visibility into whether your offsite ads spend is actually profitable, what your true margin is on each sale, and what it really costs to maintain your listing count at scale.
Handmade COGS is a different calculation
Sellers who buy and resell finished goods have a simple COGS: purchase price per unit, multiplied by units sold. Handmade sellers have a different problem. Each product consumes specific raw materials at specific quantities, and those inputs have unit costs that shift when you buy in volume or when supplier prices change.
A candle might need 8oz of wax, 1.5oz of fragrance oil, one wick, and a glass vessel. The COGS per candle is the sum of each material at its current cost. Buy wax in bulk and the per-ounce cost drops, so COGS changes. Track this in a spreadsheet and forget to update after a bulk purchase, and your margin figures are stale from that day forward.
International sales add currency complexity
Etsy facilitates global sales. If you're based in the UK and sell to a US buyer, Etsy converts the price and deposits to you in GBP. The exchange rate on each transaction affects what you receive. Each sale should be recorded at the rate on the transaction date, not the deposit date, not a quarterly average.
For sellers with regular international volume, the difference between per-transaction spot rates and a quarterly average can produce visible margin variance in monthly reporting.
Setting up Zoho Books for Etsy
Chart of accounts
Set up separate accounts for each fee type before you import anything. Here's a working structure for Etsy sellers:
Revenue - Etsy Product Sales (gross sale price) - Etsy Shipping Revenue (if you charge for shipping)
Cost of Sales - Raw Materials / COGS (fed by Zoho Inventory BOMs) - Etsy Transaction Fees (6.5%) - Etsy Payments Processing Fees (3% + $0.25) - Packaging and Fulfilment Costs
Advertising - Etsy Offsite Ads
Operating expenses - Etsy Listing and Renewal Fees - Etsy Pattern Subscription (if applicable) - Etsy Regulatory Fees
Other Income - Etsy Reimbursements (rare)
With this structure, gross margin reflects the real cost of making and selling. Offsite ads show up as their own line so you can measure them properly. Overhead stays out of variable cost calculations.
Tracking raw material COGS with Zoho Inventory
Zoho Inventory supports bills of materials (BOMs), which are product recipes listing each raw material input and the quantity consumed per finished unit. Set up a BOM for each SKU:
- Create raw materials as items in Zoho Inventory (wax, fragrance oil, jars, wicks, etc.)
- Set a cost per unit for each material, updated when you purchase new stock
- Build a BOM for each finished product with materials and quantities
- When an Etsy order syncs, Zoho Inventory uses the BOM to calculate COGS and reduce raw material stock
The result is COGS calculated at the actual material cost basis at the time of each sale. If you buy 50lb of wax in March at $4.20/lb and 100lb in June at $3.85/lb, the COGS for each batch of candles sold reflects what you actually paid, not a blended average from a spreadsheet that hasn't been updated in six months.
Revenue recognition: order date matters
Record revenue when the order is placed and fulfilled, not when the deposit arrives. An order placed April 30 that deposits May 5 belongs in April. Record on deposit date and your monthly figures shift by however long Etsy's deposit cycle runs.
For sellers on weekly or biweekly deposits, month-end timing creates systematic understatement in one month and overstatement in the next. Zoho Books records on invoice or order date, which is the correct basis.
Handling offsite ads reconciliation
Offsite ads fees appear in your Etsy Payment Account statement alongside other fees. They're not a separate transaction. They come out of the same net deposit. When mapping statement data, identify offsite ads charges by transaction description and route them to your advertising account.
Once those fees are in their own account, you can compare organic margin against paid-acquisition margin. For sellers who can't opt out of Offsite Ads (annual Etsy sales above $10K), that split matters: do those ads bring in genuinely incremental sales, or do they mostly capture orders that would've come through organic search anyway? You can't answer that without clean advertising cost data separate from transaction fees.
Connecting Etsy into broader operations
Most Etsy sellers who grow past a certain volume add channels: Amazon Handmade, their own Shopify store, wholesale to retailers. Once you're running more than one channel, you need one inventory system covering all of them. Our eCommerce operations services cover the full multi-channel setup for sellers expanding beyond a single marketplace.
Zoho Inventory connects to Etsy, Shopify, and Amazon. Raw material stock stays in one pool, decremented by sales from any connected channel. Zoho Books produces one P&L across all channels, with channel-level profitability available through Zoho Analytics.
For a handmade seller running Etsy alongside Shopify, separate inventory in separate systems produces regular stockout surprises: you sell the last unit through Shopify, Etsy doesn't know, and the next Etsy order is for something you don't have. One inventory pool prevents that problem at the source.
For the full picture of how Zoho handles multi-channel eCommerce, see our Zoho for eCommerce guide.
Getting the setup right
The configuration work is front-loaded: chart of accounts, BOM setup for each product, integration mapping. Once that's done correctly, the system handles categorisation automatically on every subsequent transaction.
The mistake most sellers make is connecting Zoho Books to their bank feed, seeing the net Etsy deposits, and calling that their accounting system. Bank feed accounting for Etsy gives you wrong revenue, invisible fee categories, and no COGS data for handmade goods. It's faster to set up, sure. But it consistently produces wrong numbers.
Zolify has configured Zoho Books for Etsy, Amazon, eBay, and Shopify sellers, including those with handmade goods, raw material tracking, and multi-channel inventory. Every implementation includes a CA reviewing the chart of accounts and COGS structure before go-live. The margin data is accurate from the start, not discovered to be wrong at year-end.
As an Official Zoho Authorized Partner with 100+ eCommerce implementations, we've handled the Etsy-specific edge cases: offsite ads charges that spike unexpectedly, raw material cost changes mid-year that need to roll through COGS correctly, multi-currency deposits that don't reconcile cleanly against order-date revenue. Those get handled in configuration, not surfaced six months after go-live.
If your current Etsy accounting records deposits as revenue, or you don't have raw material COGS tracking, get an eCommerce ops audit and we'll show you where the numbers are drifting.
Related reading
- Zoho Books Implementation: Expert Setup by Zolify
- Managed eCommerce Accounting Services
- eBay Seller Accounting with Zoho Books: Complete Setup Guide
- Amazon Seller Accounting with Zoho Books: The Complete Guide
- Zoho for eCommerce: The Complete Operations Platform Guide
- eCommerce Accounting Software: What Actually Works
Ready to get your Etsy accounting set up correctly? Book a free consultation and we'll review your current setup.
Coming from QuickBooks, Xero, or spreadsheets? See our QuickBooks to Zoho Books Migration Guide or Excel to Zoho CRM Migration Guide.
Frequently Asked Questions
Most Etsy sellers start with spreadsheets or simple tools like Wave. At low volume (under 50 orders a month) that's manageable. Above that, Etsy's multi-tier fee structure and the need to track raw material costs for handmade goods makes spreadsheets error-prone. Zoho Books handles Etsy's fee categorisation, connects to Zoho Inventory for raw material and product stock tracking, and supports multi-currency for international Etsy sales, all from one system.
Etsy Payments processes all buyer payments (cards, PayPal, Apple Pay, etc.) and consolidates them into scheduled deposits to your bank, weekly by default, or on-demand. Each deposit is net of all fees accrued in that period: transaction fees, payment processing fees, listing fees auto-renewed, and any offsite ads charges. The correct approach is to record the gross sale as revenue when the order is placed, then record each fee type in its correct expense account. What hits your bank is the net. Recording it as revenue produces an understated figure that compounds across the year.
Etsy's Offsite Ads fee is charged when a buyer clicks an Etsy-placed ad on Google, Facebook, or another platform and then makes a purchase. Sellers with over $10,000 in annual Etsy sales are enrolled and charged 12% on offsite-ads sales; sellers below that threshold are charged 15% and can opt out. In accounting, offsite ads fees are advertising expenses, not cost of sales. They belong in a dedicated Etsy Offsite Ads or Marketplace Advertising account, so you can measure what percentage of Etsy revenue is going to paid acquisition versus organic sales within the marketplace.
Handmade goods COGS is built from raw materials: yarn, fabric, clay, resin, components, packaging, and similar inputs. In Zoho Books connected to Zoho Inventory, you create bills of materials (BOMs) for each product that list the raw material inputs and quantities consumed per unit. When a sale occurs, Zoho Inventory deducts the raw materials from stock and calculates COGS automatically based on the BOM. Your gross margin is then calculated against actual material costs rather than a rough estimate, which matters if raw material prices shift across the year.
Yes, in US states where Etsy is a marketplace facilitator (which covers most US states), Etsy collects and remits sales tax directly. You do not collect or remit it. The sales tax never passes through your books. Etsy handles it entirely. For sales outside marketplace facilitator states, or for international sales outside countries where Etsy remits VAT, you may have separate tax obligations. Zoho Books handles tax tracking for those cases and integrates with Zoho's compliance tools for VAT in applicable jurisdictions.
