How to Make a Sports Betting Spreadsheet in Excel or Google Sheets

Choose a tool and set up your columns

You can build the same sports betting spreadsheet in Excel or Google Sheets. Both support the calculations and number formats used below. Start with a new workbook and put the headings in row 1, using one row for each bet.

Record the odds actually accepted by the bookmaker, rather than a price you saw before placing the bet. Enter money as numbers, not text, so the spreadsheet can use it in calculations.

A downloadable template, tracking app or bookmaker account history can also be useful. Check a template’s formulas and sharing permissions before using it. An individual bookmaker’s history is useful for reconciliation, but it may not combine records from your other accounts.

• A — Date placed: for example, 05/11/2026, stored as a date.
• B — Sport: for example, AFL.
• C — Event: for example, Team A v Team B.
• D — Selection: for example, Team A.
• E — Bookmaker: for example, Bookmaker 1.
• F — Bet type: for example, head-to-head single.
• G — Decimal odds: for example, 2.25.
• H — Cash stake: for example, A$20.00.
• I — Status: Pending, Won, Lost or Void.
• J — Cash return: calculated by formula.
• K — Net profit: calculated by formula.
• L — ROI stake: a helper value used in the summary.

Enter and format a sample bet

Enter the hypothetical example in row 2 using the fields above. Type 20 in H2, rather than typing the currency label into the cell, and select Pending in I2. The return and profit will stay blank until the bet is settled.

Format column A as a date, G as a number, and H, J, K and L as Australian-dollar currency. Displaying a cell as currency changes its appearance, not its underlying value, and does not convert one currency into another.

In desktop Google Sheets, you can set the spreadsheet locale to Australia through File → Settings and choose display formats through Format → Number. In Excel, select the cells and use the number-format controls to choose date, currency or percentage formats. Menu names and positions may vary by version.

Add a dropdown to column I containing Pending, Won, Lost and Void. Google Sheets provides dropdown rules through Data → Data validation; Excel also supports data-validation lists. A dropdown helps prevent misspellings, although it does not check that your odds, stake or settlement are correct.

You can add optional columns after L for the market or line, bet reference, settlement date and notes. A settlement date is particularly useful if you later want to review results by the month in which bets settled, rather than the month in which they were placed.

Add the betting spreadsheet formulas

Enter the following formulas in J2, K2 and L2, then fill them down the corresponding columns. They use English function names and commas between arguments. Depending on your spreadsheet’s language and locale settings, you may need different function names or separators.

J2 calculates the cash return. For a win it multiplies the accepted odds by the stake and rounds the result to cents; for a loss it returns zero; and for a fully void bet it returns the stake. It leaves the result blank when the status is pending or unrecognised, or when the odds or stake are missing or invalid.

J2: =IF(OR(NOT(ISNUMBER(G2)),NOT(ISNUMBER(H2))),"",IF(OR(G2<=1,H2<=0),"",IF(I2="Won",ROUND(G2*H2,2),IF(I2="Lost",0,IF(I2="Void",H2,"")))))

K2 calculates net profit by subtracting the stake from a numeric return. A blank return remains blank rather than being treated as a loss.

K2: =IF(ISNUMBER(J2),J2-H2,"")

L2 includes the stake in the ROI denominator only when a won or lost row has a calculated profit. Pending bets, fully void bets and invalid entries contribute zero.

L2: =IF(AND(OR(I2="Won",I2="Lost"),ISNUMBER(K2)),H2,0)

Return and profit are different. If the hypothetical A$20 bet at 2.25 wins, its calculated return is A$45, including the original stake. Subtracting the A$20 stake gives a profit of A$25.

These formulas have not been tested in current versions of both Excel and Google Sheets. Test them in your application before relying on the tracker. Actual operator payouts, deductions and rounding can differ, so reconcile the calculated amount against the settlement record.

Test every status before recording real bets

Fill the formulas down through at least row 5, then enter the following hypothetical odds, stakes and statuses. The figures are arithmetic expectations, not a claim that the formulas have been tested in your software. Amounts are in Australian dollars.

• Row 2: odds 2.25, stake A$20, Won. Expected return A$45, profit A$25 and ROI stake A$20.
• Row 3: odds 2.00, stake A$10, Lost. Expected return A$0, profit −A$10 and ROI stake A$10.
• Row 4: odds 1.50, stake A$15, Void. Expected return A$15, profit A$0 and ROI stake A$0.
• Row 5: odds 1.80, stake A$30, Pending. Expected return and profit blank, with ROI stake A$0.

Check invalid entries and copied formulas

Try a row with blank odds, odds of 1 or less, a zero stake and a stake entered as text. Also try a misspelt status and a completely blank row. Return and profit should remain blank for those inputs; the ROI helper should show zero. A blank result signals that the row needs attention, not that the bet lost.

Check that formulas copied to later rows refer to the odds, stake and status in their own row. If a formula produces an error, check the brackets, separators and function language. Once the summary below is in place, test a valid row beyond row 1000: it should demonstrate that the fixed summary ranges need extending.

Keep a copy of your test sheet or remove the hypothetical rows before entering real records. Do not mix test bets with actual results.

Create a settled-results and ROI summary

A betting ROI spreadsheet needs a clear definition of what counts. Here, ROI means net profit divided by the cash stakes on valid settled wins and losses. Some trackers call this yield and use ROI for a calculation against starting bankroll instead.

Pending bets are excluded because they have not settled. Fully void bets are also excluded from this guide’s denominator: their stake is refunded and their profit is zero. This is a reporting choice, not the only possible convention.

Place the following labels in M2 to M6 and the corresponding formulas in N2 to N6. Format N2, N3, N4 and N6 as currency and N5 as a percentage.

• M2: Won/lost cash stake included in ROI. N2: =SUM(L2:L1000)
• M3: Won/lost returns. N3: =SUMIFS(J2:J1000,I2:I1000,"Won")+SUMIFS(J2:J1000,I2:I1000,"Lost")
• M4: Total net profit, including zero-profit voids. N4: =SUM(K2:K1000)
• M5: ROI. N5: =IF(N2=0,"",N4/N2)
• M6: Refunded void stakes. N6: =SUMIFS(J2:J1000,I2:I1000,"Void")

Understand and check the summary

For the four test rows, the expected summary is A$30 in won/lost stake, A$45 in won/lost returns, A$15 in net profit, 50% ROI and A$15 in void refunds. The ROI is A$15 divided by A$30. The pending A$30 stake does not enter that calculation.

All settled returns in the example total A$60 when the A$15 void refund is included. Showing the refund separately makes it easier to distinguish returned void stakes from returns on won and lost bets. When there are no valid won or lost stakes, the ROI cell remains blank to avoid division by zero.

The summary formulas cover rows 2 to 1000 only. Extend every relevant range consistently when your records go beyond row 1000, including the ranges in both parts of the won/lost returns formula. Check the results again after making changes.

A positive result in a small set of bets does not establish reliable long-term performance. Missing bets, incorrect stakes and the choice of date used for reporting can also distort the picture.

How to track sports bets and reconcile them

Enter each cash single consistently, then update its status after settlement. Compare the recorded return with the bookmaker’s account history rather than assuming that every payout matches the formula. Investigate differences before using the row in a review.

For a wider picture, include records from each account you use. A bet reference can help you find the original transaction, while a settlement date makes it easier to report results for a particular month. Keep placement and settlement dates distinct.

You can build separate criteria-based summaries for a sport, bookmaker or bet type. Be careful when filtering: ordinary SUM and SUMIFS formulas do not necessarily change to include only visible rows. Use a separate criteria-based summary or verify a filtered-subtotal method before drawing conclusions.

• Check the accepted decimal odds and actual cash stake.
• Confirm that every settled bet has the correct status and that pending bets remain pending.
• Compare the calculated return with the cash credited by the operator.
• Look for missing or duplicated bets, including records from other accounts.
• Check that new rows fall within the summary ranges.

Keep complex bets outside the basic formulas

The one-status formula is deliberately narrow. Different products can have different settlement rules, so keep these bets outside the basic tracker unless you have designed and tested a separate workflow for their actual returns.

For cash-outs, partial settlements or deductions, the amount credited may not equal the original stake multiplied by the accepted odds. Record those results separately or exclude them from this version. Do not simply overwrite a formula cell without a clear way to preserve and maintain the record.

• Multis: Record the individual legs and the actual settlement. Sportsbet says a void leg in its standard multi is removed and the remaining legs are recalculated; its same-game products can be treated differently. Other providers’ terms may differ.
• Each-way bets: Track the win and place components separately, including their stakes, prices and results. A single status cannot represent a losing win component alongside a place return.
• Exchange bets: Capture whether the bet is a back or lay, the matched stake, liability, market ID and commission. Betfair Australia describes lay liability separately from the backer’s stake and commission on net market winnings. A market-level charge should not be subtracted from every row without a defined allocation method.
• Bonus bets: Keep promotional value separate from cash stake. Sportsbet and TAB describe bonus bets where the bonus stake is not returned with winnings; that does not establish a rule for every offer. Check the relevant terms before designing a calculation.

Protect your records and review spending honestly

Restrict access to your file, secure the account that holds it and keep a backup. Avoid storing passwords, identity documents or payment-card details in the sheet. Protecting individual cells can reduce accidental edits, but it is not a substitute for securing the file and account.

A tracker can make stakes and realised losses easier to see, but it is not a spending lock. If gambling is causing concern, Gambling Help Online provides free, confidential support across Australia, including 24/7 phone and online support. The Gambling Helpline is 1800 858 858.

BetStop allows self-exclusion from Australian-licensed online and phone wagering providers for a minimum of three months. It does not cover every form of gambling or every physical venue. You can also check an interactive wagering provider through the Australian Communications and Media Authority’s register.

FAQ

Can I make a betting tracker spreadsheet in Excel or Google Sheets?

Yes. Both support the formatting and conditional-sum functions used in the A–L layout. The formulas have not been tested in current versions of both applications, so check the test cases in your chosen version before relying on them. Menus, function names and argument separators can vary.

How do I calculate profit on a sports bet?

For an ordinary settled cash single, subtract the cash stake from the cash return. In the hypothetical example, an A$45 return minus the A$20 stake gives A$25 profit. A loss with no return produces a loss equal to the stake. Cash-outs, deductions and other adjustments require the actual settlement to be checked.

Should pending or void bets count towards ROI?

This guide excludes pending bets because they have not settled. It also excludes fully void bets from the ROI denominator, while recording their refunded stake and zero profit. For example, the test row’s A$15 void refund appears separately. Other trackers may use a different definition, so compare conventions before comparing results.

Can the same spreadsheet track multis or bonus bets?

It can be adapted, but the basic formulas are not sufficient for every settlement. Multis need leg details and the actual settled return, particularly when a leg is void. Bonus-bet value should be kept separate from cash stake. Check the provider’s product terms and test any separate workflow before including those results.

Why is my betting ROI cell blank?

The N5 formula stays blank when N2 contains no valid won/lost stake. Check whether all bets are pending or void, whether odds and stakes are valid numbers, and whether statuses match the dropdown labels. Also check that your bets are within rows 2–1000 and that the formulas were copied correctly. A formula error may instead indicate a separator or function-language mismatch.

Does filtering the sheet show ROI for only the visible bets?

Not necessarily. The ordinary SUM and SUMIFS formulas in this guide use their specified ranges and criteria; hiding rows with a filter does not automatically make the summary a visible-rows-only report. Build a separate criteria-based summary or test a suitable filtered-subtotal method before using a filtered view to assess results.