Free Etsy profit calculator — the batch kind

How to calculate your Etsy profit — from your whole order file, product by product

This one reads your whole order file at once — not one item at a time.

  1. 1Drop your file
  2. 2See your numbers
  3. Unlock the full report

Drag your Etsy orders file here

🔒 It never leaves your computer.

Find it in Etsy Shop Manager: Settings → Options → Download Data, choose Order Items (CSV or Excel both work).

How to calculate Etsy profit from an order file

Your Etsy profit is what is left of each sale after Etsy's fees and your own costs — and the honest way to get it is from your whole Order Items file, not one listing at a time. This calculator does it in three steps:

Work out the fees on every order. The 6.5% transaction fee on the item price plus the shipping charged, payment processing of 3% + $0.25 per order, and the $0.20 listing fee per item — then each order's fees are assigned to the products in that order.

Subtract the fees from what each product sold for. That is what Etsy actually paid you for that product — the number your bank deposits are built from, product by product.

Rank your products by what is left. The ranking is your profit before materials and postage. Add your material costs — the way the full kit does — and it becomes your true profit per product.

Etsy profit questions, answered straight

There is no official Etsy benchmark, and any single "good" number is a rule of thumb, not a fact. What a margin has to do is cover your materials, packaging, postage and your time, and still leave a cushion for slow months and supplier price rises. As a rule of thumb, a handmade product whose price also has to pay its maker gets fragile below about a third of the selling price kept after fees and materials — at that level, one wax or fabric price rise can erase the profit on that product entirely. But the margin alone is not the whole story: a product at 40% that sells every week usually earns more than a product at 60% that sells twice a year. The number that matters is yours, product by product — the ranking this calculator builds is where it starts.
Add up everything one sale costs you: Etsy's fees (a 6.5% transaction fee on the price plus the shipping you charge, payment processing of 3% + $0.25 per order, and the $0.20 listing fee), your materials and packaging, and the postage you paid. Subtract that total from what the buyer paid, then divide what is left by what the buyer paid. Example: a $30 item with $5 shipping charged brings in $35; the fees come to about $3.78, so if materials, packaging and postage are $14, your profit is $17.22 and your margin is about 49%. Do it across your whole order file rather than one listing at a time — the flat $0.25 processing charge lands very differently on a one-item order than on a three-item order.