Blog · VAT methods

Deductions before VAT or after VAT: why mixing them breaks your VAT return

There are two honest ways to work out VAT on a progress claim that takes off an advance and retention. A mix of the two gives a third set of figures that matches no certificate, and the damage shows up at the retention release, often long after the claim.

By , founder of Mizarah, who ran a UAE joinery workshop for 13 years · 7 minute read · Published · Last updated

The problem in one line

Take the advance off before VAT and the retention after it, and your claim matches no certificate, and when the retention comes back nobody can say whether its VAT was already declared.

I spent 13 years running a joinery workshop in the UAE. Our progress claims went out from an Excel sheet, and every so often the main contractor's QS sent one back with the VAT worked out differently from ours.

Nobody was being careless. There are two ways to do this sum, both of them consistent, and a claim sheet that has been copied forward month after month tends to pick up a bit of each. That third version is the one that causes trouble, and it rarely shows on the claim itself.

Two methods, and every deduction follows one

Deductions before VAT: take the advance, the retention and any other deduction off the work, then add 5% on what is left. Deductions after VAT: add 5% on the whole of the work first, then take every deduction off the total including VAT.

The part people skip is "every deduction". The advance recovery, the retention, earlier bills, a discount and a penalty you typed in yourself all follow the same method on the same invoice. You do not get to pick per line.

The two methods
one of them per invoice, never both
Before VATAfter VAT
OrderWork less deductions = net, then VAT on the netVAT on the work first, then deductions off the total including VAT
A % deduction% of the work before VAT% of the total including VAT
A fixed amountRead as an amount before VATRead as an amount including VAT
An earlier invoice deductedAt its net value (received 105, deduct 100)With its VAT (10 net deducted as 10.50)

The smallest example I know is a claim of 100 with a 30% advance and 10% retention. Before VAT: 100 less 30 less 10 is 60, plus 3 of VAT, so 63 to pay. After VAT: 100 plus 5 is 105, less 31.50 and 10.50, so 63 to pay.

Deductions before VAT
  1. Work certified100.00
  2. −Advance 30%30.00
  3. −Retention 10%10.00
  4. =Taxable amount60.00
  5. +VAT 5%3.00
  6. =Payable63.00
Deductions after VAT
  1. Work certified100.00
  2. +VAT 5%5.00
  3. =Including VAT105.00
  4. −Advance 30%31.50
  5. −Retention 10%10.50
  6. =Payable63.00
The same claim of 100 worked both ways. The order changes; the payable does not.

Same 63, but not the same VAT on the invoice. Before VAT the claim declares 3.00. After VAT it declares 3.50: 5.00 on the work, less the 1.50 already declared on the advance. The missing 0.50 is the retention's VAT, and the before-VAT method declares it later, at the release.

One contract, worked both ways

This is the contract we test Mizarah against: 1,000,000 before VAT, a 30% advance, 10% retention, and the work billed 30%, 40% and 30%.

Deductions before VAT
deductions first, then 5%
DocumentCalculationVAT declaredPayable
Advance tax invoice300,000 + VAT15,000.00315,000.00
Claim 1300,000 − 90,000 − 30,000 = 180,000, + VAT9,000.00189,000.00
Claim 2400,000 − 120,000 − 40,000 = 240,000, + VAT12,000.00252,000.00
Claim 3300,000 − 90,000 − 30,000 = 180,000, + VAT9,000.00189,000.00
Retention release100,000 + VAT5,000.00105,000.00
TotalNet 1,000,00050,000.001,050,000.00
Deductions after VAT
5% first, then the deductions
DocumentCalculationVAT declaredPayable
Advance tax invoice300,000 + VAT15,000.00315,000.00
Claim 1315,000 − 94,500 advance − 31,500 retention10,500.00189,000.00
Claim 2420,000 − 126,000 − 42,00014,000.00252,000.00
Claim 3315,000 − 94,500 − 31,50010,500.00189,000.00
Retention release105,000, VAT already declared0.00105,000.00
TotalNet 1,000,00050,000.001,050,000.00

After VAT, a claim declares the VAT on its work less the VAT already declared on the advance it takes back: on claim 1, 15,000 − 4,500 = 10,500.

Both methods end in the same place. The contract bills 1,000,000, declares 50,000 of VAT and collects 1,050,000. The advance account and the retention account both finish at zero, and a fourth claim has nothing left to bill. What moves is the retention's VAT: before VAT it waits for the release, after VAT it is declared on each claim.

Mizarah claim summary, deductions before VAT: total before VAT 300,000, less advance 90,000, less retention 30,000, taxable amount 180,000, VAT 9,000, total 189,000.
A 300,000 claim with a 30% advance and 10% retention, deductions before VAT: 189,000.00 to pay. Local test data, invented names.
Mizarah claim summary, deductions after VAT: total before VAT 300,000, VAT on the work billed 15,000, less VAT already declared on the advance 4,500, VAT payable on this invoice 10,500, total including VAT 315,000, less advance 94,500, less retention 31,500, total 189,000.
The same claim, deductions after VAT: VAT payable 10,500.00 and the same 189,000.00 to pay. Local test data, invented names.

Where they part: fixed amounts

With percentages the two payables match, as above. With fixed amounts they do not, and you should not try to force them to.

Say a claim of 1,000,000 recovers a fixed 300,000 of advance and holds a fixed 100,000 of retention. Before VAT, those two figures are amounts before VAT. After VAT, the same two typed numbers are amounts including VAT.

Fixed advance and retention
1,000,000 claim · 300,000 advance · 100,000 retention
LineBefore VATAfter VAT
Work certified1,000,000.001,000,000.00
VAT on the work—50,000.00
Less advance−300,000.00−300,000.00
Less retention−100,000.00−100,000.00
VAT on the net30,000.00—
Payable630,000.00650,000.00

The 20,000 gap is not an error. After VAT, the 300,000 you typed already contains 14,285.71 of VAT, so only 285,714.29 of advance comes off the work. The claim declares 35,714.29 of VAT: 50,000.00 on the work, less the 14,285.71 inside the advance. Before VAT it declares 30,000.00, 5% of the 600,000 left.

So when a main contractor tells you to "take 300,000 off", ask which method their certificate uses before you type it. The same number means a different deduction in each.

What a mix looks like, and where it breaks

The usual mix takes the advance off before VAT and leaves the retention inside the VAT base. It looks reasonable on a single claim. Here it is on claim 1 of the reference contract, next to the two honest methods:

Claim 1, three ways
300,000 certified · 30% advance · 10% retention
MethodVAT on the claimPayable
Before VAT9,000.00189,000.00
After VAT10,500.00189,000.00
Mixed: advance before, retention after (wrong)10,500.00190,500.00

190,500 matches neither method. Whichever one the main contractor certifies under, the certificate says 189,000 and your invoice says 190,500. The extra 1,500 is VAT on retention the client has not paid you, and will not pay you until the release.

You can see that one on the day. The bigger problem waits for the end of the job. Across the three claims the mix declares 35,000 of VAT, which already includes the retention's VAT, while the 100,000 of retention sits in your books at its value without VAT. Months or years later, someone has to raise the release, and both standard ways of doing it are wrong:

  • Raised the before-VAT way, the release is 100,000 plus 5,000 of VAT. The retention's VAT has now been declared twice, and the contract declares 55,000 in total: 5.5% of its value.
  • Raised the after-VAT way, the release asks for 105,000 with no VAT. That is 5,000 more than was ever held back.

The only right release for that contract is 100,000 with no VAT, which is a document neither method produces. By then the person raising it is often working from a sheet that does not say how the claims were done. So the claims look fine for the whole job, and the VAT return goes wrong in the period of the release.

Which method should you use?

Both are consistent. My own rule of thumb: use the method your contract and your main contractor's certificates already use, so your invoice and their certificate agree line by line, and confirm it with your tax agent. Then keep to it for every invoice on that contract.

Write down which method each contract uses, in the contract file and not only in the sheet. The release depends on it, and the release is the document most likely to be raised by someone who never saw the claims.

Printed English and Arabic tax invoice: two door lines billed at 35% and 30%, total before VAT 100,000, less advance payment 30% 30,000, less retention 10% 10,000, taxable amount 60,000, VAT 5% 3,000, total AED 63,000.
A printed progress claim in English and Arabic, deductions before VAT: 100,000.00, less 30,000.00 advance and 10,000.00 retention, VAT on the 60,000.00 left, 63,000.00 to pay. Local test data, invented names.

To see one of your own bills both ways before you decide, the free progress bill calculator works out a single claim under either method. The guide to VAT on progress claims has the same rules in short form.

HOW MIZARAH HANDLES ITTRUE OF THE PRODUCT TODAY

How Mizarah handles it.

In Mizarah the method is a company setting, Deductions and VAT, which is before VAT unless you change it. Each invoice records the method it was worked out under, and the claim editor has one choice for the whole invoice rather than a switch for each deduction. The advance, the retention, earlier bills, the discount and any deduction you add all follow it.

The tax invoice prints in the order the VAT was worked out. After VAT, its tax block shows the VAT on the work, less the VAT already declared on the advance tax invoice, then the VAT payable on this invoice: the figure that goes in your VAT return. When the retention comes back, the release follows the method each claim used, so it charges VAT on retention held before VAT and none on retention held after VAT. A claim that would bill past 100% of the contract is refused.

QUESTIONS5 ANSWERS

Common questions.

Do both methods declare the same VAT over a whole contract?
Yes. Across the advance, the claims and the retention release, both declare 5% of the contract value, each fil once: 50,000 on a 1,000,000 contract. What differs is which document declares the retention's VAT. Before VAT it is the release; after VAT it is the claims.
Why does my claim show a different payable from the main contractor's certificate?
Check three things. Which method each side used. Whether any deduction is a fixed amount, because a fixed figure is before VAT under one method and includes VAT under the other. And whether your sheet mixes the two, for example the advance before VAT and the retention after.
Does a discount follow the method too?
Yes. The discount, earlier bills, the advance, the retention and any deduction you name yourself all follow the invoice's one method.
What VAT goes in my return for a claim done after VAT?
The VAT on the claim's work, less the VAT already declared on the advance it takes back. On claim 1 of the 1,000,000 example that is 15,000 − 4,500 = 10,500.
Can different contracts use different methods?
Each invoice has one method, so yes, as long as each contract is consistent. Agree the method with the client and your tax agent, and record it on the contract, because the retention release depends on it.

Official sources

Read next on this site

Practical guidance, not tax advice. The figures are worked examples, not anyone’s real contract. Check how the rules apply to your own contracts with your tax agent.

TRY IT ON YOUR OWN CONTRACT14 DAYS FREE · NO CARD

Put one of your own claims through it.

Start the free 14-day trial at mizarah.com and bill a contract you already know the answer to. Or work one bill out first with the free progress bill calculator, either VAT method, no sign-up.