Bankroll Management Spreadsheet: A Free Template You Can Use Today
Tracking your betting on paper or in your head doesn't work. You need a spreadsheet.
This guide explains a simple template you can use immediately.
Why You Need a Spreadsheet
Your memory is bad at tracking.
You think you're up 50 pounds. Actually, you're down 30 pounds.
A spreadsheet removes this guess. It shows exact numbers.
Simple Spreadsheet Structure
Open a spreadsheet (Google Sheets or Excel). Create columns:
Column A: Date Column B: Match (Team A vs Team B) Column C: Odds Column D: Stake Column E: Result (Win/Loss/Void) Column F: Profit/Loss Column G: Running Bankroll
That's it. Seven columns. Everything you need.
How to Fill Each Column
Date: when you placed the bet.
Match: brief description of the bet. "Man City vs Brighton" or "Over 2.5 goals".
Odds: the decimal odds. 2.5, 1.8, etc.
Stake: how much you bet. 10 pounds, 25 pounds.
Result: Win, Loss, or Void (bet cancelled).
Profit/Loss: if you won at 1.8 odds for 10 pounds = 8 pounds profit (10 * 1.8 - 10 = 8). If you lost = -10 pounds.
Running Bankroll: previous bankroll plus profit/loss.
Example Rows
Date | Match | Odds | Stake | Result | Profit/Loss | Running Bankroll 2026-04-01 | Man City vs Brighton | 2.5 | 10 | Win | 15 | 1015 2026-04-02 | Liverpool vs Fulham | 1.8 | 10 | Loss | -10 | 1005 2026-04-03 | Chelsea vs Wolves | 2.0 | 10 | Win | 10 | 1015
Simple. Clear. Everything visible.
Adding Summary Calculations
At the bottom of your spreadsheet:
Total Stakes: SUM all values in Column D. Total Profit/Loss: SUM all values in Column F. ROI: Total Profit/Loss / Total Stakes * 100. Number of Bets: COUNT all rows. Win Rate: (Number of wins / Number of bets) * 100.
After 20 bets:
Total Stakes: 200 pounds. Total Profit/Loss: 8 pounds. ROI: 4%. Number of Bets: 20. Win Rate: 60%.
These numbers tell you everything.
Weekly and Monthly Summaries
Add a second sheet for weekly summaries.
Week 1 | Stakes | Profit | ROI | Number of Bets | Win Rate Week 1 (Apr 1-7) | 70 | 5 | 7.1% | 7 | 57% Week 2 (Apr 8-14) | 100 | -8 | -8% | 10 | 40% Week 3 (Apr 15-21) | 90 | 12 | 13% | 9 | 67%
This shows trends. Week 2 was rough. Week 3 recovered. Seeing patterns helps.
Tracking By Bet Type
Create separate sheets for different bet types.
Sheet 1: All bets (main summary). Sheet 2: Singles only. Sheet 3: Accas only. Sheet 4: In-play only.
After 200 bets, you'll see which type is profitable. Focus there.
Confidence Tier Tracking
Add a column: Confidence Tier (1, 2, 3, 4).
Then calculate ROI by tier.
Tier 1 bets: 45% win rate, -2% ROI. Tier 2 bets: 52% win rate, 2% ROI. Tier 3 bets: 58% win rate, 6% ROI. Tier 4 bets: 62% win rate, 9% ROI.
This shows whether your confidence tiers are calibrated. Tier 1 should be low win rate. Tier 4 should be high.
If Tier 1 is actually 62% win rate, your tiers are miscalibrated.
Market Tracking
Add a Market column.
Premier League, Championship, European, etc.
Calculate ROI by market.
Premier League: +5% ROI. Championship: +2% ROI. Asian leagues: -1% ROI.
You might focus on Premier League (best edge) and avoid Asian leagues (bad edge).
Running Metrics
Beyond just running bankroll, track:
Win streak: how many consecutive wins. Loss streak: how many consecutive losses. Longest win streak: max consecutive wins to date. Longest loss streak: max consecutive losses to date.
These show variance. Most good bettors have 5-10 loss streaks in 200 bets. Knowing this prevents panic.
Bankroll Projection
Use a formula to project future bankroll.
If current ROI is 5%, and you place 10 bets per week:
Week 1 ending: 1000 pounds. Week 5 ending: ~1255 pounds (estimated, assuming consistent 5% ROI).
Reality will vary. But projections show long-term trajectory.
Regular Review Dates
Schedule reviews:
Every 50 bets: check win rate and ROI. Are they in line with expectations?
Every 200 bets: major review. Is your method working? Should you continue, adjust, or stop?
Every year: annual review. Compare this year to last. Set next year's targets.
Spreadsheet Discipline
Rules:
- Log every bet within 24 hours.
- Never lie to the spreadsheet. If you lost, mark it as lost.
- Review weekly. Don't ignore bad news.
- Calculate ROI correctly. Use the formula. Don't estimate.
The spreadsheet is only useful if it's accurate.
Sharing (Or Not)
Some bettors share spreadsheets with accountability partners.
Others keep them private.
Decide based on your situation. But do keep one. The discipline of tracking is itself valuable.
Moving Between Spreadsheets
As you get serious, you might move to more advanced tracking software.
But start with a simple spreadsheet. A spreadsheet proves you're serious and ready for something more complex.
Common Mistakes
Don't:
- Log only wins (ignoring losses).
- Adjust odds retroactively to look better.
- Calculate ROI incorrectly.
- Ignore rows of losing bets.
The spreadsheet's value is showing truth, not flattering you.
In Summary
- Create a simple seven-column spreadsheet.
- Track: Date, Match, Odds, Stake, Result, Profit/Loss, Running Bankroll.
- Add weekly and monthly summaries.
- Review regularly.
- This one tool shows whether your method works and prevents self-deception.
Frequently Asked Questions
Can I use my notes app instead of a spreadsheet? You could, but a spreadsheet's calculations are more reliable. Notes require manual math, which invites error. Use a spreadsheet.
Should I share my spreadsheet publicly? Only if you want. It's personal financial data. Privacy is reasonable. Some bettors post results for credibility. Others keep it private. Your choice.
How detailed should my spreadsheet be? Start simple (seven columns). Add detail as needed. After 200 bets, add market and bet type analysis. Don't overcomplicate early on.
Can I use my betting account's own tracking? Many betting apps have built-in tracking. Use it if available. But also keep your own spreadsheet. Your records are under your control.
What if I place bets across multiple accounts? Use one master spreadsheet tracking all accounts. Or separate sheets per account, then one summary sheet. Either works.
How long do I keep spreadsheet data? Indefinitely. Five years from now, your data shows trends. Long history is valuable for analysis.