Free handmade cost-to-make + markup sheet
You know the mug sells at $28. You are less sure what it costs once materials, your minutes and packaging are in. This spreadsheet adds those up, then suggests a list price from a markup multiplier or a desired margin after fees. Google Sheets or Excel, and the file is yours.
One sample row (from the download)
| Product | Cost before fees | Markup × | Suggested list |
|---|---|---|---|
| Speckled mug | materials + labour + pack | 2.5 | formula |
Cream cells are inputs. Suggested prices calculate. Fees % is editable.
Free. One email with the download, then occasional updates. Unsubscribe any time.
- Free, unsubscribe any time
What's in the file
Three tabs · markup or margin
-
Tab 1
Start here How the labour minutes, markup multiplier and desired margin columns work. Read it once.Guide · no formulas to touch
-
Tab 2
Products Materials, minutes, hourly rate, packaging, fees %, markup or margin → two suggested list prices.You type · cream cells
-
Tab 3
Summary Product count and average suggested prices from the rows you filled.Calculates · shop average
Set it up
- Open the file. In Google Sheets: File, Import, Upload, Replace spreadsheet.
- Replace sample product rows with yours. Leave formula columns alone.
- Set fees % to what your platform actually takes. Adjust markup or margin until the suggested list price is one you would pay yourself.
Questions
Does it work in Excel?
Yes. Only formulas Google Sheets and Excel share (IF, IFERROR, basic arithmetic). File, Import, Upload, Replace spreadsheet in Google Sheets.
Markup multiplier or desired margin — which do I use?
Use the markup column when you think in “2.5× cost.” Use desired margin when you want a percentage left after fees. Both suggested prices are on the same row; pick the one that matches how you price.
What is fees %?
Your estimate of platform plus payment cut as a share of list price (0.10 = 10%). Fees change, so check your own platform rather than trusting a number in a template.
Is this the Seller Back-Office Kit?
No. This free sheet is costing and suggested list price only. The Back-Office Kit (planned at $29) puts costing, stock, ledger and invoices on one product list. Checkout isn't open yet; its page has a list for one email when it is.
Does it track inventory?
No. Pair it with the free inventory spreadsheet for stock and reorder flags.
Also useful
- Etsy fees vs take-homeCheck deposit after fees on one order.
- Inventory spreadsheetStock on hand and reorder flags.
- Offsite Ads scenarioOrganic vs Offsite take-home side by side.
- Craft fair break-evenDoes the booth fee clear on your unit margin?
Updated