📄 Free budget template – a monthly budget spreadsheet
A blank monthly budget with a column for what you plan and a column for what really happened. Income, costs by category and what is left over add up on their own – you only type your own numbers. There are no amounts filled in. Use it as a monthly budget template, a weekly budget template or a printable budget worksheet – and it works as a budget template in Google Sheets too.
- ✓ No email address, no account, no sign-up
- ✓ Opens in Microsoft Excel, Google Sheets and Apple Numbers
- ✓ Excel file, about 14 KB
What's inside the budget spreadsheet
Sheet 1: Monthly budget
- Income: take-home pay for up to four people
- Costs in four categories: Housing, Food, Transportation and Everything else
- Common costs listed by name, plus blank rows for your own
- Columns: Planned per month, Actual this month, Difference
Formulas already in place
- Total income and a total for each category
- Total costs
- Left over = total income − total costs
- Difference = actual − planned, on every line
Sheet 2, How to use, has the short version of the steps below, so the file explains itself when you open it again next month.
Preview of the Monthly budget sheet
| Item | Planned per month | Actual this month | Difference |
|---|---|---|---|
| INCOME | |||
| Take-home pay – person 1 | formula | ||
| Take-home pay – person 2 | formula | ||
| Take-home pay – person 3 | formula | ||
| Take-home pay – person 4 | formula | ||
| Total income | sum | sum | formula |
| COSTS | |||
| Housing | |||
| Rent or mortgage | formula | ||
| Utilities | formula | ||
| Renters or home insurance | formula | ||
| Internet | formula | ||
| Housing total | sum | sum | formula |
| Food | |||
| Groceries | formula | ||
| Dining out | formula | ||
| Food total | sum | sum | formula |
| Transportation | |||
| Car payment | formula | ||
| Gas | formula | ||
| Car insurance | formula | ||
| Public transit | formula | ||
| Transportation total | sum | sum | formula |
| Everything else | |||
| Phone | formula | ||
| Subscriptions | formula | ||
| Health care | formula | ||
| Personal spending | formula | ||
| Everything else total | sum | sum | formula |
| Total costs | sum | sum | formula |
| Left over (total income − total costs) | formula | formula | formula |
Each category in the file also has three blank rows for costs of your own.
How to use the monthly budget template
- Download the file and open it in Excel or Numbers. In Google Sheets, choose File → Import → Upload, or open the .xlsx from Google Drive.
- Write take-home pay for everyone who shares costs – what lands in the account, not gross pay.
- At the start of the month, fill in the Planned column. Bills you pay once a year: divide by 12.
- Rename or leave empty any line. Use the blank rows for costs that are not listed.
- At the end of the month, fill in Actual. Difference shows where you were over or under the plan.
- Save a copy for next month and start again from your planned numbers.
Prefer to fill it in online?
The same budget runs in your browser, with nothing to download. Your numbers are saved on your device and never sent to a server.
A budget spreadsheet you can start using today
Updated October 27, 2026A budget does not need to be complicated to work. What helps most is seeing, on one page, what comes in, what goes out and what is left – and then checking at the end of the month how close the plan came. This free budget template is built for exactly that: one row per income, one row per cost, and the math already done.
What a household spends depends on where you live, how many you are and how you live, so the template has no averages or sample amounts in it. The cost names are a checklist of things most households pay for. Keep the ones that fit, rename the rest.
Planned vs actual
The Planned column is your plan for the month. The Actual column is what really happened. The Difference column shows, line by line, where the month went differently – that is where next month's plan gets better.
One household, one or several incomes
The template works for one person and for everyone who shares a home – roommates, a parent and a grown child, or any other mix. Each take-home pay gets its own row, and the total is the household's.
Budget categories list
- 🏠 Housing – rent or mortgage, utilities, renters or home insurance, internet
- 🛒 Food – groceries, dining out
- 🚗 Transportation – car payment, gas, car insurance, public transit
- 📦 Everything else – phone, subscriptions, health care, personal spending
Missing a category? Common additions are savings, debt payments, child care, pets and gifts – use the blank rows or rename one.
Excel, Google Sheets or printed
It is one .xlsx file: a budget template for Excel that also opens in Google Sheets and Apple Numbers, with the formulas intact. Prefer paper? Print the Monthly budget sheet and use it as a budget worksheet. Prefer to plan by the week? Use weekly amounts – the totals work the same way.