Worksheet
Commission tracker worksheet
Every booking line gets its own row. Columns are booking reference, client, supplier, confirmation number, travel date, gross value, expected commission, status, date claimed, amount received, difference, reason for difference and next chase date. A summary block at the top totals expected, earned, received and overdue commission by supplier, so the weekly review starts from one view.
Name: ______________________ Business: ______________________ Date: ______________
Scroll the table sideways to see every column.
| Item | Who owns it | Where it is kept today | What is missing |
|---|---|---|---|
Cross out or rewrite any heading that does not fit your business. From the guide “How a travel agency tracks commission from booking to receipt”, www.gullysystem.com/blog/how-a-travel-agency-tracks-commission-from-booking-to-receipt