Stock Count and Reconciliation Checklist

5.0/5 with 1 votes

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 nameSKU / variantLocationUnit of measureExpected quantityFirst countFirst counted byFirst counted atRecountConfirmed countConfirmed varianceReconciliation stateEvidence / decision logAdjustment reference
Starter stock row: count one saleable SKU in one bin
Show note

STARTER 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:

  • First count: person, date/time and any count limitations
  • Recount: person, date/time, reason and what was checked
  • Reconciliation: cut-off movements, pack/bin checks, variance explanation and supporting record
  • Review: authorized reviewer, date/time, decision and approved adjustment quantity/reason, or why more investigation is needed
  • Posting: inventory-system reference, who posted and when, verified final balance, or confirmed no-adjustment decision Never overwrite an earlier observation to make it match the system. Use native task assignment and due dates for the current count/follow-up owner and target review date; these do not replace the recorded counter or authorized reviewer. A state field or checked row does not authorize an adjustment.
Starter stock row: count the same SKU in a second bin
Show note

STARTER 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:

  • First count: person, date/time and any count limitations
  • Recount: person, date/time, reason and what was checked
  • Reconciliation: cut-off movements, pack/bin checks, variance explanation and supporting record
  • Review: authorized reviewer, date/time, decision and approved adjustment quantity/reason, or why more investigation is needed
  • Posting: inventory-system reference, who posted and when, verified final balance, or confirmed no-adjustment decision Never overwrite an earlier observation to make it match the system. Use native task assignment and due dates for the current count/follow-up owner and target review date; these do not replace the recorded counter or authorized reviewer. A state field or checked row does not authorize an adjustment.
Starter stock row: count held or returned stock separately
Show note

STARTER 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:

  • First count: person, date/time and any count limitations
  • Recount: person, date/time, reason and what was checked
  • Reconciliation: cut-off movements, pack/bin checks, variance explanation and supporting record
  • Review: authorized reviewer, date/time, decision and approved adjustment quantity/reason, or why more investigation is needed
  • Posting: inventory-system reference, who posted and when, verified final balance, or confirmed no-adjustment decision Never overwrite an earlier observation to make it match the system. Use native task assignment and due dates for the current count/follow-up owner and target review date; these do not replace the recorded counter or authorized reviewer. A state field or checked row does not authorize an adjustment.

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.

Download PDFDownload WordDownload Excel

Presented by:

Checklist.com

Checklist.com

Stats

Views

42

Uses

0

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.

Adapt this count record to your organization’s approved inventory controls. It does not authorize inventory adjustments, calculate differences or post to another system.

Who it's for

A stock controller and independent reviewer count a defined stock/location scope, investigate differences and post only authorized adjustments.

How to use

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

Stock Count and Reconciliation Checklist Frequently Asked Questions

How do you carry out a physical stock count and reconciliation?

Define the stock and locations in scope, agree a cut-off, and pause movements or keep an approved movement log. Count each SKU and location in a consistent unit, preserve the original observation, recount differences where required, and compare quantities at the same cut-off. Investigate the evidence before an authorized reviewer decides on an adjustment. Finish by verifying any posting and assigning unresolved exceptions.

What information belongs in each stock-count record?

Use one record per SKU or variant, location and unit of measure. Keep expected quantity, first count, recount, confirmed count and confirmed variance separate. In the evidence log, record who counted and when, why a recount was made, what explains the difference, and who reviewed the decision. Include relevant movement records, the adjustment reference and the checked final balance. Separate held, damaged or returned stock when your process requires it.

Can you count stock while goods are still being received or picked?

Yes, if the approved process controls those movements and reconciles them to one cut-off. Log receipts, picks, transfers and returns with enough detail to determine whether each movement was already included in the count and system balance. If that cannot be established reliably, pause the affected activity or arrange a controlled recount. Do not compare quantities from different times without accounting for the movements.

Should counters see the expected inventory quantity?

Follow the approved counting method. For a blind first count, enter or compare the expected quantity only after the first physical observation has been recorded, and provide counters with records that do not reveal it. This checklist does not enforce blind access. Preserve the first count even if it differs from the expected balance, so the reviewer can see what was actually observed.

How do you calculate inventory variance?

Choose and document a sign convention, such as confirmed physical count minus expected quantity at the same cut-off. With that convention, 48 confirmed units against 50 expected units is a variance of −2 units. Use the same unit for both quantities and reconcile movements or pack conversions before comparing them. Calculate and review the result manually or in your approved system; the checklist does not calculate it automatically.

Should a recount replace the original stock count?

No. Keep the first count and recount as separate observations, with the person, time and recount reason recorded for each. Use the confirmed-count field for the quantity accepted after review. For example, if a second pack explains the difference, keep both counts and record where the pack was found. The original observation helps explain why the final quantity changed.

What should you check before approving an inventory adjustment?

Check the stock identity, location, unit and cut-off first. Review unposted receipts or picks, transfers, returns, nearby bins, pack sizes and the recount evidence. Record the explanation or leave an owned investigation open. The authorized reviewer should record the adjustment decision and approved quantity or reason. After posting in the inventory system, verify the resulting balance and save the reference to avoid duplicate adjustments.

When is a stock count ready to close?

Close the count boundary when every scoped stock line has been counted and reconciled, or has an explicitly accepted open exception with an owner, next action and review date. Keep unresolved records visibly open. Confirm any approved adjustments were posted once and their balances checked, then release movement controls through the agreed process. Retain original counts, recounts, dated review decisions and supporting evidence; a checked row alone does not authorize a stock change.

Why does this use Table rather than a form?

A count contains repeated stock records with the same quantity and evidence fields. Table lets the reviewer compare those records. Run-level scope, cut-off and movement controls belong in the run notes, while each row keeps one stock identity and its observations. The starter rows must be replaced with the real scope before counting.

Rate this Checklist

5 stars
Scores 5.00 with 1 vote

Suggest Improvements

Not finding exactly what you need?

Generate a custom checklist with AI in seconds.

Works on Web, iOS, and Android.