Continuously monitor VAT transactions and configurations

There are few things as important to a Chief Financial Officer as reliable and accurate data. It’s what keeps  the business moving onwards and upwards into risk free profits and greater growth. As Tax Authorities  explore compulsory requirements for VAT  submissions and audits we find ourselves sinking deeper and  deeper into the ever-growing pit of data our business produce. To make it even worse, Tax Authorities are  avidly adopting data analytics in-house which specifically target indirect tax risk indicators. The result? Penalties. All of which is avoidable with the correct solution in hand

ACL has the solution for you

Structure & Configuration

The Structure and Configuration module focuses on accuracy of master data that relates to VAT setup and the ERP environment of the company. It allows you to gain insight into items such as tax coding setup.

Transactional Data Quality

This module tests various aspects of the transactional data with specific reference to VAT rules and the implementation of the master data tables and rules initially tested in the configuration module.

Submission Readiness

Similar to Transactional Data Quality module, transactional data is tested in this module but with a specific focus on those that ultimately populate and affect line items in the VAT return or IT14SD.

Compliance & Documentation

Compliance and Documentation was developed to ensure that the relevant compliance checks are done on a monthly basis prior to the submission of the VAT return.


Time of VAT supply rules for both Input VAT and Output VAT are specifically analyzed in this module.

Our customers are our strongest advocates

The ACL team spent many hours with us to understand our tax environment & correctly map our data. ACL technology gave us confidence & allowed us to improved existing controls & processes.

Continuous monitoring provides value to the organisation through the provision of continuous insight and  assistance within the tax environment. Using a best practice risk and control matrix, transactions are  proactively monitored and you’re notified of any issues allowing you to know about problems such as VAT  leakages, incorrect cost allocations or data issues of month end and the VAT submission report.

Connect To Any Data Source

Access and consolidate data from all of your sources. A billion records from your ERP system? Spreadsheets? Unstructured report PDFs? No problem. No other tool can access any data as economically as ACL Analytics

Data Visualisation

Visually detect patterns and share. Explore and build a better understanding of your data by creating interactive visualizations that can be shared with stakeholders to tell your story.

Independent. Provable. Repeatable

Your entire data set is protected in read-only format. Every analytic step is recorded to provide assurance and repeatability.

Automate Recurring Analysis

Automate those manual tasks. Recurring analysis can be easily automated to free up time and ensure analysis is consistently performed every time.

What can you test?

  • Extract a complete list of tax codes & their descriptions for review.
  • Extract whichtax codes are automatically assigned to general ledge accounts.
  • Extract a listing of ERP company codes &related VAT registration numbers.
  • Providea listing of all vendors VAT numbers using SARS algorithm.
  • Test for duplicate VAT numbers but for vendors with different names.

  • Tax codeusage analysis –by general ledger account.
  • Listing manual journals posted to the input & output VAT accounts.
  • Recalculationof VAT on transactions for consistency with VAT codes.
  • Output & input VAT amounts recalculated & compared to what was cleared to VAT control per VAT period.
  • Identity transactions which have standard ratedVAT codes but do not have an input or output VAT posting.
  • Identify duplicate input VAT postings based onamount & invoice number.
  • Keyword search for disallowed input VAT items but which have been claimed.
  • Transactions whichare inconsistent with the VAT status of the vendor.
  • Output VAT not declared onsundry income.
  • Trend analysis of the past year output VAT per VAT control account by VAT period.
  • Trend analysis of the past year input VAT per VAT control account (VAT return) by VAT period.
  • Trend analysis of the past year manual journals posted to the VAT control account by VAT period.
  • Comparison of revenue to grossed up output VAT amount per VAT period.
  • Revenue GL account analysis by VAT code.
  • Capital expenditure email notification.
  • Imported goods and services email notification.
  • Email notification when a manual journal is posted directly against the VAT control account.
  • VAT control account reconciliation to payments to SARS.
  • Late payments made to SARS.
  • Document check for sample of 10 high-value input VAT supplies for the selected VAT period.
  • Complete listing of input VAT transactions for the purposes of a VAT review or audit.
  • Keyword search of exempt supplies which have not been coded as such.
  • Dates & VAT period analysis of expenses (invoice basis not payment basis)
  • Age analysis of time lag between invoice date and capture date.
  • Prepaid expenses without input vat recognized.
  • Prepaid expenses cleared to income statement with an input VAT leg.
  • VAT control account analysis for aged items.
  • Output VAT not declared on income received in advance.