Process map · Trading
VAT return in a trading company
A trading company's return is shaped by where the goods come from and where they go. Imports can bring the reverse charge, exports can be zero rated when the conditions are met, sales through designated zones can follow special rules, and every customer return changes the figures. This map follows that version. The treatment of each kind of movement is for your tax agent to confirm.
The full map is free
16 steps, 2 decisions, 2 roads into other maps. Sign in once to open every approval and branch, larger ERPNext screens and a printable sheet.
Select a step to see who does it, the document and the ERPNext screen.
Step by step
-
Each sales invoice takes its tax from the template: 5% on standard-rated lines, nothing on lines marked zero rated or exempt. The emirate of the sale is recorded on the invoice, because the UAE VAT 201 report adds up standard-rated sales emirate by emirate.
- Who does it
- Invoicing clerk
- Document that comes out
- Sales Invoice
ERPNext then does this by itself
- Tax is worked out line by line and posted to the output tax account
- The invoice prints as a tax invoice with both TRNs
- The emirate is kept on the invoice for the return
Without an ERP
Invoices are made in a word processor. One goes out with no TRN, another with VAT added to a zero-rated sale, and the customer's accountant sends both back.
ERPNext 16 · Sales Invoice (UAE VAT) -
Local suppliers' tax invoices are entered with their TRN, the VAT charged and the VAT that can be recovered. Invoices from suppliers abroad are entered in the supplier's currency, and marked as reverse charge where your tax agent confirms it applies. Freight and clearing invoices from local agents carry VAT of their own and are entered like any local purchase.
- Who does it
- Accounts payable clerk
- Document that comes out
- Purchase Invoice
ERPNext then does this by itself
- Input tax is posted to its own account, apart from the cost
- A repeated supplier invoice number can be set up to be refused
- The UAE VAT 201 report counts only purchase invoices with the recoverable amount filled in
Without an ERP
The import invoice, the customs declaration and the clearing agent's bill sit in three different files. The VAT on one of them is always missed.
ERPNext 16 · Purchase Invoice -
The registers are run for the period and read for missing TRNs, lines with no tax where tax was expected and invoices in the wrong period. Export invoices are checked for their evidence. Sales and purchases that passed through a designated zone are listed apart for the tax agent to confirm.
- Who does it
- Accountant
- Document that comes out
- Sales Register and Purchase Register
ERPNext then does this by itself
- Each tax account has its own column, so an odd rate stands out
- Every line opens the invoice behind it
Without an ERP
Zero-rated sales are one total in a spreadsheet. Nobody can say which of them are exports with papers and which are simply invoices where someone left the tax off.
ERPNext 16 · Sales Register report -
The UAE VAT 201 report is run for the tax period. It gives the main lines of the return: standard-rated sales for each emirate, zero-rated and exempt sales, reverse charge, and standard-rated expenses with the tax that can be recovered.
- Who does it
- Accountant
- Document that comes out
- UAE VAT 201 report
ERPNext then does this by itself
- Sales are grouped by the emirate saved on each invoice
- Zero-rated and exempt lines go to their own boxes
- Only submitted invoices inside the period are counted
Without an ERP
Splitting a quarter's sales by emirate means sorting hundreds of invoices by hand on the last evening before the deadline.
ERPNext 16 · UAE VAT 201 report -
The return is filed on the Federal Tax Authority's online portal, by the company or by its tax agent. This step is outside ERPNext: the figures from the UAE VAT 201 report are entered on the portal and checked once more before submitting. Most businesses file each quarter, and the return is due 28 days after the period ends.
- Who does it
- Finance manager or tax agent
- Document that comes out
- Filed VAT return
ERPNext then does this by itself
- The report can be exported or printed as the working paper for the filing
- Closing the period in ERPNext stops later changes to the invoices behind the return
Without an ERP
The figures are finished on the last day. One typing mistake on the portal means a correction afterwards, and there is no working paper showing where the numbers came from.
-
A Journal Entry moves the period's output tax and input tax into one VAT payable balance, which equals the amount on the return. The payment to the Authority is then recorded from the bank against that balance. When input tax is higher than output tax, the balance is in your favour, and your tax agent confirms how it is claimed.
- Who does it
- Accountant
- Document that comes out
- Journal Entry
ERPNext then does this by itself
- The VAT accounts start the next period from nil
- The payable clears when the bank payment is recorded
Without an ERP
The payment to the Authority is booked as an expense. The VAT accounts keep growing year after year, and nobody can tell what is really owed.
The Full map adds 10 more steps: the approvals, checks and branches between these.
In one quarter a distributor imports four containers, sells in three emirates, exports two orders to Oman and takes back one damaged pallet. Each of those lands in a different box of the return, and each is already marked on its own invoice.
What changes in a trading company. The same process, the steps this industry really uses.
-
Imports are checked against customs papers
Purchases from suppliers abroad are compared with the customs paperwork for the period, and marked as reverse charge where your tax agent confirms it applies.
-
Exports need their evidence
An export invoice can be zero rated when the conditions are met, and the shipping and customs documents that prove the goods left are attached to it on the day, not searched for during an audit.
-
Returns reduce output tax
Goods taken back are credited with a credit note linked to the original invoice, so the sale and its VAT are reversed together in the period of the credit note.
-
Zone movements are flagged
Sales and purchases that pass through a designated zone are listed apart at period end, so the tax agent can confirm their treatment before the report is run.
Where this map leads
Processes feed each other. Follow the work into the next map.
Free tool
Build your company's map
Pick your industry and the processes you run. Get one printable document with every map and step, ready to show your team or your ERP partner.
- VAT return
- Order to cash
- Purchase to pay
- Inventory management
- Month-end close
Questions about vAT return
Ask us anything elseHow is VAT on imported goods recorded in ERPNext?
Are exports zero rated for UAE VAT?
How does ERPNext split our sales by emirate for the return?
See this process run on your own data
A 45-minute ERPNext demo that follows this map with an example from your business.