Value Added Tax (VAT) is an everyday reality for business owners, freelancers, and consumers alike. Yet, calculating the exact VAT figure on an invoice, receipt, or pricing sheet remains one of the most common accounting headaches. If you have ever stared at a receipt trying to work out the original price before tax was added, or if you are trying to prepare a tax return and need to isolate the tax portion from your total sales, you know how confusing the math can be.

At first glance, it seems simple. If standard VAT is 20%, shouldn't you just subtract 20% from your total? Unfortunately, this is the single most common mistake people make, and it leads to inaccurate financial records, underpaid tax, or lost revenue.

In this comprehensive guide, we will break down the exact mathematics of VAT. We will show you how to take VAT off a figure, how to find the VAT of a figure directly, and how to avoid the common mathematical traps that catch out even experienced professionals.

1. The Anatomy of a VAT Figure: Net, Tax, and Gross

Before we dive into formulas, we must establish a clear financial vocabulary. Every transaction subject to Value Added Tax contains three distinct figures:

1. The Net Figure (Pre-Tax): This is the cost of the goods or services before any tax is applied. It is the base amount that a business keeps as revenue.
2. The VAT Amount: This is the tax levied on the net figure. The rate varies depending on the country and the type of product (such as standard, reduced, or zero rate).
3. The Gross Figure (Total/Tax-Inclusive): This is the final amount paid by the end customer. It is the sum of the Net Figure and the VAT Amount.

Understanding how these three figures interact is key. When you look at a invoice, the total amount you see is the gross amount. If you are registered for VAT, you cannot simply treat this gross number as your revenue. You must divide it into its taxable and non-taxable components. Knowing how to isolate the VAT figure is essential for filing your returns correctly and ensuring your bookkeeping remains fully compliant with authorities like HMRC in the UK, or revenue agencies across Europe and the globe.

2. The Mathematical Trap: Why You Can't Just Subtract 20%

Why does calculating a figure minus VAT confuse so many people? The answer lies in a common mathematical misunderstanding regarding percentages and their bases.

Let’s look at a concrete example to understand why simple percentage subtraction fails.

Imagine you have a product with a Net price of £100. If the VAT rate is 20%, you add £20 of tax to the net price:

£100 (Net) + £20 (VAT) = £120 (Gross)

Now, imagine you only have the Gross figure (£120) and you want to take out VAT from a figure to find the original Net amount.

If you make the mistake of calculating 20% of the Gross figure (£120) and subtracting it, look at what happens:

20% of £120 = £24 £120 - £24 = £96

Your calculation says the original price was £96. But we already know the original price was £100! By simply subtracting 20% from the gross amount, you have undervalued your net price by £4. If you repeat this mistake across hundreds of invoices, your books will be a disaster, and you will report incorrect figures to the tax authority.

Why does this happen?

This error occurs because the 20% VAT was originally calculated on the Net figure (£100), not the Gross figure (£120). When you calculate 20% of £120, you are calculating a percentage on a larger base number, which yields a larger tax amount (£24 instead of £20). To properly reverse the calculation and deduct VAT from figure total, you must use division rather than basic percentage subtraction. This brings us to the core formulas.

3. How to Take VAT Off a Figure (Finding the Net Amount)

To find the figure minus VAT (the Net amount) when starting with the gross total, you need to use a simple division formula. This process is often called "calculating the reverse VAT."

The Reverse VAT Formula

To take VAT off a figure, divide the Gross amount by 1 plus the VAT decimal rate:

Net Amount = Gross Amount / (1 + (VAT Rate / 100))

Let's apply this formula to standard and reduced tax rates to make it highly practical.

Example A: Removing 20% Standard VAT (UK / EU standard)

For a standard VAT rate of 20%, the decimal rate is 0.20. Therefore, your divisor is 1.20.

• Formula: Gross Amount / 1.2
• Scenario: You have an invoice for £150 and want to find the net price without tax.
• Calculation: £150 / 1.2 = £125
• Result: The net figure is £125. The remaining £25 is the VAT amount.

Example B: Removing 5% Reduced VAT (UK / EU reduced)

For items subject to a reduced VAT rate of 5% (such as domestic fuel or children's car seats), the decimal rate is 0.05. Your divisor is 1.05.

• Formula: Gross Amount / 1.05
• Scenario: You spent £84 on fuel and need to find the pre-tax amount.
• Calculation: £84 / 1.05 = £80
• Result: The net figure is £80. The remaining £4 is the VAT amount.

Example C: Removing 10% GST/VAT (Australia / Global standards)

For countries with a standard 10% rate (like Australia's Goods and Services Tax), the divisor is 1.10.

• Formula: Gross Amount / 1.1
• Scenario: A service invoice totals $330 tax-inclusive.
• Calculation: $330 / 1.1 = $300
• Result: The pre-tax net figure is $300, and the GST is $30.

By memorizing these simple divisors (1.2 for 20% VAT, 1.05 for 5% VAT, and 1.1 for 10% VAT), you can easily and instantly calculate a figure minus VAT using any basic calculator.

4. How to Find the VAT of a Figure Directly (The "VAT Fraction" Shortcut)

What if you do not care about the Net figure, and you simply want to extract the tax portion from the gross total? For instance, you have a pile of standard receipts and you need to calculate the exact amount of VAT you can reclaim, without having to calculate the net value for each one first.

To find the VAT of a figure directly, you can use a mathematical shortcut known as the VAT Fraction.

Understanding the VAT Fraction

The VAT fraction is derived from the ratio of the VAT rate to the total tax-inclusive percentage.

VAT Fraction = VAT Rate / (100 + VAT Rate)

Let’s calculate the fractions for the most common tax rates:

• For 20% VAT: 20 / 120, which simplifies to 1/6.
• For 5% VAT: 5 / 105, which simplifies to 1/21.
• For 10% VAT/GST: 10 / 110, which simplifies to 1/11.

These fractions are incredibly powerful tools for quick, manual business calculations.

Extracting 20% VAT Using the 1/6 Rule

If you want to find VAT in a figure where the standard rate is 20%, you simply divide the gross figure by 6, or multiply it by 1/6.

• Formula: Gross Amount / 6 (or Gross Amount * 0.16667)
• Scenario: You have a receipt for £72 and want to know exactly how much VAT you paid.
• Calculation: £72 / 6 = £12
• Result: The exact VAT amount is £12. (You can verify this: if VAT is £12, Net is £72 - £12 = £60. £60 * 20% = £12. The math is flawless!)

Extracting 5% VAT Using the 1/21 Rule

If you need to extract a 5% reduced VAT figure directly from a gross invoice, divide the gross total by 21.

• Formula: Gross Amount / 21
• Scenario: A commercial utility bill displays a gross total of £210, subject to 5% VAT.
• Calculation: £210 / 21 = £10
• Result: The VAT element of the bill is exactly £10.

Using fractions is the fastest way to take out VAT from a figure when preparing spreadsheets, conducting auditing checks, or building quick mental estimates.

5. Adding VAT to a Figure (The Standard Net-to-Gross Formula)

While our main focus is removing or extracting VAT from a total, completeness requires us to briefly cover the inverse operation: adding VAT to a net figure. This is highly straightforward, but still requires the correct decimal multiplier.

To calculate a gross figure from a net base, use the following formula:

Gross Amount = Net Amount * (1 + (VAT Rate / 100))

• To add 20% VAT: Multiply the net figure by 1.20.
  • Example: £50 net * 1.2 = £60 gross.
• To add 5% VAT: Multiply the net figure by 1.05.
  • Example: £50 net * 1.05 = £52.50 gross.
• To add 10% GST: Multiply the net figure by 1.10.
  • Example: $50 net * 1.1 = $55 gross.

By keeping these two operations clear—dividing by 1.2 to take VAT off, and multiplying by 1.2 to add VAT on—you can confidently navigate any invoicing standard with ease.

6. How Rounding Rules Impact Your Calculations

When calculating VAT figures, you will frequently encounter long decimal outputs. For example, if you divide a gross total of £100 by 1.2 to remove standard 20% VAT, your calculator will show 83.3333333...

Because currencies only deal in two decimal places (pence, cents, etc.), you must apply rounding rules. However, rounding incorrectly can lead to discrepancies between your invoices, your digital accounting software, and your tax declarations.

The Standard Rounding Principles

Most tax authorities, including HM Revenue and Customs (HMRC), provide strict guidance on how to round VAT calculations. The general rules are:

1. Work with maximum precision during intermediate steps: Do not round numbers too early in your calculation sequence. Perform all your multiplication and division first, and only round the final VAT figure.
2. Round to the nearest penny/cent: If the third decimal place is 5 or higher, round up. If it is 4 or lower, round down. For example, £83.333 rounds down to £83.33, while £83.336 rounds up to £83.34.
3. Consistency is key: Whichever direction you choose to round fractional units (e.g., always rounding down to benefit the consumer, or rounding to the nearest half-penny), you must apply this methodology consistently across all invoice line items. Commercial invoicing systems usually automate this, but when calculating manually or setting up custom spreadsheets, you must ensure your formulas mirror these rules.

7. Summary Cheat Sheet: Quick Reference Formulas

Keep this cheat sheet handy for your day-to-day calculations. It contains everything you need to solve any puzzle regarding a VAT figure:

Frequently Asked Questions (FAQ)

How do I take VAT out of a figure quickly in Excel?

To take VAT out of a gross figure in Microsoft Excel or Google Sheets, write a simple formula pointing to the gross cell. If your gross figure is in cell A1 and your standard VAT rate is 20%, enter =A1/1.2 in cell B1 to find the net. To isolate just the VAT portion directly, enter =A1-(A1/1.2) or =A1/6.

What is a VAT fraction and why does it work?

A VAT fraction is a mathematical ratio used to extract the tax portion directly from a gross amount. Because standard 20% VAT means the gross total is 120% of the net price, the tax portion represents 20 out of 120 parts. Simplifying the fraction 20/120 gives you 1/6. This means exactly one-sixth of any standard VAT gross total is tax.

Can I just multiply the gross amount by 0.20 to find the VAT?

No. This is a critical mistake. Multiplying the gross figure by 0.20 calculates 20% of the tax-inclusive price, which is too high. You must divide the gross figure by 1.2 to find the net, or divide by 6 to find the correct VAT amount directly.

Does the same math apply to sales tax and GST?

Yes. The exact same formulas apply to sales tax, Goods and Services Tax (GST), and any other tax-inclusive systems. Simply substitute the local rate into the standard reverse formula: Gross / (1 + (Rate / 100)). For instance, Canadian GST at 5% uses a divisor of 1.05, while NZ GST at 15% uses a divisor of 1.15.

How do I deduct VAT if the rate is 17.5% or 15%?

If you are auditing historical records from years when standard VAT was 17.5% or 15%, you must adjust your divisor. For 17.5% VAT, divide the gross figure by 1.175. For 15% VAT, divide the gross figure by 1.15.

Conclusion

Calculating, isolating, or removing a VAT figure doesn't have to be a complicated mathematical puzzle. By discarding the instinct to simply subtract percentages and using division instead, you ensure that your business numbers remain 100% accurate. Keep the reverse VAT divisors (such as 1.2 for standard rates) and the VAT fractions (like 1/6) close at hand, and you will never struggle with invoice math again. Clean calculations lead to painless book-keeping, reliable financial reporting, and total confidence when tax season arrives.