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 ***