Skip to main content
J
Jason1985
Known Participant
May 25, 2023
Question

Back calculating UK VAT - Adobe Pro DC

  • May 25, 2023
  • 3 replies
  • 2476 views

Hi,

 

I am creating a PDF mileage expenses form, and as HMRC's approved mileage rates already include VAT, I need to back calculate this to get it to display VAT reclaimable in a dedicated field, can anyone help?

 

I know the calculation its just working it out in Adobe Pro without a division option:

 

As an example:

Mileage rate: 16p per mile

​The 16p is VAT inclusive so you need to work backwards to find out the VAT claimable. 

So 16p represents 120% (100% plus 20% VAT).  So the VAT element is 16/120*20 = 2.67p.  So for every business mile you claim 16p for, you can reclaim 2.67p VAT.

 

Thanks in advance for any support with this.

3 replies

A
amelia_9925
Participant
October 14, 2025

Add your formula under Simplified field notation in the VAT claim field.  It will calculate automatically from the other fields.

J
Jason1985Author
Known Participant
June 2, 2023

Anyone support with this at all?

Thanks

A
Asim123
Inspiring
June 2, 2023

If you can't explain better what you need, then share your file, so we can see what is going on.

J
Jason1985Author
Known Participant
June 2, 2023

The reason for no replies/support was not due to a lack of comprehension around my request, but just simply that no body else responded.

 

I have attached the file FYI.

Nesa Nurani
Community Expert
Nesa NuraniCommunity Expert
Community Expert
May 25, 2023

See if this works for you:

var rate = Number(this.getField("Mileage rate").valueAsString);

if(rate)
event.value = rate/120*20;
else
event.value = "";

 

J
Jason1985Author
Known Participant
May 26, 2023

Hi,

 

Thanks for the reply.

 

But forgive me I am pretty new to Adobe, which calculation field do I put this text in? e.g. Simplified field notation etc

 

Also, for info here is my actual field names from the document

Mileage rate = Vehicle type

Total Miles Travelled = Miles travelled 1.0

VAT reclaimable = VAT claim   (Nb. this is where I want this calculation output to be)

 

Thanks for your support!

Nesa Nurani
Community Expert
Nesa NuraniCommunity Expert
Community Expert
May 26, 2023

Script should go into 'Custom calculation script' (it's under simplified field notation) of "VAT Claim" field.

In script, change "Mileage rate" field name to the name of the field where you input 16 (I guess it's "Miles travelled 1.0").

Is "Vehicle type" field included in calculation?

If yes, please explain what and how should be calculated.

 

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices