Popular reconciliation template
Rake and Commission Reconciliation
Reconcile rake, commission, platform fees, game round deductions, entry fees, wallet movements, taxes, settlements, and open items in one structured workflow.
View demo reportReconcile rake and commission with game, wallet, and accounting records
Rake and commission may be calculated from game rounds, entry fees, stakes, contest fees, platform fees, winnings, partner revenue shares, taxes, and wallet movements. Cointab helps bring these records into one clear reconciliation report.
The Rake and Commission Reconciliation template helps finance, gaming operations, and accounting teams compare rake or commission records with game round reports, wallet ledger entries, player transactions, settlement reports, tax records, and accounting postings.
This helps teams answer questions such as:
- Which game rounds generated rake or commission?
- Which rake or commission amounts match the platform's expected calculation?
- Which game rounds are missing rake or commission records?
- Which rake or commission entries do not have matching game round records?
- Which wallet debits, entry fees, stakes, winnings, refunds, or reversals affect rake calculation?
- Which partner commissions, affiliate commissions, provider commissions, or platform fees need review?
- Which tax, GST, VAT, TDS, withholding, or fee deductions explain the difference?
- Which items need game operations review, partner follow-up, revenue review, accounting correction, or internal approval?
This template is useful for gaming platforms, real money gaming businesses, fantasy sports platforms, tournament platforms, marketplace-style platforms, wallet-based apps, finance teams, controllers, CFOs, and accounting firms that need a repeatable rake and commission reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around common rake reports, commission reports, game round files, contest reports, wallet ledgers, settlement reports, tax reports, partner reports, ERP exports, and supporting data.
| Data source | Example records |
|---|---|
| Rake / Commission Report | Used as the main revenue-side report containing rake amount, commission amount, platform fee, transaction ID, round ID, contest ID, game ID, player ID, fee percentage, revenue share, tax values, and calculation basis. |
| Game Round Report | Used to compare rake or commission with game rounds, stakes, winnings, losses, entry fees, round status, session IDs, table IDs, provider references, and settlement status. |
| Wallet Ledger Report | Used to compare rake or commission with player wallet debits, entry fee deductions, stake movements, winning credits, refunds, reversals, and balance movement. |
| Contest / Tournament Report | Optional, but useful where commission is calculated from contest entry fees, prize pools, joining fees, platform fees, tournament fees, or contest-level revenue. |
| Platform Fee / Revenue Report | Optional, but useful where platform fee, service charge, rake, commission, net gaming revenue, gross gaming revenue, or revenue share values are calculated separately. |
| Partner / Provider Commission Report | Optional, but useful where game providers, affiliates, agents, partners, or distributors receive commission or revenue share from game activity. |
| Tax / Deduction Report | Optional, but useful where GST, VAT, TDS, withholding, gaming tax, platform tax, service tax, or other statutory deductions need to be compared. |
| Refund / Reversal Report | Optional, but useful where cancelled games, void rounds, failed rounds, refund entries, rake reversals, commission reversals, or manual corrections need to be reconciled. |
| Settlement Report | Optional, but useful where rake, commission, platform fee, provider share, partner share, and tax deductions need to be connected with settlement or payout records. |
| ERP / Accounting Export | Optional, but useful if rake revenue, commission expense, platform fees, tax, partner payable, wallet, or accounting records are maintained in an ERP, accounting system, internal finance system, or data warehouse. |
| Supporting Data | Optional supporting files can be used for game mapping, player mapping, wallet mapping, provider mapping, partner mapping, commission slab mapping, rake rule mapping, tax mapping, GL mapping, entity mapping, or other enrichment. |
What Cointab matches in rake and commission reconciliation
Cointab compares rake and commission records with game rounds, wallet ledgers, contest entries, platform fees, partner reports, tax records, settlements, and optional ERP or accounting data.
Rake and game rounds
Match rake records with the game rounds, tables, contests, tournaments, or sessions that generated them.
Commission and partner records
Compare partner commission, provider commission, affiliate commission, agent commission, or revenue share records with source transaction data.
Entry fees and platform fees
Match entry fees, joining fees, contest fees, platform fees, service charges, and commission deductions with wallet or game records.
Player wallet movements
Compare wallet debits, wallet credits, stakes, winnings, refunds, reversals, and bonus movements with rake and commission calculations.
Revenue calculations
Check whether rake percentage, commission rate, revenue share, net gaming revenue, gross gaming revenue, and platform fee calculations are correct.
Taxes and deductions
Compare GST, VAT, TDS, withholding, gaming tax, service tax, statutory deductions, and tax-inclusive or tax-exclusive values where available.
Refunds and reversals
Match rake reversals, commission reversals, cancelled rounds, void rounds, failed games, refund entries, and adjustment records.
Settlements and accounting postings
Compare rake revenue, commission payable, partner settlement, provider settlement, GL entries, revenue postings, and accounting records.
Internal records, if added
If ERP, books, settlement, tax, wallet, risk, or compliance data is included, Cointab can connect rake and commission reconciliation with wider finance and control workflows.
Common rake and commission reconciliation exceptions
Cointab helps finance and operations teams focus on revenue and commission differences instead of manually reviewing every game round, wallet entry, platform fee, partner share, and tax record.
Game round missing rake
A game round or contest entry exists, but the expected rake or commission record is missing.
Rake record without game round
A rake or commission entry appears, but there is no clear matching game round, contest, wallet, or source transaction.
Rake amount mismatch
The game round, contest ID, player ID, or transaction reference appears to match, but the calculated rake amount differs from the reported rake amount.
Commission amount mismatch
Partner, provider, affiliate, or platform commission differs from the expected commission value.
Platform fee mismatch
Entry fee, joining fee, service fee, platform fee, or deducted amount does not match the expected value.
Wrong commission slab
A transaction is calculated using the wrong commission rate, rake percentage, slab, campaign rule, provider agreement, or partner rule.
Tax mismatch
GST, VAT, TDS, withholding, gaming tax, service tax, or tax deduction differs from expected tax values.
Refund or reversal not adjusted
A cancelled game, void round, failed round, or refund exists, but rake or commission was not reversed correctly.
Duplicate rake entry
The same rake, commission, game round, contest, wallet transaction, or partner entry appears more than once.
Missing partner commission
Partner or provider commission should be payable but is not reflected in the commission report or settlement report.
Commission posted without source transaction
A commission is recorded even though the underlying game, contest, player transaction, or platform fee is missing.
Settlement mismatch
Rake revenue, commission payable, partner share, or provider settlement does not match settlement or accounting records.
Timing difference
A game round belongs to one period, but rake, commission, settlement, tax, or accounting posting appears in another period.
Wrong game, partner, or entity allocation
Rake or commission is mapped to the wrong game, contest, partner, provider, entity, branch, business unit, GL account, or cost center.
Missing or unclear reference
Round ID, game ID, contest ID, player ID, partner ID, commission ID, wallet transaction ID, or source reference is missing, incomplete, or inconsistent.
Skipped record
A row cannot be reconciled because required data is missing, invalid, duplicate, incomplete, or unusable.
How this ready-made reconciliation works
Cointab pre-configures the workflow so your team does not need to rebuild the rake and commission reconciliation setup every period.
Select the template
Choose Rake and Commission Reconciliation from popular reconciliations.
Select the period
Choose the day, week, month, quarter, campaign period, year, lifetime period, or custom period you want to reconcile.
Upload rake, commission, and source reports
Upload the rake or commission report, game round report, and any required wallet ledger, contest, platform fee, partner, tax, refund, reversal, settlement, ERP, or supporting files.
Validate file format
Cointab checks whether the uploaded files match the expected structure and highlights missing or incorrect columns.
Run reconciliation
Cointab applies predefined data preparation and matching logic for rake, commission, game round, wallet, partner, settlement, and accounting data.
Review output
View fully matched, partially matched, unmatched, and skipped records.
Download or automate
Download the Excel report, or automate future data input and output through email, SFTP, or APIs.
Structured matching first, AI assistance for difficult cases
Cointab applies structured reconciliation logic first, then uses AI to help with difficult open records where fixed rules are not enough.
Structured matching
Structured matching can use:
Matching scenarios
One-to-one
One rake or commission record matches one game round, wallet transaction, contest record, or accounting entry.
One-to-many
One game round or contest maps to multiple rake, commission, tax, partner share, provider share, or settlement records.
Many-to-one
Multiple game rounds or wallet transactions are grouped into one rake posting, commission posting, settlement record, or accounting entry.
Many-to-many
Multiple game rounds, wallet records, rake records, commission records, tax records, and settlement records are grouped and compared together.
Partial matching
Identifiers match, but rake amount, commission amount, platform fee, tax amount, or settlement amount differs.
Rule-level matching
Rake percentage, commission rate, revenue share rule, slab rule, partner rule, provider agreement, or campaign rule is checked against calculated amounts.
Settlement-level matching
Rake revenue, partner share, provider share, commission payable, taxes, deductions, and settlement amounts are compared together.
Net and contra matching
Rake, commission, platform fees, taxes, refunds, reversals, void rounds, cancelled games, chargebacks, recoveries, adjustments, and settlements are netted where required.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- References are incomplete
- Game round IDs are formatted differently
- Partner or provider names are written differently
- Wallet references appear inside long narration fields
- One game round creates multiple fee, rake, tax, or commission records
- One settlement summarizes multiple game rounds
- Refunds or reversals do not directly link to original rake records
- Commission slabs require contextual review
- Tax descriptions are inconsistent
- Partner settlement records are grouped differently from game activity
- Amounts require business context
- Multiple possible causes exist for the same commission difference
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.
Audit-ready rake and commission reconciliation reports
Cointab gives your team a clear report showing which rake, commission, game round, wallet, partner, tax, settlement, and accounting records matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
Rake, commission, game round, wallet, partner, tax, settlement, and accounting records where identifiers, rules, and amounts match.
Partially matched
Records where identifiers match but rake amount, commission amount, platform fee, tax amount, settlement amount, or accounting amount differs.
Unmatched in rake or commission records
Game rounds, wallet entries, contest records, partner records, or accounting records that do not clearly match rake or commission records.
Unmatched in source reports
Rake or commission records that do not clearly match game round, wallet, contest, partner, settlement, or accounting source data.
Rule calculation differences
Records where rake percentage, commission slab, partner share, provider share, or platform fee calculation requires review.
Tax and deduction differences
Records where tax, TDS, withholding, GST, VAT, service tax, or statutory deductions require review.
Refund and reversal differences
Records where cancelled rounds, void rounds, refunds, reversals, and adjustments were not reflected correctly.
Settlement differences
Records where rake revenue, partner commission, provider share, settlement amount, or accounting posting requires review.
Allocation differences
Records where game, partner, provider, entity, business unit, GL account, or cost center mapping requires review.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Transaction-level details
- Game-level filters
- Partner-level filters
- Commission type filters
- Rule-level filters
- Tax filters
- Difference amounts
- Calculated rake and commission view
- Matched transaction drill-down
- Manual match
- Undo manual match
- Excel export
- Audit-friendly output
Automate recurring rake and commission reconciliation
Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.
Bring data into Cointab
Data can be received or pulled through:
Run automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Matched rake records
- Matched commission records
- Matched game round records
- Unmatched game rounds
- Unmatched rake entries
- Unmatched commission entries
- Rake amount differences
- Commission amount differences
- Platform fee differences
- Wrong slab records
- Tax differences
- Refund adjustment differences
- Partner share differences
- Provider share differences
- Settlement differences
- Duplicate rake records
- Wrong game allocation records
- Wrong partner allocation records
- Timing differences
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View a rake and commission reconciliation demo report
See how Cointab presents Rake and Commission Reconciliation output with matched, partially matched, unmatched, and skipped records.
Rake and Commission Reconciliation Demo
Explore a sample report showing game rounds, wallet entries, rake records, commission records, platform fees, partner share, provider share, tax differences, refund adjustments, settlement differences, and open items.
View demo reportExplore related gaming, wallet, and revenue reconciliations
Cointab supports other wallet, game round, deposit, withdrawal, bonus, refund, settlement, books, ERP, and finance reconciliation workflows.
Player Wallet vs Game Rounds
Reconcile player wallet ledger movements with game round records across stakes, winnings, bonuses, refunds, and reversals.
View templateWallet Ledger Reconciliation
Reconcile wallet credits, debits, deposits, withdrawals, bonuses, refunds, reversals, and balances.
View templateBonus and Promotion Reconciliation
Reconcile bonus credits, promotional usage, wallet movements, game rounds, expiries, reversals, and balances.
View templatePlayer Wallet Balance Reconciliation
Reconcile opening balances, wallet credits, wallet debits, deposits, withdrawals, game rounds, bonuses, refunds, reversals, and closing balances.
View templateRefund and Reversal Reconciliation
Reconcile refunds, reversals, failed refunds, chargebacks, bank debits, customer ledgers, and accounting records.
View templateBank Statement vs Books
Compare bank statement entries with accounting or books records.
View templateBuilt for teams reconciling rake, commission, and platform revenue
This template is useful for teams that regularly reconcile game activity, rake revenue, platform fees, partner commissions, provider shares, taxes, settlements, and accounting postings.
Gaming platforms
For platforms reconciling rake, commission, platform fees, game rounds, wallet entries, partner shares, and settlements.
Real money gaming businesses
For businesses that need controlled, audit-ready reconciliation of rake revenue, player game activity, wallet movements, and finance records.
Fantasy sports platforms
For teams reconciling contest entry fees, platform fees, prize pool deductions, commission, and settlement records.
Tournament platforms
For teams reconciling tournament fees, entry fees, rake, platform commission, partner share, and player transaction data.
Game operations teams
For teams reviewing game round completeness, fee calculation, provider references, cancelled games, and revenue-impacting exceptions.
Partner operations teams
For teams reviewing partner commissions, provider shares, affiliate commissions, revenue shares, and settlement exceptions.
Finance teams
For teams preparing recurring rake and commission reconciliation reports for daily review, month-end close, reporting, and audit.
Accounting teams
For teams reconciling platform revenue, commission expense, partner payable, tax entries, settlement entries, and accounting postings.
Controllers
For controllers who need visibility into missing rake, incorrect commission calculation, wrong tax values, settlement gaps, and posting issues.
CFOs
For finance leaders who want stronger control over platform revenue, partner commissions, accounting accuracy, margin visibility, and audit readiness.
Accounting firms
For CA, CPA, or outsourced accounting teams handling gaming revenue, rake, commission, wallet, and settlement reconciliation for multiple clients.
Trusted by teams handling rake and commission reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across game rounds, rake, commission, player wallets, partner reports, payment gateways, banks, books, ERP systems, and internal systems.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
Rake and Commission Reconciliation FAQs
Start Rake and Commission Reconciliation
Use Cointab's ready-made rake and commission reconciliation workflow to match game rounds, platform fees, rake revenue, partner commissions, taxes, settlements, accounting postings, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported