Inventory Tracker Starter Kit
A five-tab Excel inventory workbook for makers — raw materials, finished goods, packaging, and a purchase log, with reorder thresholds and conditional formatting that flash low-stock rows automatically. Designed to take you through the first 50–150 SKUs and the first year of selling.
A five-tab Excel workbook for makers, bakers, and small-batch sellers running their inventory out of a spreadsheet. Tab one is a Read Me with the workflow and the workbook's deliberate limits. Tabs two through four are Raw Materials, Finished Goods, and Packaging — each with on-hand quantity, reorder point, a status column that turns the row red / amber / green, and a per-row inventory value that calculates itself. Tab five is the Purchase Log: every supplier order, line-by-line, with month-to-date and year-to-date spend at the top. Built to take you through the first 50–150 SKUs and the first year of selling — and built to make the spreadsheet method's limits visible the day you outgrow it.
- A Raw Materials tab with on-hand qty, reorder point, last unit cost, supplier, and lead time — plus a status column that reads on-hand vs. reorder point and tells you what to do
- A Finished Goods tab tracking what is on the shelf ready to sell, with wholesale and retail price columns and stock value at retail
- A Packaging tab for the boxes, mailers, labels, and tape that ship — with the same reorder-point status logic
- Conditional formatting that flashes the row red when on-hand drops below half the reorder point, amber when it hits the reorder point, gray when it gets close, and green when stock is healthy
- A Purchase Log tab with month-to-date and year-to-date spend totals computed automatically — the running record of cost-of-goods that pays off every April 15
- Sample rows across candles, soap, baked goods, and jewelry you can replace with your own catalog in a few minutes
Educational tool only — not financial, tax, or accounting advice. Reorder-point math is an estimate based on average usage and lead time; tune the safety buffer to your supplier reliability and demand variance. Inventory valuation methods (FIFO, LIFO, weighted-average, specific identification) vary by accounting framework and jurisdiction — the workbook uses last unit cost as a simple stand-in, which is not a substitute for a year-end COGS reconciliation with a CPA. Lot / batch traceability for cottage food, cosmetic, or other regulated products requires more than a single on-hand quantity column.
When a spreadsheet is enough
A spreadsheet is the right tool for inventory tracking when your business is single-location, your SKU count is below ~150, you produce in batches you can hold in your head, and tax-time COGS reconciliation runs once a year. Below those thresholds, a well-built workbook is faster to update than any software, free, and runs offline.
The tipping points are usually multi-location stock (booth + studio + retail partner), recipes that consume materials when you produce (so finished goods need to decrement raw materials automatically), and lot/batch traceability for cottage food labeling — three things spreadsheets cannot reliably do without breaking formulas.
How the reorder-point status logic works
Each materials row has an on-hand quantity and a reorder point. The status column reads them and outputs one of four states: green (on-hand > reorder point), gray (on-hand within 25% of reorder point), amber (on-hand at or below reorder point), and red (on-hand below half the reorder point). Conditional formatting highlights the row in the matching color, so a glance at the sheet tells you what to order today.
The Purchase Log tab cross-totals month-to-date and year-to-date spend automatically, so the running record of cost-of-goods is always current — the line your CPA will ask for first on April 15.
Or skip the spreadsheet entirely
A spreadsheet runs your inventory until it can't. Ardent Seller picks up where it leaves off — multi-location balances, recipes that decrement materials when you produce, automatic cost roll-ups when a vendor price changes, photos and barcodes per item, lot/batch traceability, and an audit trail of every change. Same data model you already think in (materials → recipes → batches → sales), without the formulas you have to maintain by hand.
Multi-location inventory
Track raw materials, finished goods, and packaging separately by location — booth, studio, retail partner — with a single running balance per item.
Recipe costing & production runs
Producing a batch decrements materials and packaging automatically — the spreadsheet's biggest blind spot, solved at the data layer.
Reorder thresholds & alerts
Set a reorder point per item and get a ready-to-order list any time you sit down to do supplier orders — no walking the shelves to figure out what is low.
Frequently asked questions
How should a maker organize inventory in Excel?
Split inventory into three categories on separate tabs: raw materials (ingredients, components used to make products), finished goods (completed products ready to sell), and packaging (mailers, labels, tape, tissue). Add a fourth tab for the purchase log so the running cost-of-goods record is in the same workbook. Each item gets one row with on-hand qty, reorder point, last unit cost, supplier, and lead time.
What is a reorder point and how do I set one?
A reorder point is the on-hand quantity that triggers reordering — calculated as (average daily usage × supplier lead time) + a safety buffer for variance. For a maker buying soy wax with a 7-day lead time and 2 lbs/week average usage, the math is (2/7 × 7) + 1 lb buffer = 3 lbs. When on-hand drops to 3 lbs, reorder.
How do I track raw materials separately from finished goods?
Use separate tabs (or sheets) so the data model stays clean: raw materials are valued at purchase cost; finished goods are valued at retail or wholesale. They follow different reorder logic and different counting cadences. Mixing them in one tab is the most common cause of unreliable inventory totals in a spreadsheet.
When should I switch from a spreadsheet to inventory software?
The clearest signals are: (1) you sell from more than one location, (2) you produce in batches that decrement raw materials and need recipe costing, (3) cottage food rules require lot/batch traceability on labels, (4) reconciling sales channels takes more than 30 minutes a month, or (5) you have caught more than two inventory math errors in formulas this year. Any one of these is usually the moment to graduate.
Related resources
Monthly Inventory Count Sheet
Three sections, one page. Print, count, and reconcile raw materials, finished goods, and packaging — with expected, actual, and variance columns.
End-of-Month Closeout Checklist
Seven steps to a clean monthly close — sales reconciliation, inventory counts, expense review, P&L, planning, reordering, and backup. Print one each month.
Year-End Inventory Reset Checklist
A two-page printable for the December/January annual ritual — full stocktake, write-off identification, dead-stock liquidation plan, and the Schedule C Part III math that turns this year’s ending inventory into next year’s opening balance.
Small-Batch Production Planning Playbook
A printable six-page playbook for handmade-goods producers — five planning principles, the demand-driven batch-sizing formula, and four worksheets for sizing, run logging, weekly WIP, and post-run audit.
Vendor & Supplier Contact Organizer
A four-page fillable PDF for tracking suppliers — vendor records, an alternate-supplier scoring sheet, and a one-row-per-vendor master index. Type into it in your PDF reader, or print blank copies for the clipboard.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
From the blog
Articles that dig deeper into the topics this tool covers.
Inventory Management for Craft Sellers: Stop Guessing, Start Growing
Most craft sellers lose money through poor inventory habits without realizing it. Learn how to build a simple inventory system that eliminates guesswork, prevents stockouts, and scales with your business.
SKU Design for Small Sellers: How to Name, Number, and Track Every Product Without Losing Your Mind
Most small sellers build their first SKU system on a Tuesday afternoon in a hurry and regret it for the next three years. Here is how to name, number, and organize your products so you can find anything in seconds — and how to fix the mess if you already built one.
Spreadsheet Breakup: How to Know When Your Maker Business Has Outgrown Excel (And What Actually Replaces It)
Your spreadsheet got you this far. It is also the thing that is quietly breaking every time you open it. Here is how to tell when a maker business has outgrown Excel, what you actually lose by staying too long, and a plain decision framework for choosing what replaces it.
Stocktake Guide: A Step-by-Step Walkthrough for Counting What You Actually Have
Most small sellers "know" their inventory — until they count it and discover they are off by 15-30%. A practical, no-excuses guide to running your first real physical inventory count, fixing what you find, and building a cycle counting habit that keeps your numbers honest year-round.