How to calculate VAT

Understanding VAT before you calculate it

VAT, or Value Added Tax, is a tax added to many goods and services at each stage of the supply chain. For most businesses, the practical question is simple: how much VAT should be added to an invoice, receipt, quote, or bill? Whether you are a freelancer, sole trader, small business owner, agency, contractor, consultant, retailer, or service provider, knowing how to calculate VAT correctly helps you price your work, invoice customers accurately, and keep clear records for tax reporting.

Although the idea of VAT can seem confusing at first, the actual calculation is usually straightforward once you understand the relationship between the net amount, the VAT rate, the VAT amount, and the gross amount. The net amount is the price before VAT. The VAT amount is the tax added to that price. The gross amount is the final total including VAT. Most VAT calculations are simply about moving between those three figures.

For example, if you sell a service for £100 before VAT and the VAT rate is 20%, the VAT amount is £20. The total price including VAT is £120. In this example, £100 is the net amount, £20 is the VAT amount, and £120 is the gross amount. Once you understand this structure, you can calculate VAT on invoices, products, services, discounts, deposits, expenses, and mixed-rate sales with much more confidence.

Invoice24 is designed to make this easier by helping you create clear invoices, add VAT where needed, calculate totals automatically, manage line items, apply discounts, and produce professional invoice documents without having to build your own spreadsheet from scratch. Even if you use an app to do the maths for you, it is still useful to understand how the figures work so you can check your invoices and explain totals to customers when needed.

The basic VAT formula

The most common VAT calculation is adding VAT to a price before tax. This is the calculation you use when you know the net price and need to work out the final amount to charge the customer.

The formula is:

VAT amount = net amount × VAT rate

Gross amount = net amount + VAT amount

If the VAT rate is 20%, you use 20% as 0.20 in the calculation. If the VAT rate is 5%, you use 0.05. If the VAT rate is 10%, you use 0.10. Percentages need to be converted into decimals before multiplying.

Here is a simple example. Suppose your net price is £250 and the VAT rate is 20%:

VAT amount = £250 × 0.20 = £50

Gross amount = £250 + £50 = £300

So the invoice should show a net amount of £250, VAT of £50, and a total amount due of £300. This is the standard way VAT is shown on many business invoices because it makes the tax amount clear to the customer and keeps your records organised.

How to add VAT to a price

To add VAT to a price, multiply the net price by one plus the VAT rate. This gives you the gross total in a single step. For example, with a 20% VAT rate, you multiply the net price by 1.20. With a 5% VAT rate, you multiply by 1.05. With a 10% VAT rate, you multiply by 1.10.

The formula is:

Gross amount = net amount × (1 + VAT rate)

If the net amount is £80 and the VAT rate is 20%, the calculation is:

£80 × 1.20 = £96

The gross amount is £96. The VAT amount is £16, because £96 minus £80 equals £16.

This shortcut is useful when you are preparing prices, quotes, estimates, and invoices. Instead of calculating the VAT separately and then adding it, you can multiply by the VAT-inclusive factor. This is especially handy when you have many line items and want to check totals quickly.

Invoice24 can handle this automatically when you create invoices. You can add your products or services as line items, enter the price, choose the VAT rate, and let the invoice total update for you. This reduces the chance of manual arithmetic mistakes, especially when your invoice includes several services, quantities, discounts, or different tax rates.

How to remove VAT from a price

Sometimes you already know the price including VAT and need to work backwards to find the price before VAT. This is called extracting VAT from a gross amount. It is common when you are reviewing receipts, calculating the VAT portion of an inclusive price, or entering expenses into your records.

To remove VAT from a VAT-inclusive price, divide the gross amount by one plus the VAT rate. For a 20% VAT rate, divide by 1.20. For a 5% VAT rate, divide by 1.05. For a 10% VAT rate, divide by 1.10.

The formula is:

Net amount = gross amount ÷ (1 + VAT rate)

Then:

VAT amount = gross amount - net amount

For example, suppose the total price including VAT is £120 and the VAT rate is 20%:

Net amount = £120 ÷ 1.20 = £100

VAT amount = £120 - £100 = £20

This means the original net price was £100 and the VAT included in the £120 total was £20. A common mistake is to calculate 20% of the gross amount and assume that is the VAT. For example, 20% of £120 is £24, but that is not the correct VAT amount included in a £120 VAT-inclusive price. The VAT is £20 because the £120 already contains both the original price and the tax.

Why adding VAT and removing VAT are different

Adding VAT and removing VAT are not mirror-image calculations using the same percentage of the final number. This is one of the most common areas of confusion. When you add 20% VAT to £100, you add £20, producing a total of £120. But when you remove VAT from £120, the VAT is not 20% of £120. It is the portion of the £120 that represents 20% of the original net amount.

Think of it this way: if £100 is the net amount, 20% VAT is £20, and the total is £120. The VAT is 20% of the net amount, but it is one-sixth of the gross amount. That is why the correct way to remove 20% VAT from a gross price is to divide by 1.20, not subtract 20% from the gross price.

For example, if you incorrectly subtract 20% from £120, you get £96. That would suggest the VAT amount is £24, which is wrong. If you then added 20% VAT back to £96, you would get £115.20, not £120. The correct net amount is £100. Dividing by 1.20 keeps the calculation accurate.

VAT calculation examples

Here are several practical VAT examples to show how the formulas work in everyday business situations.

If your net price is £50 and the VAT rate is 20%, the VAT is £10 and the gross total is £60. The calculation is £50 × 0.20 = £10, then £50 + £10 = £60.

If your net price is £375 and the VAT rate is 20%, the VAT is £75 and the gross total is £450. The calculation is £375 × 0.20 = £75, then £375 + £75 = £450.

If your gross price is £240 and the VAT rate is 20%, the net price is £200 and the VAT amount is £40. The calculation is £240 ÷ 1.20 = £200, then £240 - £200 = £40.

If your net price is £1,200 and the VAT rate is 5%, the VAT is £60 and the gross total is £1,260. The calculation is £1,200 × 0.05 = £60, then £1,200 + £60 = £1,260.

If your gross price is £525 and the VAT rate is 5%, the net price is £500 and the VAT amount is £25. The calculation is £525 ÷ 1.05 = £500, then £525 - £500 = £25.

These examples show the same principle each time. To add VAT, multiply the net amount by the VAT rate. To remove VAT, divide the gross amount by one plus the VAT rate. Once you know which direction you are calculating, the maths becomes much easier.

How to calculate VAT on an invoice

VAT invoices usually show each item or service, the quantity, the unit price, the VAT rate, the VAT amount, and the total. The exact layout can vary, but the purpose is always the same: to make it clear what was sold, what VAT was applied, and what the customer needs to pay.

To calculate VAT on an invoice, start by listing each product or service. For each line item, multiply the unit price by the quantity to get the line net amount. Then apply the correct VAT rate to that line. Add the VAT amounts together to get the total VAT. Add the net amounts together to get the subtotal before VAT. Finally, add the subtotal and VAT total to get the invoice total.

For example, imagine an invoice with two services. The first service costs £300 before VAT. The second service costs £150 before VAT. The VAT rate is 20% on both lines. The net subtotal is £450. The VAT is £90. The total invoice amount is £540.

The calculation is:

£300 + £150 = £450 net subtotal

£450 × 0.20 = £90 VAT

£450 + £90 = £540 total

When an invoice has one VAT rate, you can calculate VAT on the subtotal. When an invoice has different VAT rates, you should calculate VAT separately for each line or group of lines. This helps avoid errors and makes the invoice easier to understand.

Invoice24 helps by letting you create invoices with multiple line items and VAT rates, so you do not need to manually recalculate every total. This is useful when you sell a mixture of services, products, expenses, or billable items and want the invoice to remain professional and accurate.

How to calculate VAT with multiple line items

Many invoices contain more than one line item. A line item might be a service, a product, a project stage, a delivery charge, a subscription, a licence fee, or an expense recharge. Each line should have its own net amount and VAT treatment.

Suppose you are creating an invoice with the following items:

Consulting: £500 net at 20% VAT

Design work: £300 net at 20% VAT

Printing: £100 net at 20% VAT

The total net amount is £900. The VAT at 20% is £180. The gross invoice total is £1,080.

If every line uses the same VAT rate, the calculation is simple. You can add the net amounts first and then apply VAT to the subtotal. However, it is still good practice to show line details clearly, especially if your customer needs a VAT invoice for their own records.

If your invoice includes items with different VAT rates, calculate each line separately. For example, one item might be charged at 20%, another at 5%, and another at 0%. In that case, calculating VAT only on the total subtotal would be inaccurate. Each rate needs to be applied only to the relevant items.

How to calculate VAT with different VAT rates

Some businesses sell items that do not all have the same VAT rate. When this happens, you need to separate the invoice into groups by VAT rate. Each group has its own net total, VAT amount, and gross total. The overall invoice total is then the sum of all the gross totals.

For example, imagine an invoice with three items:

Item A: £200 at 20% VAT

Item B: £100 at 5% VAT

Item C: £50 at 0% VAT

The VAT on Item A is £40. The VAT on Item B is £5. The VAT on Item C is £0. The total net amount is £350. The total VAT is £45. The gross total is £395.

The calculation is:

£200 × 0.20 = £40

£100 × 0.05 = £5

£50 × 0.00 = £0

Total VAT = £40 + £5 + £0 = £45

Total invoice = £350 + £45 = £395

This line-by-line method is the safest way to handle mixed-rate invoices. It also makes the invoice clearer for the customer. If they need to check how the VAT was calculated, they can see the rate and amount for each item instead of trying to understand one combined figure.

How to calculate VAT on discounts

Discounts can affect VAT because VAT is normally calculated on the amount the customer actually pays after the discount has been applied. If you reduce the selling price, the VAT amount usually reduces as well.

For example, suppose you provide a service priced at £500 before VAT and offer a 10% discount. The discount is £50, so the discounted net price is £450. If the VAT rate is 20%, the VAT is £90 and the gross total is £540.

The calculation is:

£500 × 10% = £50 discount

£500 - £50 = £450 discounted net amount

£450 × 20% = £90 VAT

£450 + £90 = £540 total

A common mistake is to calculate VAT on the original price before applying the discount. That can overstate the VAT and make the invoice total incorrect. The discount should usually be applied before VAT is calculated, unless your specific pricing arrangement requires a different treatment.

With Invoice24, you can create invoices that include discounts and VAT, helping you show the customer how the final total was reached. This is especially useful for promotional offers, loyalty discounts, early-payment discounts, project discounts, and negotiated rates.

How to calculate VAT on deposits and part payments

Deposits and part payments are common in many industries, especially for project work, bookings, construction, design, events, consulting, and custom orders. VAT can apply when a payment is received or when an invoice is issued, depending on the rules that apply to your business and location. From a calculation point of view, the important step is to apply VAT to the relevant amount being charged.

If you request a deposit of £200 before VAT and the VAT rate is 20%, the VAT on the deposit is £40 and the customer pays £240. If the full project price is £1,000 before VAT, the full VAT would be £200 and the full gross project value would be £1,200. The deposit invoice would show £200 net, £40 VAT, and £240 total.

When the final invoice is issued, you may need to show the full project value, deduct the deposit already paid, and show the remaining balance. Keeping the records clear is important so the customer understands what has already been paid and what remains outstanding.

Invoice24 can help you create professional invoices for deposits, balances, and staged payments. This is useful when a project is billed in phases or when customers pay part of the total upfront.

How to calculate VAT on expenses

Businesses often recharge expenses to clients. These might include travel, materials, postage, accommodation, software, printing, or other costs incurred while delivering work. VAT on expenses can be more complex because the correct treatment may depend on whether the cost is a disbursement, a recharge, part of your service, or an item you bought and resold.

From a calculation perspective, if you need to add VAT to an expense recharge, you calculate it in the same way as any other invoice line. For example, if you recharge £75 of expenses and VAT applies at 20%, the VAT is £15 and the gross amount is £90.

The calculation is:

£75 × 0.20 = £15 VAT

£75 + £15 = £90 total

If you are entering a VAT-inclusive receipt into your records, you remove VAT by dividing by the VAT-inclusive factor. For example, if a receipt total is £36 including 20% VAT, the net amount is £30 and the VAT is £6. The calculation is £36 ÷ 1.20 = £30, then £36 - £30 = £6.

Because expense rules can vary, it is important to apply the correct VAT treatment for your situation. A good invoicing app helps with the arithmetic, but you should still use the correct VAT category for each item.

How to calculate VAT-inclusive prices

A VAT-inclusive price is a price that already includes VAT. This is common in retail, ecommerce, hospitality, consumer services, and other businesses where customers expect to see the final amount they will pay. If a product is advertised at £120 including VAT, the customer pays £120. The task is to work out how much of that total is VAT and how much is the net price.

To calculate the net amount from a VAT-inclusive price, divide by one plus the VAT rate. At 20%, divide by 1.20. At 5%, divide by 1.05.

For a £120 VAT-inclusive price at 20% VAT:

Net amount = £120 ÷ 1.20 = £100

VAT amount = £120 - £100 = £20

For a £63 VAT-inclusive price at 5% VAT:

Net amount = £63 ÷ 1.05 = £60

VAT amount = £63 - £60 = £3

This is useful when your selling prices are customer-facing and already include tax. You can still create a VAT invoice by showing the VAT breakdown behind the final price.

How to calculate prices before VAT

Sometimes you need to set a price before VAT based on the final amount you want the customer to pay. For example, you might want the VAT-inclusive price to be exactly £99, £250, or £1,000. To find the net price, divide the target gross price by one plus the VAT rate.

If you want the customer to pay exactly £99 including 20% VAT, the net price is:

£99 ÷ 1.20 = £82.50

The VAT is:

£99 - £82.50 = £16.50

So the price before VAT should be £82.50, the VAT should be £16.50, and the final price should be £99.

This method is helpful when setting fixed package prices, subscription prices, product prices, or advertised prices that need to include VAT. It also helps avoid awkward totals when you want a clean final price for customers.

How to calculate VAT in Excel or a spreadsheet

Many businesses use spreadsheets for quick VAT checks. The formulas are simple, but spreadsheets can become difficult to manage if you have lots of invoices, customers, tax rates, payment statuses, and document numbers. Still, it is useful to know the basic formulas.

If cell A1 contains the net amount and the VAT rate is 20%, the VAT amount can be calculated with:

=A1*20%

The gross amount can be calculated with:

=A1*1.20

If cell A1 contains a VAT-inclusive amount and the VAT rate is 20%, the net amount can be calculated with:

=A1/1.20

The VAT amount can be calculated with:

=A1-(A1/1.20)

Spreadsheets are flexible, but they are also easy to break. A copied formula, deleted row, incorrect cell reference, or wrong VAT rate can create errors that are difficult to spot. For professional invoicing, Invoice24 can be a better option because it is built specifically for creating invoices, managing totals, calculating VAT, and keeping customer documents organised.

How to calculate VAT without a calculator

For some common VAT rates, you can estimate VAT mentally. This is helpful when checking a price quickly, although you should still use accurate calculations for invoices and tax records.

For 20% VAT, divide the net price by 5 to find the VAT. For example, 20% of £100 is £20 because £100 ÷ 5 = £20. To add 20% VAT, add one-fifth of the net amount to the original amount.

For 10% VAT, divide the net price by 10. For example, 10% of £80 is £8. For 5% VAT, calculate 10% and then halve it. For example, 10% of £200 is £20, so 5% is £10.

Removing VAT mentally is harder because you need to divide by the VAT-inclusive factor. For 20% VAT, the VAT portion of a gross amount is one-sixth of the total. For example, if the gross amount is £120, one-sixth is £20, which is the VAT amount. The net amount is £100.

Mental shortcuts are useful for estimates, but an invoicing tool is safer for official documents. Even small rounding differences can create confusion when invoices contain multiple items.

Rounding VAT correctly

VAT calculations often produce decimals. For example, 20% VAT on £19.99 is £3.998. Because money is usually shown to two decimal places, this needs to be rounded. In most cases, £3.998 would be shown as £4.00.

Rounding can be handled at line level or invoice-total level depending on how the invoice is structured and what is appropriate for your records. Line-level rounding means calculating and rounding VAT on each invoice line. Total-level rounding means adding the net amounts first and then calculating VAT on the subtotal. These methods can sometimes produce a small difference of one penny, especially on invoices with many low-value items.

For example, if several small items each create fractions of a penny in VAT, rounding every line individually may produce a slightly different total than calculating VAT on the combined subtotal. The key is to use a consistent method and make sure the invoice total is clear.

Invoice24 helps reduce rounding mistakes by calculating invoice totals automatically. This is one of the advantages of using invoicing software rather than manually calculating VAT with a calculator or spreadsheet for every invoice.

Common VAT calculation mistakes

One common mistake is subtracting the VAT percentage from a gross amount to remove VAT. As explained earlier, this is incorrect. To remove VAT from a VAT-inclusive price, divide by one plus the VAT rate.

Another mistake is applying VAT to the wrong amount when a discount is involved. VAT should usually be calculated after the discount has reduced the taxable amount. If you calculate VAT before applying the discount, the customer may be charged too much.

A third mistake is using the wrong VAT rate. Some goods and services may have different rates, and some may be outside the scope of VAT or charged at a zero rate. Always make sure the correct rate is used for the item being invoiced.

A fourth mistake is mixing VAT-inclusive and VAT-exclusive pricing without making it clear. If a quote says £500, does that mean £500 before VAT or £500 including VAT? This should be stated clearly to avoid disputes. Business customers often expect net prices plus VAT, while consumers often expect the final price including VAT.

A fifth mistake is forgetting to update invoice templates. If you use old templates, copied documents, or manual spreadsheets, you may accidentally reuse old customer details, invoice numbers, VAT rates, or payment terms. Invoice24 helps by giving you a structured way to create new invoices without relying on copied files.

VAT-exclusive pricing vs VAT-inclusive pricing

VAT-exclusive pricing means the price is shown before VAT. For example, a service might be listed as £500 plus VAT. If VAT is 20%, the customer pays £600 in total. VAT-exclusive pricing is common in business-to-business sales because VAT-registered customers may need to see the tax separately.

VAT-inclusive pricing means the price already includes VAT. For example, a product might be listed as £60 including VAT. The customer pays £60 in total, and the business calculates how much VAT is included within that amount. VAT-inclusive pricing is common in consumer sales because customers usually want to know the final price they will pay.

The important thing is to be clear. If your invoice, quote, or estimate does not say whether VAT is included, the customer may misunderstand the final amount. This can lead to payment delays, disputes, or awkward conversations.

Invoice24 can help you produce professional documents that show prices, VAT, and totals clearly. This makes it easier for customers to understand what they are being charged and easier for you to keep accurate records.

How to show VAT on an invoice

A clear VAT invoice should show the essential transaction details. This usually includes your business details, customer details, invoice number, invoice date, description of goods or services, net amounts, VAT rates, VAT amounts, and the total amount payable. Payment terms and payment instructions should also be easy to find.

For each invoice line, it is helpful to show the description, quantity, unit price, VAT rate, and line total. At the bottom of the invoice, show the subtotal before VAT, the total VAT, and the final amount due. If different VAT rates apply, it can be helpful to show a VAT summary that breaks down the totals by rate.

For example, an invoice might show:

Subtotal: £1,000

VAT at 20%: £200

Total due: £1,200

This simple structure makes the invoice easy to read. It also helps the customer process the invoice quickly, especially if they need to enter it into their accounting system.

How Invoice24 helps with VAT calculations

Invoice24 is a free invoice app designed to help businesses create professional invoices quickly and accurately. Instead of manually calculating VAT each time, you can enter your invoice details and let the app calculate totals for you. This saves time and reduces the risk of arithmetic mistakes.

With Invoice24, you can create invoices with multiple line items, add VAT rates, apply discounts, manage customer details, include payment information, and produce clean invoice documents. This is useful for freelancers, small businesses, contractors, agencies, consultants, tradespeople, and anyone who needs a simple way to invoice clients.

Invoice24 is especially helpful when your invoices include more than one item. Manual calculations become more error-prone as soon as you add quantities, discounts, expenses, or different VAT rates. A dedicated invoicing tool keeps the calculation structure consistent and helps make sure the final amount due is clear.

Using Invoice24 can also make your business look more professional. A well-formatted invoice gives customers confidence, makes payment details easy to find, and helps avoid confusion about totals. When VAT is shown clearly, customers can understand exactly how the final amount has been calculated.

Step-by-step guide to calculating VAT

The first step is to decide whether your starting amount is net or gross. If the amount is before VAT, it is net. If the amount already includes VAT, it is gross. This matters because adding VAT and removing VAT use different formulas.

The second step is to identify the correct VAT rate. The rate must match the type of goods or services being sold and the rules that apply to your business. If you are unsure which rate applies, check before issuing the invoice.

The third step is to calculate the VAT amount. If you are adding VAT, multiply the net amount by the VAT rate. If you are removing VAT, divide the gross amount by one plus the VAT rate to find the net amount, then subtract the net amount from the gross amount to find the VAT.

The fourth step is to check the final total. For VAT-exclusive pricing, the total should be the net amount plus the VAT amount. For VAT-inclusive pricing, the total should remain the same, but you should be able to show how much of it is net and how much is VAT.

The fifth step is to present the calculation clearly on your invoice. The customer should be able to see what they bought, the price before VAT, the VAT charged, and the amount they need to pay.

Practical VAT calculation checklist

Before sending an invoice, check that the customer details are correct, the invoice date is correct, the invoice number is unique, and each product or service is described clearly. Then check that the net amounts are correct and that the VAT rate has been applied to the right items.

Next, check any discounts. Make sure the discount has been applied before VAT if that is the correct treatment for your invoice. Then check the VAT total and the final invoice total. If the customer has already paid a deposit, make sure the amount paid and the balance due are clear.

You should also check whether your prices are intended to be VAT-inclusive or VAT-exclusive. This is especially important when turning a quote into an invoice. If a customer accepted a quote for a final total, make sure the invoice matches the agreed pricing structure.

Finally, check that your payment instructions are easy to understand. An accurate invoice is only useful if the customer can also see how and when to pay. Invoice24 helps by keeping these details organised in a professional invoice format.

Frequently asked questions about calculating VAT

How do I calculate 20% VAT?

To calculate 20% VAT on a net amount, multiply the net amount by 0.20. For example, 20% VAT on £100 is £20. The total including VAT is £120.

How do I add VAT to a price?

To add VAT to a price, multiply the net price by one plus the VAT rate. For 20% VAT, multiply by 1.20. For example, £250 × 1.20 = £300.

How do I remove VAT from a price?

To remove VAT from a VAT-inclusive price, divide the gross price by one plus the VAT rate. For 20% VAT, divide by 1.20. For example, £240 ÷ 1.20 = £200 net, meaning the VAT is £40.

Is VAT calculated before or after a discount?

VAT is usually calculated on the discounted amount the customer actually pays. For example, if a £500 item is discounted to £450 and VAT is 20%, VAT is calculated on £450, not £500.

What is the difference between net and gross?

Net means the amount before VAT. Gross means the amount including VAT. The VAT amount is the difference between the net and gross figures.

Can Invoice24 calculate VAT for me?

Yes. Invoice24 can help you create invoices, add line items, apply VAT, calculate totals, include discounts, and produce professional invoices for your customers.

Final thoughts on calculating VAT

Calculating VAT is much easier when you understand the basic relationship between net, VAT, and gross. If you are adding VAT, multiply the net amount by the VAT rate and add it to the original price. If you are removing VAT, divide the gross amount by one plus the VAT rate and subtract the net amount from the gross total to find the VAT.

The most important points are to use the correct VAT rate, apply it to the correct amount, handle discounts properly, and show the calculation clearly on your invoice. Small mistakes can lead to incorrect totals, customer confusion, and messy records, so it is worth using a reliable process every time.

Invoice24 makes VAT invoicing simpler by handling the calculations and helping you create clear, professional invoices. Whether you are sending a simple one-line invoice or a detailed invoice with multiple items, VAT rates, discounts, deposits, and expenses, Invoice24 gives you the tools you need to invoice accurately and confidently.