Inventory & Product Pricing Calculator | COGS Tracker for Google Sheets & Excel

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.

✦ 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 IT WORKS

1. Buy and download your files instantly after checkout.

2. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel.

3. Follow the Start Here tab. Everything else calculates.

✦ GOOD TO KNOW

• Instant download: nothing physical is shipped.

• Works in Google Sheets (free) and Microsoft Excel 2016+ / Microsoft 365 / Excel for the web. Not compatible with Apple Numbers.

• Works on desktop and in the Google Sheets and Excel phone apps (a computer is easiest for setup).

• No macros. Example and blank versions included. Licensed for one person or one business.

• Record-keeping and planning tool, not tax, legal or financial advice.

• Questions? Message me. I usually reply within a day.

© SageAndSheets. Please do not share or resell. Because this is a digital download, refunds aren't offered, but if anything isn't working, message me and I'll make it right.