The short version: open a blank Excel workbook, build three tabs (Income, Expenses, Summary), use SUMIF to pull totals automatically, and check it against your bank statement every single week, not once a month. The template itself takes forty minutes to build. Keeping it alive is the actual work, and that’s where most people quietly give up by week six.
I built my first proper Excel budget in 2021, when my income dropped by more than half in one year and I needed to know, to the pound, where every bit of money was going. Not roughly. Exactly. I’d used budgeting apps before that. Nice dashboards, pretty pie charts, and I never once looked at them after the first week. Excel is unglamorous and that’s exactly why it works. It makes you type in the numbers yourself, which means you see them.
Why Excel beats an app for this job
Every budgeting app I’ve tried, and I’ve tried at least six, does the same thing: it connects to your bank, pulls transactions automatically, and files them into neat little categories. Sounds brilliant. It isn’t. The categorisation is wrong at least a third of the time, the app tells you what happened rather than making you plan what should happen, and because the data appears without effort, most people stop paying attention within a month.
A spreadsheet has none of that convenience, and that’s the point. Typing in your rent, your Netflix subscription, your invoice payment from a client, one line at a time, forces a level of attention that automation quietly removes. This is the uncomfortable bit nobody selling budgeting software wants you to hear: the friction is the feature. If a tool makes budgeting effortless, it usually makes you stop looking at it.
The three tabs you need
You do not need a fifteen-tab template with macros and a dashboard that looks like a Bloomberg terminal. I’ve seen people download templates like that, get overwhelmed in ten minutes, and abandon the whole thing. Three tabs is enough.
- Income – every source of money coming in, listed by date, source, and amount.
- Expenses – every outgoing, listed by date, category, and amount.
- Summary – the tab that pulls totals from the other two and shows you the gap between what came in and what went out.
If you run a small business alongside personal finances, which most of my clients do, add a fourth tab called Business, kept completely separate from personal spending. Mixing the two is the single most common mistake I see when I help people set this up, and it makes the tax return a nightmare in January.
Setting up the Expenses tab
Six columns: Date, Category, Description, Amount, Payment method, Notes. Categories matter more than people think. Don’t use vague ones like “Miscellaneous” or “Other”, because that’s where every uncomfortable expense hides. Use specific categories: Groceries, Fuel, Software subscriptions, Client lunches, Childcare, Rent, Utilities. The more specific the category, the more useful the total becomes when you’re staring at it three months from now trying to work out why you’re short.
Setting up the Income tab
Four columns: Date, Source, Amount, Status (invoiced, paid, expected). That last column matters enormously if you’re self-employed, because “money I’ve invoiced” and “money that’s landed in my account” are not the same thing, and treating them as the same thing is how freelancers end up overdrawn in a week they thought was fine.
Building the formulas that do the work
This is the part people find intimidating and it isn’t. Four formulas will run the whole thing.
- SUM for total income and total expenses:
=SUM(Expenses!D:D)gives you a running total of every expense entered, no matter how many rows you add. - SUMIF to break spending down by category:
=SUMIF(Expenses!B:B,"Groceries",Expenses!D:D)pulls every row categorised as Groceries and adds up the amount. Copy this down for each category and you have a full breakdown without touching a calculator. - A simple subtraction on the Summary tab: Income total minus Expenses total gives you the actual number that matters, the one that tells you whether the month worked or not.
- Conditional formatting to turn that number red when it goes negative. Home tab, Conditional Formatting, “Less than 0”, fill red. This sounds trivial. It isn’t. A red cell staring at you every time you open the file changes behaviour in a way a neutral black number never does.
Set up the categories once, drag the SUMIF formulas down the column, and every month after that you’re just entering new rows, not rebuilding anything.
The month I found £400 leaking out of my own business
Here’s the actual story, because this is where the template earns its keep. In early 2022 I ran my first full month through the spreadsheet, entering every transaction as it happened rather than dumping the bank statement in at the end. When I hit the SUMIF total for “Software subscriptions” I stopped and checked it twice, because it read £412 for the month.
I had thirteen active subscriptions. Two project management tools I’d signed up to and never migrated off the first one, a stock photo library I hadn’t opened in four months, a scheduling tool that duplicated one I already paid for through a different plan, and a webinar platform I’d trialled and forgotten to cancel. None of those showed up as a problem in my bank statement, because each one on its own was small, £9 here, £29 there. The spreadsheet is what made them visible as a total, sitting in one row, impossible to ignore. I cancelled six of them that afternoon and cut the monthly figure to £187. That’s nearly £2,700 a year, found because a formula did the adding instead of my eyes skimming past thirteen small direct debits.
This is the actual argument for building the thing rather than downloading a template and glancing at it once. The value isn’t in having a budget. It’s in the totals it forces to the surface that you’d never spot line by line.
Where a budget template falls apart
I’ll say the uncomfortable bit most guides on this topic skip over: a fixed monthly budget template assumes fixed monthly income, and for a huge number of people, particularly anyone self-employed or running a one-person business, that assumption is wrong from the first row. If your income swings between £1,800 and £6,000 depending on which clients paid that month, a rigid budget built around an average will look fine on paper and then leave you short in the actual weeks that matter.
The fix isn’t a fancier template, it’s a different structure: budget against your lowest realistic month, not your average month. Take your worst three months from the past year, find the lowest one, and build fixed costs, rent, utilities, insurance, software, against that number only. Anything earned above it goes into a separate buffer tab, not straight into “spendable” money. I run my own budget this way now and it’s the single change that stopped the January-to-March stretch, always my quietest quarter, from feeling like a crisis every single year.
The 50/30/20 split, and why I adjust it
The standard rule taught in most personal finance guides is 50% needs, 30% wants, 20% savings or debt repayment. It’s a decent starting frame for employees with a fixed salary. For anyone running their own business it needs adjusting, because “savings” for a business owner also has to cover tax you haven’t paid yet, and that changes the maths considerably. I run closer to 50% needs, 20% wants, 30% held back, with a chunk of that 30% ring-fenced specifically for tax so it never even feels like available money. Set this up as its own tab with its own SUMIF pulling from a category simply called “Tax reserve”, and never spend against it mentally.
Keeping the template alive past month one
Building the spreadsheet is the easy forty minutes. What determines whether this works is a habit, not a formula, and here’s what I’ve settled on after four years of running mine:
- Enter transactions weekly, not monthly. A month of receipts entered in one sitting turns into guesswork. Fifteen minutes every Friday keeps it accurate.
- Reconcile against the actual bank balance once a week. If your spreadsheet says you should have £2,340 and the bank says £2,180, find the £160 before you move on. Don’t shrug it off.
- Review categories quarterly, not the numbers, the categories themselves. If “Client lunches” has three entries a year, merge it into something else. A category with almost nothing in it is just clutter.
If typing everything in by hand every week isn’t realistic for you, this is one of the few places where I’d recommend outsourcing the data entry rather than the strategy. A virtual assistant can enter receipts and reconcile the bank feed for a few hours a month for far less than the anxiety costs you, while you keep ownership of the categories and the decisions the numbers point to.
Where AI tools fit, and where they don’t
People ask me constantly whether AI has made the Excel budget obsolete. It hasn’t, but it has made parts of the maintenance faster. I use one of the free AI tools I cover in my roundup of free AI tools for small business to categorise a messy bank export before it goes into the spreadsheet, which saves maybe twenty minutes a month. What AI hasn’t replaced, and I don’t think it will, is the judgement of sitting with the totals and deciding what to cut. That’s a human decision every time, and building a bit of comfort with these tools generally, which I go into in my piece on foundational AI skills for business, helps more with speed than it does with the actual choices.
A cheap way to plug the gap the budget reveals
Once your spreadsheet is running for a month or two, it will almost always reveal a gap somewhere, either spending that’s higher than expected or income that’s lower than needed. If the answer for you is bringing in more revenue rather than just cutting further, don’t reach for an expensive marketing retainer straight away. I’ve written before about the cheaper marketing moves that move revenue, and most of them cost nothing but time, which is usually the more honest trade when the budget is tight in the first place.
Frequently asked questions
Do I need a fancy template, or can I build my own from scratch?
Build your own. A downloaded template with categories that don’t match your actual spending gets abandoned faster than a blank sheet you set up yourself. Three tabs, four formulas, and your own categories will outlast any template you didn’t build.
How much time does this take each month once it’s set up?
About fifteen minutes a week for entering transactions, plus another fifteen minutes at month end to check the Summary tab and adjust anything that’s drifted. Call it an hour a month total once the initial build is done.
What if my income changes every month because I’m self-employed?
Budget your fixed costs against your lowest realistic month from the past year, not your average month. Anything you earn above that baseline goes into a buffer tab rather than straight into spending money, so a quiet month doesn’t leave you short.
Should I link my bank account to the spreadsheet automatically?
You can export a CSV and paste it in, but I’d stop short of full automation. Typing or checking each entry manually is what makes you notice what’s happening to your money, and that noticing is the whole point of doing this in a spreadsheet rather than an app.
Further reading
Related reading: What Makes a Good Excel Checklist Template for Daily Tasks and What Is The Best Free Excel Template For Creating Price Quotations.
