Turnkeyxgaming

Guide · Finance

What the daily GGR file is for

The daily file is how your ledger and the aggregator agree on stake, win and the difference. It is not a player statement and it is not a marketing report. If those jobs share one export, one of them will be wrong.

7 min readUpdated By the Turnkeyxgaming team

Close the day on purpose

Pick a timezone and a cut-off and print both in the file header. A round that starts before midnight and settles after it needs a rule: we use settlement time. Changing that rule mid-month moves revenue between days and breaks the invoice match. Studio totals, game totals and brand totals should add back to the same grand total. If they do not, the export is not finished.

Bonus-funded stakes and free-round wins are not the same as cash play. Mark them. GGR on a free round is negative by the amount won, because there was no cash stake. If that number sits inside the cash GGR line, the studio invoice and your bonus budget will never meet. The GGR explained page is the commercial definition. This file is the operational one.

A round that spans the cut-off belongs to the day it settles, and the header should say so in the same words every morning. Moving that rule on the 12th shuffles revenue between two archived days and makes the month impossible to rebuild from the files you already sent. Keep a one-line exception list for voids corrected after the file left: the original day stays as it was sent, and the correction is a dated adjustment, not a silent rewrite.

How each line is marked in the daily file

The export is the operational record finance will tie to the month. It is not a player statement. Each line needs a flag before anyone sums the column.

LineCash GGRWhere it sits in the file
Cash stake and cash winStake minus win.The main total, split by studio, game and brand so the three views meet.
Free-round winNegative by the win. No cash stake was taken.Its own flag. Never inside the cash line.
Bonus-funded stakeDepends on the campaign rule you already published.Marked, so the bonus budget can see it without borrowing the cash total.
Void corrected after the file was sentRemoved from the total.An exception section plus a dated adjustment. The archived day is not edited in place.

Checks before the file leaves finance

  1. 01

    Header

    Write the timezone and the cut-off rule in the file, not only in a wiki.

  2. 02

    Adds up

    Studio rows, game rows and the grand total must reconcile to the cent.

  3. 03

    Bonus flag

    Split cash GGR from bonus-funded wins before anyone emails the file.

Print the clock in the header

Timezone and cut-off belong in the file, not only on a wiki page nobody opens at month end. A studio comparing totals cannot guess whether you meant settlement time in UTC or session start in the brand's local zone.

Worked example

A file excerpt finance can audit without asking engineering

A useful daily file names its clock in the header, splits cash from bonus-funded play, and shows corrections as dated lines rather than edits to a closed day. Suppose a €2.00 spin settles at 00:03 UTC on 14 March, after the 00:00 cut-off. It belongs to 14 March under settlement time, not 13 March under session start. The header says so, and the studio total and the brand total both use the same rule.

A free-round win of €0.80 carries a promotional flag and sits outside the cash GGR line. If it were folded into cash GGR, the studio invoice and the bonus budget would both be wrong, and the difference would surface at month end. Keep the flags on the line, keep the totals split, and keep the adjustment section for anything corrected after the file leaves.

Four lines from one day

LineExampleHow it is marked
Cash spinStake €2.00, win €0.00Cash GGR, settlement date 14 March
Bonus-funded roundStake €0.00, win €0.80Promotional flag, outside cash GGR
Void after the file leftStake €1.00 returnedDated adjustment naming the original day
HeaderCut-off 00:00 UTC, settlement timePrinted in the file, not in a wiki

FAQ

Questions operators ask

Should the file include voided rounds?

Include them in an exception section so they can be audited, and exclude them from the GGR total. Hiding them entirely makes the next dispute harder.

Should the daily file list every player?

No. It is stake, win and the difference, by the dimensions finance reconciles. A player-level dump is a statement or a support extract. Sharing one export between those jobs means one of them is shaped wrong.

What happens to a round that starts before the cut-off and settles after it?

It belongs to the settlement day, and that rule stays for the whole month. Putting it on the start day in week one and the settlement day in week two moves the same money between two files.

Should a correction change the archived day?

No. The archived file is what was sent. Add a dated adjustment line that names the day it corrects, so finance can rebuild the month from the archive and still see both versions.

Keep reading

Related pages

  • Guide · FinanceGGR explainedCasino GGR is stakes minus wins. It is not NGR, and sportsbook GGR can swing on a single result, so the definition matters.Read
  • PricingPricingPublished rates are 13% of GGR in Asia and 16% elsewhere, all-in. Why a cheaper headline rate often hides the real terms.Read
  • Guide · TestingSandbox versus invoicesHow to separate sandbox players, test currencies and staff accounts from the GGR file that becomes an invoice, with examples.Read
  • Guide · FinanceGGR by countryA GGR row needs a defined country. A VPN can leave the tax file and the payment file naming two different places for one player.Read

Get a written quote and sandbox access

Tell us your licence, target markets and products. You get the GGR rate in writing, the studio list for your markets and sandbox credentials.

Telegram @turnkeyxhub WhatsApp Email Contact form