Shopping

Sale month versus a normal month: compare category totals

Compare category totals for a sale month and a normal month side by side, with a made-up example and a short routine to explain the gap.

Editorial illustration for Sale month versus a normal month: compare category totals

Put two months side by side with one row per category, subtract the normal month from the sale month, and sort by the biggest difference. The top two or three rows usually explain most of the gap, and a short routine can then tell you whether each rise was planned, an impulse or a gift.

How do I set up the side-by-side?

Use five columns: category, normal month, sale month, difference and a note. Pick a normal month that had no festival, travel or big annual bill, otherwise the comparison itself is skewed. Take the totals from your tracker or statements rather than from memory.

Here is a made-up example with a normal August against a festive October.

CategoryNormal monthSale monthDifference
Groceries₹9,000₹9,800+₹800
Dining out₹3,200₹4,100+₹900
Shopping₹4,500₹18,700+₹14,200
Gifts₹500₹6,300+₹5,800
Travel₹2,000₹7,500+₹5,500
Bills and rent₹11,200₹11,200₹0
Total₹30,400₹57,600+₹27,200

The check is simple: 800 plus 900 plus 14,200 plus 5,800 plus 5,500 equals 27,200, and 57,600 minus 30,400 is also 27,200. If your two figures do not match, a category is missing from one side.

What does the gap tell me?

In this example, three rows (Shopping, Gifts, Travel) explain ₹25,500 of the ₹27,200 rise. Groceries and Dining out moved a little, which is normal for a festive month with visitors. Bills did not move at all, so the gap is not a sign that the household cost base has changed.

A second view helps when income or household size has changed: express each category as a share of the month's total. In the example, Shopping is ₹4,500 of ₹30,400 in the normal month, about 15 percent (4,500 divided by 30,400 is 0.148), and ₹18,700 of ₹57,600 in the sale month, about 32 percent (0.325). A category that doubles its share is worth a note even if the rupee amount looks modest.

How do I explain each big jump?

For every category that rose by more than you would expect, split the difference into three buckets and write the amounts down.

  • Planned: it was on a list or tied to a known occasion.
  • Impulse: you cannot recall deciding to buy it before you saw it.
  • Gifts and giving: spending for other people, which is not the same thing as impulse.

Say the Shopping rise of ₹14,200 splits into ₹9,000 planned (listed items) and ₹5,200 impulse. Gifts of ₹5,800 are all planned. Travel of ₹5,500 was a train booking made weeks earlier. Now the real lever is clear: ₹5,200 of impulse buying, not the whole ₹27,200.

What formulas help?

  • Difference: =C2-B2, filled down.
  • Percentage change: =IF(B2=0,"new",(C2-B2)/B2), formatted as a percentage, so a category that was nil last time does not cause an error.
  • Total gap: =SUM($D$2:$D$7), which should equal the difference of the two totals.

Where do I get the totals from?

If you import your statements into SpendixAI, you can filter each month in the Report builder, group by category and download a CSV, then paste the two sets of figures into your own sheet. A plain sheet does the same if you have been adding lines by hand.

Watch for the opposite pattern as well. A sale month can be followed by a quiet one because spending was pulled forward. If the month after a festival shows Shopping below the normal month, count the two together before deciding the festival was expensive, and note any refunds that landed in the later month.

A routine for the day after a big month

  1. Pick the normal month to compare against and write why you chose it.
  2. Fill in both columns from the statements and check the totals match.
  3. Mark the three largest differences and split each into planned, impulse and gifts.
  4. Write one change for next year, such as a smaller impulse cap or an earlier gift list.
SPENDIXAI JOURNAL

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

Explore your reports