Maaliya app is now live, with a free plan and no card needed. Start free or book a demo.
Article

Why Isn't My VAT Calculating in Xero? UAE Troubleshooting Guide

Updated 14 Nov 20268 min readLina Mansouri
Why isn’t my VAT calculating in Xero? UAE troubleshooting guide cover
Quick diagnostic: check these five things first
  • Open the invoice, bill or transaction and check the tax rate on every line. A line set to zero-rated, exempt or no-tax should not calculate 5% VAT.
  • Confirm the Xero organisation is configured for UAE VAT and that the business is actually VAT registered for the period in question. Software settings should reflect the business's real FTA position, not create one.
  • Check the transaction date. A transaction dated outside the relevant VAT registration or reporting period may not appear where you expect in the VAT report.
  • Check whether the document is tax inclusive or tax exclusive. On AED 1,000 exclusive of VAT, 5% VAT is AED 50 and the gross total is AED 1,050; if AED 1,000 is tax inclusive, the VAT component is AED 47.62 and the net amount is AED 952.38.
  • For imported bank transactions, CSV uploads and bank-feed lines, remember that the bank line itself does not prove the VAT treatment. It still needs the correct account and tax rate when reconciled or created.

Overview

If VAT is not calculating in Xero, the problem is usually not the arithmetic. In a UAE organisation, check the tax rate on the transaction, the organisation's VAT setup, the transaction date, whether amounts are tax inclusive or exclusive, and whether imported or bank-feed transactions have been coded correctly. A 0% or exempt transaction can legitimately show no VAT, while a standard-rated UAE supply will generally carry 5% VAT.

In this guide:

  • The wrong Xero tax rate is selected
  • Your organisation's VAT status or setup is wrong
  • The transaction date is outside the period you're checking
  • Tax-inclusive and tax-exclusive pricing is being confused
  • A contact or repeating transaction is carrying an old default
  • Imported transactions haven't been given VAT logic yet
  • The transaction is correctly zero-rated, exempt or outside scope
  • What about reverse charge transactions?
  • How to troubleshoot without damaging your VAT records
  • Frequently Asked Questions
  • Sources
Still not sure what's wrong?

If you've checked the basics and VAT still isn't behaving as expected, a quick call with our team can help you pinpoint the issue before it affects your next filing.

Book a free consultation today!

The wrong Xero tax rate is selected

This is the most common place to start. UAE VAT does not mean every transaction should have 5% added. The Federal Tax Authority distinguishes standard-rated, zero-rated and exempt supplies, and transactions outside the scope of UAE VAT also need to be treated separately. A zero-rated supply is still a taxable supply, but VAT is charged at 0%; an exempt supply is not a taxable supply.

The FTA explains that taxable supplies may be taxed at 5% or 0%. Review the FTA definition of a taxable supply before changing a Xero tax rate simply because the VAT amount is zero. If you're still unsure which rate applies to a given transaction, our Xero UAE Tax Rates Explained guide walks through each rate in more detail.

If the tax treatment is wrong, correct the underlying transaction only after confirming the legal VAT treatment. Do not force 5% just to make the VAT report show a number.

Your organisation's VAT status or setup is wrong

If the business is not set up in Xero as expected for UAE VAT, the available rates and reporting behaviour may not match what you are trying to do. Check the organisation settings and VAT configuration before troubleshooting individual invoices. Our Setting Up Xero for UAE VAT: Step-by-Step Guide walks through that configuration from scratch.

For UAE businesses, VAT registration is mandatory when taxable supplies and imports exceed AED 375,000 under the applicable registration test; voluntary registration can be available from AED 187,500. Those thresholds determine the FTA registration obligation, not whether you should manually switch VAT on inside accounting software.

Xero now provides a UAE VAT workflow that maps accounting data to VAT201 fields and can generate an FTA Audit File. See Xero's UAE VAT information for the current product workflow.

The transaction date is outside the period you're checking

If VAT appears on the invoice but not in the VAT report you are reviewing, inspect the transaction date and the report period. Also check whether the transaction was edited, voided or posted into a different period. The tax point for UAE VAT can depend on the facts of the supply, so changing a date merely to move VAT between periods is not an appropriate fix.

Tax-inclusive and tax-exclusive pricing is being confused

Xero can calculate VAT differently depending on whether the entered amount includes tax. For example, AED 2,000 entered exclusive of 5% VAT produces AED 100 VAT and a total of AED 2,100. AED 2,000 entered inclusive of 5% VAT contains approximately AED 95.24 VAT. If the displayed VAT looks wrong, first confirm what the AED amount is supposed to represent.

A contact or repeating transaction is carrying an old default

Defaults can make the same error recur. If invoices for one customer or bills from one supplier repeatedly use an unexpected tax rate, inspect the contact, item, account and repeating-template defaults rather than correcting each transaction individually. The correct VAT treatment still depends on the underlying supply.

Imported transactions haven't been given VAT logic yet

A bank statement import gives Xero the money movement; it does not automatically turn a payment into a compliant VAT entry. When reconciling imported lines, verify the supplier or customer, account, tax rate and source document. The same applies when transactions are migrated from Excel or another accounting system.

A practical example: a UAE company imports a bank line showing AED 1,050 paid to a local supplier. That amount alone does not prove AED 50 is recoverable input VAT. The company should check the supplier's tax invoice and the conditions for input-tax recovery before coding the payment.

The transaction is correctly zero-rated, exempt or outside scope

No VAT amount does not automatically mean Xero is broken. A valid zero-rated supply carries a 0% rate. Exempt supplies do not carry output VAT, and some transactions can also fall outside the scope of UAE VAT. The accounting code should follow the actual transaction, not the VAT result you expected to see. If you're unsure which category applies, our Zero-Rated vs Exempt in Xero UAE guide breaks down the distinction.

What about reverse charge transactions?

Imported services and other reverse-charge situations require special care. Under FTA guidance, a UAE VAT registrant receiving certain services from outside the UAE may need to account for output tax under the reverse-charge mechanism, subject to the applicable rules and exceptions. Do not treat an imported service as an ordinary local 5% supplier bill merely to make VAT appear. See our Reverse Charge VAT in Xero UAE guide for a step-by-step walkthrough.

How to troubleshoot without damaging your VAT records

Work through issues in this order: confirm the real-world VAT treatment, inspect the source invoice or contract, check the Xero tax rate, check the inclusive or exclusive setting, verify the date and VAT period, then review the VAT report. If several transactions are wrong for the same reason, identify the default or import rule causing the issue before bulk-editing anything. Our Common Xero VAT Mistakes in the UAE guide covers the errors we see most often.

Before changing historic transactions that have already been included in a filed VAT return, consider whether the correction affects a previous tax period and whether an FTA correction or voluntary disclosure process may be relevant. The correct treatment depends on the nature and size of the error, so obtain professional advice where needed.

Frequently Asked Questions

Why is Xero showing 0 VAT on my invoice?

Check the tax rate on each line first. A zero-rated, exempt or no-tax treatment can legitimately produce no VAT. If the supply should be standard-rated in the UAE, investigate why the wrong tax rate or default was applied.

Why is VAT on an AED 1,000 invoice not AED 50?

If AED 1,000 is entered as tax inclusive, the VAT component at 5% is AED 47.62, not AED 50. AED 50 applies when AED 1,000 is the tax-exclusive amount.

Why is VAT missing from my Xero VAT report even though it appears on the invoice?

Check the transaction date, the report period, the transaction status and the VAT setup. A transaction can contain VAT and still sit outside the period you are reviewing.

Does importing a UAE bank statement calculate VAT automatically?

Not necessarily. A bank transaction records the cash movement only. The VAT treatment should be supported by the underlying transaction and source documentation, then coded correctly during reconciliation.

Should I change every transaction with no VAT to 5%?

No. UAE supplies can be standard-rated, zero-rated, exempt or outside scope depending on the facts. Forcing a 5% rate can create an incorrect VAT return.

Maaliya VAT Health Checker

If VAT in Xero is not behaving as expected, use Maaliya's VAT Health Checker to review your VAT setup and spot common configuration issues before your next return.

Check VAT Health Now

Sources

Federal Tax Authority, What Is a Taxable Supply? Last updated 16 May 2024. Accessed 25 September 2026.

Federal Tax Authority, Registration for VAT. Last updated 6 April 2026. Accessed 25 September 2026.

Federal Tax Authority, VAT Public Clarification VATP044: Concerned Services, Accounting for Output Tax, Issuing Tax Invoices, and Input Tax Recovery. 26 May 2025. Accessed 25 September 2026.

Xero, UAE VAT Returns | Xero's FTA-Accredited Software. Accessed 25 September 2026.

Lina Mansouri
Written by
Lina Mansouri
Corporate Services, Maaliya

Lina Mansouri is a Corporate Services specialist at Maaliya, where she helps UAE businesses with company incorporation, VAT and corporate tax registration, and liquidation. She writes Maaliya's guides to Xero, UAE VAT, bank reconciliation and eInvoicing, drawing on the questions UAE founders and finance teams bring to Maaliya every day.

Like what you read? Add Maaliya as a preferred source on Google.

Books that close themselves.
Built for the UAE.
Book a demo