Dubai & Sharjah, UAE +971 4 422 1190 enquire@aonebiz.com Mon–Fri 09:00–18:00

UAE Tax Invoice Template: Fields, Numbering and Language

How to build a tax invoice template that holds up in an audit: the fields, a numbering system that does not break, and how to handle currency, discounts and language.

Plain-language VAT guidanceChecked against the VAT law text8 min readUpdated 20 October 2026

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

ZoneWhat to put there
HeaderThe words Tax Invoice, invoice number, issue date, date of supply if different
Supplier blockName, address, TRN
Customer blockName, address and TRN if registered
Line itemsDescription, quantity, unit price, discount, taxable amount, VAT rate and VAT amount
TotalsTotal excluding VAT, total VAT in AED, total payable
FooterPayment 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

  1. Create a locked invoice sheet with cells for the fields above and a separate sheet for customers.
  2. Use formulas for the taxable amount, VAT and totals so staff cannot override them by hand.
  3. Round VAT to two decimals at the line or invoice level, and use the same method every time.
  4. Protect the sheet and keep a log of invoices issued to prevent duplicates.
  5. 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

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

DescriptionQtyUnit priceDiscountTaxableVAT rateVAT
Consulting, March110,000.000.0010,000.005%500.00
Export documentation12,000.000.002,000.000%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.

Talk to us

Get a clear answer in one short call

Tell us your situation and we will say what applies, what does not and what to do next.

  • Scoped first we agree what is in and out before any work starts.
  • Named consultant one person owns your file from the first call.
  • Plain-language advice you get a clear answer, not a list of options.
  • Records kept tidy working papers you can hand to the FTA or an auditor.
Scroll to Top