UAE e-invoicing · Free · Private

Is your customer data ready for e-invoicing?

From 2027 every B2B invoice in the UAE must go out as an e-invoice. It cannot be sent without the customer's tax number, address, city and emirate, and every item needs an official unit code. Upload your customer list and see in one minute who is ready, what we can fix for you, and exactly what is missing.

🔒 Your file never leaves your computer
⚖️ Based on the Ministry of Finance field list and PINT AE
⏱ Results in about a minute

1 Upload your customer list (and your item list, if you like)

Drop your customer list here or choose files · Excel, CSV or TXT export · you can add the item list too

Download the sample file

Any accounting system works: SAP, Odoo, Zoho, QuickBooks, Tally or a plain Excel list. Useful columns: customer name, TRN, address, city, emirate, country, and if you have it, the last invoice date. For units: the item list with its unit column.

Using SAP Business One? Copy this query

Run it in the Query Manager and export the result (Excel or TXT). It lists your customers with their tax number, default bill-to address and last invoice date.

SELECT T0."CardCode" AS "Customer Code", T0."CardName" AS "Customer Name",
  CASE T0."CmpPrivate" WHEN 'C' THEN 'Company' WHEN 'I' THEN 'Private person' WHEN 'G' THEN 'Government' END AS "Customer Kind",
  T0."LicTradNum" AS "Federal Tax ID (TRN)", T0."frozenFor" AS "Inactive", T4."LastInv" AS "Last Invoice Date",
  T2."Street" AS "Bill to Street", T2."Block" AS "Bill to Block", T2."Building" AS "Bill to Building",
  T2."City" AS "Bill to City", T2."State" AS "Bill to State / Emirate", T2."Country" AS "Bill to Country"
FROM OCRD T0
LEFT JOIN CRD1 T2 ON T2."CardCode" = T0."CardCode" AND T2."AdresType" = 'B' AND T2."Address" = T0."BillToDef"
LEFT JOIN (SELECT "CardCode", MAX("DocDate") AS "LastInv" FROM OINV WHERE "CANCELED" = 'N' GROUP BY "CardCode") T4
  ON T4."CardCode" = T0."CardCode"
WHERE T0."CardType" = 'C'
ORDER BY T4."LastInv" DESC NULLS LAST

Units: SELECT "SalUnitMsr" AS "Sales Unit", COUNT(*) AS "Items" FROM OITM WHERE "SellItem" = 'Y' GROUP BY "SalUnitMsr"

Your e-invoicing deadline

No file needed.

When do you need to be ready?

Annual revenue (AED) We are a government entity

Enter your revenue to see your phase.

Your Peppol ID

Your TRN (15 digits)

Your e-invoicing address is 0235: followed by the first 10 digits of your TRN.

Good to know

Not legal advice. It checks your data against the Ministry of Finance field list (23 Feb 2026) and the Peppol PINT AE specification (v1.0.4). Review results with your accountant or e-invoicing provider.
Private. Your file is read in your browser only. We never receive your customer list.
Format only. We check that TRNs and Peppol IDs look right. We cannot confirm with the FTA that a TRN is registered, or that a customer is already live on the Peppol network.
Peppol IDs we create follow the official rule (0235 + first 10 digits of the TRN). For companies in a VAT group, the TRN you hold may be the group's: each company needs its own number.
Private persons (B2C) are not in scope yet. Foreign customers follow different delivery rules, so they are counted but not checked in detail.
Files: Excel, CSV or TXT. Not PDF invoices or password-protected files. Works best on a computer.