Inventory Tracker Spreadsheet for Small Business, COGS Calculator and Stock Count, Product Profit Tracker for Makers, Google Sheets & Excel

Inventory tracker spreadsheet and cost of goods sold (COGS) calculator for small shops and makers: list your products, log what you buy or make and what you sell, and the sheet keeps stock, average cost, profit per product and reorder flags up to date. At year end, type your stock count and get cost of goods sold and closing stock value.

WHAT'S INSIDE
- Start Here: three steps, one color rule (yellow cells are where you type) and quick answers
- Setup: business name, currency, year, product categories and sales channels
- Products (up to 200): SKU, category, sale price, reorder level and opening stock; bought, sold, in stock, average unit cost, stock value, revenue, cost of goods sold, gross profit, margin and a status (OK, Reorder, Out of stock)
- Purchases (1,000 rows): quantity, unit cost and extra costs such as shipping, spread over the units
- Sales (2,000 rows): channel, quantity, list price or your own price, discount; revenue and cost of each line
- Stock Count: book quantity vs counted quantity, the difference and the closing value
- COGS Summary: opening stock + purchases - closing stock = cost of goods sold, gross profit, the count adjustment, and a month-by-month table
- Dashboard: revenue, cost of goods sold, gross profit, margin, stock value, items to reorder, top 5 products, reorder list and a chart

HOW IT WORKS
1. List your products: SKU, price and the stock you had on 1 January.
2. Log buys and sales: stock, cost and profit update themselves.
3. Count at year end: get cost of goods sold and closing stock.

GOOD TO KNOW
- Costing method: one average unit cost per product for the year, explained with a worked example in the guide.
- Makers: log each finished batch as a purchase at the materials cost per unit.
- Every formula was tested in LibreOffice with a filled example year and uses only functions Excel and Google Sheets share. No macros.

FILE FORMAT
You receive one ZIP file containing:
- Inventory_COGS_Tracker.xlsx (blank, ready to use)
- Inventory_COGS_Tracker_Example.xlsx (an invented soap and candle maker's year)
- Quick_Start_Guide.pdf (4 pages)
- Google_Sheets_Links.pdf (click to make your own copy in Google Sheets)
Works in Excel 2010 or later, Excel for Mac, Google Sheets and LibreOffice. Any currency. Apple Numbers can open the file but is not supported.

Digital download, nothing is shipped.

Because this is a digital file, returns and exchanges aren't accepted. If something isn't working, message me and I'll help put it right.

Not tax or accounting advice. Check how your tax office wants stock valued.

Designed by WrenWorks with AI assistance.