A UAE tax invoice template is a layout plus rules. The layout carries the details the VAT law requires; the rules keep numbering, currency and corrections consistent. This guide covers what to build into an Excel or accounting-system template and the points that most often fail a review.
Layout: where each field goes
| Zone | What to put there |
|---|---|
| Header | The words Tax Invoice, invoice number, issue date, date of supply if different |
| Supplier block | Name, address, TRN |
| Customer block | Name, address and TRN if registered |
| Line items | Description, quantity, unit price, discount, taxable amount, VAT rate and VAT amount |
| Totals | Total excluding VAT, total VAT in AED, total payable |
| Footer | Payment terms, bank details, any notes such as reverse charge |
For the legal list of required details see UAE tax invoice requirements. The table above is a layout suggestion, not a replacement for the regulation.
Numbering that survives an audit
Commentary on the Executive Regulation lists a unique, sequential invoice number among the particulars of a full tax invoice. A practical way to meet this:
- Use one running sequence per document type, such as INV-2026-0001.
- Do not reuse or overwrite a number. If an invoice is wrong, issue a credit note and a new invoice.
- Let the system assign numbers. Typing them manually is how gaps and duplicates appear.
- Keep proformas, quotes and delivery notes in separate series. See proforma vs tax invoice.
- If a number is void, keep a record of why.
Building it in Excel
- Create a locked invoice sheet with cells for the fields above and a separate sheet for customers.
- Use formulas for the taxable amount, VAT and totals so staff cannot override them by hand.
- Round VAT to two decimals at the line or invoice level, and use the same method every time.
- Protect the sheet and keep a log of invoices issued to prevent duplicates.
- Save each invoice as a PDF and file it with the supporting delivery or service record.
Excel works for very low volumes. Beyond that, an accounting system with automatic numbering is safer, and under e-invoicing it will be essential. See FTA-approved accounting software and the e-invoicing software checklist. For a quick draft, you can try the tax invoice generator.
Currency and VAT in AED
Invoices can be issued in a foreign currency, but the VAT amount has to be shown in dirhams, using a rate you apply consistently. Many templates show both: the line total in the invoice currency and the VAT in AED, with the exchange rate stated.
Discounts and zero-rated lines
- Show the discount against the line it applies to, so the taxable amount is clear.
- Mark zero-rated, exempt and out-of-scope lines separately; see zero-rated, exempt and out-of-scope VAT.
- If the reverse charge applies, add a clear note; see reverse charge.
Language
Many UAE businesses issue invoices in English or in English and Arabic. We have not found a rule in the secondary sources we reviewed that stops an English or bilingual invoice being accepted in practice. Language is a point worth confirming against the current Executive Regulation and FTA guidance for your sector, particularly if you supply government entities.
Do you need a second template?
Retail businesses often keep a short template for sales to unregistered customers. See simplified tax invoice for when it can be used.
Mistakes that fail a review
- Missing TRN or a TRN with a typo.
- VAT shown only in a foreign currency.
- Gaps or duplicates in numbering.
- Invoices edited after issue instead of corrected by credit note.
- No clear date of supply where it differs from the invoice date.
Next step
If you are about to move from Excel to a system, plan the template with your accountant first. Our accounting team can set up numbering rules and check a sample of invoices against the VAT requirements.
A sample line layout
| Description | Qty | Unit price | Discount | Taxable | VAT rate | VAT |
|---|---|---|---|---|---|---|
| Consulting, March | 1 | 10,000.00 | 0.00 | 10,000.00 | 5% | 500.00 |
| Export documentation | 1 | 2,000.00 | 0.00 | 2,000.00 | 0% | 0.00 |
Total excluding VAT: 12,000.00. Total VAT: 500.00. Total payable: 12,500.00. Keep each line self-explanatory, so a reader can follow how the tax was worked out.
Notes and references
- Reference the purchase order number if the customer requires it.
- Add payment terms and bank details in the footer.
- Mention the original invoice number on any credit note.
Frequently asked questions
At minimum the words Tax Invoice, a unique invoice number, date, supplier and customer details, a description of the supply, VAT rate and amount, and the total. Check the full list in the Executive Regulation.
Commentary on the regulation lists a sequential or unique number among the particulars of a full tax invoice. A running sequence managed by your system is the safest way to meet it.
Yes, for low volumes. Use locked formulas and a log of numbers issued. As volumes grow or e-invoicing applies, use a system that numbers invoices automatically.
State the VAT amount in AED, using the exchange rate you apply consistently, alongside the invoice currency.
The sources we reviewed do not point to a rule that blocks English or bilingual invoices in practice. Confirm the current wording of the regulation and any sector guidance if you supply government bodies.
