Skip to content
Trio Travel guide

Importing Electronic Invoices from Excel

On this page
  1. 1 Prepare the template and example
  2. 2 Invoice identifiers and references
  3. 3 Quantity price and fixed discount
  4. 4 Taxes and receiver type
  5. 5 Receiver name and address
  6. 6 Upload and reconcile the result
  7. 7 Review lines before signing
  8. 8 Existing-customer lookup and error handling

1 Prepare the template and example

1 Import creates multiple e-invoices from an Excel file. This example uses two imported invoices for Computer Software.
Import creates multiple e-invoices from an Excel file. This example uses two imported invoices for Computer Software.

Open E-invoice → Invoices. Obtain the approved template and its column catalog. This example uses the Import worksheet with 32 columns. Keep column names unchanged and enter data starting in row 2.

Confirm the item, currency and branch exist in the current organization. Do not reuse branch or customer identifiers from another company’s catalog. The example uses EGS, internal code 1, EGP and exchange rate 1.

The training identities are fictitious. Successful import means the invoice was saved in Trio. Review, electronic signing, submission and processing status are subsequent steps.

2 Invoice identifiers and references

2 internalid groups invoice lines; internalcode identifies the item within the selected item catalog.
internalid groups invoice lines; internalcode identifies the item within the selected item catalog.

internalid: required invoice grouping key. Repeat it across rows to create multiple lines in one invoice. Invoice-level fields are read from the group’s first row. Avoid an ID already used in the same year for the same document type.

invoicetype: i for invoice, c for credit note and d for debit note. The catalog also supports ei, ec and ed; this example uses i. Blank or unrecognized input defaults to i, so enter the intended code explicitly.

proformainvoicenumber is the proforma reference; purchaseorderreference is the purchase order reference; salesorderreference is the sales order reference. These are optional and default to 0 when blank.

taxpayeractivitycode is the document activity code, 5229 here. internalcode is required on every line and must exactly match an existing item internal code. itemtype accepts uppercase EGS or GS1; blank defaults to EGS.

3 Quantity price and fixed discount

3 Invoice 1 uses 2 × 1000 with a fixed discount of 200, producing a net amount of EGP 1800.
Invoice 1 uses 2 × 1000 with a fixed discount of 200, producing a net amount of EGP 1800.

description is the line description and falls back to the item’s primary name when blank. currency is an existing currency code, such as EGP, and defaults to EGP. Verify the imported currency.

totaltaxablefees holds additional taxable line fees; the example uses 0. unittype is the unit-of-measure code and defaults to EA.

quantity is converted to an integer, truncating fractional units. price is the unit amount. Sales amount equals quantity × price. Both fields default to 0 when blank.

discount is a fixed line amount, not a percentage. To apply 10% to 2000, enter 200 in this template. exchangerate converts the line currency to EGP and defaults to 1.

4 Taxes and receiver type

4 Enter tax percentages as numbers such as 14 and 3. Review tax subtypes after import.
Enter tax percentages as numbers such as 14 and 3. Review tax subtypes after import.

itemsdiscount is an additional line item discount. t1 and t4 are their respective percentages on line net total. The training example uses 14 and 3 as directed by the system owner; use the applicable rates for your transaction.

subtype is a shared import field used for both T1 and T4. When blank, T1 defaults to V009 and T4 to W009. The example displayed W009 as Supporting export subsidies. Review it in the item editor before signing and choose the applicable subtype.

extradiscountamount is the document-level additional discount and defaults to 0. branchid is an existing internal branch ID in the current organization. Blank uses the signed-in user’s branch.

type: 1 Person, 2 Business or 3 Foreigner. With an explicit type, provide customername; Business and Foreigner also require customerid. This example uses type 2 and fictitious tax ID 123456789, not a customer database record ID.

5 Receiver name and address

5 This example supplies the receiver identity and address explicitly in the template.
This example supplies the receiver identity and address explicitly in the template.

customername is required for an explicit receiver type. country accepts a country code or name. The example uses EG, also the blank default for direct receiver entry.

governate is the governorate, such as Cairo. regioncity is the city or district, such as Nasr City. region_city is an alias read when regioncity is blank; avoid conflicting entries.

street is the street/address. buildingnumber holds the building number. building_number is an alias used when buildingnumber is blank. The example uses Demo Tourism Street and building 10.

The importer may substitute a dash for missing direct-entry address fields. Complete and review correct address details; saving an imported row does not replace tax-platform validation.

6 Upload and reconcile the result

6 The result shows Total 2, Saved 2 and Not Saved 0. Choose OK to return to the invoice list.
The result shows Total 2, Saved 2 and Not Saved 0. Choose OK to return to the invoice list.

Save as xlsx. Choose Import From Excel and select the populated workbook. Verify its name in Upload EXCEL File, then select Yes; choose No if it is the wrong file. Wait for Upload Results before another upload.

Search by internalID. Invoice 32 is DEMO-EIMP-20261113-001 for 1998; invoice 33 is DEMO-EIMP-20261113-002 for 1665. The combined amount is EGP 3663.

Invoice 1 reconciles as 1800 + 252 − 54 = 1998. Invoice 2 reconciles as 1500 + 210 − 45 = 1665. Check receiver name, identity, address, currency and every line rather than relying only on the saved count.

7 Review lines before signing

7 Choose Edit from the invoice row menu, then the item’s pencil icon to review taxes and discount.
Choose Edit from the invoice row menu, then the item’s pencil icon to review taxes and discount.

Confirm the first example has fixed discount 200, T1 14, T4 3 and total 1998. Review each tax subtype; an import default is not automatically appropriate for every activity.

When changing an item, save it in the item window and then save the invoice using Edit. Use Close to leave without saving. Ensure the entire invoice revision is saved before signing.

Imported invoices initially show Not Signed. After review, use the signing program and token, then submit and monitor the processing status. Import alone does not perform these steps.

8 Existing-customer lookup and error handling

8 Choose the receiver-entry route deliberately and check invoice IDs before uploading again.
Choose the receiver-entry route deliberately and check invoice IDs before uploading again.

According to the catalog, with type blank, a 14-character customerid is interpreted as a person identity and a 9-character value as a business tax number. Both routes require customername. An empty customerid follows the person route and also requires a name.

If customerid is neither 9 nor 14 characters and type is blank, the importer looks up an existing customer using tax_number, customer_id or serialId. The customer record needs country, city, region_city, address and a numeric building_number. Record data is used and the supplied customername is ignored on this route.

The tested example uses explicit type 2, name, tax ID and address; it does not verify the existing-customer lookup route. If Not Saved appears, review the template, item internal code and catalog type, receiver details, branch and duplicate internalid. Under the catalog rules, an error in one invoice group rejects that whole invoice.

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