An inventory count sheet records what is physically present at a particular location and time. Start with a separate row for each SKU, location and stock status, record the quantity you actually count, then compare it with a matching inventory snapshot. A blank quantity means uncounted; zero means you checked and found none.
This guide follows a fictional boutique counting canvas pouches. The quantities are original examples, not customer results. For an editable calculation after the count, use the free physical count adjustment worksheet.
What belongs on an inventory count sheet?
At the top, write the count ID, date, cutoff time, location, counter and page number. “October stocktake” is too broad if two people count the same shelf at different times. A record such as COUNT-1020, backroom A, October 20 at 9:00 a.m. tells the reviewer which snapshot to use.
| Field | What to enter | Mistake it helps expose |
|---|---|---|
| SKU and description | PCH-NV; navy canvas pouch | Combining colors or sizes |
| Bin and stock status | A1; sellable | Counting held returns as sellable |
| Unit | Each, pack or case; define pack size | Comparing cases with individual units |
| First count and recount | Separate quantities and counter initials | Replacing the original observation |
| Movement reference | Receipt, transfer or dispatch ID with time | Calling a timing difference a loss |
| Review fields | Snapshot, final count, difference, cause and approval | Posting an unexplained adjustment |
If the business uses lots or serial numbers, add those identifiers rather than hiding them inside a generic product total. The batch and lot traceability guide covers the separate history needed to connect materials, production and shipments. A count sheet only captures a physical observation.
Prepare the area and fix the cutoff
Choose a manageable zone and list every shelf, overflow bin, returns area and packing bench in that zone. Assign each area once. Mark completed shelves so a second counter does not unknowingly add the same units again. Check a few empty-looking bins too; a prepared SKU list can miss items stored in the wrong place.
Pause movements in the zone where practical. If orders must continue, keep a movement log with the item, quantity, direction, exact time and document reference. Record when each bin was counted. The reviewer must bring the physical observation and system balance to the same time before comparing them.
Keep the expected quantity off the counter's copy if you want a blind count. The review page can hold the system balance after counting. Count sealed packs using an agreed method and write the conversion. Three verified packs of 12 plus five loose pieces equal 41 each, not eight units.
Filled example: two differences, two different causes
The boutique freezes movements at 9:00 a.m. Its snapshot lists 40 navy pouches in A1, 24 natural pouches in B1 and six navy returns in a hold bin. These are distinct rows even though two rows share the same SKU. Both the physical total and snapshot include held returns, but the hold stock remains unavailable for sale.
| SKU / bin / status | Snapshot | First count | Recount | Final difference |
|---|---|---|---|---|
| PCH-NV / A1 / sellable | 40 | 37 | 38 | −2 |
| PCH-NT / B1 / sellable | 24 | 26 | 26 | +2 |
| PCH-NV / R1 / held return | 6 | 6 | 6 | 0 |
| Control total | 70 | 69 | 70 | 0 net |
The net difference is zero, yet two SKU rows are wrong. The final differences have an absolute total of four units: two missing on one row plus two extra on another. Do not approve a count just because its grand total matches. The recount found one navy pouch behind a carton; the original count of 37 stays visible alongside the corrected observation of 38.
In this fictional investigation, dispatch record D-118 confirms that two navy pouches left before the snapshot cutoff but the shipment was not posted. Receiving record R-205 confirms that two natural pouches arrived before cutoff but the receipt was not posted. After the responsible person corrects those specific transactions, the expected quantities become 38 and 26. No separate unexplained quantity adjustment is needed for these rows. Posting both the missing transactions and another −2/+2 adjustment would double-correct the inventory.
What if stock moves while you count?
Suppose another shelf has a 9:00 a.m. snapshot of 50 units. A documented receipt adds five at 9:10, and the counter finds 54 at 9:20. With no other movement, the comparable expected balance at 9:20 is 55. The unexplained difference is 54 − 55 = −1. Comparing 54 directly with the earlier 50 would incorrectly suggest a gain of four.
Alternatively, bring the count back to the cutoff: 54 minus the five received after cutoff equals 49, compared with the original 50. Both methods produce −1 if the movement record is complete. Use one approach consistently. If the receipt time or count time is uncertain, flag the row for investigation or recount rather than treating the arithmetic as proof.
Review before changing inventory
For each difference, check the item identity, unit, location, stock status and relevant movements. Look for an unposted receipt, dispatch, transfer or return. Keep damaged stock separately identified; physical presence does not make it sellable. Count someone else's consigned stock under a clearly defined ownership scope rather than silently adding it to owned inventory.
Assign a reviewer and retain the evidence for any approved correction. Shopify's stock-count review documentation, for example, separates count review from updating inventory and describes an adjustment history. Follow the actual process in your own system; the downloadable sheet does not connect to Shopify or post changes.
Use the free adjustment worksheet only after establishing comparable quantities. Give each entry a label that identifies the SKU, bin and status. A calculated difference is a review aid, not approval. Keep count sheets, transaction evidence and the final posting reference together.
Make the next count easier
Close the count with a short exception list: unresolved rows, owners and next check dates. An empty result is not a confirmed zero. If a bin was inaccessible, mark it uncounted and exclude it from claims about completed coverage.
Choose the next count zone from actual problems such as frequent picking errors, returns or inconsistent pack sizes. There is no universal count frequency in this worksheet. A small shop can start with one clearly scoped zone and adjust the routine after seeing how long it takes and what discrepancies recur.
Once quantities are reliable, use the reorder-point guide to plan replenishment. A purchase order tracker records incoming orders; it should not be used as evidence that goods have physically arrived.
Common questions
Can I use the sheet for a cycle count?
Yes. Limit it to the selected zone or items and record that scope. A completed cycle count does not mean the whole store was counted.
Should I enter zero for an item I did not reach?
No. Leave it uncounted and record the reason. Enter zero only after checking the assigned location and confirming that no units are there.
Does the printable template calculate differences?
No. It provides blank writing fields. Calculate final counted quantity minus the comparable system quantity on the review page, or enter reviewed figures in the free browser worksheet. Preserve your completed paper or PDF with its evidence.