If you are running a business in a country where you must charge your clients VAT, like Israel or the UK, you may often find yourself trying to figure out how much money is left once VAT is deducted from client payments. I’ve found a number of online VAT calculators, but they are either unreliable, or you cannot modify the VAT amount which is set for the VAT rates in the UK or other countries.
So I made my own VAT calculator in Google Spreadsheet. It’s really simple, yet useful, so I decided to share it with you. All you have to do is change the value in the Gross row, and the VAT row if relevant, and it will recalculate the Net amount automatically.
Here’s how it looks:
You can download the spreadsheet here.