Ultimatcher : Matched Betting is a hot topic right now for those trying to earn money from home. It’s easy to do, creates tax free earnings, you can easily earn £1000+ a month from it and you don’t need much money to get started. However, keeping track of those earnings can be quite difficult. Some people might make their own spreadsheet to keep track of their profits and loses, however, I have decided to use Ultimatcher which is a spreadsheet that seasoned matched betting people use to keep track of everything.
It can be very confusing when you first start using it so I am giving you a ‘getting started’ guide here. We will cover putting in your details, doing a few bets and looking at how the information is tracked. This should be enough for you to get started using the sheet, if you have any questions feel free to leave a comment below.
Download Ultimatcher
The first thing we need to do is download the spreadsheet. We can do that by going here – You can download both the 2003 MS Office version or the 2010 and onwards one from that link.
If you are using a Windows 8 system, then you’ll need to follow these instructions to get Ultimatcher to work:
- Open Ultimatcher, but DO NOT allow Macros.
- Press ALT-F11, to open the VB editor
- Click on Tools / References (on the top menu)
- Deselect ‘Microsoft XML, V6
- Select ‘Microsft XML, V3’ (If you have a V4, this should be fine as well)
- Click OK, then close the VB Editor
- Save the workbook
- Open the workbook, and this time enable Macros
Another point worth noting is that I have only known this spreadsheet work as it should do on Microsoft Office. Due to the sheer number of
How to setup Ultimatcher
I’m going to run through what to do in the following order
1) Putting in your bank details
2) Putting in the bookie / exchange details
3) Placing bets and manual adjustments
4) Understanding the logs
Open the spreadsheet once it has downloaded. If a pop up asks you to enable editing then check “YES”
If you look at the tabs at the bottom you will see one called Banking – we are going to use that one first.

In this screen we simply need to enter 3 bits of information. We do that under ‘Add New Bank’ The details you need to enter are your bank name, the currency (which will be GBP) and your starting balance which would more than likely be £0.00. Once you have entered the details simply press ‘Add Bank’ and you are done. If for some reason you are using multiple bank accounts to fund your matched betting venture then you could add those in by just repeating the same action.
Once you have filled in all your bank details click the Bookies tab at the bottom
Here we need to enter details for the bookies and exchanges that we use. You don’t need to do this ALL at once if you are just getting started, just enter the bookies you have used so far.

Under ‘Add New Bookie’ enter the name of your bookie, choose if they are a Bookie or an Exchange, the starting balance would typically be 0, same with profit, commission would be 0%. If you are entering an exchange like BetFair the commission would be 5%. Then you can enter some of your login details, choose which Bank you are funding the bookie account with and set the currency to GBP. That is all we need to fill in at this point so you can just click ‘Add Bookie’. Rinse and repeat this for all bookies / exchanges you use.
Tracking our first Matched Bet on Ultimatcher
We are now at the point where the spreadsheet knows details about how our matched betting is funded and which bookies and exchanges we are using. This is more than enough for us to put our first bet into the sheet so click on BM1 at the bottom in the list of tabs.
I will go through an entire free bet scenario here, including both the qualifying and free bet
First we need some qualifying bet details so let’s say the offer is
Bet £20 on Coral and get a £10 free bet
We will be betting on England to beat Germany – Coral odds are 2.0, Betfair odds are 2.1
The first thing we need to do is enter the event details – We do that in the top left hand corner of the BM1 sheet.

If you click ‘Date / Event’ it will fill in the current date by default which is quite helpful. On the right hand side of that we put the event taking place and then put in the information for what we are backing and what we are laying.
We are now going to fill in the ‘Bookie’ side details of the bet

On the right hand side where it says ‘Bookie Side’ we select Qualifier (as that is the type of bet we are doing here. We choose Coral as the bookie, input our stake and where it says Odds Input we put the odds for the back bet (2.0) – That is all the information we need to put in so now we look to the right where it says Match Type

Here we select our exchange (BetFair) from the drop down box next to Bookie. We next put in the odds for the lay bet (2.1) here where it says ‘Odds Input’ and then put in the value of your lay bet where it says ‘Stake Override’
That’s all you need to enter, if you scroll down a little bit on the sheet you will see this Bet Statistics info which tells you how much you will lose on this qualifier based on if the bookie or exchange side ends up with the money.

We are now all done here so press ‘Process bet’ – It may seem long winded when you start doing this but given enough time you can enter these details in around 30 seconds once you have done it a lot of times.
It may be a few hours (or even days) until this event takes place so the bet will vanish from infront of you and go into the Pending tab at the bottom – and that is where we are going next

This is a very simple tab to use. Basically we just tell the sheet how the bet ended. We will say that England didn’t win in this match so we simply click where it says ‘Pending’ under the result column and select ‘Win’ or ‘Lose’ next to the Coral line. That’s all there is to do on this tab, we are simply confirming the result of the bet. All happy, then press ‘Process Bets’ and the bet will again vanish from in front of you as you have told it that the event is no longer in pending and a result has taken place
A short while later we get our free bet from Coral so it is time to go back to the BM1 tab and enter the bet details.
We are going to bet on the 14:10 at Newmarket on a horse called Smartysocks. Coral has odds of 5 and the exchange has 5.05

I won’t go through the entire process again as the only change you need to make here is changing the bet type from Qualifier to Free SNR (Free Stake not returned). To do that simply click on the right hand side of where it says Bookie side and select Free SNR. Then enter the bet details just as you did before. Scroll down a little again on that sheet and you should see the potential outcome below

If you are happy with everything then just press ‘Process bet’ again and then it’s over to the Pending tab again
Once again we are going to select the outcome of the race

In this case the horse didn’t win so the Betfair side got the win and that is the result that we tell it by again clicking in the Result column and selecting the outcome. As you can see it’s obvious to see our £7.60 profit from this free bet. All done here so we click Process Bets and it will again vanish from this tab.
How to deal with Manual Adjustments in Ultimatcher
Any seasoned matched better does not just restrict themselves to doing sports events and so will play the slots quite a bit as well. If you make some money out of those you need to enter them into Ultimatcher as well. To do this we go to the Bookies tab again at the bottom.

In here we will be using the ‘Manual Account Adjustment’ section
We simply choose which bookie the slots offer was with. Put in the amount we won under ‘Amount in GBP’ and under Reason we enter something like ‘Win on Slots’ – that’s all there is to it so we just click Make Adjustment and we are all done here.
—
This pretty much covers everything a day to day matched better would use Ultimatcher for but it’s important that we can actually see how we are doing with out bets and what profit and loss we are making. For that we need to click on the Betting Log tab.

Here we can see all 3 of ours transactions. Our qualifying bet, our free bet and finally our £40 slots win. As you can see it also keeps track of how much we have staked during the course of our bets and how much money we have made. The Stats tab at the bottom gives some great information once you have started filling in Ultimatcher a lot more with more varied information as you can look at which bookies are performing the best for you and all sounds of other useful information.
Hopefully this is enough of a guide to get your up and running with Ultimatcher and keep track of your matched betting career.
If you want to give matched betting a go then just click this banner below and sign up to Profit Accumulator which is the matched betting service I use. If you are already involved in Matched Betting then make sure to check out our official thread on the subject here
FAQ
Ultimatcher is an easy to use spreadsheet that anyone who is doing Matched Betting can use to track their profit.
Due to the use of macros Ultimatcher can only be used on Microsoft Excel. It does not work with the likes of Google Sheets or Numbers on the Apple Mac.
Once you have downloaded the spreadsheet simple enter your details about as requested and then fill in information about any bets you are planning to place.
Ultimatcher offers far more flexibility and control when it comes to detailing your profits and open bets.
Why not pin this image for later?

This is a super helpful post. I have never heard of the Ultimatcher before but I will be researching this.
http://fashionandstylepolice.com
Thanks for the details and advice, I wouldn’t ever bet though.
Sophie
xx
http://www.pocockins.co.uk
it don’t work on any format tried them just keeps crashing and opens 50 windows save it and it cant save useless
Hi Carl – What version of Ultimatcher are you using 2003 or 2010 and on which version of Windows are you trying to use it?
Thanks for that. I am about to download and start using it myself so those instructions are really useful.
The fix for windows 8 doesn’t work in windows 10 btw. If you do the above it sets everything to dollars when you use the banking tab or when you are processing bets. This is Excel 2013…Is there a fix for this
I am loving Ultimatcher!
So easy to use. I am using it with Microsoft Office Enterprise 2007 and it works perfectly. Thanks for your detailed instructions it was easy to see how to set it up and where all the different info goes.
Was about to set this all up but then found I don’t have office…bugger.
Hi – does this work with Macs? I have downloaded both available options and it asks me whether or not to enable macros. If I do then about 50 windows open. If I don’t then it does not work correctly. I have tried both versions.
Any advice would be greatly appreciated, many thanks
Hi Samuel
The only way it will work on a Mac is by running it using parallels
HOWEVER if you head on over to our forum and look at our HUGE matched betting thread you will see there is a Mac user on there who has made a fantastic spreadsheet and offers it out to users who need it
Hope this helps
Jon
Hi Jon
Thank you for the advice. I have started using it through Parallels but I will check out the Mac user spreadsheet too.
Thanks again
Samuel
Hi, I’m on Win 8. I had no prompt about macros on opening for the first time, or on re-opening. But when I try to ‘add bank’ it says cannot run the macro and that it may be unavailable or disabled. I followed the VB editor steps, V3 was already selected as were few other boxes at the top and, V6 deselected. Any clues?
Hi Cappy123
Thanks for your comments.
Which version of Microsoft Office / Excel are you running please?
why does this error show up ?
HI
why does this error show up ???
Hey Lewis! You are using the right version of Ultimatcher for YOUR version of MS Office aren’t you?
HI, yes the rest of the sheet seems to be working fine its just that one page doesn’t work ?
Also is this spreadsheet available on Google docs?
And do you has more advanced guide i cant seem to find anything other than this page?
Hi Lewis
Just to confirm though you are using the RIGHT VERSION for your version of MS office as there are 2 copies of Ultimatcher One for office 2000/2003 and one for later versions and I just wanted to confirm you are using the right one since you are getting that error.
No Ultimatcher doesn’t work on Google Sheets however come and check out our Matched Betting thread on the forum as some users there have designed some great Google Sheet compatible MBing spreadsheets they use and share with other members.
http://www.themoneyshed.co.uk/index.php?topic=5338.0
hi
i think so ??? i downloaded the unlitmatcher4.05.xlsm file and im using Excel 2016 could this be my problem ?
and could you point me in the right direction on your thread to the googlesheets that people are using, as there is so many posts i cant find anything?
Thanks for your help
Hi Lewis
THIS is the version of Ultimatcher you want to be using for your version of Office
http://www.mediafire.com/download/y6ku4ddrbxpyh86/Ultimatcher4.05.xlsm
I would say join in on the forum and drop Auntygeek a PM once you get your post count above 10 as she is the user who has been working on it and can share it with you
Jon
I have found a bug or error i think. When I transfer money from my bank to my bookies and back again my total bankroll decreases. Why? In the pie chart of my cash locations the money is going into a section called pending bets but in pending bets there are none.
To try and copy this error
add a bank of 400£
add a bookie balance 0
now your bank roll should be 400
transfer money to and from the bookie and watch the bank roll lower….it shouldn’t.
Solved: this is normal and you need to add a date into the transfer section to reflect money landing in your bank.
ive created a video of this at https://www.youtube.com/watch?v=d03tfYdkuwk
Hi.
I have just downloaded for windows 10, excel 2016, but I keep getting the bug messages when I open it.
Thanks
Thanks, this makes it easy for people like me to understand.
I’ve made mistake & recorded free bet as qualifying one- how can I amend this ?