I have started more budget spreadsheets than I have finished. There was the colour-coded one with fourteen tabs that I abandoned in week two. There was the app that wanted read access to every account I owned. There was the printable one I filled in with a pen, lost, and never rebuilt. What finally worked was embarrassingly plain: one page, three categories, ten minutes on a Sunday. The elaborate ones failed not because they were bad but because they asked more of me each month than the information was worth.

So that’s what this is. Fill in what you actually bring home, then what you plan to spend, and it shows you where your money is going as you type — including whether your plan is quietly bigger than your paycheque. Nothing is sent anywhere, there’s no signup, and nothing is stored. When you’re happy with it, download it as a spreadsheet you can open in Excel, Numbers, or Google Sheets.

Monthly Budget Planner

Enter your take-home pay, then what you plan to spend. Rename any line to match your life, or add your own. Nothing is sent anywhere — it all stays in your browser. When you’re done, download it as a spreadsheet.

$

$

Needs target 50%

Wants target 30%

Savings & extra debt target 20%

Key Takeaways

  • A budget spreadsheet works when it’s simple enough to update in ten minutes. Complexity is the main reason people abandon them.
  • Budget on your take-home pay, not your salary — the gap between the two is where most plans quietly break.
  • Three categories is enough: needs, wants, and savings plus extra debt. More categories rarely mean more control.
  • The number that matters most is the one left unassigned. Money without a job tends to vanish before month end.
  • The 50/30/20 split is a starting frame, not a rule. On a lower income, needs often exceed 50% — that’s arithmetic, not a personal failing.
  • Reviewing what actually happened matters more than planning perfectly. The second month is always more accurate than the first.

Why Most Budget Spreadsheets Get Abandoned

It’s almost never a discipline problem. It’s a maintenance problem. A spreadsheet with forty categories requires you to decide, every single time you spend money, which of forty boxes it belongs in — and that decision cost adds up until updating it feels like homework. Three weeks in, you stop. Then you feel bad about stopping, which makes opening it again worse.

The other common failure is budgeting on the wrong number. If you plan around your salary rather than what actually lands in your account, every month will feel mysteriously tight. The difference between the two is tax, insurance, and retirement contributions, and it’s often a quarter of the headline figure. If you’re not sure which number you’re working with, my guide to gross versus net income shows you exactly where to find your take-home pay on a payslip.

How to Fill It In

Start With What Actually Arrives

Use the amount that hits your account, after everything is taken out. If your income varies — freelance, commission, shifts — use the lowest month you’ve had in the past year rather than the average. A budget built on your best month is a budget that only works in your best month.

Fill In Needs From Your Statements, Not Memory

This is the step people skip, and it’s the one that makes the difference. Open last month’s bank and card statements and read the actual numbers. Almost everyone underestimates groceries and subscriptions, usually by a meaningful margin. You’re not trying to catch yourself out; you’re trying to start from something true.

Be Honest About Wants

Wants are not the enemy and this is not an exercise in eliminating them. A plan with zero room for anything enjoyable is a plan you will break by the second weekend, and then abandon out of guilt. Give the category a real number you can live with.

Treat Savings as a Bill

The section that decides whether this works is savings and extra debt. If it’s whatever happens to be left over at the end of the month, the honest answer is usually nothing. Put a number in, automate it on payday, and let the rest of the plan flex around it.

“A budget isn’t a punishment schedule. It’s just a decision made in advance, while you’re calm, instead of in the aisle at 6pm.”

What the Percentages Are Telling You

As you type, the planner shows what share of your income each category is taking, against the 50/30/20 framework. Treat those targets as a reference point rather than a verdict.

If needs are well above 50%, that is extremely common and it usually reflects housing costs rather than anything you did wrong. The useful response isn’t guilt, it’s recognising that your savings category has to come out of a smaller pool, and that the biggest lever available to you is one of the big recurring lines — rent, insurance, transport — rather than a hundred small ones. My guide to cutting monthly expenses goes hunting in the right places, and if money is genuinely tight, budgeting on a low income is written for exactly that situation without a shred of judgment.

If savings and debt is sitting near zero, that’s the number to fix first — even at $25. The habit matters more than the amount at the start.

What to Do After the First Month

Come back and compare what you planned against what actually happened. Your first month will be wrong, and that is genuinely fine — it’s a measurement, not a test. Adjust the categories that were unrealistic rather than resolving to try harder, because trying harder is not a plan and adjusting the number is.

Two things to build in once the basics hold. Give predictable irregular costs — car repairs, holidays, annual renewals — their own sinking funds, so they stop blowing up an otherwise good month. And park a starter cushion of $500 to $1,000 somewhere separate, which is what stops the next surprise from landing on a credit card. Building an emergency fund on a tight budget does it $10 at a time.

If credit card debt is one of your lines. The free credit card payoff calculator turns that balance into an actual date — and shows how much sooner you’d be free of it by adding a little to the payment.

Frequently Asked Questions

Is this budget spreadsheet really free?

Yes, and there’s no email required. Fill it in above and download it whenever you like. Nothing you type is sent anywhere or saved — it lives in your browser only, which also means it disappears if you close the tab, so download it when you’re happy with it.

What format does the download come in?

A CSV file, which opens directly in Excel, Numbers, Google Sheets, or any other spreadsheet program. From there you can format it, add your own formulas, or duplicate it for next month.

What categories should a budget spreadsheet have?

Fewer than you think. Needs, wants, and savings plus extra debt covers nearly everyone, with a handful of lines under each. The temptation is to split spending into very fine categories, but every extra category is another decision to make each time you spend, and that maintenance cost is the single biggest reason budgets get abandoned.

Should I budget on gross or net income?

Net, always. Your budget should be built on money that actually arrives in your account after tax and deductions. Budgeting on gross income builds in a shortfall of roughly 20 to 30% from the start, which is why plans built that way feel inexplicably tight every month.

What if my income changes every month?

Budget on your lowest realistic month rather than your average, and treat anything above that as a bonus with a job already assigned — topping up your emergency fund, or an extra debt payment. That way a slow month is survivable rather than a crisis, and a good month makes real progress instead of quietly disappearing.

How often should I update my budget?

Once a month is plenty for the plan itself, plus a quick five-minute check partway through to see whether anything is running away from you. Daily tracking works for some people, but it isn’t required, and treating it as required is what makes budgets feel like a second job.

The version of this you’ll still be using in six months is the boring one. Not the beautiful spreadsheet with the conditional formatting, not the app that categorises everything automatically — just a page that’s roughly right and takes ten minutes to revisit. So here’s your assignment for tonight: fill in the income box and the needs section using last month’s actual statements, and stop there. Don’t optimise anything, don’t feel bad about any number you see. Just get something true on the page. The rest gets easier once the truth is visible, and I’m here for every step of it.

The Paystream shares information and frameworks to help you make your own decisions; it isn’t personalized financial, legal, or tax advice. For guidance specific to your situation — especially if your payments feel unmanageable — consider speaking with a nonprofit credit counselor or a qualified professional.