To set next year's budget from this year's actual spending, take each category's yearly total, divide by twelve for a monthly average, adjust for changes you already know about, add a monthly share of your yearly costs, and round to a cap you can remember. Starting from what you really spent is more reliable than starting from what you wish you had spent.
Step one: get a clean year of actuals
Collect twelve months of statements and categorise every debit. Remove transfers between your own accounts and credit card bill payments. If a category includes a one-off, such as a gift of ₹15,000 for a wedding, note it and remove it from the average, then budget for it separately if it will recur.
Step two: work out the averages and adjust
Divide each category's yearly total by twelve. Then change the figure only for things you know: a rent revision, a new school fee, a subscription you cancelled. Do not add a random cushion to every line.
| Category | Last year total | Monthly average | Known change | Next year's cap |
|---|---|---|---|---|
| Groceries | ₹1,08,000 | ₹9,000 | +₹500 for higher prices | ₹9,500 |
| Transport | ₹36,000 | ₹3,000 | Fewer office days, −₹500 | ₹2,500 |
| Dining and delivery | ₹48,000 | ₹4,000 | None | ₹4,000 |
| Utilities | ₹30,000 | ₹2,500 | None | ₹2,500 |
| Subscriptions | ₹14,400 | ₹1,200 | Cancelled one, −₹300 | ₹900 |
Check the averages: 108,000 ÷ 12 = 9,000; 36,000 ÷ 12 = 3,000; 48,000 ÷ 12 = 4,000; 30,000 ÷ 12 = 2,500; 14,400 ÷ 12 = 1,200. The changes are made-up and the caps round the result.
Step three: add the yearly costs as a monthly share
Insurance, vehicle paperwork, annual fees and gifts are not in the monthly averages the same way. Put them on a separate line. Say yearly insurance and renewals are ₹24,000: ₹24,000 ÷ 12 = ₹2,000 a month set aside, so the bill does not surprise you when it falls due.
How tight should the caps be?
- Fixed bills, such as rent and EMIs: exact figure.
- Regular variable spending, such as groceries: the average, perhaps rounded up.
- Wants, such as dining and shopping: slightly below the average if you want to save more.
- A small unallocated line for things you did not foresee.
What about festival and other uneven months?
Averages hide peaks. If you expect about ₹6,000 of extra spending in each of two festival months, that is ₹12,000 over the year, or ₹1,000 a month. Add that as its own line, not as a bump on groceries or shopping, so the regular caps stay realistic. Do the same for a yearly trip or a school-term month.
Avoid these common mistakes:
- Using the budget you made last year instead of what you actually spent
- Setting every cap to the old average and forgetting the yearly bills
- Leaving out cash spending, which makes every cap look easier than it is
- Changing the plan every week instead of reviewing it every quarter
How do you check it against your income?
Add the caps, the yearly-costs line and your savings target, and compare the total with your expected monthly take-home. If the budget is more than the income, cut the wants first. If it is less, decide where the leftover goes before the year starts.
Putting it into an app or sheet
In a sheet, enter the caps and compare each month's actuals with =caps-actual using SUMIFS. If you use SpendixAI Pro, you can set budgets by category and review them as each month's transactions are imported; the plan itself is still your decision.
Review dates
- Check the first month's actuals against the caps.
- Adjust after three months, not every week.
- Re-run the exercise when your income or rent changes.
- Do the full review again at year end.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


