Skip to content
Retail Store Inventory cover: a sample sheet with lines counted, units counted and net variance (units) and a column chart, beside the Dashboard tab

Retail Store Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This template is for a store that runs regular stock counts across its sales floor and backroom. The Count sheet tab holds one row per SKU with the system quantity, the counted quantity, the variance in units and its value at retail price. The Count calendar tab plans which department gets a spot count or a full count on every weekday. The Dashboard totals the net variance and the value of shortfalls, broken down by department and by location.

Print the Count sheet or fill it in on a tablet while you walk the floor. Enter the system quantity from your till or stock system, then the number you count, and let the variance calculate. Negative variances turn red, so you can recheck those lines first. Work through one department each day on the calendar, and keep the SKU order the same so counts line up from week to week. Overwrite the sample lines with the products you stock.

Useful for

  • Running a weekly spot count on the sales floor
  • Finding where shrinkage happens by department
  • Preparing for a full store count at year end

What's included

  • 4 tabs: Dashboard, Count sheet, Count calendar, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Count sheet: a table
  • Count calendar: a grid
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Count sheet tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How does a spot count differ from a full count in this sheet?

A spot count checks a few lines or one department, usually to catch a problem early. A full count covers every SKU in the store and is often done on a set day. The Count calendar lets you mix both across the week, so no department goes too long without a check.

Why does a variance show up when I count?

A variance means the counted quantity differs from the system quantity. Common causes are sales not scanned, items moved to another location, damage, or a delivery counted twice. Recount the line before you adjust the system, so you know the gap is real.

How do I value a shortfall?

The value difference multiplies the variance by the retail price, so a shortfall of two items priced at 30 dollars shows as negative 60 dollars. The figure is at retail, not cost. Ask your accountant which value your stock write-offs should use.

  • #inventory
  • #retail-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…