How to Learn Excel Basics from Scratch
The tool most people build their budget in — from a blank sheet to working formulas you trust.
Read the guide →Most first budgets fail for two boring reasons: they're built from memory instead of statements, and they have no category for the bills that don't arrive monthly — the car service, the dentist, the birthdays. This guide fixes both. Over five short sessions you'll pull your real numbers from three months of statements, sort them into needs, wants and irregulars, build a draft where every euro has a job, set up a buffer so irregular bills stop being emergencies, and end with a weekly check-in short enough to survive a bad week. It teaches a general budgeting structure, not personal financial advice — for decisions about debt, tax or investing, talk to a qualified adviser.
What you'll be able to do: In five short sessions, build a monthly budget from your own real numbers — not a generic template — that you'll actually keep using.
Outcome: "I have one page listing my actual income and every recurring expense, taken from statements rather than memory."
Open your banking app and write down two numbers: the total that came in last month and the total that went out. Thirty seconds, no categories yet.
A budget built from memory fails within a month, because memory reliably underestimates small frequent spending and forgets annual charges entirely. The fix is to work from the last three months of bank and card statements instead of from what you think you spend — three months rather than one, because any single month is atypical. At this stage you are only collecting: no cutting, no cancelling, no judging.
Down the left: every line item that appears in the statements — salary, rent, electricity, phone, groceries, transport, insurance, subscriptions, everything. In the middle: what it cost in each of the last three months. On the right: the monthly average, and for annual bills, the yearly figure divided by twelve. A €360 annual insurance premium becomes €30 a month on this page, even though it leaves the account once. By the end you have one number for income and a list of numbers for outgoings, all sourced from statements rather than estimates.
Outcome: "Every line on my page is labelled as a need, a want, or an irregular expense."
Take your Chapter 1 page and label just the five largest expenses N, W or I. The biggest lines decide most of the outcome, so start there.
Three labels, each with one clear test. A need is something whose absence causes a real problem within a month — housing, utilities, basic food, transport to work, insurance, minimum debt payments. A want is everything you choose, however reasonable. An irregular expense is a real cost that doesn't arrive monthly: car maintenance, dentist, birthdays, the annual insurance premium. Most failed budgets fail because irregular expenses never got a category, so they arrive looking like emergencies when they were entirely predictable.
Rent €900 → N. Electricity and water €150 → N. Groceries €300 → N, though part is arguably W. Transport €150 → N. Phone €25 → N at a basic level. Streaming services €35 → W. Eating out €180 → W. Gym €40 → W. Car service and tyres €600 a year → I, €50 a month. Dentist and medical excess €300 a year → I, €25 a month. Gifts and birthdays €480 a year → I, €40 a month. Notice what just appeared: €115 a month of entirely predictable irregular spending that never showed up in any monthly budget before.
Outcome: "I have a first-draft monthly budget built entirely from my own real numbers."
At the top of a page, write your monthly take-home income — the actual amount that lands in your account after tax, as one number. Everything else in this chapter works from that single figure, so it has to be real, not a rough guess.
A first draft budget assigns every euro of that income to one of three buckets, in this order: Needs (rent, utilities, groceries, transport — costs you can't skip), Wants (a capped amount for everything else you choose to spend on), and Buffer/savings (whatever's left). The goal isn't to spend zero on wants — it's that every euro has a job, so nothing quietly disappears.
Take-home income: €2,400. Needs come first and are listed individually: rent €900, utilities €150, groceries €300, transport €150 — totalling €1,500. Wants get one capped line, not itemised yet: €500 for eating out, subscriptions, and hobbies combined. That leaves €400. Rather than leaving it unassigned, it's split into two lines: €250 into an irregular-expenses buffer (covered in the next chapter) and €150 into savings. Every euro of the €2,400 now has a named destination.
Outcome: "I have one buffer amount and a place to keep it, so irregular bills stop being emergencies."
Take the irregular monthly total from Chapter 2 and write it on a sticky note. That single number is the whole chapter.
The buffer isn't savings and isn't an emergency fund — it's money already spoken for by bills that simply haven't arrived yet. It works because it's separated: a second account, a sub-account, or a labelled pot, so the money isn't visible in your day-to-day balance. Each month you move the irregular total into it; when the car service or the dentist arrives, you pay from the buffer and the monthly budget doesn't move at all. The distinction that makes it work: an emergency fund covers what you couldn't predict, the buffer covers what you could.
The irregular total from Chapter 2 is €115 a month, so €115 moves into a separate account on payday, automatically. In March the car needs €400 of work — the buffer holds €345, so €345 comes from the buffer and €55 from the month's spare capacity, and nothing else is disrupted. By August the balance has rebuilt to €575, which covers €300 of dental work with room to spare. December's €480 of gifts is the year's largest single hit, and it's also the one the buffer has had twelve months to prepare for. Across the whole year nothing has to go on a credit card, because nothing arrived that hadn't been counted.
Outcome: "I have a weekly routine that keeps the budget accurate without re-doing it."
Put a five-minute recurring appointment in your calendar for the same time every week — a quiet slot, not Monday morning. The appointment matters more than the method.
Budgets don't fail at the planning stage, they fail at the maintenance stage, and the fix is to make maintenance small enough to survive a bad week. Five minutes, once a week, doing three things only: compare what's actually left in the account against what should be left, trace any gap to a cause, and adjust one line if needed. What makes it sustainable is what you leave out — no categorising every transaction, no spreadsheets, no monthly overhaul. The budget gets rebuilt properly only when something real changes: a raise, a move, a new recurring bill.
It's Thursday evening, week three of the month. Expected balance at this point: roughly €400, since the buffer and fixed costs have already gone out and there's a week of groceries and spending left. Actual balance: €280. The gap is €120, and thirty seconds of scrolling finds it — two unplanned restaurant meals. Nothing is wrong with the budget; the wants line was simply overspent. The response is one decision: either stop eating out for the remaining week, or take €120 off next month's wants. Pick one, write it down, close the app. Total time: four minutes.
The complete guide — all 5 chapters, every checklist and exercise — as a clean, printable PDF. No email required.
Every guide on this site is produced with the Self-Directed Learning Framework: instead of an article that explains a topic at you, the framework turns it into a structure you work through — each chapter with one outcome, a starting action under twelve minutes, the minimum you actually need to know, a worked example, a checklist, and exercises. It starts from three questions:
Topic: Building a first monthly budget.
Outcome wanted: Have a working monthly budget, built from real numbers, that actually gets used — within five days.
Starting point: Practical but shaky — roughly knows the income, but has never tracked spending systematically.
The prompt framework behind it is public: see the C.R.A.F.T. prompt framework, including the exact prompt that generated this library.
The tool most people build their budget in — from a blank sheet to working formulas you trust.
Read the guide →Free, self-paced guides across everyday, professional and academic topics.
See all guides