Built around the jobs handmade sellers actually do
Track what your materials really cost
Log each purchase. The sheet works out cost per unit, keeps a rolling average across purchases and flags any material whose cost jumps more than 15%.
Material purchasesAverage cost per unitCost each product from its recipe
List the materials in each product and the batch yield. Costs split across every item, whether a batch makes 20 bars of soap or one ring.
Ingredients, batch yieldMaterial cost per itemPay yourself for your time
Log production time per product, and your hourly rate turns it into a labor cost per item.
Minutes per itemLabor cost per itemSpread fixed costs across what you make
Enter monthly rent, utilities, insurance and software plus your production volume to get overhead per item.
Monthly fixed costsOverhead per itemPrice for profit after fees
Wholesale and retail prices come from your costs and target margin, with a breakdown of marketplace fees and your take-home per sale.
Target marginWholesale and retailHave your COGS ready for Schedule C
A year-end worksheet laid out like Schedule C Part III, lines 33 to 42. Enter beginning and ending inventory to get your cost of goods sold.
Year-end inventoryCOGS for Schedule C11 tabs in one file
- Start Here
- Dashboard
- Product Summary
- Materials
- Recipes BOM
- Labor
- Overhead
- Pricing
- Schedule C COGS
- Settings
- Conversions
- Start Here
- Setup steps and a guide to every tab.
- Dashboard
- Key numbers, product margins and margin alerts.
- Product Summary
- Pick a product to see its full cost breakdown.
- Materials
- Material purchases with cost per unit and rolling averages.
- Recipes BOM
- Product recipes with batch yields and material cost per item.
- Labor
- Production time and labor cost per item.
- Overhead
- Monthly fixed costs split across each item.
- Pricing
- Wholesale and retail prices with fees and take-home.
- Schedule C COGS
- Year-end COGS worksheet for Schedule C lines 33 to 42.
- Settings
- Hourly rate, profit margin, markup, fee rates and lists.
- Conversions
- Weight, volume, length and craft unit conversions.
Pair it with
“Excellent! Very easy to use.”
“Well thought out worksheets nicely presented”
Before you buy
Will it work for my craft?
Yes. It works for soap, candles, jewelry, pottery, woodworking, textiles, baked goods and other handmade products. Material categories and units are editable.
Does it handle batches?
Yes. Set the batch yield and every cost is divided per item. For one-off pieces, set the yield to 1.
Does it include selling fees?
Yes. The Pricing tab breaks out listing, transaction, payment processing and offsite ad fees, so you can see what you keep from each sale.
What do I get?
An Excel file (.xlsx), a filled-in sample to look at, and a quick-start PDF guide with a link that makes your own copy in Google Sheets.
How does delivery work?
You get your download links right after checkout, and Stripe emails your receipt. There is nothing to ship and nothing to wait for.
How do I set it up in Google Sheets?
Open the quick-start PDF and click the Google Sheets link. Google makes a copy in your own Drive that only you can edit. You need a free Google account.
Will it work on a Mac?
Yes. It works in Excel on Mac and Windows, and in Google Sheets in any browser.
I'm not a spreadsheet person. Is that a problem?
No. You only type in the yellow cells. Everything in gray works itself out, and the Start Here tab shows you where to begin.
Can I get a refund?
Templates are digital downloads, so sales are final. If a file won't open, is broken or doesn't match its description, email hello@cleanpixelstudios.com within 30 days and we'll fix it, or refund you if we can't.
What if I get stuck?
Email hello@cleanpixelstudios.com and we'll help you get it working.
More in Makers & creatives
See all Makers & creatives templates
Made by Clean Pixel StudiosWe start every template by reading what people in that line of work say they struggle with, then build the spreadsheet around those problems. This one was made for handmade sellers and nobody else.
How we build templatesHandmade Business COGS Pricing Calculator$9.99 · Excel + Google Sheets