Softwiro
Free Excel template

Monthly Household Budget Template for Excel

A free Excel household budget for a family, a couple or one person running a home. You set a planned amount for every income and expense line, then log each pay day and payment as it happens. The sheet fills in the actual column for the month, shows which lines are over plan or short, splits your money between needs, wants and savings, tracks your savings goals and adds up the whole year. It opens in Excel, LibreOffice and Google Sheets, and it works in any currency.

Excel file (.xlsx) · 159 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Month shown46327Change the month, the currency and the target split on the Settings sheet.
Income this month7,150.00
Planned income7,300.00
Spent and saved this month4,952.50
Left over2,197.50
Savings rate0.0%
Expense groupPlannedActualLeft (+) / over (-)
Housing1,925.001,925.000.00
Utilities360.00378.64-18.64
Food1,110.00567.15542.85
Transport690.00583.15106.85
Health290.00305.60-15.60
Family690.00720.00-30.00
Fun and personal395.00272.96122.04
Debt200.00200.000.00
Savings1,000.000.001,000.00
Lines with no group0.00-0.000.00
Total6,660.004,952.501,707.50

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: Income, spending and savings for the month you are reviewing, what is left over and your savings rate, planned vs actual for each expense group, the needs / wants / savings split against your targets, a twelve-month table, and four charts.
  • Budget: Your plan: every income and expense line with its group, bucket (Needs, Wants or Savings) and planned monthly amount. Next to each line the sheet shows the actual for the month, the difference and a status (On plan, Short, Behind, Within plan, Over plan). Room for 40 lines.
  • Transactions: The log you type into: date, description, the budget line from a dropdown and the amount. The sheet looks up whether it is income or spending, its bucket and its group. A Check column flags a missing amount, date or line. Room for 2,000 rows.
  • Year: Income, needs, wants, savings, total spent and saved, left over and savings rate for each of the twelve months, plus the year total and a running total of what you have saved.
  • Goals: Up to ten savings goals with target, saved so far and a monthly amount. It shows what is still to save, the progress, how many months to go and the month you reach the target.
  • Settings: Household name, currency symbol, any date in the month to review, your target split for needs, wants and savings, and your list of expense groups.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

A budget only helps if you can see how the month is going against it. Most free household budget templates ask you to type the actual figure into every line at the end of the month. Here you log payments as they happen, and the planned vs actual comparison, the savings rate and the yearly view update on their own. The sample is a family budget with entries for October and November 2026, so you can see every sheet working before you replace it with your own.

How do I make a monthly household budget in Excel?

Start with income, then expenses. List every source of money you expect in a normal month and the amount of each, then list every expense line with the amount you plan: rent or mortgage, utilities, groceries, transport, insurance, childcare, debt payments and so on. Put your savings in as lines too, so the money you set aside is planned rather than whatever is left.

Check the plan before you start. In the sample, planned income is 7,300.00 and planned spending and saving is 6,660.00, so the plan leaves 640.00 unallocated. If that number is negative, the plan spends more than you earn and needs trimming before the month begins.

What is the 50/30/20 budget and how do I use it here?

The 50/30/20 rule is a simple guide: roughly half of your income to needs, a third to wants and a fifth to savings. Each line on the Budget sheet has a bucket, and the Dashboard shows what share of income went to each one next to your target. You can change the targets on Settings if 50/30/20 does not suit you.

In the sample, November income so far is 7,150.00. Needs came to 4,416.44, which is 61.8% of income, wants to 536.06, and nothing has been moved to savings yet because the transfers happen mid-month. That is the kind of picture the split is for: it shows the needs share is above the target, and it shows savings still to come.

How do I compare planned and actual spending?

Give each payment the budget line it belongs to, and the sheet adds up the month for you. Each line shows its difference from plan, and the Dashboard rolls that up by group. In the sample, electricity is 151.20 against a plan of 140.00 and clothing is 189.99 against 120.00, so both read Over plan, while groceries are at 424.05 of 850.00 halfway through the month.

Look at the lines that are over, then decide whether the plan was too low or the spending too high. If a line is over every month, change the plan to match reality and take the difference from another line. For a look further ahead, see the cash flow forecast, and for spending only, the expense tracker.

How to use it

  1. On Settings type the household name, your currency symbol, any date in the month to review, and your target split between needs, wants and savings (50/30/20 in the sample).
  2. On Budget list your income lines and your expense lines. For each give the group, whether it is a Need, a Want or Savings, and the amount you plan for a normal month.
  3. On Transactions add every payment and every pay day: date, description, the budget line from the dropdown, and the amount. Always type amounts as positive numbers.
  4. Budget fills in the Actual column for the month you are reviewing and shows whether each line is within plan, over plan, short or behind.
  5. The Dashboard shows income, spending, savings and what is left over, planned vs actual by group, the needs / wants / savings split and the last twelve months.
  6. Use Goals to track what you are saving for: how much is saved, how much is left, and in which month you reach the target at your monthly amount.

Before you start:

  • Capacity: 40 budget lines, 12 expense groups, 2,000 transactions and 10 savings goals.
  • The date on Settings decides the month shown on Budget and Dashboard and the year shown on Year. Change it to review another month.
  • Type every amount as a positive number. Whether it counts as income or spending comes from the Kind of the budget line it is filed under.
  • Savings are budget lines too: file transfers to savings under a line whose bucket is Savings, and they count as saved, not as spending.
  • Give each budget line a different name, because transactions find their line by name. A transaction whose line is not on Budget shows "Unknown item" in the Check column.
  • Use one currency in one workbook. The currency symbol on Settings is only a label.

Excel file (.xlsx) · 159 KB · 8 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet needs you to open it and type in every expense. In MyAccBot you send a photo of the receipt or a voice message on Telegram, and it handles the rest.

In this sheetIn MyAccBot
You open the sheet and type in every expense by hand.You send a photo of the receipt, a line of text or a voice message on Telegram, and the data is extracted and classified as income or expense.
You find out about a budget overrun at the end of the month.You set a monthly spending limit and get an alert at 80% and at 100%.
Summing up the month takes hours.An Arabic PDF report on the first of every month, plus a formatted XLSX file you hand to your accountant.
You dig through old receipts looking for an amount.You ask the bot for the total of a month, between two dates, or for a particular supplier, and it answers from your data.

See MyAccBot · Ask for a demo

Frequently asked questions

Is this household budget template really free?

Yes. Download it, use it for your home and change anything you like. There is nothing to sign up for to open the file.

Does it work in Google Sheets and LibreOffice?

Yes. It uses only ordinary formulas such as SUMIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

How many budget lines and transactions can it hold?

40 budget lines, 12 expense groups, 2,000 transactions and 10 savings goals. When the transaction log is full, save a copy and start a new one for the next year.

Do I enter savings as income or as spending?

As a budget line with the bucket Savings, and the transfer as a transaction on that line. It counts as saved on the Dashboard and the Year sheet, and it is included in the total of spent and saved, so the left-over figure is what is not yet allocated.

Why does a transaction say Unknown item?

Its budget line is not on the Budget sheet, usually because of a spelling difference or a line that was renamed. Pick the line from the dropdown. Until then the amount counts in the month's totals but not under any budget line.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Personal finance

More free templates

All templates · Free tools