Know what it costs. Know what to charge.
Materials, recipes, stock and pricing in one spreadsheet. When wax, jars or beads go up, you'll see exactly how each product's cost moved.
$16
- Instant download
- Google Sheets + Excel 2016+
- No macros or subscription
- Filled demo file included
Secure checkout by Gumroad, our merchant of record. Sales tax or VAT is added at checkout where it applies.
Instant download: by completing your purchase you expressly agree that the download starts immediately, before the 14-day withdrawal period ends, and you acknowledge that you lose your EU/UK right of withdrawal once the download is made available. See our terms.
Guessing your prices is expensive.
When a supplier raises prices, most makers don't know how much each product's cost moved, or that they're about to run out of a key material the week before a market.
After setup, you'll be able to:
- Know the true cost per unit of every product, with your time included.
- Get suggested retail and wholesale prices for the margin you choose.
- See reorder and out-of-stock flags before you run out.
- Know how many of each product your materials still cover.
Maker Inventory & Pricing Calculator
Cost per unit from pack prices
Enter the pack size and price you paid. The sheet works out cost per gram, ounce or piece, averaged across restocks.
Recipes (bill of materials)
List what goes into each product once. Material cost per product adds itself up.
Pricing calculator
Fees, profit and margin, plus a 1.5x to 4x price ladder and suggested prices for your target margin.
Stock and reorders
Restocks in, production out, reorder alerts and a 'can make from stock' count. Dashboard with 8 key numbers, a reorder list and 3 charts.
See it working
Screenshots from the DEMO file, which uses a fictional shop.
Connected tabs
Start Here · Settings · Materials · Purchases · Recipes · Products · Production Log · Pricing Calculator · Dashboard
Files in your download
- Maker-Inventory-Pricing-Calculator_BLANK.xlsx: your calculator
- Maker-Inventory-Pricing-Calculator_DEMO.xlsx: a fictional candle and soap shop
- Maker-Inventory-Pricing-Calculator_Start-Here.pdf: setup steps and your Google Sheets "Make a copy" link
Type in the yellow cells. We do the math.
Add materials
Pack size and price for each supply.
Build recipes
What goes into each product, in the unit you prefer.
Price and track
Read cost, suggested price and stock. Log restocks and batches as you go.
A good fit if…
- You make products from materials you buy in packs: candles, soap, jewelry, prints, ceramics.
- You want to price from real costs, not from what other shops charge.
- You'd like reorder reminders without inventory software.
Not the right tool if…
- You resell finished goods and don't make anything. A simpler stock list will do.
- You need barcode scanning or live sync with your shop. This is a manual, private spreadsheet.
- You have hundreds of materials and several staff. Dedicated inventory software will suit you better.
Before you buy
"I already price at what similar shops charge."
That's a fine reality check. This sheet adds the other half: whether that price actually covers your costs and your time.
"Setting up all my materials sounds slow."
Start with your three best sellers. The DEMO file shows a full shop, so you can copy the pattern.
"Do I need the Profit Tracker too?"
Not to start. This calculator handles costs and pricing. The tracker shows real profit from actual orders. The bundle has both, plus bookkeeping.
FAQ
Grams or ounces?
Either. Pick one unit per material and use it in both Materials and Recipes.
Does it sync with my shop?
No. Stock changes when you log restocks and production batches. Simple and private.
Does it include Etsy fees?
It estimates fees from the rates you enter in Settings, so you can see profit and margin at each price.
Do I need Excel?
No. Every template works in Google Sheets, which is free in any browser, and in Microsoft Excel 2016 or newer on Windows or Mac. Your download includes a Start Here PDF with a Google Sheets "Make a copy" link.
Are there macros, add-ons or a subscription?
No. These are plain spreadsheet formulas. You pay once, keep the file and can use it for as long as you like.
Is this tax or accounting advice?
No. The templates help you organize and estimate your numbers. Results depend on the data and rates you enter. For tax questions, talk to a qualified professional.
Can I use it in another currency?
Yes. The currency is a label, so type amounts in your own currency. Nothing is converted.
How do I get the files?
Checkout runs on Gumroad. Right after you pay, Gumroad shows a download page and emails you a receipt with the link. Your download holds the BLANK file, a DEMO file and the Start Here PDF.
What if something doesn't work for me?
Write to us through Gumroad or at [email protected] and the Oak & Tally team will help you get it working. Please read our terms for how refunds work for digital downloads.
Are you connected to Etsy?
No. Oak & Tally is independent. Etsy is a trademark of Etsy, Inc. Our templates are not affiliated with, sponsored or endorsed by Etsy, Inc.
Want all three templates?
The Maker Back-Office Bundle has this template plus the Handmade Seller Profit Tracker and the Maker Bookkeeping & Tax Set-Aside. $39 instead of $54 separately.
Maker Inventory & Pricing Calculator
$16
Not ready? Try the free Etsy Fee & Profit Calculator first.
Not tax, legal or accounting advice. Our templates are organizing and estimating tools; results depend on the data and rates you enter. Etsy is a trademark of Etsy, Inc. Oak & Tally is independent and not affiliated with, sponsored or endorsed by Etsy, Inc. Screenshots show a fictional demo shop.