Bankroll & records · 7 min read
Reconcile a bankroll without mistaking deposits for profit
A worked cash ledger shows how stakes, settlements, refunds and deposits differ, with a practical checklist for duplicate-safe import provenance.
By Stakesift editorial
Published · Updated
A balance is a stock of money at a point in time. Profit is a result over a period. They answer different questions. A deposit increases available cash without improving performance; placing a bet reduces available cash before you know whether it will win. Reconciliation connects those movements without pretending they are the same thing.
Define what your balance includes
Begin with one account, one currency, a stated opening time and a stated closing time. Determine whether the source's balance means available cash, cash including reserved stakes, or cash plus positions. The following example assumes a cash-funded sportsbook subtracts the stake when a bet is placed and credits the full returned amount when it settles. Do not apply that convention unchanged to an exchange using collateral or to a statement that already includes reserved funds.
Separate withdrawable cash, restricted promotional credit, open stakes and settled net result. A $50 bonus that cannot be withdrawn is not $50 of cash. An unsettled $30 stake is exposure, not a $30 realized loss. Use a separate valuation policy if you want to mark open positions to market; stake cost is not a guaranteed liquidation value.
A complete cash bridge
| Movement | Cash effect | Meaning |
|---|---|---|
| Opening cash | $1,000 | Starting balance |
| Deposit | +$200 | External funding, not profit |
| Withdrawal | −$100 | External outflow, not a betting loss |
| Four stakes placed | −$140 | $50, $40, $20 and $30 committed |
| $50 bet wins; total return $95 | +$95 | $50 principal plus $45 profit |
| $40 bet is voided | +$40 | Stake refunded; zero net result |
| $20 bet loses | $0 | Stake already deducted; net result −$20 |
| $30 bet remains open | $0 | No settlement yet |
| Closing available cash | $1,095 | $1,000 + $200 − $100 − $140 + $135 |
Settled net result is $45 + $0 − $20 = $25. Gross settlement credits are $135, not $135 of profit. The $95 rise in cash is not $95 of profit either: it includes $100 of net external funding and excludes the $30 still committed to the open bet.
For this cost-based bookkeeping example, cash plus open stake cost is $1,095 + $30 = $1,125. Subtract the $1,000 opening balance and $100 net external funding to recover $25. This identity assumes no opening open positions, fees, promotional conversions or other adjustments. It is a reconciliation bridge, not a claim that the open bet can be sold for $30.
Why importing the same file twice is not the only duplicate risk
An export can repeat the same ticket across overlapping date ranges. A later export can also describe that ticket in a new state: pending, then settled, then corrected. Treating every appearance as a new wager overstates turnover. Treating every repeated ticket ID as something to discard can lose its legitimate settlement update.
- Exact replay: the same source record already recorded for the same account should not create another financial movement.
- State update: the same ticket with a later settlement is an update to its lifecycle, not a second stake.
- Distinct tickets: identical event, stake and price do not prove duplication. Two separate tickets may legitimately match those fields.
- Corrections: a revised payout needs a traceable correction, not silent deletion of the original evidence.
A source-provided transaction or ticket identifier is stronger evidence than a guessed fingerprint. Scope identifiers to the source and account: different accounts can reuse the same identifier. If IDs are missing, use a conservative matching policy and review ambiguous rows rather than automatically merging them.
Preserve provenance before calculating performance
- Keep the source account, file or batch reference, source row identifier, import time and original event time distinct.
- Preserve currency, timezone and the source's meaning of payout: total return or profit-only. Never infer that meaning from a positive number alone.
- Preview parsed rows and confirm statuses. Missing settlement is unknown, not automatically a loss.
- Compare opening cash plus net movements with the source's closing statement at the same cutoff.
- Investigate any difference: missing withdrawals, fees, bonuses, cash-outs, resettlements and timezone boundaries are candidates, not excuses to insert a balancing profit.
Transfers between your own accounts should not count as aggregate profit or new aggregate funding. Pending deposits and withdrawals need their own status. Exchange-rate changes can also alter a combined reporting-currency total without any wagering gain; preserve native-currency balances before conversion.
Review before relying on the totals
Open the imports workspace (signup required) to review your records. This checklist describes sound recordkeeping, not a promise that every source format or account connection is supported. Once the ledger reconciles, connect it to net costs and execution and an honest historical evaluation. Redact account identifiers before sharing evidence, and keep original statements private.