Getting the export
In Trams Back Office, open Reports, then Report Generator, then Build Report. Add the Comm Track booking fields listed below.
Print the report with Mail Merge, which writes a tab-delimited text file, or send any standard report To File as Excel.
Open the file in a spreadsheet, save as CSV, and check the amounts are numbers: Trams exports Excel data as text.
Upload in MarginShield and map the header once.
One row per invoice booking. A received commission is a payment that closes the Comm Track booking, so open items also appear on Reports, Core, Vendor Balances.
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 Trams Back Office and ClientBase’s own documentation; the rest are inferred from its screens, and the mapping step will show you your actual headers either way.
| MarginShield field | Trams Back Office and ClientBase column | Seen in docs |
|---|---|---|
| Booking reference | Confirmation Number | Yes |
| Supplier | Vendor | Yes |
| Booking date | Issue Date Or Depart Date, if you prefer to age by travel. | Yes |
| Currency | Local or foreign currency field Trams captures both; the exact header depends on the report. If every row is one currency, map a fixed value. | Inferred |
| What you expected | Commission Amount Or map Total Fare and Commission/Rate and let MarginShield compute it from the rate you confirm. | Yes |
| Amount actually received | Amount paid against the booking Comes from the payment that closed the booking; on Vendor Balances an open booking has none. Confirm the header on your report. | Inferred |
Watch for
- Excel output is text. Amounts with $ signs, commas and parentheses for negatives are all read correctly by MarginShield, but a cell that says “See note” is not an amount.
- ClientBase alone does not hold commission payments; if you only have ClientBase, the figures are in TBO.
Sources
Other systems
Tern · TravelJoy · TESS · TravelWorks. Anything else with a CSV export works too; the guide describes the fields in general terms.