NAQIXUAE VAT 201 return: how to prepare it from your ledger
The VAT 201 return is a summary of your books for one tax period. Every box should trace back to invoices, credit notes, supplier bills and expenses you can open and check. Here is how to prepare the return from the ledger and review it before anyone signs in to EmaraTax.
What the VAT 201 return asks for
VAT-registered businesses in the UAE file the VAT 201 return for each tax period the Federal Tax Authority (FTA) assigns them, usually a quarter, through the EmaraTax portal. The return is short, but each line summarises a lot of documents. In broad terms it is built like this:
| Boxes | What they hold |
|---|---|
| 1a to 1g | Standard-rated supplies and the VAT on them, split by emirate |
| 2 | Tax refunds provided to tourists under the tourist refund scheme |
| 3 | Supplies subject to the reverse charge (output tax you self-account) |
| 4 and 5 | Zero-rated supplies and exempt supplies |
| 6 and 7 | Goods imported into the UAE and adjustments to those imports |
| 8 | Totals of the output side |
| 9 and 10 | Standard-rated expenses and supplies subject to the reverse charge (input side) |
| 11 to 14 | Input totals, total tax due, recoverable tax and the payable or refundable position |
The FTA's own VAT returns user guide is the reference for what belongs in each box. Treat the summary above as orientation and confirm the details, especially for imports, designated zones and reverse charge, with your tax adviser.
Why prepare it from the ledger
Many small businesses still build the return in a spreadsheet: export sales, export purchases, add up the VAT columns and type the totals into the portal. It works until somebody asks why box 9 is higher than last quarter, or which invoices make up box 1b. A spreadsheet copied out of the books has already lost the link back to the documents.
Preparing the return from the ledger keeps that link. The same invoices that post to your output VAT account produce box 1, the same bills that post to input VAT produce box 9, and a correction made in the books changes the return the next time you open it. When the figures disagree with the VAT accounts, that disagreement is itself useful: it tells you there is a document to investigate before you file.
Seven steps to a return you can defend
1. Fix the tax period on your company calendar
Use the period the FTA assigned to you, including staggered quarters that do not start in January. Read dates in the company's own time zone, so that an invoice raised late on the last evening of the quarter lands in the right period.
2. Count only real tax documents
Final invoices and credit notes belong on the return. Drafts, quotations, proforma invoices and sales orders do not, and neither do cancelled invoices. On the purchase side, count bills for goods and services you actually received, plus expenses, and leave out purchase orders that were never billed.
3. Give every branch an emirate
Boxes 1a to 1g split standard-rated supplies by emirate. If you trade from Dubai and Sharjah, each branch's sales must carry the right emirate. A branch without one is a gap you should close before filing, not a figure to guess.
4. Check the treatment of each supply
Standard-rated, zero-rated, exempt and out of scope supplies go to different places, or nowhere. Exports, international transport and certain education and healthcare supplies may be zero-rated; some financial services and residential property supplies may be exempt. The treatment should be decided when the invoice is raised, not reconstructed at quarter end.
5. Review reverse charge and imports
Services bought from overseas suppliers with no VAT charged, and goods imported through UAE Customs, create output tax you account for yourself and, where eligible, matching input tax. Our reverse charge checklist covers the review in more detail.
6. Separate recoverable from blocked input tax
Not all VAT you pay is recoverable. Certain expenses, such as some entertainment and personal-use costs, are blocked. Mark them when the expense is entered so they stay out of box 9 instead of being removed by hand at the end of the quarter.
7. Tie the return to the ledger
Compare the output and input VAT on the return with the balances on your VAT accounts for the same period. Differences are usually timing, a document posted to the wrong account, or a manual journal that moved VAT without a document behind it. Explain each one.
Common review points before filing
- Foreign-currency invoices. A sale invoiced in US dollars or euros must appear on the return in dirhams. Check the rate used and that it matches the rate on the invoice.
- Credit notes in the right period. A credit note reduces the period in which it is issued, which is not always the period of the original invoice.
- Customer overpayments. A credit created because a customer paid too much is not a reduction of any supply and should not reduce box 1.
- Documents that are not on the return. Ask for the list of documents that were left out and why: drafts, out of scope items or bills with no VAT. That list is often where errors hide.
- Audit evidence. The FTA can ask for an FTA Audit File (FAF). If your system can produce one for the same period, check that its totals agree with the return.
How NAQIX prepares the VAT 201 return
In NAQIX the VAT 201 report is built from the same posted documents as your ledger, for one company at a time. You choose a quarter, a month or custom dates, and staggered quarters are supported. The report shows boxes 1a to 14 with the amount, the VAT and any adjustment, and you can select a box to list the documents behind it. A note such as "N documents are not on the return" links to the documents that were left out, with the reason.
- Each branch takes its emirate from its address, or from a value you set. Supplies with no emirate appear in a separate line with a warning, so you can fix them before filing.
- Invoices in other currencies are converted to the company's base currency at the rate saved on the invoice.
- The reverse-charge register lists imports and reverse-charge bills, with a treatment you can change per bill. Changes are refused once the period is closed.
- The FTA Audit File page shows supply, purchase and ledger totals with a check that each ties to the VAT 201 return, and downloads the file as CSV.
- Box 2 stays at zero, because NAQIX does not operate the tourist refund scheme.
NAQIX prepares these figures for review. It does not file the return; you or your tax agent submit it in EmaraTax after checking it. The Tax & compliance page lists the UAE features, the Accounting & reports page covers the ledger behind them, and the NAQIX page for the UAE describes the local setup.
Before you file
Share the return, the documents behind any unusual box and the list of excluded documents with your accountant. Agree who prepares the return and who reviews it, and close the period in your books once it is filed so the figures cannot change underneath you. Keep the records for as long as the law requires, and confirm deadlines and penalties for your tax period with your tax adviser.