Skip to content
Kaarne Superstore⌕
AI & Digital Tools

Sales Went Up. Are You Comparing the Same Kind of Month?

Before explaining a sales increase, check period coverage, included records and measure definitions. A practical comparison exercise for small-business owners.

A bicycle-shop owner compares reporting periods with different calendar coverage.

The sales figure is higher than last month. That sounds encouraging, but the first useful question is what exactly you are comparing.

A report can contain correct arithmetic while comparing periods with different coverage, definitions or included records. Before explaining a change, make sure the two figures describe the same kind of thing.

Put the comparison in a sentence

Consider a fictional bicycle shop. Its owner compares November sales with October sales. One file contains all transactions posted by the month’s end; the other was exported several days early. The labels look comparable, but the coverage differs.

Write the comparison in plain language: which dates, which transaction status, which source and which measure? Is the number gross sales, net sales after returns or another defined amount? Are you counting orders, order lines or units?

You do not need a complicated analytical model to discover a basic mismatch. You need a definition specific enough for someone else to repeat.

Separate business change from reporting change

A category can appear to grow because the business sold more, because transactions were recategorised or because the latest export includes a new channel. Those explanations imply different decisions.

Keep a small change note beside the report. Record new sources, altered category rules and changes to the period boundary. Where a definition changed, either rebuild the earlier comparison consistently or label the limit clearly.

Avoid presenting a corrected preparation method as evidence that the underlying business suddenly improved. The correction may be valuable without supporting that conclusion.

Look at the calendar without inventing a story

Different numbers of trading days, closures or an event can be useful context. They do not automatically prove why sales changed. Add facts you actually know and distinguish them from ideas worth investigating.

For the bicycle shop, the owner might note an extra Saturday opening or a particular promotion. The next action could be to inspect the relevant category or dates, rather than attributing the whole difference to the promotion.

If a comparison is only partial, describe it as partial. A clearly labelled provisional view is more useful than a confident conclusion built on incomplete coverage.

Create a comparison card

For the next monthly report, write five lines: period covered, measure used, records included, known preparation changes and unresolved questions. Place the card beside the two figures before explaining the difference.

Then choose a few source records from each period and confirm that the same rule includes them. Check a return, a cancelled item or another boundary case relevant to your business. This is a practical consistency check, not a statistical claim about causation.

The exercise makes the report’s language more precise. Instead of “sales are up”, you can say which defined measure increased across which comparable periods, then decide what deserves a closer look.

Keep the reporting method connected

Explore the Make the Monthly Report Useful Before Making It Bigger guide and the related practical questions below.

If you want a written practice route, review the Excel Monthly Reports with Matze course overview. It requires compatible Excel Desktop for Windows with Power Query; you build the report yourself.

Check the course contents and current price. Affiliate link: Superstore may earn a commission if you buy. Check current contents, requirements and terms before purchasing.

0

Discussion 0

What did this article make you think about?

Join the conversation

Your email address will not be published. Required fields are marked *

Saved articles

Saved in this browser.