VAT Reporting in South Africa: Using Your Sales Data
Use sales data for VAT reporting in South Africa: split VAT-inclusive and exclusive amounts at 15%, reconcile totals and prepare figures for your return.
· 5 min read · Summarix team
To use your sales data for VAT reporting in South Africa, you need clean transaction records that show, for each sale, whether the amount is VAT-inclusive or exclusive and whether it is standard-rated (15%), zero-rated or exempt. From there, output VAT is a simple calculation, and the real work is reconciling your totals to your accounting system before your return is submitted. This guide shows the formulas and a practical checking routine.
The VAT basics you need for your data
- The standard VAT rate in South Africa is 15%.
- Output VAT is VAT you charge on your sales. Input VAT is VAT you pay on qualifying business purchases.
- Supplies can be standard-rated (15%), zero-rated (0%, but still a taxable supply, such as certain exports and basic foodstuffs) or exempt (no VAT, and generally no input VAT claim on related costs).
- Your return covers a tax period. Check your own period and due dates on SARS eFiling.
VAT-inclusive vs VAT-exclusive: the formulas
Most retail prices in South Africa are displayed including VAT, while many B2B systems store amounts excluding VAT. Mixing the two is the most common error in home-made VAT reports. Here are the formulas at 15%:
| You have | You want | Formula | Example |
|---|---|---|---|
| Exclusive amount | VAT | Exclusive × 0.15 | R1,000 × 0.15 = R150 |
| Exclusive amount | Inclusive amount | Exclusive × 1.15 | R1,000 × 1.15 = R1,150 |
| Inclusive amount | VAT | Inclusive × 15 ÷ 115 | R1,150 × 15 ÷ 115 = R150 |
| Inclusive amount | Exclusive amount | Inclusive ÷ 1.15 | R1,150 ÷ 1.15 = R1,000 |
Preparing your sales data
Export sales for the VAT period from your point-of-sale, e-commerce platform or invoicing system. Make sure each row has, at minimum:
- Invoice or transaction date (in the correct period).
- Invoice or order number, so you can spot duplicates.
- Amount, with a clear indication of whether it includes VAT.
- VAT treatment: standard, zero-rated or exempt.
- Status: paid, refunded, cancelled or credited.
Then clean it: remove test orders and duplicates, make sure refunds and credit notes are negative amounts, and check that dates are in one consistent format. Our data cleaning checklist covers these steps in more detail.
A worked example
Say your shop’s export for a two-month period shows the following (all amounts VAT-inclusive, as your till records them):
| Line | Inclusive total | VAT (× 15/115) | Exclusive |
|---|---|---|---|
| Standard-rated sales | R230,000 | R30,000 | R200,000 |
| Credit notes (standard-rated) | −R11,500 | −R1,500 | −R10,000 |
| Zero-rated sales | R40,000 | R0 | R40,000 |
| Total | R258,500 | R28,500 | R230,000 |
In this example, output VAT is R28,500. The zero-rated line still appears in total taxable supplies, but carries no VAT. Your return will also need input VAT from purchases, which is a separate dataset from your supplier invoices.
Useful checks to build into your VAT workbook
A few simple checks catch most errors before they reach your return. Add them as extra columns or a separate summary tab:
- Ratio check: for standard-rated lines, VAT ÷ exclusive amount should equal 0.15. Anything else points to a wrong rate or a mixed inclusive/exclusive row.
- Blank VAT treatment: count rows with no standard, zero-rated or exempt flag. The answer should be zero.
- Out-of-period dates: filter for dates before the first or after the last day of the period.
- Duplicate invoice numbers: a count greater than one usually means an export was run twice or a sale was captured in two systems.
- Rounding: calculate VAT per invoice and in total, and make sure the method matches what your accounting system does, because small differences add up over thousands of transactions.
Reconcile before you rely on the numbers
- Compare your export’s total sales to the sales figure in your accounting system for the same dates.
- Compare calculated output VAT to the VAT control account.
- Investigate any difference: common culprits are timing (orders placed on the last day but invoiced in the next period), missing credit notes and rounding across many small transactions.
- Check a sample of large invoices by hand.
- Keep the reconciliation with your records; SARS can ask for supporting documents.
Using reporting tools to speed this up
A spreadsheet with the formulas above works fine for many small businesses. If you do it every period, it helps to automate the summary: totals by VAT treatment, a month-by-month trend and a list of anomalies such as unusually large refunds. Summarix can take a CSV or Excel sales export, or a live read-only connection to your database, and produce a report with totals, charts and data-quality notes calculated by code from your file. It is a reporting aid, not a VAT submission tool: your accountant or eFiling remains the place where the return is done.
Upload a sales export and get totals, trends and data-quality flags in about a minute.
Free plan: 5 AI reports a month, no card needed.
Summary
Good VAT reporting starts with good sales data: every transaction dated, classified and marked inclusive or exclusive. Use 15/115 for inclusive amounts and 0.15 for exclusive ones, reconcile to your accounting system every period, and keep the working. For month-end habits that make this easier, see our month-end reporting checklist.
Frequently asked questions
How do I calculate VAT from a VAT-inclusive price in South Africa?
Multiply the inclusive price by 15 and divide by 115. For example, R1,150 × 15 ÷ 115 = R150 VAT, leaving R1,000 excluding VAT.
What is the difference between zero-rated and exempt supplies?
Zero-rated supplies are taxable at 0%, so the vendor can generally still claim related input VAT. Exempt supplies are outside VAT, and related input VAT generally cannot be claimed. Confirm specifics with SARS guidance or a tax practitioner.
Can I use my sales report instead of my accounting system for VAT?
A sales report is useful for checking and analysis, but your VAT return should be based on your accounting records. Reconcile the two and resolve any differences.
Where can I find official VAT information?
The South African Revenue Service publishes VAT guides and rules on sars.gov.za, and returns are submitted through SARS eFiling.