VAT Calculator

The DCP VAT Calculator can be used to add or remove VAT at any percentage rate. Simply use this tool to check your VAT calculations are correct.

Free VAT calculator tool for instant online VAT calculations.

 

Online VAT Calculator

Use the calculator below to add or remove VAT


Add VAT Calculator

 


 

Remove VAT Calculator

 


 

Free Online VAT Calculator

How to add VAT using the VAT Calculator

The first calculator displayed above is used for adding VAT to the cost of products or services.

Step 1 - Enter the cost excluding VAT.

  • Example: Enter 100.

Step 2 - Enter the VAT percentage rate.

  • Example: Enter 20.

Step 3 - Now select the black "Calculate" button.

You should see the correct VAT amount and cost including VAT automatically calculated.

  • VAT Amount = 20.00
  • Total Cost Including VAT = 120.00

Add VAT Calculator Demo

Add VAT Calculator Demo


How to remove VAT using the VAT Calculator

The second calculator displayed above is used for removing VAT from the cost of products or services.

Step 1 - Enter the cost including VAT.

  • Example: Enter 240.

Step 2 - Enter the VAT percentage rate.

  • Example: Enter 20.

Step 3 - Now select the black "Calculate" button.

You should see the correct VAT amount and cost including VAT automatically calculated.

  • VAT Amount = 40.00
  • Total Cost Including VAT = 200.00

Remove VAT Calculator Demo

Remove VAT Calculator Demo


VAT Calculation Formula for adding VAT

You can also manually calculate adding VAT by multiplying the ex VAT cost by 1 + VAT Percentage.

Example 1:

  • Ex VAT Cost = £20.00
  • VAT Percentage = 20%
  • VAT Calculation: £20.00 x 1.2 = £24.00 inc VAT

Example 2:

  • Ex VAT Cost = £20.00
  • VAT Percentage = 17.5%
  • VAT Calculation: £20.00 x 1.175 = £23.50 inc VAT

Example 3:

  • Ex VAT Cost = $500.00
  • VAT Percentage = 22%
  • VAT Calculation: $500.00 x 1.22 = $610.00 inc VAT

Example 4:

  • Ex VAT Cost = $1245.00
  • VAT Percentage = 12.8%
  • VAT Calculation: $1245.00 x 1.128 = $1,404.36 inc VAT

VAT Calculation Formula for removing VAT

You can also manually calculate removing VAT by diving the inc VAT cost by 1 + VAT Percentage.

Example 1:

  • Inc VAT Cost = £24.00
  • VAT Percentage = 20%
  • VAT Calculation: £24.00 / 1.2 = £20.00 ex VAT

Example 2:

  • Inc VAT Cost = £23.40
  • VAT Percentage = 17.5%
  • VAT Calculation: £23.40 / 1.175 = £19.57 ex VAT

Example 3:

  • Inc VAT Cost = $610.00
  • VAT Percentage = 22%
  • VAT Calculation: $610.00 / 1.22 = $500.00 ex VAT

Example 4:

  • Inc VAT Cost = $1404.36
  • VAT Percentage = 12.8%
  • VAT Calculation: $1404.36 / 1.128 = $1245.00 ex VAT

VAT Calculation Formula for the VAT amount only

You can also manually calculate adding VAT by multiplying the ex VAT cost by 0 + VAT Percentage.

Example 1:

  • Ex VAT Cost = £20.00
  • VAT Percentage = 20%
  • VAT Amount Only Calculation: £20.00 x 0.2 = £4.00

Example 2:

  • Ex VAT Cost = £20.00
  • VAT Percentage = 17.5%
  • VAT Amount Only Calculation: £20.00 x 0.175 = £3.50

Example 3:

  • Ex VAT Cost = $500.00
  • VAT Percentage = 22%
  • VAT Amount Only Calculation: $500.00 x 0.22 = $110.00

Example 4:

  • Ex VAT Cost = $1245.00
  • VAT Percentage = 12.8%
  • VAT Amount Only Calculation: $1245.00 x 0.128 = $159.36

How to Calculate VAT using Microsoft Excel

To give you a helping hand simply watch the video below which will show you how to set up formulas in Excel for calculating VAT.

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%.

 


Microsoft Excel Bookkeeping Tutorial

At DCP we understand that managing a business can be a daunting task, especially if you are a new business. At DCP our company director (Pankaj Shah) has to learn the hard way and is a self-taught business owner. One of the most important aspects of running a business is bookkeeping. Understand which clients have paid you and which have not is essential to keeping your business cash flow running. Also, keep track of your expenditure is also important and analysing your costs can help you to plan and save your business money.

To give you a helping hand, our company director has created a series of Excel Bookkeeping Tutorials which also include VAT calculations for VAT registered businesses.

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

 


In the first part of this small business bookkeeping video tutorial, I will show you how to keep track of invoices that you have sent to your clients. We will create a spreadsheet that will document:

Video Chapters:

  • 00:00  Introduction
  • 00:55  Chapter 1 - Create a new blank Excel spreadsheet
  • 02:24  Chapter 2 - Create column titles
  • 04:42  Chapter 3 - Column cell formatting
  • 06:45  Chapter 4 - Data entry examples
  • 24:54  Chapter 5 - Adding colour tracking
  • 34:30  Chapter 6 - Future payments
  • 41:58  Chapter 7 - Filename convention
  • 45:55  Chapter 8 - Auto filters / AutoSum

Excel Column Headers used in this tutorial:

  • Invoice Date
  • Invoice No
  • Date Paid
  • Payment Type
  • Reference
  • Description
  • Company Name
  • Location
  • Cost
  • Paid

In this video tutorial, we will use colour codes and highlight rows in green which are paid invoices and rows in blue which are still outstanding. This helps us to quickly check outstanding invoices. I will also show you how to use the auto sum function to calculate your total expected income, the total amount paid to date and the total amount which is outstanding.

Using the spreadsheet should also reduce your business accountant costs as you will be able to provide a comprehensive spreadsheet that is fully documented for income into your business. This should save your accountant time and result in lower accountancy fees.
bookkeeping training.

Most important is for you to understand what income is coming into your business and keep track of outstanding invoices which you need to chase up.

In the second part of this tutorial, I will show you how to create a custom invoice template using Microsoft Excel.

Ultimately the goal of this tutorial is to reduce your monthly outgoing fees for accountancy software.

Once you've mastered this bookkeeping software tutorial then you'll be less reliant on third-party applications.

If you're planning on building an online e-commerce store then it may be worth looking at third-party software solutions for bookkeeping such as Xero or Quick Books. Xero or Quick Books and other accountancy software can be easily integrated into e-commerce solutions like woocommerce or Shopify. In the long run, this should save you time so you can focus on your you're my main goal which is to sell products.

Make sure you update bookkeeping spreadsheets on a weekly or monthly basis, trust me it will save you a lot of headaches later. Remember to file hard copies of your invoices and receipts in date order.

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

 


In the second part of this small business bookkeeping video tutorial, I will show you how to create a custom invoice template using Microsoft Excel. I will also show you how to add formulas for automatic calculations. We will replicate the invoice template to create new client invoices, I will also show you how to save the Excel invoice into PDF format so you can simply email invoices to your clients - bookkeeping training.

Video Chapters:

  • 00:00  Introduction
  • 01:27  Chapter 1 - Create a new blank Excel spreadsheet
  • 02:25  Chapter 2 - Update spreadsheet margins
  • 04:46  Chapter 3 - Create the invoice header
  • 14:09  Chapter 4 - Layout invoice template content
  • 33:40  Chapter 5 - Add payment details (Bank Account)
  • 38:10  Chapter 6 - Add payment terms
  • 39:47  Chapter 7 - Add company number & VAT number to the footer of the document
  • 47:15  Chapter 8 - Create a new invoice from the template
  • 51:10  Chapter 9 - Data entry and formula calculations
  • 54:20  Chapter 10 - Save invoice as PDF

Our first goal is to create a blank spreadsheet and save the file as a template. We will then fix the margin to give us more space. Next, we will add our company address and logo to the header of the document spreadsheet invoice template.

Once the header is completed, we will start the processing of laying out content for the main invoice body. We will add our banking details so clients can easily make bank transfers for payments.

I will then show you how to add your company number and VAT number to the footer of the document.

Now the template is completed, I will show you how to copy the template and enter data to create a new customer invoice.

We will enter data from the invoice tracker template we created in part 1 of this tutorial, I will also show you how to create some basic formulas to speed up data entry.

Finally, we will save the document as a PDF file which we can email to the customer.

Note, there are monthly subscription accounting software applications like Xero or Quick Books which also allows you to generate invoices that can be sent to customers via email. The goal of this tutorial is to try and keep your costs low as possible for a small start-up business.

In the long run, it is probably worth investing in accounting software when your business grows and you're seeing substantial profits. 

It would be a good idea to speak to your accountant and find out what software applications they recommend such as Xero or Quick Books.

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

 


In the third part of this small business bookkeeping video tutorial, I will show you how to keep track of your company's expenditure. We will create an Excel Spreadsheet which will simply allow us to keep track of all costs in our business - bookkeeping training.

The Excel expenditure spreadsheet Will track the following information:

  • Invoice date
  • date paid
  • Company name
  • Payment Type
  • Cost
  • other Currencies
  • Notes

We will use colour codes and highlight rows in different colours to visually track different types of costs in our business.

Using the spreadsheet should also reduce your business accountant costs as you will be able to provide a comprehensive spreadsheet that is fully documented for your company's yearly expenditure. This should save your accountant time and result in lower accountancy fees.

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

 


In the fourth part of this small business bookkeeping video tutorial, I will show you how to convert the current small business bookkeeping system into a VAT bookkeeping system.

We will modify the previous spreadsheets we created in Part 1, 2 and 3 to include VAT calculations.


Disclaimer: DCP Web Designers are not liable for damage or loss of profits caused by the use of the VAT calculator or tutorials on this page. You are using this website at your own risk.



Tell Us Your Thoughts

back