How to Track Sports Bets in a Useful Spreadsheet

Enter each sportsbook ticket once, whether it is a single wager or a parlay. Start with these columns:

Line and odds are different. On Chiefs −3.5 at −110, −3.5 is the point spread; −110 determines the potential payout. A moneyline selection has no separate spread or total, so its line cell can stay blank.

For a parlay, keep one row with the combined ticket odds. Put each leg’s selection and line in the selection cell or a notes column. Creating a row for every leg and repeating the full stake would count the same money multiple times, distorting stake totals and profit calculations. Once settled, net profit is payout minus stake; leave that calculation blank while the ticket is open.

For an $11 point spread bet at −110, enter the ticket when it is placed—not after the game. A simple example might look like this:

The $10 is what the wager could win, before settlement; it is not profit earned. If the bet wins, the $21 payout includes the original $11 stake. Keeping actual return and net profit blank until settlement prevents open bets from looking like losses or completed wins.

Use the same market and status labels on every row, and preserve the original line and odds even if the betting line moves later. Reconstructing prices from memory makes the record less useful. If entering every ticket manually becomes a chore, bet tracking apps for automated recordkeeping may help; imported details are still worth checking against the sportsbook ticket.

Use separate columns for net profit and payout. Net profit shows how much a settled ticket gained or lost; payout is the total amount returned by the sportsbook, including the stake on a standard winning bet.

For the formulas below, put stake in F, American odds in G, status in H, net profit in I, and payout in J. Enter odds as numbers, such as -110 or +150, and use Win, Loss, Push, or Pending for status.

In I2, enter:

=IF(OR(H2="",H2="Pending"),"",IF(H2="Win",IF(G2>0,F2*G2/100,F2*100/ABS(G2)),IF(H2="Loss",-F2,IF(H2="Push",0,""))))

In J2, enter:

=IF(I2="","",F2+I2)

Copy both formulas down the sheet. A win at positive odds uses the odds to calculate profit; a win at negative odds divides by their absolute value. A loss records the full stake as a negative net result and a $0 payout. A push records $0 net and returns the stake. Pending tickets stay blank in both calculated columns, so an unsettled wager is not mistaken for a loss.

For example, an $11 win at −110 earns $10 net. Its $21 payout is the $10 profit plus the returned $11 stake—not $21 in profit. These formulas assume a standard cash wager; a free bet whose stake is not returned needs different payout handling.

Keep one row per ticket, even when a parlay has several legs. Record its total stake once and enter the sportsbook’s final return when the entire ticket settles. Adding a row for each leg would count the same stake multiple times.

Use the amount actually paid back to calculate results:

• Push or void: If the full cash stake is refunded, record that refund as the return. Net profit is $0. If only part of the stake is refunded, record the actual amount returned.
• Cash-out: Record the cash-out payment as the return, not the payout the original odds might have produced. A $20 cash wager closed for $14 has a $6 loss.
• Parlay with a void leg: Leave it as one ticket. Record the final payout under the sportsbook’s adjusted odds; do not create a separate refund for that leg.

Promotional wagers need a separate cash-stake field if the spreadsheet’s net-profit formula normally subtracts the listed stake. A $10 bonus bet might pay winnings without returning the $10 promotional stake. Record the payout actually received and the cash actually risked, rather than treating the bonus stake as a cash refund. Check current sportsbook terms for how the specific promotion settles.

A small summary above the wager log is enough to show whether the recorded bets are making or losing money. Filter Status to completed wins, losses, and cash-outs; leave open wagers and fully voided tickets out of the sample. Then calculate:

• Settled wagers: Count the visible tickets, not the legs within a parlay.
• Settled stakes: Add the cash at risk on those same tickets. Subtract any refunded portion of a stake.
• Net result: Add their net-profit values, including losses as negative amounts.
• ROI: Divide net result by settled stakes, not by the bankroll or the stakes of every wager ever entered. Leave ROI blank when settled stakes are zero.

In Excel or Google Sheets, SUBTOTAL can count or sum visible rows, so the figures update when the log is filtered. Filtering by sportsbook, sport, or bet type can reveal, for example, whether NFL point spreads and player props have different recorded results. Keep all four figures tied to the same filtered rows; the ROI calculation from betting records is only meaningful with a matching stake total.

A filter showing a profit on NFL point spreads can look convincing until the wager count comes into view. Five settled bets, including one large win, say little about whether that market suits a bettor better than others. Keep the number of wagers and total stake beside net profit and ROI so a narrow slice cannot hide behind a strong percentage.

Before changing stake size or dropping a bet type, widen the date range and judge results over a meaningful sample. Check whether one parlay, bonus bet, or unusually large wager drives the result. Even a longer profitable run records past outcomes, not a proven edge.

Add a bankroll summary separate from the bet log. Tracked bankroll = opening bankroll + deposits − withdrawals + settled net results. If the starting amount was $500, deposits totaled $100, withdrawals totaled $50, and settled bets netted $25, the tracked bankroll is $575.

Deposits and withdrawals move cash; they are not betting profit or loss. A $100 transfer from one sportsbook to another changes each account’s available funds but leaves the combined bankroll unchanged. When tracking multiple accounts, record both sides of the transfer without counting it as new money entering the bankroll.

Keep open wagers visible too. If $40 of that $575 is tied up in unsettled bets, $535 remains uncommitted, assuming the stakes were paid in cash. This distinction helps show current exposure across sportsbooks. A higher balance is not a reason to increase stakes automatically; it is one input when developing a sustainable betting strategy that accounts for risk and affordable wager sizes.