Getting the export
Open Back office, then Bookings. Filter to the period you want, usually one month of bookings by booking date.
Choose Export at the top right. Tern writes a CSV with the same columns as the table on screen.
For commission specifically, Commission then Bookings has its own export, and Commission then Unclaimed lists what Tern thinks is outstanding.
Upload the CSV in MarginShield and map the header once. The mapping is remembered.
One row per booking. A supplier that paid in instalments shows as a partial status with more than one received amount.
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 Tern’s own documentation; the rest are inferred from its screens, and the mapping step will show you your actual headers either way.
| MarginShield field | Tern column | Seen in docs |
|---|---|---|
| Booking reference | Confirmation Number | Yes |
| Supplier | Supplier Name | Yes |
| Booking date | Booking date | Yes |
| Currency | Expected Commission Currency Tern carries a separate currency column per amount. Map the expected commission’s currency; check it matches the received currency. | Yes |
| What you expected | Expected Commission Amount | Yes |
| Amount actually received | Commission 1 - Received Amount If a booking has Commission 2 and 3 received columns, add them into one column in your spreadsheet before uploading. MarginShield maps one received column per row. | Yes |
Watch for
- The column names above are those of Tern’s own import template, which is also what its export mirrors. If your export’s headers differ, the mapping screen will show you them and you pick.
- Bookings exported without a commission amount will be refused, not guessed. Export with the commission columns included.
Sources
- Tern: agency commission reconciliation
- Tern: import template columns
- Tern: missing or overdue commission
Other systems
TravelJoy · Trams Back Office and ClientBase · TESS · TravelWorks. Anything else with a CSV export works too; the guide describes the fields in general terms.