How to calculate VAT - Excel Tutorial

In this video tutorial, I will show you How to calculate VAT in Excel.

Here are the key concepts you will learn in this video tutorial:

Create a new Excel Document
Add Columns for ExVAT | VAT | Inc VAT
Add value for ExVAT
Create a formula for VAT calculation
Create a formula for adding ExVAT to VAT for Inc VAT total

I will also show how to change the VAT percentages if you not based in the UK. At the present UK VAT is set to 20%.

Other MS Excel Tutorials:

Bookkeeping for Small Business - Excel Tutorial - Part 1 - Invoice Tracking - Bookkeeping Training

Bookkeeping for Small Business - Excel Tutorial - Part 2 - Invoice Template - Bookkeeping Training

Bookkeeping for Small Business - Excel Tutorial - Part 3 - Expenditure Tracking

Bookkeeping for Small Business - Excel Tutorial - Part 4 - VAT Calculations

***********************************************************************************************

***********************************************************************************************

Contact me on:

#Excel2021 #Tutorial #dcpweb

[erikaweirdsurname]

Where you from i could listen this accent all day 😂

[MrOldhoot]

You do some very useful tutorials. Some people have quite a problem understanding percentages. You don't need a % button on a calculator to add or subtract a percentage.
The video shows how to add it easy enough. If you give someone a 10% discount just multiply by 0.9 or 0.85 if it's 15%. However finding the amount before VAT was added is different. Always look at it in terms of 100. You know 20% on 100 gives 120 so form a fraction 100/120 and multiply that by 120 to bring it back to the pre VAT amount of 100. You can do this no matter what the VAT rate is. Say VAT is changed to 16.375% To add VAT multiply by 1.16375. To take off the VAT it's just 100/116.375 times the amount including VAT. If you've been multiplying X 5 and ÷ by 6 that's the same fraction as 100/120 for the current UK VAT rate.
Please no replies saying how obvious this is. It isn't to everyone.

[omahumzy]

THANK YOU JUST SOLVED A BIG PROBLEM FOR ME

[kassaArt]

Thank you!!. If only I had teachers like you when I went to school/college.

[AlaminKhalifa-yv]

that was very easy method. thank u sir

[vandanasah]

First comment 7th like 😁😁😁
Edit: and 82 view