record keeping ?

[NySportsfan]

just necessarily only about capping record-keeping, but just in general for accounting and personal purposes..........what do you guys think is the best way to keep track of bills and also something for capping.......excel is alright, but I was looking for something better, I know people have asked before........whats the best kind of ledgers and things to buy at staples or officemax or the like, just wondering, I know quickens good for bills and expenses and things, dont know the best way for capping though, excel is a hassle to put the different fields in, and I like by hand better, just need a good ledger with enough lines, LOL thats my stupid thread for ya, shows how bored I am, take care

Mike

 

[Nick Douglas]

I have used Appleworks spreadsheets (Mac equivalent of Excel) for about 3 1/2 years and it works great. Starting from the left I have:

Date
Team
Line
Odds (moneyline)
Opponent
Sport
Book
Risk
Win
Result
Profit (sum of all Results)
Withdrawls & Deposits
Money Offshore (sum of Profit and Withdrawl/Deposit columns)

For the withdrawl and deposit column, I split up withdrawls, deposits, bonuses and fees. On the rare occasions I have played online casino games at a book I put any profit or loss from those in separate entries on the Withdrawl/Deposit column as well.

It takes a lot of discipline to keep one of these up, especially when you go through a rough losing streak. Every play I have made since September of 2000 is documented though so it helps when I want to go back and see what I bet or where I bet when I did well or poorly.

 

[NySportsfan]

just what I was looking for nick, thanks a lot....how often do you do the profit and withdrawl/deposit thing, like when you deposit youd put down deposit, 3k or something, but I dont know how exactly youd keep that up, I guess youd put down +200 if you are up and -200 if you're down, I like the headings you have though, going to do something similar, think I'll use excel b/c I dont have appleworks, everything else appreciated from all

Mike

 

[Nick Douglas]

Deposit/Withdrawl column is just for deposits and withdrawls into a book. Here is an example where I withdrew $500 from Oly earlier this year, paid a $15 fee, deposited that $500 into Tradewinds and got a $75 bonus:

($500)
($15) - entry in red so that I know it is a bonus or a fee.
$500
$75 - entry in red again

I would have made four entries in the deposit withdrawl column. In the Money Offshore column, since it automatically sums the Profit column with the Deposit/Withdrawl column, it would go up by $60 in total after these four entries are made.

Free plays are a little tougher to calculate. When you get a $100 free play ($0 to win $100), it is not really fair to call it a $0 risk bet. I try to figure out the equivalent cash value of the play. So my $100 free play might be entered at like a $52.38 bonus in the Deposit/Withdrawl column.

Glad you like this spreadsheet idea. I am convinced that it is a great way to track wagering activity.