The Matched Betting Tracker Spreadsheet

Almost every matched betting guide tells you to keep records, and then hands you nothing to keep them in. This is the spreadsheet we would have wanted on day one.

What is in it

Bet log

Two hundred rows, one per bet. You enter the date, bookmaker, offer type, stake, back and lay odds, lay stake and commission. It works out the liability, the profit on each side and your running total.

It handles all three bet types properly — cash, stake-not-returned and stake-returned free bets — because the maths is different for each and getting it wrong is how people end up thinking an offer lost money when it did not. Bets left as Pending are kept out of your totals until they settle.

Bookmaker accounts, with a gubbing early warning

This is the part that is not in anyone else’s tracker. Each account shows its own profit, how many bets you have placed, and how many days it has been since the last one. If an active account goes quiet past a threshold you set, it flags.

That matters because a promotion ban is often silent. No email arrives; the promotions page just quietly empties. If you are working twelve accounts you will not notice for weeks. A flag that says “gone quiet, check your promotions page” is the difference between finding out now and finding out next month. Our guides on avoiding restrictions and what to do once restricted cover the rest.

Summary

Net profit, bets settled, bets pending, and breakdowns by offer type, bet type and month. Enough to answer “is this actually working” without building anything yourself.

Why bother tracking at all

Three honest reasons, and none of them is that spreadsheets are fun.

• You cannot tell whether an offer type is worth your time without a record. Qualifying losses are small and frequent; free bet profits are larger and rarer. Over fifty bets the pattern is obvious. Over five it is invisible.
• Positive expected value strategies lose regularly. Extra places, acca insurance and money-back specials pay off across many attempts and lose on most individual ones. Without a record, a normal losing run feels like a broken strategy, and people quit in the middle of one.
• Bookmakers ask. When a withdrawal gets queried, a clean log of deposits and bets settles it in one email.

What it does not do

It does not size your bets. Work the lay stake out in the matched betting calculator first, place the bet, then log what you did. Keeping the two jobs separate is deliberate — a tracker that also tries to be a calculator ends up doing neither well.

It does not connect to your accounts or read anything. It is a spreadsheet. You type in it.

Frequently asked questions

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Sheets. The formulas and dropdowns carry over. It also opens in Excel and in Numbers on a Mac.

Do I have to log every single bet?

For the profit figures, yes, or the totals mean nothing. For the gubbing flag, what matters is logging the date of your most recent bet at each bookmaker — that alone makes column H useful.

Is it really free?

Yes. We make money when people join a service through our links, which is disclosed on every page that carries one. The spreadsheet costs you an email address and nothing else.

18+ only. Please gamble responsibly. BeGambleAware.org