Accounting
OTA payout matching
Upload the payout file from Viator, GetYourGuide, Klook, Expedia or any reseller and see every line matched to its booking: paid as expected, paid a different amount, not found, or already paid. Totals show expected against received and the commission actually charged.
Who it's for
Why operators use OTA payout matching
Operators who sell through Viator, GetYourGuide, Klook, Expedia, agents or other resellers and reconcile each payout against bookings in a spreadsheet.
Highlights
- Upload the payout file as CSV or Excel, exactly as the channel exports it
- Map its columns once; the mapping is remembered for that channel
- Lines matched by the channel's reference, your booking reference, or the traveller's name, date and amount
- Each line marked paid as expected, paid a different amount, not found or already paid
- Totals of expected against received, and the commission the channel actually charged
Good to know
- Payouts are in Finance › Payments › OTA payouts, with CSV export. A confirmed payout is kept as the record of what the channel paid.
The spreadsheet between OTA payouts and bookings
Viator, GetYourGuide, Klook, Expedia and resellers pay in batches, net of their commission, with a remittance file listing what each payment covers. Checking that file against your bookings line by line is slow, and a short payment or a booking that was never paid is easy to miss. OTA payout matching does the checking for you.
Upload the payout file as CSV or Excel, as the channel exports it, in any common separator or encoding. Tourtify guesses which column is the reference, the traveller, the date and the amount, and you confirm or change the mapping once. It is remembered for that channel, so next month's file matches straight away.
How lines are matched
Each line is matched first by the channel's own booking reference, then by your booking reference, then by the traveller's name on the activity date with an amount within the difference you allow for rounding and bank fees. Amounts and dates are read as channels write them, such as 1.234,56 or 19/11/2026.
Every line ends up paid as expected, paid a different amount, not found, or already paid on an earlier payout or row, so double payments are caught. You can match or unmatch lines by hand. Totals show what you expected against what arrived and the commission the channel actually charged. Once confirmed, the payout is the record of what the channel paid, with CSV export, and files of several thousand lines match in seconds.
Setting up OTA payout matching
- 1Switch on OTA payout matching. In Plugins, switch it on and set the allowed difference.
- 2Upload a payout file. In Finance › Payments › OTA payouts, upload the file and choose the channel or agent.
- 3Check the mapping and match. Confirm which column is which, match, fix any lines by hand and confirm the payout.
Settings
What you can set up
OTA payout matching works out of the box with sensible defaults. These are the choices you can make, straight from your console.
Matching
- Allowed difference
- In the payout’s currency. A line paid within this much of what you expected counts as matched (rounding and bank fees).
Accounting
How accounting plugins fit in
Accounting plugins keep your books and tax paperwork in step with your bookings: numbered invoices and credit notes, costs and profit per departure, and live sync of every sale, payment and refund to Xero, QuickBooks Online, Zoho Books, Sage or MYOB.
- 1
Switch it on
Open Plugins in your console and turn it on. No code and nothing to install.
- 2
Make your choices
Adjust the settings to match how your business works, or keep the defaults.
- 3
It works everywhere it should
Your website, checkout, emails and console pick it up straight away.
Related
More accounting integrations
Invoices & tax receipts
A numbered invoice for every booking, with your legal name and tax ID, emailed to the traveller as a PDF. Changes, refunds and cancellations get credit notes, so your numbering never has gaps. Export them all for your accountant.
Income & expenses
All the money of your business in one place, not only trip bookings. Record sales of air and bus tickets, vehicle hire, hotels, permits and visas with their cost or commission, take part payments and print receipts. See who owes you and what you owe suppliers, keep cash, bank and wallet accounts, and let your team log expenses with a receipt photo for approval.
Costs & profit
Record what each departure costs: drivers, hotels, park fees, meals. Default costs per tour fill in automatically, guide pay and agent commission are counted, and you see the real profit, margin and break-even of every departure and tour.
Xero
Sends every sale, payment, refund and credit note to Xero as it happens, booked to the accounts and tax rates you choose. No more CSV imports.
Zoho Books
Sends every sale, payment, refund and credit note to Zoho Books as it happens, booked to the accounts and taxes you choose, in your Zoho data centre (India, EU, US, Australia and more).
Sage Accounting
Sends every sale, payment, refund and credit note to Sage Business Cloud Accounting as it happens, booked to the ledger accounts, bank accounts and VAT rates you choose.
FAQ
OTA payout matching: questions
Which channels does it work with?
Any channel, agent or reseller that sends a CSV or Excel payout file, including Viator, GetYourGuide, Klook and Expedia.
Does it need the Channel manager?
No. It matches by references, names, dates and amounts, so bookings entered by hand match too.
What if the channel paid less?
The line is marked as paid a different amount, so you know what to chase.
Which plans include OTA payout matching?
OTA payout matching is available on Growth & Scale, at no extra cost.
How do I switch on OTA payout matching?
In your Tourtify console, open Plugins, find it in the list and switch it on. Its settings open straight away, and you can switch it off again at any time.
Do I need a developer?
No. Plugins are built into Tourtify and set up from the console. Where an outside account is involved, such as a payment provider, you connect it by entering your account details.
Does OTA payout matching work with my other plugins?
Yes. Every plugin is built and maintained by Tourtify, so they work together: discounts, deposits, vouchers and fees all add up correctly at checkout.
Start selling tours direct
Try Tourtify free for 30 days. Add your tours, pick a theme and take your first booking today.