Inventory Management in Excel: How to Build It, and When to Stop

You can absolutely run inventory in Excel, and for a single location with a modest catalog you probably should. A spreadsheet is free, instant, and bends to exactly how your business works. The problem is not that Excel is bad at inventory. The problem is that it stays quietly adequate for about a year after it stopped being adequate, and the cost of that gap shows up as stockouts and dead stock rather than as an error message.

This is a practical guide to building an inventory spreadsheet that actually earns its keep, and an honest account of the three points where it breaks.

What an inventory spreadsheet needs

Most inventory spreadsheets fail because they are a list of what you have. A useful one is a list of decisions. The difference is a handful of columns.

Column	Why it earns its place
SKU	The unique key. One SKU, one row, no exceptions
Description, category, supplier	Grouping and sorting, and the supplier drives lead time
Unit cost	Everything financial depends on it
Quantity on hand	What is physically there
Quantity on order	What is on the water, so you do not double-order
Quantity committed	Already promised to open orders
Available to sell	on hand + on order − committed
Average daily demand	Units sold in the period ÷ days in the period
Lead time (days)	The supplier's actual average, not the promised one
Safety stock	The buffer for weeks that are not average
Reorder point	(avg daily demand × lead time) + safety stock
Days of cover	on hand ÷ avg daily demand
Verdict	An IF formula that says: reorder, watch, or fine

The last four are the ones almost everybody omits, and they are the only ones that turn a record into a decision. A spreadsheet without a reorder point column is not managing inventory. It is describing it.

The formulas, in Excel terms

Assuming quantity on hand in D2, average daily demand in H2, lead time in I2 and safety stock in J2:

• Available to sell: =D2+E2-F2
• Reorder point: =(H2*I2)+J2
• Days of cover: =IFERROR(D2/H2,"")
• Verdict: =IF(G2<=K2,"REORDER",IF(G2<=K2*1.25,"WATCH","OK"))

A quick and defensible starting point for safety stock is half the demand during lead time, =(H2*I2)/2. It is crude but it is not stupid, and it beats zero. When you are ready for the real version, which sizes the buffer from measured demand variability and a chosen service level, the safety stock formula has the Z-score math.

Then add conditional formatting so REORDER rows turn red, sort by days of cover ascending, and you have something genuinely useful: a purchasing shortlist that reorders itself every time you refresh the sales numbers.

Three habits that keep a spreadsheet honest

Update demand weekly, not never. Every number downstream depends on average daily demand. If it reflects last spring, so does your entire reorder logic, and the spreadsheet will keep producing confident, precise, wrong answers.

Use the lead time you observed, not the one you were promised. Keep a column for the last few actual delivery times per supplier. If they quote 14 days and deliver in 19, use 19. This one change prevents more stockouts than any formula on the sheet.

One person owns the file. The moment two people keep local copies, you have two inventories and no way to know which is real. If that is already happening, it is the clearest signal you have outgrown the spreadsheet.

Where Excel actually breaks

Not at some SKU count. Excel will hold a hundred thousand rows without complaint. It breaks at three specific events, and they are worth naming because each one has a date attached.

1. The second sales channel

With one channel, on hand and available to sell are effectively the same number. Add a second, and they separate: something sold online at 9am is still sitting in the shop's count at noon. The spreadsheet has no way to know, so it confidently offers stock you no longer have. The first oversell is the tuition fee, and it is the core problem that ecommerce inventory management exists to solve.

2. Reorder points that go stale faster than you update them

A reorder point is only correct for the demand rate it was computed from. When a product's sales double, its reorder point should rise the same week. In a spreadsheet, that happens when a human remembers. With 50 SKUs, a human remembers. With 800, across four suppliers and two locations, nobody does, and the sheet keeps signing off on numbers that stopped being true in March. This is the quiet failure mode of static reorder points.

3. Nobody trusts the file any more

The tell is behavioral, not technical. Someone walks to the stockroom to check a number the spreadsheet already contains. Once physical verification becomes routine, the sheet has stopped being a system of record and has become a suggestion, and you are paying for it twice: once in the maintenance, once in the walking.

Excel versus inventory software, honestly

	Excel	Inventory software
Cost	Effectively free	$29 to $349/mo
Setup	An afternoon	Hours to weeks
Flexibility	Total	Bounded by the vendor
Multichannel stock sync	No	Yes
Reorder points that update themselves	No	Yes, if the tool forecasts
Audit trail	Weak	Yes
Breaks when	Two people, two channels	You outgrow the pricing tier

The fair summary: a spreadsheet is the right tool for a single-channel business whose owner can still hold the fast movers in their head. It is the wrong tool the moment the same SKU sells in two places, or the moment the catalog outgrows one person's memory. Most businesses cross that line months before they admit it, and the cost of the delay is invisible, because a stockout leaves no trace in the accounts. The sale that never happened does not generate a record.

If you want to see what the automated version of your spreadsheet's verdict column looks like, the stock scan on our homepage takes pasted rows, exactly the ones you already have, and computes cover, safety stock and a reorder verdict per SKU. No signup, and it runs on sample data if you would rather not paste your own. When you do decide to move, our comparison of the best inventory management software lays out what the real options cost, and the small business guide covers what a small team actually needs.