Most Etsy sellers know their revenue. Almost none know their actual profit.

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?

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?

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?

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.

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?

Love this angle. Building Xstream4K right now so this hits close to home — what made you look into it in the first place?