How to compare sales across periods without messy spreadsheets

“The month is going well.” “It’s been quiet lately.” “Sales are picking up.” Every store owner makes these calls — and most of the time they rest on memory and the mood of the moment. The trouble is that memory is a terrible baseline: it keeps the exceptional days and quietly deletes the ordinary ones.

Comparing periods properly isn’t advanced analytics — it’s three simple rules and a few minutes a week. Here’s how to make comparisons that actually mean something, and the traps that quietly distort them.

Rule #1: compare like with like

A Saturday doesn’t compare to a Tuesday. A week with a holiday doesn’t compare to a normal week. December doesn’t compare to November. The golden rule: compare each period to the one that resembles it most — the same week last month, the same month last year, Saturday against Saturday.

For a store with regular customers, the most telling everyday comparison is week over week, weekday by weekday. For seasonal decisions — hiring, special orders, opening hours — last year is the better mirror.

Rule #2: look at three levels, not one

The sales total can hold steady while everything underneath it shifts. A useful comparison goes down three levels:

• The period total: the big picture, to place the overall trend.
• Transaction count and average basket: fewer customers spending more? More customers spending less? The two situations call for different responses.
• The products: which items explain the rise or the drop? A dip caused by two out-of-stock products is a completely different story from a dip spread across the whole store.

Rule #3: separate trends from accidents

One down week isn’t a trend — it’s a data point. Weather, a school break, roadwork out front can easily dent or inflate a week. Before reacting, ask: do I see the same direction across three or four periods in a row? A real trend survives several comparisons; an accident vanishes by the next one.

This is also the best protection against panic decisions: cutting prices or staff hours because one week felt soft is reacting to noise. Good decisions respond to confirmed trends.

So what about the famous spreadsheet?

Plenty of merchants end up exporting sales into a spreadsheet to do these comparisons: a column per week, percentage formulas, copy-paste every Monday. It works — until the routine breaks. One busy Monday, one shifted formula, one lost file, and three months of tracking end right there.

If you stay on a spreadsheet, keep it minimal: one row per week with the total, the transaction count, and your five key products. That’s enough to apply all three rules. If updating it becomes a chore that skips every other week, that’s the signal a tool that prepares these comparisons automatically will pay you back in time — and in consistency.

One last dead-simple tool: a logbook. Write one line for each event that affects your sales — storm, festival, roadwork, promotion, broken cooler. Three months from now, when a strange number pops out of a comparison, that log turns a mystery into a ten-second explanation. It’s the memory the spreadsheet doesn’t have.

The takeaway

Comparing periods is what turns register numbers into decisions: adjusting hours, reordering the right products, responding to a competitor. Compare like with like, go down to the products, demand confirmation across several periods — and distrust impressions, especially your own. The best surprises in sales data are the ones you catch before anyone else does.