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.

• 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.