Budgeting

Your normal month: lowest, typical and highest spend

Find your normal monthly spending range from twelve months: lowest, median and highest spend, then set a budget at the typical figure and a buffer for heavy months.

Editorial illustration for Your normal month: lowest, typical and highest spend

Your normal month is a range, not one number. Take twelve months of total spending and find the lowest, the median (the middle value) and the highest. Set your budget near the median and keep a separate buffer for the heavy months, instead of budgeting on a single month that may have been unusually quiet or unusually expensive.

Twelve hypothetical months

Here is a made-up year, April to March, of total monthly spending.

MonthSpendingMonthSpending
April₹46,000October₹71,000
May₹44,000November₹55,000
June₹48,000December₹62,000
July₹47,000January₹49,000
August₹52,000February₹45,000
September₹50,000March₹53,000

The year adds up to ₹6,22,000, so the average is about ₹51,833. October at ₹71,000 is the festival month and May at ₹44,000 is the quietest.

How do you find the minimum, median and maximum?

Sort the twelve values: 44, 45, 46, 47, 48, 49, 50, 52, 53, 55, 62, 71 (in thousands). The lowest is ₹44,000 and the highest is ₹71,000. With an even number of months, the median is the average of the 6th and 7th values: (49,000 + 50,000) ÷ 2 = ₹49,500.

  • Lowest: ₹44,000, what the year looks like when little goes wrong.
  • Median: ₹49,500, what a typical month looks like.
  • Highest: ₹71,000, the month your plan must survive.
  • Middle half of months: about ₹46,750 to ₹53,500 (the 25th and 75th percentiles).

Why use the median and not the average?

One festival or wedding month drags the average upwards. The median ignores how extreme the high months were and tells you what an ordinary month costs. Here the average is about ₹2,333 above the median because of a few heavy months.

How do you set a budget from the range?

Budget at the typical figure, ₹49,500, and handle the heavy months with a buffer. The year's spending above the median in six months comes to 2,500 + 500 + 21,500 + 5,500 + 12,500 + 3,500 = ₹46,000. The six lighter months fell below it by 3,500 + 5,500 + 1,500 + 2,500 + 500 + 4,500 = ₹18,000. The net extra is ₹28,000 over the year, which is ₹2,333 a month. So put ₹49,500 into the budget and ₹2,333 a month into a pot for the heavy months, and the year works out.

What about the highest month on its own?

The gap between the highest and the typical month is 71,000 − 49,500 = ₹21,500. That is the most a single heavy month has pushed you above normal, so it is a sensible size for a one-time cushion in your account when a month like October begins.

Doing it in a sheet

Put the twelve totals in B2:B13. These work in Excel and Google Sheets.

  • Lowest: =MIN(B2:B13)
  • Typical: =MEDIAN(B2:B13)
  • Highest: =MAX(B2:B13)
  • Middle half: =QUARTILE(B2:B13,1) and =QUARTILE(B2:B13,3)

What if you only have three months of data?

Start anyway, but hold the results loosely. Say the last three months were ₹48,000, ₹51,000 and ₹46,000. The median is ₹48,000, the lowest ₹46,000 and the highest ₹51,000, but no festival or annual bill has appeared yet, so the range is probably too narrow. Keep adding months, and flag the ones where a known yearly expense is still to come.

Next steps

  1. Collect twelve months, even if some are estimates from statements.
  2. Work out the three figures and write them on one line.
  3. Set the monthly budget at the median and decide how large the buffer pot should be.
  4. Revisit after a year, or after a large change such as a new rent or a child starting school.

Spending totals by month are simple to pull out if you import statements into SpendixAI and use the overview and reports to read each month, though the choice of median and buffer remains your own.

SPENDIXAI JOURNAL

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

Explore your reports