Price, fees, materials, packaging, shipping and your own time — added up against each other so the profit on a single listing is visible before you publish it. This Etsy listing profit calculator applies Etsy's fees automatically, line by line, and shows you the net profit, the margin and the break-even price. It's a ready-made Excel workbook: you type the figures in, and the answers follow.
| Product | Cost | Margin | Price |
|---|---|---|---|
| Candle | $6.20 | 55% | $13.80 |
| Print A4 | $3.10 | 60% | $7.75 |
Illustrative example — the workbook itself is a clean spreadsheet.
This bench is a picture of the idea, not the product: type your own figures on the tag and the cost ticket, and watch the beam settle and the break-even slider move. In the workbook itself, the same weighing is done for real — one listing in depth on the Calculator sheet, and up to 600 side by side on Batch Compare.
You've just finished a new design. You know roughly what the materials cost, you've looked at similar listings to settle on a price, and it goes live. It sells. And somewhere in the back of your mind is a question you keep postponing: after Etsy takes its cut, after the packaging and the postage, after the hour and a half it took to make — did that sale actually leave you anything?
The answer isn't on the listing page, and it isn't on the payout either. Etsy's fees arrive as separate charges, the material cost lives in a receipt somewhere, and your own time is the number nobody counts at all. So the listing keeps selling, the question keeps waiting, and the discovery — if it comes — comes last.
This Etsy listing profit calculator is a ready-made Excel workbook built to answer that question for one listing at a time, properly. You enter the sale price, the quantity, the shipping you charge, what the materials and packaging cost you, and — if you want to count it — your labour minutes and an hourly rate. The workbook applies Etsy's fees from its own settings, adds up every cost, and shows you what's left: the net profit, the margin, and the break-even price.
What changes is the order of events. Instead of finding out last, you find out first. A price you were unsure about becomes a number you can defend or change. A listing that's been selling steadily turns out to run a thinner margin than you thought — or a healthier one — and either way you know, and you can act. And because the fee settings live in one place, if Etsy changes a rate you update it once and every calculation in the workbook follows.
A plain note before you read on: the visuals and interactive elements on this page are illustrations, made only to introduce the product and show what it does. The product itself is the Excel workbook described here — those illustrations are not part of the file you receive.
You don't type in fee amounts or look up percentages. The workbook carries Etsy's fee settings — a 6.5% transaction fee and a 3% + $0.25 payment-processing fee, both charged on the price plus shipping, and a $0.20 listing fee per item sold — and applies them automatically as you enter your figures. Each fee appears as its own line, so you can see exactly what's being taken and where. The settings are editable in one place: if Etsy changes a rate, you change it once and every result in the workbook follows.
Etsy changes its rates from time to time. In this workbook those fee settings are editable in one place. Update the setting, and every result in the file follows. You do not hunt through formulas to fix a number buried in a cell.
The Calculator sheet doesn't stop at a total. It shows the net profit on the listing, the margin as a share of what the buyer pays (price plus shipping), and the break-even price — the lowest price at which the listing doesn't lose money. That last number is the one most sellers have never worked out, and it changes how you think about offers, discounts and the floor beneath your pricing.
Most profit calculations quietly ignore the hours you spend making the thing. This one has optional fields for labour minutes and an hourly rate, so your time becomes part of the total cost rather than a hidden subsidy. If you'd rather see the profit before your time is counted, leave them empty — the workbook works either way.
You set a healthy margin floor — 20% as shipped is the starting point — and the workbook compares each listing's margin against it, saying plainly whether the listing looks healthy or sits under the floor. That isn't a judgment about your business; it's a line you've drawn, and seeing which listings cross it is the fastest way to find the ones that need attention. The Calculator also tracks progress toward a profit goal you set.
The second working sheet lines up to 600 listings side by side. For each one you enter its name, price, unit cost and shipping charged, and the sheet works out its Etsy fees, net profit and margin using the same fee settings as the Calculator. That's how you find the listing that sells every week and still loses money — the one that looks like a success on the sales count and turns out to be the most expensive thing in your shop.
The workbook has four sheets, in this order: START HERE, Calculator, Batch Compare and Thank You.
START HERE is the opening sheet, where you begin. The Calculator is where one listing gets worked through in depth. For each item you enter the sale price, the quantity, the shipping you charge the buyer, the material cost and the packaging cost, and, if you like, the labour minutes and an hourly rate. The sheet then lays out the revenue, the shipping collected, each Etsy fee as its own line and the total fees. Below those come the material, packaging and labour costs and the total costs. At the bottom sit the numbers you came for: the net profit, the margin as a share of price plus shipping collected, and the break-even price.
Batch Compare takes the same fee settings from the Calculator, so a rate you update there carries across to your whole list. You enter the listings, and each one gets its fees, net profit and margin. Thank You is a short closing note.
It is an ordinary Excel file. Nothing needs installing and no account is needed. You can click into a cell, see how a result is built and change it.
The first sheet you open — where the workbook begins.
One listing in depth: price and costs in; fee lines, net profit, margin, break-even and the margin verdict out.
Up to 600 listings side by side, each with its fees, net profit and margin.
A short closing note.
Short walkthroughs for this workbook. Nothing loads until you press play.
Short, focused walkthroughs of the Etsy Listing Profit Calculator are being recorded — getting started, working each sheet, and the month-end routine. When they are published, they will appear right here, filed under the categories above.
The Calculator, in miniature — the workbook's own fee settings and formulas, running live in your browser. Enter one listing's price, quantity, shipping and costs, set your margin floor and a profit goal, and read the net profit, the margin and the break-even price. It runs entirely here: nothing is stored, and no data leaves the page. The full workbook remains the complete version — with Batch Compare for up to 600 listings beside it.
The workbook’s Calculator sheet, reduced to one listing: it runs the workbook’s own fee settings and formulas — the same rates, applied the same way, each fee line rounded to the cent — live in your browser. Amounts are in dollars; a blank field counts as 0.
A negative or non-numeric entry is rejected — it counts as 0 until it is fixed.
This miniature works one listing in depth, as the Calculator sheet does. The full workbook also carries Batch Compare — up to 600 listings side by side — and remains the complete version.
This is for the Etsy seller who is pricing something new, or who has a listing already running and a nagging feeling about it. You sell physical products, you know roughly what your materials and packaging cost, and you've never sat down and put the fee, the material, the postage and your own time against the price in one place. You don't need accounting software for this. You need one honest sum, done properly, for the listing in front of you — and then, if you want it, the same sum run across every listing you have.
It's not for you if you're looking for something that connects to Etsy and pulls your sales data in automatically — this is a workbook you type figures into. Nor is it a bookkeeping system for the whole shop's sales and expenses over time; it answers the profit question for individual listings, which is the question pricing actually raises.
You pay once on Etsy, and the file is yours to keep and reuse.
It arrives as an instant download the moment you check out, with nothing shipped and nothing to wait for.
Open the workbook in Microsoft Excel, Google Sheets or LibreOffice Calc — the built-in formulas take over from there.
The workbook opens in Microsoft Excel, Google Sheets and LibreOffice Calc, so you can work in whichever you already have. It arrives as an instant download the moment you check out, with nothing shipped and nothing to wait for. You pay once on Etsy, and the file is yours to keep and reuse.
No. The workbook carries Etsy's fee settings — the 6.5% transaction fee, the 3% + $0.25 payment-processing fee and the $0.20 listing fee — and applies them automatically. If a rate changes, you update the setting in one place and every result in the workbook follows.
The Calculator sheet takes one listing in depth: every input, every fee line, the net profit, the margin and the break-even price. The Batch Compare sheet takes up to 600 listings side by side and gives each one's fees, net profit and margin, so you can compare them and spot the ones that are losing money. The Calculator is for understanding one listing; the Batch Compare is for surveying all of them.
If you want it to. The Calculator sheet has optional fields for labour minutes and an hourly rate, and when you fill them in your time becomes part of the total cost. If you'd rather see the profit before your time is counted, you can leave those fields blank — the choice is yours, and the workbook works either way.
You pay once on Etsy, and the file is yours to keep and reuse.
Instant download after checkout. One payment, and the workbook is yours to keep.