Guide

How to calculate VAT manually in South Africa (with worked examples)

Add or remove 15% VAT by hand, work back from a VAT amount, avoid the most common mistake, and get rounding right — with formulas for spreadsheets too.

How we made this: Explains the arithmetic of VAT at South Africa's 15% standard rate. It is general information, not tax advice; confirm the rules that apply to you with SARS or a registered tax practitioner. Editorial policy.

South Africa’s standard VAT rate is 15% (since 1 April 2018). The maths is simple once you know which direction you’re going — and there’s one mistake almost everyone makes at least once.

Short on time? Use the free South Africa VAT calculator. It does all three calculations below and shows the working.

Adding VAT (exclusive → inclusive)

Use this when you have a price before VAT, for example when preparing a quote.

Formula: inclusive = exclusive × 1.15

Example: a service costs R2,400 excluding VAT.

  • VAT = R2,400 × 0.15 = R360
  • Inclusive price = R2,400 × 1.15 = R2,760

Mental shortcut: 15% is 10% plus half of 10%. For R2,400: 10% is R240, half of that is R120, so the VAT is R240 + R120 = R360.

Removing VAT (inclusive → exclusive)

Use this when a price already includes VAT, such as a till slip or a retail price.

Formula: exclusive = inclusive ÷ 1.15

Example: you paid R1,150 including VAT.

  • Exclusive amount = R1,150 ÷ 1.15 = R1,000
  • VAT included = R1,150 − R1,000 = R150

To find just the VAT portion, use inclusive × 15 ÷ 115. That fraction simplifies to 3/23, which is handy without a calculator: R1,150 ÷ 23 = R50, and × 3 = R150.

Working back from the VAT amount

Sometimes you only know the VAT, for example from a slip that shows only the VAT total.

Formula: exclusive = VAT ÷ 0.15, and inclusive = exclusive + VAT

Example: the VAT was R45.

  • Exclusive = R45 ÷ 0.15 = R300
  • Inclusive = R300 + R45 = R345

The most common mistake

Taking 15% off an inclusive price:

  • Wrong: R1,150 × 0.15 = R172.50
  • Right: R1,150 × 15 ÷ 115 = R150

VAT was calculated on the smaller, exclusive amount, so you reverse it by dividing by 1.15. Subtracting 15% removes too much.

Quick reference table

ExclusiveVAT (15%)Inclusive
R100.00R15.00R115.00
R500.00R75.00R575.00
R1,000.00R150.00R1,150.00
R8,695.65R1,304.35R10,000.00

Rounding to the cent

Round the VAT to the nearest cent, then work out the other figure from it so the three numbers add up. Removing VAT from R100:

  • VAT = R100 × 15 ÷ 115 = R13.0435… → R13.04
  • Exclusive = R100 − R13.04 = R86.96

On invoices with several lines, rounding each line can give a slightly different total from rounding once at the end. Three lines of R33.30 excl. VAT:

  • Per line: R33.30 × 0.15 = R4.995 → R5.00, so the VAT adds up to R15.00
  • On the total: R99.90 × 0.15 = R14.985 → R14.99

Neither is wrong, but be consistent. Accounting software applies one rule throughout, which is one reason VAT vendors often use it — see accounting tools and invoicing tools.

In a spreadsheet

With the amount in cell A2 and the rate (15) in B2:

To getFormula
VAT on an exclusive amount=ROUND(A2*B2/100, 2)
Inclusive from exclusive=A2+ROUND(A2*B2/100, 2)
VAT inside an inclusive amount=ROUND(A2*B2/(100+B2), 2)
Exclusive from inclusive=A2-ROUND(A2*B2/(100+B2), 2)
Exclusive from a VAT amount=ROUND(A2*100/B2, 2)

Keeping the rate in its own cell means a future rate change is a one-cell edit.

Next steps

This guide explains arithmetic only and is not tax advice. Tax rates and rules can change. Verify current requirements with SARS or a qualified tax professional.

Frequently asked questions

What is the formula to add 15% VAT?

Multiply the VAT-exclusive amount by 1.15. The VAT on its own is the amount × 0.15.

What is the formula to remove 15% VAT?

Divide the VAT-inclusive amount by 1.15 to get the exclusive amount. The VAT included is the inclusive amount × 15 ÷ 115 — or, equivalently, × 3 ÷ 23.

How do I find the price from the VAT amount?

At 15%, divide the VAT by 0.15 to get the exclusive amount, then add the VAT back for the inclusive total. R150 VAT means R1,000 excl. and R1,150 incl.

Do I have to charge VAT?

Only registered VAT vendors charge VAT. Whether you must or may register depends on your turnover and circumstances. Check the current registration rules on the SARS website or ask a tax practitioner.

Tools mentioned

Xero

Accounting

Cloud accounting software for small businesses and their accountants. It handles invoicing, bank reconciliation, bills and financial…

Main use
Day-to-day bookkeeping
Free plan
Not yet verified
Pricing
Not yet verified
Last reviewed
Not yet reviewed
SA-relevant

Sage Accounting

Accounting

Sage’s cloud accounting product for small businesses. Sage is a long-established name in South African business software, and the product…

Main use
Bookkeeping for small businesses
Free plan
Not yet verified
Pricing
Not yet verified
Last reviewed
Not yet reviewed
SA-relevant

Zoho Invoice

Invoicing

A dedicated invoicing app from Zoho for creating quotes and invoices, tracking payments and sending reminders — a lighter option than…

Main use
Invoicing clients as a freelancer
Free plan
Not yet verified
Pricing
Not yet verified
Last reviewed
Not yet reviewed

Comparisons

Side-by-side pages for tools covered here.

You may also need

Free tools and pages that help with the same job.

Explore categories