How to Remove VAT or Add VAT with the VAT Calculator v2.0

In version 2.0 of the Working Data VAT Calculator, we have made it even easier to remove VAT from, or add VAT to, several numbers at the one time.

The quick and easy-to-follow instructions below will take you through how to remove VAT or add VAT with the VAT Calculator.

Step 1, is to download the VAT Calculator. Remember to virus-scan any files you download from the internet with up-to-date virus scanning software.

Removing VAT

On opening the VAT Calculator, you will see that there are two worksheets in the spreadsheet. One for Adding VAT and one for Removing VAT. Click on the sheet tab called 'Removing VAT'. It should look like Spreadsheet Data 1.

Spreadsheet Data 1

Simply type in the name of the product in the product column and the price including VAT in the Price Incl. VAT column and the VAT Calculator will calculate the Price Excl. VAT and the VAT amount. This does not have to be a product, it can be a service or any transaction. See Spreadsheet Data 2.

Spreadsheet Data 2

And that's it! You can add more products and prices down the rest of the rows. The method for adding VAT is exactly the same, except you use the worksheet titled 'Adding VAT' and you enter the price excluding VAT.

If you have any questions about how to use the VAT Calculator or you would like to suggest a spreadsheet to add to our library, please contact us

..back to top