Skip to main content
Jay Sudha

Template

Monthly Budget Template

A monthly budget template turns a vague sense of "where did the money go" into a clear plan you can act on. This one is built for Indian households: it captures every income source, separates fixed bills from variable spending, sets aside savings and SIPs first, and shows your surplus or shortfall at a glance. Use it to give every rupee a job at the start of the month and to review what actually happened at the end.

Free · Excel / Google Sheets compatible · no signup — see what’s inside below, then download.

What it does

The template gives you one sheet to plan a month before it starts and review it after it ends. You list income at the top, then fixed expenses (rent, EMIs, SIPs, insurance), then variable expenses (groceries, fuel, eating out), and a savings line. It automatically totals each block and shows the surplus — income minus everything else — so you can see immediately whether the plan balances. A second column lets you record actuals against your plan, turning the budget into a feedback loop rather than a one-time guess.

Who it’s for

  • Salaried professionals who want to stop wondering where their pay goes.
  • Couples managing a shared household budget.
  • Anyone moving from "spend then save" to "save then spend".
  • People preparing to take on an EMI who want to test it against their budget first.

Fields included

Income sourcesSalary, freelance income, rent, interest — each on its own row.
Fixed expensesRent, EMIs, SIPs, insurance, subscriptions that recur every month.
Variable expensesGroceries, fuel, dining, shopping — categories that fluctuate.
Savings & investmentsAmount moved to savings/SIP before discretionary spending.
Planned vs actualTwo columns so you can compare your plan against reality.
Surplus / shortfallAuto-calculated: income minus all outflows.

How to use it

  1. At the start of the month, enter all expected income in the income block.
  2. List every fixed expense — rent, EMIs, SIPs, insurance premiums, subscriptions.
  3. Add a savings line and treat it as a fixed expense, not a leftover.
  4. Estimate variable expenses by category based on the last two or three months.
  5. Check the surplus line — if it is negative, cut variable categories until it balances.
  6. Through the month, record actual spending in the "actual" column.
  7. At month end, compare plan vs actual and adjust next month’s estimates.

Preview

CategoryPlanned (₹)Actual (₹)
Salary (income)85,00085,000
Rent22,00022,000
SIP / investments10,00010,000
Groceries12,00014,000
Surplus25,00023,000

Free Excel / Google Sheets template — no signup required.

Download Excel template (.xlsx)

Example workflow

Riya earns ₹85,000 a month. She enters income ₹85,000, fixed expenses of ₹38,000 (rent ₹22,000, SIP ₹10,000, insurance ₹3,000, subscriptions ₹3,000), and budgets ₹22,000 for variable categories. The surplus line shows ₹25,000. She moves ₹15,000 of it to a goal fund and keeps ₹10,000 as a buffer. Through the month she logs actual spends; at month end groceries ran ₹2,000 over, so she raises next month’s grocery estimate and trims dining out.

Frequently Asked Questions

Ready to put this to work?

Download Excel template (.xlsx)