Resources—Bookings & Commissions

Commission Tracking Spreadsheet

Travel advisor commissions are easy to lose track of. A booking gets confirmed in January, the client travels in June, the supplier pays in August, and by the time you reconcile your books in October you can't remember which trip the deposit was tied to.

This free spreadsheet gives you one place to log every booking, every supplier, every deposit and final payment, and every commission owed and received. Built for travel advisors who aren't ready for full back-office software yet.

Download

Get this resource

We'll email you a copy and occasional Voyagr updates. Unsubscribe anytime.

Sheet 1 · Settings

The setup tab. Set your default commission split with your host agency, your business name, and the year the workbook covers. Every formula on the Bookings and Clients tabs pulls from here, so changing your host split once updates the whole workbook automatically.

Sheet 2 · Bookings

The main worktab. One row per booking with columns for client, trip dates, supplier, confirmation number, total trip value, commissionable amount, expected commission (gross and net of your host split), commission received, payout date, and a status field that moves from quoted → booked → traveled → paid. This single tab answers the two questions you ask most often: what's in my pipeline, and what's owed to me.

Sheet 3 · Clients

A one-row-per-client tab that totals lifetime bookings, lifetime commissions, and last trip date by pulling from the Bookings tab automatically. Useful at the end of the year for identifying your top 20% of clients (who deserve a thank-you) and your dormant clients (who deserve a re-engagement email).

How to use it

Duplicate the template once per calendar year. Log every booking the day you book it; don't batch this work weekly or you'll forget details. When a commission lands, fill in the actual amount and payout date the same day. Block 15 minutes on your calendar at month-end to reconcile expected vs received and chase anything that's late.

When the spreadsheet stops scaling

A spreadsheet works well up to about 50–75 active bookings. Past that, the manual entry burden compounds: you're duplicating data across tabs, formulas break when rows are inserted in the wrong place, and reconciling a single late commission takes longer than booking the trip did. That's the point most advisors graduate to dedicated software. Voyagr is built for that step.

When a spreadsheet stops being enough

Commission data lives in five places: the spreadsheet, supplier emails, your CRM, your bank statements, and your head.
Late commissions are easy to miss when nothing automatically reconciles expected vs received.
Booking details (client, supplier, dates) get retyped into three systems for every trip — that's where errors creep in.
At 50+ active bookings, the spreadsheet starts breaking more than it helps.

One workspace for bookings, commissions, clients, and itineraries.

Voyagr connects every booking to its commission automatically, flags shortfalls and late payouts, and keeps your client and supplier records in one place. The spreadsheet is a great starting point. Voyagr is what comes next.

Try Voyagr Free Book a Demo

Frequently asked questions

Who is this spreadsheet for?

Travel advisors tracking their own bookings and commissions. It's especially useful in the first one to three years of selling, when you have enough bookings to lose track but not enough to justify dedicated software.

What's the difference between the Google Sheet and the Excel version?

Functionally identical. The Google Sheet is best if you work in the browser, want to share with a team member, or want changes to sync across devices automatically. The Excel file is best if you prefer working offline or already keep your business records in Excel. You can switch between them at any time.

Will the formulas break if I add or delete rows?

Inserting rows inside the existing data range is safe — the formulas use structured references and will extend automatically. Deleting rows that are referenced by the summary tabs will leave #REF errors. If that happens, undo (Ctrl/Cmd+Z) immediately. Better practice: mark rows as cancelled instead of deleting them.

Does it handle splits with a host agency?

Yes. Set your default host split once on the Settings tab and every row on the Bookings tab will calculate net commission (what you keep after the split) automatically. Override the split on individual rows for one-off arrangements.

How often should I update it?

Log new bookings the day you confirm them — don't batch. Update commission-received entries the day the payout hits your account. Block 15 minutes at month-end to reconcile expected vs received and chase anything outstanding. The whole system collapses if you let entries pile up.

What does Voyagr do that this spreadsheet does not?

The spreadsheet records what you remember to type. Voyagr connects bookings to commissions automatically, alerts you when a commission is late or short, stores client profiles (so you stop re-entering passport details), and keeps everything in one workspace alongside your itineraries and client communication.

PDFGoogle SheetNotion