Free monthly budget template for Excel: the 15-minute method
A monthly budget template for Excel needs five blocks and nothing more: money in, fixed bills, flexible spending, savings, and what is left. The free workbook described here has exactly those blocks on one tab, with the sums, the differences and the savings rate already calculated, and the method below is designed to fill in a first version in about fifteen minutes, with a bank statement open next to it.
What a monthly budget must show
The Consumer Financial Protection Bureau's guide "Budgeting: how to create a budget and stick with it" (published 5 June 2019, page last modified 25 June 2026, now marked as archived content) describes four steps: list every source of income, track what you spend in an average month by category, list your bills with their due dates (a month-end shortfall can come from bills and income that do not line up), then combine the three into a working budget, updated when your job or your spending changes.
A good template therefore answers three questions at a glance: how much comes in, how much is already committed before the month starts, and how much is actually left. Two more figures show whether the plan works: the gap between planned and actual, and the share of income saved.
The five blocks of the template
The Free Monthly Budget Planner is a single Excel workbook, with no macros, for Excel 2016 or later. It has three tabs: Start Here, My Month and Grocery Unit Price. The My Month tab holds the five blocks below. Mint cells are yours to type in; cream cells hold the formulas.
| Block | What goes in | What the sheet calculates |
|---|---|---|
| Money in | Take-home pay or pension, student aid, family help, side job, benefits, one line each | Total income for the month |
| Fixed bills | Rent or mortgage, utilities, insurance, phone, loan payments, subscriptions | Total fixed bills; what is left after fixed bills |
| Flexible spending | Groceries, health, kids, fun, shopping, fuel, gifts, the unexpected | Planned against actual, the difference and a status per line |
| Saving | What you move to savings or toward a goal | The savings rate: saving plus any money left over, as a share of income |
| What is left | Nothing to type | Income minus bills, spending and saving: the month's balance |
The category names are yours to change. For a structure that matches official statistics, the glossary of the Bureau of Labor Statistics Consumer Expenditure Surveys (last modified 12 December 2025) groups household spending under food, housing, apparel and services, transportation, healthcare, entertainment and other expenditures. Your own list can be shorter, as long as you keep it up.
Fill it in fifteen minutes
- Minutes 1 to 2: currency and sample data. On the My Month tab, choose $, £ or € in the currency cell (H4); it appears in every header. Then select the mint cells of the fictitious sample month and press Delete: the sample data goes, the formulas stay.
- Minutes 3 to 5: money in. Type each take-home amount on its own line. If you are paid every two weeks, IRS Publication 15-T (Federal Income Tax Withholding Methods, 2026 edition) counts 26 biweekly pay periods a year, against 24 for twice a month, so two months of the year usually bring three paychecks. The free template shows one month at a time, so type what actually arrives in that month.
- Minutes 6 to 9: fixed bills. Copy every recurring amount from last month's statement, with its due date. This is the CFPB's third step: a bill that falls before the second paycheck is still a bill for this month.
- Minutes 10 to 13: planned flexible spending. Type a planned amount per line. Do not aim for perfection; the actual column will correct you.
- Minutes 14 to 15: saving and reading. Type what you plan to move to savings, then read the three calculated figures at the bottom: what is left after fixed bills, the balance and the savings rate.
During the month, the only task is to type actual amounts, as they happen or once a week from the banking app.
Useful formulas
If you prefer to build your own sheet, these are the kinds of formulas a template like this needs. The cell references are examples: column C is planned, column D is actual; the totals below use D, and the same formulas with C give the planned figures. The workbook uses no macros and none of the functions that Excel 2016 lacks, such as XLOOKUP, LET or LAMBDA, and Google Sheets supports every function it uses.
| Figure | Formula (example cells) | Reads as |
|---|---|---|
| Total income | =SUM(D5:D9) | All money-in lines added up |
| Left after fixed bills | =D10-D20 | Income minus total fixed bills |
| Difference per line | =D25-C25 | Actual minus planned; on a spending line, positive means over plan |
| Status per line | =IF(D25="","",IF(D25>C25,"Over","OK")) | Blank until an actual amount is typed |
| Balance (in D40) | =D10-D20-D30-D35 | Income minus bills, spending and saving |
| Savings rate | =IF(D10=0,0,(D35+MAX(0,D40))/D10) | Saving plus any positive balance, as a share of income; safe on a blank month |
Keep planned and actual in separate columns rather than overwriting the plan, and never type a number into a formula cell; in the template, the color of the cell tells you which is which.
Reading the result
Take a fictitious example: income of $3,200, fixed bills of $1,950, actual flexible spending of $900 and $200 moved to savings.
- Left after fixed bills: $1,250. What the month really has to work with. If it is close to zero, the problem is in the bills, not in the groceries.
- Balance: $150. Income minus bills, spending and saving. A negative balance means the month was financed by last month, a credit card or an overdraft.
- Savings rate: 10.9%. $200 saved plus the $150 left over, divided by $3,200, as the free workbook counts it. The template sets no target; the figure is there to compare one month with the next.
The difference column does the rest: a line over plan three months running means the plan itself needs adjusting.
From month to year
A single month hides two things. The first is the annual bill: car registration, insurance paid yearly, a vacation, back-to-school costs. They belong to every month, as a twelfth, not to the month they fall in; the method is in Sinking funds: how to spread annual bills over twelve months. The second is the shape of the year: the months with three paychecks, the renewals, the season when utilities peak. Seeing it before it happens is the subject of Yearly budget planner: see the whole year before it happens.
The free workbook deliberately stops at one month: no twelve-month plan, no sinking funds, no utilities readings, no car cost, no debts. Its third tab, Grocery Unit Price, compares the price per unit between pack sizes and stores, flags the cheapest line and shows the saving on the quantity you buy; the rule behind it is in Grocery unit price comparison: the rule and a simple spreadsheet.
FAQ
Does the free template work in Google Sheets?
It is built with functions that Google Sheets also supports, so it can be imported; check the colors and any drop-down lists afterward. The file has no macros; if Excel opens it in Protected View, Enable Editing is enough.
What if my income is irregular?
Type what actually arrives in the month, line by line, and plan the flexible spending from your lowest-income recent month rather than your best one. The full planner smooths irregular income over the year; the free version keeps to the month.
What counts as a fixed bill?
Anything charged whether or not you act: rent or mortgage, insurance, loan payments, phone and internet, subscriptions. Utilities are fixed in nature but variable in amount; put the typical amount in fixed bills and correct it with the actual column. If canceling it needs a phone call or a notice period, it is a fixed bill.