Craft pricing calculators
Handmade Product Pricing Calculator
Pricing calculator spreadsheet for handmade sellers: enter what your materials cost, how long each item takes and what your marketplace charges, and see the price that hits your target profit margin, a wholesale price and your real profit at the price you charge now. One Excel workbook for every product you make.
C$12CAD
Secure checkout. Sales tax, VAT or GST is added at card checkout where it applies.
- Instant download, nothing shipped
- Excel 2016+ and Google Sheets
- Filled-in sample file included
- Damaged or not as described? Fixed or refunded within 60 days
Prefer Etsy? Buy this template in our Etsy shop.
What it does
- Materials: enter each material once with what you pay for a pack and how many grams, ounces, yards or pieces are in it. The cost per unit calculates
- Recipes: one row per material in a product. Pick the product and the material from drop-downs, type how much one item uses, and the material cost adds up by itself
- Products: labour minutes at your hourly rate, overhead per item, packaging, shipping you pay and other costs give the total cost of one item
- Price for your target margin: the price that covers every cost and the marketplace fees and still leaves the margin you set
- Wholesale price: total cost times your wholesale markup
- Profit check at your current price: fees, profit per sale and margin. Products below your target turn amber, products losing money turn red
- Settings: hourly rate, overhead, transaction and payment fee percentages, fixed fees per order, target margin and wholesale markup. Change one and every price updates
- Room for 200 materials, 200 products and 1,000 recipe lines. Works for any craft and any currency
What you get
- XLSXHandmade-Product-Pricing-Calculator.xlsx (blank)
- XLSXHandmade-Product-Pricing-Calculator-with-Sample-Data.xlsx (a filled-in candle maker: 12 materials, 5 products)
- PDFQuick-start guide (PDF)
Good for
Candle and soap makers, crocheters and knitters, jewellery makers, bakers, sewists and any maker who sells online or at markets and wants prices based on real costs instead of guesses.
Please note
A pricing and planning tool, not accounting or tax software. Enter the current fees of the marketplace or checkout you use; they change. For use in your own business; please don't resell or share the files.
Disclaimer
This template is a planning tool and does not replace advice from a qualified or licensed professional (such as an accountant, financial advisor or lawyer). Check the results before you rely on them.
How it was made
Designed by VARS Digital with AI-assisted tools. Every formula is checked before release, and the sample file shows each tab working.
Questions
Email varsdigitals@gmail.com and we'll help you get set up.
