YuVerse at Global Fintech Fest 2026View event
Talk to us
BlogBankingCompetitor ComparisonYusight

VAT Returns vs Bank Credits: Reconciling UAE Borrower Turnover

Reconcile VAT 201 declared supplies to bank statement credits for a UAE borrower. See the legitimate differences, a worked AED bridge

YT

YuVerse Team

Published September 5, 2026 · Updated September 13, 2026 · 11 min read

VAT Returns vs Bank Credits: Reconciling UAE Borrower Turnover

VAT 201 declared supplies and bank statement credits never match, and they are not supposed to. One measures invoiced supplies at the tax point; the other measures cash arriving, including money that is not revenue at all. Bridge them properly and a clean UAE borrower lands inside about 2%. Skip the bridge and you will manufacture a gap that does not exist.


Key facts

  • YuSight cites 100% of the figures it produces, each traceable in one click to the source document and page — so the bridge below is checkable line by line instead of being a spreadsheet nobody can audit.
  • VAT supplies are dated to the tax point, not to payment. Federal Decree-Law No. 8 of 2017 fixes the date of supply as "the earlier date of any of the following," running through transfer of goods, availability, completion of service, payment and invoice issuance (Article 25) — and requires a tax invoice "within (14) days as of the date of the supply" (Article 67) (Federal Decree-Law No. 8 of 2017 on VAT). Cash can arrive ninety days later.
  • Registration starts at AED 375,000 of taxable supplies, so almost every borrower worth underwriting files a VAT 201 (Cabinet Decision No. 52 of 2017, the VAT Executive Regulation, as published by the Ministry of Finance).
  • Audited accounts often will not settle the argument. They are compulsory for corporate tax purposes only above "AED 50,000,000 … during the relevant Tax Period," plus for Qualifying Free Zone Persons (UAE Ministry of Finance, *Ministerial Decision No. 84 of 2025*). For most UAE SMEs this reconciliation is the turnover verification.
  • The Central Bank expects you to do the work. Licensed institutions "must collect comprehensive financial information and cash flow projections from their Obligors" and must not decide "mostly based on subjective information" (CBUAE Rulebook, *Credit Risk Management Standards*).

What is each document actually measuring?

 

VAT 201 declared supplies

Bank statement credits

Unit of measurement

Value of supplies made, excluding VAT

Cash received, including VAT

Timing basis

Tax point — earlier of delivery, invoice or payment

Value date of the credit

Includes non-revenue items?

No. Boxes 3, 6 and 7 are purchases, not sales

Yes, extensively — loans, transfers, refunds, capital

Excludes revenue items?

Yes — out-of-scope and designated-zone supplies

Yes — anything settled in cash, by offset or by barter

Who prepares it

The borrower, filed to the Federal Tax Authority

The bank, generated by its core system

Cost of misstating it

5% of every fictitious standard-rated dirham, plus penalties

Zero, if the statement is genuine — and the tampering risk if it is not

Best used for

Sizing turnover and dating it to a period

Testing whether the turnover converted to cash

The two documents are strong in exactly the places the other is weak. That is why the comparison works, and why either one alone is a poor turnover test. If you have not read the return itself box by box first, start with the VAT 201 box-by-box guide — this page assumes you already know that turnover is Boxes 1 + 4 + 5 and never Box 1 alone.

Why do the two legitimately differ?

Seven reasons, in rough order of how much money they move.

  1. VAT itself. Declared supplies are net of VAT; bank credits are gross. On a domestic standard-rated sale the credit is 105% of the declared supply. Ignore this and a fully domestic borrower looks 5% "over-banked".
  2. Receivables timing. A tax point in December collects in February. Opening and closing receivables move the whole reconciliation, and for a borrower on 75 days' DSO they move it a lot.
  3. Zero-rated exports. Exports outside the GCC implementing states sit in Box 4 at 0%, so the credit equals the declared supply exactly — no 5% uplift. A heavy exporter's blended uplift is far below 5%, and applying a flat 5% to the whole book overstates expected credits.
  4. Non-revenue inflows. Facility drawdowns, shareholder loans, FTA refunds, insurance settlements, asset sale proceeds, returned-cheque reversals. Every one of these is a credit and none is turnover.
  5. Inter-company and inter-account transfers. A borrower running three accounts across two banks can double- or triple-count the same dirham. Net them before anything else — and note that a transfer from a sister company may be a genuine intercompany sale, which is a supply and should be in the return.
  6. Cash trading. Cash taken over the counter is a supply the moment it is made, whether or not it reaches a bank. UAE retail, foodstuff, spare parts and general trading businesses routinely pay suppliers or petty expenses directly from till cash. Those sales are in the VAT return and never in the credits.
  7. Settlement by offset. Where a borrower buys from and sells to the same counterparty and nets, the sale is a supply and the cash never moves.

Worked bridge: Noor Al Sahra Foodstuff Trading LLC

👤
Borrower: Dubai mainland LLC, foodstuff wholesale, roughly a third re-exported to Oman and East Africa. Single TRN, quarterly filer. FY2025. Two current accounts across two banks.

Step 1 — what the returns declare

Box

FY2025 (AED)

1 — standard rated supplies, Dubai

31,200,000

4 — zero rated supplies (exports)

16,400,000

5 — exempt supplies

0

Declared supplies (1 + 4 + 5)

47,600,000

Step 2 — convert declared supplies into expected cash from customers

Line

AED

Declared supplies per VAT 201

47,600,000

Add: VAT charged to customers on standard-rated supplies (31,200,000 × 5%)

1,560,000

Gross invoiced value including VAT

49,160,000

Add: opening trade receivables at 1 Jan 2025, collected during the year

7,420,000

Less: closing trade receivables at 31 Dec 2025, not yet collected

(8,960,000)

Less: credit notes and returns settled by offset, not by cash

(640,000)

Less: cash takings paid straight to suppliers and never banked

(1,180,000)

Expected operating credits into the bank accounts

45,800,000

Note the uplift. Applying 5% to the whole AED 47.6m would have added 2,380,000. The correct figure is 1,560,000, because AED 16.4m of exports carry no VAT. That single distinction is worth AED 820,000 of phantom variance.

Step 3 — strip the bank statements back to operating credits

Line

AED

Gross credits, both accounts, twelve months

54,150,000

Less: transfers between the company's own two accounts

(3,850,000)

Less: overdraft and invoice-discounting drawdowns

(2,900,000)

Less: shareholder loan injected in March 2025

(1,500,000)

Less: VAT refund received from the FTA

(310,000)

Less: insurance claim settlement on damaged stock

(185,000)

Less: re-credit of a cheque debited and then reversed

(95,000)

Operating credits from customers

45,310,000

Step 4 — the variance

Expected 45,800,000 − actual 45,310,000 = AED 490,000 490,000 ÷ 45,800,000 = 1.07%

A 1.07% residual on AED 45.8m is a clean reconciliation. What made it clean was the four adjustments on the expected side and the six on the actual side — not the borrower's honesty.

Now look at what the lazy version produces. Declared supplies of 47,600,000 against gross credits of 54,150,000 is a AED 6,550,000 gap, 13.8% of turnover, and it points the wrong way — it suggests undeclared sales. In fact the borrower under-banked its declared supplies by AED 490,000. An analyst who takes the raw comparison to committee is arguing the opposite of the truth.

What variance should you accept?

There is no published tolerance, so set your own and apply it consistently. A workable frame:

Residual after bridging

Read

Under 2%

Clean. Note the bridge in the memo and move on

2% to 5%

Explainable, but explain it. Usually one unmodelled item — a large offset, a designated-zone sale, an unbanked cash pocket

5% to 10%

Do not proceed on management's explanation alone. Ask for the sales ledger and test a month

Over 10%

Either the records are wrong or the turnover is. Stop and reconcile at transaction level

These bands are a practitioner convention, not a CBUAE or FTA standard. Calibrate them against your own portfolio before adopting them as policy.

Two conditions on using any tolerance at all:

  • Reconcile the same period. Four VAT quarters against twelve statement months, aligned to the same dates. A quarter's misalignment on a seasonal borrower produces a 20% variance out of nothing.
  • Use every account. The most common cause of an unexplainable gap is a bank the borrower did not mention. Ask for a list of all bank relationships and match it against the salary, VAT and utility debits you can see.

Which "explanations" are not explanations?

Four answers a relationship manager will bring back, and what to do with each.

  • "It's a cash business." Cash trading explains credits being lower than declared supplies. It cannot explain credits being higher. If the gap runs the other way, cash is not the answer.
  • "Those are customer advances." An advance received is a payment, and payment is one of the triggers for the date of supply under Article 25. If it was received and it relates to a taxable supply, it should generally be in the return. Ask which period.
  • "The other company's sales come through this account." Then either there is an undisclosed related entity in the group — see the UAE SME entity map — or the borrower is invoicing through a second TRN. Both change the file.
  • "The accountant filed it late." Possibly true, and it is its own finding. Unpaid VAT attracts penalties and the tax authority ranks ahead of you in practice, so treat a VAT arrear as undisclosed senior debt.

Run this reconciliation alongside the bureau-to-bank-statement comparison and the AECB facility read. Turnover, debt service and repayment behaviour tested against three independent record sets is about as much assurance as a UAE SME file will give you.

Frequently asked questions

How do you reconcile VAT turnover to bank credits?

Bridge from both ends to a common figure. From the VAT side, add the VAT actually charged, add opening receivables collected, deduct closing receivables, and deduct anything settled in cash or by offset. From the bank side, strip out inter-account transfers, facility drawdowns, shareholder money, refunds and reversals. Compare what is left.

What variance between VAT and banking is acceptable?

Under 2% after a proper bridge is clean, and 2% to 5% is normally one unmodelled item. Above 10% you should stop and reconcile at transaction level. There is no official UAE tolerance, so calibrate the bands against your own portfolio and apply them the same way to every file.

Does cash trading explain VAT and banking gaps?

Only in one direction. Unbanked cash makes bank credits lower than declared supplies, which is a normal pattern for foodstuff, spare parts and retail borrowers. If credits are higher than declared supplies, cash trading is not the explanation and something else is inflating the account.

Should you add VAT to declared supplies before comparing?

Yes, but only on the standard-rated portion. Box 1 attracts 5%; zero-rated exports in Box 4 attract nothing. Applying a flat 5% to total declared supplies overstates expected credits for any exporter — in the worked example above, by AED 820,000.

What if the borrower banks with more than one bank?

Then you need statements from all of them, or the reconciliation is meaningless. Ask for a list of every bank relationship, then test it: salary runs, VAT payments and utility debits leaving one account for a facility held elsewhere will expose an account the borrower did not declare.

Do customer advances belong in the VAT return?

Generally yes. Receipt of payment is one of the triggers for the date of supply under Article 25 of the VAT Decree-Law, so an advance against a taxable supply usually creates a tax point in the period it is received. If a borrower says a large credit was "just an advance," ask which return it appears in.

Can this reconciliation replace audited financial statements?

For most UAE SMEs it has to. Audited accounts are compulsory for corporate tax purposes only above AED 50 million of revenue, and below that many borrowers present unaudited management figures. VAT returns against bank statements is the strongest independent turnover test available.

What does a persistent negative residual mean?

That the business is declaring more supplies than it is collecting, year after year. Check receivables first — a rising unbanked balance is a working-capital problem. If receivables are stable, the borrower may be declaring supplies it has not made, which is unusual because it costs 5% in cash, or collecting somewhere you cannot see.

Key takeaways

  1. Bridge before you compare. Raw declared supplies against raw credits produced a AED 6.55 million "gap" in the worked example. The real residual was AED 490,000.
  2. Add VAT only where VAT was charged. Zero-rated exports carry no uplift. Getting this wrong created AED 820,000 of phantom variance on a AED 47.6 million book.
  3. Strip non-revenue credits first. Transfers, drawdowns, shareholder money, refunds and reversals accounted for AED 8.84 million of gross credits in this file.
  4. Get every account. An undisclosed bank is the most common cause of a gap nobody can explain.
  5. Watch the direction of the gap. Cash trading only explains credits falling short. It never explains credits running ahead.

YuSight's Bank Statement Analyzer classifies every credit on a multi-bank, multi-currency statement set, separates operating collections from transfers, drawdowns and capital, and reconciles the result against the VAT 201 returns in the same file — with 100% of figures cited back to the page they came from. The same standardised figures then flow into financial spreading and into the credit memo without being typed a second time.

Run one borrower through the analyzer — book a live demo.

Stay Updated

Get the latest AI insights delivered to your inbox.

Product Brochure

A complete overview of YuVerse products, use cases, and capabilities.

Topics

VAT vs bank statement reconciliation UAEUAE turnover verificationVAT return analysisbank statement analysis UAE lending