How to Calculate 20% VAT and Total in Adobe Acrobat PDF Forms
Question details
The user needs to set up a PDF form to automatically calculate a 20% Value Added Tax (VAT) from a base net amount, and then sum both values to generate a grand total.
- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Creating an interactive PDF invoice or billing form where tax amounts and totals need to dynamically update based on user input.
- Observed behavior
- The form requires a specific mathematical logic and a strict calculation order to ensure the VAT is generated before the final sum is processed.
Ensure your PDF form is open in Adobe Acrobat's 'Prepare Form' mode and that your text fields are clearly named (e.g., 'Total nett amount', 'VAT', and 'Grand Total').
Use Custom Calculation Script and Sum Function
Apply a short JavaScript snippet to the VAT field to calculate the 20% tax, and use Acrobat's built-in Sum calculation for the final total.
To achieve accurate automatic calculations in PDF forms, you need to use a custom calculation script for the percentage and a standard addition function for the total. The order in which Acrobat processes these fields is critical to avoiding calculation errors.
Right-click the VAT text field in Prepare Form mode and select 'Properties'. Navigate to the 'Calculate' tab.
Select 'Custom calculation script' and click the 'Edit' button. Enter the following code: event.value = Number(this.getField("Total nett amount").valueAsString) * 0.2; then click 'OK'.
Right-click your final total field and select 'Properties'. Go to the 'Calculate' tab, choose 'Value is the sum (+) of the following fields', and click 'Pick' to select both the 'Total nett amount' and 'VAT' fields.
Click the 'More' button (or options menu) in the Prepare Form sidebar and select 'Clear or Set Calculation Order'. Ensure that the 'VAT' field appears above the final total field in the list so the tax calculates before the sum.
Manage and Fill Interactive PDF Forms with WPS Office
WPS Office offers a robust PDF editor that allows you to seamlessly view, fill, and manage interactive PDF forms, ensuring embedded calculations function smoothly.
- 1. Open the PDF: Launch WPS Office and open your interactive PDF form.
- 2. Fill the Data: Click on the form fields to enter your base amounts. WPS PDF will automatically execute embedded scripts to calculate VAT and totals.
- 3. Save and Export: Once your invoice or form is filled, click 'Save' or export the document for secure sharing.
Frequently Asked Questions
Why is my grand total not updating automatically after I input the net amount?
This usually occurs because the calculation order is incorrect. If Acrobat calculates the Grand Total before calculating the VAT, the sum will be missing the tax amount. Check your Calculation Order settings and move the VAT field above the Total field.
How do I change the VAT calculation to a different percentage?
To change the rate, modify the multiplier in the custom script. For example, for a 15% tax rate, change the end of the script from '* 0.2' to '* 0.15'.
Do PDF form calculations work in all PDF viewers?
Calculations based on JavaScript work flawlessly in full-featured PDF editors like Adobe Acrobat and WPS Office PDF. However, some basic browser-based PDF viewers or built-in mobile readers may not support JavaScript executions, causing the fields to remain blank.
