DEV Community

Viral Videos
Viral Videos

Posted on

Etsy Fee Calculator — Free Google Sheets Template with Formulas

How to Calculate Your True Etsy Profit (Free Calculator)

If you sell on Etsy, you know the struggle: Etsy takes a cut from every sale — listing fees, transaction fees, payment processing, and maybe offsite ads too. Before you know it, your $25 item only nets you $15.

Here's the exact formula Etsy uses:

Etsy Fee Breakdown (2025 rates)

  • Listing fee: $0.20 per item (renews every 4 months)
  • Transaction fee: 6.5% of the total sale
  • Payment processing: 3% + $0.25 per transaction
  • Offsite ads: 12% or 15% depending on your plan

Example Calculation

For a $32 handmade tote bag with $8 in materials:

  • Listing: $0.20
  • Transaction fee: $32 × 6.5% = $2.08
  • Payment processing: $32 × 3% + $0.25 = $1.21
  • Offsite ads (if applicable): $32 × 12% = $3.84

Total fees: $7.33 (or $3.49 without offsite ads)
Net profit: $32 - $8 - $7.33 = $16.67 (52% margin)

The Solution

I created a free Google Sheets calculator that does all this automatically. Plug in your price and cost, and it shows you exact profit per item plus monthly projections.

Download it free: Etsy Fee & Profit Calculator

No signup required, just make a copy to your Google Drive. It includes 5 pre-filled examples so you can start using it immediately.

What's your current profit margin on Etsy? Drop a comment below.

Top comments (0)