Monthly Budget Template: The Structure, the Percentages and a Filled Month

Here is the template. Six blocks, each with a target share of your take-home pay, summing to exactly 100%.

Worked example

The six blocks and their targets

Percentages of take-home pay — the money that actually lands in your account

• Fixed essentials40%40%
• Variable essentials15%15%
• Sinking funds7%7%
• Discretionary13%13%
• Buffer5%5%
• Savings & extra debt20%20%

Rolled up, that is 55% essentials, 25% chosen spending, 20% future — the same top-level split as the budget categories list. Against the 50/30/20 rule that is five points moved from wants to needs: a more realistic allowance for essentials, and a tighter one for discretionary spending.

The blank template, ready to paste

Select the block, paste it into cell A1 of a new Google Sheet or Excel workbook, then run Data → Split text to columns (Sheets) or Data → Text to Columns (Excel) on the comma. The subtotal formulas are written for these exact row positions, so paste it into A1 and nothing else.

Section,Line,Planned,Actual,Difference
Income,Take-home pay — you,,,
Income,Take-home pay — partner,,,
Income,Other regular income,,,
Income,TOTAL INCOME,=SUM(C2:C4),=SUM(D2:D4),
Fixed,Rent or mortgage payment,,,
Fixed,Property tax / council tax / rates,,,
Fixed,Home or contents insurance,,,
Fixed,Electricity and gas,,,
Fixed,Water,,,
Fixed,Broadband,,,
Fixed,Mobile phones,,,
Fixed,Car payment or lease,,,
Fixed,Vehicle insurance,,,
Fixed,Health and life insurance premiums,,,
Fixed,Childcare or school fees,,,
Fixed,Debt minimum payments,,,
Fixed,Subscriptions and memberships,,,
Fixed,SUBTOTAL FIXED,=SUM(C6:C18),=SUM(D6:D18),
Variable,Groceries,,,
Variable,Fuel or transit,,,
Variable,Household and cleaning supplies,,,
Variable,Prescriptions and medical costs,,,
Variable,Pets,,,
Variable,SUBTOTAL VARIABLE,=SUM(C20:C24),=SUM(D20:D24),
Sinking,Vehicle servicing registration and inspection,,,
Sinking,Holiday or vacation fund,,,
Sinking,Christmas and birthdays,,,
Sinking,Dental and optical,,,
Sinking,Home maintenance and appliances,,,
Sinking,Annual insurance renewals,,,
Sinking,SUBTOTAL SINKING,=SUM(C26:C31),=SUM(D26:D31),
Discretionary,Restaurants and takeaway,,,
Discretionary,Coffee and work lunches,,,
Discretionary,Entertainment and hobbies,,,
Discretionary,Clothing,,,
Discretionary,Personal care,,,
Discretionary,Gifts and giving,,,
Discretionary,SUBTOTAL DISCRETIONARY,=SUM(C33:C38),=SUM(D33:D38),
Buffer,Unallocated buffer,,,
Savings,Emergency fund,,,
Savings,Retirement above any payroll deduction,,,
Savings,Named goal,,,
Savings,Extra debt payment above the minimum,,,
Savings,SUBTOTAL SAVINGS,=SUM(C41:C44),=SUM(D41:D44),
Check,TOTAL ALLOCATED,=C19+C25+C32+C39+C40+C45,=D19+D25+D32+D39+D40+D45,
Check,LEFT TO ALLOCATE,=C5-C46,=D5-D46,

Two more things and it is finished:

1. Column E. Put =D6-C6 in cell E6 and fill it down to E45. On a spending line a positive number means you went over.
2. The check row. Cell C47 should read zero once you have allocated every pound or dollar. If it reads a positive number, that money has no job yet — which is the whole idea behind zero-based budgeting. If it reads negative, the plan does not fit the income and something has to come out before the month starts, not after.

Only budget money that actually leaves your bank account. If your pension or health premium is deducted from your pay before you see it, it is already excluded from take-home pay and should not appear as a line.

Where the percentages come from

They are built backwards from what households actually spend, then tightened.

The Bureau of Labor Statistics Consumer Expenditure Survey puts average US household spending at $78,535 in 2024, and publishes how it splits. The BLS unit is a "consumer unit" rather than a household — close enough to read as one, not identical.

Where the average US household's money actually goes

Share of total annual spending, 2024

Housing

33.4%

Transportation

17.0%

Food

12.9%

Personal insurance and pensions

12.5%

Healthcare

7.9%

Entertainment

4.6%

Cash contributions

2.9%

Apparel and services

2.5%

Education

2.0%

Miscellaneous

1.6%

Source: US Bureau of Labor Statistics, Consumer Expenditure Surveys, Table B, USDL-25-1586, published 19 December 2025

One adjustment turns that into something you can budget against. "Personal insurance and pensions" is 12.5% of the total, but most of it — $6,684 of $9,797 — is compulsory Social Security deductions that never reach a bank account. Strip that block out and rescale the remaining 87.5% to 100, and here is what leaves the average US household's account:

Housing, transport, groceries and healthcare come to about 75% before a single discretionary purchase. That is why the template's 55% essentials target is a target and not a description. If your first honest pass lands at 60% or 65%, you are in normal territory — you have a housing or transport problem to work on over the next two years, not a budgeting failure this month.

The gap between the 20% savings target and reality is just as wide. On the OECD's net household saving measure — net saving as a share of net disposable income, which is not the same thing as the gross saving ratios national statistics offices publish — households saved 5.7% in the United States in 2024, 5.1% in Canada and 4.7% in the UK (OECD National Accounts at a Glance). Read that as the size of the hill, not as permission to stop climbing.

Housing is the line that changes by country

Everything else in the template travels. Housing does not, and it is the largest block, so getting the target wrong wrecks the rest. The national spending surveys will not settle it for you — they put housing at 33.4% of US spending, 32.1% of Canadian and 18% of UK, and that spread is mostly where each statistics agency files mortgage interest and property taxes. The chart below uses one measure applied the same way to every country instead.

Housing as a share of household income, on one comparable measure

Spending on housing, water, electricity, gas and other fuels as a share of net adjusted disposable income, 2023

• UKUnited Kingdom21.5%OECD National Accounts at a Glance
• CACanada19.6%OECD National Accounts at a Glance
• IEIreland18.5%OECD National Accounts at a Glance
• AUAustralia18.0%OECD National Accounts at a Glance
• USUnited States15.7%OECD National Accounts at a Glance

Four lines in the fixed block also need renaming before the template works where you live.

Healthcare is the gap that will break a copied budget. It is 7.9% of the average US household's spending, of which $4,055 of $6,197 is insurance premiums. The equivalent ONS "Health" line for UK households was £11.90 of £676.60 weekly spending — 1.8% (ONS Family Spending, FYE 2025). A US household paying premiums post-tax should move roughly four points from discretionary into fixed before starting.

A filled month

One household, US, $5,400 a month take-home — roughly the region a household on the US median income of $83,730 (Census Bureau, 2024) lands in after tax. Your figure will differ; the structure will not.

Worked example

The month, as it actually happened

$5,400 take-home, six blocks, what was left

5400

Take-home pay

−2610

Fixed essentials

−947

Variable essentials

−320

Sinking funds

−517

Discretionary

−118

Buffer used (vet bill)

−875

Savings & extra debt

13

Unspent

Read the month properly. Nothing here went to plan: energy ran $28 over, groceries $63 over, restaurants $71 over, and a $118 vet bill arrived out of nowhere. The month still balanced, for three reasons.

The buffer absorbed the vet bill and had $82 left, which covered the $40 fixed overrun and the $32 variable-block overrun with $10 to spare. Clothing came in at zero, as it does most months. And savings left on payday rather than at month end, so the overruns had nowhere to eat except the buffer.

Now check the actual against the targets: fixed came in at 48% of take-home against a 40% target, so discretionary was funded at 10% against 13% and savings at 16% against 20%. The template's job is to make that trade visible on one screen. The fix is not to try harder on restaurants next month — $71 is not where an eight-point overshoot lives. It is rent, the car payment and the insurance renewal.

On a £3,200 UK take-home the same structure gives £1,280 fixed, £480 variable, £224 sinking funds, £416 discretionary, £160 buffer and £640 savings. The proportions carry; only the labels in the fixed block change.

Sinking funds: the block most templates leave out

A sinking fund is an annual or irregular bill divided by the number of months between payments, set aside monthly, so the bill arrives against money that already exists. This is the single most common reason a budget that works in February collapses in August.

Sources, in order: TV Licensing; Consumer Council for Water; MHCLG — note the average per dwelling across all bands is lower, at £1,868; BLS Consumer Expenditure Survey and the NAIC Auto Insurance Database Report, which measures a different thing — spend per insured vehicle rather than per household — and runs three years behind.

The test is one question: does it arrive less often than monthly, and would paying it out of a single month's income hurt? If yes, divide and treat the result as fixed. Christmas is the textbook case — a December fund started in January is the difference between a good month and a January card balance.

Sinking funds behave better in a separate account or pot than as a number in a spreadsheet, which is the modern form of the envelope system. Money you can see in a current account is money you will spend.

When your income is not a fixed number

The template assumes one income figure. If yours moves, change one thing: plan on your lowest month from the last twelve, not the average.

Then add a line called income smoothing at the bottom of the savings block. In a month that beats the baseline, the excess goes there. In a month that misses, it comes back out. You are paying yourself a salary out of a buffer instead of riding the swings, and the six blocks never have to be redrawn. The irregular income guide has the full version, including how many months of smoothing to hold before you spend a good quarter.

Two people with two irregular incomes need one more rule: agree the baseline figure together before the month starts, not while looking at a shortfall. Budgeting as a couple covers the conversation.

Which format to use

Most people who last a year end up hybrid: the plan lives where they can see the whole month at once, and the tracking lives wherever it takes the fewest taps. Which format you pick matters far less than whether logging a transaction takes under ten seconds. If it takes thirty, you will stop by week three, and the reasons budgets fail are mostly friction rather than willpower.

The monthly rhythm

Using the template through the month

1. 1Before payday: build the planFill the Planned column only. Check row 47 reads zero. Ten minutes.
2. 2Payday: move the savings firstStanding orders or transfers for the savings and sinking blocks leave the same day the money arrives, before anything else.
3. 3As you spend: log itInto the Actual column, or into an app that fills it. Whichever takes fewer than ten seconds.
4. 4Weekly: five minutes on the variable blockGroceries, fuel and eating out are the only three lines that move enough in a week to be worth checking.
5. 5Month end: read the Difference columnNot to feel bad about it. To find the one line worth changing, and to reset next month's Planned figures.

The weekly check is the step people skip and the one that does the work. Once a month is too late to change anything; every day is a habit nobody keeps. The weekly budget review exists because a five-minute look on Sunday catches the grocery overrun while there is still a week left to react to it, and it is most of what separates a budget that survives the year from one that does not.

Where this template does not work

Three honest limits.

It cannot fix a negative budget. If your essentials genuinely exceed your income, the spreadsheet will tell you so and then be useless. That is not a rare position — 28% of new clients at StepChange were in a negative budget in 2025, meaning their spending exceeded their income even after going through the charity's own budgeting process, though that is down from 30% the year before (StepChange Statistics Yearbook 2025). The right next step there is free debt advice, not a better template.

Tracking is not the same as improving. A UK randomised controlled trial that gave people money-management apps found they became measurably better at keeping track of income and spending, and more resilient to an unexpected bill — but their household's overall financial situation did not improve over the six months of the trial (French, McKillop & Stewart, European Journal of Finance). It was a small sample of credit union members in one city, and the authors put the flat wellbeing result down to too short a window. Still, take the lesson: visibility is a prerequisite for change, not change itself. The template earns its keep on the month you act on the Difference column.

The percentages break above about a third of take-home on housing alone. Once rent or mortgage passes that line, no allocation of the remainder rescues the month. Keep the structure and the savings block, however small, and treat the fixed block as a two-year project.

One more thing worth knowing before you start: this is not unusual work that most people already do. Across the 39 countries and economies the OECD surveyed, only 63% of adults keep track of their money in the short term at all (OECD/INFE 2023). Filling in one column puts you in that 63% rather than the 37% who do not.

Frequently asked questions

What should a monthly budget template include?

Six blocks against take-home pay: fixed essentials, variable essentials, sinking funds for annual bills, discretionary spending, an unallocated buffer, and savings including extra debt payments. It also needs Planned, Actual and Difference columns, and a check row that reads zero when everything is allocated. A template without a sinking-fund block will fail in whichever month the insurance renews.

What percentages should I use in a monthly budget?

Start at 40% fixed essentials, 15% variable essentials, 7% sinking funds, 13% discretionary, 5% buffer and 20% savings — 55/25/20 rolled up. Adjust housing first: US households paying post-tax health premiums should move about four points from discretionary into fixed, and anyone whose rent or mortgage alone exceeds a third of take-home should expect a higher essentials share for now.

How do I make a budget template in Excel or Google Sheets?

Paste the CSV block from this page into cell A1, run Data → Split text to columns on the comma, then add =D6-C6 in E6 and fill down. The =SUM() subtotal formulas are already written for those row positions. If they land as plain text after the split, retype the four subtotal cells and they will recalculate.

What if my income changes every month?

Plan on your lowest month from the last twelve rather than the average, and add an income-smoothing line at the bottom of the savings block. Surplus months feed it, short months draw from it. That keeps the six blocks stable instead of rebuilding the template every time work is slow.

How many categories should a monthly budget have?

The blank template above has 30 spending lines across four blocks, plus a buffer and four savings lines. That is about the practical ceiling. Under eight and the budget hides the problem; well over twenty and the tagging stops happening by month three. Split a category only when you suspect it of something — pulling coffee out of "eating out" is worth it if coffee is the leak.

Where to go next

• the full budget category list — 50 lines with a target percentage for each, if six blocks is too coarse
• zero-based budgeting for beginners — the method behind the check row at the bottom of the template
• building a household budget step by step — the walkthrough if this is your first one
• budget calculator — put your take-home pay in and see the six blocks in your own currency

---

Put this into practice

A spreadsheet needs you to type every transaction into it. iBudget keeps the same six blocks with the limits already set, so the Actual column fills itself and the Difference is there when you open it.

Start budgeting free — free plan, no card required, no bank logins.