Getting the export
Open Commission, then Paid. The download control at the top right exports the current list to Excel.
For a per-booking view, filter the commission list to the period and export that list, if your TESS version offers it. If it does not, the Bookings list export with total commission is the expected side, and the Paid list is the received side.
Open in a spreadsheet, save as CSV.
Upload in MarginShield and map the header once.
The documented Checks Paid export is one row per agent payout check, not per booking. Use a booking-level list for reconciliation.
Mapping the columns
MarginShield needs a booking reference, a currency, what you expected and what you received. Supplier and booking date are optional and worth mapping. Column names marked as seen come from TESS’s own documentation; the rest are inferred from its screens, and the mapping step will show you your actual headers either way.
| MarginShield field | TESS column | Seen in docs |
|---|---|---|
| Booking reference | Booking Number A field on the booking screen; confirm its header in your export. | Yes |
| Supplier | Operator / Supplier As labelled on the booking; confirm the header. | Yes |
| Booking date | Booking Date | Yes |
| Currency | Not exported; USD is assumed Map a fixed currency if every row is the same. | Inferred |
| What you expected | Total Commission | Yes |
| Amount actually received | Commission Rcvd Verified on the Checks Paid export; on a booking-level export confirm the header. | Yes |
Watch for
- A payout-check export mixes many bookings into one row. If the only export you have is that one, reply to your trial note with the header row and we will suggest a route.
Sources
Other systems
Tern · TravelJoy · Trams Back Office and ClientBase · TravelWorks. Anything else with a CSV export works too; the guide describes the fields in general terms.