About a year ago, I sat down on a Sunday evening and built myself an automated spending tracker. It took roughly two hours. Since then, I haven't manually logged a single transaction — and I know exactly where every pound goes each month. If you've ever wanted to track spending automatically but couldn't stick with a budgeting app, this is the approach that finally worked for me.
Why Most Spending Trackers Failed Me
I've tried everything. I've downloaded apps, carried notebooks, kept receipts in a shoebox. The problem was always the same: it required effort. Even the slickest app needs you to open it, categorise things, and care enough to keep doing that every single day.
What I actually needed was a system that worked without me. Something that captured my spending in the background and only asked for my attention when I wanted to give it — say, once a month when I fancied a review.
The solution turned out to be embarrassingly simple: bank notifications piped into a spreadsheet.
The System: Bank Notifications + Google Sheets
Here's how my automated spending tracker works, step by step. You can set this up in an evening.
Step 1: Turn on instant spending notifications.
Most modern banks let you get a push notification every time money leaves your account. I use Monzo for my day-to-day spending because the notifications are instant and include the merchant name, amount, and category. Starling does the same thing brilliantly if you prefer them.
The key is using a bank that notifies you in real time — not two days later with a vague description like "CARD PAYMENT TO POS 4829473."
Step 2: Set up an email rule.
Both Monzo and Starling can send transaction data to your email (Monzo via its export feature, Starling via email notifications). I forward all spending notifications to a dedicated Gmail address I created just for this purpose. Then I set up a Gmail filter that labels them automatically.
If email forwarding feels clunky, you can skip ahead to Step 4 for an even simpler alternative.
Step 3: Pull the data into Google Sheets.
Once a month, I export my transactions as a CSV from my banking app and drop them into a Google Sheet I built. The sheet has a few basic formulas that:
- Sort transactions by category (groceries, transport, eating out, subscriptions, etc.)
- Total up each category
- Compare this month to last month
- Highlight any category where I've spent more than £20 above my usual average
Nothing fancy. No macros, no code. Just SUMIF, VLOOKUP, and conditional formatting. The whole thing fits on two tabs.
Step 4 (the easier alternative): Use an app that does the aggregation for you.
If building a spreadsheet isn't your thing, Emma connects to your bank accounts and automatically categorises your spending. It gives you a monthly breakdown, flags subscriptions you might have forgotten about, and even spots price increases. It's genuinely useful if you want the tracking without any of the setup.
Plum is another solid option — it analyses your spending patterns and can automatically move spare money into savings. I use it alongside my spreadsheet to sweep leftover cash at the end of each week.
What I Actually Learned From Tracking Everything
The numbers were humbling. In my first month of proper tracking, I discovered:
- I was spending roughly £180 a month on eating out — nearly double what I'd guessed
- My subscriptions had crept up to about £70 a month, including two I'd completely forgotten about
- My grocery spend was actually lower than I expected, which was a nice surprise
- Transport costs were wildly inconsistent — anywhere from £40 to £120 depending on the month
None of this was obvious before I had the data in front of me. The automated spending tracker didn't just show me where my money went — it showed me where my assumptions were wrong.
The Monthly Review: 15 Minutes That Save Me Hundreds
Every first Sunday of the month, I spend about 15 minutes looking at my spreadsheet. That's it. I'm not budgeting in the traditional sense — I'm not allocating £X to each category and then feeling guilty when I overshoot. I'm just looking at the data.
Here's what my review looks like:
- Export transactions from Monzo (takes 30 seconds)
- Paste into the spreadsheet and let the formulas do their thing
- Check the highlights — anything flagged red means I've spent noticeably more than usual in that category
- Decide if I care — sometimes a spike is fine (birthday month, holiday). Sometimes it's a wake-up call
- Cancel anything I'm not using — subscriptions are the usual culprit
Since starting this, I've trimmed roughly £120 a month from my spending without feeling like I'm cutting back. Most of it was subscriptions and impulse spending I simply hadn't noticed.
Tips If You Want to Build Your Own
A few things I learned the hard way:
- Use a separate account for spending. Transfer a set amount each payday and spend from that. It makes tracking cleaner because you're only monitoring one account.
- Don't over-categorise. I started with 20+ categories and it was a nightmare. I trimmed it to eight: groceries, eating out, transport, subscriptions, household, health, entertainment, and other. That covers everything.
- Round your figures. I round everything to the nearest pound. Precision doesn't matter — patterns do.
- Review monthly, not daily. Checking daily turns tracking into an obsession. Monthly gives you enough data to spot trends without burning out.
- Automate the boring parts. If you're manually typing transactions into a spreadsheet, you'll stop within a fortnight. Let your bank or an app like Emma do the heavy lifting.
Do You Actually Need a Budget?
Honestly? Maybe not in the traditional sense. What most people need is awareness. Once you can see where your money goes — clearly, without effort — you naturally start making better decisions. You don't need a rigid budget that tells you you're allowed £30 on coffee this month. You need a system that shows you, without judgement, that you spent £80 on coffee last month.
That's what this automated tracker gives me. Not a cage, but a mirror.
If you want something more structured, YNAB (You Need A Budget) is brilliant for people who like the envelope method. But for me, the passive tracking approach has been far more sustainable.
Free tool: Use our Subscription & Direct Debit Audit spreadsheet (free) to find out exactly where your money goes each month. See all our UK finance tools.
If you've been meaning to get a handle on your spending but keep putting it off, start small. Turn on your bank notifications today — just that. You don't need the spreadsheet yet. Just start noticing. Once you see the numbers, the rest follows naturally.