Why comparison can mislead
A business sees sales of 3,60,000 in the quarter just ended, against 4,20,000 in the previous one. A fall of 14 percent sounds alarming. But what if the earlier quarter contained a festival, a large one-off order and a number of days more than the current one? The numbers are not comparable without adjustment.
Fair comparison means asking what was different between the periods apart from performance.
Compare like with like
Start with the same period a year earlier. A quarter of the same season is a better benchmark than the quarter just before it. If the business is new and has no history, compare with the previous quarter but adjust for known effects.
Next, check the number of working days, public holidays, and any closures. A quarter with ten fewer trading days will have lower sales, even if each day was as good.
Strip out one-offs
Identify unusual items: a bulk order, a refund of a large sale, a one-time purchase, a repair, an insurance recovery. Show the figures with and without these items.
| Item | This quarter | Last quarter |
|---|---|---|
| --- | --- | --- |
| Sales reported | 3,60,000 | 4,20,000 |
| One-off bulk order | 0 | 50,000 |
| Sales without one-offs | 3,60,000 | 3,70,000 |
| Trading days | 78 | 82 |
| Sales per trading day | about 4,615 | about 4,512 |
After adjustment, the apparent decline becomes a small improvement. The business is doing better than the headline suggests.
Look at costs the same way
Compare costs per unit of sales, not just totals. If costs fall in line with sales, margins are stable. If costs stay the same while sales fall, margins are being squeezed. Check also for timing differences, such as an annual insurance payment that fell in one quarter and not the other.
Use ratios
A few ratios help comparison across periods of different length or size: gross margin as a share of sales, wage cost as a share of sales, rent as a share of sales, and cash buffer in months. Watching these over several quarters shows trends that totals hide.
Write down what changed
Add a note for each major difference: a new product, a price change, a lost customer, a new hire. When the figures are looked at later, the notes explain them.
In SpendixAI, reports by date range make it easy to set two quarters side by side. Keep notes in the same place, and review them before making decisions on pricing, hiring or stock.
Seasonal businesses and the fair comparison
For businesses with strong seasons, quarter-on-quarter comparisons rarely mean much. Year-on-year comparisons for the same season, or rolling twelve-month totals, give a better view. A rolling twelve-month figure smooths out the season, and its direction shows whether the business is growing, flat or shrinking.
Track the rolling figures for sales, margin and costs on one page. A glance each quarter tells whether the underlying trend is healthy, regardless of the season that just ended.
Reading the gap between the headline and the adjusted figures
The distance between the reported change and the adjusted change is itself informative. When the two are close, the quarter was ordinary and the headline can be trusted. When they differ widely, the business leans heavily on unusual events, and planning should not assume they will repeat. A business that depends on one big order every few quarters needs a different buffer from one earning steadily week by week. Writing the adjusted comparison in the monthly notes keeps both truths in view and prevents either panic or complacency.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
