How to Track Bets Manually: A Spreadsheet Setup That Works

To track bets manually, open a spreadsheet, give every wager one row, and log the same details each time: date, event, bet type, odds, stake, sportsbook and result. Then add formulas for profit and return on investment (ROI), and update each row as soon as the bet settles. The whole system takes about 10 minutes to build and under a minute per bet to maintain. Below you get the exact columns, the formulas, a worked example, and a way to compare odds across books before the bet is even placed.

TL;DR

• Log every bet the moment you place it, then fill in the result right after it settles. A record with gaps is worse than no record.
• Use one row per wager with these columns: date, sport and event, bet type, sportsbook, odds, stake, result, profit or loss, and closing line.
• ROI is profit divided by the total amount wagered. Track it by sport, bet type and month, not only overall.
• Check the same market at more than one sportsbook before you bet, and record the price you actually took.
• In the U.S., an accurate record of winnings and losses also matters at tax time, so keep tickets and statements.

Table of Contents

• Why track your bets by hand at all
• What to record for every bet
• Build the spreadsheet in five steps
• How to record results, payouts and bankroll accurately
• Compare odds before you log the bet
• Keep records the IRS can accept
• Our perspective on tracking
• Put your tracking to work with ParlayGeeks
• Common mistakes to avoid
• FAQ
• Sources

Why track your bets by hand at all

Your sportsbook balance tells you where you stand today. It does not tell you why. Yahoo Sports betting analyst Pamela Maldonado argued in 2022 that logging every wager, rather than just watching the account balance, helps you see your strengths and weaknesses across a season. That is the real payoff of tracking: patterns.

Typical patterns a log exposes:

• You win on NFL sides but bleed money on same-game parlays.
• Your Sunday bets are sharper than your late-night ones.
• One sportsbook consistently gives you better prices than another.
• Your stakes creep up after a loss.

Sporting News makes a related point: without a record, it is hard to know whether a strategy is actually profitable, and the same piece lists chasing losses, emotional betting and oversized wagers as the bankroll mistakes that follow. A written log makes those mistakes visible, because you can see the stake jump on the row after a loss.

Memory is the other reason. Most people remember their big hits and quietly forget the small losses. A log replaces the story you tell yourself with totals: how much you staked, how much came back, and what that means per dollar wagered.

Why manual rather than an app that syncs? Because typing the bet forces a pause. You write down the price, the stake and a one-line reason, and that habit alone filters out impulse wagers. A spreadsheet is also yours: no subscription, no export limits, and you can add any column you want.

What to record for every bet

Keep the log simple enough that you will actually fill it in. Here is the column set we recommend, with what each one is for.

The date, type, odds, stake, result and closing line are the core. A company-published tracking guide lists date and time, sport and event, bet type, odds, stake, result, profit or loss and closing line as the useful set, and the extra columns above (sportsbook, legs, note) cost you little and answer questions you will certainly ask later.

A note on odds format

U.S. sportsbooks display American odds. Negative odds show how much you must bet to win $100, and positive odds show how much you win on a $100 bet, as Hard Rock Bet’s how-to-bet guide lays out. Always record American odds in one consistent format so your formulas work. If you need a refresher on decimal and fractional prices, our guide to reading betting odds fast covers the three formats.

The same guide notes that the odds printed on your ticket are the odds you have, however the line moves afterward. That is why you log the price at the moment you bet and keep the closing price in a separate column.

Build the spreadsheet in five steps

You can do this in Google Sheets or Excel. Both handle everything below.

1. Create the header row. Type the columns from the table above in row 1 and freeze the row so it stays visible as you scroll.
2. Add data validation. Turn Bet type, Sportsbook and Result into dropdown lists. Consistent labels are what make summaries possible. “Win” and “won” count as two different values to a formula.
3. Calculate profit automatically. Use a formula that reads the result, odds and stake, so you only enter three things per bet.
4. Add totals at the top. Total staked, total profit, ROI, win rate and number of bets.
5. Build a summary tab. Group results by sport, bet type, sportsbook and month.

The profit formula

In American odds, a winning bet pays differently depending on the sign:

• Positive odds: profit = stake × (odds ÷ 100). A $50 bet at +150 wins $75.
• Negative odds: profit = stake × (100 ÷ absolute odds). A $55 bet at -110 wins $50.

In a spreadsheet, assuming odds are in column G, stake in H and result in I (typing “W”, “L” or “P”), a single cell formula for profit can be:

=IF(I2="W", IF(G2>0, H2*G2/100, H2*100/ABS(G2)), IF(I2="L", -H2, 0))

A push or voided bet returns your stake, so profit is zero. Copy the formula down the column and every row calculates itself.

ROI and win rate

The research on this is consistent: ROI is profit divided by the amount wagered. In your sheet, that is total profit divided by total stake across settled bets.

A worked example with made-up numbers:

Note what ROI does not say. A 5% ROI says nothing about how many bets won. At -110, you need to win about 52.4% of your bets just to break even, so a bettor winning 55% of the time can have a thin ROI, while a +300 parlay specialist might win under 30% and still profit. Track both numbers, but trust ROI and sample size over win rate.

Sample size matters just as much. Fifty bets is a start, not a verdict. Variance can make a good bettor look bad over a month and a bad one look brilliant, so review by hundreds of bets before you change your approach.

Break it down with a summary tab

The summary tab is where the habit pays off. Use SUMIFS to total profit and stake for each category, then divide. For example, one row per sport, with columns for bets, staked, profit and ROI. Do the same for bet type and sportsbook.

After a couple of months you might see that your NBA totals are up 9% while your parlays are down 14%. That is a decision you can act on: cut parlay stakes, or study why those legs fail.

How to record results, payouts and bankroll accurately

The rule is simple: log the key details when you place the bet and update the result as soon as it settles. Waiting weeks to backfill is how errors, and skipped losing bets, creep in.

A few habits keep the numbers honest:

• Log before the game. Odds, stake and sportsbook go in at the moment of the wager, while the price is still on your screen.
• Settle from the sportsbook, not from memory. Check the bet history for the official result and payout, especially for props and parlays that void a leg.
• Record pushes and voids. They affect your ROI denominator in the right way only if you mark them correctly.
• Handle parlays as one row. Put the combined American odds and total stake in a single row, with the number of legs in its own column. If you want leg-level analysis, add a second tab with one row per leg.
• Count promotional bonus bets separately. A free bet that returns only the winnings is not the same as a cash stake. Give it its own result code, or you will inflate your ROI.
• Track deposits and withdrawals on a bankroll tab. Your bankroll is the money set aside for betting. Betting results move it, but deposits and withdrawals should not count as wins or losses.

On bankroll, the guardrails matter more than the math. Sporting News flags using money you cannot afford to lose as one of the core bankroll risks. Set a budget before the season starts and write it at the top of your sheet. The American Gaming Association’s responsible-betting guidance likewise tells bettors to set a budget and stick to it, and its 2025 research found that 60% of sports bettors always or usually set a budget and 85% of those stick to it. Note that this figure refers to budgets set before gambling at a casino. A tracking sheet turns the same idea into a number you can see: budget, spent, remaining.

If you notice yourself raising stakes after losses or betting more than you planned, treat it as a signal to step back. In the U.S., the National Problem Gambling Helpline (1-800-GAMBLER) offers free, confidential support.

Compare odds before you log the bet

A tracking sheet records what you did. The biggest lever on what you earn is the price you take. Sporting News advises comparing the same bet across sportsbooks before placing it, because a worse price cuts into your potential return and even small differences add up over time.

How to compare odds across books in practice:

1. Match the market exactly. Same game, same bet type, same number. A spread of -3 at one book and -3.5 at another is a different bet, not a different price on the same bet.
2. Convert to a common format. Compare American odds side by side. -105 beats -110, and +150 beats +140.
3. Compare implied probability when prices differ in sign. -110 implies about 52.4% (110 ÷ 210). +105 implies about 48.8% (100 ÷ 205). Lower implied probability means a better price for the side you are backing. Our implied probability workflow walks through this step by step.
4. Read the rules, not just the number. Books can settle ties, player props that miss a game, or overtime differently. Check before you assume two lines are identical.
5. Log the price you took and the best available price. A “best available” column shows what shopping is worth in dollars over a season.

Why do prices differ at all? Books update at different speeds, face different customer flows and manage risk differently, so the same market can briefly carry different numbers. Line movement itself comes from new information like injuries or weather, or from money coming in that pushes books to adjust to manage their exposure. The same source describes reverse line movement, when a line moves against the side getting most of the bets, which can happen when fewer, larger sharp wagers outweigh the public ones.

To go deeper on comparing lines, see our guides on line shopping for the best odds, sharp versus soft books, and NBA line movement patterns. If you are still deciding where to play, choosing a sportsbook comes first.

Add a closing line column

Closing line value (CLV) compares the odds you took with the odds at the close. If you consistently beat the closing price, that is a sign you are making positive expected value decisions, even before results catch up. It is a useful check because it judges your decision quality rather than short-term luck. Enter the closing odds right before kickoff, then add a column that shows whether your number was better or worse. Our closing line value guide shows how to calculate and read it.

Keep records the IRS can accept

If you bet in the U.S., your log has a second job. The IRS says you may deduct gambling losses only if you itemize on Schedule A, only up to the amount of your reported gambling winnings, and only when you keep an accurate record of winnings and losses backed by documentation such as receipts, tickets or statements.

The IRS’s guidance on a gambling diary says the record should include the date and type of wager, the name and location of the establishment, who was with you, and the amounts won or lost, and that you should keep supporting documents like wagering tickets, canceled checks or payment slips. For online betting, that means saving account statements and bet history exports along with your sheet.

Practical steps:

• Add a column for the sportsbook name and, if relevant, the location.
• Download your annual betting history from each sportsbook and file it with your sheet.
• Keep deposits and withdrawals records from your bank.
• Ask a CPA or tax professional how your state treats gambling winnings and losses, since this is general information and not tax advice.

Our perspective on tracking

We built ParlayGeeks around a simple belief: bettors lose money to bad information and bad habits far more often than to bad luck. A tracking sheet fixes the habit side. Odds comparison, injury news and clear pick reasoning fix the information side.

Manual tracking is the best way to start because it forces you to understand what you are logging. Once you know your own numbers, tools make the process faster. That is why we put a free parlay calculator, a structured BetSlip builder and live odds comparison across sportsbooks in one place, so the price you log is the best one you could have found.

Our approach to premium picks follows the same logic. Each pick comes with its reasoning, so you can log not only what you bet but why, and later judge whether the reasoning held up. Following experts, reading their analysis and checking injury reports before you commit all feed a better log, and a better log feeds better decisions.

Track every bet, shop every line, and review monthly. Do those three things and you are ahead of most of the market.

Roy

Put your tracking to work with ParlayGeeks

Once your sheet is running, you can cut the time spent on research. ParlayGeeks puts odds from multiple sportsbooks next to each other, shows live injury reports, and lets you build a structured BetSlip you can share publicly or keep to yourself.

If you want expert picks with the reasoning shown, our premium plans are Silver at $49 per month, Gold at $99 per month and Platinum at $199 per month. You can also start free at ParlayGeeks with the parlay calculator and odds comparison, and paste what you decide straight into your tracking sheet.

Common mistakes to avoid

• Tracking only winners. The log must include every bet, or the ROI is fiction.
• Mixing bankroll and results. A deposit is not a win.
• Changing columns midway. Adding columns is fine. Redefining them breaks your history.
• Judging on small samples. Review monthly, decide quarterly.
• Ignoring context. Weather and injuries move lines and outcomes. Our guide on weather impact for parlay bettors and the public betting data checks show what to note beside the bet.
• Skipping the why. A one-line note is how you later separate good bets that lost from bad bets that won. It also connects to value betting: you can only judge value if you wrote down what you thought the price should be.

FAQ

What is the easiest way to track bets manually?

Use a spreadsheet with one row per bet and a dropdown for the result. Enter the date, event, bet type, sportsbook, odds and stake when you place the wager, and let a formula calculate profit. Update the result right after the bet settles, and review totals once a month.

What should a bet tracking spreadsheet include?

At minimum: date, sport, event, bet type, odds, stake, result and profit or loss. Add the sportsbook, the number of legs for parlays, the closing odds and a short note on why you bet. Those extras let you compare books, measure closing line value and review your reasoning.

How do I calculate ROI on my bets?

Divide your total profit by the total amount you wagered, then multiply by 100 for a percentage. If you staked $2,500 and finished $125 ahead, your ROI is 5%. Count only settled bets, and treat pushes as a zero-profit bet.

How do I compare odds across sportsbooks?

Look at the same market, with the same line, at several books, and compare American odds directly. When one price is negative and the other positive, convert both to implied probability. Record the price you took, and check settlement rules before you assume two lines are the same bet.

Do I need to keep betting records for taxes?

In the U.S., the IRS allows gambling loss deductions only when you itemize, only up to your winnings, and only with an accurate record supported by documents. Keep your log, tickets and sportsbook statements, and ask a tax professional how this applies to you.

Sources

• Betting 101: How to keep track of your wagers, Yahoo Sports
• Bankroll management for sports betting, explained, Sporting News
• How to Track Your Sports Bets and Keep Accurate Betting Records
• Hard Rock Bet how-to-bet guide
• How Sports Betting Markets Work
• Responsible Gaming: Awareness and Perceived Effectiveness, American Gaming Association
• Americans to Legally Wager Estimated $3.1 Billion on March Madness, American Gaming Association
• Topic no. 419, Gambling income and losses, IRS
• Diary or Similar Record, IRS

Recommended

• U.S. Bettors: Share Bet Slips Without Exposing Your Stake
• 5 Step Live Odds Tracking Workflow Bettors Use With ParlayGeeks
• Value Betting Strategy: How to Find Bets Worth Making
• Lock Your Stakes: Unit Size Betting and a 3 Unit Stop Loss Workflow