Most people who earn money from bank switching fall into the same trap. They nail the strategy—they know which banks to switch to, when to switch, what cards to stack. But then the bonuses start arriving at different times, one account comes to the end of its 0% period without notice, and suddenly they've lost track of whether they've met the spending requirements.
The money's still there. They just stopped tracking it.
If you're serious about earning £1,000+ per year from banking, you need a system. Not a complicated one—just something structured enough to catch the things that fall through the cracks. This is the guide to building it.
Why Your Current System Isn't Working
You probably track your banking in one of three ways right now, and all three fail.
The mental note. You remember that you switched to Barclays last month. You know the bonus is supposed to arrive in Q3. When it doesn't show up on schedule, you think: "I'll check into it later." By the time you actually investigate, the bank's escalation window has closed. You've lost the bonus.
The one spreadsheet. You created a Google Sheet with all your accounts, their bonuses, and when the money arrived. It's accurate, but you update it every six months. The moment something changes—a new offer from your current bank, a bonus that arrives two months late, a 0% period ending—the spreadsheet becomes stale. You start trusting it less and rely on memory again, which brings you back to problem one.
The app chaos. You're using your banking app for everything: checking balances, setting reminders, scrolling through offers. But apps are designed to show you what's in that bank, not across your entire network. You miss new offers from competitors. You don't see the full picture of your switching schedule. You're always missing context.
The pattern is the same: tracking breaks down because you're not connecting the information you have. You need visibility across three dimensions: where you're applying next, where your money is supposed to arrive, and what's actually in each account.
The Three-Tier Tracking System
This is simpler than it sounds. Three spreadsheets—or three sections of one spreadsheet—that each answer a specific question.
Tier 1: Your Application Pipeline
This is the answer to: "What have I applied for, when does each one complete, and what do I need to do?"
Your columns:
- Bank name. Obvious, but helps when you're managing 5+ accounts.
- Account type. Current account, savings, credit card, regular saver. Matters because some accounts have prerequisites.
- Application date. When you hit submit. You'll reference this for the 30-day assessment period.
- Target completion date. When the account should be active. Check your terms—it's usually 5–7 days for current accounts, variable for credit cards.
- Bonus amount. Link to the original offer page so you can verify it if something goes wrong.
- Bonus payout date. When the bank promised to pay it. Not when you expect it—when they said they would.
- Spending requirement. £1,000 in the first three months? £500 in the first 60 days? Write it down exactly as stated.
- Spending requirement deadline. When you need to hit that number by.
- Status. Applied, active, bonus pending, bonus received, closed.
- Notes. Use this ruthlessly. "Waiting for letter," "ID verification flagged," "called bank about late bonus," "bonus arrived 15 days late."
When you add a new switch, fill in every column. Spend five minutes now to save yourself an hour of detective work later.
Your monthly ritual for Tier 1: on the first of each month, review anything that should have become active last month. Is it showing in your banking app? If not, what's the blocker? Call the bank if needed. It's remarkable how many people don't follow up.
Tier 2: Your Bonus Ledger
This answers: "Which bonuses have been paid, which are pending, and which are missing?"
Your columns:
- Bank and account.
- Bonus promised. The amount you should receive.
- Promised payout date. When they said it would arrive.
- Actual payout date. When it actually hit your account. Leave blank if still pending.
- Status. On time, late (how many days?), not received, disputed.
- Action taken. Complained to bank? Escalated? Contacted ombudsman? Document it.
This is where you catch delays. If a bonus was promised on June 30 and it's now July 10, you know to call the bank. Most delays are genuine errors—the bank's system assigned the bonus incorrectly, or there was a flag on your account that's now cleared. A five-minute call usually fixes it.
Every bonus that arrives late teaches you something about that bank. Some banks reliably pay late. Some have specific triggers that delay bonuses (direct debit not set up yet, spending requirement flagged as dodgy, address verification pending). Document it. You'll use this when planning future switches.
Tier 3: Your Account Snapshot
This answers: "What money is sitting in which account, what's coming to the end of its useful life, and what should I do about it?"
Your columns:
- Bank and account type.
- Current balance. Update this monthly. Most people do this anyway; just drop it in your sheet.
- Interest rate or 0% period. What you're currently earning.
- End date. When the 0% ends, when the rate drops, when you need to move the money.
- Months remaining. Calculate this so you can see at a glance which accounts are coming to the end.
- Next action. Move money to regular saver? Switch this bank? Park it somewhere safe? Decide in advance so you don't let money sit in a poor-rate account by accident.
- Estimated earnings from this account. Simple math: balance × interest rate ÷ 12. Gives you a rough monthly projection and keeps you motivated.
This tier is your defence against slow accounts. A lot of people move money off a 0% card successfully but then forget to deposit it into something earning interest. It sits in a current account at 0.01% for three months. You've done 95% of the work and then thrown away 5% of the reward. This sheet prevents that.
Setting Up Your System
You don't need fancy software. Google Sheets works. A local Excel file works. Notion works if you want something prettier. What matters is that you can see across all three tiers in under a minute and update it in five.
Option 1: Simple spreadsheet. One sheet per tier, same file. Minimal friction. Works perfectly for 5–8 active accounts.
Option 2: One consolidated sheet. Columns for all three tiers in one big sheet if you prefer a single view. Harder to scan but easier to manage if you're also tracking other financial data nearby.
Option 3: Automated tracking. Some people use a small Zapier integration or IFTTT rule to log new offers. If you've got the time to set this up, it's worth it. Most people don't, and a manual check once a month is fine.
One rule: update it the same day you take action. Applied for a new bank? Add it to Tier 1 immediately. Bonus arrived? Log it in Tier 2. You're not relying on memory anymore; you're capturing facts as they happen.
Your Monthly Ritual
Set a calendar reminder for the first Thursday of every month. Block 30 minutes. Here's what you do:
-
Tier 1 scan (10 minutes). Look at anything marked "applied" or "active." Are they in your banking app yet? If an account should be active and isn't, what's the hold-up?
-
Tier 2 audit (10 minutes). Look at pending bonuses. Anything overdue? Call the bank. Seriously—most complaints are resolved in under five minutes, and you're usually polite enough that they'll expedite the bonus as goodwill for the inconvenience.
-
Tier 3 decision (5 minutes). Look at the "months remaining" column. Anything under three months? Decide your next move: move it to a saver, plan your next switch, or park it somewhere stable. Decide and log it in the "next action" column.
-
Month-end close (5 minutes). Update all balances. Add up your estimated earnings from Tier 3. This is the number you're aiming for. You'll be amazed how motivating it is to see that £847 estimated annual return from your current stack of accounts.
This ritual takes 30 minutes and costs you nothing. It's the difference between earning £1,500 and earning £1,200 in a year—directly through catching bonuses that fall through cracks and indirectly through staying motivated enough to stick with your strategy.
Common Questions
How do I know if my bonus is actually late?
Check your offer's T&Cs. Most banks specify a window—"within 30 days of completing the requirements" or "by end of Q3." If you're outside that window and it hasn't arrived, call them. Have your offer letter ready (screenshot it) so you can prove what you were promised. Most banks resolve this within a week of you calling.
Should I include closed accounts in my tracking?
Yes, for the first three months after closure. Bonuses sometimes arrive after you've closed the account. You need to know if it's stuck. After three months, archive it.
What if I'm tracking 10+ accounts?
The system still works, but it gets harder to update manually every month. This is the point where you might automate it or use a tool like a shared Google Sheet with conditional formatting (red for overdue, green for on track). The core logic remains: application pipeline, bonus ledger, account snapshot.
Can I use my banking app's budgeting features instead?
No. Banking app budgeting is designed to show you what you've spent, not what you're earning. You need a separate system focused entirely on inflows and timelines, not outflows and spending.
How long do I keep this data?
At least three years. You might need to reference it if there's a dispute with a bank about whether you met requirements or whether a bonus was paid. Three years also gives you enough history to spot patterns in which banks pay late, which accounts earn best, and when you should switch next.
The Final Layer: Your Annual Audit
Once a year—let's say in January—step back and look at your full data. How many switches did you actually do? What was your real earnings (look at Tier 2)? Which banks delayed bonuses? Which accounts earned what? What would you do differently next year?
This is where your spreadsheet stops being a tracking tool and becomes a learning tool. You're not just managing the present; you're getting smarter about the future.
The difference between people earning £1,000 from banking and people earning £3,000 isn't usually strategy—it's discipline. It's the tracking. It's knowing exactly what's happening, when it should happen, and following up when it doesn't.
Your spreadsheet isn't glamorous. But it's the system that keeps your money moving.
The Stooze Daily: For the latest offers and changes since the ones you've already checked, see our live offers page and the offer changelog since 2019 to spot newly competitive accounts.
Common Questions
Can I automate all of this?
Most of it, if you're technical. But manual tracking once a month is usually faster than building the automation. Where automation wins: if you're running 10+ accounts or you want alerts for new offers from specific banks, set up a Google Alert or check the switching guide for tools that monitor rates. For bonus tracking, staying manual means you actually pay attention rather than trusting a system that might miss something.
What if I miss updating for two months?
Your data becomes unreliable, which defeats the purpose. Don't let this happen. If you miss a month, update it as soon as you remember—even if the data is slightly stale, it's better than nothing. If you find yourself skipping months consistently, you're probably managing too many accounts for your current life situation. Scale back.
Should I share this spreadsheet with my partner?
Absolutely, if you're switching together. Make it read-only or use comments to avoid accidental overwrites. It becomes your shared reference for what you're earning and when money should arrive. Removes a lot of "Did the bonus come yet?" conversations.
How do I know if my spreadsheet is accurate?
Once a quarter, spot-check three random entries against your actual banking app and statements. Log in to those banks and verify the balance, bonus status, and terms. If they match, your system is working. If not, figure out where the discrepancy is and update your process.
What's the biggest mistake people make with tracking?
Not capturing the date they did something. Most people log "bonus pending" but not "bonus pending since June 15." Without the date, you don't know if something is overdue. Add a date to everything.
Slug suggestion: banking-tracking-system-guide