Use one master ledger
The master ledger begins with the external amount allocated under the budget. Operator, exchange, strategy, and currency views are sub-ledgers of that amount. Do not add their starting balances together if the same cash transfer moved between them.
| Layer | Record |
|---|---|
| Household boundary | Money explicitly outside gambling |
| Master bankroll | Allocated cash, deposits, withdrawals, net result, open exposure |
| Operator sub-ledger | Cash balance, bonuses, pending withdrawals, unsettled bets |
| Strategy tag | Stakes and results attributed to one locked rule |
| Currency ledger | Native amount, conversion rate, fees, base-currency value |
Worked reconciliation
An illustrative master bankroll starts at GBP 100. GBP 100 is deposited, GBP 20 is later withdrawn, GBP 70 remains as withdrawable operator cash, and GBP 10 is committed to unsettled bets.
Withdrawn 20 + cash 70 + open exposure 10 = opening 100
This check assumes no settled profit or loss. If a bet settles or a fee is charged, add it as a separate transaction. Do not count both the original stake and an inclusive displayed balance if the operator has already deducted that stake.
Separate by purpose, not by imagined safety
Useful tags can distinguish model versions, market types, or settlement currencies. They do not make dependent bets independent or protect household money unless the external budget is actually enforced.
Avoid creating a new bankroll after every loss or moving losing bets into a hidden category. Strategy transfers need a timestamp, amount, source, destination, and reason.
Operator concentration and customer funds
Cash held with an operator creates access and insolvency exposure in addition to betting risk. In Great Britain, operators must disclose how customer funds are protected; the Gambling Commission consumer guide explains that protection levels vary. This is not a recommendation to hold funds with multiple operators, and rules differ elsewhere.
Reconcile in both directions
At least monthly, verify:
- master ledger cash equals the sum of sub-ledger cash after currency conversion;
- every deposit and withdrawal appears in both the bank record and operator ledger;
- open stakes and lay liabilities match live receipts;
- voids, commission, bonuses, and adjustments have separate entries;
- strategy totals sum to the master settled result;
- no household transfer is omitted or relabelled as profit.
The household budget should be built from accurate income and spending records; MoneyHelper provides the external budgeting method. If separation is being used to conceal or chase losses, GamCare's money guidance is the more appropriate next step.
Handle currency, bonuses, and pending cash
Keep native-currency amounts and the base-currency conversion used for each snapshot. Record conversion fees and do not rewrite historical results at today's exchange rate. Pending withdrawals remain a separate receivable state until cash reaches the external account; they are not available bankroll in both places.
Treat bonuses and free-bet credits as restricted instruments with their own expiry and settlement terms, not as cash deposits or profit at receipt. Reconcile their value only when a defined cash outcome occurs. A master ledger should be able to remove every bonus row and still reconcile real cash. This prevents promotional balances from inflating capital or disguising additional household transfers.
Next step
Use Bankroll Spreadsheet Template for the next part of this topic.
Continue learning
- Next guide: Stake Sizing Across Bet Types
- Related guide: Stop-Loss Betting Rules
Assumptions and limitations
The example ignores bonuses, exchange liability, pending withdrawals, chargebacks, taxes, and currency movement. A spreadsheet cannot guarantee access to operator funds or prevent additional deposits. Separate records improve auditability; they do not create diversification, profit, or affordability.

