ToolsGambling
TG
Sportsbook Betting History: Check Profit and Loss

How to Export Betting History and Check Your Net Result

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.

  1. Define the scope: account, currency, period boundaries, time zone and ticket inclusion rule. The example below uses settlement date and preserves placement time separately.
  2. Save the betting history and account transactions. Record the filters used and each source filename.
  3. Match ticket IDs in both directions. Look for tickets without corresponding transactions and betting transactions without a ticket in the betting history.
  4. Flag exceptions. Missing tickets, unexplained returns and conflicting statuses need investigation, not guessed values.
  5. 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.

FieldWhat to record
Operator / accountOperator name and account identifier
CurrencyThe currency used for each calculation
Ticket IDThe key used to match account transactions
Placement time and time zoneOriginal placement date, time and time zone
Settlement timeUsed to determine inclusion in the period
Event / market / selectionWhat the wager covered
Accepted oddsThe odds actually accepted, not current odds
Bet typeFor example, a single or a multiple
Stake funding sourceCash, bonus funds or a mixture
Cash and bonus portionsSeparate amounts
StatusOpen, won, lost, void, cashed out or another recorded status
Actual gross cash returnCash returned on settlement, including the stake where applicable
FeesCosts recorded separately
ProductUsed to separate sports betting from other products
Source reference / filenameWhere the original record can be checked
Multiple detailsOverall 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.

TicketPlaced, UTCSettled, UTCStatusCash stake, USDAccepted oddsGross cash return, USDNet result, USD
B0012026-10-01 12:002026-10-01 15:00Won20.001.9038.00+18.00
B0022026-10-02 12:002026-10-02 16:00Lost15.002.100.00−15.00
B0032026-10-03 12:002026-10-03 14:00Void12.002.5012.000.00
B0042026-10-04 12:00—Open10.002.30——
B0052026-10-05 12:002026-10-05 13:00Cashed out25.002.0019.00−6.00
B0062026-10-06 12:002026-10-06 15:00Settled; reconstructed from transactions8.00Missing from bet export14.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 classAmounts, USDTreatment
Deposit+100.00Account funding, not profit
B001−20.00; +38.00Cash stake and gross cash return
B002−15.00Lost cash stake
B003−12.00; +12.00Cash stake and full void return
B004−10.00Open cash stake
B005−25.00; +19.00Cash stake and cash-out return
B006−8.00; +14.40Evidence for the missing ticket
Bonus credit+5.00Separate bonus accounting
Withdrawal−40.00Money withdrawn, not a betting loss
Transfers between productsNone in this exampleReconcile 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 valueMeaning
pendingAwaiting settlement
wonWon
lostLost
voidStake 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.

FAQ

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.

Evgeniy Volkov

Verified Expert
Fullstack Developer

Fullstack developer with a background in mathematics. I build the calculators and game-style tools on ToolsGambling with Pixi.js and modern web tech, and every result uses transparent probability formulas you can verify yourself.

EducationMathematics
SpecializationiGaming
StatusActive

Was this article helpful?

Share Article

Free calculators and tools

Run the numbers before you bet. Our calculators use transparent formulas you can verify yourself.