NGR Reconciliation for iGaming Affiliate Programs: How to Prevent Payout Disputes
Introduction
Revenue-share partnerships depend on a number that both sides need to trust: the revenue base used to calculate commission. In many iGaming programs, that base is net gaming revenue, or NGR. The calculation looks straightforward on paper, but the operational process behind it involves several data sources, attribution rules, deductions, currencies and accounting periods. A difference in any one of these components can change the amount payable to an affiliate.
For that reason, NGR reconciliation is not simply a finance check performed before sending money. It is a control process that verifies whether player activity, revenue, allowable deductions and commission rules have been applied consistently across the affiliate platform, gaming platform, payment systems and internal reporting environment. A structured reconciliation process identifies discrepancies before they develop into recurring affiliate payment disputes.
Operators also need to distinguish a genuine calculation error from a data-timing or attribution issue. An affiliate dashboard can show a different figure without either system being mathematically wrong. One platform can record activity on the transaction date while another uses the settlement date. A chargeback can appear after the original commission period. Currency conversion can take place at different exchange rates. The purpose of reconciliation is to trace these differences to a defined source rather than comparing two final totals and assuming one of them is incorrect.
What NGR Reconciliation Means in iGaming Affiliate Programs
NGR reconciliation in iGaming is the process of confirming that the net revenue attributed to an affiliate corresponds with the underlying player and financial data used by the operator. The process normally starts with gaming activity and finishes with the affiliate commission payable for a defined reporting period. Every transformation between these stages must be reproducible.
The basic logic is:
- GGR – contractually defined deductions = NGR
- NGR × applicable RevShare rate = affiliate commission
The apparent simplicity of this NGR formula hides an important contractual issue. NGR is not defined identically across every affiliate program. Bonus costs, gaming duties, payment fees, refunds, chargebacks, jackpot contributions and other expenses are treated differently depending on the operator, jurisdiction, product and commercial agreement. A reliable reconciliation process therefore starts with the NGR definition in the affiliate agreement rather than with a generic industry formula.
The distinction between GGR vs NGR is also essential. Gross gaming revenue reflects gaming results before additional agreed deductions are applied. NGR reduces that gross amount by specific costs defined by the program. A RevShare contract based on NGR therefore requires more reconciliation steps than a simple GGR calculation because every deduction affects the affiliate’s commission base.
Reconciliation is different from routine iGaming affiliate reporting. A report presents results. Reconciliation proves how those results were produced. A dashboard showing €120,000 NGR and €36,000 commission at 30% RevShare gives the affiliate an outcome, but not necessarily enough information to verify it. A reconciled dataset provides the underlying GGR, deductions, adjustments, carryover balance and commission rule that generated those totals.
A mature process also establishes a source of truth for every data category. The gaming platform can remain authoritative for wagers and winnings, the payment layer for confirmed financial transactions, and the affiliate system for attribution and deal configuration. The reconciliation layer connects those records through stable identifiers and documented transformation rules.
Why NGR Figures Do Not Match Between Affiliate and Operator Systems
Most affiliate tracking discrepancies originate before the final commission calculation. Affiliate software, gaming platforms, CRMs, payment processors and business-intelligence systems are built for different purposes. They can process the same player through different event definitions, timestamps and identifiers. Comparing their top-level revenue figures without normalizing these differences produces false discrepancies as well as genuine ones.
Time boundaries are a frequent cause. Consider a deposit completed shortly before midnight on the final day of the month. The affiliate system can assign it to the current reporting period while another system records the transaction after settlement in the following period. Neither record is necessarily inaccurate. The systems are using different accounting or event timestamps. Timezone configuration creates the same problem when one platform operates in UTC and another generates reports in a local timezone.
Attribution errors create a more serious mismatch. Revenue can exist correctly in the gaming platform but fail to appear under the correct affiliate because the player-to-affiliate relationship was lost, overwritten or never synchronized. Missing server-to-server events, duplicate postbacks, broken click identifiers and inconsistent player IDs all affect the amount of revenue attached to a partner.
Typical discrepancy categories include:
- different reporting cut-off times;
- timezone differences;
- delayed postbacks or API synchronization;
- duplicate registrations, deposits or revenue events;
- missing player-to-affiliate mappings;
- inconsistent affiliate IDs across platforms;
- incorrect campaign or sub-ID attribution;
- currency conversion at different dates or rates;
- pending transactions included in one report but excluded from another;
- chargebacks posted in a later accounting period;
- manual corrections not synchronized across systems;
- different bonus-allocation logic;
- different treatment of fraud, refunds or voided transactions.
Currency is especially relevant for programs operating across multiple GEOs. If a player generates revenue in GBP while the affiliate account is settled in EUR, the systems need the same FX methodology. A platform using the transaction-time exchange rate will not reproduce a report generated with the month-end rate. Reconciliation therefore needs to compare the original transaction currency, conversion rate, conversion timestamp and reporting currency rather than only the converted amount.
Another common error is comparing metrics that have similar labels but different definitions. Deposits can mean initiated deposits, successful deposits, net deposits or settled deposits. Revenue can mean GGR, adjusted GGR, NGR before taxes or final commissionable NGR. The first task in any affiliate revenue reconciliation is to confirm that both datasets measure the same economic event.
A practical investigation should work from granular records upward. Instead of asking why one dashboard shows €83,410 and another €79,960, the team should compare registrations, FTDs, deposit transactions, player-level GGR, deductions and adjustments separately. The first level at which the datasets diverge normally identifies the source of the problem.
Which NGR Deductions Must Be Reconciled
The most sensitive part of an NGR-based RevShare model is the deduction layer. Every valid deduction reduces the commissionable base, so even a technically correct calculation becomes commercially disputed when an affiliate cannot identify why revenue was reduced. NGR deductions therefore require both contractual clarity and transaction-level evidence.
There is no single mandatory list that applies to every iGaming affiliate program. The applicable categories depend on the affiliate agreement and operating model. Industry implementations commonly account for bonus costs, chargebacks and relevant gaming duties, while payment processing fees, jackpot contributions, game-provider costs and other expenses are less consistent across programs. The contract should determine which costs belong in the calculation rather than an undocumented month-end adjustment.
NGR deductions: reconciliation requirements and dispute risks
Bonus costs require particular attention because operators use several incentive types throughout a player’s lifecycle. A welcome bonus connected to acquisition has a different commercial purpose from a reload offer sent months later by a retention team. If all incentive costs reduce affiliate NGR, the agreement and reporting logic should state this explicitly. If only defined acquisition bonuses are deductible, retention incentives must not silently enter the calculation.
Chargebacks create a different reconciliation problem. The original deposit and the reversal often occur in separate periods. An operator therefore needs a consistent rule for when the revenue adjustment becomes effective. The affiliate statement should preserve enough information to link the later chargeback to the original player and transaction.
Fraud-related deductions need stronger controls than automated expense categories. A manual fraud adjustment without a reason code, player reference, timestamp and approval record is difficult to audit. The same applies to refunds, voided bets and exceptional account corrections. Any adjustment that changes previously reported revenue should leave a traceable record.
The safest model is a closed deduction taxonomy. Each category receives a code, calculation rule, source system and contractual basis. New expense categories should not enter the RevShare calculation through miscellaneous spreadsheet adjustments. This approach reduces interpretation risk and keeps period-to-period comparisons consistent.
How to Reconcile NGR Step by Step Before Affiliate Payouts
A reliable affiliate payout reconciliation follows the same sequence every period. The goal is not to force different systems to display identical totals at all times. The goal is to account for every material variance and determine the commission base according to one controlled methodology.
The reconciliation period should also be closed consistently. If finance extracts gaming data on the first day of the month while the affiliate team refreshes its dashboard two days later, late transactions can produce different totals. Both teams need the same cut-off, data version and adjustment policy before starting the calculation.
A practical workflow contains the following steps:
- Define the reporting period. Set the exact start and end timestamps, timezone, settlement policy and cut-off rules. Record whether late events move into the next period or reopen the previous one.
- Export affiliate attribution data. Capture affiliate ID, campaign parameters, click identifiers, player IDs, registration dates, FTD status and deal configuration.
- Extract gaming data. Obtain player-level wagers, payouts or winnings, GGR and the product information required by the program’s revenue formula.
- Match player records. Use stable player IDs wherever possible. Do not rely on names, email addresses or approximate registration dates when deterministic identifiers exist.
- Reconcile GGR. Compare player-level gross revenue before deductions. If the gross amounts already differ, the problem exists upstream from the NGR calculation.
- Reconcile each deduction category. Check bonuses, chargebacks, taxes, refunds and every other permitted cost separately. Aggregate totals are insufficient when a dispute requires transaction-level investigation.
- Review adjustments. Separate current-period activity from corrections relating to previous periods. Every retroactive adjustment should carry a reason, reference and effective date.
- Calculate final NGR. Apply the contractual formula only after the underlying components have been validated.
- Apply the correct RevShare rule. Confirm the affiliate’s rate, tier, product-specific rate and effective dates. Deal changes during a period need explicit handling.
- Apply negative carryover where applicable. Bring forward the verified opening balance according to the contract before calculating payable commission.
- Compare the expected payout with the affiliate statement. Any remaining variance should be categorized by source rather than placed in an unexplained balancing adjustment.
- Approve and lock the period. Store the approved dataset, calculation version and authorization record. Future changes should enter through a controlled adjustment process.
The sequence matters. A team should not troubleshoot commission percentage settings when the affiliate and operator disagree on the underlying player population. Likewise, checking deductions is inefficient when GGR itself has not reconciled. Working from attribution to revenue to deductions to commission isolates errors faster.
A variance threshold can improve operational efficiency, especially in programs handling large transaction volumes. The threshold should distinguish immaterial rounding differences from issues requiring investigation. It should never become a mechanism for ignoring systematic underpayment or overpayment. Repeated small differences from the same source indicate a process defect even when each individual variance falls below the review threshold.
The final output should be a reproducible calculation rather than an amended spreadsheet total. If finance cannot recreate the approved payout using the stored source records and rules, the process has not achieved true reconciliation.
Negative Carryover, Adjustments and Other Sources of Payout Disputes
Negative carryover determines what happens when the applicable RevShare balance becomes negative and the deficit extends beyond the current commission period. Under a carryover model, future positive revenue first offsets the accumulated negative balance. Under a reset model, the next period begins without carrying that deficit forward. The chosen model directly affects the timing and value of future affiliate earnings.
For example, assume an affiliate operates on a 30% RevShare agreement and finishes one month with -€10,000 in applicable NGR. If the contract uses full negative carryover and the following month generates €16,000 of positive NGR, €10,000 clears the carried deficit. Commission is then calculated on the remaining €6,000, producing a €1,800 payout. Under a monthly reset model, the same second month would start from zero and the 30% calculation would apply to the full €16,000.
The mathematical rule is not usually the source of the dispute. Problems arise when the affiliate does not know whether carryover operates at affiliate, player, product, brand or account level. A high-value player’s large win can affect future commission differently depending on the aggregation model. Multi-brand programs also need to state whether a negative balance under one brand can offset positive NGR generated under another.
Negative carryover must also be separated from a clawback. Carryover affects future commission by bringing a negative balance forward. A clawback reverses or recovers commission associated with an event that was previously treated as payable, normally because of a later reversal, fraud finding or failed qualification condition. Mixing these concepts in reporting makes the partner unable to understand whether revenue variance or a retrospective correction changed the payout.
Other common dispute sources include:
- previously unreported chargebacks;
- retroactive fraud decisions;
- voided transactions;
- corrected bonus costs;
- changed player attribution;
- delayed tax entries;
- manual commission adjustments;
- a RevShare tier changed during the reporting period;
- a currency correction after the first statement was generated;
- reopening a period without versioning the original report.
Operators therefore need an adjustment policy alongside the NGR formula. The policy should specify when closed periods can be amended, who can approve a change, where the adjustment appears and whether the original period is restated or the correction enters the next statement.
Version control is particularly important. If an affiliate downloads a statement showing €22,400 commission and the dashboard later changes to €19,700 without an adjustment record, confidence in the reporting process declines even when the correction itself is valid. The system should preserve the original calculation, the revised amount and the reason for the difference.
How Reporting and Audit Trails Prevent NGR Disputes
Transparent iGaming affiliate reporting converts a commission statement from a final number into an auditable calculation. An affiliate does not need access to every internal finance record, but the information supplied should be detailed enough to explain how attributed activity became commissionable NGR.
At a minimum, the reporting model should connect an affiliate to the relevant players, revenue period, gross revenue, agreed deductions, final NGR, commission rate, carryover and payable amount. Where privacy requirements restrict direct player information, operators can use persistent pseudonymous identifiers that still support reconciliation without exposing unnecessary personal data.
Useful fields include:
- affiliate ID;
- campaign or sub-ID;
- pseudonymous player ID;
- registration date;
- FTD date and status;
- deposit amount;
- wagering activity;
- winnings or payouts;
- GGR;
- bonus deductions;
- chargebacks;
- tax or duty deductions;
- other contractual adjustments;
- final NGR;
- opening carryover balance;
- closing carryover balance;
- RevShare percentage;
- calculated commission;
- manual adjustment value and reason;
- payout status;
- payout reference.
An audit trail adds historical context to those numbers. Every material change should record what changed, when it changed, which source generated the change and who approved it when human authorization was required. This is especially valuable for fraud decisions, deal amendments and retroactive financial adjustments.
A strong payout audit trail should allow the operator to trace a commission from the final payment back through the commission rule and revenue calculation to the underlying attributed activity. Industry reconciliation guidance also emphasizes consistent identifiers, timestamps and adjustment records across affiliate, gaming and payment systems because disconnected records make dispute investigation significantly harder.
Auditability also improves internal control. Affiliate managers, finance teams and BI analysts should not maintain separate unofficial versions of the same calculation. If each team uses its own spreadsheet logic, discrepancies become part of the operating model. A controlled source of truth gives each function the same approved data while allowing different reporting views.
Historical reporting needs to remain reproducible after system changes. When commission rules, tax treatment or affiliate tiers are updated, the system should retain the configuration that applied to earlier periods. Recalculating historical months using today’s settings can silently rewrite past commissions.
Best Practices for Preventing Affiliate Payout Disputes
The most effective way to reduce affiliate payout disputes is to remove ambiguity before revenue is generated. Operators should define how NGR works when the agreement is created, configure the same rules in the calculation environment and expose enough reporting detail for affiliates to verify the outcome. Reconciliation should confirm those rules rather than inventing exceptions at month-end.
Contract language, system configuration and operational procedures must therefore describe the same economic model. A contract that excludes payment fees from NGR is ineffective if the commission engine deducts them by default. A clear negative-carryover clause also provides little protection if the affiliate dashboard does not display the opening and closing balance.
A robust control framework includes the following practices:
- Define NGR precisely. List every permitted deduction instead of relying on a broad “net revenue after costs” definition.
- Maintain a controlled deduction taxonomy. Each deduction should have a code, source and calculation rule.
- Use one reconciliation methodology. Finance and affiliate teams should not produce competing commission figures from separate spreadsheets.
- Standardize identifiers. Preserve affiliate ID, click ID, player ID and transaction ID across system integrations.
- Normalize timestamps. Store a common reference timezone and document which event timestamp determines the reporting period.
- Document FX rules. Specify exchange-rate source, effective timestamp and rounding convention.
- Separate revenue from adjustments. Do not hide chargebacks, fraud corrections or manual changes inside aggregated NGR.
- Define negative carryover clearly. State the aggregation level, duration and reset conditions.
- Version commission agreements. Preserve the rate and terms that applied on each effective date.
- Reconcile before payment approval. Investigation after funds have been sent creates unnecessary clawback and relationship risk.
- Set a formal dispute workflow. Define the contact channel, evidence required, review owner and escalation process.
- Lock closed periods. Changes after approval should create adjustment records instead of silently rewriting history.
Automation improves this framework when transaction volumes increase, but automation does not correct an undefined business rule. A system can apply the wrong bonus policy with perfect consistency. The program first needs an agreed revenue model; technology then enforces it at scale.
Operators should also measure reconciliation performance. Useful control metrics include the percentage of transactions automatically matched, value of unresolved differences, number of manual adjustments, average dispute value, repeated discrepancy categories and the share of payouts amended after initial calculation. A rising number of corrections indicates a process problem even when individual disputes are resolved successfully.
For affiliates, transparent reconciliation also changes the quality of commercial discussions. Instead of arguing about a final payment, both parties can discuss the exact component that changed: one missing player mapping, a defined bonus deduction, a chargeback from a prior period or an incorrect tier rate. This makes payout resolution faster and reduces the risk that routine accounting differences damage a productive acquisition partnership.
Conclusion
NGR reconciliation is the control layer between player activity and affiliate payment. It verifies that the same attribution, revenue definitions, deductions, adjustments and commission rules have been used throughout the calculation. Without this layer, an operator can produce technically valid reports from several systems that still fail to agree with one another.
The strongest reconciliation process works from granular data upward. It first confirms player attribution and GGR, then verifies each NGR deduction, applies contractual carryover rules and only then calculates RevShare. This sequence distinguishes tracking failures from revenue-calculation errors and commission-configuration mistakes.
Preventing disputes also requires more than a correct monthly formula. Clear affiliate agreements, stable identifiers, controlled adjustment workflows, consistent period rules, transparent reports and complete audit trails create a calculation that both sides can reconstruct. When the operator can explain every material movement between GGR, net gaming revenue and the final payout, commission reconciliation becomes a routine financial control instead of a recurring source of conflict.
FAQ
The questions below cover the issues most frequently associated with NGR calculation, RevShare reporting and affiliate reconciliation. The exact treatment of deductions and balances always depends on the commercial terms of the individual program.
For that reason, an affiliate agreement should remain the primary reference when a general industry convention and a program-specific calculation differ. Reconciliation verifies whether the agreed methodology has been applied correctly; it does not replace the agreement itself.
[1] What is NGR reconciliation in iGaming affiliate marketing?
NGR reconciliation is the process of verifying that the net gaming revenue assigned to an affiliate matches the underlying player activity, permitted deductions and commercial rules recorded by the operator. It connects attribution data with gaming revenue and the final affiliate commission.
A complete reconciliation does not compare only two dashboard totals. It traces the calculation through player IDs, GGR, bonuses, chargebacks, other agreed deductions, carryover and the applicable RevShare rate. This makes individual discrepancies identifiable and auditable.
[2] How is NGR calculated for affiliate commissions?
A simplified calculation starts with GGR and subtracts the deductions defined in the affiliate agreement. If the resulting commissionable NGR is positive, the applicable RevShare percentage is applied to that amount, subject to any carryover or deal-specific rules.
There is no universal list of deductions for every iGaming program. Bonus costs and chargebacks are frequently relevant, while taxes, payment fees, jackpot contributions and other expenses depend on the contract and operating model. The operator should therefore document its net gaming revenue calculation rather than relying on an assumed industry definition.
[3] Why does affiliate NGR differ from the operator’s NGR?
Differences often originate from reporting scope rather than arithmetic. The affiliate system can use a different period cut-off, attribution dataset, exchange rate, settlement status or adjustment timing from the operator’s internal revenue report.
The comparison can also involve different definitions of NGR. One internal report can include costs that are excluded from the commission agreement, while the affiliate report contains only commissionable deductions. Reconciliation must normalize definitions before comparing totals.
[4] Which deductions can be included in NGR?
The valid deductions are those defined by the program’s commercial terms. Depending on the agreement, these can include player bonuses, chargebacks, specified taxes or duties, refunds, jackpot contributions, payment-related costs and documented fraud adjustments.
Each category should be separately identifiable in the calculation. Broad unidentified deductions weaken auditability and create disputes because the affiliate cannot determine how the final NGR figure was obtained.
[5] How often should iGaming affiliate payouts be reconciled?
Reconciliation should take place before each scheduled RevShare payout. A monthly program therefore needs a completed month-end reconciliation before the corresponding monthly commission is approved.
High-volume programs also benefit from intraperiod monitoring. Daily or weekly exception checks can identify missing postbacks, attribution failures and abnormal revenue differences before the reporting period closes, reducing the amount of manual investigation required at payout time.
[6] How does negative carryover affect NGR reconciliation?
Negative carryover introduces an opening balance into the commission calculation. When the previous period ends with a qualifying negative balance, future positive NGR first offsets that deficit according to the program’s rules before new RevShare becomes payable.
Reconciliation therefore needs to verify both current-period NGR and the carried balance. The report should show where the opening deficit came from, how much current revenue offset it and what balance remains after the period. Hidden carryover is a frequent source of confusion because the affiliate can generate positive current-month NGR while still receiving no commission.
[7] How can operators prevent affiliate payout disputes?
Operators can prevent most recurring disputes by defining the NGR formula, deductions, reporting periods, FX methodology, adjustment rules and negative-carryover policy before commissions are calculated. Those terms must then be reflected consistently in the affiliate platform and financial workflow.
Transparent player-level or appropriately pseudonymized reporting, controlled adjustment records and a complete audit trail further reduce disagreement. When both parties can reconstruct the iGaming affiliate commission from the same underlying data, payout questions become specific reconciliation tasks rather than disputes over an unexplained final figure.