Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainWarehouse ManagementStock Count Sheet

SpreadsheetWarehouse ManagementFree

Stock Count Sheet

Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.

Shown with sample data

Colour

Stock Count Sheet

Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.

Lines counted
93%
Progress
Count accuracy
54%
Lines matching the system
Net variance value
-$66.90
Recounts needed
1
Net variance value by location
  • C - Cold room-$6.30
  • D - Retail shelf-$9.90
  • A - Dry store-$14.20
  • B - Packaging-$36.50
Count accuracy by location
  • A - Dry store75%
  • C - Cold room66.7%
  • B - Packaging50%

How to use it

  1. 1Paste each item's system quantity and unit cost before you start, grouped by location.
  2. 2Count each location and type the counted quantity and your initials.
  3. 3Recount any line flagged Recount and type the figure in Recount qty.
  4. 4When every line is Counted, post the variances to your inventory system and keep this sheet as the audit record.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Run a clean stocktake or cycle count. Paste in system quantities, count each location and type what you find; the sheet works out the variance in units, percent and value, asks for a recount when a line is out by more than your tolerance, and uses the recount as the final figure. A location sheet shows progress and accuracy for each area, so you know when the count is finished and how much stock is missing or found.

Who it’s for

  • Year-end and quarterly stocktakes
  • Cycle counts of high-value items
  • Investigating shrinkage

What’s included

  • Count sheet: Counted against system quantity for every line.
  • By location sheet: Progress, accuracy and value of differences in each location.
  • Settings sheet: How far out a count can be before it is recounted.

How to use it

  1. 1Paste each item's system quantity and unit cost before you start, grouped by location.
  2. 2Count each location and type the counted quantity and your initials.
  3. 3Recount any line flagged Recount and type the figure in Recount qty.
  4. 4When every line is Counted, post the variances to your inventory system and keep this sheet as the audit record.

Tips

  • Count in pairs for high-value areas: one counts, one records.
  • Freeze stock movements during the count, or note deliveries that arrive mid-count.

Questions

When does a line need a recount?

When the first count differs from the system by more than the tolerance on the Settings sheet (5% by default) and no recount has been entered.

How is accuracy measured?

The share of counted lines whose final count matches the system quantity exactly.

Related searchesstock countstocktakecycle countinventory auditstock varianceshrinkage

Details

Format
Spreadsheet
Category
Warehouse Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetWarehouse ManagementFree

Stock Count Sheet

Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Warehouse Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More warehouse management templates

View all
Warehouse Bin Location Map2 sheets

Bins

8

Space used

71%

Empty bins

2

ABCD
1LocationZoneItemQty stored
2A-01-01-AA Fast pickPhone case, clear180
3A-01-01-BA Fast pickScreen protector260
4A-01-02-AA Fast pickCharging cable 1m90
5A-01-02-BA Fast pick 0
Bins
SpreadsheetWarehouse Management

Warehouse Bin Location Map

Where every item lives: zone, aisle, rack and bin, with capacity used and empty locations.

10 min setupPreview
Goods Received Log2 sheets

Lines received

6

Received complete

33%

Lines with a problem

4

ABCD
1DateGRN numberPO numberSupplier
2Nov 3GRN-0841PO-4418BoxCo Packaging
3Nov 3GRN-0841PO-4418BoxCo Packaging
4Nov 4GRN-0842PO-4421Volt Supply
5Nov 5GRN-0843PO-4425Northfield Supply
Receipts
SpreadsheetWarehouse Management

Goods Received Log

Check each delivery against its order: quantities, damage and shortages, with supplier accuracy.

10 min setupPreview
Warehouse Safety Checklist2 sheets

Items checked

18

Pass rate

67%

High-risk failures open

2

ABCD
1AreaCheck itemReferenceResult
2Racking and storageUprights and beams free of damage; beam locks fittedANSI MH16.1; OSHA 1910.176(b)Fail
3Racking and storageLoad capacity signs posted and not exceededANSI MH16.1Pass
4Racking and storageRacks anchored; column guards at aisle endsANSI MH16.1Pass
5Forklifts and MHEDaily pre-use checks completed and signed for every truckOSHA 1910.178(q)(7)Fail
Inspection
SpreadsheetWarehouse Management

Warehouse Safety Checklist

Inspect racking, forklifts, docks, exits, fire, electrical and hazmat with pass/fail results, risk ratings and tracked corrective actions.

30 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ