Poker Bankroll Management Spreadsheet
Build a poker bankroll management spreadsheet: the columns, the formulas for win rate and buy-in count, and how to read it for move-up calls.
On this page · 8 sections
A poker bankroll management spreadsheet is the cheapest, most flexible tool for running your roll — a free sheet that logs every session, computes your bankroll in buy-ins, and flags when to move up or down. Below is the exact column layout, the formulas that do the work, and how to read the result. Build it once and it does your bankroll math automatically forever.
The columns you need
Start with the essentials, one row per session:
| Column | Example | Purpose |
|---|---|---|
| Date | 2026-06-28 | Track trends over time |
| Game / stake | NL $0.50/$1 | Compare profitability by game |
| Hours / hands | 3.5 hrs / 2,400 | The denominator for win rate |
| Buy-in | $200 | Money into the session |
| Cash-out | $340 | Money out |
| Net | +$140 | Buy-in minus cash-out |
| Running bankroll | $4,140 | Previous roll + net |
| Buy-in count | 20.7 | Running bankroll ÷ current buy-in |
The last two columns are what turn a plain results log into a bankroll manager. Everything before them is just tracking; the running bankroll and buy-in count are the decision engine.
The formulas that do the work
Assume net is in column F, running bankroll in G, and your current stake’s buy-in is $200. In row 2:
- Net:
=E2-D2(cash-out minus buy-in). - Running bankroll:
=G1+F2(prior roll plus this session’s net). - Buy-in count:
=G2/200(roll divided by one buy-in). - Win rate (bb/100): total big blinds won ÷ (total hands ÷ 100). If you log hands,
=SUM(bb_won)/(SUM(hands)/100).
Drag those down and the sheet updates itself after every session. You never do bankroll arithmetic by hand again — you just read the buy-in count.
Worked example: reading the sheet
Your running bankroll column shows $4,140 and your current stake buy-in is $200.
- Buy-in count: $4,140 ÷ $200 = 20.7 buy-ins. You’re at the very floor for live cash — playable, but with no cushion.
- The signal: one bad session drops you under 20. So the sheet is telling you to tighten table selection and be ready to move down, not to shot a bigger game.
- Win rate check: if your bb/100 column shows a healthy, proven rate over a large sample, you keep grinding and let the roll rebuild. If it’s break-even, the leak is your game, not variance.
Without the sheet, “$4,140” feels like plenty. Expressed as 20.7 buy-ins, it correctly reads as thin. That reframing is the entire point of the tool.
Conditional formatting: the tripwire
Add one rule and the spreadsheet warns you automatically. Set conditional formatting on the buy-in count column to turn red below 20 and green above 30. Now a downswing that pushes you under threshold lights up before you sit down again. This is the discipline mechanism a raw dollar figure can never give you — a visual stop that fires without you having to do the math each time.
How important is this, really?
Very. Bankroll management is what separates a winning player who lasts from one who goes broke to variance. Even a genuine winner runs into downswings of dozens of buy-ins; without enough of them in reserve, one of those swings ends the whole run before the edge can pay off. The spreadsheet makes that abstract risk concrete — you can literally watch your buy-in count breathe with variance. The deeper logic behind why the buy-in count matters is the same expected-value thinking that governs every long-run decision at the table.
Spreadsheet vs. dedicated tracker
A spreadsheet gives total control and costs nothing — perfect for live players and casual online grinders. Dedicated apps and hand-history trackers automate the data entry and compute positional stats, which earns its keep at high online volume. Neither is “better”; the rule is the same either way: log every session honestly, including the losers. If you want the broader case for tracking and what to log, see the results-tracking guide.
Turning the sheet into decisions
The spreadsheet feeds the two decisions that matter most. A buy-in count that climbs comfortably past the next stake’s threshold — paired with a proven win rate and ROI over a real sample — is your green light to move up in stakes. A count that keeps dipping under threshold is the signal to move down and fix your game. Let the sheet, not your mood, make the call.
Bottom line
Build a poker bankroll management spreadsheet with columns for date, stake, hours, buy-in, cash-out, net, running bankroll, and buy-in count. Let simple formulas compute the last two, add a conditional-formatting tripwire below 20 buy-ins, and read the buy-in count to decide when to move up or down. It’s free, it’s honest, and it’s most of bankroll management in one tab. See the full system in the bankroll management hub.
Frequently asked
Why use a spreadsheet for bankroll management?
A spreadsheet is free, flexible, and forces you to engage with your own numbers. It computes your bankroll in buy-ins, your win rate, and your move-up and move-down lines automatically, turning bankroll decisions into data instead of gut feel.
What columns should a poker bankroll spreadsheet have?
At minimum: date, game and stake, hours or hands, buy-in, cash-out, and net result. Add a running bankroll column and a buy-in count column so you can see at a glance whether you're still properly rolled for your stake.
How important is bankroll management in poker?
It's the single thing that keeps a winning player from going broke to variance. Even a genuine winner hits long downswings; without enough buy-ins, one of them ends your ability to play. Bankroll management is what lets your edge actually pay off over time.
Spreadsheet or a tracking app?
Both work. A spreadsheet gives you total control and costs nothing, ideal for live and casual online players. Apps and hand-history trackers automate data entry and are worth it at high volume. The discipline of logging every session matters far more than the tool.