Last Updated on September 18, 2020 by Ben Adams
First, I have to start with an apology.
I spent a while thinking, ‘how can I make a post about a matched betting spreadsheet even a tiny bit interesting?’.
Well, I decided, I can’t!
So, I’m sorry, but, it is an important topic so it has to be done!
Keeping track of bookmakers details, offers, withdrawals, deposits etc, etc, etc isn’t the most exciting part of matched betting.
However, a simple matched betting spreadsheet can make this a painless process.
As a result, you can minimise time spent on admin, and instead focus your time on completing more offers.
As you’ll know, more offers ultimately leads to more profit.
What You Need To Record
Keep things as basic as possible.
You don’t need to record every single football team and horse you back and lay.
I recommend having one sheet for recording offers.
On it, you should keep track of:
– The date that you started the offer
– Bookmaker account that the offer is from
– Brief description of the offer
– Profit or loss from the offer
– Total running profit
– Extra notes if needed for each offer (e.g name of a horse, if it comes 2nd or 3rd will get a £10 free bet)
On a separate second sheet, the next thing you absolutely need to record is your bookmaker and casino account details.
Those who really excel at matched betting will end up having well over 100 different accounts open.
Life will be much easier if you have an efficient system to help you find your login details.
The last thing you want is to waste time searching around trying to remember your username or having to go down the lost password route.
So, I would recommend logging the following:
– The date you opened the account
– The name of the bookmaker
– Total deposited/Balance/Total withdrawn
– Password or password hint
– Pending deposits
– Pending withdrawals
This information helps keep track of where all your matched betting bankroll is.
When I check my bank statement, I can see if all the deposits and withdrawals have happened as expected.
With Microsoft Excel, you can password protect your matched betting spreadsheet. (Just don’t forget your password to this!).
So, with sheet one for offers and sheet two for bookmaker/casino accounts, that’s all the essential information covered that you absolutely need to have easy access to.
If you hate the idea of spreadsheets, there is nothing wrong with the old fashioned way.
A good old notepad and pen.
As long as you have a quick system that you can easily retrieve your information, then you’ll be set up and ready to go.
Monthly Profit Graph
This is not necessarily needed but it can be nice to see your monthly profits.
With matched betting, your monthly profit will vary a lot.
Though, as you continue, over the long term, the graph will show you the amount you average each month.
It’s nice to know roughly how much you can expect to make monthly.
Total Profit Graph
Another non-essential graph but great to help keep you motivated.
Particularly helpful when doing higher variance casino offers.
You can at times find yourself going through a bad run or feel like you aren’t getting anywhere.
Looking at your overall profit will remind you that your profit will dip and rise.
But in the long run, by continuing to only take value, your total profit is only heading in one direction.
Download My Matched Betting Spreadsheet
I designed and use a simple matched betting spreadsheet with all four sections mentioned above.
If you have experience with spreadsheets, then I think it’s a great idea to build you’re own.
I personally like building my own so it suits my needs and I know where everything is.
However, if you like the look of mine, you can download a blank copy of my spreadsheet here.
Alternative Way To Track Your Progress
Oddsmonkey have a tool called a Profit Tracker.
The Oddsmonkey Profit Tracker helps you record your daily, monthly and all-time profits.
Personally, I prefer using my own spreadsheet out of habit.
Although, if I was starting matched betting now, I would definitely make use of this.
The most appealing thing about the Profit Tracker is that you record your stats in the same place as you do your matched betting.
It makes the flow of your admin work much more natural.
Logging your bets from the matched betting calculator sends all the information you need straight to your profit tracker.
This will be particularly helpful to beginners to keep them organised and less overwhelmed.
I like that you can easily see the source of your profit too.
This can be useful to analyse your data over the long term.
You can see where your time is best spent.
Use What Works For You
Whichever option you choose, the main thing is, have something that makes it easy for you.
Get comfortable with a system that keeps admin to a minimum.
Instead, spend your valuable time completing more offers, and making more profit.