Most Etsy sellers know their revenue. Almost none know their actual profit.
Small observation from building a bookkeeping tool for Etsy sellers and freelancers: almost everyone I talked to could tell me their monthly sales number instantly. Almost nobody could tell me their profit number without stopping to think, or just guessing.
The gap isn't laziness. Revenue is handed to you - Etsy puts it right on your dashboard - but profit means actually subtracting materials, Etsy/payment fees, shipping, and a tax set-aside, and most people are doing that subtraction in their head, if at all. That's how you end up feeling profitable all year and then get surprised at tax time.
I built Small Business Profit & Tax Tracker to fix this for my own use case first: log a sale or expense once, and it auto-calculates a P&L by category, runs a break-even/pricing calculator so you actually know what to charge, and keeps a running tax set-aside estimate that updates every time you log something. No accounting software login, no dashboard to configure - just a spreadsheet that does the subtraction you're currently doing by feel.
It's live on Etsy and Gumroad if anyone wants to see how it's structured: https://www.etsy.com/listing/4581328562/etsy-seller-profit-tax-tracker-live and https://thefinanceguru1.gumroad.com/l/small-business-profit-tax-tracker
Curious how others here actually handle this - real bookkeeping software, a spreadsheet you built yourself, or mostly gut feel until tax season forces the issue?
The fee I see people forget most is that Etsy charges its 6.5% on the total the buyer pays, shipping included. On a $25 item with $5 shipping that's 6.5% of $30 ($1.95), plus the ~3% + $0.30 processing on the full amount as well. Roughly $3 in platform fees before materials, packaging, or the listing fee — so a sale that looks like 30% margin at the revenue line is closer to 18% once the actual math is done.
The distinction between revenue being handed to you and profit requiring the unglamorous subtraction is so real—especially the tax-set-aside surprise. I keep a free monthly P&L + quarterly tax set-aside sheet for solopreneurs/freelancers at https://solopreneurpl.com; it’s deliberately a simple park-the-habit-and-know-the-number workflow, so it could sit alongside your Etsy-specific tracker rather than replace it. Curious: in your conversations, is the bigger adoption hurdle getting people to log materials/shipping as they happen, or getting them to open the numbers at month-end?
From the handful of real conversations I've had, it's the logging-as-you-go part, not opening the numbers at month-end. Etsy sellers are used to checking a sales number obsessively but treat expenses as a once-in-a-while chore, so the habit that has to change is smaller (log this one expense now) but has to happen more often, which is a different kind of hard than a monthly review. Good luck with solopreneurpl - the "sit alongside, don't replace" framing is smart, most people in this space seem to assume they need to win the whole workflow instead of one habit.
The bit I'd stress-test is materials cost, since it's the one number in that P&L that isn't handed to you the way revenue and Etsy fees are. Shipping and fees come from the platform, but materials cost is whatever the seller types in, and unlike a spreadsheet formula that fails loudly when it's wrong, a slightly-off materials number quietly produces a profit and tax set-aside that look precise but aren't. Freelancers run into the same kind of gap with hours they don't bother logging because the work doesn't feel like "real work"; the tool doesn't complain, the number is just quietly wrong. Does the tracker flag anything about that input, a sanity check against typical material-cost ratios for the category, say, or is accuracy there entirely on the seller?
Honest answer: no, it doesn't flag anything right now. It's a straightforward input cell, no sanity check against typical material-cost ratios by category. That's a real gap, not a design choice - accuracy on that number is entirely on the seller today. A category-average check (like "handmade jewelry materials are usually 15-25% of price, yours is at 60%, double check this") is a genuinely good idea for a v2, thank you for naming the actual weak point instead of the more comfortable stuff to praise.
Thanks for writing this up. Bookmarking it for later.
Good point. Did you test that with users before committing to it?
Clear and practical, thanks. Did anything surprise you along the way?
Appreciate the honesty here, most people only share the wins.
Makes sense. Are you planning to charge for it, or keep it free for now?
Great breakdown. What feedback have you had from early users?
Interesting approach. What was the hardest part to get right?
Built the same shape of thing for Stripe. The trap I hit was getting the direction wrong: my tool counted a won chargeback as money lost, but on a win the money comes back. Only the fee is gone, and on Stripe one of the two dispute fees returns and one doesn't. Does Etsy give its fee back on a refunded sale?
No automatic handling of that today - it's a manual ledger, so on a refund the seller just logs a reversing entry for whatever Etsy actually nets out to them, fee included. I don't want to guess at Etsy's exact refund-fee policy since I'm honestly not 100% sure it's consistent across categories, so right now that accuracy is on the seller checking their own Etsy payment account rather than the tool inferring it. Your Stripe example is exactly the kind of "quietly wrong in one direction" bug I'd want to catch before shipping automatic refund handling, so good flag.
Revenue-profit gap is the same trap in SaaS. Stripe dashboard shows MRR, feels great, then you add up infrastructure, API costs, domain renewals, translation services and the margin is much thinner than the number suggests. We run UtilitySEO in seven languages and each one adds hosting and API cost that does not show up in the revenue line.
The spreadsheet-as-product approach is smart for this audience specifically because Etsy sellers already live in spreadsheets. Asking them to learn accounting software is a different conversion problem from asking them to use a spreadsheet they already understand. The distribution channel being Etsy itself is also right — they are already buying there.
The question I would watch: do buyers actually use it past the first month, or does it become another unused tool once tax panic subsides? If the P&L updates automatically from Etsy data, retention solves itself. If it requires manual logging, you will want to check 30-day active use rates early.
Honest answer, and it's the uncomfortable one: it's manual logging right now, not synced from Etsy's API. So the retention risk you're naming is real and unresolved - I don't have 30-day active-use data yet because I don't have real users yet, but I'd bet the honest outcome without a fix is exactly what you describe, a burst of use around tax panic and then drop-off. An Etsy-data auto-sync is the obvious next version if this gets any real usage, I just haven't built it because I wanted to ship something and get feedback like yours before investing in that integration.
Have buyers shown they use the tracker throughout the year to make pricing or spending decisions, or does the urgency mostly appear when tax season gets closer?
Same honest answer I gave James_UtilitySEO above - no data yet since I don't have real users, and it's manual logging today rather than synced from Etsy, so I'd expect the same tax-panic-then-drop-off pattern you're both flagging until that changes. Appreciate two people independently naming the same weak spot.
The tax-season dependence is the part I’d be most curious to follow as usage develops. Could be useful to compare notes by email sometime, if you’re open to it.
Love this angle. Building Xstream4K right now so this hits close to home — what made you look into it in the first place?