Commission tracking is the most overlooked profit center in travel agencies. While you focus on selling incredible trips, thousands of dollars slip through cracks in spreadsheets, missed supplier payments, and forgotten reconciliation. This guide will fix that.

Why Commission Tracking Matters

15-20%

Of commissions are lost to poor tracking

$25K

Average annual loss for mid-size agencies

ROI on proper commission tracking software

The 5-Step Commission Tracking Process

Step 1: Record Expected Commission at Booking

When you make a booking, immediately record the expected commission amount, supplier, booking date, travel date, and confirmation number. Don't wait — memory fades and details get lost.

Step 2: Set Commission Rate Rules

Configure your commission rates by supplier in your tracking system. Most cruise lines pay 10-16%, hotels 10%, tour operators 10-20%. Having these pre-loaded prevents calculation errors.

Step 3: Track Payment Status

Mark commissions as "Expected," "Invoiced," "Received," or "Overdue." Set automatic reminders for commissions that should have arrived but haven't.

Step 4: Reconcile Monthly

Every month, compare your expected commissions against actual payments received. Flag discrepancies immediately — suppliers make mistakes too, and it's easier to fix within 30 days.

Step 5: Calculate Splits & Report

For host agencies, calculate IC splits. For teams, attribute commissions correctly. Generate monthly reports for accounting and tax purposes.

Commission Tracking Methods Compared

Method	Accuracy	Time Required	Best For
Spreadsheet	Low	High	Solo advisors, tiny budgets
Generic CRM	Medium	Medium	Agencies already using HubSpot/Salesforce
Travel CRM (travelCRM)	High	Low	All travel agencies
Manual Supplier Portals	Low	Very High	No other option

Common Commission Tracking Mistakes

✗
Not recording at booking time. Waiting until "later" means details get lost. Record immediately.
✗
Ignoring split commissions. Group bookings often have split commissions between multiple agents or host/IC. Track both portions.
✗
Not following up on overdue payments. Suppliers sometimes miss payments. If you don't track, you don't know they're missing.
✗
Manual reconciliation. Comparing spreadsheets to supplier portals is error-prone and time-consuming. Automation is essential.

Recommended Commission Tracking Software

While spreadsheets work for 1-2 bookings per month, any serious agency needs dedicated software. Here's our top recommendation:

travelCRM Commission Module

✓ Auto-capture expected commission at booking
✓ Pre-loaded supplier commission rates
✓ Automated reconciliation against statements
✓ Host/IC split calculations
✓ Overdue payment alerts
✓ Monthly profitability reports

Included in all plans starting at $15/mo. Most agencies recover their subscription cost in the first month from captured commissions alone.

Stop Losing Commissions Today

Start tracking every commission automatically with travelCRM's built-in commission module.

Start Free 14-Day Trial

Travel Agent Commission Tracking: Complete 2026 Guide