Does this work in Excel and Google Sheets?

Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.

Are Etsy's fees up to date?

The defaults are 6.5% transaction, 3% plus $0.25 payment processing, and $0.20 listing, entered as 9.5% and $0.45. Etsy changes these occasionally; both live on the Settings sheet.

Does it handle Offsite Ads?

Not as a separate field, because it only applies to some orders. To model the worst case, raise the platform fee by 15%.

What is yield % and do I have to use it?

It is how much of what you buy you can actually use. Ribbon has scraps; fragrance oil spills. Leave it at 100 where nothing is wasted.

I'm not confident with spreadsheets. Will I manage?

Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

Home → Tools → Etsy Fee and Profit Calculator

Fee & Profit Calculator for Etsy Sellers

The sale notification feels great until the deposit doesn't match it.

True cost per handmade product with Etsy's full fee structure, and the minimum price that survives it.

$19 USD · one-time

Buy on Etsy · $19Gumroad coming soon

Instant download · Excel & Google Sheets · works on Mac and Windows · on Etsy today, Gumroad soon

Etsy Fee and Profit Calculator dashboard

Who it's for

Made for the way you actually work.

Etsy sellers pricing with every fee counted before they list
Shops running sales without quietly selling at a loss
Sellers doing the free-shipping math instead of hoping
Anyone whose deposits keep coming in smaller than expected

What's included

Everything in one file.

Dashboard: Three headline numbers and two charts. Read-only.
Start Here: Five steps from opening the file to a real number on screen.
Product Pricing: Where you cost one recipe. The main working sheet.
Materials: Your shelf. Enter each purchase once; used everywhere.
Settings: Labor rate, overhead, target margin and fees.
Instructions: What each sheet does, and what to do if a number looks off.
About: Version, license and support.
PDF Quick-Start Guide: two pages, first result in five minutes

How it works

Three steps to a number you trust.

Open Settings. Etsy's current fees are pre-filled: 9.5% plus $0.45 per order. Set your labor rate and the margin you want to keep.
Open Materials. Replace the sample shelf with what you actually buy: price, pack size, unit, and yield % for anything you waste.
Open Product Pricing. Name the product and say how many the batch makes.

A look inside

The screens you'll be working in.

List of the eight sheets in the Etsy fee and profit calculator

Product Pricing sheet with fees, shipping and profit per sale

Materials sheet with pack prices, units and yield

Settings sheet with fee rates, target margin and shipping

Three steps to a price: load materials, apply the fees, read the minimum

Compatibility list showing Excel, Google Sheets, Mac and Windows support

Questions

Good to know.

Does this work in Excel and Google Sheets?: Both. Google Sheets: File > Import, or open and make a copy. Excel 365: open it directly. No macros, no add-ons, nothing to install.
Are Etsy's fees up to date?: The defaults are 6.5% transaction, 3% plus $0.25 payment processing, and $0.20 listing, entered as 9.5% and $0.45. Etsy changes these occasionally; both live on the Settings sheet.
Does it handle Offsite Ads?: Not as a separate field, because it only applies to some orders. To model the worst case, raise the platform fee by 15%.
What is yield % and do I have to use it?: It is how much of what you buy you can actually use. Ribbon has scraps; fragrance oil spills. Leave it at 100 where nothing is wasted.
I'm not confident with spreadsheets. Will I manage?: Yes. The white cells are the only ones you touch. The Quick-Start Guide has your first real number on screen in about five minutes, and if you get stuck, message me.

One mispriced job costs more than this.

$19 once, and it's yours to keep. It pays for itself the first time it stops you underpricing a job or leaving margin on the table. No subscription, no login, just a file that does the maths.

Buy on Etsy · $19Gumroad coming soon

Related tools