Free Inventory Tracking Spreadsheet with Count Sheet

Items with reorder points, receipts and issues with on-hand calculated, a stock card per item, and a printable count sheet with variance and value. An item reads REORDER at its reorder point and OUT OF STOCK at zero. Works in Microsoft Excel and Google Sheets.

Items sheet of the inventory tracking spreadsheet: item number, description, on hand, status (OK, reorder, out of stock) and reorder point

What the inventory tracking spreadsheet does

Inventory slips in two ways: an issue nobody wrote down, and a reorder point nobody looked at until the shelf was empty. This spreadsheet keeps what you type apart from what it works out, so the on-hand quantity never depends on someone remembering to change a number.

The file has four working sheets:

  • Items. One row per stock item, with item number, unit, reorder point, bin, supplier, unit cost and reorder quantity. The grey columns fill themselves: on hand, status, total in, total out, stock value and the date of the last movement. Status reads REORDER once on hand reaches the reorder point and OUT OF STOCK at zero.
  • Stock Movements. One row per receipt (purchase order, return), issue (requisition, work order) or adjustment, with the reference and who it went to. Balance After shows what is left of that item after every row.
  • Stock Card. Pick an item number and every movement of that item lines up in date order with in, out and balance, the bin card that used to hang on the shelf, without copying anything by hand.
  • Count Sheet. A printable inventory count sheet: book quantity, a column for the counted quantity, the variance, unit cost and counted value, with the total at the top. For a blind count, hide the book column before you print, so whoever counts writes down what is on the shelf rather than confirming the expected number.

The opening balance goes in as the first receipt of each item. To count a few items at a time instead of the whole stockroom once a year, see cycle counting. Tools that go out and come back belong in the tool inventory template, and machines and devices in the equipment inventory template.

Who uses this inventory tracking spreadsheet

Wherever stock is used every day and someone answers for the count.

Maintenance stockrooms

Filters, belts, lubricants and fasteners issued on work orders.

Contractors and job sites

Consumables for the crew: cut-off wheels, bits, PPE and fasteners.

Manufacturing

Production supplies and packaging, with a reorder point so the line never stops.

Facilities teams

Janitorial supplies, lamps and office stock across several buildings.

Restaurants and kitchens

Disposables and cleaning supplies reordered every week.

Small businesses

Quantities of products by item number, with a warning before they run out.

Before you fill it in

The sheet says 8 boxes. The shelf has two.

Try UNIO24 to automate inventory tracking.

Try UNIO24 Free

A spreadsheet goes out of date within days, and keeping it current takes someone's time every week. UNIO24 automates that work: every receipt, issue and adjustment updates the item's balance as it happens.

Your inventory tracker, three months in
The same item in UNIO24
Transaction history of nitrile gloves in UNIO24 with the Low stock badge: receipts from the opening balance and a purchase order, issues on requisitions to maintenance and production
UNIO24Mobile on the nitrile gloves item: stock below minimum threshold warning, quantity of 8 boxes, minimum stock of 10 and reorder quantity of 20
Feature comparison
CapabilityFree TemplateUNIO24 FreeRecommended for more than one stockroom
Stock levels
On hand worked out from movementsBoth calculate it. UNIO24 also splits the balance by location.PartialYes
Reorder point warningThe template shows REORDER on the row. UNIO24 flags the item on the phone and the desktop.PartialYes
Parts used on work ordersThe issue is tied to the work order and the machine it went into.NoYes
History
Stock card per itemReceipts and issues in order, with the balanceYesYes
Data & reliability
Several people entering stock at onceA shared file gets overwritten. UNIO24 handles the whole team.PartialYes
Who entered each movementEvery receipt and issue with name, date and timePartialYes
Full support1/ 66/ 6

Frequently Asked Questions

About tracking and counting stock with the template

Is the inventory tracking spreadsheet free?

Yes. No cost, no subscription, no card. Enter your name and email and the Excel file downloads instantly.

What should an inventory count sheet include?

Item number, description, bin, unit, the counted quantity, the date and who counted. For year-end figures add unit cost and counted value. Whether the book quantity goes on the printed sheet is a choice: leave it on to spot variances while you count, or hide it for a blind count, which keeps counters from simply confirming the expected number.

Can I track stock in more than one location?

The template holds one bin per item. For several stockrooms the cleanest option is a file per stockroom, because each balance has to add up on its own. When stock moves between sites often, UNIO24 keeps a balance per location and records the transfer.

How do I set a reorder point?

Add up what goes out during the supplier's lead time, then add a safety margin. If the crew uses 3 boxes of gloves a week and the supplier takes two weeks to deliver, 6 boxes go out while the order is on its way; with a margin of 4, the reorder point is 10. Change the number when usage or lead time changes. More on the margin in safety stock.

What do I do with count variances?

Enter each one as an adjustment on Stock Movements, signed, with the reason: damaged, expired, entered wrong, or taken without a requisition. Never overwrite the on-hand number. If the same item comes up short at every count, it is usually being taken without paperwork.

Is this a retail inventory spreadsheet?

It tracks quantities, reorder points and the value of each product, which a small shop needs too. Selling price, margin and sales are left out: that is the job of a point-of-sale system. Many shops use a spreadsheet like this for the back room and the POS at the counter.

up arrow