Office software, documents & open source in South Africa
Partner story

Automate SARS VAT 201 in Excel

19 November 2026

For many South African businesses, the monthly task of preparing and submitting the VAT201 return to SARS is a time-consuming process that often involves manual data entry and reconciliation. While the VAT201 return can be completed electronically through SARS' eFiling system, the process is still largely manual, with businesses often using Excel spreadsheets to prepare the return before submitting it to SARS. However, by automating the VAT201 process in Excel, finance teams can save time, reduce errors, and streamline the process.

What SARS requires for completing and submitting VAT201

When it comes to completing the VAT201 return, SARS has specific requirements for both the content of the return and the process for submitting it. Here are the key requirements:

  • The VAT201 return must be submitted electronically through the eFiling system.
  • The VAT201 return is requested in eFiling by selecting Returns, then Returns Issued, then Value Added Tax (VAT201).
  • The VAT201 return is an editable declaration for the selected tax period that can be saved for later editing before submission.
  • The return is automatically processed by SARS after submission through eFiling once all required fields are captured.

Which VAT201 fields are most important for Excel-based preparation

When preparing the VAT201 return in Excel, there are several key fields that businesses need to focus on. These fields include:

Field 4A: Calculated as Field 1A × (r / (100 + r))

Fields 14 and 15: Input tax claimed on capital and other goods and/or services supplied to you and charged with VAT at 15%

These fields are important because they require calculations and reconciliation with the business's accounting records. Field 4A must equal Field 1A × (r / (100 + r)), while Fields 14 and 15 require the business to claim input tax on capital and other goods and/or services supplied and charged with VAT at 15%.

How an Excel workflow can assemble, reconcile, and review the return

To automate the VAT201 process in Excel, finance teams can create a workflow that assembles, reconciles, and reviews the return. Here are the key steps:

1. Assemble the data: Use Excel's data import features to pull in relevant data from accounting systems, such as invoices, income statements, and balance sheets.

2. Reconcile the data: Create formulas to reconcile the data with the VAT201 fields, such as calculating the output tax on supplies and the input tax on capital goods and imports.

3. Review the data: Use Excel's data validation and error-checking features to ensure that the data is accurate and complete.

4. Generate the VAT201 return: Use Excel's reporting features to generate the VAT201 return, including all required fields and calculations.

What direct submission or automation tools can and cannot do

While tools like Sage and Automize offer direct submission of VAT201 returns to SARS, there are limitations to what these tools can do:

Sage enables users to prepare, submit, and track VAT 201 declarations through direct integration with SARS, while Automize can automate return submissions using OAuth 2.0 client credentials.

They cannot automate the review process. Finance teams must still review the data and ensure its accuracy and completeness.

Practical setup steps, limitations, and approval controls for SARS eFiling use

To use SARS eFiling to submit the VAT201 return, finance teams must follow these practical steps:

1. Activate the VAT eFiling workflow through an ISV setup in SARS eFiling.

2. Ensure that the accounting system is properly configured to export the required VAT201 fields.

3. Review the VAT201 return in the accounting system before submitting it to SARS.

4. Submit the VAT201 return through the eFiling system.

5. Ensure that the VAT201 return is submitted by the due date.

However, there are limitations to using eFiling for VAT201 submission:

Finance teams must still manually review and approve the VAT201 return before submitting it.

VAT 201 submissions made between 06:00 and 18:00 are queued and processed after 18:00, while submissions made between 18:00 and 06:00 are processed immediately.

The eFiling system may not always provide clear error messages or guidance on how to correct errors.

To address these limitations, finance teams can implement the following approval controls:

Implement a dual-approval process, where two authorized users must review and approve the VAT201 return before submission.

Set up email alerts to notify finance teams of any errors or issues with the VAT201 submission.

Implement a backup process, such as manual submission, in case of eFiling system issues.

By automating the VAT201 process in Excel and using eFiling for submission, South African finance teams can streamline the process, reduce errors, and save time. However, it's important to understand the limitations of the tools and to implement proper approval controls to ensure the accuracy and completeness of the VAT201 return.

Read also