Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesOperations & Supply ChainWarehouse ManagementCycle Count Schedule and Variance Report

SpreadsheetWarehouse ManagementFree

Cycle Count Schedule and Variance Report

Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.

Shown with sample data

Colour

Cycle Count Schedule and Variance Report

Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.

Inventory accuracy
80%
Counts exact or within tolerance
Net variance value
-$303.40
Gross variance value
$303.40
Gains plus losses
Recounts needed
2
Counts overdue
2
Due this week
1
Variance value by SKU
  • BOLT-M8-$4.50
  • CTN-L-$11.40
  • LBL-220-$16
  • GSK-1162-$21
  • SEAL-14-$31.50
  • BRG-6204-$77
  • MTR-075-$142

How to use it

  1. 1On Count rules, set counts per year and tolerance for A, B and C items (for example 12, 4 and 2 counts).
  2. 2List items on the Schedule with ABC class, location, unit cost and the date last counted.
  3. 3Each day, count the items marked Overdue or Due this week, blind (without showing the system quantity).
  4. 4Record every count on the Counts sheet; anything outside tolerance shows Recount.
  5. 5Recount, investigate the cause, adjust the system and update Last counted on the Schedule.

In this workbook

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

About this template

Cycle counting replaces the annual shutdown count with small, frequent counts weighted by value. Set how often A, B and C items are counted and the variance tolerance for each class; the schedule gives every item its next count date and flags what is due. Record each count against the system quantity and the report calculates variance in units, value and percent, judges it against tolerance and tracks inventory record accuracy, the figure auditors and finance care about.

Who it’s for

  • Replacing or reducing annual physical counts
  • Improving ERP or WMS stock accuracy
  • Supporting auditors’ inventory testing
  • Finding root causes of stock loss

What’s included

  • Counts sheet: Each count with variance in units, value and percent.
  • Schedule sheet: Every item with its class, next count date and status.
  • Count rules sheet: Count frequency and tolerance for each ABC class.

How to use it

  1. 1On Count rules, set counts per year and tolerance for A, B and C items (for example 12, 4 and 2 counts).
  2. 2List items on the Schedule with ABC class, location, unit cost and the date last counted.
  3. 3Each day, count the items marked Overdue or Due this week, blind (without showing the system quantity).
  4. 4Record every count on the Counts sheet; anything outside tolerance shows Recount.
  5. 5Recount, investigate the cause, adjust the system and update Last counted on the Schedule.

Tips

  • Count blind: counters who see the system number tend to find it.
  • Freeze transactions for the location, or count when there is no movement such as at shift start, to avoid timing differences.
  • Record the cause of every adjustment (receiving error, picking error, damage, theft, unit of measure). Fixing causes improves accuracy; adjusting alone does not.

Questions

What is ABC cycle counting?

Items are ranked by annual usage value: A items (about 20% of items, 80% of value) are counted most often, C items least. It focuses effort where errors cost most.

How is inventory accuracy measured?

Here, the share of counts that are exact or within the tolerance for their class. Many warehouses target 95% or better; best-in-class sites exceed 99%.

What tolerance should I use?

Common starting points are 0–1% for A items, 2% for B and 5% for C, tighter for high-value or serialised stock.

Related searchescycle count templatecycle count scheduleinventory variance reportabc cycle countinginventory accuracy kpistock count variance

Details

Format
Spreadsheet
Category
Warehouse Management
Sheets
3
Setup
25 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetWarehouse ManagementFree

Cycle Count Schedule and Variance Report

Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.

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
25 min
Level
Intermediate
Price
Free

Your copy is private to you.

More warehouse management templates

View all
Stock Count Sheet3 sheets

Lines counted

93%

Count accuracy

54%

Net variance value

-$67

ABCD
1LocationItemUnit costSystem qty
2A - Dry storeEspresso beans 1kg$18.5014
3A - Dry storeLoose leaf tea 500g$11.809
4A - Dry storeGranola 2kg$14.204
5A - Dry storeHot chocolate 1kg$9.4012
Count
SpreadsheetWarehouse Management

Stock Count Sheet

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

10 min setupPreview
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

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