How to Add VAT in South Africa
Adding Value-Added Tax manually is straightforward when you apply the standard SARS 15% vat calculation formula.
The Add VAT Formula
Total = Amount × 1.15
This is the standard formula to add VAT. The 1.15 multiplier represents 100% of the price plus 15% VAT. Using this formula guarantees a highly accurate result.
Step by Step — Adding VAT
- Take your original price before VAT.
- Multiply by 1.15 (which adds 15%).
- The result is your VAT inclusive price.
Worked Example — Adding VAT
Example: Invoice for R2,500 before VAT
Calculation: R2,500 × 1.15 = R2,875
VAT amount: R2,875 − R2,500 = R375
You start with a base value of R2,500. By multiplying it by 1.15, you add the 15% VAT correctly. The final invoice amount is R2,875.
How to Remove VAT in South Africa
The Remove VAT Formula
Amount excl VAT = Total ÷ 1.15
This formula works in reverse to find the original amount. Dividing by 1.15 safely unbundles the 15% tax.
Common Mistake
Do not multiply by 0.85, as that gives the wrong answer. You cannot subtract 15% directly.
Step by Step — Removing VAT
- Take the total amount that includes VAT.
- Divide that total amount by 1.15.
- The result is the price before VAT.
Worked Example — Removing VAT
Example: Receipt shows R3,450 including VAT
Calculation: R3,450 ÷ 1.15 = R3,000
VAT amount: R3,450 − R3,000 = R450
The total receipt value is R3,450. You divide this amount by 1.15 to strip away the tax. The price excluding VAT is precisely R3,000.
How to Calculate VAT in Excel
Excel Formula to Add VAT
=A1*1.15
Type this formula into any blank cell. It references your original amount in cell A1. The result will instantly include the 15% VAT. This works perfectly for fast invoicing.
Excel Formula to Remove VAT
=A1/1.15
Place this formula in an adjacent cell. It takes the total VAT inclusive amount in cell A1. The formula removes the tax and shows the bare price.
Excel Formula for VAT Amount Only
=A1*0.15
Use this if you only need the tax portion. It calculates 15% of the base amount in cell A1. The result displays the specific VAT paid or charged.
VAT Registration in South Africa
When Must You Register for VAT?
- Turnover exceeds R2.3 million in 12 months — compulsory registration.
- Turnover exceeds R120,000 — voluntary registration allowed.
- Must register within 21 days of crossing threshold.
- Late registration results in SARS penalties.
Important Note
It is crucial to monitor your business turnover carefully. If you hit the R2.3 million mark, registration becomes mandatory. Voluntary registration can benefit businesses claiming large input VAT. Ignoring these rules invites severe legal and financial penalties. For a complete step-by-step walk-through, see our guide on VAT Registration South Africa.
Common VAT Mistakes to Avoid
1. Missing VAT Filing Deadlines
SARS sets strict deadlines for bi-monthly VAT returns. Filing your return late will automatically trigger financial penalties. You also risk accumulating interest on unpaid amounts. Always mark the 25th or the final business day on your calendar.
2. Misclassifying Zero-Rated Items
Not all goods carry the standard 15% VAT rate. Basic foodstuffs like brown bread are zero-rated. Applying 15% to zero-rated goods throws off your entire tax return. Keep a clear list of what qualifies under SARS guidelines. See our complete zero-rated food list.
3. Not Claiming Input VAT
Businesses often forget to claim taxes paid on business expenses. Input VAT reduces the final amount owed to SARS. You must retain valid tax invoices for five years. Losing these invoices means you leave money on the table.
4. Incorrect VAT Calculations
Many people incorrectly subtract 15% to find the exclusive price. The correct method is to always divide by 1.15. Mathematical errors result in underpaid tax or angry customers. Always double-check your numbers or use an online tool.
5. Poor Record Keeping
Tax records must be stored safely for five years. SARS officers can request an audit at any time. Clean, organized files make the entire review process simple. Sloppy paperwork creates huge headaches and invites deeper investigations.
Frequently Asked Questions
How do I calculate 15% VAT in South Africa?
Multiply the amount by 1.15 to add VAT. To find just the VAT amount, multiply by 0.15.
What is the formula to remove VAT?
Divide the total amount by 1.15. This gives you the original price exclusive of VAT.
How do I calculate VAT in Excel?
To add VAT, use =A1*1.15. To remove it, use =A1/1.15 in your spreadsheet.
When must I register for VAT?
Registration is mandatory when turnover exceeds R2.3 million annually. Voluntary registration starts at R120,000.
What is the difference between zero rated and VAT exempt?
Zero-rated items are taxable at 0%, allowing input VAT claims. Exempt items fall outside the VAT system entirely.
How often do I submit a VAT return?
Returns are usually submitted every two months. You can file these directly through SARS eFiling.
Related VAT Guides
