Get your free inventory count sheet
A count sheet spends its working life on a clipboard, not on a screen. Print the sheet, count on the floor, then key your numbers into the spreadsheet to see the variance.
- Blind count sheet (PDF) (no expected quantity printed)
- Non-blind count sheet (PDF) (expected quantity printed)
- Variance spreadsheet (.xlsx) (Excel, Google Sheets, LibreOffice Calc)
No sign-up, no email gate, no time limit. Both PDFs are US Letter, two pages, 50 numbered rows, and print in black and white.
Blind vs non-blind counting: which sheet to print
The two PDFs are the same sheet apart from one column: the expected quantity. That column changes the count more than anything else on the page.
What a blind count sheet is
A blind sheet prints the SKU, description, bin and unit, then leaves the quantity column empty. The counter writes what is in the bin, with nothing to compare against.
What a non-blind count sheet is
A non-blind sheet prints the expected quantity, the figure your system holds, beside a blank counted column.
Why it is the one decision that most changes count accuracy
A printed expected quantity is an answer. Once someone has read "48", counting turns into checking: four stacks of twelve, looks right, write 48, move on. That is how attention works when a number is in front of you, and it is why a non-blind count confirms the system more often than it tests it.
A blind count takes longer and finds more of the discrepancies that are really there. Print it when accuracy matters more than speed: year-end, high-value items, or any count backing an audit or an insurance claim. The non-blind sheet is faster, and fine for a routine recount that needs to catch a few large misses.
What belongs on an inventory count sheet
Both sheets carry the same fields:
- Page header. Location, section or zone, count date and counted by, hand-filled once per page.
- Row columns. Row number (pre-printed 1 to 50), SKU, product or description, bin or location, unit of measure, expected quantity on the non-blind sheet only, a wide blank counted quantity, and notes.
- Sign-off. Separate "counted by" and "checked by" lines, each with a name, signature and date.
One instruction is printed on it: write what you counted even if it looks wrong, and cross out mistakes rather than erase them.
Full physical count vs cycle counting: which to run
A full physical count means stopping and counting everything at once, usually yearly or ahead of an audit. A cycle count means counting a rotating slice continuously, so the catalog gets verified over a quarter or a year without stopping.
If you can tolerate a short stop and need one audit-grade number on one day, run a full count. If you cannot stop, count a slice on a schedule: name the zone and list only the bins you are counting that week. Both sheets work either way.
For the deeper comparison and ABC-tiered schedules, see our guides to cycle counting and inventory counting methods, and our stock-taking procedures guide for preparing a full count.
Count tolerance: when a variance is noise and when it is a problem
A variance is not automatically a problem. Handling, rounding on case-pack items and honest miscounts show up on almost every count. The question is where the line sits between a number you note and one you chase.
Two lenses answer that:
- Units and percent. Two units missing from an item that normally sits at 40 is noise. Two missing from an item that should have had two is not.
- Value. The spreadsheet multiplies each variance by your unit cost: a unit missing from a $5 item barely matters, one missing from a $500 item is worth an hour.
A line is worth investigating when either lens flags it, not only when both do. That is what the Flag column does: it checks each line against a tolerance percentage, a minimum unit allowance and a dollar threshold, and flags it if it crosses any one. Defaults are 2%, one unit and $50.
Most businesses run tighter tolerance on high-value items, roughly 1 to 2%, and up to 5% on low-value ones. Our guide to inventory counting covers the ABC analysis behind the split.
What to do with the variance once you have it
This is the step that gets skipped. A count that finds a variance and stops there has not fixed anything. Until the counted number goes back into the system that tracks your stock, it keeps quoting the old figure.
Write it back with a reason attached: what changed, why (a miscount, damage, shrinkage or a write-off, not just "count"), and who approved it.
In Qoblex that write-back is a stock adjustment, and you never pick a count mode for it. Qoblex works out the mode by watching who actually counts. While one person counts, typing quantities in or running the CSV stocktake wizard that exports a location's stock and takes the counts back, it stays a straightforward correction that authorizing resolves in one step, and nothing moves in or out of stock until that draft is authorized.
The moment a second, different person records a count on the same adjustment, Qoblex promotes it to a fully reconciled stocktake, automatically and permanently. Every line then has to settle to one agreed quantity before it can be authorized, and the total stays provisional until it does. Authorizing and reconciling are two separate permissions, so the person counting is not automatically the one who commits the number. Running a stock take covers the in-app steps.
When a paper count sheet is enough
Who this fits
One location. One or two people counting rather than a large rotating team. No lot, batch or serial-tracked stock. Counted numbers keyed in within a day, not a month.
If that is your operation, a clean printed sheet with a sign-off line is a perfectly good count.
What starts to hurt
Three things break it:
- More than one counter, with no cross-check. Paper keeps no per-counter record. If two people count the same shelf, or each skips a bin assuming the other has it, nothing on either sheet says so.
- Lot, batch or serial-tracked stock. A flat counted-quantity column cannot say which batch or expiry date a count applies to, so a variance cannot be traced to one batch.
- Rolling many sheets into one trusted number. Consolidating paper across counters or locations, and tracking which lines were checked twice, is slow and error-prone at volume.
Where Qoblex fits
Qoblex's stock adjustment covers the first case with no setup, because the multi-counter mode is detected rather than chosen. Each counter's tally is kept separately rather than overwritten, every line shows whether the counters agree and whether it is Pending, in Conflict or Resolved, and nothing authorizes until every line has settled.
Lot and batch traceability is a separate paid add-on; see pricing for what is included where. If none of these describes your week, print the sheet and keep your Saturday.
FAQ
Is this inventory count sheet really free?
Yes. No sign-up, no email gate, no time limit.
What is the difference between a blind and non-blind inventory count?
A blind sheet does not print the expected quantity, so the counter writes only what they find. A non-blind sheet prints it beside a blank counted column, which is faster but more prone to confirming the system's number.
Should I run a full inventory count or a cycle count?
Run a full count when you can stop for a short time and need one audit-grade number on one day. Run a cycle count, a rotating subset counted continuously, when you cannot stop; our cycle counting guide covers ABC-tiered schedules.
What counts as an acceptable variance in a stock count?
A variance is worth investigating if it crosses either a unit or percentage threshold or a dollar threshold, not only both.
What do I do with the variance after a count?
Write it back to whatever system tracks your stock, with a reason attached (miscount, damage, shrinkage or write-off) and who approved it. In Qoblex that is a stock adjustment.
Do I need special software to use this template?
No. The PDFs need a PDF viewer and a printer; the spreadsheet works in Excel, Google Sheets or LibreOffice Calc.