📄 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

ItemPlanned per monthActual this monthDifference
INCOME
Take-home pay – person 1formula
Take-home pay – person 2formula
Take-home pay – person 3formula
Take-home pay – person 4formula
Total incomesumsumformula
COSTS
Housing
Rent or mortgageformula
Utilitiesformula
Renters or home insuranceformula
Internetformula
Housing totalsumsumformula
Food
Groceriesformula
Dining outformula
Food totalsumsumformula
Transportation
Car paymentformula
Gasformula
Car insuranceformula
Public transitformula
Transportation totalsumsumformula
Everything else
Phoneformula
Subscriptionsformula
Health careformula
Personal spendingformula
Everything else totalsumsumformula
Total costssumsumformula
Left over (total income − total costs)formulaformulaformula

Each category in the file also has three blank rows for costs of your own.

How to use the monthly budget template

  1. Download the file and open it in Excel or Numbers. In Google Sheets, choose File → Import → Upload, or open the .xlsx from Google Drive.
  2. Write take-home pay for everyone who shares costs – what lands in the account, not gross pay.
  3. At the start of the month, fill in the Planned column. Bills you pay once a year: divide by 12.
  4. Rename or leave empty any line. Use the blank rows for costs that are not listed.
  5. At the end of the month, fill in Actual. Difference shows where you were over or under the plan.
  6. Save a copy for next month and start again from your planned numbers.

A budget spreadsheet you can start using today

Updated October 27, 2026

A 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.

Questions about the free budget template

Yes, it is free, and no. The download button gives you the file directly. There is no email address to enter, no account and no sign-up.
Yes. In Google Sheets, choose File → Import → Upload and pick the file, or upload the .xlsx to Google Drive and open it with Google Sheets. The totals keep working. The same file opens in Microsoft Excel and in Apple Numbers.
Turn them into a monthly amount. Divide a yearly bill by 12 and a quarterly bill by 3, and write that in the Planned column. Setting that amount aside every month means the money is there when the bill arrives.
Use take-home pay – the amount that actually lands in your account after taxes and anything else your employer deducts. That is the money your budget has to cover.
Plan on a low month, not a good one. Look at what you have actually received in recent months and use an amount you are fairly sure of as Planned income. When a month brings in more, set the extra aside for the months that bring in less. Fill in Actual with what really came in, so Left over shows the true picture.
Yes. The template has rows for four take-home pays, and you can insert more between them so the total picks them up. It shows the household total. To work out who pays what – by income, equal shares or one person pays – use the household budget calculator.
The template is a file you keep and fill in on your own computer. The calculators on this site run in your browser, save your numbers on your device and can split costs between several people. Both are free and need no account.
Yes. The formulas add up whatever you type, so you can plan one week at a time: write weekly amounts in Planned and Actual, and rename the column headings if you like. To turn a monthly bill into a weekly amount, multiply it by 12 and divide by 52.
Yes. Open the file and print the Monthly budget sheet from Excel, Google Sheets or Numbers. With no amounts filled in, it works as a printable budget worksheet you fill in by hand – the totals then need adding up yourself.