10 tabsGoogle Sheets + Excel
Project Management Spreadsheet
Tasks, Kanban board, Gantt chart and dashboard in one sheet that keeps itself up to date.
$7.00$14.0050% off
Overview
Many makers set prices by looking at what others charge. This spreadsheet starts from your own numbers instead: materials, packaging, your time and overhead. From those it works out the cost per unit, a wholesale price, a suggested retail price, the selling fees, your profit per sale, your margin and the break-even price.
Enter what you buy and what goes into one batch, and the dashboard shows which products are priced well, which are below a fair retail price and which are losing money. A filled-in candle studio example shows how it works. Etsy's US fees are already entered in Settings, and you can change them.
Your true cost
Materials, packaging, your time and overhead added up for each unit.
Profit after fees
See what's left from each sale once selling fees are taken out.
Spot money-losers
The dashboard flags products priced too low or losing money.
Quote in 30 seconds
Price a custom order quickly with the Quick Quote tab.
What's inside
Dashboard
Which products are priced well, below a fair retail price or losing money, plus your average margin
Products
Cost per unit, wholesale price, suggested retail, selling fees, profit per sale, margin and break-even price
Recipes
What one batch of each product uses
Materials
Everything you buy, with cost per ounce, gram or piece worked out from the pack price
Quick Quote
Price a custom order in about 30 seconds
Settings
Your hourly wage, overhead, markups and selling fees, with Etsy's US fees filled in and editable
Example & guide
A filled-in small candle studio (soy candles, travel tins, wax melts, reed diffusers, gift set) and a Start Here guide
How it works
- 1
Buy on Etsy, then download the START-HERE PDF and the Excel files from your Etsy Purchases page.
- 2
For Google Sheets, open the link in the PDF and choose Make a copy. For Excel, open the .xlsx file.
- 3
Add your materials and recipes, type your prices and see your real profit after fees.
Good to know
- Digital download: nothing is shipped
- For use in your own business: please don't share or resell the template
- Fees are estimates: check the platform's current fees
- Not financial advice
Questions
How do I price handmade products?
Add up materials, packaging, your time and overhead to get a cost per unit, then apply a wholesale and retail markup. This spreadsheet does that math and shows the profit left after selling fees.
Does it include Etsy fees?
Yes. Etsy's US fees are filled in on the Settings tab, and you can edit them. Treat them as estimates and check Etsy's current fees.
Is it only for candle makers?
No. The example is a candle studio, but it suits soap makers, bakers, jewelry makers, crocheters, sticker and print shops and any small-batch business.
Do I need Excel?
No. It works in Google Sheets with a free Google account, on a computer, tablet or phone. It also opens in Microsoft Excel, and Apple Numbers can open the Excel file.
How it's made: designed by Sorted Templates. We use AI tools to help draft text and lay out pages, and every page is reviewed and edited by us before it's listed. Lifestyle and mockup images may be AI-generated or AI-edited; the page previews show the actual files.
Helpful guides & free tools
You might also like
9 tabsGoogle Sheets + Excel
Book Tracker Spreadsheet
A cozy digital reading journal: every finished book becomes a colored spine on your shelf.
$6.00$12.0050% off
6 tabsGoogle Sheets + Excel
Assignment Tracker Spreadsheet
Enter your syllabus once and see every due date, exam countdown and class grade update.
$3.50$7.0050% off
7 tabsGoogle Sheets + Excel
Job Application Tracker Spreadsheet
Your whole job search in one sheet, with follow-up reminders so no lead goes quiet.
$4.00$8.0050% off