Finance · Payout & bank reconciliation
Every payout and bank transfer matched to its bookings
See which payments, fees and refunds make up each payout from your payment provider, and match bank statement lines to bookings automatically, so the money in your bank always agrees with your bookings.
Overview
Payout & bank reconciliation at a glance
Payouts are synced from your payment provider every few hours. Each one is broken down into the payments, gateway fees and refunds it contains and matched to bookings, and any difference between what was paid out and what Tourtify expected is flagged for you to check.
For bank transfers, import a statement from any bank as CSV or the ISO 20022 CAMT.053 format. Lines are matched to bookings by reference, amount and name, with suggestions for the rest. Matching records the payment and confirms the booking; undo adds a reversal, so nothing disappears from the accounts.
Capabilities
What's included
-
Payout breakdown
Payments, fees and refunds in every payout, linked to their bookings.
-
Differences flagged
Payouts that don't add up are highlighted, with what's missing.
-
Bank statement import
CSV from any bank, or CAMT.053 XML, with remembered column mapping.
-
Automatic matching
By booking reference, amount and payer name, with manual matching for the rest.
-
Safe undo
Reversals instead of deletions, with a full audit trail.
-
Agent settlements
Commission statements per agent and period, with payouts recorded against them.
How each payout is checked
Tourtify syncs payouts every three hours, again whenever Stripe reports a payout change, and whenever someone chooses Sync now. The first sync looks back 90 days, and payouts from the last fortnight are re-read so an in-transit payout moves to paid or failed without anyone checking the provider's dashboard. Stripe is covered as standard, and Square and Razorpay payouts are listed too when their plugins are on.
Every charge and refund in a payout is matched to the payment Tourtify recorded, using the provider's own transaction ID. Each line ends up matched, different from what was expected, missing from Tourtify, or converted, which means the provider settled it in another currency and the amounts can't be compared directly. A late webhook isn't a problem: matching re-runs, so a line that was missing at first is matched once the payment arrives.
Resolving differences and spotting money that never arrived
Some differences have a good explanation, such as an adjustment your provider made by hand. Open the payout, choose Mark as resolved and write how it was settled; the note, your name and the date stay on the payout and in the activity log. If a later sync finds more differences than you explained, the payout reopens by itself, so a resolution can never hide a new problem.
The payouts page also lists payments that are not paid out yet: card payments taken through a provider that no synced payout has settled after a number of days. Seven days is the default and you can choose anything from 2 to 60, which suits providers with longer settlement times. Refunds given as gift voucher credit never reach a payout and are left out of this check. Export the list, or a single payout, as CSV for your bookkeeper.
Getting bank transfers to match first time
Booking references look like TT-7K3Q9X and never use the characters 0, O, 1, I or L, so they survive being typed into a banking app. Ask travellers to put the reference in the transfer description. The matcher still finds it when banks change it to tt 7k3q9x or TT7K3Q9X, or drop the prefix altogether.
Each statement line is scored: the reference is strong evidence, an amount equal to what's owed or what was due at booking is medium, and a payer name that matches the customer is weak. A line is only confirmed automatically when it has the reference and the exact amount and points to one booking only; you can turn that off in the plugin's settings so every match waits for a person. Bookings that are already paid or cancelled are never suggested, and a payment smaller than the deposit due stays a suggestion for someone to look at.
Statement quirks and how Tourtify handles them
Banks write numbers differently, so the import reads 1.234,56 and 1,234.56, amounts like 1'000.00, negatives in brackets and CR or DR markers, and works out whether dates are day first or month first. Money going out, total rows and blank lines are skipped. Importing the same statement again, or an overlapping one, skips lines already imported, while two identical payments within one file are kept as two.
Not every line belongs to a booking. Ignore bank interest or a transfer between your own accounts with a short note, and restore it later if needed. When new bookings are made or paid after an import, choose Look for matches again to refresh the suggestions. Undoing a match is refused if part of that payment has since been refunded, because the refund is then the record to correct. Bank reconciliation comes with the Pay by bank transfer plugin and is open to people who can record payments.
How it works
Payout & bank reconciliation, step by step
- 1
Connect your provider
Payouts sync automatically.
- 2
Import a statement
Upload the CSV or CAMT.053 file from your bank.
- 3
Review
Confirm suggested matches and check flagged differences.
Integrations
Extend payout & bank reconciliation
Switch these on in one click from your console.
Payments
Pay by bank transfer
Let travellers book now and pay by bank transfer. They get your bank details and their reference by email, the seats are kept for a few days, and the booking confirms when you record the money.
Distribution
Resellers & agents
Give travel agents, hotel concierges and affiliates their own referral link and commission rate. Bookings they send are credited to them automatically, and you see what you owe each one, with statements and payouts.
Accounting
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.
Accounting
QuickBooks Online
Sends every sale, payment, refund and credit memo to QuickBooks Online as it happens, booked to the accounts and tax codes you choose. No more CSV imports.
Which payment providers are covered?
Stripe payouts are synced automatically; other providers are added where their APIs list payouts.
Which banks work?
Any bank that exports a CSV statement, plus banks that provide CAMT.053, CAMT.052 or CAMT.054 files.
Who can see reconciliation?
Bank reconciliation is open to team members who can record payments; payouts need finance access. Undoing a match needs refund permission.
Related features
Works well with
Start selling tours direct
Try Tourtify free for 30 days. Add your tours, pick a theme and take your first booking today.