Contents
Balance change alone cannot verify betting profit or loss: use betting history and account transactions for the same scope, join them by ticket ID, and include only settled cash wagers in the settled net result. In the synthetic example below, turnover is USD 80.00, gross cash returns are USD 83.40 and the settled net result is +USD 3.40. The USD 10.00 open stake is shown separately and excluded from that result.
Gross cash returns include the returned stake where applicable. They are not net profit: you still need to subtract cash stakes and fees.
How to collect the records for reconciliation
Collect two sets of records for the same account period: betting history and account transactions. If no export is available, use the available history view and preserve the original details. There is no universal export button or standard operator column set.
- Define the scope: account, currency, period boundaries, time zone and ticket inclusion rule. The example below uses settlement date and preserves placement time separately.
- Save the betting history and account transactions. Record the filters used and each source filename.
- Match ticket IDs in both directions. Look for tickets without corresponding transactions and betting transactions without a ticket in the betting history.
- Flag exceptions. Missing tickets, unexplained returns and conflicting statuses need investigation, not guessed values.
- Separate funding and other account movements. Deposits, withdrawals, transfers between products and bonus credits are not betting outcomes.
Minimum fields to preserve
Preserve the following fields where available, and mark missing values as unknown. These are requirements for your reconciliation, not a promise about an operator’s export.
| Field | What to record |
|---|---|
| Operator / account | Operator name and account identifier |
| Currency | The currency used for each calculation |
| Ticket ID | The key used to match account transactions |
| Placement time and time zone | Original placement date, time and time zone |
| Settlement time | Used to determine inclusion in the period |
| Event / market / selection | What the wager covered |
| Accepted odds | The odds actually accepted, not current odds |
| Bet type | For example, a single or a multiple |
| Stake funding source | Cash, bonus funds or a mixture |
| Cash and bonus portions | Separate amounts |
| Status | Open, won, lost, void, cashed out or another recorded status |
| Actual gross cash return | Cash returned on settlement, including the stake where applicable |
| Fees | Costs recorded separately |
| Product | Used to separate sports betting from other products |
| Source reference / filename | Where the original record can be checked |
| Multiple details | Overall ticket result and individual leg statuses, if supplied |
How to calculate turnover, returns and net result
Calculate all three measures from the same set of settled tickets using the same period rule. Here, turnover includes settled void stakes and excludes open stakes.
- Turnover = total cash stakes on settled tickets within the declared scope.
- Gross cash returns = actual gross cash returns from those same tickets.
- Settled net result = gross cash returns − cash stakes − fees.
You can cross-check the result against the available cash balance:
Settled net result = ending available cash balance + open cash stakes − starting cash balance − deposits + withdrawals.
This check requires a complete account of cash movements. Add open cash stakes only when the ending available balance has already been reduced by those stakes. Reconcile bonus balances and transfers between products separately; do not bury unexplained movements in the betting result.
Diagram using synthetic data: bet history and account transactions matched by ticket ID; result +3.40 USD.This diagram uses synthetic data to match bet history and account transactions by ticket ID; the settled net result is +3.40 USD.
Synthetic ledger: from tickets to the result
The synthetic ledger produces a settled net result of +USD 3.40. All figures are illustrative USD data, not operator data. The selected account period is 1–8 October 2026, inclusive, in UTC; the settled tickets fall on 1–6 October, while the account transaction ledger extends through 8 October. Tickets are included by settlement date, with placement time preserved separately.
| Ticket | Placed, UTC | Settled, UTC | Status | Cash stake, USD | Accepted odds | Gross cash return, USD | Net result, USD |
|---|---|---|---|---|---|---|---|
| B001 | 2026-10-01 12:00 | 2026-10-01 15:00 | Won | 20.00 | 1.90 | 38.00 | +18.00 |
| B002 | 2026-10-02 12:00 | 2026-10-02 16:00 | Lost | 15.00 | 2.10 | 0.00 | −15.00 |
| B003 | 2026-10-03 12:00 | 2026-10-03 14:00 | Void | 12.00 | 2.50 | 12.00 | 0.00 |
| B004 | 2026-10-04 12:00 | — | Open | 10.00 | 2.30 | — | — |
| B005 | 2026-10-05 12:00 | 2026-10-05 13:00 | Cashed out | 25.00 | 2.00 | 19.00 | −6.00 |
| B006 | 2026-10-06 12:00 | 2026-10-06 15:00 | Settled; reconstructed from transactions | 8.00 | Missing from bet export | 14.40 | +6.40 |
The odds are preserved as supplied; no odds conversion or inference is used. Fees are USD 0.00. Amounts are stated to the nearest cent, so no further rounding is needed. This example assumes cash-funded stakes, no transfers between products and separate accounting for the bonus credit.
83.40 − 80.00 − 0.00 = +3.40 USD.
Exceptions that need an audit trail
B003, B004 and B005 need different treatment, while B006 demonstrates why betting history alone is insufficient. An open bet has an open status and no settlement time; in account transactions alone it looks exactly like a loss—only a stake debit with no return—so you must check its status in the betting history. A void bet shows a settlement time and a return equal to the stake.
- B003 — void. Its USD 12.00 cash stake remains in turnover under the declared convention. The gross cash return is USD 12.00 and the net result is USD 0.00. Keep the row. A void leg within a multiple may be treated differently under the applicable rules; do not apply this whole-ticket example automatically.
- B004 — open. Its USD 10.00 cash stake is excluded from the settled net result. It is the total open exposure in this simple full-stake-loss example, not a settled loss or an expected loss.
- B005 — cashed out. Use the actual cash-out return of USD 19.00 against the USD 25.00 stake, giving a result of −USD 6.00. The original odds of 2.00 cannot reconstruct the actual cash-out return.
- B006 — missing from the bet export. Matching ticket IDs reveals account transactions of −USD 8.00 and +USD 14.40. These confirm the cash stake and gross cash return; the odds remain unknown. Mark the row as reconstructed from transactions rather than presenting it as an original export row.
How to cross-check account transactions and balances
The balance check also produces +USD 3.40, provided the bonus credit is kept separate from cash funds.
| Transaction class | Amounts, USD | Treatment |
|---|---|---|
| Deposit | +100.00 | Account funding, not profit |
| B001 | −20.00; +38.00 | Cash stake and gross cash return |
| B002 | −15.00 | Lost cash stake |
| B003 | −12.00; +12.00 | Cash stake and full void return |
| B004 | −10.00 | Open cash stake |
| B005 | −25.00; +19.00 | Cash stake and cash-out return |
| B006 | −8.00; +14.40 | Evidence for the missing ticket |
| Bonus credit | +5.00 | Separate bonus accounting |
| Withdrawal | −40.00 | Money withdrawn, not a betting loss |
| Transfers between products | None in this example | Reconcile separately if present |
The starting cash balance is USD 100.00 and the ending available cash balance is USD 153.40. The on-screen balance may show USD 158.40 including the USD 5.00 bonus; the formula uses the USD 153.40 cash balance without the bonus. The withdrawal belongs to the selected account period, not to betting profit or loss:
153.40 + 10.00 − 100.00 − 100.00 + 40.00 = +3.40 USD.
The USD 5.00 bonus credit is excluded from this formula and is not cash betting profit. For a free bet or bonus bet, check the actual terms: whether the promotional stake is returned on a win, whether it is not returned, and whether resulting funds can be used or withdrawn. The word “bonus” alone does not establish any of these conditions.
This distinction also matters for bankroll management: a deposit increases account funds but does not improve the betting result.
Official PokerStars history routes: 16 October 2026
As of 16 October 2026, PokerStars’ public help documents two distinct routes: viewing sports bets and requesting a date-range account history. The articles are titled “How can I check my betting history?” and “Requesting playing history audit” (PokerStars Help, European site, captured 16 October 2026). This is a dated account of public documentation, not a description of an inspected authenticated interface. Availability and layout may vary by product, platform and region. From some countries, including Russia, the help pages are unavailable and redirect to an exit page.
The official sports history help page documents these interface labels:
My Bets— the bet-history area;Open— open bets;Settled— settled bets;Historical Bets— a separate tab in the same window for older bets placed before the date shown there; when reconciling a long period, check both the current views and this tab.
Where available, use these views to check tickets and their statuses. The documentation does not establish a universal export button or a specific sportsbook export column set.
Separately, the official Playing History Audit instructions describe the Playing History Audit section, including a date-range selection and Excel 97–2003, HTML or TXT formats. The help says you create a password to protect the file and receive an email with download instructions. That history covers deposits, withdrawals, transfers and playing history.
This audit request is not the same as viewing open and settled sports tickets. Check the resulting file for the fields you need; neither direct compatibility with this reconciliation method nor compatibility with ToolsGambling is guaranteed.
What history access does GB RTS 1 require?
For operators subject to Great Britain’s RTS 1, at least three months of history must be easily accessible, with at least 12 months available on request. This is a jurisdiction-specific requirement, not a universal retention period.
UKGC RTS 1 lists history categories including deposits, withdrawals, transfers between products, bonus information, bets, results and winnings paid. The RTS 1 page was updated on 7 May 2024 and checked on 16 October 2026.
Under RTS 1C, net deposits are cumulative deposits minus withdrawals over the lifetime of the account, not the betting result. In the synthetic example, the same difference is calculated for the selected period: USD 100.00 − USD 40.00 = USD 60.00, while the settled net result is +USD 3.40.
What can you transfer to ToolsGambling?
The ToolsGambling bet tracker is an optional analysis layer after reconciliation, not a connection to an operator. An unknown status from an operator file (for example, cashed_out or settled) is silently converted to pending by the tracker, and rows with errors are skipped, so map statuses before import. Its exact CSV schema is:
date,event,sport,bookmaker,odds,stake,status
These fields represent the date, event, sport, bookmaker, odds, stake and status. The accepted status values are:
| CSV value | Meaning |
|---|---|
pending | Awaiting settlement |
won | Won |
lost | Lost |
void | Stake returned; neither won nor lost |
The tracker’s cash totals include settled bets marked won, lost or void; pending stakes are shown separately. For a void bet, the return is treated as equal to the stake.
The schema has no ticket ID, settlement time, actual gross cash return, cash-out field, bonus fields, fees, deposits or withdrawals. It also lacks dedicated fields for currency, account identifier, time zone, market and selection, bet type, product, source references and multiple-leg details. It therefore cannot replace the source reconciliation. In particular, B005 cannot be represented accurately using only its original odds and a win or loss status.
An operator file may need normalization to match these fields and statuses. Keep the original file separately, and do not use the simplified analysis table as your only evidence of settlement.
Final reconciliation checklist
Reconciliation is complete when every settled cash ticket is supported, exceptions are explained and the result agrees with the cash transactions.
- Use one account, one currency and one period rule.
- Match betting history to account transactions by ticket ID.
- Investigate records found in only one source.
- Retain void rows and show open stakes separately.
- Use the actual cash-out return.
- Separate deposits, withdrawals, transfers, bonus credits and fees.
- Preserve ticket IDs and original source files.
- Refer unresolved discrepancies to the operator’s support team.
This guide helps you prepare verifiable records; it does not resolve disputes or replace operator support, and it is not tax advice. A positive period alone does not prove skill, an edge or future profit.
Frequently Asked Questions
Keep each currency separate for a reproducible reconciliation. This example uses USD only and does not define a currency conversion method.
On a settlement-date basis, include the ticket if it settled within the period. Preserve its placement time separately and check whether your history filters excluded it.








