How to Set Up a Simple Inventory Counting System for Small Retail Stores

Quick answer

The short version: create one shared inventory sheet, give each product variation its own identifier, and assign items to repeatable store or stockroom zones. Record starting stock and update quantities for purchases, sales, and losses so the sheet can be compared with a physical count.

Plan recurring counts for quieter periods, after relevant receipts, transfers, and adjustments have been recorded. The right frequency depends on the store and its products; one example is counting A items weekly, B items monthly, and C items quarterly.

During each count, record the physical quantity, flag damaged or unsaleable stock, and investigate differences before changing records. Keep a count trail that includes who counted and who reviewed the count and calculations.

Google Sheets supports sharing with view, edit, or comment access; if you need offline access, set it up and verify it before count day.

Step-by-step guide

Gather the store’s product and stock information

Before building the count sheet, gather the store’s current stock records and make a working list of the products you sell, including distinct variations such as sizes or colors. Each variation will need its own identifier later, so note any existing item codes and descriptions.

Write down how staff record purchases, sales, transfers between locations, and losses or damaged goods. This helps you know which stock movements must be accounted for before comparing a physical count with the records.

Choose a quieter period for the first count, then identify the areas to cover, such as sales-floor sections and stockroom shelves. A clear list of areas makes it easier to plan assignments and repeat counts consistently.

Sources: Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits.

Create the inventory spreadsheet

1. Open the Google Sheets home screen and select New to create a spreadsheet. Use it as the store’s inventory list and count log.

2. Add columns for item identifier, description, zone, starting quantity, current recorded quantity, physical count quantity, count date, counted by, reviewed by, and notes. Keep the starting quantity separate from the current recorded quantity so you can compare the count with the stock record.

3. Use one row per distinct product variation. The result should be a list where each item can be located and its recorded and counted quantities compared. Check the layout by entering a sample item and confirming you can fill in both quantity fields and the count details.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Identify products and divide the store into count zones

Give each distinct product variation its own SKU or other unique item code. For example, if the same shirt comes in different colors or sizes, list each color-and-size combination separately so its count can be recorded accurately.

Next, divide the sales floor and stockroom into practical zones, such as a named aisle, display area, or shelf section. Enter a consistent zone name beside each item in the spreadsheet; if an item is stocked in more than one zone, list each location separately so staff know where to count it.

Keep zone boundaries and names consistent from one count to the next. The result should be a clear assignment list that lets staff count a defined area and return to it during future counts.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Set a recurring count schedule

1. Group items by how often they sell, their value, and how likely their records are to be wrong. Use these groups to decide which products need closer attention; there is no single count frequency that suits every store.

2. Add a planned count frequency and next count date for each group in your spreadsheet. As a starting example, count A items weekly, B items monthly, and C items quarterly, then adjust after reviewing your store’s results.

3. Assign each scheduled count to a zone and choose a quieter period. Check the schedule regularly and increase counts for items with frequent discrepancies or important stockout risks.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Record stock movements and count a planned zone

1. Enter the starting quantity for each item in the spreadsheet. Update its recorded quantity as purchases arrive and sales or losses occur, so the sheet reflects stock movements between counts.

2. Before counting, choose a quieter period and make sure relevant receipts, transfers, and adjustments have been recorded. This helps avoid comparing the physical stock with an outdated figure.

3. Count the units in the scheduled zone and note damaged or unsaleable stock separately. Compare the physical result with the recorded quantity; if they differ, keep the discrepancy visible for investigation rather than silently changing the count.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Compare and document the count

1. Enter the physical count beside the recorded quantity for each item, then compare the two. Keep any difference visible until you have checked it; don’t overwrite the recorded figure without noting what changed.

2. For a mismatch, verify the item and zone, then check whether receipts, transfers, sales, or adjustments were recorded before the count. Recount if needed, note the reason you found (or that it remains unresolved), and flag damaged or unsaleable stock separately.

3. Record the item description, counted quantity, date, and who counted. Have another person review the count and any calculations, and retain relevant unit-price and value fields where applicable. This gives you a traceable record to check later.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Share the file with the counting team

Share the inventory sheet with the staff who will count or review stock, and choose the permission each person needs: view, comment, or edit. Give edit access to people entering counts or updating records; use view access for staff who only need to consult the list.

Ask each assigned person to open the file and confirm they can access it with the intended permission. If someone cannot make an expected update, check their access setting before changing the sheet structure or sending another copy, which could create competing versions.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Check that the count system is usable

Before relying on the sheet, choose a few items and run a test count. Confirm each product variation has its own identifier and zone, the scheduled count is easy to find, and you can enter a physical quantity beside the recorded quantity.

Check that purchase, sales, transfer, and loss updates are reflected, and that the count date, notes, counter, and reviewer are retained. Have each assigned staff member open the file and confirm they can view, edit, or comment as intended.

If you expect to count offline, set up offline access in advance and test it on the device and browser you’ll use. Google documents an internet connection for setup, Chrome or Edge, and enabling offline access as prerequisites.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Resolve count differences and access problems

If a physical count differs from the spreadsheet, first check that you counted the right item and zone. Confirm that receipts, transfers, sales, and adjustments were recorded before the count, then investigate and document the difference instead of simply overwriting the recorded quantity.

Note damaged or unsaleable stock separately. If repeated cycle counts leave differences unresolved, use a full physical count to reconcile the records.

If the store needs to count offline, set up and test access ahead of time. Google Sheets’ documented prerequisites include an internet connection for setup, Chrome or Edge, and enabling offline access.

Sources: How to use Google Sheets; Inventory Tracking: A 5-Step Guide for Retail Businesses; Cycle Counting: Types, Best Practices & Benefits; Publication 334 (2025), Tax Guide for Small Business.

Next steps

For a small store, I’d start with a spreadsheet, a clear list of product variations, and a manageable recurring count schedule. Adjust the cadence to what sells quickly, what matters most to keep in stock, and where discrepancies tend to appear.

Before relying on the routine, test it with a few items: confirm staff can find the right zone, enter a count, and compare it with the recorded quantity. If smaller counts keep producing unresolved differences, use a full physical count to reconcile the records.

Keep the count sheet as an operational record, and check tax or accounting requirements separately with a qualified adviser. If the team will count offline, confirm access is configured and working in advance.