Spreadsheets

Household monthly budget template for Excel (India, with formulas)

Build a three-tab household monthly budget in Excel for an Indian family: Income, Planned vs Actual with a variance column, and a Summary, with formulas.

Editorial illustration for Household monthly budget template for Excel (India, with formulas)

A household budget in Excel needs three tabs: Income, Planned vs Actual, and Summary. Income adds what comes in, the middle tab holds one row per spending category with a variance formula, and Summary shows what is left. Below is a working layout for a family with two salaries, with sample numbers you replace with your own.

What goes on the Income tab?

List every source in column A, the expected amount in column B and the amount actually received in column C. Say a couple earns as follows:

SourceExpected (₹)Received (₹)
Salary, first earner58,00058,000
Salary, second earner44,00044,000
Rent received8,0008,000
Side income4,0002,500
Total=SUM(B2:B5) = 114,000=SUM(C2:C5) = 112,500

The Total row has the formula in B6 and C6. Side income is irregular, so the difference between expected and received is a useful signal. Many households budget on the lower of the two columns to stay safe.

Put a bonus, arrears or any one-off credit on its own row with a note, rather than adding it to a regular salary line. Otherwise next month's expected figure looks wrong and the plan drifts.

How do I build Planned vs Actual with a variance?

Name the second tab Planned vs Actual. Columns: A category, B planned, C actual, D variance, E status. Use these categories to start: rent, groceries, school, car loan EMI, utilities, domestic help, fuel, health, fun. Then add formulas:

  • D2: =B2-C2. A positive number means you spent less than planned; a negative one means you went over.
  • E2: =IF(D2<0,"Over","OK").
  • Row 11 totals: =SUM(B2:B10) and =SUM(C2:C10), with D11 =B11-C11.

With the sample figures, planned spending adds up to ₹82,000: rent 20,000, groceries 14,000, school 12,000, EMI 9,000, utilities 6,500, help 5,500, fuel 5,000, health 4,000 and fun 6,000. Say the month's actuals total ₹84,300 because groceries ran to ₹15,200, utilities to ₹7,300, fuel to ₹5,800 and fun to ₹7,500, while health came in at ₹2,000. The variance in D11 is 82,000 minus 84,300, which is minus ₹2,300.

What should the Summary tab show?

Keep it to five cells in rows 2 to 6, with headings in row 1. Because the second tab's name contains spaces, Excel needs quotes around it in formulas:

Cell labelFormulaResult with sample data
Income received=Income!C6₹1,12,500
Planned spending='Planned vs Actual'!B11₹82,000
Actual spending='Planned vs Actual'!C11₹84,300
Left over=B2-B4₹28,200
Left over as a share of income=IFERROR(B5/B2,0)25.07%

Format the last cell as a percentage. Check the arithmetic: 112,500 minus 84,300 is 28,200, and 28,200 divided by 112,500 is 0.2507. Whether that left-over amount goes to savings, a goal or a loan is your decision; the sheet only shows it.

How do I handle expenses that are not monthly?

School fees, insurance premiums and festival spending land in single months, and they wreck a monthly view. Add a row called Yearly set-aside to Planned vs Actual, and plan one-twelfth of the annual total there. Say yearly costs add up to ₹60,000: that is ₹5,000 a month. When the bill comes, record it against the set-aside rather than against an ordinary month.

What do I do with the result?

  1. Look at the Over rows first. Is it a one-off or a pattern for three months?
  2. Adjust Planned for the next month; a budget that is always wrong is a bad plan, not bad behaviour.
  3. Freeze the top row and protect the formula cells so a stray edit does not change the totals.
  4. Save a fresh copy of the workbook each April for the new financial year.

Typing actuals by hand is the part most families drop. If that happens, SpendixAI takes bank and card statements as PDF, CSV or Excel, categorises them, and has budgets on Pro, so the Actual column fills itself.

SPENDIXAI JOURNAL

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

Explore your reports