Sports Betting Record Keeping Spreadsheet
*** If you like our bet records spreadsheet you will absolutely LOVE our bet records database which we believe is the best bet recording software available ***
The Importance of Record Keeping. So, why on earth should you ever worry about keeping records of your sports bets? Well, if you’re taking your sports betting seriously, you need to treat it like a business. So, I have built a matched betting spreadsheet that, in my opinion, is the very best out there! Matched Betting Spreadsheet Benefits. Automatically track your profit. Automatically track your balances.
Keeping betting records is important as you need to be able to analyse your bets in order to help you see which type of bets are are making you profit long term. It is also important to know what your overall profit or loss might be and this is very difficult to keep track of across multiple bookmakers.
We at Betting Tools have devised a spreadsheet for keeping track of all your bets. All you have to do is name the bet, set the stake and odds, choose the bookmaker from the dropdown and then choose win or lose once it has been completed. The spreadsheet does the rest and works out your profit loss on that particluar bet and overall. It will also tell you what your return would have been if you bet the same amount on each bet (level stakes) and this is a very useful comparison.
The spreadsheet will also keep track of how much you should have in each bookmaker account based on your deposits and bets you've made with them. Again this is very useful as bookmakers do make mistakes!
If you need any help or have any questions about the spreadsheet you can find post a message on the forum.
*** UPDATE - A new version of the bet records spreadsheet has been created where new rows are added from the top and are then modified which reduces scrolling and the length of the spreadsheet. You do need macros enabled for this though and it's best to change the default save option to macro enabled too ***
Click here to download the updated Bet Records Spreadsheet
**NEW! You can now subscribe to our 3, 4 and 5 star tipsters for just £9.99 a month (33p a day). Click here to start making a profit from our tips. |
An account with Betfair is a must have.
The big profits from our tips largely come from horses over 10/1 and betfair exchange have significantly better prices on those selections.
We have had success requesting slighty bigger prices than those tipped and usually get matched very easily.
Liquidity can be a problem at times but
they also have their sportsbook odds which are up there with the best in terms of
bookie odds.
Sign up to betfair and get a £20 free bet.
New customers only, bet at least €20 on the Exchange and if your
first bet loses, we’ll refund you €20 in Cash. Bet must be placed in first 7 days of account opening. Full T&Cs Apply
Name | W/L | Profit £ | |
---|---|---|---|
1 | Dynamite21 | 5/9 | +13.50 |
2 | AndyHolding | 0/0 | +0.00 |
3 | Pricewise | 0/3 | -30.00 |
4 | TipOfTheDay | 0/7 | -70.00 |
5 | On The Nose | 0/18 | -180.00 |
Name | W/L | Profit £ | |
---|---|---|---|
1 | Bet Monkey | 1/3 | +60.00 |
Last Updated on March 6, 2021 by
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!
Matched Betting SpreadsheetKeeping 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
– Offers
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)
– Bookmaker Accounts
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.
Football Betting Spreadsheet
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.
Betting Spreadsheet Template
So, I would recommend logging the following:
– The date you opened the account
– The name of the bookmaker
– Total deposited/Balance/Total withdrawn
– Username
– 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 matched betting 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
Sports Betting Record Keeping Spreadsheet Template
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.
Final Thoughts: Use What Works For You
Sports Betting Record Keeping Spreadsheet
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.
Sports Betting Record Keeping Spreadsheet Free
Instead, spend your valuable time completing more offers, and making more profit.