Getting the export
Open Reports, then Commissions and Sales.
Use the Details tab. The export control sits on the right-hand side of that tab. Choose the period and, if you invoice in more than one currency, one currency at a time.
Save the spreadsheet as CSV if it is not already.
Upload in MarginShield and map the header once.
The Details tab is one row per invoice item, which is usually one row per booking. The Payments tab is per payment and is not the one to upload.
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 TravelJoy’s own documentation; the rest are inferred from its screens, and the mapping step will show you your actual headers either way.
| MarginShield field | TravelJoy column | Seen in docs |
|---|---|---|
| Booking reference | Supplier confirmation number A searchable field in TravelJoy; confirm its header in your export. | Inferred |
| Supplier | Supplier | Yes |
| Booking date | Booking Date | Yes |
| Currency | Not a column; set by the currency filter Export one currency at a time, and add a currency column in your spreadsheet, or map a fixed value if every row is the same. | Yes |
| What you expected | Expected agency commission | Yes |
| Amount actually received | Collected commission TravelJoy labels the received side as collected; confirm the header in your export. | Inferred |
Watch for
- Dates are US-ordered. MarginShield reads 04/07/2026 as the fourth of July; map an unambiguous date column or convert first.
- Agent commission is the advisor’s share, not what the supplier paid. Map the agency figure.
Sources
Other systems
Tern · Trams Back Office and ClientBase · TESS · TravelWorks. Anything else with a CSV export works too; the guide describes the fields in general terms.