Etsy Bookkeeping: 8 Problems That Wreck Shop Finances

Etsy bookkeeping fails the same way for almost every shop: the deposit hits the bank, the seller books it as sales, and from that moment the books understate revenue, hide fees, and can't compute a margin. Multiply that by six fee types, an advertising charge that hits some orders and not others, and the materials accounting that handmade goods require, and you get books that can't answer whether the shop actually makes money. Here are the eight problems we see in Etsy shops' books, and the fix for each.

Problem 1: The payment account nets everything before you see it

Etsy doesn't charge fees separately; it runs everything through your Etsy Payments account. Sales flow in, then listing fees, transaction fees, processing fees, ad charges, label costs and refunds all come out of the balance, and whatever's left lands in your bank on your deposit schedule. Sell $1,000 in a week and the deposit might be $840. Book that $840 as sales and you've understated revenue by 16% and recorded zero deductible fees; run a slow week where fees exceed sales and Etsy charges your card, producing a "negative deposit" your bank feed can't classify at all.

The fix: book gross sales, fees and refunds from the monthly Etsy Payment account CSV, and treat the deposit as what it is: a transfer of the remaining balance. It's the same gross-versus-net discipline Amazon sellers need for settlement accounting, at friendlier volume.

Problem 2: Six fee types, one blurry expense line

The current Etsy fee stack for a US shop: $0.20 listing fees (per listing, renewing every four months and on every sale), a 6.5% transaction fee on the item price plus shipping and gift wrap, payment processing at 3% plus $0.25, Offsite Ads at 12% or 15% on attributed orders, a 2.5% currency conversion fee where it applies, optional Etsy Plus at $10 a month, and a one-time setup fee for new shops. Booked as one "Etsy fees" blob, you can't see that transaction fees scale with revenue while listing fees scale with catalog size, or that your effective total take is drifting from 11% toward 17% as Offsite Ads bite harder.

The fix: separate accounts for transaction/processing fees, listing fees, and advertising, per our chart of accounts template. Fee creep is visible in an itemized ledger and invisible in a blob, and Etsy's take as a percent of gross is a number every shop should track quarterly.

Problem 3: Offsite Ads hits some orders and not others

Offsite Ads is Etsy advertising your listings on Google, Facebook and elsewhere, then charging you 15% of any attributed order (12% once your trailing twelve-month revenue passes $10,000, at which point participation also stops being optional; the fee caps at $100 per order). The bookkeeping problem is its randomness: two identical $60 orders, one costing you $9 more than the other because of where the buyer clicked. Shops that budget advertising as a steady percent get surprised, and shops that don't isolate the charge can't tell whether Offsite Ads orders are profitable at all, which for low-margin items at 15% they sometimes aren't.

The fix: book Offsite Ads to its own advertising account and check the math per affected order once a quarter. If a $12 item nets negative after a 15% ad fee, that's a pricing decision waiting for data, and the mandatory-participation threshold means "just turn it off" stops being an option right as your volume makes it matter.

Problem 4: Materials COGS, the maker's version of inventory accounting

A maker's cost of goods is built, not bought: fabric, clasps, glaze, lumber, resin, packaging. The IRS treats handmade inventory like any other: materials are inventory when purchased and cost of goods sold when the finished piece sells, which means valuing raw materials, works in progress and finished goods, at least at year end. Expensing every Michaels run on purchase date overstates costs in stock-up months and understates them later, the same seesaw that plagues resellers, just measured in beads.

And the rule that stings: your own labor is not COGS for a sole proprietor. The forty hours in a quilt never touches the books as a cost; you're paid through profit. Price accordingly.

The fix: a per-product materials cost sheet (the handmade equivalent of a landed-cost sheet), a year-end count of materials and finished goods, and COGS computed with the standard formula. It's an afternoon per quarter, and it's the difference between knowing a product line's margin and guessing it.

Problem 5: Sales tax looks handled, and mostly is

Etsy is a marketplace facilitator, so it collects and remits sales tax on Etsy orders in every state with a sales tax. Genuinely handled, with two leftovers. First, the collected tax shows up in your payment account flows, and books that don't strip it out inflate gross sales. Second, the moment you sell anywhere else (craft fairs, your own site), that channel's tax is yours, measured under each state's rules: thresholds run from $100,000 in most states to $500,000 in Texas and California, and in-person sales at a Texas fair are taxable from the first dollar with no threshold at all.

The fix: tax collected by Etsy stays out of revenue entirely; tax you collect directly sits in a liability account until remitted. Never in income, ever.

Problem 6: The 1099-K whiplash

Etsy 1099-K rules have changed direction three times in five years, and 2025 legislation settled them back where they started: the federal threshold is $20,000 and 200 transactions again. But several states set their own, far lower triggers ($600 in Virginia, Maryland and Massachusetts among others, around $1,000 in New Jersey and Illinois), and Etsy issues forms accordingly. So whether a form arrives depends on where you live, and either way the form reports gross sales, before every fee and refund, the same trap that catches Amazon sellers every January.

The fix: report gross, deduct fees, and never file from deposits. And remember the form is informational: no 1099-K doesn't mean no taxable income. A profitable shop owes tax at $6,000 of sales exactly as it does at $60,000, quarterly estimates included; hobby-versus-business classification is its own question with its own rules, covered in our creator bookkeeping guide for the side-income crowd.

Problem 7: Multi-channel makers with one pile of records

The successful maker's arc: Etsy first, then craft fairs on Square, then a Shopify site, then maybe wholesale to local boutiques on invoices. Each channel has its own fees, its own payout rhythm, its own tax posture, and shops that pour it all into one undifferentiated ledger can't answer the only strategic question that matters: which channel is worth the next hour? Etsy's 17% all-in take versus Shopify's 3% processing looks damning until you price in the traffic Etsy brings and the ads Shopify needs, and only channel-level books can run that comparison honestly.

The fix: revenue and fees by channel, one inventory pool, and channel tagging on shared costs, the same architecture Shopify sellers and multi-platform resellers need. Square and fair sales also mean handling your own sales tax at in-person rates, one more reason the channels can't share a shoebox.

Problem 8: Bookkeeping once a year, at tax time

The most common Etsy bookkeeping system is a January spreadsheet marathon over twelve months of cold records: mystery deposits, a shoebox of materials receipts, and an Offsite Ads total nobody can reconstruct per order. Annual bookkeeping means every pricing decision all year ran on instinct, every quarterly estimate was a guess, and problems compounded for months before anyone saw them (ask the shops that found out in January that their bestseller lost money all fall).

The fix: a monthly close, even a light one: post the Etsy CSV, reconcile the payment account, update the materials sheet, glance at margin by product line. Two hours a month, and January becomes a non-event. The monthly rhythm has a side benefit nobody advertises: it's when you notice the anomalies worth money, like a refund rate creeping up on one product (a supplier quality problem surfacing) or a listing quietly renewing $6 a month in fees on items that stopped selling in March. Yearly books can't catch what monthly eyes would.

What Etsy actually keeps: a $1,000 month, itemized

Numbers make the netting problem concrete. Here's a plausible month for a small US shop: 25 orders averaging $40 including shipping charged, one $40 refund, three orders attributed to Offsite Ads at the 15% tier:

Line	Amount
Gross sales (25 orders, incl. shipping charged)	$1,000.00
Transaction fees (6.5% of item + shipping)	-$65.00
Payment processing (3% + $0.25 x 25)	-$36.25
Listing fees (30 listings at $0.20)	-$6.00
Offsite Ads (15% of $120 attributed)	-$18.00
Shipping labels purchased	-$95.00
Refund issued	-$40.00
Deposited to bank	$739.75

Etsy's take before labels and the refund is $125.25, about 12.5% of gross, and it climbs toward 17% for shops with heavier Offsite Ads attribution. Book the $739.75 as sales and every one of those lines vanishes: revenue understated by 26%, zero deductible fees on the books, and a "profit margin" that's really just a deposit ratio. Book the gross and the lines separately and you can see, for instance, that labels ran 9.5% of sales this month, which is a shipping-price conversation worth having. The CSV has every number; the whole game is posting them.

Etsy taxes FAQ

Are Etsy fees tax deductible? All of them: listing, transaction, processing, Offsite Ads, subscriptions, labels. But only if your books capture them, which deposit-based books don't. Shops that record net deposits routinely overpay income tax by deducting nothing Etsy kept.

Does Etsy report my sales to the IRS? Above the federal 1099-K threshold ($20,000 and 200 transactions), yes, and above much lower thresholds in several states. Below the thresholds, no form is issued, but the income is just as taxable and marketplace data is just as discoverable.

Do I owe quarterly estimated taxes on my shop? If the shop is profitable enough that you'll owe $1,000 or more at filing, generally yes: four payments a year, with a safe harbor pegged to last year's tax. It's the most commonly skipped obligation among makers who crossed from hobby scale to business scale mid-year.

Is my shop a hobby or a business? It matters more than people think: business losses can offset other income, hobby losses can't, and hobby income is still taxable with no deductions against it. Profit motive, regular activity and businesslike records are the factors, and ironically, keeping real books is itself evidence in your favor.

Does Etsy collect sales tax for me? On Etsy orders, yes, in every state with a marketplace facilitator law, which is now all of the sales tax states. Fairs and your own website remain your job.

When to hire it out (and what it costs)

DIY is the right answer for a small shop: under roughly $3,000 a month in sales, a spreadsheet plus the monthly routine above genuinely suffices. Past that, and certainly once multiple channels or quarterly estimates enter the picture, the hours and the error risk start costing more than help does; the full market pricing is in our bookkeeping cost guide, and our own rates start at $149 a month for Books Lite. We built a bookkeeping service specifically for Etsy sellers: gross-not-net revenue from the payment CSV, every fee type itemized, materials COGS handled, channels separated, books in your own QuickBooks or Xero file.

Not sure which side of the line you're on? Two free tools answer it: our money leak checklist takes ten minutes and flags the expensive gaps (Offsite Ads math and fee creep are perennial finds for Etsy shops), and the free Books Teardown goes deeper: we'll walk your actual books with you and show you what they're hiding; request one here. A shop that knows its numbers prices with confidence, raises prices when materials costs say to, and drops the products that only felt profitable. Pricing is where handmade businesses live or die, and pricing runs on books.