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.
| Line | Cash GGR | Where it sits in the file |
|---|---|---|
| Cash stake and cash win | Stake minus win. | The main total, split by studio, game and brand so the three views meet. |
| Free-round win | Negative by the win. No cash stake was taken. | Its own flag. Never inside the cash line. |
| Bonus-funded stake | Depends 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 sent | Removed from the total. | An exception section plus a dated adjustment. The archived day is not edited in place. |
Checks before the file leaves finance
- 01
Header
Write the timezone and the cut-off rule in the file, not only in a wiki.
- 02
Adds up
Studio rows, game rows and the grand total must reconcile to the cent.
- 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
| Line | Example | How it is marked |
|---|---|---|
| Cash spin | Stake €2.00, win €0.00 | Cash GGR, settlement date 14 March |
| Bonus-funded round | Stake €0.00, win €0.80 | Promotional flag, outside cash GGR |
| Void after the file left | Stake €1.00 returned | Dated adjustment naming the original day |
| Header | Cut-off 00:00 UTC, settlement time | Printed 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.