Use one row for each bet or ticket. Record the accepted details when you place it, then add the result and the actual return once the wager is fully settled. A clear ledger separates stake from gross return, flags unsettled bets, and lets you reconcile each entry with a receipt or account history.
What to record for each bet
Use columns that identify the wager and show how it was settled. A practical layout is:
- Bet ID: a unique number or label for the row.
- Date and time placed: when the bet was accepted.
- Bookmaker or tote: the operator that accepted the wager.
- Track or meeting: where the race took place.
- Race number or time: enough detail to identify the event.
- Selection: the horse or other selection on the ticket.
- Bet type: such as win, place, each-way or forecast.
- Accepted odds and odds format: preserve the odds shown on the ticket and label them as decimal, fractional or American.
- Stake: the amount risked, with the currency recorded or kept consistent throughout the sheet.
- Settlement status and result: for example, open, settled, void/refunded, won or lost.
- Gross return actually credited: the total amount returned, including the stake if that is how you define the column.
- Net profit/loss: calculated using a clearly stated convention.
- Payout date: when winnings were paid, if applicable.
- Receipt or account-history reference and notes: so you can check a corrected, disputed or unusual settlement.
This detail also makes it easier to compare a personal record with the operator’s transaction history. The UK Gambling Commission’s guidance for licensed pool-betting operators lists minimum transaction details including the bet date, stake, track and race or pool identity, selection, winnings and the date winnings were paid. It includes “the date on which the bet is made.” This is UK operator-facing guidance, not a personal legal checklist or a rule for every type of betting account. UK Gambling Commission guidance.
How to calculate profit or loss
First decide what the return column means. For straightforward, fully settled cash wagers, if gross return includes the returned stake, net profit/loss is gross return minus stake. A losing bet with a zero return therefore has a loss equal to the negative stake.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →#1 Best Overall
For example, if a settled bet has a stake of £10 and £24 is actually returned, net profit is £14: £24 − £10. If the bet loses and nothing is returned, net profit/loss is £0 − £10, or −£10. These are arithmetic examples, not odds predictions.
If your return column records winnings excluding the returned stake, label it that way and use a formula consistent with that definition. Do not mix the two conventions: doing so can overstate or understate results.
Rank #2
- Ideal for Gifting
- Ideal for a bookworm
- Compact for travelling
Example spreadsheet formula
If the stake is in column J and gross return, including any returned stake, is in column M, enter =M2-J2 in the net profit/loss cell for row 2. Copy the formula down only for straightforward, fully settled cash wagers whose return is recorded consistently. Leave open bets out of settled totals.
How to handle open, void and unusual settlements
Do not treat every row as a standard win or loss. Use an explicit status so unsettled entries cannot be mistaken for final results:
- Open: the race, settlement or payout is not yet final. Do not include it in settled profit/loss.
- Settled: enter the final result and the actual credited return before calculating net profit/loss.
- Void or refunded: record the status and the amount actually returned; do not assume the stake was either lost or returned without checking the ticket.
- Partially settled: record what has been paid and what remains unresolved, rather than forcing the whole wager into a win/loss formula.
For each-way bets, dead heats, free bets and other nonstandard settlements, use the actual return and stake treatment shown by the ticket and the applicable bookmaker rules. A single generic odds formula may not represent how those wagers were settled.
How to review the spreadsheet
Once individual rows are complete, filters or a separate summary view can help you group settled results by month, bookmaker, track, flat or jumps racing, or bet type. Keep open and partially settled entries distinct from final results when making those summaries. A spreadsheet is a record of what you staked and what was returned; it does not establish a betting edge or show that past results predict future returns.
Rank #4
Keep personal tracking separate from operator reporting
The Gambling Commission’s pool-betting guidance concerns records licensed operators must retain in Great Britain. Its regulatory-return guidance also describes gross gambling yield (GGY) as an operator reporting measure, not an individual punter’s profit formula. UK Gambling Commission guidance on regulatory returns. A personal ledger is useful for recordkeeping, but it is not a substitute for jurisdiction-specific tax or legal advice.
Quick Recap
Best Value
- It can be a gift option
- Comes with secure packaging
- Helpful in various ways
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
