What is OTA / Partner Settlement Reconciliation?

OTA / Partner Settlement Reconciliation is the process of comparing OTA or partner settlement reports with internal booking, refund, cancellation, commission, bank, invoice, and accounting records to identify matched settlements, missing bookings, short settlements, fee differences, refund differences, tax differences, and open items.

What files are required?

The main files are usually the OTA or partner settlement report and internal booking report. Depending on the workflow, commission reports, refund reports, cancellation reports, invoice files, credit notes, bank statements, supplier statements, ERP exports, or supporting data may also be used.

Can Cointab identify partner settlement entries missing from internal bookings?

Yes. Cointab can show OTA or partner settlement entries that do not clearly match internal booking records.

Can Cointab identify bookings missing from OTA settlement reports?

Yes. Internal booking records that do not clearly match OTA or partner settlement entries can be shown separately for review.

Can Cointab reconcile OTA commissions?

Yes. OTA commission, partner commission, platform fee, service fee, marketing fee, discount sharing, and other commercial deductions can be compared where the data is available.

Can Cointab identify short settlements?

Yes. Cointab can compare expected settlement with actual partner payout after considering commissions, refunds, cancellations, taxes, deductions, and adjustments.

Can Cointab identify excess settlements?

Yes. Excess settlements can be flagged where the partner payout is higher than expected or where refunds, deductions, duplicate bookings, or adjustments need review.

Can Cointab reconcile refunds and cancellations?

Yes. Full refunds, partial refunds, cancellations, no-show charges, partner credits, cancellation fees, and refund reversals can be included where the required data is available.

Can Cointab reconcile partner invoices and credit notes?

Yes. Invoices, credit notes, debit notes, adjustment notes, taxes, and outstanding balances can be compared where the data is available.

Can Cointab compare settlements with bank credits?

Yes. Bank statements can be added to trace OTA or partner payout records to actual bank statement credits.

Can Cointab reconcile taxes and statutory deductions?

Yes. GST, VAT, TDS, TCS, withholding, tourism tax, service tax, and other tax or statutory deductions can be compared where the data is available.

Can Cointab handle multiple OTAs or partners?

Yes. Multiple OTA and partner settlement files can be reconciled using partner IDs, OTA names, settlement IDs, booking references, payout dates, and bank references.

Can I reuse this reconciliation every settlement cycle or month?

Yes. Once this template is selected and the workflow is used, the same setup can be reused for daily, weekly, monthly, partner payout cycle, settlement cycle, booking cycle, 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 OTA or partner 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 OTA and partner settlement reconciliation?

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

Can I manually match OTA and partner settlement 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 OTA and partner settlement reconciliation report?

Yes. Users can download Excel reports with fully matched, partially matched, deducted, refunded, unmatched, skipped, booking-level, partner-level, OTA-level, settlement-level, invoice-level, and transaction-level details.

Popular reconciliation template

OTA / Partner Settlement Reconciliation

Reconcile OTA and partner settlement reports with internal booking, payment, refund, cancellation, commission, supplier, bank, and accounting records in one structured workflow.

Upload the required OTA or partner settlement report, booking report, payment report, refund and cancellation data, bank statement, and accounting records, select the period, run reconciliation, and review fully matched, partially matched, unmatched, deducted, refunded, and skipped records.

Start this reconciliation Schedule guided setup

View demo report

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

OTA / Partner Settlement Report

Internal Booking Report

Refund / Cancellation / Commission Data

Bank / Accounting / Invoice Data

Cointab OTA-Partner Settlement Reconciliation

MatchedPartially MatchedDeductedRefundedUnmatchedSkipped

Reconcile OTA and partner settlements with internal booking records

OTA and partner settlement reports often include bookings, commissions, platform fees, cancellations, refunds, chargebacks, deductions, taxes, and payout values in a format that does not directly match internal booking and accounting reports. Cointab helps bring these records into one clear reconciliation report.

The OTA / Partner Settlement Reconciliation template helps finance, operations, and accounting teams compare partner settlement reports with internal booking records, supplier records, payment data, refund reports, bank statements, and accounting ledgers.

This helps teams answer questions such as:

Which OTA or partner settlement entries match internal booking records?
Which partner-settled bookings are missing from the internal booking system?
Which internal bookings are missing from the OTA or partner settlement report?
Which commissions, platform fees, discounts, refunds, cancellations, and deductions explain the settlement amount?
Which OTA payouts were received in the bank?
Which partner settlements were short-paid, overpaid, delayed, reversed, or adjusted?
Which invoices, credit notes, GST, VAT, TDS, TCS, withholding, or other tax amounts need review?
Which items need OTA follow-up, partner follow-up, booking system correction, finance review, or accounting correction?

This template is useful for travel companies, hotel booking platforms, tour operators, ticketing platforms, hospitality businesses, online booking marketplaces, finance teams, accounts receivable teams, accounts payable teams, controllers, CFOs, and accounting firms that need a repeatable OTA and partner settlement reconciliation process.

Required files for this template

Cointab's ready-made workflow is designed around common OTA settlement reports, partner payout reports, booking reports, invoice files, refund reports, cancellation reports, commission reports, bank statements, ERP exports, and supporting travel finance files.

Data source	Example records
OTA / Partner Settlement Report	Used as the partner-side report containing partner booking references, settlement IDs, payout dates, booking values, commission, deductions, refunds, cancellation amounts, taxes, net payout values, and settlement status.
Internal Booking Report	Used as the internal source-of-truth report containing booking IDs, customer IDs, guest names, supplier names, booking dates, service dates, booking amounts, booking status, payment status, cancellation status, and refund status.
Partner Commission / Fee Report	Optional, but useful where OTA commission, partner commission, platform fees, service fees, convenience fees, marketing fees, discount sharing, or commercial deductions need to be reconciled.
Refund Report	Optional, but useful where full refunds, partial refunds, failed refunds, delayed refunds, partner refunds, or customer refunds affect settlement values.
Cancellation Report	Optional, but useful where cancelled bookings, no-show charges, cancellation penalties, supplier charges, refund eligibility, or cancellation timestamps need to be compared.
Partner Invoice / Credit Note Report	Optional, but useful where invoices, credit notes, debit notes, tax invoices, partner charges, supplier credits, and adjustment notes need to be reconciled.
Bank Statement	Optional, but useful where OTA payouts, partner settlements, bank credits, bank charges, reversals, and settlement UTRs need to be compared with actual bank movements.
Supplier Statement	Optional, but useful where the partner settlement also needs to be compared with supplier-side payables, supplier invoices, hotel statements, airline reports, tour operator statements, or vendor ledgers.
Channel / Partner Master	Optional, but useful where partner IDs, OTA names, vendor codes, commission terms, payout cycles, tax settings, contract terms, and settlement rules need to be mapped.
ERP / Accounting Export	Optional, but useful if booking revenue, partner receivables, supplier payables, commissions, taxes, refunds, settlements, and bank postings are maintained in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another accounting system.
Supporting Data	Optional supporting files can be used for booking mapping, partner mapping, OTA mapping, customer mapping, invoice mapping, refund mapping, settlement mapping, bank mapping, supplier mapping, GL mapping, tax mapping, entity mapping, or other enrichment.

What Cointab matches in OTA and partner settlement reconciliation

Cointab compares OTA or partner settlement records with internal booking records, refund files, cancellation reports, commission reports, bank statements, invoices, credit notes, and accounting ledgers.

Partner settlements and bookings

Match OTA or partner settlement lines with internal booking records.

Booking and partner references

Compare booking IDs, partner booking IDs, OTA confirmation numbers, reservation IDs, invoice numbers, voucher numbers, payment references, settlement IDs, and UTRs.

Customer, guest, and service details

Compare customer names, guest names, check-in dates, check-out dates, travel dates, event dates, service dates, routes, product details, package details, room nights, tickets, or booking channels where available.

Gross booking value

Compare internal booking value with partner-reported gross booking value, base fare, room value, package value, ticket value, taxes, fees, and total sale amount.

Commission and fee deductions

Compare OTA commission, partner commission, platform fees, service fees, convenience fees, marketing fees, payment fees, discount sharing, and commercial deductions.

Refunds and cancellations

Match cancellations, no-shows, full refunds, partial refunds, refund reversals, partner credits, customer refunds, and cancellation charges.

Settlement and payout amounts

Compare gross value, deductions, refunds, taxes, commissions, net settlement amount, paid amount, outstanding amount, and bank credit amount.

Taxes and statutory deductions

Compare GST, VAT, TDS, TCS, withholding, tourism tax, service tax, local tax, and other statutory deductions where applicable.

Bank credits

If bank statements are included, compare partner payout records with actual bank credits, UTRs, settlement dates, and bank charges.

Accounting postings

If ERP or accounting data is included, compare partner receivables, booking revenue, commission expense, supplier payables, refund liabilities, taxes, settlements, bank entries, and journal postings.

Common OTA and partner settlement reconciliation exceptions

Cointab helps finance teams focus on settlement differences instead of manually reviewing every booking, partner payout, refund, cancellation, commission, deduction, and bank entry.

Partner settlement entry not found in bookings

An OTA or partner settlement entry appears without a matching internal booking record.

Booking not found in partner settlement

An internal booking exists but does not appear in the OTA or partner settlement report.

Settlement amount mismatch

The booking or settlement reference appears to match, but the partner settlement amount differs from the expected internal amount.

Commission mismatch

OTA commission, partner commission, platform fee, service fee, or commercial deduction differs from expected terms.

Refund mismatch

A refund appears in one report but is missing, delayed, failed, reversed, or recorded differently in another report.

Cancellation mismatch

A booking is cancelled internally, but the partner settlement shows it as payable, paid, refunded, partially refunded, or deducted differently.

No-show or penalty mismatch

No-show charges, cancellation penalties, supplier deductions, or partner penalties do not match expected values.

Tax mismatch

GST, VAT, TDS, TCS, withholding, tourism tax, service tax, or other tax amounts differ across reports.

Short settlement

The partner payout is lower than expected after considering commission, refunds, taxes, deductions, and adjustments.

Excess settlement

The partner payout is higher than expected and may indicate duplicate booking, incorrect deduction, refund missing, or partner-side adjustment.

Settlement received but not posted

A partner payout appears in the bank statement but is missing from internal settlement or accounting records.

Settlement recorded but bank credit missing

The OTA or partner report shows settlement paid, but no matching bank credit is found.

Duplicate settlement

The same booking, settlement ID, partner reference, invoice, payout, or UTR appears more than once.

Invoice or credit note mismatch

Partner invoice, credit note, debit note, or adjustment amount does not match settlement or internal booking data.

Timing difference

A booking belongs to one period internally but appears in the partner settlement, invoice, bank statement, or accounting ledger in another period.

Wrong partner allocation

A booking, settlement, refund, fee, tax, or adjustment is mapped to the wrong OTA, partner, supplier, channel, branch, entity, GL account, or business unit.

Missing or unclear reference

Booking ID, partner booking ID, OTA confirmation number, invoice number, settlement ID, UTR, payout reference, guest name, or 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 OTA and partner settlement reconciliation setup every period.

Select the template

Choose OTA / Partner Settlement Reconciliation from popular reconciliations.

Select the period

Choose the day, week, month, quarter, booking cycle, partner payout cycle, settlement cycle, financial year, lifetime period, or custom period you want to reconcile.

Upload partner settlement and booking reports

Upload the OTA or partner settlement report, booking report, and any required commission, refund, cancellation, invoice, credit note, supplier, bank, 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 OTA, partner settlement, booking, refund, cancellation, commission, tax, bank, and accounting data.

Review output

View fully matched, partially matched, unmatched, deducted, refunded, 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:

Booking IDPartner booking IDOTA confirmation numberReservation IDVoucher numberInvoice numberCredit note numberSettlement IDPayout IDUTRBank referencePayment referenceCustomer IDGuest nameCustomer nameSupplier IDSupplier nameOTA namePartner IDChannel codeVendor codeProduct codeService codeBooking statusPartner booking statusSettlement statusPayment statusRefund statusCancellation statusInvoice statusAccounting statusBooking amountPartner gross amountCommission amountPlatform fee amountService fee amountMarketing fee amountDiscount amountTaxable amountTax amountTDS amountTCS amountWithholding amountRefund amountCancellation amountNo-show charge amountAdjustment amountCredit note amountDebit note amountNet settlement amountBank credit amountOutstanding amountBooking dateService dateTravel dateCheck-in dateCheck-out dateCancellation dateRefund dateInvoice dateSettlement datePayout dateBank credit datePosting dateAccounting periodDerived or cleaned identifiers

Matching scenarios

One-to-one
One internal booking record matches one OTA or partner settlement entry.
One-to-many
One booking maps to multiple partner settlement lines, fee lines, commission lines, tax lines, refund records, credit notes, or bank entries.
Many-to-one
Multiple bookings are grouped into one partner settlement, payout batch, bank credit, invoice, or accounting entry.
Many-to-many
Multiple booking records, partner settlement entries, refunds, cancellations, invoices, credit notes, deductions, and bank records are grouped and compared together.
Partial matching
Identifiers match, but booking amount, commission, refund, tax, deduction, net settlement amount, or status differs.
Status-level matching
Booking status, partner status, refund status, cancellation status, settlement status, invoice status, bank status, and accounting status are compared together.
Partner-level matching
All bookings, commissions, refunds, deductions, settlements, payments, invoices, credits, and outstanding balances for a partner are grouped and compared.
Settlement-level matching
Settlement batches, partner payouts, UTRs, bank credits, fees, refunds, chargebacks, deductions, taxes, and net settlement values are compared together.
Invoice-level matching
Partner invoices, credit notes, debit notes, booking values, taxes, commissions, deductions, and net payable or receivable amounts are compared invoice-wise.
Net and contra matching
Bookings, commissions, refunds, cancellations, no-shows, partner credits, debit notes, credit notes, taxes, bank charges, settlements, and accounting adjustments are netted where required.

AI-assisted transaction matching

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

References are incomplete
Partner booking IDs are missing or formatted differently
OTA confirmation numbers are inconsistent
Booking IDs are embedded inside narration fields
Guest names are written differently
Partner names are written differently
One partner settlement contains multiple bookings
One booking appears across multiple settlement, refund, and fee lines
Refunds or credit notes do not clearly link to original bookings
Commission and deduction descriptions are inconsistent
Bank narration is messy
Tax and withholding treatment requires contextual review
Amounts require business context
Multiple possible matches exist

AI exception analysis

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

Partner settlement entry missing internallyBooking missing in partner settlementSettlement amount mismatchCommission mismatchFee mismatchRefund mismatchCancellation mismatchNo-show penalty mismatchTax mismatchShort settlementExcess settlementSettlement received but not postedSettlement recorded but bank credit missingDuplicate settlementInvoice mismatchCredit note mismatchWrong partner allocationPosting period differencePartner reporting issueInternal booking system issueUnclear reference

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

Audit-ready OTA and partner settlement reconciliation reports

Cointab gives your team a clear report showing which OTA settlement, partner payout, booking, refund, cancellation, commission, invoice, bank, and accounting records matched, partially matched, remained unmatched, or were skipped.

Report categories

Fully matched
Booking and OTA or partner settlement records where identifiers, statuses, and amounts match.
Partially matched
Records where identifiers match but booking amount, commission, refund, tax, deduction, settlement amount, or status differs.
Unmatched in internal bookings
OTA or partner settlement entries that do not clearly match internal booking records.
Unmatched in partner settlement
Internal booking records that do not clearly match OTA or partner settlement entries.
Commission and fee differences
Records where OTA commission, partner commission, platform fee, marketing fee, service fee, or commercial deduction requires review.
Refund and cancellation differences
Records where refunds, cancellations, no-shows, cancellation charges, partial refunds, or partner credits require review.
Tax and deduction differences
Records where GST, VAT, TDS, TCS, withholding, tourism tax, service tax, or other deductions require review.
Settlement differences
Records where net settlement amount, payout amount, settlement ID, UTR, payout date, or partner settlement status requires review.
Bank differences
Records where partner settlement is not found in bank, bank credit is not found in settlement, or amount/date differs.
Invoice and credit note differences
Records where invoice number, invoice amount, credit note, debit note, adjustment, or outstanding value requires review.
Accounting differences
Records where partner receivable, supplier payable, booking revenue, commission, refund, tax, bank, or journal entry requires review.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

Summary cards
Transaction-level details
Booking-level filters
Partner-level filters
OTA-level filters
Settlement-level filters
Invoice-level filters
Refund and cancellation filters
Difference amounts
Partner payout view
Matched transaction drill-down
Manual match
Undo manual match
Excel export
Audit-friendly output

Automate recurring OTA and partner settlement 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:

DailyWeeklyMonthlyQuarterlyBooking cycle-wisePartner payout cycle-wiseSettlement cycle-wiseAt month-end closeAfter OTA settlement report receiptAfter partner payout file receiptAfter booking report exportAfter refund or cancellation report receiptAfter bank statement receiptAfter accounting ledger exportAfter all required files are availableAt a custom frequency

Push output back

Send reconciliation output to:

Booking systemERPAccounting systemPartner settlement dashboardAccounts receivable dashboardAccounts payable dashboardFinance operations dashboardBI dashboardInternal finance systemAnalytics databaseData warehouseInternal exception trackerOTA follow-up workflowPartner follow-up workflowPayment approval workflowAccounting close workflowAudit or compliance system

Matched OTA settlement records
Matched partner settlement records
Matched booking records
Matched bank credits
Unmatched internal bookings
Unmatched partner settlement entries
Settlement amount differences
Commission differences
Platform fee differences
Refund differences
Cancellation differences
No-show penalty differences
Tax differences
Short settlement records
Excess settlement records
Invoice differences
Credit note differences
Wrong partner allocation records
Timing differences
Open items
Suggested actions
Excel reconciliation report
Structured API output

View an OTA and partner settlement demo report

See how Cointab presents OTA / Partner Settlement Reconciliation output with matched, partially matched, deducted, refunded, unmatched, and skipped records.

OTA / Partner Settlement Reconciliation Demo

Explore a sample report showing OTA settlement entries, partner payout records, internal bookings, commissions, refunds, cancellations, tax deductions, settlement IDs, bank credits, invoice differences, and open items.

View demo report

Explore related booking, partner, and settlement reconciliations

Cointab supports other booking, OTA, supplier, payment gateway, bank, refund, vendor, books, ERP, and finance reconciliation workflows.

Bookings vs Payment Gateway

Reconcile booking records with payment gateway reports across paid bookings, failed payments, refunds, cancellations, gateway fees, and settlements.

View template

Bookings vs Supplier Statement

Reconcile booking records with supplier statements across supplier invoices, cancellations, refunds, credits, commissions, taxes, and payables.

View template

Cancellations vs Refunds

Reconcile cancellation records with refund reports across expected refunds, actual refunds, failed refunds, deductions, and reversals.

View template

Payment Gateway Settlement vs Bank

Reconcile payment gateway settlements with actual bank statement credits.

View template

Vendor Ledger vs Vendor Statement

Reconcile internal vendor ledgers with vendor statements across invoices, credit notes, payments, deductions, and outstanding balances.

View template

Bank Statement vs Books

Compare bank statement entries with accounting or books records.

View template

Built for teams reconciling OTA and partner settlements

This template is useful for teams that regularly reconcile OTA settlements, partner payouts, bookings, commissions, refunds, cancellations, deductions, invoices, bank credits, and accounting records.

Travel companies

For travel businesses reconciling OTA settlements, partner payouts, customer bookings, refunds, cancellations, commissions, and bank receipts.

Hotel booking platforms

For platforms reconciling hotel OTA payouts, booking values, room-night settlements, commissions, cancellation charges, no-shows, and supplier balances.

Tour operators

For tour and activity operators reconciling partner bookings, OTA settlements, supplier charges, commissions, credits, and payout records.

Ticketing platforms

For platforms reconciling airline, bus, rail, event, or attraction partner settlements with booking records, refunds, cancellations, and payment data.

Online booking marketplaces

For marketplaces reconciling bookings across multiple partners, suppliers, vendors, OTAs, sellers, service providers, settlement files, invoices, and credits.

Hospitality businesses

For hotel chains, serviced apartments, resorts, and hospitality finance teams reconciling OTA settlement files with property bookings and bank credits.

Accounts receivable teams

For teams reviewing partner receivables, settlement collections, OTA payouts, short settlements, deductions, and outstanding amounts.

Accounts payable teams

For teams reviewing partner or supplier payables, credits, deductions, commissions, invoices, and payment approvals.

Finance teams

For teams preparing recurring OTA and partner settlement reconciliation reports for daily review, month-end close, reporting, and audit.

Accounting teams

For teams reconciling booking revenue, partner receivables, supplier payables, commissions, refunds, taxes, bank credits, and accounting postings.

Controllers

For controllers who need visibility into short settlements, commission differences, refund gaps, partner deductions, bank posting issues, and tax differences.

CFOs

For finance leaders who want stronger control over partner settlements, booking revenue, payout accuracy, deduction visibility, accounting accuracy, and audit readiness.

Accounting firms

For CA, CPA, or outsourced accounting teams handling travel, hospitality, ticketing, OTA, partner settlement, supplier, and booking reconciliation for multiple clients.

Trusted by teams handling OTA and partner settlement reconciliation

Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across OTA settlements, partner payouts, booking systems, supplier statements, 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.”
— Urbanic

OTA / Partner Settlement Reconciliation FAQs

Start OTA / Partner Settlement Reconciliation

Use Cointab's ready-made OTA and partner settlement reconciliation workflow to match bookings, partner payouts, commissions, refunds, cancellations, deductions, invoices, bank credits, accounting postings, 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

OTA / Partner Settlement Reconciliation

Reconcile OTA and partner settlement reports with internal booking, payment, refund, cancellation, commission, supplier, bank, and accounting records in one structured workflow.

View demo report

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

Data source

Example records

OTA / Partner Settlement Report

Used as the partner-side report containing partner booking references, settlement IDs, payout dates, booking values, commission, deductions, refunds, cancellation amounts, taxes, net payout values, and settlement status.

Internal Booking Report

Used as the internal source-of-truth report containing booking IDs, customer IDs, guest names, supplier names, booking dates, service dates, booking amounts, booking status, payment status, cancellation status, and refund status.

Partner Commission / Fee Report

Optional, but useful where OTA commission, partner commission, platform fees, service fees, convenience fees, marketing fees, discount sharing, or commercial deductions need to be reconciled.

Refund Report

Optional, but useful where full refunds, partial refunds, failed refunds, delayed refunds, partner refunds, or customer refunds affect settlement values.

Cancellation Report

Optional, but useful where cancelled bookings, no-show charges, cancellation penalties, supplier charges, refund eligibility, or cancellation timestamps need to be compared.

Partner Invoice / Credit Note Report

Optional, but useful where invoices, credit notes, debit notes, tax invoices, partner charges, supplier credits, and adjustment notes need to be reconciled.

Bank Statement

Optional, but useful where OTA payouts, partner settlements, bank credits, bank charges, reversals, and settlement UTRs need to be compared with actual bank movements.

Supplier Statement

Optional, but useful where the partner settlement also needs to be compared with supplier-side payables, supplier invoices, hotel statements, airline reports, tour operator statements, or vendor ledgers.

Channel / Partner Master

Optional, but useful where partner IDs, OTA names, vendor codes, commission terms, payout cycles, tax settings, contract terms, and settlement rules need to be mapped.

ERP / Accounting Export

Optional, but useful if booking revenue, partner receivables, supplier payables, commissions, taxes, refunds, settlements, and bank postings are maintained in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another accounting system.

Supporting Data

Optional supporting files can be used for booking mapping, partner mapping, OTA mapping, customer mapping, invoice mapping, refund mapping, settlement mapping, bank mapping, supplier mapping, GL mapping, tax mapping, entity mapping, or other enrichment.

Start OTA / Partner Settlement Reconciliation

View demo report

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