Tracking poker results: a bankroll spreadsheet for clubs
Without tracking it is easy to believe you are winning when you are losing, or the other way round. In club poker tracking matters even more: money is spread across clubs, rakeback comes separately and chip rates differ. Here is how to keep a simple results spreadsheet, which columns you need and what conclusions to draw.
Memory is a poor accountant. Big wins are remembered vividly, losses fade, and a month later many players sincerely believe they are up while the balance says otherwise. Others remember only bad beats and think they are unlucky, though they win in the long run. Tracking results removes these illusions and shows what is really happening.
In club apps tracking is especially necessary. Money sits in several clubs with different agents, chips may have different rates, and rakeback is credited separately and sometimes forms a noticeable part of income. Without a spreadsheet you cannot tell which club pays and which eats your bankroll. More on splitting money in bankroll management in clubs.
Which tool to choose
A regular spreadsheet is enough to start: Google Sheets, Excel or any other. It is free, works on phone and computer and calculates everything you need. Dedicated tracking programs and trackers are convenient but often excessive for club poker or do not support the apps you use. The key is not the tool but regularity: a sheet filled in after every session beats a perfect program you open once a month.
Which columns you need
Record date and time, club and stake, session length, result in money and a short note. If you play several formats, add a format column: cash, tournament, SNG, Omaha. Record results in real money, not chips, especially if chip rates differ between clubs. More on rates in chip rate explained.
Date | Club | Stake | Minutes | Result | Note |
|---|---|---|---|---|---|
01.08 | Club A | NL25 | 90 | +18 | Played well |
02.08 | Club B | PLO25 | 60 | -32 | |
04.08 | Club A | NL25 | 120 | +41 | Two weak players |
05.08 | Club A | Rakeback | - | +12 | Weekly credit |
Tracking rakeback
Rakeback in clubs is credited separately, usually weekly after reconciliation. Record it as a separate row or column rather than mixing it with table results. That way you see two numbers: how much you win from opponents and how much you get from the agent. If you are negative without rakeback and slightly positive with it, that is important: your game is not yet profitable on its own. More in rakeback as part of win rate.
Balances across several clubs
Keep a separate sheet with current balances: how many chips in each club, at what rate, what that is in money, and how much is in your wallet and on your card. Update it weekly. This helps you see your total bankroll and notice in time if too much has piled up in one club. Keeping a large balance in one club is risky, see the agent disappeared with my money.
The tracking ritual
After each session spend two minutes: record the result, time and one sentence about how it went. Once a week check balances and add rakeback. Once a month sum up. This rhythm takes little time but gradually becomes a valuable database about your game.
Useful formulas
A few simple formulas make the sheet much more useful. Summing the result column gives the overall total. Dividing the result by total minutes and multiplying by 60 shows win per hour. A filter or pivot table on the club column shows results for each club separately. A running total by date can become a chart that clearly shows streaks and how the bankroll changes over time. All of this uses built-in tools of any spreadsheet without special knowledge.
What to analyse
The main metric is win per hour, or per 100 hands if the app shows hand counts. It lets you compare clubs and stakes. Look at results by club: often one club brings almost all the profit while another is steadily negative because of high rake or strong opponents. Analyse your worst sessions separately: if they are linked to tilt or fatigue, it is time to review your discipline. More in tilt and discipline.
Variance and sample size
Do not draw conclusions from a week or two. Poker results swing a lot, and even a strong player can lose for a month. The more records, the more reliable the conclusions. After three or four months of tracking the picture becomes fairly clear: you see which stakes and formats suit you and which to drop. More on swings in the glossary: variance.
When to move up
Tracking helps you decide when to change stakes. A simple rule: keep a bankroll of several dozen buy-ins for your current stake and move up only when it has grown to the level needed for the next one. If after moving up you lose a noticeable part of the bankroll, move back down without regret. The sheet shows these boundaries in numbers, not feelings.
A spreadsheet does not make you a better player, but it stops you fooling yourself about how good you are.
Common tracking mistakes
Recording only winning sessions.
Mixing rakeback with table results.
Counting in different clubs’ chips without converting to money.
Forgetting deposit and withdrawal fees.
Drawing conclusions from too small a sample.
Tracking and security
A sheet with balances and results is personal financial information. Do not publish it and do not store passwords or wallet details in it. If you use cloud spreadsheets, turn on two-factor protection for the account. More in two-factor protection.
FAQ
Do I need to record every hand?
No. Session totals are enough. Save individual hands only for review, see hand review from the app.
How do I track tournaments?
Record the buy-in and the prize separately and the result as the difference. For tournaments, long-run metrics such as ROI matter.
What if I missed a few sessions?
Reconstruct the result from club balances and keep tracking. An imperfect sheet is better than none.
Summary
Tracking results shows the real picture of your game. Keep a simple sheet with date, club, stake, time, result and a note, track rakeback and club balances separately, and analyse win per hour and results by club every month. Do not draw conclusions from a short sample, and use the data to decide on stakes and clubs.