If opening your banking app makes your stomach tighten a little, you are in good company. Most of us were never taught how money works — we picked up habits from parents, adverts, and sheer luck, and then felt quietly ashamed that it never quite added up. Learning how to make a budget spreadsheet changes that feeling faster than you’d expect. Twenty minutes, zero cost, and suddenly the mystery of “where did it all go?” starts to lift. Not with jargon. Not with an app demanding a monthly subscription. Just a plain table that belongs to you.
Why a plain spreadsheet beats a shiny budgeting app
Budgeting apps look like the answer: they connect to your bank, sort spending into neat charts, and send cheerful notifications. For a week or two it feels like magic. Then the trial ends, and the app becomes one more icon you avoid tapping.
A spreadsheet asks something different of you: ten honest minutes with your own numbers. Typing out what you spent is slower than an automatic import, and that slowness is the whole point. When your fingers type “takeaway — £14”, your brain actually registers it. No algorithm is doing the noticing for you.
There are practical wins too. A spreadsheet costs nothing and shares your data with nobody. It never redesigns its interface overnight or locks last year’s history behind a paywall. If a column stops being useful, you delete it. If you want a category called “midweek treats”, you make one. Nobody’s product team gets a vote — and nobody is quietly selling you credit cards in the sidebar.
Set up your table with four friendly columns
Forget the forty-column templates people share online. Your first sheet needs exactly four columns, and boring is a feature here:
Date — the day the money moved. This lets you see patterns by week and month later.
Description — a few plain words: “weekly shop”, “bus pass”, “birthday gift for Sam”. Write it the way you’d say it out loud.
Category — the bucket it belongs to: food, transport, home, fun, and so on. Keep this list short. Five to eight categories is plenty to start.
Amount — the number, with a minus sign if your sheet wants one for spending. Pick one convention and stick with it.
That is the whole machine. Date, description, category, amount. Every habit in this article is just a way of keeping those four columns alive and honest.
Use the tool you already have: Google Sheets or Excel
Do not download anything new. If you have a Google account, you have Google Sheets, free, in your browser, saved automatically. If you have Microsoft Office, you have Excel, and it does everything in this article just as well. Phone, laptop, tablet — whatever you reach for most.
Open a fresh sheet and type those four column titles across the top row. Congratulations: you are roughly three minutes into learning how to make a budget spreadsheet, and the hardest part is behind you.
Make your first budget deliberately small and imperfect
Here is where most beginners trip up: they try to budget their entire financial life in one sitting. Every bill, every subscription, every possible emergency. Two days later the sheet feels like homework and gets abandoned.
Start embarrassingly small. Pick this month, or even just the next two weeks. Write down your expected income at the top. Then list only your biggest, most predictable costs: rent or mortgage, food, transport, bills, and one line for fun. That is it.
Guess the amounts — honestly, guess. An honest guess beats a perfect figure you never write down. Put the numbers in a second column beside your categories, so “planned” sits next to “spent”.
Your first budget will be wrong. Food will cost more than you thought; something random will break; you’ll forget a subscription. That is not failure — that is the sheet doing its job. A budget is a draft you keep revising, not a test you pass first try. Small and wrong beats grand and abandoned.
Let one tiny formula do the heavy lifting
Spreadsheets scare people because of formulas, so let’s demystify the only one you truly need: SUM. It adds things up. That’s the entire trick.
At the bottom of your Amount column, click an empty cell and type:
=SUM(D2:D31)
(Swap D for your Amount column’s letter, and stretch the numbers to cover your rows.) Hit enter — the sheet totals everything above it. In plain words, that formula says: “add up every number between row 2 and row 31.” No calculator needed.
One more: put your income in B2, total spending in B3, and type =B2-B3 in B4. That shows what’s left — breathing room or overspend, in plain sight. Two formulas, and you have a working budget. Everything else is decoration you can learn later, when you feel like it.
Give yourself a 10-minute money date each week
A budget only works if you look at it, and “looking at it” sounds dull, so give it a better name. Once a week — Sunday evening with tea, Friday lunch break, whenever suits you — open the sheet for ten minutes. Set a timer if you like.
Each money date has three small jobs. First, add any spending you haven’t logged yet. Second, glance at your category totals: which bucket grew fastest this week? Third, notice anything odd — a double charge, a forgotten subscription, a week where takeaway quietly tripled.
That’s the whole meeting: you’re staying in touch with your finances, not solving them in ten minutes. Miss a week? No drama. Open the sheet, catch up, carry on. The people who succeed at budgeting aren’t the disciplined ones — they’re the ones who keep coming back after they drift off.
Irregular income? Budget from what already landed
Freelancers, shift workers, and anyone paid by the gig know the headache: money arrives in lumps, late, or not at all. Standard monthly budgets assume a tidy salary, so let’s flip the approach.
Rule one: only budget money that is already in your account. Not invoiced, not promised, not “should clear Tuesday”. Count what’s there, plan from that. It means you never spend a paycheque that never arrives.
Rule two: pay in order of survival. Essentials first — roof, food, transport to work. Then a little toward savings. Then fun money. When a good month lands, the surplus goes to savings or the lean weeks ahead.
Rule three: build one “lean month” budget and keep it saved. Work out the cheapest month you could survive — bare essentials, nothing extra. On thin months, switch to it without a second thought. Having that fallback written down turns a scary quiet spell into a plan you’ve already made.
So you blew the budget. Now what?
It will happen. A birthday weekend, a sale, a bad day that ended with a shopping basket. The old instinct is to slam the spreadsheet shut and pretend the month never happened. Don’t. The sheet can take it.
Log the spending anyway. Overspending you can see is just information; overspending you hide from yourself is a habit. Then ask one calm question: what did that money actually buy? Sometimes the answer is “a genuinely lovely evening with friends” — and that’s a fine use of money, even if it broke the plan. Sometimes the answer is “stuff I don’t remember ordering” — and now you know something useful.
Then adjust the number, not your self-worth. If fun money keeps running out by week three, the budget was wrong, not you. Raise the fun line, trim somewhere painless, and try again. One rough week doesn’t erase three steady ones. The only real way to fail is to stop looking.
The little things beginners usually wonder about
What if I’m terrible with numbers? Then you’re the perfect candidate. This whole system uses one formula that adds things up. If you can read a receipt, you can run this budget.
Do I have to track every single coffee? For the first month, yes — that’s how you learn where money actually goes. After that, small regular treats can share one “daily treats” line. The goal is awareness, not surveillance.
How do I log cash spending? The honest way: poorly, at first. Keep receipts in a pocket or snap a photo, then type them in during your weekly money date. Cash is where budgets leak, so even rough cash notes beat none.
Should my partner and I share one sheet? One shared sheet with a “who” note in the description column works beautifully — “weekly shop — Priya”, “car fuel — Dev”. Money arguments shrink when both people can see the same calm numbers.
How long until this feels normal? About six to eight weeks of those little money dates. After that, most people say checking the sheet feels less like a chore and more like checking the weather — just something you do.
Give your money a simple map — starting tonight
Let’s hold all seven habits in your head at once: skip the app, build four plain columns, use the tool you already own, start small and let it be wrong, learn SUM, keep a ten-minute money date, and budget only what’s landed.
None of this requires talent, willpower, or a finance degree. It asks for a blank sheet, twenty honest minutes, and the willingness to look. The fog around your money isn’t permanent — it’s just what happens when nobody writes anything down.
So tonight, open Google Sheets or Excel, type those four little column titles, and log today’s spending. That’s the whole first step. A month from now, you’ll open that sheet and see your own life in numbers — where it went, what mattered, and how much calmer it feels when you know. Your money has been waiting for a map. Draw it one row at a time.
