Best for the full workbook
Download the Excel version when you want the native tables, validation lists and dashboard exactly as built. No macro or external connection is used.
Download .xlsxFree template, no email gate
Free poker bankroll spreadsheet
Updated August 2026 · by Tom Howcroft
A complete Excel and Google Sheets-ready poker tracker with a clean session log, worked sample, true hourly, BB/hr, bankroll curve, monthly results and maximum drawdown.
6purpose-built tabs
4live dashboard charts
20worked sample sessions
0email fields or locks
What is included
A real tracker, not a blank table
The workbook calculates the useful numbers from the rows you enter. The Dashboard can switch between the included sample and your clean Sessions tab, so every chart has a worked example before you trust it with your own history.
- Formula-backed net result, true hourly, BB/hr and result in big blinds.
- Bankroll curve, monthly results, stake split and venue split.
- Average session length, total hours, winning-session rate and maximum drawdown.
- Custom venue, game and stake lists with clear formula notes.
- Clean 500-row entry table plus a separate worked sample.
- Version, changelog, licence and data-ownership notes in the file.
What to record after every poker session
The sheet separates cash movement, time and costs so a headline win does not become a flattering hourly. Complete beats perfect: if a cost is unknown, leave it blank rather than inventing it.
| Field | What it means | Use |
|---|---|---|
| Date | The calendar date of the session. | Required |
| Venue | Casino, card room, home game or online room. | Required |
| Game | No-Limit Hold'em, PLO, mixed game or your own label. | Required |
| Stake | Readable stake name such as £1/£2. | Required |
| Big Blind | Numeric big blind used to calculate result in BB and BB/hr. | Required for BB stats |
| Buy-In / Cash-Out | Money put into the session and money taken away. | Required |
| Hours | Decimal session length, for example 5.5 hours. | Required |
| Rake | Only enter a separate rake cost when cash-out does not already include it. | Optional |
| Tips / Travel | Direct costs that sit outside the chips in play. | Recommended |
| Notes / Tags | What happened, what to review and how to find the session later. | Optional |
How the true hourly is calculated
This example buys in for £1,000, cashes out £1,378 and records £20 in tips plus £18 travel. Net Result is £340. Across 5.5 hours that is £61.82 per hour, or 12.36 BB/hr at a £5 big blind.
| Date | Venue | Stake | Buy-In | Cash-Out | Hours | Costs | Net | True hourly | BB/hr |
|---|---|---|---|---|---|---|---|---|---|
| 2026-08-05 | Aspers Stratford | £2/£5 | £1,000 | £1,378 | 5.5 | £38 | £340 | £61.82/hr | 12.36 BB/hr |
Net Result = Cash-Out - Buy-In - Rake - Tips - TravelEnter rake only when it is not already reflected in cash-out.
Best for access anywhere
Download the Google Sheets-ready copy, upload it to Drive, then open it with Google Sheets. Choose File, Save as Google Sheets if you want a native cloud copy.
Download Sheets copyCSV and Overshove
Move the history without losing the sample
The plain CSV carries the same core column names with no formulas. It is the cleanest interchange format when you want to move your history into a tracker or back into your own analysis.
- Keep one row per session and use ISO dates such as 2026-08-05.
- Export or save the session table as CSV UTF-8.
- Map date, venue, game, stake, buy-in, cash-out and hours first.
- Map tips, travel, rake, notes and tags where the source has them.
- Check totals against the workbook before accepting the import.
Fix the common spreadsheet problems
BB/hr is blank
Enter a numeric Big Blind, Hours and a completed Net Result. Stake is a readable label; Big Blind is the calculation field.
The dashboard still shows sample data
On Dashboard, change Data source from Sample to Your Sessions. The headline stats and charts follow that selector.
My result looks double-counted
If cash-out already reflects table rake, leave the Rake column at zero. Use it only for a separate fee that the cash-out number does not include.
Google Sheets changed the chart style
The data and formulas remain the important part. Google may restyle imported Excel charts. Reapply your preferred chart colours after saving as a native Google Sheet.
CC BY 4.0
Use, adapt and share the template, including commercially, with attribution to Overshove and a link to this page. Your poker data remains yours.
Read the Creative Commons licencev1.0.0, 5 August 2026
First public release: clean session log, 20-row worked sample, source-switching dashboard, bankroll curve, monthly, stake and venue splits, and maximum drawdown.
Poker spreadsheet FAQs
Is the poker bankroll spreadsheet really free?
Yes. Excel, Google Sheets-ready and CSV versions download without an email address, account or card. The workbook uses no macros or external data connection.
Does it calculate poker hourly rate and BB/hr?
Yes. Net Result subtracts buy-in and direct costs from cash-out. True Hourly divides that net by hours, and BB/hr also uses the numeric Big Blind field.
Can I use it in Google Sheets?
Yes. Download the Google Sheets-ready copy, upload it to Drive and open it with Google Sheets. Save it as a native Google Sheet if you want cloud sharing.
How many sessions can the workbook hold?
The supplied entry table has 500 prepared rows with formulas, validation and dashboard support. You can extend the table in Excel if you need more.
Can I bring the spreadsheet into Overshove?
Yes. Save the clean session table as CSV, map the columns once and check the imported totals against the workbook so the full sample comes across.
Who owns the data?
You do. The file stays on your device or in your own cloud account, and the plain CSV gives you an open interchange format.