Client Tool

VAT Schedule Builder

Upload your sales and supplier invoices and we'll build a VAT schedule — Output VAT and Input VAT, ready to export to Excel in the standard layout. Your invoices are processed entirely on your own device.

VAT Schedule Builder

Processed on your device

Upload sales invoices and supplier invoices — typed or scanned. Each is read entirely inside your own browser: nothing is uploaded to us or to any server. We pull the invoice date, invoice number, party name and total; where the invoice prints its own VAT amount we use that figure directly, and cross-check it against 15% of the total so a misread number gets flagged rather than silently exported. Because invoice layouts vary far more than bank statements, please check the extracted rows before you export — anything missing, mismatched, or that looks like a duplicate upload is flagged for you.

01 Business Details
Business name (for the schedule title)
Preparing this as
The exported schedule will start plain, straight at the VAT OUTPUT / VAT INPUT row, with no firm logo or letterhead.
VAT is calculated at South Africa's standard rate of 15%, assuming each invoice total already includes VAT.
02 Upload Invoices
Document type
Sales Invoices Output VAT
📄
Drop invoice PDFs here, or click to browse
Invoices you issued to clients
PDF · TYPED OR SCANNED · PROCESSED LOCALLY
Supplier Invoices Input VAT
📄
Drop invoice PDFs here, or click to browse
Invoices you received from suppliers
PDF · TYPED OR SCANNED · PROCESSED LOCALLY
Reading invoices…
02a No Invoices? Estimate From a Bank Statement
Important: SARS requires a valid tax invoice to claim input VAT (VAT Act, s16(2) read with s20) — a bank line is never sufficient documentation on its own, however this tool treats it. Every row added this way is marked as an estimate and cannot be filed as-is: it tells you which transactions to go and get invoices for. Once you have the invoice, delete the estimated row and upload the invoice above instead.
🏦
Drop bank statement PDFs here, or click to browse
Read once, split into likely output VAT (money in) and input VAT (money out)
PDF · TYPED OR SCANNED · PROCESSED LOCALLY
Reading statement…
03 Review & Correct

Click any cell to edit — including the VAT column, which overrides the printed or calculated figure. Rows with a warning icon are missing a field, have a VAT/total that doesn't reconcile at 15%, or look like a duplicate upload; hover the icon for details, and check these against the source invoice before exporting.

Output VAT — Sales Invoices Output VAT
0 invoices
Invoice Date Invoice Number Client Name Amount inc VAT VAT Amount
No sales invoices yet — upload above.
Input VAT — Supplier Invoices Input VAT
0 invoices
Invoice Date Invoice Number Supplier Name Amount inc VAT VAT Amount
No supplier invoices yet — upload above.
04 VAT Summary
Sales Invoices
0
Supplier Invoices
0
Total Output VAT
0.00
Total Input VAT
0.00
VAT Payable
0.00
05 Export
The Excel file follows the MNVA VAT schedule template: branded header, Output VAT and Input VAT side by side, live formulas for the VAT and totals, and a VAT Payable / Receivable line that updates if you edit any figure. Dates and amounts are formatted and the table is fully styled. The schedule grows to fit however many invoices you upload — every row keeps its formatting, and the totals and VAT Payable cover all of them on a single sheet.
A tool from MN Valuation & Advisory All processing happens in your browser — your files are never uploaded anywhere.

Need More Than a Schedule?

Let Us Handle Your VAT Submission

If you'd rather someone else prepare and file your VAT201, reconcile it against your books, or take on your bookkeeping entirely, our team can take it from here.

Book a Discovery Call    View Our Services