How to update VAT percentages in bulk for products, scheduled invoices, delivery notes, quotes, mass invoices, and other payment items
What does the term "payment item" mean in this guide?
The term payment items collectively refers to the following functions in the system:
Scheduled invoices
Delivery notes
Pro forma invoices
Quotes
Mass invoices
Updating VAT Percentages for Products
Updating the VAT percentages for products changes the VAT rate of selected products from a selected current rate to a new rate and recalculates the net and gross prices accordingly.
If any payment items (scheduled invoices, delivery notes, quotes, mass invoices) contain those products with the specified current VAT rate, all uninvoiced payment items where the next billing date is today or in the future will also be updated.
Steps:
Go to Sales → Products
Use the search to find the desired products
Select the products you want to update
Click the "VAT Update Tool" button
Choose the current VAT rate you want to update
Choose the new VAT rate
From the option "Choose which price remains: Net or Gross", select:
Net
Gross
Keep the current pricing direction (net or gross stays as is)
For example:
If you select 10% as the current VAT and 14% as the new VAT and choose Net, the net price stays the same and the gross price increases.
If you choose Gross, the gross price stays the same and the net price decreases.
Click "Update VAT percentages for selected rows"
The selected products' VAT rates and prices will be updated according to your selections. If those products are used in payment items, the related payment item rows and items will also be updated.
Updating VAT Percentages for Payment Items
You can also update only the VAT percentages of payment items (scheduled invoices, delivery notes, quotes, mass invoices) — useful if you haven't used products, do not wish to update products, or have already manually updated product VAT rates.
Steps:
Go to the section for the payment item whose rows you want to update:
Scheduled/Contract Invoices: Sales → Scheduled Invoices
Delivery Notes: Sales → Delivery Notes
Mass Invoices: Sales → Mass Invoices
Pro formas: Sales → Pro formas
Quotes: Sales → Quotes or Project Management / Work Log → Quotes
Search and display the relevant rows
Select the rows you want to update
Click the "VAT Update Tool" button
Choose the current VAT rate
Choose the new VAT rate
Choose the price direction from "Choose which price remains: Net or Gross":
Net
Gross
Keep the current direction (net or gross remains unchanged)
For example:
With 10% as current VAT and 14% as new VAT, if Net is chosen, the net price stays the same and the gross price increases.
If Gross is chosen, the gross price stays the same and the net price decreases.
Click "Update VAT percentages for selected rows"
The VAT percentages and prices for the selected payment item rows will be updated according to your choices.