Free stock count builder

Count stock, not spreadsheet mistakes.

Build a clean Excel, CSV, or printable count sheet for your store or warehouse—in under a minute, with no sign-up.

Create my count sheet How it works

Free
No sign-up
Files stay on your device

Counted 326 / 412

SKU 1048Cotton apron

A-022424

SKU 1052Stoneware mug

A-031817

SKU 1057Linen napkin

A-0432—

No account neededStart immediately

Excel, CSV and print readyUse the format that fits

Generated on your deviceYour stock data stays private

Make your sheet

Set up your count.

Three choices. One tidy, ready-to-use sheet.

Set up your count

stock-count-template.xlsx XLSX

Live count sheet preview

Live

Preview focuses on key fields; downloads include every selected column.

Available downloads

CSV file
Excel worksheet
Printable sheet
Release checklist

For larger lists, import locations first with zone owners, escalation, and spot-check proof, then load products.

A cleaner count

From blank sheet to signed-off count.

Start simple. Add more control only when the size of the count calls for it.

01
Create the sheet

Choose the columns your counters need and download the file.
02
Check the list

Find missing SKUs, duplicate barcodes, and broken rows before counting.
03
Count and reconcile

Enter quantities in Excel or scan with a phone, then review variances.

Free tools

Help for the messy parts.

Open one dedicated tool when you need to clean the input or close the count—not all of them at once.

01 Check your barcode listPaste or upload a CSV to catch missing IDs, duplicate barcodes, GTIN errors, bad locations, print-readiness gaps, and GS1 2D or SSCC mismatches before counters scan. Keep clean rows moving and send proof exports to owners when needed.

Barcode check

Check your barcode list

Paste or upload a CSV to catch missing IDs, duplicate barcodes, GTIN errors, bad locations, print-readiness gaps, and GS1 2D or SSCC mismatches before counters scan. Keep clean rows moving and send proof exports to owners when needed.

Paste CSV Upload CSV

Delimiter: , GTIN checked: 0 Readiness score: 0/100

80+ is ready; below 80 needs review. GTIN, location, collision, quantity, GS1 2D syntax, row-match, and SSCC checks stay in the exports.

Barcode list CSV Paste headers and rows, or upload a CSV. Keep SKU, barcode, location, quantity, and count-pack evidence together.

SKU,Barcode,Lot number,Use by date,Expiration date-time,Best before date,Sell by date,Production date,Packaging date,Serial number,Count of items,Logistic count,Net weight kg,GS1 2D data,Description,Location,Expected qty,Batch,Scope,Assigned counter,Reason,Location confirmed by,Counter signed off at,Supervisor reviewed at
A1001,0123456789012,LOT-A,2026-09-30,2026-09-30 14:30,2026-09-15,2026-09-10,2026-03-15,2026-03-16,SN1001,10,48,1.950,(00)000123456789012343(02)00123456789012(37)48,Widget A,A01-01,10,Batch 1,A items - warehouse A,Alex,,Alex,,
A1002,0123456789029,,2026-08-31,2026-08-31 14:30,2026-08-15,2026-08-10,2026-02-10,2026-02-11,SN1002,12,24,0.500,https://id.gs1.org/01/00123456789029/21/SN1002?17=260831&7003=2608311430&15=260815&16=260810&11=260210&13=260211&30=12&37=24&3103=000500,Widget B,A01-02,,Batch 1,A items - warehouse A,Priya,,Priya,,
A1003,0123456789029,LOT-B,2026-10-15,2026-10-15 08:45,2026-10-01,2026-09-28,2026-04-01,2026-04-02,,5,36,1.250,https://id.gs1.org/01/00123456789029/10/LOT-B?17=261016&7003=2610160845&15=261001&16=260928&11=260401&13=260402&30=5&3103=001250,Widget C,A01-03,5,Batch 1,A items - warehouse A,Sam,Found stock,Sam,Sam 09:24,Lee 10:02
A1004,,LOT-C,2026-11-01,2026-11-01 09:00,2026-10-20,2026-10-15,2026-04-15,2026-04-16,,8,,2.000,,Widget D,A01-04,8,Batch 2,A items - warehouse A,Alex,,Alex,,
A1005,0123456789000,LOT-D,2026-12-31,2026-12-31 16:15,2026-12-15,2026-12-10,2026-05-01,2026-05-02,,3,18,0.750,https://id.gs1.org/01/00123456789000/10/LOT-D?17=261231&7003=2612311615&15=261215&16=261210&11=260501&13=260502&30=3&3103=000750,Widget E,0123456789012,3,Batch 2,A items - warehouse A,Priya,Moved stock,Priya,,
,0123456789074,LOT-E,,May 1 2026 08:00,2026-09-30,2026-09-20,May 1 2026,2026-05-01,SN1006,3,12,0.750,https://id.gs1.org/01/00123456789074/10/LOT-E/21/SN1006?15=261001&16=260921&11=260502&13=260503&30=4&3103=000700,Widget F,A01-6,3,Batch 2,A items - warehouse A,Sam,,Sam,,

Import requirements

Keep count-pack columns in the import

Run the barcode check before scanning, but do not strip fields that supervisors need after the count.

Batch and scope: Keep the assignment batch or count scope so the variance reviewer can group follow-up work.
Counter and location: Keep assigned counter, location, bin, or aisle fields so rows trace back to the person and place counted.
Label durability: Replace worn rack or bin labels. Keep one full-height, high-contrast scanner-readable label with quiet zones, edge clearance, and a smooth glare-free scan surface.
Cycle handoff: Keep bin-first scan proof, count attempt policy, reason-code prompt, pending-review owner, and release status with the scan-proof export.
Quantity and evidence: Keep expected quantity, reason, location confirmation, counter sign-off, and supervisor review columns for the count pack.
2D barcode data: Keep lot, date, serial, count, weight, element-string, scanner-output, and Digital Link fields when labels need QR, Data Matrix, or SSCC data; the 2D audit checks decoded values before label work.

The import CSV keeps source values exact. Use the spreadsheet-safe CSV when people will open clean rows in spreadsheet software.

Spreadsheet, audit, proof, print, and SSCC exports

Preview (0 rows)

0 rows loaded

02 Plan cycle count scope and cadenceChoose whether each scope covers a full location or named products only. The planner scores risk and capacity, then builds session exports with the correct completion, exception, review, and release proof.

Cycle count planner

Plan cycle count scope and cadence

Choose whether each scope covers a full location or named products only. The planner scores risk and capacity, then builds session exports with the correct completion, exception, review, and release proof.

Scope and risk

Scope name Count coverage SKUs or locations in scope Inventory value in scope Recent variance rate % Barcode coverage %

Delivery capacity

Available count sessions per week SKUs or locations per session

Schedule, queue, and counters Show due dates, eligibility, queue CSV, and counter rotation

Late-date policy

Count generated Maximum days before late Working days Serialized stock

Maximum days before late counts selected working days. Days between completed counts use calendar days, then roll to the next working day. Company holidays are not modeled.

Multiple scopes CSV (optional) Paste capacity columns. Add ABC class, intended cadence weeks, and planned sessions to check portfolio coverage; add scope type for mixed full-location and named-product rows. Counter names for session export (optional) Enter names separated by commas or new lines. Sessions rotate counters and add review capacity, device readiness, movement cutoff, release gates, reason-code capture, pending review, and sign-off fields.

Cycle plan summary

Priority class: -
Cadence: -
Sessions per cycle: -
Capacity fit: -

Next action:

Suggested count plan (0 rows)

CSV generated in your browser

Cycle count preview scopes, priority classes, count schedule, and next supervisor action.

03 Stock count time calculatorCompare first-pass counting, expected recount/review rows, and barcode time savings before you assign counters.

Time estimate

Stock count time calculator

Compare first-pass counting, expected recount/review rows, and barcode time savings before you assign counters.

Estimated time to complete

Estimated count time by method, supervisor review block, and combined time savings.
Method	Total time	Review block	Savings

Operational recommendation:

04 Review count variancesPaste or upload counted rows, set tolerances, and split OK rows from recounts, approvals, and posting holds. Exports package cutoff, root-cause, adjustment, and pending-review disposition proof for count-pack release.

Variance review

Review count variances

Paste or upload counted rows, set tolerances, and split OK rows from recounts, approvals, and posting holds. Exports package cutoff, root-cause, adjustment, and pending-review disposition proof for count-pack release.

Recount if quantity differs by Recount if variance is at least % Manager approval if value is at least

Advanced tolerance policy Same limits for gains and losses

Use separate limits for stock gains and losses

Join two count files System stock + count result

Choose the item, location, and quantity columns in each file. Matching is exact after outer whitespace is removed; source values and leading zeros stay unchanged.

System stock CSV Choose system CSV No file selected.

Item key Location key Expected quantity

Returned count CSV Choose count CSV No file selected.

Item key Location key Counted quantity

Choose both CSV files to map and join them.

Paste CSV Upload CSV

Count result CSV Paste rows or upload a CSV with item, location, expected quantity, physical count, optional value, reason, cutoff timing, approval, disposition, posting or recount reference, root-cause, follow-up, condition, and closeout evidence columns.

Count batch,Zone,Assigned worker,Item number,Storage location,Book quantity,Physical count,Unit value,Expected value,Counted value,Variance reason,Location checked by,Count completed at,Approved by,Scanner blocked at,Mobile exception reason code,Counting reason policy,Default counting reason code,Display counting reason code,Edit counting reason code,Counting reason code group,Reason-code approval status,Unconfirmed pick qty,Receipt not put away qty,Putaway not posted qty,Shipment hold qty,Transfer in transit qty,Paperwork not posted qty,Timing review cleared at,Discrepancy investigated by,Correction accepted by,Correction acceptance reason,Transaction evidence checked,Discrepancy follow-up owner,Discrepancy follow-up due at,Preventive action,Evidence stored at,Follow-up verified at,No-barcode/manual route,Manual route owner,No-barcode reason code,Manual route verification,Manual list attached at,Barcode repair ticket,Repair source field,Repair priority,Recount completed at,Pending review cleared at,Duplicate scan review owner,Duplicate scan reason code,Duplicate scan verification
Batch 1,A items - warehouse A,Alex,A1001,A01-01,12,12,8.50,102.00,252.00,Cost layer review,Alex,Alex 09:10,Lee 10:05,,,Optional,,Hide,No,,Not required,0,0,0,0,0,0,,,,,,,,,,,Use standard scanner exceptions only; no separate manual route required.,Count lead,,,,,,,,,,,
Batch 1,A items - warehouse A,Priya,A1002,A01-02,24,23,14.25,342.00,327.75,,Priya,Priya 09:16,,,,Mandatory,,Line,Yes,VARIANCE,Pending,1,0,0,0,0,Open receiver paperwork,,Priya,,,,,,,,,Use standard scanner exceptions only; no separate manual route required.,Count lead,,,,,,,,,,,
Batch 1,A items - warehouse A,Sam,A1003,A01-03,8,11,42.00,336.00,462.00,Found stock,Sam,Sam 09:24,Lee 10:02,,,Mandatory,FOUND,Line,Yes,VARIANCE,Approved,0,0,0,0,0,0,Sam 09:30,Lee,Lee 10:02,Found stock matched receiving note,Receipt and movement history checked,Lee,2026-08-01,Update receiving cutoff checklist,Count pack folder Batch 1,Lee 10:20,Use standard scanner exceptions only; no separate manual route required.,Count lead,,,,,,,Sam 09:31,Lee 10:02,,,
Batch 2,A items - warehouse A,Alex,A1004,A01-04,15,9,5.75,86.25,51.75,,Alex 09:33,Alex 09:34,,Alex 09:32,Barcode would not scan,Mandatory,NO_SCAN,Line,No,NO_SCAN,Pending,0,0,0,Open shipment,0,0,,Alex,,,,,,,,,Count no-barcode rows from the exception list then send them to barcode repair.,Item-data owner,NO_BARCODE,Manual list attached and repair ticket assigned,Alex 09:40,BR-214,Barcode / GTIN,1,,,Count lead,Repeated mobile scan,
Batch 2,A items - warehouse A,Alex,A1004,A01-04,15,9,5.75,86.25,51.75,Duplicate mobile scan,Alex 09:35,Alex 09:36,,Alex 09:35,Barcode would not scan,Mandatory,NO_SCAN,Line,No,NO_SCAN,Pending,0,0,0,0,0,0,,Alex,,,,,,,,,Count no-barcode rows from the exception list then send them to barcode repair.,Item-data owner,NO_BARCODE,Manual list attached and repair ticket assigned,Alex 09:43,BR-214,Barcode / GTIN,1,,,Count lead,Repeated mobile scan,Duplicate row removed from posting batch
Batch 2,A items - warehouse A,Priya,A1005,A02-01,6,7,125.00,750.00,875.00,Moved stock,Priya,,Lee 10:12,,,Mandatory,MOVED,Line,Yes,VARIANCE,Approved,0,0,1,0,1,0,Lee 10:09,Lee,Lee 10:12,Moved stock accepted after putaway check,Putaway and transfer history checked,Lee,2026-08-02,Review putaway cutoff queue,Count pack folder Batch 2,,Count no-barcode rows from the exception list then send them to barcode repair.,Item-data owner,NO_BARCODE,Manual list attached and repair ticket assigned,,BR-215,GS1 Digital Link,2,,Lee 10:12,,,
Batch 2,A items - warehouse A,Sam,A1006,A02-02,30,,3.20,96.00,,Needs recount,Sam,,,,,Mandatory,RECOUNT,Line,Yes,RECOUNT,Pending,0,2,0,0,0,Pending paperwork,,Sam,,,,,,,,,Count no-barcode rows from the exception list then send them to barcode repair.,Item-data owner,NO_BARCODE,Manual list attached and repair ticket assigned,,,Barcode / GTIN,1,,,,,

Review summary

Rows: 0
Variance rows: 0
Posting holds: 0
Approval value: $0

Next action:

Blind recount packet

Send only stable row keys and blank completion fields to the independent second counter.

No recount rows are ready for a blind packet.

Batch release note

Review variances to generate a session-batch release note.

Variance preview (0 rows)

CSV processed in your browser

Preview filters Run a review to filter rows.

Keep it practical

Use the simplest method that fits.

A small shelf does not need a system rollout. A team counting thousands of items should not share one spreadsheet.

Use the simplest method that fits.
Method	Best fit	Tradeoff
Paper	Small shelves, no expected quantity	Fast to start, slow to reconcile
Excel	Simple lists with expected quantity	Easy export, manual typing risk
Barcode app	Many rows, barcodes, team counts	Fast capture and cleaner variance export

When the count grows

Thousands of items? Bring the count to the barcode.

Scan with your phone, work offline, and keep every counter in sync with Mobile Inventory.

Import your CSV in seconds
Scan barcodes and enter quantities fast
Works offline. Syncs when you are back online.

See the scanning app

Field notes

A better count starts before count day.

Short, practical guides for getting the list, the team, and the handoff right.

01 Free stock count template Build an Excel, CSV, or printable count sheet. 02 Barcode readiness checker Find missing SKUs, duplicate barcodes, and bad columns. 03 Variance reviewer Classify count differences by quantity, percentage, and value thresholds.

Quick answers

Before you begin.

Can I download a stock count template without signing up?

Yes. The basic CSV, genuine .xlsx, and printable templates can be generated in the browser without an account.

When should I use Mobile Inventory instead of Excel?

Use Mobile Inventory when you have many items, barcodes, multiple counters, offline locations, or a need to export a cleaner variance report.

Can the templates be localized later?

Yes. The site is built with locale files so copy can be translated manually per language without changing the page templates.

Ready when you are

Start with a cleaner count sheet.

Create my count sheet

Count stock, not spreadsheet mistakes.

Set up your count

Live count sheet preview

Available downloads

Count-pack checklist

From blank sheet to signed-off count.

Create the sheet

Check the list

Count and reconcile

Help for the messy parts.

Check your barcode list

Keep count-pack columns in the import

Preview (0 rows)

Plan cycle count scope and cadence

Cycle plan summary

Next assignment batches

Suggested count plan (0 rows)

Stock count time calculator

Estimated time to complete

Review count variances

Duplicate or blank keys

Unmatched system rows

Unmatched count rows

Review summary

Blind recount packet

Batch release note

Correction summary

Posting holds and mobile exceptions

Detected columns

Required quantities

Review context

Import readiness

Decision rollup

Reason-code rollup

Session batch release rollup

Root-cause actions