Just Starting - Making Available Funds = Current Sportsbook Balance

[Bsmith0]

Hi,

I am very new to this sports betting tracker and previously I was only using excel for basic recording of my bets. I did not start recording my bets on my excel spreadsheet for a few months, so I do not have my bets from when I first deposited money into my account. I now am trying to transfer to this betting tracker but I have a problem:

I currently have $ABC in my sportsbook account. I deposited a total of $XYZ into the account, resulting in me earning a profit. How do I set my new betting tracker to show that I have a current balance of $ABC, while showing that I have deposited a total of $XYZ (and will have no bets that show how I went from $XYZ to $ABC)

I need help to essentially calibrate my new betting tracker to account for the money that I currently have in my sportsbook account, my open bets, and my total money deposited into my sportsbook account that has resulted in my current balance.

Any help is greatly appreciated because I would like to utilize this great betting tracker, but am unsure how to transition from my own personal records to this workbook!

Thank you

[Bsmith0]

I believe I have solved my own problem by creating an Account Adjustment bet type and sport, and then winning that bet for the difference between my total money deposited and my current balance, then recording my open bets.

Maybe this will help someone else?

[admin]

Hi Bsmith0,

Yes, I've used Account Adjustment style bet types and sports myself.

Alternatively you can set a bet type like "Previous winnings." For example, if you deposited $100 and your current balance is $150, you could enter $100 as the deposit and then create a winning $50 wager at 2.00 odds.

One other option is to simply enter your current bookmaker balance as the deposit. So if you deposited $100 and at the time you created the spreadsheet the balance was $150, you would enter $150 as your initial deposit. This would mean that the spreadsheet would track your betting performance from this day onwards instead of from the date you made the deposit.