Seller Fee & Profit Workbook

You listed it at $29. The payout said $25.72. Etsy took $3.28 — and on orders that came from an Etsy ad, another $4.35 on top.

This workbook shows you exactly where every cent went, on six different sales channels.

Seven sheets, 746 formulas, six channels in one file

Most fee calculators cover one channel. This one puts Etsy, eBay, Amazon Handmade, Gumroad, your own site via Stripe and your own site via PayPal next to each other, on the same product, so the comparison is real rather than remembered.

What it does

• Profit Calculator — enter one product, see net profit and margin on all six channels at once
• Pricing Lab — work backwards: name the profit you want, get the price to charge on each channel
• Break-Even — how many sales cover your fixed costs before you discount
• Sales Log and Dashboard — log real orders, watch revenue, fees, profit and margin by channel
• Fee Settings — every rate editable in one place, each carrying the page it came from and the date it was checked

Why the numbers are right

Etsy charges its two main fees on two different amounts. The 6.5% transaction fee is calculated on a base that excludes US sales tax. The 3% + $0.25 processing fee is calculated on a base that includes it. Most calculators apply one base to both, and are quietly wrong on every order.

This workbook models them separately. The Offsite Ads section accounts for the $100 per-order cap, and for the fact that the 12% rate becomes permanent — and can no longer be switched off — once a shop crosses $10,000 in any rolling 365 days.

Every rate was verified against the platform's own published fee page. When a platform changes something, you edit one cell and the whole workbook follows.

Who this is not for

If you sell on one channel and have no intention of adding another, a single-channel calculator is cheaper and will serve you fine. This is for the seller who suspects they are on the wrong channel and wants the arithmetic before they move.

What you get

One Excel workbook (.xlsx), seven sheets, plus a how-to guide and licence terms. Instant download after payment. Works in Excel, Numbers and Google Sheets.

If a file will not open, or is not what this page described, email support@mockwrenstudio.com and it gets fixed or refunded. No argument.