Staking Group Settlement Sheet — DFS & Sports Betting Groups
Built for the groups the solo trackers don't cover: a backer staking players, or a few people pooling entries and splitting the result. You know the shape of the problem — one guy's play netted $450, the other guy lost $200, the backer gets 60%, and settling up turns into three people doing different math in a group chat.
This sheet keeps it in one place:
- Members tab — up to 10 people, backer/player roles, profit shares and separate loss shares if your deal has them. A check right under the table flags it if the shares don't add to 100%.
- Action Log — 200 rows ready: date, player, site, contest, buy-in, winnings. Net calculates itself, and the player column is a dropdown of your Members names so the totals actually tie out.
- Settlement tab — per member: total played, total cashed, their share of the group net, and the single number that settles it — what they owe the bank or what the bank owes them. Everybody settles with the bank, nobody has to chase anybody. There's also a month-by-month summary for groups that settle monthly.
- Tax Notes tab — a checklist of what to keep for each member (site statements, settlement records, bank payouts) so year-end isn't a scavenger hunt. Record-keeping only, not tax advice.
Comes with a plain-English guide that walks through a real settle, dollar by dollar, including the part everyone gets wrong the first time (the guy who won the most is usually the guy who sends money back). Delete the example rows and it's yours. Works in Excel, Google Sheets, and LibreOffice.