What is Bonus and Promotion Reconciliation?

Bonus and Promotion Reconciliation is the process of comparing bonus and promotion records with wallet ledger entries, game round usage, expiry records, reversals, campaign rules, player balances, and accounting records to identify matched bonuses, missing wallet entries, amount differences, duplicate credits, expiry differences, and open items.

What files are required?

The main files are usually the bonus or promotion report and wallet ledger report. Depending on the workflow, player bonus balance reports, game round reports, campaign master files, expiry reports, reversal reports, ERP exports, risk reports, or supporting data files may also be used.

Can Cointab identify bonuses issued but not credited to wallets?

Yes. Cointab can compare bonus or promotion records with wallet ledger credits to identify approved or issued bonuses that were not posted to player wallets.

Can Cointab identify wallet bonus credits without promotion records?

Yes. Wallet bonus credits that do not clearly match bonus, promotion, campaign, or approval records can be shown separately for review.

Can Cointab reconcile bonus usage?

Yes. Bonus usage can be compared with wallet debits, game round stakes, campaign usage records, and promotion rules where the data is available.

Can Cointab reconcile bonus winnings?

Yes. Bonus winnings, promotional winnings, locked winnings, and wallet credit entries can be compared where those records are available.

Can Cointab reconcile expired or forfeited bonuses?

Yes. Expired bonuses, forfeited promotional balances, unused promotions, and campaign-end removals can be matched with wallet ledger entries.

Can Cointab identify duplicate bonus credits?

Yes. Duplicate bonus credits can be flagged where the same bonus ID, campaign ID, player ID, wallet transaction ID, or promotion reference appears more than once.

Can Cointab compare bonus balances?

Yes. Cointab can compare opening bonus balance, bonus credits, bonus usage, bonus winnings, expiries, reversals, adjustments, and closing bonus balance.

Can Cointab validate campaign rules?

Cointab can help compare bonus issuance and usage against available campaign data such as campaign dates, eligibility, bonus caps, expiry dates, player segments, and usage limits.

Can Cointab handle multiple bonus wallet types?

Yes. Bonus wallet, cash wallet, locked wallet, withdrawable wallet, non-withdrawable wallet, and total wallet balances can be reconciled if the data is available.

Can I reuse this reconciliation every day, month, or campaign period?

Yes. Once this template is selected and the workflow is used, the same setup can be reused for daily, weekly, monthly, campaign-level, or custom reconciliation periods.

Can this run automatically?

Yes. Once configured, Cointab can receive or pull required reports through email, SFTP, or APIs where available, run reconciliation automatically, and push output back to downstream systems.

What if my bonus or promotion report format is different?

Cointab validates uploaded files against the expected format. If the file format is different, users can correct the file, update the workflow, or create a custom reconciliation.

Can AI help with bonus and promotion reconciliation?

Yes. AI can help match difficult open records, review messy campaign references, analyze exceptions, create derived columns, and suggest possible reasons and next actions.

Can I manually match bonus and promotion records?

Yes. Users can manually match records that the system and AI could not confidently match, and undo manual matches if needed.

Can I download the bonus and promotion reconciliation report?

Yes. Users can download Excel reports with fully matched, partially matched, unmatched, skipped, campaign-level, player-level, and transaction-level details.

Popular reconciliation template

Bonus and Promotion Reconciliation

Reconcile bonus and promotion records across bonus credits, promotional usage, wallet movements, game rounds, wins, reversals, expiries, locked balances, and open items in one structured workflow.

Upload the required bonus, promotion, wallet ledger, game round, player balance, expiry, reversal, and adjustment reports, select the period, run reconciliation, and review fully matched, partially matched, unmatched, and skipped records.

Start this reconciliation Schedule guided setup

View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Bonus / Promotion Report

Wallet Ledger

Game Round / Usage Data

Expiry / Reversal / Balance Data

Cointab Bonus and Promotion Reconciliation

MatchedPartially MatchedUnmatchedSkipped

Reconcile bonus and promotion activity with wallet and usage records

Bonus and promotion activity often flows through campaign systems, wallet ledgers, game rounds, promotional balances, expiry records, and accounting reports. Cointab helps bring these records into one clear reconciliation report.

The Bonus and Promotion Reconciliation template helps finance, operations, risk, and accounting teams compare bonus credits, promotional credits, bonus usage, game round activity, wallet balances, reversals, expiries, and manual adjustments.

This helps teams answer questions such as:

Which bonus credits were correctly posted to player wallets?
Which promotional credits were used in eligible game rounds or transactions?
Which bonus wallet movements do not have matching campaign or promotion records?
Which promotion records are missing from the wallet ledger?
Which bonus amounts were used, expired, reversed, forfeited, or adjusted?
Which bonus winnings, bonus stakes, locked balances, or non-withdrawable balances do not match?
Which campaigns, bonus rules, or player segments created differences?
Which items need wallet correction, campaign review, risk review, finance review, or accounting correction?

This template is useful for gaming platforms, real money gaming businesses, fantasy sports platforms, wallet-based apps, fintech platforms, promotion operations teams, finance teams, risk teams, controllers, CFOs, and accounting firms that need a repeatable bonus and promotion reconciliation process.

Required files for this template

Cointab's ready-made workflow is designed around common bonus reports, promotion reports, wallet ledgers, game round files, player balance reports, expiry reports, reversal reports, adjustment files, ERP exports, and supporting data.

Data source	Example records
Bonus / Promotion Report	Used as the main promotion-side report containing campaign IDs, promotion IDs, bonus IDs, player IDs, bonus type, bonus amount, issued amount, used amount, expired amount, reversal amount, eligibility rules, campaign dates, and promotion status.
Wallet Ledger Report	Used to compare bonus credits, promotional debits, bonus winnings, reversals, expiries, locked wallet movements, and balance changes with actual wallet ledger entries.
Player Bonus Balance Report	Used to compare opening bonus balance, bonus credits, bonus usage, bonus winnings, expired bonus, reversed bonus, locked balance, non-withdrawable balance, and closing bonus balance.
Game Round Report	Optional, but useful where bonus usage needs to be connected with game round stakes, bonus stakes, winnings, losses, cancelled rounds, void rounds, and provider-side activity.
Campaign / Promotion Master	Optional, but useful where bonus rules, eligibility logic, campaign dates, campaign names, user segments, bonus caps, wagering rules, expiry rules, and usage limits need to be validated.
Expiry / Forfeiture Report	Optional, but useful where unused bonus balances expire, are forfeited, or are removed from player wallets after a campaign condition or time limit.
Reversal / Adjustment Report	Optional, but useful where bonus credits, bonus usage, campaign adjustments, manual reversals, risk corrections, or promotional corrections need to be reconciled.
Player Master / Segment File	Optional, but useful where player IDs, user IDs, wallet IDs, KYC status, player segments, campaign eligibility, location, risk category, or account status need to be mapped.
ERP / Accounting Export	Optional, but useful if bonus cost, promotional liability, campaign expense, wallet liability, player balances, or accounting postings are maintained in an ERP, accounting system, internal finance system, or data warehouse.
Supporting Data	Optional supporting files can be used for player mapping, wallet mapping, campaign mapping, promotion type mapping, bonus rule mapping, game provider mapping, GL mapping, entity mapping, risk mapping, or other enrichment.

What Cointab matches in bonus and promotion reconciliation

Cointab compares bonus and promotion records with wallet ledgers, player balances, game rounds, expiry records, reversals, campaign rules, and optional ERP or accounting data.

Bonus credits

Match approved or issued bonus credits with wallet ledger credit entries.

Promotional credits

Compare promotional credits issued through campaigns with wallet movements and player bonus balances.

Bonus usage

Match bonus usage records with wallet debits, game round stakes, promotional transactions, or eligible activity.

Bonus winnings

Compare bonus winnings, promotional winnings, locked winnings, and non-withdrawable winnings with wallet credits.

Expired and forfeited bonuses

Match expired bonus balances, forfeitures, unused promotions, and campaign-end removals with wallet ledger entries.

Reversals and adjustments

Compare bonus reversals, campaign corrections, manual adjustments, risk corrections, and wallet correction entries.

Campaign and eligibility records

Check whether bonus issuance and usage match campaign eligibility, player segments, campaign dates, usage limits, bonus caps, and rule logic.

Player bonus balances

Compare opening balance, bonus credits, bonus debits, bonus usage, reversals, expiries, and closing bonus balance.

Internal records, if added

If ERP, accounting, risk, payment, bank, or game provider data is included, Cointab can connect bonus and promotion records with wider finance and control workflows.

Common bonus and promotion reconciliation exceptions

Cointab helps finance, operations, and risk teams focus on bonus differences instead of manually reviewing every campaign, wallet entry, game round, bonus credit, usage record, and balance movement.

Bonus issued but not credited to wallet

A bonus is approved or issued in the promotion report but is not found as a wallet credit.

Wallet bonus credit without promotion record

A bonus wallet credit appears, but there is no matching bonus, promotion, campaign, or approval record.

Bonus amount mismatch

The bonus ID, campaign ID, player ID, or wallet reference appears to match, but the issued bonus amount and wallet credit amount differ.

Bonus usage not found in wallet

A promotion or game round shows bonus usage, but the matching wallet debit is missing.

Wallet bonus debit without usage record

A bonus debit appears in the wallet ledger but does not clearly match game round usage, campaign usage, expiry, reversal, or adjustment records.

Bonus win mismatch

Bonus winnings or promotional winnings do not match game round or wallet records.

Expired bonus not removed

A bonus balance should have expired or been forfeited but remains in the player wallet.

Bonus removed without expiry record

A bonus balance is reduced, but there is no matching expiry, forfeiture, reversal, usage, or adjustment record.

Duplicate bonus credit

The same bonus, promotion, campaign entry, or wallet credit appears more than once.

Wrong player allocation

A bonus, promotion, usage, reversal, or wallet movement is mapped to the wrong player, user ID, wallet, segment, campaign, or entity.

Wrong campaign allocation

A wallet movement is linked to the wrong campaign, promotion, bonus type, game, source, or eligibility rule.

Timing difference

A bonus or promotion belongs to one campaign period but is credited, used, expired, reversed, or posted in another period.

Locked balance mismatch

Locked, non-withdrawable, withdrawable, bonus, or promotional balance does not match expected movement.

Campaign rule mismatch

Bonus issuance or usage does not follow expected campaign eligibility, caps, expiry rules, wagering rules, or usage limits.

Missing or unclear reference

Player ID, wallet ID, bonus ID, campaign ID, promotion ID, game round ID, transaction ID, or wallet narration 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 bonus and promotion reconciliation setup every period.

Select the template

Choose Bonus and Promotion 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 bonus, promotion, and wallet reports

Upload the bonus or promotion report, wallet ledger report, and any required player balance, game round, campaign master, expiry, reversal, adjustment, ERP, risk, 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 bonus, promotion, wallet, game round, expiry, and balance 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:

Player IDUser IDWallet IDWallet transaction IDBonus IDPromotion IDCampaign IDCampaign nameBonus typePromotion typePlayer segmentEligibility referenceGame IDRound IDSession IDProvider transaction IDTransaction typeBonus statusPromotion statusWallet transaction statusIssued bonus amountPosted bonus amountUsed bonus amountBonus stake amountBonus winning amountExpired bonus amountForfeited bonus amountReversed bonus amountAdjustment amountOpening bonus balanceClosing bonus balanceLocked balanceWithdrawable balanceNon-withdrawable balanceCampaign start dateCampaign end dateBonus issue dateBonus usage dateExpiry datePosting dateDerived or cleaned identifiers

Matching scenarios

One-to-one
One bonus or promotion record matches one wallet ledger entry.
One-to-many
One bonus campaign record maps to multiple wallet credits, game round usages, expiries, reversals, or adjustment entries.
Many-to-one
Multiple bonus records are grouped into one wallet posting, campaign batch, or accounting entry.
Many-to-many
Multiple bonus records, promotion records, wallet entries, game round records, and balance movements are grouped and compared together.
Partial matching
Identifiers match, but issued amount, posted amount, used amount, expired amount, reversed amount, or balance movement differs.
Campaign-level matching
Campaign-issued bonus totals, wallet credits, usage totals, expiries, reversals, and remaining balances are compared together.
Player-level matching
Player-wise bonus credits, usage, wins, expiries, reversals, and balances are compared together.
Balance-level matching
Opening bonus balance, bonus credits, bonus usage, bonus winnings, expiries, reversals, adjustments, and closing bonus balance are compared together.
Net and contra matching
Bonus credits, bonus usage, winnings, expiries, forfeitures, reversals, chargebacks, cancellations, manual corrections, and balance movements are netted where required.

AI-assisted transaction matching

After structured rules run, AI helps match difficult open transactions where:

References are incomplete
Bonus IDs are missing or inconsistent
Campaign IDs are formatted differently
Wallet references appear inside long narration fields
One campaign creates multiple wallet entries
One wallet movement is split across bonus, cash, locked, or withdrawable balances
Bonus usage is recorded differently across wallet and game round reports
Expiry and forfeiture records do not directly link to original bonus credits
Campaign rules require contextual review
Manual adjustments need reason analysis
Amounts require business context
Multiple possible causes exist for the same bonus difference

AI exception analysis

For transactions that remain open, AI can help identify possible reasons such as:

Bonus not creditedWallet credited without promotion recordBonus amount mismatchBonus usage missingBonus debit without usage recordBonus win mismatchExpired bonus not removedBonus removed without expiry recordDuplicate bonus creditWrong player allocationWrong campaign allocationTiming differenceLocked balance mismatchCampaign rule mismatchManual adjustment issueInternal system issueUnclear reference

AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.

Audit-ready bonus and promotion reconciliation reports

Cointab gives your team a clear report showing which bonus, promotion, wallet, game round, expiry, reversal, and balance records matched, partially matched, remained unmatched, or were skipped.

Report categories

Fully matched
Bonus, promotion, wallet, usage, expiry, reversal, and balance records where identifiers, statuses, and amounts match.
Partially matched
Records where identifiers match but issued amount, wallet amount, used amount, expired amount, reversed amount, or balance amount differs.
Unmatched in bonus or promotion records
Wallet credits, wallet debits, game round usage, expiry, reversal, or adjustment records that do not clearly match bonus or promotion records.
Unmatched in wallet ledger
Bonus or promotion records that do not clearly match wallet ledger entries.
Campaign differences
Records where campaign totals, bonus issuance, usage, expiry, reversal, or remaining balances require review.
Bonus usage differences
Records where promotional usage, bonus stakes, bonus debits, or game round usage requires review.
Bonus winning differences
Records where bonus winnings, promotional wins, locked winnings, or wallet credits require review.
Expiry and forfeiture differences
Records where expired bonus, forfeited bonus, unused promotions, or campaign-end removals require review.
Balance differences
Records where opening bonus balance, bonus movement, locked balance, withdrawable balance, or closing bonus balance does not agree.
Rule or eligibility differences
Records where campaign eligibility, bonus caps, segment rules, usage limits, or expiry logic requires review.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

Summary cards
Transaction-level details
Player-level filters
Campaign-level filters
Promotion type filters
Bonus status filters
Difference amounts
Campaign-level totals
Player bonus balance view
Matched transaction drill-down
Manual match
Undo manual match
Excel export
Audit-friendly output

Automate recurring bonus and promotion 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:

EmailSFTPAPI integrations, where available

Run automatically

Schedule reconciliation:

DailyWeeklyMonthlyEnd of campaignAt month-end closeAfter bonus report exportAfter wallet ledger exportAfter game round report receiptAfter expiry report receiptAfter all required files are availableAt a custom frequency

Push output back

Send reconciliation output to:

ERPAccounting systemInternal wallet systemCampaign management systemPromotion operations dashboardGame operations dashboardRisk or compliance dashboardBI dashboardInternal finance systemAnalytics databaseData warehouseInternal exception trackerWallet correction workflowCampaign review workflowAudit or compliance system

Matched bonus credits
Matched promotional usage
Matched bonus expiries
Matched bonus reversals
Unmatched bonus records
Unmatched wallet entries
Bonus amount differences
Bonus usage differences
Bonus winning differences
Expired bonus differences
Locked balance differences
Campaign rule differences
Duplicate bonus credits
Wrong player allocation records
Wrong campaign allocation records
Timing differences
Open items
Suggested actions
Excel reconciliation report
Structured API output

View a bonus and promotion reconciliation demo report

See how Cointab presents Bonus and Promotion Reconciliation output with matched, partially matched, unmatched, and skipped records.

Bonus and Promotion Reconciliation Demo

Explore a sample report showing bonus credits, promotional usage, wallet movements, game rounds, bonus winnings, expired bonuses, reversals, locked balance differences, campaign differences, and open items.

View demo report

Explore related bonus, wallet, and gaming reconciliations

Cointab supports other wallet, deposit, withdrawal, game round, refund, bank, payment gateway, books, ERP, and finance reconciliation workflows.

Wallet Ledger Reconciliation

Reconcile wallet credits, debits, deposits, withdrawals, bonuses, refunds, reversals, and balances.

View template

Player Wallet Balance Reconciliation

Reconcile opening balances, wallet credits, wallet debits, deposits, withdrawals, game rounds, bonuses, refunds, reversals, and closing balances.

View template

Player Wallet vs Game Rounds

Reconcile player wallet ledger movements with game round records across stakes, winnings, bonuses, refunds, and reversals.

View template

Player Deposits vs Payment Gateway

Reconcile player deposit records with payment gateway reports across wallet top-ups, successful payments, failed deposits, refunds, and chargebacks.

View template

Refund and Reversal Reconciliation

Reconcile refunds, reversals, failed refunds, chargebacks, bank debits, customer ledgers, and accounting records.

View template

Bank Statement vs Books

Compare bank statement entries with accounting or books records.

View template

Built for teams reconciling bonus and promotion activity

This template is useful for teams that regularly reconcile bonus credits, promotional usage, campaign rules, wallet movements, game rounds, expiries, reversals, and player bonus balances.

Gaming platforms

For platforms reconciling bonuses, promotions, wallet credits, bonus usage, game round activity, expiries, and reversals.

Real money gaming businesses

For businesses that need controlled, audit-ready reconciliation of bonus liability, promotional cost, wallet balances, and campaign usage.

Fantasy sports platforms

For teams reconciling contest bonuses, referral credits, promotional wallet balances, bonus usage, rewards, and reversals.

Wallet-based apps

For apps that maintain promotional credits, bonus wallets, locked balances, and campaign-driven user balances.

Promotion operations teams

For teams reviewing campaign issuance, eligibility, usage, expiry, and promotion-level performance differences.

Game operations teams

For teams reviewing bonus stakes, bonus winnings, cancelled rounds, voided rounds, and provider-side game activity.

Risk and compliance teams

For teams reviewing bonus abuse, suspicious promotional credits, duplicate bonus entries, incorrect eligibility, and audit trails.

Finance teams

For teams preparing recurring bonus and promotion reconciliation reports for daily review, campaign close, month-end close, reporting, and audit.

Accounting teams

For teams reconciling promotional liabilities, campaign expenses, bonus costs, wallet balances, reversals, and accounting postings.

Controllers

For controllers who need visibility into unexplained bonus differences, duplicate credits, campaign rule gaps, and balance mismatches.

CFOs

For finance leaders who want stronger control over promotional spend, bonus liabilities, player balances, accounting accuracy, and audit readiness.

Accounting firms

For CA, CPA, or outsourced accounting teams handling gaming, wallet, campaign, and bonus reconciliation for multiple clients.

Trusted by teams handling bonus and promotion reconciliation

Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across bonuses, promotions, player wallets, campaign systems, game rounds, payment gateways, banks, books, ERP systems, partner reports, 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.”
— Urbanic

Bonus and Promotion Reconciliation FAQs

Start Bonus and Promotion Reconciliation

Use Cointab's ready-made bonus and promotion reconciliation workflow to match bonus credits, promotional usage, wallet movements, game rounds, expiries, reversals, balances, review exceptions, and export audit-ready reports.

Start this reconciliation Schedule guided setup

View demo report

Ready-made workflow · Reusable every period · Manual upload and automation supported

Bonus and Promotion Reconciliation

Reconcile bonus and promotion records across bonus credits, promotional usage, wallet movements, game rounds, wins, reversals, expiries, locked balances, and open items in one structured workflow.

View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Data source

Example records

Bonus / Promotion Report

Used as the main promotion-side report containing campaign IDs, promotion IDs, bonus IDs, player IDs, bonus type, bonus amount, issued amount, used amount, expired amount, reversal amount, eligibility rules, campaign dates, and promotion status.

Wallet Ledger Report

Used to compare bonus credits, promotional debits, bonus winnings, reversals, expiries, locked wallet movements, and balance changes with actual wallet ledger entries.

Player Bonus Balance Report

Used to compare opening bonus balance, bonus credits, bonus usage, bonus winnings, expired bonus, reversed bonus, locked balance, non-withdrawable balance, and closing bonus balance.

Game Round Report

Optional, but useful where bonus usage needs to be connected with game round stakes, bonus stakes, winnings, losses, cancelled rounds, void rounds, and provider-side activity.

Campaign / Promotion Master

Optional, but useful where bonus rules, eligibility logic, campaign dates, campaign names, user segments, bonus caps, wagering rules, expiry rules, and usage limits need to be validated.

Expiry / Forfeiture Report

Optional, but useful where unused bonus balances expire, are forfeited, or are removed from player wallets after a campaign condition or time limit.

Reversal / Adjustment Report

Optional, but useful where bonus credits, bonus usage, campaign adjustments, manual reversals, risk corrections, or promotional corrections need to be reconciled.

Player Master / Segment File

Optional, but useful where player IDs, user IDs, wallet IDs, KYC status, player segments, campaign eligibility, location, risk category, or account status need to be mapped.

ERP / Accounting Export

Optional, but useful if bonus cost, promotional liability, campaign expense, wallet liability, player balances, or accounting postings are maintained in an ERP, accounting system, internal finance system, or data warehouse.

Supporting Data

Optional supporting files can be used for player mapping, wallet mapping, campaign mapping, promotion type mapping, bonus rule mapping, game provider mapping, GL mapping, entity mapping, risk mapping, or other enrichment.

Start Bonus and Promotion Reconciliation

View demo report

Ready-made workflow · Reusable every period · Manual upload and automation supported