Travel Advisor Booking and Commission Tracker Spreadsheet | Trip Pipeline, Commission Chase Board and Supplier Pay Speed - Google Sheets

The trip sailed in June. The commission was due in August. It's October.

Suppliers pay travel advisors 30–90 days after travel — and they pay late, they pay short, and sometimes they don't pay at all. If your follow-up system is a notebook, an inbox search, or memory, some of your income is quietly expiring. This tracker runs your whole book of business in one Google Sheets file: a trip pipeline, a booking log, client payments, and a commission chase board that ages every dollar you're owed until it lands.

WHAT THE SAMPLE DATA SHOWS

The tracker comes loaded with a fictional sample business, Sunward Travel Studio (11 bookings, 13 trips in the pipeline, 2026), and the samples make the point: one commission is badly overdue — $624.00 from Regal Ocean Cruises on a cruise that ended August 2, 76 days since travel and a month past its due date, flagged OVERDUE on the chase board. Another supplier paid SHORT: $382.50 landed against $450.00 expected, because the rate came in at 8.5% instead of the agreed 10% — a $67.50 gap you'd never spot in a bank feed. And the quiet top earner, Palms & Pines Resorts, has paid $2,038.80 across 3 bookings, every cent in full, in about 25 days on average. The board flags all three stories automatically.

WHAT'S INSIDE — 7 TABS

1. Start Here + Dashboard — the full guide, the As-Of date every flag grades against, the money at a glance (commissions expected, received, outstanding, overdue), and your pipeline by stage.

2. Client & Trip Pipeline — every trip you're working, one row each: Inquiry → Quoted → Booked → Deposited → Final Payment → Traveled → Commission Received.

3. Booking Log — confirmed bookings: supplier, booking reference, travel dates, trip total, what the client has paid in, and the balance still due.

4. Commission Tracker — THE CHASE BOARD: per booking, the commission rate, expected amount, the date it should arrive, what actually arrived, the variance, and days outstanding — with OVERDUE and SHORT flags.

5. Client Payment Schedule — every deposit and final payment by due date, graded PAID / OVERDUE / DUE SOON / SCHEDULED, so a client's unpaid final flags itself before the trip departs.

6. Supplier Directory — your standard commission rate and pay window per supplier, plus a pay-speed history built from your own bookings: bookings, volume, expected, received, average days to pay, and flags (TOP EARNER, SLOW PAYER).

7. Monthly Summary — booked vs. traveled vs. commissioned revenue, kept in three separate columns — because in this business those are three different numbers, in three different months.

HOW THE MATH WORKS

Expected commission = trip total × the supplier's commission %. The due date = travel end + the supplier's standard pay days, pulled from your Supplier Directory. Type the received amount and date when a payment lands and the sheet grades it: RECEIVED IN FULL, or SHORT with the exact variance. Unpaid commissions age on the board — AWAITING inside the normal pay window, DUE once the due date passes, OVERDUE 14 days after that — with a running Days Since Travel count.

WHO IT'S FOR

Independent travel advisors and small agencies who book through commission-paying suppliers and are tired of reconstructing what they're owed from confirmation emails. It is an organization and calculation tool: it reports the numbers you enter, and it is not tax, financial, or legal advice. Commission rates and pay windows come from your own supplier agreements — the samples use plausible ones (8–12%, 21–60 days), and you edit them to match yours.

You need a free Google account to use the Google Sheets file. Sample data is fictional and clearly replaceable — swap in your suppliers, your rates, and your trips as you go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

This is a digital product — no physical item will be shipped. Your file is available instantly after checkout. All sales are final (no returns or cancellations on digital downloads), but if anything is ever wrong with your file, message us anytime and we'll fix it — no time limit.