ETA Invoices Manual Import - kwentra Help Center

Import ETA invoices from a ready-made sheet. The sheet holds every field the ETA Portal needs.

Where: Settings → Integrations → ETA → Manual Invoices

Column Name	Description
Internal ID	Unique ID for the document. Max 40 characters. Must be unique inside the sheet. EIN00 is added in front, for example EIN00-1234.
Document Type	Invoice, Credit Note or Debit Note.
References	UUID references of documents already sent to ETA. Max 30 characters. Credit Note and Debit Note only.
Receiver Type	P, B or F.
Receiver ID	Unique ID of the receiver. Max 20 characters. Must be 14 characters when Receiver Type is P.
Receiver Name	Full name of the receiver. Max 200 characters.
Receiver Address	Street address of the receiver. Max 100 characters.
Receiver City	City of the receiver. Max 100 characters.
Receiver Country	ISO country code of the receiver. See the Country Codes list.
Department Code	A valid Kwentra department code. Its tax setup is applied automatically. Check your tax department mapping first. Put it on the line(s) after the document main data.
Amount	Invoice amount. Must be more than 0. Up to 5 decimal places. Put it on the line(s) after the document main data.
Currency	ISO currency code. Put it on the line(s) after the document main data.
Exchange Factor	Exchange factor for the currency. It is 1 for EGP. Put it on the line(s) after the document main data.
Comments	Extra notes. Optional, max 500 characters. On an invoice line, max 50 characters.

The system checks the sheet before it imports. Common errors:

Fix the sheet and upload it again.

If the internal ID already exists in the system:

Status Invalid or Empty — the old document is deleted and a new one is created.
Any other status — the new document is ignored. You see: “Document {internal ID} already created in the system with status {status}”.

Click the Instructions tab for full instructions, common problems and an example sheet.

Update: July 2026

The sheet has a new SO Reference column. Comments now show correctly on the ETA invoice, for invoices and for receipts.

SO Reference sends a document-level reference to ETA. It shows under Sales Order Reference. Max 100 characters.
Document-level comments now show under Sales Order Description. Max 500 characters.
Invoice line comments now show as the line description on the ETA invoice. They replace the department description. An empty comment keeps the department description.

Download the latest template from Settings → Integrations → ETA → Manual Invoices.
Fill in SO Reference at document level. Max 100 characters.
Add comments where you need them:
- A comment on the document line is sent as the Sales Order Description.
- A comment on an invoice line is sent as that line’s description.
- Leave it empty to keep the department description for that line.
Import the sheet as usual. The mapped values show on the ETA invoice printout.

Note: These mappings work for invoices and for receipts. The Instructions tab has the full field reference.