Skip to content
Trio Travel guide

Importing extra services from Excel

On this page
  1. Downloading the template and preparing references
  2. The four amount columns
  3. Uploading a two row file
  4. Reviewing the rejection and correcting currency
  5. Retrying and checking both services
  6. Matching the remaining values

Downloading the template and preparing references

This guide explains how to import extra service definitions from Excel, correct a rejected row with an unknown currency code and check the saved values.

Open Settings, then Extra Services. Use the arrow beside Import to download the template and catalogue. The template is for data entry; the catalogue explains the columns and lists currencies and ledger accounts.

1 The original template has eight columns. Keep the first-row headings and enter data from row 2.
The original template has eight columns. Keep the first-row headings and enter data from row 2.

name is the required service name. currency is an existing currency code, such as EGP. Copy it from the catalogue’s Currencies sheet, rather than using the currency name or ID.

cost_ledger is the cost account code and revenue_ledger the revenue account code. Both are optional. If used, copy the correct code from the Ledgers sheet rather than guessing a number. The example leaves both blank.

Save the working copy as xlsx. Upload the template, rather than the catalogue.

The four amount columns

2 Amount columns in the corrected example: cost 100, child_transfer 10, child_cost 50 and adult_transfer 20.
Amount columns in the corrected example: cost 100, child_transfer 10, child_cost 50 and adult_transfer 20.

cost is the adult cost, set to 100. child_transfer is the child transfer amount, set to 10. child_cost is the child cost, set to 50. adult_transfer is the adult transfer amount, set to 20.

Enter numeric Excel cells without a currency symbol or extra text. The amounts use the currency specified in currency. These training values demonstrate the fields.

The catalogue marks the amounts optional, but keep all four amount column headings in the file. The example fills all four so they can be checked after import.

3 The first part of the corrected row contains service B and currency EGP, with both ledger fields blank.
The first part of the corrected row contains service B and currency EGP, with both ledger fields blank.

The example name is DEMO-XLS-EXTRA-20261115-B. For your own data, use the actual service name and review the list to avoid duplication.

Uploading a two row file

4 The training file contains A with EGP and B with nonexistent code DEMO-NOT-FOUND to demonstrate an error and its correction.
The training file contains A with EGP and B with nonexistent code DEMO-NOT-FOUND to demonstrate an error and its correction.

Open Extra Services, click Import and select extra-services-demo-mixed.xlsx.

5 Check the filename in the Import window. Select Yes to start, or No to return without submitting it.
Check the filename in the Import window. Select Yes to start, or No to return without submitting it.

Confirm once, then open Background tasks and wait for the result before uploading again.

Reviewing the rejection and correcting currency

6 Extra services shows one successful row and one rejected row, with Completed. Click Download details to read the rejection reason.
Extra services shows one successful row and one rejected row, with Completed. Click Download details to read the rejection reason.

The error column in the rejection report says Currency with code 'DEMO-NOT-FOUND' not found.

After the first attempt, A appeared as number 3, B was absent and the total increased from 2 to 3. Check the row’s result in the list before retrying.

In a copy of the original template, include only row B and replace its currency with EGP. Retain amounts 100, 10, 50 and 20, with both ledgers blank. Save as extra-services-demo-corrected.xlsx.

Leave the error column out of the upload file and exclude the previously successful A row.

Retrying and checking both services

Upload the corrected file through Import, check its filename and confirm Yes once.

7 The new attempt shows 1 succeeded and Completed. The first attempt remains separately listed with its success and rejection counts.
The new attempt shows 1 succeeded and Completed. The first attempt remains separately listed with its success and rejection counts.
8 The total is now 4: A is number 3 and B number 4, with both original services retained. Adult cost is 100 and the adult transfer field is 20...
The total is now 4: A is number 3 and B number 4, with both original services retained. Adult cost is 100 and the adult transfer field is 20 for each new row.

Matching the remaining values

9 After horizontal scrolling, the two new rows show child cost 50 and child transfer field 10.
After horizontal scrolling, the two new rows show child cost 50 and child transfer field 10.
10 Currency is EGP and the ledger fields have no values, matching the prepared file.
Currency is EGP and the ledger fields have no values, matching the prepared file.

Check the name, currency, all four amounts and both ledgers before using the definition in services. Keep the corrected file and operation result for reference.

Sign in to record the lessons you have read. Sign in