Summarize with AI

Discuss this page

Choose your assistant for a short summary and practical next steps.

If the prompt is not filled in, paste the copied text. Your assistant may need you to paste the page content.

Free Blank Inventory Count Sheet Generator

Choose the columns and the number of blank rows. For a blind count, turn off Expected Quantity before printing or exporting. To reconcile counts, keep expected quantity and variance, then download Excel (XLSX) for the formula. CSV has no formulas. Print on A4 or Letter. No sign-up.

Configure your count sheet

Choose columns and blank rows. Store and area details are optional; the file is ready to fill in during your count.

Number of blank item rows
Select table columns:
Download XLSX
Generated in your browser. SKU and barcode columns use text formatting. With Expected Quantity and Variance selected, the sheet calculates counted minus expected once both quantities are numeric. Otherwise, the variance cell stays blank.
Download CSV
A blank text table without formulas or cell formatting. Import the barcode column as text in your spreadsheet software to preserve leading zeros.
Print sheet
Print the current blank sheet, or choose Save as PDF in your browser’s print dialog. For a blind count, turn off Expected Quantity first.

Need to count inventory directly on your phone?

Retail Scan & Stock helps small businesses scan barcodes, perform physical counts, prepare purchase orders and share inventory reports.

Permanent Free plan · Up to 1,000 catalog items · 1 device

Opens the store listing in a new tab.

Min/max replenishment from stock counts. Use counted stock and your min/max rules to suggest quantities, round to order multiples and prepare drafts by assigned supplier. How min/max replenishment works

Explore Retail Scan & Stock →

Live Printable Preview

Formatted for clean printing on standard A4 and US Letter paper. Margins and page breaks adjust automatically.

Rows: 25

INVENTORY COUNT SHEET

Store / Business: ________________________
Location / Area: ________________________
Date:
Counted by: _______________________Verified by: _______________________
#SKUBarcodeItem / Product DescriptionExpected QtyCounted QtyVarianceNotes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

Physical Inventory Count Sheet Template

A ready-made blank stocktake sheet designed for annual or periodic physical counts. Includes text-formatted barcode fields and pre-configured formulas to calculate discrepancies automatically.

Download Ready-Made Template →

How to Conduct a Disciplined Physical Stock Count

What is an inventory count sheet?

An inventory count sheet is a physical or digital recording sheet used by store staff to tally shelf and backroom stock during a stocktake. Standardized sheets ensure counters record item identification, counted quantities, and discrepancy notes in a consistent format.

Blind counts vs. expected quantity counts

A 'blind count' sheet omits expected quantities, forcing staff to count physical units without anchoring to computer records. This prevents confirmation bias where counters assume the recorded quantity must be correct. Include the Expected Quantity column only when performing spot audits or variance investigations where immediate reconciliation on the sales floor is required.

Best practices for count day execution

  • Divide your store and stockroom into numbered bays or shelves before count day.
  • Count in pairs where possible: one person calls items and counts, the second logs and verifies.
  • Mark counted shelves with colored tape or stickers to prevent duplicate counting.
  • Store returned or damaged items in a clearly marked 'DO NOT COUNT' quarantine area prior to the audit.

Reconciling variances after the count

Once physical counting is complete, compare counted quantities against inventory records. Focus first on high-value and high-velocity discrepancies. Investigate whether differences are due to unrecorded vendor deliveries, cashier scanning errors, shrinkage, or misplaced backroom stock before finalizing record adjustments.

Worked example · illustrative figures

Fill a count row without mixing units

Use SKU, Barcode, Expected Quantity, Counted Quantity and Variance for this comparison. The generator creates a blank sheet; these figures show how a completed row can be read.

Example item · CSV row 1

SKU
BEV-MILK-001
Barcode
012345678905
Unit
pieces
Recorded
24
Counted
22
Variance
-2
  • Counted 22 − recorded 24 = −2 pieces. Use the same unit for both quantities.
  • Recount the shelf and check stock movements before recording a cause. For a blind count, leave Expected Quantity off and compare after counting.

For the same task on a phone, Retail Scan & Stock lets you scan items, record physical quantities and share the completed count as CSV or Excel.

View the example count CSV

The sample CSV has English headings and illustrative figures.

Related Stocktake Guides