SageAndSheets
This inventory and product pricing calculator tracks every material you buy, costs out every product you make, sets wholesale and retail prices, and gives you year-end inventory and COGS for taxes.
Who this inventory sheet is for
Made for Handmade sellers, crafters and small product businesses who want to know what each item really costs to make and price it for profit at both wholesale and retail.
What's included
- Inventory & pricing workbook (.xlsx), example jewelry shop fully filled in
- Blank version (.xlsx): 150 materials, 60 products, 600 bill-of-materials lines, 1,000 stock-log rows
- Step-by-step PDF guide for Google Sheets and Excel
Features
- Materials list with weighted average cost per unit that updates with every purchase
- Bill of materials: what goes into one unit, with material cost per product
- Suggested overhead rate from your real monthly costs
- Cost per unit: materials + labor + overhead + packaging
- Adjustable pricing formula (cost × 2 wholesale, × 2 retail, or your own), plus fees, profit and margin
- Stock log for made, sold, personal use, damaged and returned; finished stock on hand
- Material usage and on-hand stock calculate automatically, with reorder and low-stock alerts
- Year-end Tax Summary: beginning inventory, purchases, ending inventory, cost of goods sold and personal-use withdrawals
- Dashboard: inventory value, alerts, units made vs. sold by month, top sellers and margin chart
Why it's different
Live dashboard with charts and alerts Materials usage calculated from your bill of materials, no manual counting Year-end COGS numbers included at a fraction of premium prices Both Google Sheets and Excel
How to use it
- Buy once from Etsy, Gumroad or Payhip and download the files instantly.
- Open the example version first to see the template filled in, then use the blank version for your own details.
- Upload the .xlsx to Google Drive and open it with Google Sheets, or open it directly in Excel.
- Follow the PDF guide; formulas update totals, dashboards and alerts as you type.
Frequently asked questions
Does it handle wholesale pricing?
Yes. Enter your target margins and it suggests wholesale and retail prices from your true cost of goods.
Can I track materials stock?
Yes. Materials, product stock and low-stock levels are tracked alongside your costs.
Does it work in Google Sheets and Excel?
Yes. Every spreadsheet opens in Google Sheets (free) and Microsoft Excel. A step-by-step PDF guide is included.
Is anything shipped?
No. It's an instant digital download, available right after purchase.
