Stock Count and Reconciliation Checklist
Table of Contents
Introduction
Use this stock count and reconciliation checklist to compare physical stock with the inventory record while preserving first counts, recounts and review decisions. Table is the default in the saved checklist because each row represents one SKU, location and unit of measure.
The visible starter rows show a normal bin, a second location and held or returned stock. Rename, remove or duplicate them for the actual count. Record quantities and original counter/time in separate fields; use the evidence log for recount details, investigation and approval. Quantities are not imported, calculated or posted automatically.
| Task name | SKU / variant | Location | Unit of measure | Expected quantity | First count | First counted by | First counted at | Recount | Confirmed count | Confirmed variance | Reconciliation state | Evidence / decision log | Adjustment reference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Starter stock row: count one saleable SKU in one bin | |||||||||||||
Show noteSTARTER EXAMPLE: Rename this row to an actual SKU / variant, bin and unit of measure before use. Duplicate it for every distinct stock identity/location; remove unused starter rows. All values are deliberately blank. Confirm scope and units; record the original physical count, including a confirmed zero. Preserve the first count when recounting. Bring expected and physical quantities to the same cut-off, investigate differences and calculate/review variance manually or in the approved inventory system. Record the confirmed quantity and reconciliation state. Do not mark the line complete while its required count/review remains unfinished. EVIDENCE / DECISION LOG For each stock row, keep the original quantity, recount and confirmed quantity in their separate numeric columns. Preserve their audit details as dated entries in Evidence / decision log or task notes:
| |||||||||||||
| Starter stock row: count the same SKU in a second bin | |||||||||||||
Show noteSTARTER EXAMPLE: Use only if stock is held in another included location. Rename to the real SKU / variant, second bin and unit; remove if not relevant. Count and reconcile this location independently. Do not combine it with the first bin or copy any quantity. Confirm scope and units; record the original physical count, including a confirmed zero. Preserve the first count when recounting. Bring expected and physical quantities to the same cut-off, investigate differences and calculate/review variance manually or in the approved inventory system. Record the confirmed quantity and reconciliation state. Do not mark the line complete while its required count/review remains unfinished. EVIDENCE / DECISION LOG For each stock row, keep the original quantity, recount and confirmed quantity in their separate numeric columns. Preserve their audit details as dated entries in Evidence / decision log or task notes:
| |||||||||||||
| Starter stock row: count held or returned stock separately | |||||||||||||
Show noteSTARTER EXAMPLE: Use only for an included held/returned stock identity under your approved count scope. Rename to the real SKU, held/returns location and unit; remove if not relevant. Record the stock state in the row name or evidence log. Counting it does not authorize release to saleable stock. Confirm scope and units; record the original physical count, including a confirmed zero. Preserve the first count when recounting. Bring expected and physical quantities to the same cut-off, investigate differences and calculate/review variance manually or in the approved inventory system. Record the confirmed quantity and reconciliation state. Do not mark the line complete while its required count/review remains unfinished. EVIDENCE / DECISION LOG For each stock row, keep the original quantity, recount and confirmed quantity in their separate numeric columns. Preserve their audit details as dated entries in Evidence / decision log or task notes:
| |||||||||||||
Download or Print this Stock Count and Reconciliation Checklist
Get a printable version of this checklist in your preferred format: PDF, Word, Excel, or print directly from your browser.
Presented by:
Checklist.com
Stats
Views
42
Views: 42
Uses
0
Uses: 0
Tasks
3
Tasks: 3
Details
Define the count boundary
Record locations, items, stock states, units of measure and the cut-off time. Either pause stock movements or use a controlled log so receipts, picks and transfers are not counted twice or missed. Identify held, damaged, returned and in-transit stock according to the company’s process.
Use one row per stock identity and location
A useful row identifies SKU/variant, bin and unit of measure. Keep expected quantity, first count, recount and confirmed variance in separate fields. Record zero when the included stock line is genuinely absent. Do not silently omit it.
Investigate before posting
Look for unposted movements, pack-size errors, nearby bins, returns and other evidence. An unexplained difference stays an owned exception. Only the authorized reviewer can approve an adjustment; the actual posting and resulting balance must be verified in the inventory system.
The Table design is a recordkeeping view. It does not calculate variances, scan barcodes or post stock automatically. Use validated external arithmetic or calculate and review manually.
Illustrative stock-count example
Expected quantity is 50 units. A counter first records 48; a recount finds 50 after checking a second pack in the same bin.
Keep first_count=48 with the original counter/time, recount=50 with the recount person/time, confirmed_count=50 and confirmed_variance=0. Link the pack-check evidence. Record the reviewer’s decision that no adjustment is needed.
Do not overwrite the first observation or post an inventory change solely because the first count differed.
Who it's for
How to use
- Save a working checklist. In the run notes, identify site, count scope, cut-off/timezone, count lead, authorized reviewer, movement log and inventory source. Agree movement controls before counting.
- In the saved checklist, use Table for repeated stock records or List to work through them. Rename, remove or duplicate the three labelled starter rows; use one actual stock identity, location and unit per row.
- Record the first count, First counted by and First counted at. Preserve the original observation when recounting. Keep recount person/time/reason in the evidence log and confirmed quantity in its own field.
- Reconcile movements to the same cut-off and review the manually calculated variance. Record the actual state and give unresolved exceptions an owner and review date.
- Record the authorized decision before any adjustment. Verify the actual posting and final balance in the inventory system and retain the adjustment reference. Release movement controls through the approved process; unresolved rows stay open.
Illustrative example: The expected balance is 50 units, the first count is 48, and a recount finds 50 after checking another pack in the same bin. Preserve the first count and its counter/time; record the recount, its person/time and pack-check evidence separately. The confirmed count is 50 and the confirmed variance is zero. Record the reviewer’s no-adjustment decision rather than overwriting the first observation or posting an unnecessary stock change.