Invoice Uploads
Send invoices without connecting an accounting system, or invoices your system cannot send: fill a template, or drop the invoice PDFs your system prints. Each invoice is checked against the UAE rules when it is uploaded and waits, ready to send to Peppol. This page covers every column, every use case and every value the templates accept.
At a glance
| Topic | In short |
|---|---|
| Two templates | Invoice, for invoices you send to your customers. Billing, for invoices you raise on behalf of a supplier (self-billing). |
| Also accepted | Invoice PDFs and images (PDF, PNG, JPG, TIFF, BMP, HEIC), up to 10 MB each. They should be printed by one of the six supported accounting systems: Xero, QuickBooks, Zoho Books, Odoo, Wafeq or Naqood. |
| Who can upload | Admins and editors of the company. See Users and roles. |
| One row is one invoice | Its lines go on Line Items, under the same Invoice #. |
| Totals | Worked out from the lines. The templates have no total columns; an older template's typed totals are ignored. |
How an upload goes
| Step | What happens |
|---|---|
| 1. Add the files | On Sent invoices, press Batch Upload and drop your files on Upload Invoices: filled templates (.xlsx, .xls), invoice PDFs and images, several at once. Each file uploads as soon as it is added. |
| 2. Each invoice is checked | Every row is turned into an e-invoice and checked against the UAE rules straight away, before anything is sent. Your company's own details — its name, TRN, address and Peppol ID — come from your company record, never from the file. |
| 3. It is stored with its result | Passed: ready to send. Missing a value the invoice's Missing details tab asks for, or a PDF's readings still to confirm: Held until someone gives them there. Failed for anything else: listed under Failed with its reasons, to correct in your file. Kept out: stored as excluded and never sent. |
| 4. Send | Send from the upload dialog, with Send all beside Batch Upload, or one at a time with Validate & send to Peppol in an invoice's actions. An entity that requires approval holds it for an approver first. |
| Who uploaded and sent it | An invoice's Invoice Details tab shows Uploaded by and Uploaded on, then Sent by and Sent on once Peppol accepted it: each person's name and account email, and how they sent it (pressed Send, approved it, or approved by email link). A PDF your accounting system printed is sent on upload, so its uploader is who sent it unless an approver released it. Invoices sent before 12 November 2026 show who uploaded them, but not who sent them. |
| To correct one | A failed row is corrected in your file, not on the screen: choose Delete upload, fix the row and upload the file again. An invoice number already uploaded is refused, so delete the old one first. |
Downloads
| File | What it is |
|---|---|
| Invoice template | Download. Blank. The same file as the Invoice button on Upload Invoices. |
| Billing template | Download. Blank, for self-billing. The same file as the Billing button. |
| Invoice samples | Download. The Invoice template filled with 40 invoices: one per use case, then one per option. |
| Billing samples | Download. The Billing template filled with 7 self-billed invoices and credit notes. |
Every company, person and number in the samples is invented. Their TRNs only have the right shape; uploaded under your company, the samples are checked like real invoices but should not be sent.
Reading the template
| On the sheet | Means |
|---|---|
| Column name ending in * | Required on every invoice or line. |
| No * | Optional, or required only in a stated case. Click a cell: its tooltip says exactly when, and what to type. |
| Dates | Type them day first: 05-10-2026 is 5 October 2026. 05/10/2026 and 2026-10-05 work too. Date cells are text, so what you type is what is read, whatever your computer's date settings. Excel has no date picker; Google Sheets shows one. |
| Light-red cell | Required in this row's case, and still empty. |
| Grey cell | Does not apply to this row — for a credit note, a special supply, a foreign currency or customer, an exempt or reverse-charge line. Leave it empty. |
| Dropdown | Pick from the list. A typed value outside it gets a warning; a pasted one is not checked by Excel, but the upload refuses a Type or Payment Method it does not know. |
| Calculated columns | Net Unit Price, Line Net Amt and VAT Line Amt work themselves out. VAT is charged on Standard rated lines only: a reverse-charge or margin-scheme line states its 5% rate and charges none. |
| Invoice Totals sheet | Adds each invoice up from its lines, to check before uploading. |
| Column names | Never rename one: the upload finds each column by its name. Your own columns to the right are ignored. |
Use cases
The UAE recognises 16 kinds of invoice. Each is set by three things on the row: the Type, the Transaction Type code and the lines' Tax Category. UC15 and UC16 go on the Billing template; the rest on the Invoice template. The full definitions are on UAE use cases.
| Use case | Name | Type | Transaction Type | Tax Category | Sample |
|---|---|---|---|---|---|
| UC1 | Standard tax invoice | Tax Invoice | 00000000 — None declared — an ordinary domestic supply | Standard rated, Zero rated, Exempt, Out of scope, Reverse charge | INV-UC01-01, INV-UC01-02, INV-UC01-03, INV-UC01-04, INV-UC01-05, INV-UC01-06, INV-UC01-07, INV-UC01-08, INV-UC01-09, INV-UC01-10, INV-UC01-11, INV-UC01-12, INV-UC01-13, INV-UC01-14, INV-UC01-15, INV-UC01-16, INV-UC01-17, INV-UC01-18 |
| UC2 | Reverse charge supply | Tax Invoice | 00000000 — None declared — an ordinary domestic supply | Reverse charge | INV-UC02-01, INV-UC02-02 |
| UC3 | Zero rated supplies | Tax Invoice | 00000000 — None declared — an ordinary domestic supply | Zero rated | INV-UC03-01 |
| UC4 | Deemed supply | Tax Invoice | 01000000 — Deemed supply | Standard rated | INV-UC04-01 |
| UC5 | Disclosed agent billing | Tax Invoice | 00000100 — Disclosed agent billing | Standard rated | INV-UC05-01 |
| UC6 | Summary tax invoice | Tax Invoice | 00010000 — Summary invoice | Standard rated, Reverse charge | INV-UC06-01, INV-UC06-02 |
| UC7 | Continuous supplies | Tax Invoice | 00001000 — Continuous supply | Standard rated, Exempt | INV-UC07-01 |
| UC8 | Free trade zone | Tax Invoice | 10000000 — Free trade zone | Standard rated | INV-UC08-01 |
| UC9 | Supply through e-commerce | Tax Invoice | 00000010 — Ecommerce | Standard rated | INV-UC09-01 |
| UC10 | Exports | Tax Invoice | 00000001 — Exports | Zero rated | INV-UC10-01, INV-UC10-02 |
| UC11 | Profit margin scheme | Tax Invoice | 00100000 — Profit margin scheme | Margin scheme | INV-UC11-01 |
| UC12 | Standard tax credit note | Credit Note or Commercial Credit Note | 00000000 — None declared — an ordinary domestic supply | Standard rated | CN-UC12-01, CN-UC12-02, CN-UC12-03, CN-UC12-04, CN-UC12-05, CN-UC12-06 |
| UC13 | Disclosed agent credit note | Credit Note | 00000100 — Disclosed agent billing | Standard rated | CN-UC13-01 |
| UC14 | Commercial invoice / out of scope | Commercial Invoice or Commercial Credit Note | 00000000 — None declared — an ordinary domestic supply | Out of scope, Exempt | INV-UC14-01, CN-UC14-02 |
| UC15 | Self billing | Self-Billed Invoice | 00000000 — None declared — an ordinary domestic supply | Standard rated | SB-UC15-01, SB-UC15-02, SB-UC15-03, SB-UC15-04 |
| UC16 | Self billed credit note | Self-Billed Credit Note | 00000000 — None declared — an ordinary domestic supply | Standard rated | SBCN-UC16-01, SBCN-UC16-02, SBCN-UC16-03 |
Transaction Type is eight 0/1 flags, and flags combine: 00011000 is a summary invoice for a continuous supply. One rule limits it: an invoice whose every line is exempt or out of scope cannot also be a deemed supply, a margin scheme or a summary invoice.
Use case checklist
The columns that are required only in some cases, against each use case. Required means that use case's invoice must fill it. Columns marked * are required on every invoice and are not repeated here. Whatever the use case, an exempt line needs its Exemption Reason, and a reverse-charge line its RCM Goods Type and Item Standard ID.
| Column | Required when | UC1 | UC2 | UC3 | UC4 | UC5 | UC6 | UC7 | UC8 | UC9 | UC10 | UC11 | UC12 | UC13 | UC14 | UC15 | UC16 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Due Date | unless a credit note or deemed supply. | Required | Required | Required | – | Required | Required | Required | Required | Required | Required | Required | – | – | Required | Required | – |
| Period Start | for a summary invoice. | – | – | – | – | – | Required | – | – | – | – | – | – | – | – | – | – |
| Period End | for a summary invoice. | – | – | – | – | – | Required | – | – | – | – | – | – | – | – | – | – |
| Beneficiary ID | for a free trade zone supply. | – | – | – | – | – | – | – | Required | – | – | – | – | – | – | – | – |
| Principal ID | for disclosed agent billing. | – | – | – | – | Required | – | – | – | – | – | – | – | Required | – | – | – |
| Customer TRN | for a UAE buyer (not an Individual). | Required | Required | Required | Required | Required | Required | Required | Required | Required | – | Required | Required | Required | Required | Required | Required |
| Participant ID / Electronic Addr | for a buyer outside the UAE. | – | – | – | – | – | – | – | – | – | Required | – | – | – | – | – | – |
| Participant Scheme | with a Participant ID / Electronic Addr. | – | – | – | – | – | – | – | – | – | Required | – | – | – | – | – | – |
| Preceding Invoice # | on a credit note, unless the reason is VD. | – | – | – | – | – | – | – | – | – | – | – | Required | Required | – | – | Required |
| Credit Reason Code | on a credit note. | – | – | – | – | – | – | – | – | – | – | – | Required | Required | – | – | Required |
| Delivery Address | for an e-commerce supply or export. | – | – | – | – | – | – | – | – | Required | Required | – | – | – | – | – | – |
| Delivery City | for an e-commerce supply or export. | – | – | – | – | – | – | – | – | Required | Required | – | – | – | – | – | – |
| Delivery Subdivision | for an e-commerce supply or export. | – | – | – | – | – | – | – | – | Required | Required | – | – | – | – | – | – |
| Delivery Country | with a Delivery Address. | – | – | – | – | – | – | – | – | Required | Required | – | – | – | – | – | – |
| Tax Rate % | unless Exempt or Out of scope. | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | Required | – | Required | Required |
| RCM Goods Type | on a Reverse charge line. | – | Required | – | – | – | – | – | – | – | – | – | – | – | – | – | – |
| Item Standard ID | on a Reverse charge line. | – | Required | – | – | – | – | – | – | – | – | – | – | – | – | – | – |
Invoice Tracker columns
One row per invoice. Listed in the template's order.
| Column | Required | What to put |
|---|---|---|
| Invoice # | Required | IBT-001. Must match its rows on Line Items. Example: INV-0001 |
| Date | Required | IBT-002 issue date. Example: 17-09-2026 |
| Due Date | Required unless a credit note or deemed supply. | IBT-009. The payment due date. Example: 17-10-2026 |
| Type | Required | Whether the document is an invoice or a credit note, and whether it is a tax or a commercial one. IBT-003. Choose: Tax Invoice, Credit Note, Commercial Invoice, Commercial Credit Note. Example: Tax Invoice |
| Transaction Type | Optional | Any special kind of supply, such as free zone, export or summary invoice. Flags can combine. BTUAE-02. 00000000 for none; type flags together, e.g. 10000001. Choose from its list, under Value lists. Example: 00000000 |
| Period Start | Required for a summary invoice. | IBT-073. Allowed on any invoice. Example: 01-09-2026 |
| Period End | Required for a summary invoice. | IBT-074. Not before Period Start. Example: 30-09-2026 |
| Beneficiary ID | Required for a free trade zone supply. | BTAE-01. The beneficiary's TRN. Only on a free trade zone supply (Transaction Type). Example: 100000000000303 |
| Principal ID | Required for disclosed agent billing. | BTAE-14. The principal's TRN. Only on disclosed agent billing (Transaction Type). Example: 100000000000203 |
| Currency | Required | The currency the invoice is written in. Anything but AED also needs an Exchange Rate. IBT-005. Choose from its list, under Value lists. Example: AED |
| Exchange Rate | Required when Currency is not AED. | BTUAE-04. The Central Bank rate to AED. Only when the currency is not AED. Example: 3.6725 |
| Customer Name | Required | IBT-044. Registered name of the buyer. Example: Buyer Company LLC |
| Customer Type | Optional | Whether the buyer is a business or a private person. A private person with no TRN is kept out of e-invoicing. Choose: Individual, Business. Example: Business |
| Customer TRN | Required for a UAE buyer (not an Individual). | IBT-048. 15 digits, starts 1, ends 03. Example: 100000000000103 |
| Participant ID / Electronic Addr | Required for a buyer outside the UAE. | IBT-049. The buyer's Peppol id. Only for a buyer outside the UAE. Example: 1234567890 |
| Participant Scheme | Required with a Participant ID / Electronic Addr. | IBT-049-1. Not 0235 outside the UAE. Only for a buyer outside the UAE. Example: 0088 |
| Address | Required | IBT-050 street address. Example: 1 Business Bay |
| Address 2 | Optional | IBT-051. A second address line. Example: Tower B, Floor 12 |
| City | Required | IBT-052. Example: Dubai |
| Post Code | Optional | IBT-053. Example: 00000 |
| Emirate / State | Required | The emirate of a UAE customer, or the state or province of one abroad. Pick an emirate from the list; type a state. IBT-054. Choose from its list, under Value lists. Example: DXB |
| Country | Required | The country of the customer's address. Outside the UAE, the customer is reached by its Peppol ID. IBT-055, ISO 3166-1. Choose from its list, under Value lists. Example: AE |
| Legal Reg ID | Optional | IBT-047 trade licence or registration number. Example: TL-000001 |
| Legal Reg Type | Optional | The document the customer is registered under: trade licence, Emirates ID, passport or cabinet decision. BTUAE-16. Choose: Commercial/Trade license, Emirates ID, Passport, Cabinet decision. Example: Commercial/Trade license |
| Authority Name | Optional | BTUAE-11 issuing authority. Example: DED Dubai |
| Passport CC | Required when Legal Reg Type is Passport. | BTUAE-19. The passport's country. Only when Legal Reg Type is Passport. Example: GB |
| Phone | Optional | IBT-057. With country code. On the e-invoice and PDF. Example: +971 50 1234567 |
| Optional | IBT-058. On the e-invoice and PDF. Example: billing@example.ae | |
| Payment Method | Optional | How the invoice is paid. A credit transfer also needs the IBAN. IBT-081. Leave blank if not known: it is sent as Instrument Not Defined. Choose from its list, under Value lists. Example: Credit Transfer |
| Payment Acct ID | Required for a credit transfer (not on a credit note). | IBT-084. The IBAN. Example: AE000000000000000000000 |
| Preceding Invoice Date | Optional | IBT-026. Only on a credit note. Example: 01-08-2026 |
| Preceding Invoice # | Required on a credit note, unless the reason is VD. | IBT-025. The invoice being credited. Only on a credit note. Example: INV-0001 |
| Credit Reason Code | Required on a credit note. | Why a credit note is issued. Every reason except a volume discount names the original invoice. BTUAE-03. Only on a credit note. Choose: DL8.61.1.A, DL8.61.1.B, DL8.61.1.C, DL8.61.1.D, DL8.61.1.E, VD. Example: DL8.61.1.A |
| Customs Ref | Optional | BTAE-21. Customs declaration reference. Example: CUS-000123 |
| Incoterms | Optional | BTAE-22. Example: CIF |
| Delivery Date | Optional | IBT-072. Example: 16-09-2026 |
| Deliver To Name | Optional | IBT-070. Example: Warehouse |
| Deliver To ID | Optional | IBT-071. Example: LOC-1 |
| Deliver To ID Scheme | Optional | IBT-071-1. Example: 0088 |
| Delivery Address | Required for an e-commerce supply or export. | IBT-075. Example: 3 Export Way |
| Delivery Address 2 | Optional | IBT-076. |
| Delivery Address 3 | Optional | IBT-165. |
| Delivery City | Required for an e-commerce supply or export. | IBT-077. Example: Los Angeles |
| Delivery Post Code | Optional | IBT-078. Example: 90001 |
| Delivery Subdivision | Required for an e-commerce supply or export. | The emirate or state the goods are delivered to, for an export or an online sale. IBT-079. An emirate code in the UAE. Choose from its list, under Value lists. Example: CA |
| Delivery Country | Required with a Delivery Address. | The country the goods are delivered to, for an export or an online sale. IBT-080. Choose from its list, under Value lists. Example: US |
| Notes | Optional | IBT-022. |
| E-invoicing Exclusion Scope | Optional | The legal reason an invoice is kept out of e-invoicing. Leave blank to e-invoice it. MD 243 Art. 4. A reason stores the invoice as excluded: never sent. Choose from its list, under Value lists. |
| Scope Note | Required when the scope is OTHER. | What the transaction is. Only when the E-invoicing Exclusion Scope is OTHER. |
Line Items columns
One row per line. Invoice # ties it to its invoice; Line # numbers the lines from 1.
| Column | Required | What to put |
|---|---|---|
| Invoice # | Required | Must match the Invoice Tracker row exactly. Example: INV-0001 |
| Line # | Required | IBT-126. Example: 1 |
| Item Name | Optional | IBT-153. Example: Steel plate |
| Description | Required | IBT-154. Example: Steel plate, 5mm |
| Item Type | Optional | Whether the line is goods, services or both. For display only. Not the RCM goods type. Choose: Goods, Services, Both. Example: Goods |
| Qty | Required | IBT-129. Example: 2 |
| Unit | Optional | The unit the quantity is counted in, such as each, hour or kilogram. IBT-130. Leave blank for Each. Choose from its list, under Value lists. Example: Each |
| Gross Price | Required | IBT-148, before any discount. Example: 50.00 |
| Discount % | Optional | IBT-147. Example: 0 |
| Base Qty | Optional | IBT-149. Units the price covers. Default 1. Example: 1 |
| Tax Category | Required | The VAT treatment of the line, which decides its rate and the VAT charged. IBT-151. Choose: Standard rated, Zero rated, Exempt, Out of scope, Reverse charge, Margin scheme. Example: Standard rated |
| Tax Rate % | Required unless Exempt or Out of scope. | IBT-152. 5 standard or margin, 0 zero rated. Example: 5 |
| Exemption Reason | Required on an Exempt line. | The legal reason an exempt line carries no VAT. IBT-121. Codes outside the list are accepted. Only on an Exempt line. Choose: DL8.46.1, DL8.46.2, DL8.46.3, DL8.46.4. Example: DL8.46.1 |
| RCM Goods Type | Required on a Reverse charge line. | The kind of goods on a reverse-charge line, where the buyer accounts for the VAT. BTUAE-09. Only on a Reverse charge line. Choose: DL8.48.8.1, DL8.48.8.2, DL8.48.3.1, DL8.48.3.2, DL8.48.3.3. Example: DL8.48.8.1 |
| Item Standard ID | Required on a Reverse charge line. | IBT-157. The item's standard identifier, e.g. its GTIN. Example: GTIN-0001 |
| HS Code | Optional | IBT-158. Example: 7208.51 |
| Service Code | Optional | IBT-158. |
| Net Unit Price | Calculated — do not type | IBT-146. Calculated — do not type here. |
| Line Net Amt | Calculated — do not type | IBT-131. Calculated — do not type here. |
| VAT Line Amt | Calculated — do not type | Calculated — do not type here. |
The Billing template
The same columns, with two differences. The customer columns (Customer Name, Customer TRN, the address…) hold the supplier you bill on their behalf. And these columns are not there, because on a self-bill the counterparty is your supplier, not a customer: Customer Type, E-invoicing Exclusion Scope, Scope Note. Its types are Self-Billed Invoice, Self-Billed Credit Note, Self-Billed Commercial Invoice, Self-Billed Commercial Credit Note.
Value lists
Every dropdown, with the code each choice becomes on the e-invoice. Codes are exact: type them as listed, or pick them.
| Column | Choices | What it means |
|---|---|---|
| Type |
| Whether the document is an invoice or a credit note, and whether it is a tax or a commercial one. |
| Transaction Type |
| Any special kind of supply, such as free zone, export or summary invoice. Flags can combine. |
| Currency |
| The currency the invoice is written in. Anything but AED also needs an Exchange Rate. |
| Customer Type |
| Whether the buyer is a business or a private person. A private person with no TRN is kept out of e-invoicing. |
| Emirate / State |
| The emirate of a UAE customer, or the state or province of one abroad. Pick an emirate from the list; type a state. |
| Country |
| The country of the customer's address. Outside the UAE, the customer is reached by its Peppol ID. |
| Legal Reg Type |
| The document the customer is registered under: trade licence, Emirates ID, passport or cabinet decision. |
| Payment Method |
| How the invoice is paid. A credit transfer also needs the IBAN. |
| Credit Reason Code |
| Why a credit note is issued. Every reason except a volume discount names the original invoice. |
| Delivery Subdivision |
| The emirate or state the goods are delivered to, for an export or an online sale. |
| Delivery Country |
| The country the goods are delivered to, for an export or an online sale. |
| E-invoicing Exclusion Scope |
| The legal reason an invoice is kept out of e-invoicing. Leave blank to e-invoice it. |
| Item Type |
| Whether the line is goods, services or both. For display only. |
| Unit |
| The unit the quantity is counted in, such as each, hour or kilogram. |
| Tax Category |
| The VAT treatment of the line, which decides its rate and the VAT charged. |
| Exemption Reason |
| The legal reason an exempt line carries no VAT. |
| RCM Goods Type |
| The kind of goods on a reverse-charge line, where the buyer accounts for the VAT. |
Invoices kept out of e-invoicing
A sale to a private individual — Customer Type Individual, with no Customer TRN and no Participant ID / Electronic Addr — is kept out, and so is any row whose E-invoicing Exclusion Scope names a reason. OTHER also needs a Scope Note saying what the transaction is, and the Tax Group reason applies only to invoices dated 2027 and 2028. A kept-out row is stored as excluded, with only its summary, instead of being checked and sent. See Invoices outside e-invoicing.
Credit notes
Type Credit Note (or Commercial Credit Note, Self-Billed Credit Note) with a Credit Reason Code, and the number and date of the invoice it corrects in Preceding Invoice # and Preceding Invoice Date — except reason VD, a volume discount, which names no invoice. A credit note has no Due Date. See Credit notes.
PDF and image uploads
Upload PDFs your accounting system printed: Xero, QuickBooks, Zoho Books, Odoo, Wafeq or Naqood. One printed for your company is recognised and stored as that system's invoice, and handled like it. A PDF from anywhere else is still read, laid out as a template row and checked like one, but check what was read on its Missing details tab before sending.
A document cannot say everything: the Transaction Type flags, which category a 0% line is, a reverse-charge line's goods type and item identifier. These are asked for on the invoice's Missing details tab, and anything the reader was unsure of must be confirmed there before the invoice can be sent.
When an upload is refused
| The message says | What to do |
|---|---|
| The entity's TRN is missing or is not a valid UAE TRN | Your company's TRN, on your company record, is not 15 digits starting with 1 and ending with 03 or 001. The file cannot fix it: correct the TRN on your company, then delete the upload and upload it again. |
| Contact TaxNumber … is not a valid UAE TRN or TIN | Customer TRN must be a 15-digit TRN (starting with 1, ending with 03 or 001) or a 10-digit TIN starting with 1. A 16-digit number is the usual cause. |
| Quantity must be greater than zero | A line has Qty blank or 0. Every line needs a quantity above zero, goods and services alike — a lump-sum service is Qty 1. |
| Line Amount must be greater than zero | A line works out to nothing: Gross Price is blank or 0, or Discount % is 100. |
| Duplicate — already uploaded | That invoice number is already uploaded for this company, by you or another member. Delete the old upload first. |
| No line items found | The invoice has no rows on Line Items, or its rows there spell the Invoice # differently. Line rows whose Invoice # matches no invoice are ignored. |
| Type "…" is not one of the template's document types | Type or Payment Method holds a value its list does not offer. Pick from the list; a pasted value is not checked by Excel. |
| A credit transfer needs its Payment Acct ID | Payment Method is Credit Transfer but the IBAN is empty. |
| Already in your invoices from … | A PDF of an invoice your connected accounting system already sent is not taken again, so it never reaches Peppol twice. |
Anything else: When an invoice fails.