What Is Tour Settlement?

Every month, the same ritual plays out in tour companies around the world. Someone (usually the owner, sometimes a bookkeeper) sits down with a laptop, a stack of receipts, and three browser tabs open to different OTA dashboards. They spend the next one to two weeks trying to figure out one thing: how much money did we actually make?

That process is called tour settlement. After 14 years of running tours across 7 cities and serving over 500,000 guests, I can tell you it is the most important financial process in a tour operation, and the one that almost nobody does properly.

What Is Tour Settlement?

Tour settlement is the process of reconciling all revenue and all costs for a specific tour, a specific day, or a specific period. It answers a simple question: after everything is accounted for (every OTA payout, every guide payment, every vehicle cost, every refund, every tip, every expense), what is left?

Think of it as "closing the books" for your tours. Just like a restaurant settles its register at the end of each shift, a tour company needs to settle each tour, each day, and each month. The difference is that a restaurant has one cash register. A tour company has revenue coming from 5 different OTAs, direct bookings through 2 different websites, walk-ins paid in cash, and costs spread across guides, vehicles, suppliers, and a dozen small expense categories.

Settlement is not just about knowing your revenue. Revenue is the easy part; your booking engine tells you that. Settlement is about matching revenue against costs at the most granular level possible: per tour, per departure, per day.

The Manual Process: Two Weeks of Spreadsheet Hell

Here is what manual settlement looks like in a typical mid-size tour operation running 8-10 tours per day across 2-3 cities:

1. Step 1: Collect OTA payouts. Log into GetYourGuide, Viator, Civitatis, Tiqets, and any other OTAs you work with. Download payout reports. Try to match each payout to specific bookings. Discover that GetYourGuide pays weekly in arrears, Viator pays monthly, and Civitatis has a different schedule entirely. Spend half a day just figuring out which payouts belong to which month.
2. Step 2: Reconcile direct bookings. Pull Stripe or PayPal reports for direct bookings. Match payment IDs to booking references. Account for partial refunds, chargebacks, and currency conversion fees. Discover three bookings that were paid but never showed up in your booking system.
3. Step 3: Calculate guide costs. Go through each day's schedule and match guides to tours. Check hourly rates, overtime, bonuses, and tip distributions. Some guides are salaried, some are freelance, some are on different rate cards for different tour types. Cross-reference with the guide's own timesheet submissions.
4. Step 4: Add vehicle costs. Match vehicle usage to specific tours. Some tours share a vehicle, some have dedicated transport. Add fuel receipts, parking fees, tolls, and maintenance costs allocated to the period.
5. Step 5: Process expenses and receipts. Collect all receipts from guides and staff: entrance fees, supply purchases, emergency expenses, petty cash usage. Try to match each receipt to a specific tour. Give up on matching some of them and put them in a general bucket.
6. Step 6: Account for refunds and adjustments. Pull all refunds issued during the period. Determine which were full refunds vs partial, which were weather-related vs cancellations, and which affect OTA commission calculations.
7. Step 7: Build the spreadsheet. Pour everything into a massive Excel file. Create formulas. Discover that the numbers do not balance. Spend two more days finding the discrepancies.

For a mid-size operation, this process takes 10-15 business days. Every. Single. Month. That is two weeks where someone, often the owner themselves, is doing data entry instead of growing the business. My accountant used to hate me because I would dump all of this on her desk at the last possible minute.

The Automated Process: Close Your Month in One Day

Now imagine the alternative. A settlement system that connects to all your revenue sources and cost centers. It pulls OTA payouts automatically, matches them to bookings, assigns guide costs based on the actual schedule, tracks vehicle usage per tour, and categorizes every expense.

At the end of the month, you open your settlement dashboard. Every tour is already reconciled. Every cost is assigned. Every discrepancy is flagged for your review — not buried in a spreadsheet for you to discover. You review the flagged items, approve or adjust, and close the month. Total time: one day. Sometimes less.

The difference is not just time saved. It is accuracy. Manual settlement is error-prone by nature. Miss one OTA payout, mistype one guide rate, forget one refund, and your entire month's margin calculation is wrong. An automated system does not forget, does not mistype, and does not miss transactions. It flags them.

Why Your Booking Engine Cannot Do Settlement

This is the question I get most often: "My booking engine tracks revenue. Why can't it do settlement?" The answer is fundamental to understanding what settlement actually requires.

A booking engine sees one side of the equation: revenue. It knows how many tickets you sold, at what price, through which channel. Some booking engines even track OTA commission rates so they can show you net revenue.

But a booking engine has no visibility into your costs. It does not know what you paid your guide. It does not know what the vehicle cost. It does not track your insurance, your entrance fees, your supplies, or your overhead. It cannot, because those costs live outside the booking system: in payroll, in accounting, in receipt folders, in WhatsApp messages from guides.

Settlement requires matching both sides — revenue AND costs — at the tour level. No booking engine does this. Not Bokun, not FareHarbor, not Rezdy, not Peek, not Regiondo. They were not designed to. They are booking engines, not operations platforms.

For a deeper look at what booking engines can and cannot do, see our comparisons of PaxFlow alternatives and Bokun vs Automate.

What a Good Settlement Includes

A complete tour settlement should account for every financial line item connected to a tour:

Real Example: Tuesday's Food Tour Settlement

Let us make this concrete. Here is what an actual settlement looks like for a single food tour on a Tuesday in Krakow. The tour runs at 11:00 AM with 24 guests booked across 3 OTAs, staffed by 2 guides, using 1 minivan.

This is one tour, one day. Now multiply this by 8-10 tours per day, 30 days per month, across 2-3 cities. That is 240-900 individual settlements per month. Doing this manually is not just tedious. It is practically impossible to do accurately.

Moving From Spreadsheets to Systems

The shift from manual to automated settlement is not just about efficiency. It changes what questions you can ask about your business. With manual settlement, you are lucky to know your monthly margin. With automated settlement, you can answer questions like:

• Which tour has the highest margin per guest?
• Which OTA channel delivers the best net revenue after commissions?
• Which guide generates the highest-margin tours (through upsells, lower costs, or fewer issues)?
• What is the minimum group size for each tour to break even?
• How do rainy days affect your food tour margins vs your walking tour margins?
• Which day of the week is most profitable for each tour type?

These are not academic questions. They are the decisions that determine whether your business grows at 5% per year or 25% per year. But you can only answer them if your settlement data is clean, complete, and granular. In practice, that means it needs to be automated.

This is exactly why we built the Finance & Analytics module in Automate. It connects to your booking sources, tracks every cost, and produces settlement reports automatically, per tour, per day, per period. What used to take my team two weeks now takes one click.

Frequently Asked Questions