Money tips

Use last year's spending to set a realistic budget this year

Use last year's expenses to make a budget: total by category, remove one-offs, add known changes, divide by twelve and add a cushion. Worked example.

Editorial illustration for Use last year's spending to set a realistic budget this year

To use last year's expenses to make a budget, total each category for the last twelve months, remove genuine one-offs, add changes you already know are coming, divide by twelve and add a small cushion. You end up with a monthly plan based on what really happened instead of what you hoped would happen.

Step by step

Most of the work is in the first two steps. If your records are spread across a salary account and a card, bring both together first, otherwise the totals are low and the budget will be too tight to follow.

  1. Pull twelve months of transactions, for example April to March if you think in financial years.
  2. Total each category for the year.
  3. Remove one-offs: things you do not expect to repeat, such as a phone purchase or a one-time medical bill.
  4. Add known changes: a new commute, a higher plan, a school fee increase, a loan that ends.
  5. Divide each category by twelve for a monthly figure.
  6. Add a cushion, which is a percentage you choose, to the total.

A worked example

The numbers below are hypothetical, chosen to show the arithmetic.

CategoryLast yearOne-offs removedKnown changePlan for the yearPer month
Groceries₹1,08,000₹0₹0₹1,08,000₹9,000
Transport₹36,000₹0+₹18,000 (new commute)₹54,000₹4,500
Utilities and phone₹30,000₹0+₹2,400 (₹200 a month more)₹32,400₹2,700
Eating out₹30,000₹0₹0₹30,000₹2,500
Shopping₹54,000-₹18,000 (one phone)₹0₹36,000₹3,000
Medical₹12,000-₹6,000 (one procedure)₹0₹6,000₹500
Total₹2,70,000-₹24,000+₹20,400₹2,66,400₹22,200

Check the monthly column: 9,000 plus 4,500 plus 2,700 plus 2,500 plus 3,000 plus 500 is 22,200, and 22,200 times 12 is 2,66,400. If you add a cushion of 10 percent, that is ₹2,220, and the monthly plan becomes ₹24,420. The 10 percent is only an example; pick a figure that matches how much your months vary.

Which one-offs should I remove?

Be strict. Remove an item only if you are confident it will not repeat in a similar size. A phone bought once is a clear one-off. Festival shopping is not, because it comes every year, even if the amount changes. If you are unsure, keep half of it. A medical cost is a hard call, so look at whether a similar bill appeared in the previous year too.

What about irregular costs and annual bills?

A simple check helps: after the plan is built, compare its yearly total with your total income for the year. If the plan already uses all of it, there is no room for savings, and you will want to revisit the flexible categories before the year begins, not in November.

Annual premiums, school fees and vehicle service charges inflate one month and distort the average, which is why dividing the year by twelve is helpful. Give each its own line or its own fund, so that the monthly plan includes a slice of it every month and no month is a shock.

When should I revisit the plan?

  • After the first three months, compare actuals with the plan and adjust any category that is off by a lot.
  • Whenever income, rent or a loan changes.
  • At the start of the new financial year, when a full twelve months is available again.

A tracker that holds twelve months of categorised data makes the first step quick. SpendixAI offers ready-made reports and a Report builder with CSV download, and Pro includes budgets, so the monthly figures can become budget lines once you decide on them.

Before you finish

  • Does the plan total less than your usual take-home pay?
  • Is there a line for savings or set-asides, so it is not left to chance?
  • Have you written down the assumptions, so next year's review starts easily?
SPENDIXAI JOURNAL

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

Explore your reports