Spreadsheets

Find seasonal spending spikes by comparing years month by month

Find your seasonal spending spikes by laying months against years in a grid, shading repeat peaks, and turning them into monthly sinking funds.

Editorial illustration for Find seasonal spending spikes by comparing years month by month

To find the months where your spending jumps every year, lay your spending out as a grid with the months down the side and the years across the top, then shade it with a colour scale. A month that glows in every column is a seasonal spike, and the extra rupees above a normal month, divided by twelve, are what you can set aside monthly as a sinking fund.

How do I build the month-by-year grid?

Because the Indian financial year runs April to March, order the rows that way. Put the numbers 1 to 12 in A2:A13, where 1 stands for April and 12 for March. Put the starting year of each financial year across B1:D1, for example 2023, 2024 and 2025. Your Data sheet has dates in A and amounts in C. Then in B2:

  • =SUMIFS(Data!$C$2:$C$3000,Data!$A$2:$A$3000,">="&DATE(B$1,3+$A2,1),Data!$A$2:$A$3000,"<"&DATE(B$1,4+$A2,1))

DATE copes with months above 12, so month 10 of the year (January) correctly lands in the next calendar year. Copy the formula across and down. For readable labels in a spare column, =TEXT(DATE(2000,3+A2,1),"mmm") turns 1 into Apr and 12 into Mar.

How do I make the spikes stand out?

  1. Select the whole grid, B2:D13.
  2. In Excel choose Home, Conditional Formatting, Color Scales. In Google Sheets choose Format, Conditional formatting, then Color scale.
  3. Pick a scale from pale to dark so that the highest value in each year is the darkest.
  4. Next to the grid add a ratio block, where each cell is the month divided by that year's average: =B2/AVERAGE(B$2:B$13). A ratio of 1.5 means the month cost half as much again as a typical month.

The ratio block matters because your spending grows over the years. A month at ₹60,000 in a year when you averaged ₹35,000 is a bigger spike than the same ₹60,000 three years later at an average of ₹50,000.

Which months usually repeat?

Look for the same month in every column. Common candidates are the festival month when gifts, clothes and sweets arrive together, the month the school or college fee falls due, the month an annual insurance premium is deducted, and the end of the financial year when people top up savings. Your own list will differ, and the grid will show it better than any guess. Diwali falls in October or November depending on the year, so if it moves across a month boundary, add the two months together before comparing.

How do I turn a spike into a sinking fund?

Say you have three years of history. Compare each spike month with a typical month, which here is a made-up ₹40,000:

Month2023-24 (₹)2024-25 (₹)2025-26 (₹)Average (₹)Above typical (₹)
Jun62,00065,00068,00065,00025,000
Oct71,00075,00080,00075,33335,333

The two spikes add up to about ₹60,333 above a normal month. Divided by twelve, that is about ₹5,028 a month. Put roughly ₹5,100 into a separate account or envelope every month and June and October stop feeling like emergencies. The calculation is =SUM of the "Above typical" cells divided by 12.

What should I do with a spike that is growing?

If a month rises every year, plan for the next one using the trend, not the average. Take the three years of one month and see whether the step between them is steady, for instance 62,000, 65,000 and 68,000, which rises by 3,000 each year. A fund based on 71,000 would then be more realistic than one based on the 65,000 average.

A short checklist

  • List your repeat months and what causes each.
  • Estimate the extra, not the whole month, because normal spending is already in the budget.
  • Divide the total extra by twelve and give that sum a name of its own.
  • Review the grid every April when the new financial year starts.

Building the grid depends on tidy categories and dates. SpendixAI can bring statements in and keep your history organised by category, so this kind of year-on-year look needs less cleaning first.

SPENDIXAI JOURNAL

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

Explore your reports