Excel reviewer workbook
Plan the count, track movements and reconcile both observations.
Download ExcelPreview the workbookDownload a cycle count template for Excel and a printable blind count sheet. Record physical counts, check discrepancies and keep a record of the review.
Free downloads. No email or account required.
See the worked recount exampleBatch CC-014 · Zone A · 06 Nov 2026
Site MIA-01 · Counter assigned at kickoff
| Bin | SKU | UOM | Count |
|---|---|---|---|
| A-01-02 | TB-104 | EA | ⎯⎯ |
| A-01-03 | CL-208 | EA | ⎯⎯ |
| A-02-01 | PK-310 | EA | ⎯⎯ |
Counted at __________ Initials ______
Record 0 for an empty bin. Leave unchecked rows blank.
Plan the count, track movements and reconcile both observations.
Download ExcelPreview the workbookA US Letter floor copy with blank count cells and a single count time.
Download blind count PDFPreview the PDFA simple interchange file for counts, recounts and reviewer notes.
Download worksheet (CSV)Preview the CSVPlan each batch, preserve both count observations and record the review in the same workbook.
Batch, site, owner, bin, SKU, lot and UOM. Keep the book quantity at cutoff alongside the first count and independent recount, with a counter and time for each.
Record the confirmed quantity, unit cost, reason, reviewer, decision and sign-off. The workbook calculates quantity and value variances.
| Book | First | Recount | Confirmed |
|---|---|---|---|
| 120 | 116 | 118 | 118 |
Quantity variance −2 EA · Value variance −$17.00
Batch __________ · Date __________
Site or zone __________ · Counter __________
| Bin | SKU | UOM | Count |
|---|---|---|---|
Counted at __________ Initials ______
Record 0 for an empty bin. Leave unchecked rows blank.
Print at actual size on US Letter. Fill in the batch, site and zone before issuing a copy. Give a different counter a fresh copy for an independent recount.
Download blind count PDFChoose a site, owner, bins and SKU units. Capture the book balance at the cutoff.
Count the units physically present. Enter zero only when the bin was checked and is empty.
Record one count time per sheet. Log movements separately and review their timing before confirming a discrepancy.
Keep both observations. Record the reason, confirmation, reviewer and approval decision.
Batch CC-014 counts TB-104 in A-01-02 at MIA-01. All quantities use EA.
| Step | Time | Quantity |
|---|---|---|
| Book balance at cutoff | 09:00 | 120 EA |
| First count | 09:08 | 116 EA |
| Independent recount | 09:24 | 118 EA |
| Reviewer confirms | 09:35 | 118 EA |
The first observation is 4 units short. With no movements across the cutoff, the reviewer confirms the independent recount.
Quantity variance = 118 − 120 = −2 EA. Value variance = −2 × $8.50 = −$17.00. The reviewer routes the adjustment for approval.
Multiply annual units used by unit cost in the same UOM. Sort by annual usage value, choose thresholds appropriate to your site and adjust for repeated discrepancies or fast-moving SKUs.
For example, A items might be counted monthly, B items quarterly and C items twice a year.
Use the interchange worksheet when you need plain count and review fields.
| Site | Bin | Owner | SKU | Unit | Count | Recount | Reason | Reviewer |
|---|---|---|---|---|---|---|---|---|
| Miami | A-04 | Northline Goods | CT-200 | cases | 60 | 60 |
The counter receives the item and location information and records a physical count without seeing the expected stock balance.
Write 0 for a checked empty bin. Leave the count blank when it has not been checked.
Follow your variance rules and issue a fresh floor sheet to a different counter. Keep the first observation, recount and review together.
Subtract the book quantity at cutoff from the confirmed count. Multiply the signed result by cost per unit when cost is available.
Yes. Issue one sheet per zone or batch and reconcile each location, SKU, lot and unit consistently.