Every Etsy seller who has ever opened a spreadsheet at tax time hits the same wall: the sales number on the dashboard says one thing, the deposits in the bank say another, and nothing lines up. If you've stared at a $90.05 deposit next to a $100 sale and wondered where the rest went — or why this week's payout covers orders from three different days — you're doing the right thing by trying to reconcile. Here's how to actually do it in 2026, without an accounting degree.
What "reconcile" really means
Reconciling just means proving two records agree: the money Etsy says it paid you, and the money your bank says it received. When they match to the cent, your books are trustworthy — and every fee, refund and reserve is accounted for. When they don't, something is missing, and that something is usually a fee you didn't record or a refund that landed in a different week. Reconciliation is the discipline that turns "roughly right" into "provably right."
Why your deposit never equals your sales
Start with the single most common confusion: a payout is not a sales figure. Etsy deposits the net amount — what's left after it removes its fees before the money ever leaves the platform. On a clean US $100 sale in 2026, Etsy takes a $0.20 listing fee, a 6.5% transaction fee ($6.50, charged on the item plus shipping), and payment processing of 3% + $0.25 ($3.25) — $9.95 in all — and deposits $90.05. So the deposit was never supposed to equal the sale. This is the same reason your payout is lower than your sales; reconciling is how you confirm the difference is exactly the fees and nothing else.
The five reasons the numbers drift apart
Once you accept that deposits are net, five specific things still make reconciliation tricky:
- Fees are removed before payout — so you must add the fees back to move from "deposited" to "earned." If you only record the deposit, your expenses vanish and your tax deductions with them.
- One deposit covers several days of orders. Etsy's payout cycle batches transactions, so a single bank deposit rarely maps to a single order. Always match your payout total to the bank, not individual order dates (more on timing in when does Etsy pay you).
- Refunds land in a different cycle than the original sale, so a payout can be dragged down by a refund for an order you booked weeks ago — and the fee treatment isn't always symmetric (does Etsy refund fees on refunds).
- Reserves hold part of your money back. If Etsy places a payment reserve, a slice of a sale is withheld and released later, so the deposit is smaller now and larger afterward for reasons unrelated to fees (why Etsy holds your money).
- Sales tax passes through. Etsy collects and remits sales tax on your behalf; it inflates the order total but is never your income, so it must be stripped out — not counted as revenue.
A step-by-step reconciliation (2026)
Here's the routine that works, monthly or weekly:
- 1. Export the source of truth. Go to Shop Manager → Finances → Payment account and download the CSV for the period. This is the ledger Etsy actually charged you against — not the Orders page. If you're new to it, here's how to read your Etsy payment account.
- 2. Group by payout, not by order. Each payout line in the CSV should correspond to one bank deposit. Line them up side by side.
- 3. Match each payout to its bank deposit. The payout amount and the bank credit should be identical to the cent. If they are, that cycle is reconciled.
- 4. Explain every difference between gross sales and net payout as one of: a fee, a refund, a reserve hold/release, or remitted sales tax. If a gap has no label, that's your error to chase — a miscategorised fee or a missed refund.
- 5. Record the pieces, not just the total. Book gross income, then each fee as an expense, then refunds — so your profit spreadsheet shows the full picture and your deductions survive an audit.
A worked example
Suppose a week's payout is $412.60 and it covers eight orders totalling $500 in sales, with one $40 refund from the prior week. Fees on the eight orders run about $47.40; the refund removes another $40. So: $500 − $47.40 fees − $40 refund = $412.60 — and that should equal the bank deposit exactly. If your bank shows $412.60, you're reconciled. If it shows $409.85, the $2.75 difference is a clue: maybe an Offsite Ads fee you didn't expect, or a currency-conversion charge. Reconciliation is what surfaces that clue instead of letting it hide in a "close enough" total.
Where this gets genuinely hard
The mechanics above are simple; the tedium is real. Fees are scattered across payout cycles, refunds cross periods, reserves release unpredictably, and for UK, EU and Türkiye sellers there's VAT charged on the fees themselves that no calculator shows. You can estimate a single order with our free Etsy fee calculator, but reconciling a whole month by hand in a spreadsheet is where most sellers give up — and where errors quietly compound until tax season.
That's exactly the gap Seller Profit Lens fills: it connects to your shop read-only, reads the fees, refunds and reserves Etsy actually applied on every order to the cent, and matches them against your payouts automatically — so your books are reconciled without CSV wrangling, and your real per-product profit falls out of it. It's in free beta now. Join the waitlist →