Free inventory count sheet template
Stock on hand by item and location, and what is running low.
Use this templateOpens as a card of your own. Free, no account needed.
What it looks like
| Item | SKU | Location | On hand | Reorder at | Unit cost |
|---|---|---|---|---|---|
| Coffee beans 1kg | CB-1000 | Back room | 34 | 20 | $18.00 |
| Coffee beans 250g | CB-250 | Shelf | 12 | 25 | $6.50 |
| Paper cups 12oz | PC-12 | Back room | 400 | 500 | $0.09 |
| Lids 12oz | LD-12 | Back room | 650 | 500 | $0.04 |
| Oat milk | OM-1 | Fridge | 18 | 24 | $2.40 |
| Whole milk | WM-1 | Fridge | 30 | 24 | $1.60 |
| Filters | FL-100 | Shelf | 8 | 10 | $4.20 |
| Syrup vanilla | SV-750 | Shelf | 6 | 4 | $7.80 |
Sample rows. Replace them with your own by pasting a table, dropping in a CSV or Excel file, linking a Google Sheet, or photographing the receipts.
What each column holds
- Item
- what it is
- SKU
- its code
- Location
- where it is kept
- On hand
- how many there are
- Reorder at
- the level that means order more
- Unit cost
- what one costs
Questions to ask it
Type these into the card, in these words or your own. Each comes back as an answer, a chart, and the calculation behind it.
- “Which items are at or below their reorder level?”
- “Value of stock by location”
- “Total value of stock on hand”
Why a card and not a spreadsheet
A spreadsheet holds the rows. A card holds the rows, what you worked out from them, and what you concluded, in one place. Put a total into a sentence and it stays right when you add a row. Share it read-only, with the rows hidden if they are nobody else's business.
Start with this template
It opens as your own card with these rows in it. Change anything; nothing is shared until you share it.