You do not need enterprise inventory software to know what is on your shelf, in your storeroom, or waiting to be posted. A straightforward spreadsheet inventory system works well when SKU counts are modest and stock moves at a pace you can record manually.
This guide explains the fields worth tracking, how to calculate current stock and reorder status, and when a spreadsheet stops being enough.
Core fields for a simple inventory sheet
| Field | Why it matters |
|---|---|
| SKU / product code | Unique identifier — avoids confusion when names are similar |
| Product name | Human-readable label for daily use |
| Category | Groups reporting (e.g. raw materials, finished goods) |
| Supplier | Who you reorder from and their lead time |
| Stock in | Units received from purchases or production |
| Stock out | Units sold, used or written off |
| Current stock | Opening + in − out (usually a formula) |
| Reorder level | Minimum quantity before you reorder |
| Reorder quantity | How much you typically order |
| Unit cost | Cost per unit for stock value estimates |
| Stock value | Current stock × unit cost |
| Reorder status | Flag when current stock ≤ reorder level |
Stock in and stock out
Treat every movement as a line or a running total — whichever you find easier to maintain. Purchases, returns from customers, production batches and adjustments increase stock in. Sales, samples, damage and shrinkage increase stock out.
Record dates on movements if lead times vary. That history helps you refine reorder quantities after a few cycles.
Reorder levels and regular stock checks
Set reorder level based on how long supplier delivery takes and how fast you sell. If a product takes two weeks to arrive and you sell roughly ten units per week, sitting at five units means you are already late.
Schedule a brief stock check weekly or monthly: count physical stock, compare to the sheet, and adjust for discrepancies. Small drifts are normal; large gaps usually mean untracked movements.
When a spreadsheet inventory system fits
- You hold stock in one primary location
- SKU count is manageable without barcode scanning
- Orders are fulfilled in batches you can log manually
- You need visibility more than real-time integration with a shop till
When dedicated inventory software may help
- Multiple warehouses or stock locations with frequent transfers
- High-volume picking and packing with strict accuracy requirements
- Deep integration with POS, marketplaces and couriers is essential
- You need lot tracking, expiry dates or serial numbers at scale
Linking inventory to sales and purchasing
Inventory becomes more useful when it connects to your sales tracker and supplier notes. If you know weekly sales velocity and supplier lead time, reorder decisions feel less guesswork-driven.
Stock value on the sheet is an estimate for planning — not a substitute for formal stock valuations or accounts prepared for tax purposes.
Example: a Cardiff gift shop with seasonal peaks
A high-street gift shop might carry two hundred lines across cards, homeware and local crafts. Enterprise inventory software would be overkill, but a notebook alone fails before Christmas when stock turns weekly. They maintain one row per SKU with current quantity, reorder level and supplier name.
Each Monday the owner filters the sheet for “Reorder status = Yes” and places orders before the Tuesday wholesale cut-off. After Christmas they run a slow-mover report — manually sorting by low stock-out rates — and markdown slow lines in January rather than reordering them for Easter.
When a local maker delivers a new pottery line, they add SKUs before stock hits the shelf. Untracked “just a few on the windowsill” items are how shrinkage hides. Even low-value lines get a code if they are saleable.
Seasonal reorder planning for UK retail
| Period | Typical demand shift | Spreadsheet action |
|---|---|---|
| January–February | Post-Christmas quiet; cash tight | Lower reorder levels; flag dead stock to clear |
| March–April | Mother’s Day, Easter gifting | Raise levels on cards, food gifts, spring lines |
| May–June | Wedding season, outdoor living | Review gift wrap and seasonal SKU velocity |
| July–August | School holidays; mixed footfall | Track market-day pop-ups separately if applicable |
| September | Back to school, early Christmas ordering | Increase reorder quantities for Nov delivery |
| October–December | Peak trading; stock-out risk highest | Weekly counts; shorten review cycle to twice weekly |
Handling bundles, kits and raw materials
If you assemble gift boxes from component SKUs, decide whether the sheet tracks finished bundles only or components as well. Many makers track raw materials and deduct a bill of materials mentally — workable at small scale, brittle when you hire help. A simple “Units per bundle” column on the component row lets you estimate how many finished items you can build without a separate manufacturing system.
Consignment stock — goods from local makers you pay for only when sold — deserves its own supplier tag. Physically it sits on your shelf, but legally it is not your purchase until the sale. A column for “Ownership = shop / consignment” prevents overstated stock value when you review monthly.
Write-offs need a visible home. When jars break in transit or samples leave the shop, log a stock-out row with reason “damaged” or “sample” rather than editing last month’s opening balance. Patterns in write-offs inform packaging decisions and insurance conversations.
Weekly inventory habits that prevent stock-outs
- Log all deliveries the day they arrive, not when the invoice is filed
- Deduct stock when orders ship, not when the customer pays
- Filter reorder flags before placing supplier orders
- Spot-check five high-value SKUs against physical count
- Note any product returning frequently — quality or listing issue may follow
- Archive discontinued SKUs to a “Retired” tab instead of deleting history