How One Agency Found $1M in Untracked Commissions

Last year, I conducted a workflow audit for a luxury travel agency. What I found shocked both of us: over $1 million in commissions they didn’t know they were owed.

This wasn’t a shady supplier situation. It wasn’t fraud. It was simply a tracking problem—referrals that came in, bookings that happened, and commissions that were never followed up on because nobody knew they existed.

Here’s exactly what went wrong and how to prevent it in your business.

The Setup

This agency had a good problem: they were busy. Really busy. Multiple advisors, high-volume bookings, strong supplier relationships. From the outside, everything looked healthy.

Their commission tracking system? A spreadsheet. Updated manually. When someone remembered.

Sound familiar?

What the Audit Revealed

I started by pulling data from three sources:

1. Referral records from their consortium (Virtuoso)
2. Booking confirmations in their email
3. Commission payments received in their accounting system

The theory was simple: every referral should have a booking, and every booking should have a commission payment. Match them up.

The reality was brutal.

Finding #1: Referrals Without Bookings

Over 200 Virtuoso referrals in the past two years had no corresponding booking in their system. Some were leads that didn’t convert—fine. But many were bookings that happened but were never logged.

How? The referral came in, the advisor worked directly with the client and supplier, the trip happened… and nobody connected it back to the original referral source.

Money left on the table: Estimated $400K in commissions never claimed because they didn’t know to claim them.

Finding #2: Bookings Without Commission Follow-Up

Another 150+ bookings showed in their records but had no commission payment logged. When we dug in:

• Some suppliers paid late (normal)
• Some payments went to the wrong entity and were never reconciled
• Some suppliers simply never paid, and nobody followed up
• Some commissions were pending from trips 18+ months ago

Money left on the table: Approximately $350K in commissions earned but never collected.

Finding #3: Payment Discrepancies

For bookings that did have commission payments, about 15% showed discrepancies between expected and received amounts. Sometimes the supplier paid less than the agreed rate. Sometimes additional services weren’t included. Sometimes it was calculation errors.

Nobody was checking.

Money left on the table: Roughly $250K in underpayments accepted without question.

Total Impact: $1M+

When we added it up: over $1 million in commission revenue that either wasn’t claimed, wasn’t collected, or wasn’t correct.

For context, this represented nearly 18 months of the agency’s profit margin. They’d been operating profitably—but they could have been operating much more profitably.

How This Happens

This agency wasn’t careless. They weren’t disorganized. They were busy. And when you’re busy, the unglamorous work of commission reconciliation falls to the bottom of the list.

The root causes:

No single source of truth. Referrals in one system, bookings in another, payments in a third. Nobody connecting them.

Manual tracking. If it requires a human to remember and act, it will eventually fail.

No reconciliation process. They deposited commission checks but never verified amounts or followed up on missing payments.

Volume overwhelm. At a certain booking volume, manual tracking becomes physically impossible.

The Fix: A Commission Tracking System That Works

Here’s the system I built for them (and variations I’ve implemented for other agencies):

Step 1: Single Source of Truth

Every booking lives in one system with these required fields:

• Booking date
• Travel dates
• Client name (linked to client record)
• Supplier
• Booking value
• Expected commission (calculated from supplier rate)
• Commission due date (based on supplier terms)
• Commission received (actual payment)
• Variance (automatic calculation)
• Referral source (if applicable)

ClickUp, Airtable, or a properly configured spreadsheet can handle this.

Step 2: Automated Entry

Bookings enter the system automatically or with minimal manual input:

• Form submission when booking confirmed
• Email parser that extracts booking details
• Integration with booking platform if available

The goal: eliminate the “I’ll log it later” problem.

Step 3: Deadline Automation

The system automatically:

• Calculates expected commission based on supplier and booking value
• Sets payment due date based on supplier terms
• Sends alerts when due date approaches
• Escalates when payment is overdue

Nobody has to remember. The system remembers.

Step 4: Reconciliation Workflow

Monthly process (can be weekly for high volume):

1. Pull commission payments received
2. Match to expected commissions
3. Flag discrepancies for follow-up
4. Follow up on unpaid commissions
5. Update records

This takes 2-4 hours monthly when systematized. It was taking them 0 hours because it wasn’t happening.

Step 5: Reporting

Dashboard showing:

• Total commissions expected (pipeline)
• Commissions received YTD
• Overdue commissions
• Variance trends by supplier

Visibility creates accountability.

Results After Implementation

Six months after implementing the new system:

• Recovery: $180K collected from previously untracked/uncollected commissions
• Ongoing capture: 99%+ of new bookings properly tracked from day one
• Supplier negotiations: Data revealed which suppliers consistently underpaid, leading to contract renegotiations
• Time saved: Commission reconciliation went from “never” to “4 hours monthly”

The system paid for itself in the first month.

Is This Happening to You?

Ask yourself:

• Do you know exactly how much commission you’re owed right now?
• When was the last time you followed up on an unpaid commission?
• Do you verify that commission payments match expected amounts?
• Can you see, at a glance, your commission pipeline by supplier?

If you answered “no” or “I don’t know” to any of these, you’re likely leaving money on the table.

The Minimum Viable System

You don’t need expensive software. You need:

1. One place where every booking is logged
2. Required fields for commission tracking (supplier, expected amount, due date)
3. A recurring task to reconcile payments monthly
4. Alerts for overdue commissions

Start there. Improve over time.

Quick Audit: Check Your Exposure

Right now, in the next 30 minutes:

1. Pull your last 3 months of commission payments received
2. List your last 3 months of bookings
3. Match them up

If there are bookings without corresponding commissions—and you don’t know why—you have a problem worth solving.

Need Help Finding Your Leaks?

A workflow audit isn’t just about efficiency—it’s about revenue. If your commission tracking is manual, inconsistent, or nonexistent, you’re almost certainly losing money.

Workflow Audit ($500): I’ll analyze your current tracking and identify exactly where revenue is slipping through.

Done-For-You Commission System ($5,000+): Complete implementation of automated tracking, reconciliation workflows, and reporting.

Book a discovery call to discuss your situation.