Business

Comparing two quarters fairly

Setting this quarter beside the last one invites wrong conclusions unless seasons, timing and one-off items are taken into account.

Editorial illustration for Comparing two quarters fairly

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.

ItemThis quarterLast quarter
---------
Sales reported3,60,0004,20,000
One-off bulk order050,000
Sales without one-offs3,60,0003,70,000
Trading days7882
Sales per trading dayabout 4,615about 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports