From a spreadsheet to UAE e-invoices
Many UAE businesses still raise invoices in Excel, or can export them from their accounting system only as a spreadsheet. Under UAE e-invoicing that is no longer the invoice: the legal invoice is a PINT AE XML file sent through an Accredited Service Provider. This converter bridges the gap. Save your sheet as CSV with one row per invoice line, open it here, and you get one PINT AE (UBL 2.1) XML per invoice, checked and ready to download as a zip.
How to prepare the CSV
- Start from the template (the "Download the CSV template" link) or rename the headers in your own sheet. Common names such as Invoice No, Customer, Qty and Price are recognised.
- One row per line item. An invoice with three items is three rows with the same invoice number, buyer and dates.
- Save as CSV. In Excel choose File, Save As, "CSV UTF-8 (Comma delimited)". Google Sheets: File, Download, Comma-separated values.
- Enter your own details once in the Seller box (legal name, TRN, emirate), then open the CSV.
| Column | Needed | Example |
|---|---|---|
| invoice_number | Yes | INV-1001 |
| issue_date | Yes | 14/11/2026 or 2026-11-14 (day first) |
| buyer_name, buyer_trn | Yes | Al Noor Trading LLC, 100234567800003 |
| description, quantity, unit_price | Yes | Website maintenance, 1, 2500 |
| vat_rate | No (5 if empty) | 5, 0 or exempt |
| currency, exchange_rate | No (AED if empty) | USD, 3.6725 |
| due_date, buyer_city, unit_code | No | 14/12/2026, Abu Dhabi, HUR |
What it checks
Before creating any XML it checks every row and lists problems by spreadsheet row number, so you can fix them in Excel and open the file again:
- TRNs: yours and each buyer's must have 15 digits. The 0235 Peppol ID (0235 followed by the first 10 digits, the TIN) is filled in for both parties. To clean a customer list first, use the TRN to TIN and Peppol ID converter.
- Dates and amounts: real dates, quantities above 0, prices that are numbers (commas and "AED" are fine), and a due date that is not before the issue date.
- VAT: 5% standard, 0% zero-rated or exempt on each line. VAT is calculated per category on the category total, as EN 16931 requires, so it never drifts by a fils.
- Consistency: every row of one invoice must have the same buyer, dates and currency; a different value is usually a copy and paste mistake.
- The finished XML: each file is read back with the same parser as the e-invoice XML viewer and checked with its totals rules before you can download it.
Invoices in a foreign currency
A PINT AE invoice can be in US dollars, euros or any other currency, but the VAT must also be stated in AED. Add currency and exchange_rate columns (AED per one unit, such as 3.6725 for USD) and the converter adds the AED tax currency and the VAT total in AED to the XML.
What it does not do
- It creates tax invoices (type 380) only, not credit notes.
- It carries the core fields. The Ministry of Finance lists 51 mandatory fields for a tax invoice, such as full addresses and payment details, which your ASP or accounting system adds and validates.
- It does not send anything. Invoices reach your customer and the FTA through your Accredited Service Provider.
To make a single invoice by hand, use the PINT AE invoice generator. Everything here runs in your browser: the CSV, the XML files and the zip never leave your device.