Skip to content
Trio Travel guide

Importing suppliers from Excel

On this page
  1. Downloading the template and catalogue
  2. Name contact and location
  3. Tax details and commission
  4. Ledger and discount account references
  5. Optional bank details
  6. Selecting the group and uploading
  7. Reading the error and correcting B
  8. Retrying and checking the supplier list
  9. Checking the linked account codes

Downloading the template and catalogue

This guide explains how to import two suppliers from Excel, review their linked accounts and correct a row rejected because its ledger code does not exist.

Open Suppliers and use the arrow beside Import to download the template and catalogue. Enter data in the template; use the catalogue to understand columns and look up branches, countries, cities and ledgers.

1 The first part of the original template. The required name heading is red.
The first part of the original template. The required name heading is red.
2 The remaining headings bring the total to 23 columns. Retain the headings and their comments, and enter data from row 2.
The remaining headings bring the total to 23 columns. Retain the headings and their comments, and enter data from row 2.

Save as xlsx. Retain optional columns even when leaving their values blank. Upload the template rather than the catalogue.

Name contact and location

3 Prepared Excel training example: two unique supplier names, with contact and location fields blank.
Prepared Excel training example: two unique supplier names, with contact and location fields blank.

name is the required supplier display name. Use a clear name and check the list for duplicates. This example uses DEMO-XLS-SUP-20261115-A and DEMO-XLS-SUP-20261115-B.

phone is the optional telephone number and email the optional email address. Store telephone numbers as text to retain leading zeros.

branch is the branch Serial from the Branches sheet, rather than its name or ID. In this catalogue Main Branch has Serial 382. The example leaves branch blank.

country is an existing country name from Countries, city an existing city in that country, and state free text for the state or region. These fields are optional; copy the correct references when using them.

Tax details and commission

tax_number is the supplier tax number and taxpayer_name the taxpayer legal name. Both are optional; use the supplier’s approved details when needed.

mc is the optional supplier MC commission percentage. The catalogue describes its use in SAMO reservation import. This example leaves it blank.

account_name_en and account_name_ar represent the bank account owner’s English and Arabic names. The catalogue states that these values are not currently saved, so do not rely on importing them.

4 A read-only review of A showed MC as 0 after its workbook cell was left blank. The form was closed without saving an edit.
A read-only review of A showed MC as 0 after its workbook cell was left blank. The form was closed without saving an edit.

The preceding field meanings follow the catalogue. The example contains no tax number or account-owner name and does not demonstrate commission calculation.

Ledger and discount account references

code is the supplier ledger code. The catalogue describes linking a matching ledger when one exists, or creating a ledger under the selected group. Leaving it blank generates a new code.

ledger_code is an existing supplier ledger account code from Ledgers. Do not substitute a supplier serial or internal ID. A code that does not exist causes the row to be rejected.

5 Account columns in the prepared Excel example: B contains the deliberate invalid ledger_code, while code and the discount ledger code are bl...
Account columns in the prepared Excel example: B contains the deliberate invalid ledger_code, while code and the discount ledger code are blank.

discount_and_collection_ledger_id is the internal ID of the discount and collection account. discount_and_collection_ledger_code is its account code. Both are optional; the catalogue states that the code takes precedence when supplied.

This simple new-supplier example leaves all four account-reference fields blank, except for the deliberate bad code in B used to demonstrate correction.

Optional bank details

6 Bank-detail columns in the prepared Excel example are all blank. This is an Excel preview.
Bank-detail columns in the prepared Excel example are all blank. This is an Excel preview.

bank_name is the supplier’s bank name and bank_branch the bank branch. Keep bank_branch distinct from branch, which refers to the company branch.

account_number_usd is the USD bank account number, account_number_eur the EUR account number, and account_number_le the EGP account number. Store account numbers as text and review the corresponding currency definition before using them.

iban is the international bank account number and swift_code the bank’s SWIFT/BIC code. Copy these from the supplier’s approved banking details when needed.

All seven bank columns are optional and blank in this training example. This scenario does not include a bank transfer or supplier payment.

Selecting the group and uploading

7 The Import window shows supplier group موردين with code 2130000 and file suppliers-demo-mixed.xlsx.
The Import window shows supplier group موردين with code 2130000 and file suppliers-demo-mixed.xlsx.

Choose the appropriate supplier account group in Group, then choose the workbook in File. The group is a choice in this window, rather than an extra Excel column.

Check both selections and click Submit once. Open Background tasks and wait for the outcome before retrying.

8 The first attempt shows one successful row and one rejected row, with Completed. Download details provides the rejection report.
The first attempt shows one successful row and one rejected row, with Completed. Download details provides the rejection report.

Reading the error and correcting B

9 Excerpt from the actual error workbook: line is 3 and error identifies the nonexistent account code.
Excerpt from the actual error workbook: line is 3 and error identifies the nonexistent account code.

The message is No ledger found with code DEMO-NOT-FOUND-LEDGER. Review ledger_code on row 3 of the original workbook.

The list showed A as number 2 and no B. The refreshed ledger catalogue contained A’s account and no account named B. Check both the supplier and its account before retrying a rejected row.

To create a new ledger for B in this example, include only B in a copy of the template and leave ledger_code and code blank. Save as suppliers-demo-corrected.xlsx.

Do not resend the successful A row. If starting from the rejection report, remove its line and error columns before upload. Here the simpler approach is to use the original 23-column template.

Retrying and checking the supplier list

Choose the same group and the corrected B-only workbook, then click Submit once.

10 The new top operation shows 1 succeeded and Completed. The previous operation remains separate with its original counters.
The new top operation shows 1 succeeded and Completed. The previous operation remains separate with its original counters.
11 After reloading, the list total is 3: B is number 3 and A number 2, with the original supplier retained as number 1.
After reloading, the list total is 3: B is number 3 and A number 2, with the original supplier retained as number 1.

Checking the linked account codes

12 Horizontal scrolling shows ledger account codes: B is 21300000003, A is 21300000002, and the original is 21300000001.
Horizontal scrolling shows ledger account codes: B is 21300000003, A is 21300000002, and the original is 21300000001.

Distinguish Code, which displays the account code, from Supplier Code, which in this list displays the linked ledger identifier. Review the catalogue before using either value in an import field.

13 A read-only review in Edit Supplier shows the same account code 21300000002. The window was closed without saving an edit.
A read-only review in Edit Supplier shows the same account code 21300000002. The window was closed without saving an edit.

The final catalogue contains one account named after each new supplier, with the same codes. Both suppliers show a blank branch after branch was left blank. Review the details before using a supplier in transactions.

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