Tender benchmark template
Xeneta's standard template for the Tender benchmark tool allows you to provide us with the data necessary to generate a report in a clear and consistent format. Using the template is the best way to make sure that you get your report quickly and without any errors.
How to use the template
- Download our standard Excel template. The template already has the necessary formatting, headers, and drop-downs for allowed values and data validations.
- Fill out the template using the information in the table below for reference. You only need to add a single port pair in the Origin and Destination fields for the report to work. If you leave any optional fields blank, the system will use the default values (see the table below for more information).
You don't have to use our template. You can import your bid sheet directly, but in that case you'll need to match the relevant data manually during the import process.
Template description
Refer to the table below for a description of each field in the template, including permitted values, format, required fields, and any specific rules to look out for when filling it out.
There is no limit to the number of requested port pairs. If you need to use different criteria for the same port pair (for example, a different container type), simply add that port pair again in a separate row.
| Column | Required | Allowed values and format | Rules | Default values |
|---|---|---|---|---|
| Origin | Yes | Port code (CNSGH) | UN/LOCODE One port per row | |
| Destination | Yes | Port code (DEHAM) | UN/LOCODE One port per row | |
| Bid rate | No | $X,XXX.X ($1,000.00) | Two decimal values max | Uses Your rates if left blank |
| Included THC | No | DEFAULT NONE OTHC DTHC OTHC+DTHC | One value per row | DEFAULT |
| Equipment | No | 20DC 40DC 20RE 20TK 40HC 40RH | One value per row | 40DC |
| Volume | No | Volume in TEUs | One value per row No decimals | |
| Lane ID | No | Lane ID as it appears in your bid sheet | One value per row 10 characters max | |
| Supplier | No | Supplier name as it appears in your bid sheet | One value per row |
Note that most port codes found in Xeneta match the standard UN/LOCODE convention. Refer to our Geo-Hierarchy for a full list of ports found used in platform.
For North American origin ports: Origin Terminal Handling Charges (OTHC) are included in base freight rates per US maritime regulations and cannot be excluded.
Including "Destination" or "None" for the THC field in your template will have no effect on North American origins, and OTHC will always be included in the benchmark rates regardless.