The Matched Betting Spreadsheet That Tracks Everything

This page contains affiliate links — if you open an account through them we may earn a commission at no cost to you. It never changes our verdict.

This page is a sub of our matched betting beyond the basics pillar, and it's about the unglamorous habit that quietly separates the people who profit from the people who quit: tracking. Matched betting isn't gambling when it's done right — it's a mechanical extraction of bookmaker offers using the exchange to cover your bets. But “done right” depends entirely on records, because the method deliberately involves small planned losses, and without a spreadsheet you can't tell a planned loss from a real one. That confusion is what makes people give up two weeks in, convinced it doesn't work, when in fact they were up the whole time and just couldn't see it.

Why tracking is non-negotiable

Matched betting produces a confusing set of balances on purpose. You put a stake at a bookmaker, lay it on the exchange, and on the qualifying bet you accept a small loss to unlock a free bet — then you make a larger profit from the free bet. At any given moment, your bookmaker balance, your exchange balance and your “real” profit can all be telling different stories. If you only glance at a balance, a perfectly successful offer mid-flight can look like you're losing money, because the qualifying loss has landed but the free-bet profit hasn't yet. People panic and quit at exactly this point. A spreadsheet replaces that panic with certainty: it tells you your true net profit across everything, which offers paid what, and whether any red number is the planned qualifying loss or a genuine error you need to fix. It also makes errors findable — if a leg didn't lay properly, the spreadsheet shows it immediately rather than letting it hide inside a muddle of balances.

The columns you actually need

Don't over-engineer it. The columns that earn their place are:

• Date — when you placed the offer.
• Bookmaker — which account, so you can spot which firms you've used and which offers remain.
• Offer — e.g. “£30 free bet on £10 stake” or “price boost”, so each row's purpose is clear.
• Bookie back stake and bookie odds — what you staked at the bookmaker and at what price.
• Exchange lay odds and lay stake — the price and amount you layed on Betfair.
• Lay liability — what you risked on the exchange leg.
• Commission — the exchange rate applied to winning lays.
• Qualifying loss — the small planned loss on the qualifier (a negative number).
• Free-bet / offer profit — what the free bet or boost actually returned.
• Net profit — the per-offer bottom line.
• Running profit — cumulative total.

That's it. Anything beyond this is optional polish. A template from our spreadsheet templates gives you these columns ready to fill.

The formulas that do the work

The spreadsheet earns its keep through a handful of formulas, all built on one idea: for each leg, work out what you net whether the selection wins or loses, because matched betting is designed so both outcomes leave you roughly the same. On the qualifying bet, if the selection wins you collect the bookmaker return minus your lay liability; if it loses you lose the bookmaker stake but keep the lay winnings (minus commission). Both should land on the same small negative — your qualifying loss. The formula simply subtracts your total stakes from your total returns under each outcome. On the free-bet leg, the bookmaker stake is “free” (you don't get it back in the return, but you didn't pay for it), so the maths shifts in your favour and both outcomes land on a profit. The single most useful cell is net profit per offer = free-bet profit + qualifying loss (the qualifying loss being negative), and a running SUM of that column down the sheet gives your true total. Get the matched betting calculator to produce the exact lay stake for each leg, then your spreadsheet just records the outcome rather than computing the stake from scratch.

Logging qualifying losses correctly

The qualifying loss is the column people get wrong, and getting it right is the whole psychological battle. A qualifying loss is the small, expected cost of placing the bet that unlocks the free bet — typically a pound or two on a tenner stake, caused by the gap between back and lay odds plus exchange commission. The crucial move is to log it as a clearly negative number in its own dedicated column, labelled as planned. Why does this matter so much? Because when you then add the free-bet profit, the net is comfortably positive, and seeing the qualifying loss sitting next to a larger free-bet gain makes it obvious that the small red number was an investment, not a mistake. If you instead lump everything into one balance, that qualifying loss vanishes into the noise and you lose the ability to tell “this offer cost me £1.80 as planned and then made me £24” from “something went wrong”. Read lay betting explained if the lay-leg maths behind the qualifying loss isn't yet second nature.

Tracking free bets and profit

Free bets are where the actual money is made, so track them precisely. When an offer credits a free bet, the key fact is whether it's “stake not returned” (almost always the case) — meaning you only keep the winnings, not the stake. Your spreadsheet should record the free-bet amount, the back odds and lay odds you used to convert it, and the resulting profit, which for a typical stake-not-returned free bet lands around 70–80% of the free-bet value depending on the odds you can find. Logging this per offer lets you answer two questions that matter: which offers are worth your time (a £30 free bet converting at 78% is worth roughly £23, every time you can do it), and how much “locked” value you're still sitting on in un-converted free bets. A common rookie error is treating a credited free bet as profit before converting it — it isn't money until you've layed it off and banked the guaranteed amount. The spreadsheet keeps that distinction honest.

Tracking your bank across bookies and exchange

Profit per offer is half the picture; the other half is knowing where your money physically is. Matched betting spreads your bank across multiple bookmaker accounts and your Betfair exchange wallet, and it's easy to lose track of how much is committed versus available. A simple second tab — a list of each account and its current balance, plus your exchange balance — tells you at a glance how much working capital you have and whether you've got enough in the exchange to cover your next lay liability. This matters because the most common practical failure isn't a maths error, it's running out of exchange balance to place a lay, which leaves you with an un-covered bookmaker bet — i.e. an actual gamble. Keeping a running bank tab stops that. It also lets you reconcile: if your spreadsheet says you should have £X total across everything and you don't, you've found an error to chase down while it's still small. Understanding how commission nibbles each winning lay helps you keep those balance projections accurate.

Spreadsheet vs app trackers

You don't have to use a spreadsheet forever — but it's the right place to start. Spreadsheets are free, completely transparent, and they force you to understand the maths because you're building the formulas yourself; the downside is manual entry. Paid app trackers automate logging, pull in offers, and calculate profit for you, which is genuinely faster once you're doing volume — the downside is cost and the fact that they hide the mechanics, so a beginner using one often doesn't actually understand what's happening when something goes wrong. My honest recommendation: build and use a spreadsheet until the maths is second nature and you've internalised what a qualifying loss is and why your balances behave as they do. Then, if and only if your volume justifies it, move to a tracker for speed. Starting on an app you don't understand is how people make errors they can't diagnose. The spreadsheet is the apprenticeship.

Reviewing the spreadsheet: what the numbers tell you

A spreadsheet you fill in but never read is just data entry. The real value comes from periodically standing back and asking what the columns are telling you — and they tell you more than just your total profit. Profit per offer type is the first thing to look at: sort or total your net column by offer category and you'll quickly see which kinds of offer actually pay. You may find sign-up offers were lucrative but one-off, while a particular bookmaker's recurring reloads quietly produce steady money every week — knowledge that tells you where to spend your limited time. Average qualifying loss is worth watching: if your typical qualifying loss is creeping up, it usually means you're accepting bigger gaps between back and lay odds than you should, and tightening your odds selection will claw that back. Conversion rate on free bets — the percentage of a free bet's face value you actually banked — is a quiet efficiency score; if you're consistently converting at 65% when 75–80% is achievable, you're leaving money on the table by laying at poor odds or rushing. Error frequency matters too: a column or a note flagging trades that went wrong (a leg that didn't lay, a mis-stake) shows whether your mistakes are trending down as you improve or clustering around a particular offer type or time of day when you're rushing. And the simplest review of all is the running total trend: is the cumulative profit line climbing steadily, which is exactly what a working method looks like, or is it lumpy and stalling, which usually means you've run out of fresh offers and need new ones? None of this analysis is complicated — it's a few minutes with the data you've already logged — but it's the difference between blindly grinding offers and actually managing matched betting like the small, systematic operation it is. The reload offers guide, in particular, makes far more sense once your spreadsheet shows you which recurring offers genuinely pay.

The verdict

Tracking is the boring habit that makes matched betting actually work. A simple spreadsheet — date, bookmaker, offer, back and lay details, liability, commission, qualifying loss, free-bet profit, net and running totals — gives you certainty where balances give you confusion. It tells you your true profit, proves which red numbers are planned, catches errors while they're cheap, and stops you quitting on a misread screen, which is the single most common reason people abandon a method that was working. Build it from a template, feed it exact stakes from the calculator, and anchor your wider learning in the beyond the basics pillar and the full matched betting guide. The offers make the money; the spreadsheet makes sure you keep it — and that you stick around long enough to collect it.

FAQ

Related reading

This is a sub of our matched betting beyond the basics pillar. Pair it with the offer-specific guides on price boosts and reload offers, and grab a starting template from our trading spreadsheet templates. To get the maths behind each cell, read lay betting explained and commission explained, and use the matched betting guide for the full method.