Settlement and Profit Tracking: Know Exactly Where Your Money Goes

Ask a Sri Lankan DMC owner what their profit margin is, and you will get one of two answers. The confident ones will say "around 20–25%." The honest ones will say "I am not really sure." Both answers reveal the same problem: most operators know what margin they quote, but very few track what margin they actually earn.

The gap between quoted margin and actual margin is where tour operator profits quietly disappear. A hotel that charged a higher rate than expected. A transport cost that exceeded the estimate. An activity that was added mid-tour at the guest's request but never billed to the client. A currency fluctuation that eroded the margin on a booking quoted three months ago. Individually, these are small. Collectively, across a full season, they can be the difference between a profitable year and a breakeven one.

The Settlement Gap: Planned vs. Actual

Settlement is the process of reconciling what you planned to spend on a booking with what you actually spent. In accounting terms, it is variance analysis at the booking level. In practical terms, it is the moment of truth that tells you whether a tour was profitable.

Most DMCs skip this step entirely. The tour ends, the guest leaves a nice review, and the team moves on to the next booking. The supplier invoices trickle in over the following weeks. Someone pays them. The money flows out. But no one sits down and asks: "Did we make what we expected to make on this booking?"

The operators who do ask this question — and who have the data to answer it — consistently outperform those who do not. They catch pricing errors before they become systemic. They identify suppliers who overcharge. They discover which itinerary types are genuinely profitable and which only look profitable on paper.

What Per-Booking Settlement Looks Like

A proper settlement process breaks down every cost category for a booking and compares planned versus actual:

In this example, the operator quoted a 22% margin but actually earned 17.4%. The biggest culprit was transport (an extra 55 km due to a route change the guest requested) and meals (the guest chose a more expensive restaurant twice). The $185 variance on a single booking might seem manageable, but if this pattern repeats across 40 peak-season bookings, it represents over $7,000 in lost profit.

Where the Variance Typically Hides

Based on patterns observed across Sri Lankan DMC operations, cost variances concentrate in predictable areas:

Transport: The Chronic Overrun

Transport is the category most likely to exceed estimates. Route changes, additional stops, airport timing changes, and underestimated distances all push actual costs above planned. The variance is typically 5–15%, and because transport represents 20–30% of total cost, even a small percentage overrun has material impact.

Accommodation: Rate Discrepancies

Accommodation variances usually stem from rate differences between what was quoted and what the hotel actually charges. This happens when rates were not locked in, when the booking was made at a seasonal rate that changed, or when room upgrades occurred. Peak-season surcharges and mandatory gala dinner charges (common during Christmas and New Year) are frequent surprises.

Meals and Extras: The Untracked Add-Ons

Guests request things during the tour that were not in the original itinerary. A lunch at a nicer restaurant. An additional excursion. A spa treatment that the guide arranges. If these are not tracked and billed (or absorbed consciously), they silently reduce your margin. Some operators estimate that untracked add-ons cost them 2–4% of revenue annually.

Color-Coded Variance: See Problems at a Glance

Raw numbers are useful, but color-coding makes variance analysis instant. A well-designed settlement screen uses color to highlight where attention is needed:

When you open a completed booking and see a wall of green with one red line item, your attention goes exactly where it should. You do not need to study every number — the color tells you where the problem is.

Supplier Payment Tracking: The Other Half of Settlement

Settlement is not just about cost variance. It is also about tracking payments to and from all parties. On the supplier side, you need to know the payment status for every cost line:

• Unpaid: Invoice received but no payment made yet.
• Partially paid: A deposit or advance has been paid, but the balance is outstanding.
• Paid: Full payment completed. Invoice closed.
• Overpaid: You paid more than the invoice amount (happens more often than you might think, especially with currency conversions or duplicate payments).

Tracking payment status per supplier per booking prevents several common problems: paying the same invoice twice, forgetting to pay a supplier (damaging the relationship), and losing track of how much you owe in aggregate at any given time. The last point is especially important for cash flow management — you need to know your total supplier obligations to ensure you have sufficient funds.

Client Payment Tracking: Ensuring You Collect What You Are Owed

The other side of settlement is ensuring you collect full payment from clients and agents. This sounds obvious, but with complex payment schedules (deposit upon booking, balance 30 days before arrival, extras settled post-tour), tracking becomes non-trivial.

A proper settlement system shows the total client charge, all payments received with dates and amounts, and the outstanding balance. For agent bookings, it factors in the commission to show the net receivable. When everything is in one place, chasing outstanding payments becomes a simple filter rather than a manual audit.

The Profit and Loss Summary: Your Booking Report Card

Every completed booking should have a one-screen profit and loss summary. This is the report card for the booking — a single view that shows total revenue, total actual costs by category, gross profit, profit percentage, and any outstanding payments in either direction.

When you can generate this summary for any booking with one click, several things become possible that were not possible before:

• End-of-month reviews: Pull up all completed bookings and review their P&L summaries. Identify the most and least profitable bookings.
• Pricing adjustments: If a particular itinerary type consistently underperforms on margin, you know to adjust pricing before quoting it again.
• Agent profitability: Combine booking P&Ls by agent to see which agent relationships are most profitable after accounting for commissions and service complexity.
• Supplier negotiations: When you see that a hotel consistently charges more than contracted rates, you have data to bring to the negotiation table.
• Seasonal analysis: Compare profit margins across months to understand how seasonality affects your true (not quoted) margins.

The detail that determines whether any of this actually happens is who remembers to start it. Settlement is the step every DMC intends to do and few complete, because by the time the supplier invoices arrive the team has moved on to the next booking. So in Travify the settlement is created automatically the moment a booking is marked Completed, and it carries its own status — Open, In Progress, or Settled — until someone closes it out.

That turns reconciliation from something you have to decide to do into something visibly outstanding. A booking sitting at Open three weeks after the guests flew home is a question your team can see, rather than margin quietly disappearing into an unopened inbox. You can also have a notification sent when a settlement is finalised or comes in over budget, so the number reaches whoever cares about margin without them having to go looking for it.

From Tracking to Strategy: Using Settlement Data

Settlement data is not just about historical accuracy. It is a strategic asset. Here is how forward-thinking DMCs use it:

1. Buffer calibration: If your transport costs consistently run 10% over estimate, you know to add a 10% buffer to all future transport costings. Settlement data tells you exactly how much buffer you need.
2. Supplier accountability: When you can show a supplier that their invoiced amounts consistently exceed contracted rates, you have leverage to enforce rate agreements.
3. Accurate quoting: Over time, your planned costs converge with actual costs because you are learning from every booking. Your quotes become more accurate, your margins more predictable.
4. Profitability-based pricing: Instead of applying a flat markup across all itinerary types, you can apply higher markups to itineraries that historically have higher variance and lower markups to stable, predictable ones.
5. Cash flow forecasting: When you know your average payment cycle for both clients and suppliers, you can forecast cash flow with confidence.

The Weekly Settlement Ritual

Settlement should not be a year-end activity. The most operationally mature DMCs practice weekly settlement. Every Friday (or whatever day works for your team), review:

1. All tours completed this week: Enter actual costs as invoices arrive. Flag any significant variances.
2. Outstanding supplier payments: Who needs to be paid? Any overdue invoices?
3. Outstanding client payments: Which clients or agents have balances due? Any aging receivables?
4. Variance trends: Are any cost categories consistently running over or under? What is driving the variance?

This 30–60 minute weekly ritual prevents the year-end surprise of discovering that your actual margins were 5 points lower than your quoted margins. It also builds the discipline of accurate cost tracking, which improves quoting accuracy over time.

Common Settlement Pitfalls to Avoid

• Ignoring small variances: A $20 overrun feels insignificant, but across 200 bookings it is $4,000. Track everything.
• Not separating controllable and uncontrollable variances: A currency fluctuation is uncontrollable. A forgotten buffer distance is controllable. Both reduce margin, but only one can be fixed by improving your process.
• Settling only problem bookings: If you only review bookings that had visible issues, you miss the ones that quietly leaked margin. Settle every booking.
• Delayed settlement: The longer you wait to reconcile, the harder it becomes to gather accurate data and the less useful the insights are for current operations.
• Not feeding learnings back into costing: Settlement data is only valuable if it improves future quotes. Build a feedback loop between settlement and costing.

Frequently Asked Questions