Getting the export
Run the supplier commissions receivable report, or the booking report by supplier, for one month.
Export it to Excel, then save as CSV.
Upload in MarginShield. The mapping screen shows your headers; pick the ones below by meaning.
Depends on the report. Choose a booking-level report rather than a supplier summary, so each row is one booking.
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 TravelWorks’s own documentation; the rest are inferred from its screens, and the mapping step will show you your actual headers either way.
| MarginShield field | TravelWorks column | Seen in docs |
|---|---|---|
| Booking reference | The supplier confirmation or booking number | Inferred |
| Supplier | The supplier name | Inferred |
| Booking date | The booking or issue date | Inferred |
| Currency | The currency, often CAD by default Map a fixed value if every row is the same. | Inferred |
| What you expected | Commission due or expected | Inferred |
| Amount actually received | Commission received or paid | Inferred |
Watch for
- French-language headers are common on Quebec installations; the mapping screen does not care what a column is called.
- If you send us the header row of your export, we will write this page properly and credit you.
Sources
Other systems
Tern · TravelJoy · Trams Back Office and ClientBase · TESS. Anything else with a CSV export works too; the guide describes the fields in general terms.