For groups tracking in Excel or Sheets
Most home games are not tracked with an app. They are tracked in a spreadsheet, or a notes app, or on the back of an envelope, and that is the tool an app has to beat. A spreadsheet is not a bad choice — it is free, everyone already has one, and for buy-ins and cash-outs it is genuinely sufficient. The trouble starts at the specific point where the arithmetic stops being addition, which is the moment one player is all in for less than the bet. This page is about where that line is, and what is worth keeping from the spreadsheet on the other side of it.
Honest about where a spreadsheet is already enough
The exact point it stops being enough
What to keep: the zero-sum check, the buy-in log
The left column is not a criticism. A spreadsheet is the right tool for a surprising amount of this, and the argument is only about the rows marked as a problem.
Job
Recording buy-ins and cash-outs
Spreadsheet
One row per player, two columns
Verdict
Fine — genuinely sufficient
Job
Checking the night balances
Spreadsheet
One SUM that should be zero
Verdict
Fine, and better than most apps make it
Job
Season totals across many nights
Spreadsheet
A tab per night, one summary
Verdict
Fine, if someone maintains it
Job
Live stacks during a hand
Spreadsheet
Nobody is typing during a hand
Verdict
Does not happen
Job
Side pot eligibility
Spreadsheet
Manual, mid-hand, under time pressure
Verdict
This is where it breaks
Job
Minimum-transfer settlement
Spreadsheet
Possible, rarely built
Verdict
Usually done by hand and badly
One all-in for less than the bet, with three players still in. The main pot is capped and a second pot forms above it, and only some players can win each.
Player
A (all in)
Put in
$20
Eligible for
Main pot only
Why
Capped at their own contribution, matched by each caller
Player
B
Put in
$60
Eligible for
Main pot and side pot
Why
Matched A, then kept betting
Player
C
Put in
$60
Eligible for
Main pot and side pot
Why
Same
Player
Main pot
Put in
$60
Eligible for
A, B, C
Why
$20 x 3 — the amount everybody matched
Player
Side pot
Put in
$80
Eligible for
B and C only
Why
Everything above the cap
For buy-ins and cash-outs a spreadsheet is not a compromise. Two columns per player, one subtraction, one total that should come to zero — that is the whole settlement, and it is the part most groups get right. If your game never produces a side pot and nobody wants live stacks, you do not need to change anything and this page is not going to invent a reason for you to.
When one player is all in for less than the current bet, the pot splits. The main pot is capped at that player's contribution multiplied by the number of callers, and everything above goes into a pot the all-in player cannot win. With two short all-ins there are two side pots and the order matters — the smallest all-in caps the main pot, the next caps the first side pot. None of that is hard maths. It is hard bookkeeping, done mid-hand, while five people talk, and checked by nobody.
Nobody types into a spreadsheet during a hand, which means a spreadsheet is always a record made afterwards. That is fine for settlement and useless for the actual question at the table, which is how much the person opposite has left. Without live stacks somebody has to eyeball a pile of chips, and if you have already given up the physical chips you have no pile to eyeball.
The one habit worth carrying over from the spreadsheet is the total that has to come to zero. Every player's result is their cash-out minus their buy-ins, and those results must cancel out exactly. If they do not, the difference is precisely the size of the entry that was recorded wrong — usually a rebuy nobody wrote down. Plenty of tracking apps never show you this. It is the single most useful line in the whole spreadsheet and it is worth insisting on wherever you move.
The second habit worth keeping is that the record is visible to everybody rather than held by one person. Most settlement disputes are not about honesty; they are about a rebuy made during a hand that the person keeping score was also playing. A shared sheet already gets this right. Any replacement that hides the log behind the host's screen is a step backwards, however much else it does.
Three things, and it is worth being specific rather than promising that everything gets better. Side pot eligibility is worked out rather than argued about. Stacks are live, so the chips can genuinely go away. And the settlement resolves to the fewest payments — a six-player night goes from eleven transfers to three or four, which matters less for the arithmetic than for the number of people who forget.
A spreadsheet is yours. It opens in ten years, it has no account, and nobody can change the terms on it. That is a real thing to give up and the honest mitigation is export: whatever you move to, check that you can get your history back out in a format a spreadsheet reads, and check it before you have a season's worth of data in there rather than after.
Run both for one night. Track the session in the tool and keep the spreadsheet open for the buy-ins as you always have. At the end, compare the two settlements. If they agree, you have verified the tool against a method you already trust and you can drop the spreadsheet next time. If they disagree, you have found something worth knowing about one of them, which is also a good outcome.
FAQ
01
For buy-ins, cash-outs and the final settlement, yes. It stops being enough when a hand produces a side pot or when players need to see live stacks.
02
Side pot eligibility. When someone is all in for less than the bet, the pot splits and only some players can win each part — done by hand, mid-hand, it is where errors happen.
03
Every player's result is cash-out minus buy-ins, and those results must sum to exactly zero. If they do not, the gap is the size of the entry recorded wrong.
04
Yes, and many groups should. Export a session and paste it in, or keep the tool for live play and the sheet for the running record across the year.
05
Only if you pick something you cannot export from. Check the export format before you move, not after a season's worth of results is inside it.
06
No. Stacks live on each player's phone and the cards stay physical, so you still deal and still read the table — only the chips move onto the screen.
Create a free room, invite players, track live stacks, and share the final result when the game ends.
Create Game Room