Inventory spreadsheet template (Excel stock control)

What is inside the inventory management Excel template

• Items tab: one row per SKU with name, a category dropdown, unit cost in pounds and the reorder point that drives the alerts.
• Movements tab: the heart of the workbook. Date, SKU, a type dropdown (In, Out, Adjustment), quantity and a reference such as the PO or job number. Every change to stock leaves a record.
• Stock on hand tab: a live balance per SKU built with SUMIFS: total in, minus total out, plus adjustments. Each row shows a red, amber or green status against its reorder point.
• Stocktake tab: enter what you actually counted and the sheet shows the variance against the system figure, values it at unit cost, and flags every mismatch in red so nothing gets quietly ignored.
• Example rows: three SKUs and seven movements are pre-filled so you can see the balances, the alerts and a worked variance. Replace them with your own.

How to use this stock control spreadsheet

• Set up your items first. The reorder point matters more than people think: set it at the quantity that covers your supplier lead time plus a margin.
• Log receipts as In and sales or usage as Out, both as positive quantities. Corrections go in as Adjustment, positive or negative.
• Never edit the Stock on hand tab. It is all formulas, and that is the point.
• Once a month, count the shelf and fill in the Stocktake tab. Investigate variances before you post them as adjustments; a repeating variance on the same SKU is telling you where your process leaks.
• Order when a row goes red, and treat amber as your early warning.

Formulas cover 200 items and 500 movements out of the box and extend easily. Values in GBP, example figures illustrative. Rates last checked: 15 July 2026.

Excel inventory works until stock stops matching reality

Small business forums are full of the same arc. The stock spreadsheet starts simple and works fine. Then the business gets busier, two people start updating it, a few movements get missed, and one day the sheet says 40 and the shelf says 12. From that point the owner is, in the words of one poster, fixing spreadsheet mistakes instead of running the business.

The template is built to delay that day as long as possible. A movements log means errors are correctable because there is a history. A monthly stocktake means drift gets caught at a small size. Those two habits are most of what inventory software does for you anyway.

But there is a genuine ceiling. When multiple people book stock in and out all day, when you sell across channels that each need live availability, or when the weekly reconciliation eats hours, the spreadsheet has become a job in itself. Moving to an inventory or ERP system at that point is mostly a data problem: cleaning SKUs, deciding what the real balances are, and mapping your columns to the new system's fields. That groundwork is what we do at Digital Adaption, and it is exactly what our data migration readiness review covers before you commit to any software.

How do I manage inventory in Excel?

Use three connected tabs, not one. List each item once with its reorder point, log every stock movement (in, out, adjustment) in a running log, and let formulas work out the live balance per SKU. The one rule that makes it work: never overtype a stock figure. If the shelf disagrees with the sheet, post an adjustment movement so there is a record of the correction.

What should a stock control spreadsheet include?

An items list with SKU, name, category, unit cost and reorder point. A movements log with date, SKU, type and quantity. A live stock on hand view calculated with SUMIFS. And a stocktake tab that compares counted quantities against the system figure and values the variance. This free template has all four.

How does the reorder alert work?

Every SKU on the Stock on hand tab gets a red, amber or green status. Red means the balance is at or below the reorder point you set on the Items tab, amber means it is within 25% above it, green means you are fine. The colours update automatically as movements are logged.

Why does my spreadsheet stock never match what is on the shelf?

Usually because balances are being edited directly, so corrections destroy the history and errors compound. Movements get missed, typed against the wrong SKU, or entered twice. The fix is a movements log plus a regular stocktake: count the shelf monthly, compare it with the system figure, investigate the variance and post it as an adjustment. That keeps errors small and visible instead of large and mysterious.

Does this inventory template work in Google Sheets?

Yes. Upload it to Google Drive and open it with Google Sheets. It only uses portable functions (SUMIFS, VLOOKUP and IF), so the live balances, the dropdowns and the red/amber/green formatting all carry over.

Related tools and downloads