Free Spreadsheet Template for Tracking Picks

A pick-tracking spreadsheet needs eight columns: Date, Member, Event, Pick, Odds, Stake, Result, and Payout. With the right formulas for American odds conversion and a SUMIF for per-member balances, this layout handles settlement reconciliation for operations with up to 10 members before manual grading becomes unsustainable.

Below is the complete spreadsheet layout you can copy into Google Sheets or Excel today, with formulas, sample data, and clear guidance on when it is time to upgrade to dedicated software with automated grading and a tamper-evident ledger.

Why You Need a Tracking System

Running an operation without a tracking system guarantees disputes and lost money. Even with three or four members, picks accumulate fast during a busy sports weekend. Without a clear record of who picked what, at which odds, and for how much — you are relying on memory and text message threads for settlement reconciliation.

A spreadsheet gives you a single source of truth. Every pick is logged, every result is recorded, and every balance is calculated. When it is time to settle up at the end of the week, there is no guesswork involved.

The Essential Columns

A good pick-tracking spreadsheet needs eight columns. Here's what each one captures and why it matters:

1. Date — When the pick was placed. Essential for weekly settlement grouping and resolving timing disputes.
2. Member — Who made the pick. You'll filter by this column to calculate individual balances.
3. Event — The game or match. Include both teams so there's no ambiguity about which event the pick was for.
4. Pick — What the member selected. Be specific: "Lakers ML" or "Chiefs -3.5", not just a team name.
5. Odds — The American odds at the time the pick was placed. This locks in the terms of the pick and prevents after-the-fact disputes.
6. Stake — How much the member risked. This is the amount they'll lose if the pick doesn't hit.
7. Result — Win, Loss, or Push. Fill this in after the event finishes.
8. Payout — The calculated return. For wins, this is the profit based on the odds and stake. For losses, it's the negative stake. For pushes, it's zero.

Sample Spreadsheet with Data

Here's what a completed week looks like in practice. This table shows picks from three members across a typical NFL Sunday:

Date	Member	Event	Pick	Odds	Stake	Result	Payout
2/23	Alex	Chiefs vs Bills	Chiefs -3.5	-110	$50	Win	+$45.45
2/23	Alex	Eagles vs Cowboys	Over 47.5	-105	$30	Loss	-$30.00
2/23	Jordan	Lakers vs Celtics	Lakers ML	+150	$25	Win	+$37.50
2/23	Jordan	Chiefs vs Bills	Bills +3.5	-110	$40	Loss	-$40.00
2/23	Sam	Eagles vs Cowboys	Eagles ML	-135	$50	Win	+$37.04
2/23	Sam	Lakers vs Celtics	Celtics -4.5	-110	$35	Push	$0.00

At a glance, you can see the full picture: Alex is up $15.45, Jordan is down $2.50, and Sam is up $37.04 for the week. That's exactly the kind of clarity you need when settlement day arrives.

Key Formulas

The payout column is where the math lives. You'll need a formula that handles three scenarios based on the odds and result:

• Wins with negative odds (favorites): Payout = Stake ÷ (Odds ÷ -100). For example, a $50 stake at -110 returns $50 ÷ 1.1 = $45.45 profit.
• Wins with positive odds (underdogs): Payout = Stake × (Odds ÷ 100). A $25 stake at +150 returns $25 × 1.5 = $37.50 profit.
• Losses: Payout = -Stake. The member loses their full stake amount.
• Pushes: Payout = $0. No money changes hands.

In Google Sheets, a formula combining these scenarios in a single cell might look like:

=IF(G2="Push", 0, IF(G2="Loss", -F2, IF(E2<0, F2/(E2/-100), F2*(E2/100))))

For member balances, use a SUMIF at the bottom of your sheet: =SUMIF(B:B, "Alex", H:H) gives you Alex's running total for the week.

Organizing for Weekly Settlements

Keep each week on a separate tab. Label tabs by date range — "Feb 17-23", "Feb 24-Mar 2" — so you can quickly pull up any historical week if a dispute arises. At the bottom of each weekly tab, add a summary section with each member's net balance and whether they owe you or you owe them.

This weekly structure aligns with the settlement workflow most organizers follow: picks accumulate Monday through Sunday, balances are calculated Sunday night, and settlements happen Monday or Tuesday.

When Spreadsheets Start to Break Down

A spreadsheet works well for small operations, but it has real limitations that become painful as you grow. Here are the signs it is time to upgrade:

• Manual grading consumes every weekend. Looking up scores for 30+ events and entering results by hand takes hours and introduces errors. One wrong result cascades through multiple member balances. As we covered in our guide on common organizer mistakes, manual grading errors are the number one cause of member disputes.
• Picks arrive in inconsistent formats. Some members text "Lakers ML $50", others send "50 on LA". Without a standardized input method, you are transcribing and interpreting picks — another source of errors.
• No credit limit enforcement. Spreadsheets have no concept of a maximum stake or credit ceiling. A member can be deep in the red and you will not know until you manually check their running balance. Proper bankroll management requires automated limits.
• Settlement disputes are increasing. When there is no tamper-evident ledger — just a spreadsheet that anyone with access can edit — trust erodes. Members start questioning results, and you have no audit trail to point to.
• Parlay tracking is unmanageable. Multi-leg parlays require combined odds calculation and leg-by-leg grading. Doing this manually in a spreadsheet is error-prone and time-consuming.
• You have more than 10 active members. The volume of picks, the time spent grading, and the complexity of settlement reconciliation all grow linearly. What took 20 minutes with 5 members takes over an hour with 15.

Moving Beyond the Spreadsheet

When your spreadsheet starts holding you back, you have options. Traditional pay-per-head services solve the automation problem but introduce per-head fees that scale with your member count. Modern alternatives like Booki offer the same automation — automated grading, real-time balances, tamper-evident ledger tracking — without the per-member pricing.

The key features to look for in any upgrade:

• Automated grading with odds integration that pulls live scores and settles picks without manual input
• Credit limit enforcement that blocks picks when a member reaches their ceiling
• A tamper-evident audit trail that records every pick, every result, and every settlement in an immutable log
• Real-time balances so both you and your members always know where they stand
• Parlay tracking with automatic leg-by-leg grading and combined odds calculation

Start with the spreadsheet. Learn the mechanics. When you are ready to scale, upgrade to a tool that handles automated grading and settlement reconciliation so you can focus on running your operation.