How Etsy Fee Worksheets Work
Stack platform transaction and payment processing on the same sale base—then price with eyes open.
How Etsy Fee Worksheets Work
Marketplace fee math feels messy because several line items hit the same order. An educational Etsy-style worksheet keeps the structure visible: platform percent + listing fixed fee, plus payment percent + payment fixed fee, both applied to the sale amount you enter.
The Question a Worksheet Can Answer
Platform fee = sale × transaction%/100 + listing fee. Payment fee = sale × payment%/100 + payment fixed. Total fees = platform + payment. Net proceeds = sale − total fees when fees do not exceed the sale. Effective fee percent = total fees ÷ sale × 100.
Inputs Worth Labeling
Practical sourcing habits
- Decide whether sale amount includes shipping when fees apply that way.
- Attribute listing fee to this sale—or set it to zero if amortized elsewhere.
- Copy payment processing terms from Etsy Payments for your location.
- Park ads and refunds in a separate profit worksheet.
A Transparent Worked Example
$40 sale with 6.5% + $0.20 platform and 3% + $0.25 payment → platform $2.80, payment $1.45, total $4.25, net $35.75. Raise the sale to $40 + $8 shipping if your schedule applies fees to item plus shipping, and watch both percent layers scale.
Formula map
| Name | Equation |
|---|---|
| Platform fee | saleAmount × platformPercent/100 + platformFixed |
| Payment fee | saleAmount × paymentPercent/100 + paymentFixed |
| Total fees | platformFee + paymentFee |
| Net proceeds | saleAmount − totalFees |
| Effective fee percent | totalFees ÷ saleAmount × 100 |
What the Model Leaves Out
Outside the educational scope
- Etsy Ads and offsite advertising
- Refunds, chargebacks, and conversion fees
- Live fee APIs and personalized seller advice
A Cautious Ritual
Before you trust a number
Match the fee base
Include shipping only when your schedule does.
Source every rate
Prefer Etsy’s fee docs over another seller’s screenshot.
Separate ads from fees
Model advertising in profit margin or dropshipping tools.
Reconcile one order
Compare worksheet outputs to a real order invoice.
Stacked marketplace fees are manageable when each layer stays labeled.— Free Calculator Hub Editorial Team
Price the listing after you see the stack—not before. Then move to shipping cost and profit margin worksheets when you need the full unit-economics picture.