How to Track Etsy Shop Profit Per Listing

Shopfolio

Etsy's seller dashboard shows revenue. It does not show profit. The difference is every fee Etsy charges between the customer's payment and the money that lands in your bank account. On a $25 sale, those fees consume $4-$9 depending on whether Offsite Ads triggered. Most Etsy sellers don't know their true per-listing profit within 20%.

That gap matters. A shop with 200 listings and a 15% margin error is making business decisions on fictional numbers. You think your best-seller earns $12 profit. It actually earns $8. You think your slowest category breaks even. It's losing money after fees and materials.

Every Etsy Fee on a Single Sale

Etsy charges four separate fees on every transaction, and a fifth conditional one. Here's what they each are and how they stack.

FeeAmountCharged On
Listing fee$0.20Per listing, every 4 months or at sale (auto-renew)
Transaction fee6.5%Sale price + shipping price
Payment processing3% + $0.25Total order amount (items + shipping + tax)
Regulatory operating fee0.30%Sale price (some jurisdictions)
Offsite Ads fee15% (or 12% if >$10K/yr)Sale price, only on orders from Etsy's ads

Worked Example: A $25 Digital Download

Digital products are the clearest case because there's no shipping or COGS. Your only costs are Etsy fees.

Sale price: $25. No shipping (digital delivery).

Total fees (no Offsite Ads): $2.91. You keep $22.09. That's an 88.4% margin.

If Offsite Ads triggered: Add 15% of $25 = $3.75. Total fees: $6.66. You keep $18.34. Margin drops to 73.4%.

Offsite Ads are mandatory for shops earning $10,000+/year. You can't opt out. That 15% fee applies to roughly 10-15% of orders for most shops, depending on your category and how much traffic Etsy drives via Google and social ads. Factor it into your average cost per sale, not just the transactions where it hits.

Worked Example: A $45 Physical Product

A handmade item priced at $45 with $7.50 shipping. Materials cost $11. Packaging $2.50. Labor: 45 minutes at $25/hour = $18.75.

Total Etsy fees: $5.58. Shipping out-of-pocket: $5.25. COGS: $13.50. Labor: $18.75.

True profit: $45 + $7.50 - $5.58 - $5.25 - $13.50 - $18.75 = $9.42.

That's a 17.9% margin on the total transaction. And that's without Offsite Ads. With the 15% fee ($6.75), profit drops to $2.67, or 5.1%.

If you were looking at the Etsy dashboard, it would show $45 in revenue. The gap between $45 and $2.67 is the reason you need per-listing tracking.

How to Set Up Per-Listing Tracking

Your tracking spreadsheet needs one row per listing (not per sale). Each row calculates the profit for one unit sold at the current price.

Columns you need:

  1. Listing title and SKU
  2. Sale price
  3. Shipping charged to buyer
  4. COGS (materials + packaging)
  5. Labor cost (time x your hourly rate)
  6. Actual shipping cost (postage + packaging materials)
  7. Etsy fees (calculated: listing + transaction + processing + regulatory)
  8. Offsite Ads probability (use your historical rate, typically 10-15%)
  9. Blended profit per sale (weighted average with and without Offsite Ads)
  10. Units sold (trailing 30/90 days)
  11. Total profit contribution

The blended profit formula

Blended Profit Per Sale

Blended = (Profit_no_ads x 0.88) + (Profit_with_ads x 0.12)

Adjust the 88/12 split based on your actual Offsite Ads hit rate. Check your Etsy shop stats under Marketing > Offsite Ads for the real percentage.

What This Reveals

Once you have per-listing profit, sort by profit contribution (profit per sale x units sold). Three patterns will emerge:

The $0.20 listing fee trap: If you have 200 active listings and 150 of them sell fewer than once per quarter, you're spending $30/quarter ($120/year) on listing fees for products that aren't contributing profit. Deactivate the bottom 50 and your shop is instantly more profitable.

Track true profit per listing with every fee included.

Shopfolio's Etsy Seller Bookkeeping Template calculates per-listing profit after all Etsy fees, COGS, labor, and shipping. Identifies stars, traps, and dead weight across your catalog. $29, works in Google Sheets and Excel.

See the Etsy Seller Template

Frequently Asked Questions

What percentage does Etsy take from each sale?

Etsy takes approximately 12-15% of each sale in combined fees: $0.20 listing fee, 6.5% transaction fee on the sale price plus shipping, 3% + $0.25 payment processing fee, and potentially 15% Offsite Ads fee on orders from Etsy's advertising (mandatory for shops earning over $10,000/year). On a $25 item with $5 shipping, total Etsy fees are approximately $4.38 without Offsite Ads, or $8.88 with the Offsite Ads commission.

How do I calculate my true profit margin on Etsy?

True Profit = Sale Price - COGS (materials, packaging, labor) - Etsy Fees (listing + transaction + payment processing + Offsite Ads if applicable) - Shipping Cost (if you offer free shipping or subsidize it). Divide by sale price for your margin percentage. For digital products with no COGS, your margin is the sale price minus Etsy fees. For physical products, most profitable Etsy shops operate at 30-50% true margins after all costs.

Should I include my time as a cost when calculating Etsy profit?

Yes, if you want honest numbers. Assign yourself an hourly rate (at minimum, your state's minimum wage; ideally, $25-$50/hour for skilled craft work) and track time per listing: product creation, photography, listing optimization, packaging, and shipping. Digital products avoid this trap because creation time is amortized across unlimited sales.

Related Reading