Inventory counts and variances for convenience stores

On this page

1. How often to count
2. Get ready before you count
3. How to count
4. Trouble spots
5. Working out the variance
6. Track it down before you adjust
7. Adjust, then fix the cause

Every inventory count compares two numbers: what your records say should be on hand and what is actually on the shelf. The difference is the variance, and it’s only useful if both numbers are right.

A lot of variances start on the records side. An invoice never got entered. A carton was rung up as a single pack. One flavor was scanned for another. A case of damaged product went in the dumpster without a write-off. Theft is real, but it shouldn’t be the first explanation you reach for. A count you can trust starts well before anyone picks up a clipboard.

How often to count

Not every item needs the same attention. A practical way to split the store:

• High-value, high-theft items such as cigarettes: every shift or every day. Counting at shift change ties a shortage to one shift.
• Fast movers and theft-prone categories such as energy drinks, beer and over-the-counter medicine: weekly.
• Everything else: a full count at least once a year, or as often as your accountant needs one, with cycle counts in between.

Cycle counting means counting a few sections each week on a rotation, so the whole store gets counted over time without closing down for a day. Lottery and fuel have their own counts and don’t belong in this one.

Get ready before you count

Preparation decides whether the count means anything.

1. Enter every invoice, return and credit up to the count. No pending pile.
2. Stop receiving during the count. If a delivery arrives, set it aside uncounted, with a note saying it came in after the count started.
3. Write down the time the count starts, or count right after a shift close, so you know which sales happened before and after.
4. Settle units of measure. Decide whether each item is counted by the pack or the carton, the can or the 12-pack, and match what the register sells.
5. Pull damaged and expired product and record it as a write-off before you count.
6. Print count sheets in shelf order, or set up the handheld the same way.

How to count

• Work by location: shelf by shelf, left to right, top to bottom.
• Count backstock and the sales floor separately, then add them together.
• Work in pairs where you can. One person counts and the other writes, or a second person recounts a sample of each section.
• Count blind. Don’t show counters the expected numbers. People who know what the number should be have a way of finding it.
• Mark each finished section with a sticky note or tape so nothing gets counted twice or skipped.
• Write down anything you find that isn’t on the count sheet, along with its barcode. Those are gaps in your pricebook.

Trouble spots

A few areas trip up counters again and again:

• Cigarettes. Count full cartons and loose packs separately, then convert everything to the unit the register sells. Write the conversion on the count sheet so nobody does it in their head.
• The walk-in cooler. Count the cases in the back and the product behind the doors as separate locations. Shelves loaded from behind make it easy to count the same product twice.
• Opened cases. Don’t trust the label on a case that’s been opened. Count what’s actually inside.
• Multipacks and singles. If you sell a 6-pack and single cans from the same product, count each as its own item, the way the register sees them.

Working out the variance

For each item, expected on hand is the starting count, plus what you received, minus what the register sold, plus or minus adjustments such as write-offs and returns. The variance is the counted quantity minus the expected quantity.

Here is a hypothetical count of two flavors of the same cigarette brand, in packs:

	Flavor A	Flavor B
Starting count	40	30
Received	100	60
Sold, per the register	110	75
Expected	30	15
Counted	22	23
Variance	8 short	8 over

Flavor A is 8 packs short and Flavor B is 8 packs over. Together they net to zero, so nothing left the store unpaid. Someone has been scanning Flavor B when customers buy Flavor A. If you adjust both counts and move on, you hide a cashier habit that will show up again at the next count.

Track it down before you adjust

Work through the usual causes before you assume theft.

1. Recount. Check the second location, the backstock, the display and the cooler.
2. Receiving. Make sure the invoice was entered, short ships and damaged goods were recorded, and no delivery arrived after the count started.
3. Units. A carton rung as one pack, or a 12-pack counted as one can, creates big swings.
4. Look-alikes. Flavor and size swaps show up as a matching short and over, like the table above.
5. Rings without the item. Sales rung on a department key or an open-price PLU make the item look short.
6. Unrecorded write-offs. Damaged, expired or store-use items that left without a record.
7. Theft. If the variance survives all of that, look for patterns by shift, time of day and item, and review your camera footage.

Adjust, then fix the cause

Once you’ve investigated, adjust your records to match the count and write down the reason for each adjustment. Keep a simple variance log by item and by cause.

Read the log for repeats. A cause that keeps coming back needs a change in how the store works:

• Carton and pack mix-ups: make sure the carton barcode is in the pricebook as its own item.
• Flavor swaps: retrain, and make sure every flavor scans.
• Receiving misses: tighten the back-door count.
• Department-key rings: add the missing items, and review the register’s list of barcodes it couldn’t find, if it keeps one.

Look at variances in dollars at cost as well as in units. Dollars show you which problems deserve your time first.

If you’re starting from scratch, start with cigarettes. Count them at every shift change, log each variance with its cause and fix the causes that repeat. The same habits carry over to the rest of the store.