Bet Tracker: Free Template to Track Every Wager and ROI

A bet tracker is a record you fill before the memory rewrites the ticket. Sportsbook history screens hide the price you could have had at close, and they bury voids inside a profit graph. Your sheet should be boring enough that a bad Saturday still fits on one row.

The point is not motivation. The point is arithmetic you can audit. Net profit without the stake is a mood. A closing number you did not write down becomes "I knew it" after the game. Closing line value is the habit of storing that number. Implied probability is how you turn the odds into a percent before you decide the row was a price you understood.

This is not a bankroll-management guide. It does not tell you what fraction of a roll to put on a spread. Sizing is a different subject. Here the stake column is a fact about a ticket you already placed, or are about to place. The loss limit you refuse to cross lives on gambling budget. Use that page for the ceiling. Use this page for the rows under it.

Sports betting guides is the cluster if the markets themselves are still fuzzy. Adults 18+ only. PVPspinArena is not a sportsbook, so it will not fill this sheet for you. Fairness checks Jackpot, Coinflip and Roulette. Jackpot is a pot with a different kind of record. Responsible gambling matters more than a perfect spreadsheet if you are logging to justify the next deposit.

Copy this header into a sheet. One wager, one row. Parlays get their own rows only if you also store each leg somewhere else. A parlay that you cannot decompose will teach you nothing except that the payout was large or zero.

Add a notes cell if you want the market name, the book, or a one-line reason. Do not add a cell for how the bet "felt." Feelings do not sum. If the closing line is blank because the market was a tiny prop with no close, write "no close" instead of inventing a number. A blank that looks like a zero will corrupt the average later.

Grade the result from the rule, not from the highlight. A one-goal hockey win can lose a puck line. A draw can refund draw no bet. The result column should match the settlement, or the ROI is a fiction. Profit on the row is a formula: American minus 110 on a win pays stake times 100/110. A loss is minus the stake. A push is zero profit and, in the ROI below, the stake is removed from the denominator so a refund is not punished as volume. Be consistent. Write the choice at the top of the sheet.

ROI is net profit divided by total stake, expressed as a percent. Profit of $10 on $100 staked is 10% ROI. Profit of −$10 on $100 is −10% ROI. Winning six bets out of ten does not tell you the ROI until you know the prices. A bettor who wins often at very short odds can still be down. A bettor who wins rarely at long odds can be up. The sheet is the only place those patterns stay honest.

Closing line value sits in the last column so you can separate "the ticket won" from "the price was good." You beat the close when you took a better number than the market's last number on that side. Plus 150 beaten by a close of plus 130 is a win on price, whether the club wins or not. Minus 110 that closes minus 105 is a worse price than the close. The bet can still win. The log should say you did not beat the number.

Leaks are rows that repeat. The same market you cannot explain. Live bets after a loss, with worse prices than your pre-game rows. Stakes that jump after a void because the refund felt like a start. A month of those rows is more useful than a tip. You do not need a model. You need the sort function.

Do not drop losing rows because the book voided a different bet, and do not add imaginary clv. If you forget the close, the cell stays "no close." Pretending every win beat the market is how a tracker becomes advertising.

A small sample will bounce. Twenty bets can show a shiny ROI that ten more bets erase. Report the count next to the percent. ROI of 15% over 12 wagers is a story with a denominator. ROI of 2% over 400 wagers is a different kind of sentence. This page will not tell you which of those you "should" have. It will tell you not to hide the count.

Illustration only. None of these events is a recommendation. Stakes are cash. Pushes are left out so the denominator is obvious. American profit is rounded to the cent.

Net profit is 25 − 25 − 25 + 22.73 = −$2.27. Total stake is $100. ROI is −2.27%. You won two bets and lost two, and you are down, because the total win paid less than a full $25 after juice.

Read the closes without being romantic. The NHL row won the bet and did not beat the close: you took plus 100 and the side closed minus 105, a shorter price you missed. The MLB row lost the bet and also failed the close if minus 150 is worse than a close of minus 140. The soccer row lost, and the close of plus 110 was a better price than the plus 100 you took, so you missed the close there too. The NBA row won and matched the close. Matching is not beating. The week is a small loss with three prices that were worse than, or only equal to, the close. That is a leak you can see. "I went 2 and 2" hides it.

If the NBA row had pushed, profit on that row would be $0 and, under the rule at the top of this guide, you would drop that $25 from the denominator. Net would be −$25 on $75 staked. Write the rule once so next month's push does not get counted as a win.

Second illustration. You bet an underdog at plus 150. Decimal odds are 2.50. Implied probability is 100/250, which is 40%. At close the same side is plus 130. Decimal 2.30. Implied about 43.5%.

You held the longer number. A simple price gap is 2.50 / 2.30 − 1, about 8.7% more decimal than the close. Record "beat close" on that row even if the underdog loses. Closing line value is a quality check on the number, not a second result column. One beaten close is not a career. It is a row. Fifty rows that beat the close, with the count written beside them, are the start of a question about whether your prices are early. Fifty rows that lose to the close are a leak, even if a few longshots paid for a loud weekend.

The stake on this illustration does not change the percent gap. A $10 bet and a $200 bet at the same plus 150 against the same plus 130 have the same price gap and very different damage. The tracker shows both. If the $200 rows are always the live bets after a loss, the leak is the timing, and gambling budget is the ceiling you already set or failed to set. This sheet will not invent a unit size to repair that.

Voids stay in the log with result "void" and profit zero. Deleting them makes the next month look cleaner than the year you lived. Bonus stakes get marked, because a payout that does not return stake will overstate ROI if you pretend the token was cash. That trap has its own guide. Do not hide it inside an ordinary win.

Fill this before you look at the profit color.

• Date, sport, odds, stake, result, and closing line are all present, or the close says "no close."
• The result matches the market rule, including pushes and refunds.
• Profit is a formula from the odds and the stake, not a number you remember.
• ROI uses net profit over total stake, and the bet count is written next to the percent.
• Beating the close is marked separately from winning the bet.
• Bonus tokens are labeled so stake-not-returned does not pretend to be cash ROI.
• You are 18+. The sheet is not a reason to deposit. A loss limit already exists outside the grid.

Spotting leaks is sorting, not a new strategy. Sort by market. Sort by live versus pre-game. Sort by whether you beat the close. The clump that loses money at bad prices is the leak. You do not need to name it after a system. You need to stop repeating the row.

PVPspinArena will not store your hockey prices or compute a closing line. The games here are Jackpot, Coinflip and Roulette. Fairness lets you check a reveal. It does not grade a run line. Jackpot is a pot you can watch settle. It is not a wager log for a league.

Keep the template small so you will actually fill it. Six columns beat a dashboard you abandon on Sunday. Adults 18+ only. If the sheet becomes a way to argue yourself into a larger stake, close it and keep the loss limit instead.