Download the sample workbook and duplicate it before replacing the example rows. Use it to reconstruct what happened to money you have already staked, even if you keep several bookmaker accounts.
Download the free Excel workbook (.xlsx)
Set up the columns
Keep one row per bet. Record the date, bookmaker, event, stake, decimal odds, status and amount returned. Put enough detail in the event or notes field to identify the original bet slip. A multiple belongs on one row; the legs are notes, not separate stakes.
Enter the paid return
Use the amount actually credited by the bookmaker. For a £10 winning bet at decimal odds of 2.30, a £23 return includes the £10 stake. For a loss, enter zero. For a full refund, enter £10. Leave returns blank while the bet is open. The workbook calculates net profit once both the stake and return are entered.
| Status | Stake | Return | Profit |
|---|---|---|---|
| Won | £10 | £23 | +£13 |
| Lost | £10 | £0 | −£10 |
| Refunded | £10 | £10 | £0 |
| Open | £10 | — | — |
Settled cash profit in this example is £3. Open bets are excluded. The workbook summary divides £3 by £30 of settled stakes, with refunded stakes included in that denominator.
Keep balances and results separate
The summary uses the cash stakes and returns on completed rows. Deposits and withdrawals belong in the transactions sheet. Use one currency per workbook. For a weekly review, keep a copy of the original statements and check the dates on the latest corrections before comparing weeks.
