Written by Richard Cornelisse


More than 80% of businesses are still using spreadsheets to manage their VAT compliance in at least one jurisdiction in which they operate, despite tax authorities around the world investing in better tools

Richard H. Cornelisse:

Many multinationals run various versions of ERP systems or legacy systems without harmonization. The ERP set-up is often per business unit and thus multiple set ups per country are possible. This could be the root cause that:

  • running of system's exception reports to look for missed opportunities, underclaimed VAT and potential fraudulent transactions is still a challenging exercise
  • a lot of manual (re)work is often needed to file the VAT reporting and reconcile the VAT numbers due to the use of multiple spreadsheets and various data sources (divisions, different systems)

Inherent risks The latter is interesting as spreadsheets are usually found at critical points in the audit trail. And are often designed by non-specialists with no system expertise. A spreadsheet formula error could result in substantial tax exposures. A spreadsheet has as advantage that the user is able to transform the data in the right format with some modifications such as adding extra  columns, or calculations, or descriptions, etc. However, as soon as the data goes into a spreadsheet the data will bear certain inherent risks.

Spreadsheets are difficult to analyze and the amount of data presented can give cause to misinterpretation and historical data can get lost when spreadsheets are updated. Performing a trend anlysis or data comparison will be a challenge.

With human error added into the equation, some defects are going to occur. If the tax function only has MS Excel to perform data transformation to make the data tax ready, the volume of procedures and controls will have to be significantly greater. The problem is that in Excel altered data can lose its audit trail back to its source: mismatches with a companies ERP system. A point of attention as ERP data is the source of truth by the tax authorities (e.g. e-audits such as SAF-T).

What should be considered from an audit defense?

The SAF-T standard, originally created by the OECD (similar as BEPS), is intended to give tax authorities easy access to the relevant data in an easily readable format for bot corporate income tax as VAT. This leads to much more efficient and effective tax inspections. Data analytics will become the most efficient and effective way of future tax auditing.

From the chapters: ERP systems and tax engines and Tax authorities peeking at your data

Be operationally efficient


Hidden factory or hidden operation definition: the rework and cover ups, the hours and days of wasted time in a company of people who constantly correct mistakes (unnecessary rework). The objective is to make the hidden factory visible (measure/calculate ROI) and as result returns precious time and money to the business. It is about extra man-hours, additional costs due to rework (credit/debit notes) and retrospective corrections and/or disclosures. Example: how much rework is required before numbers received from finance systems can be used?

Does the process of preparing and compiling the client’s VAT return take more than 5 man days? (starting from the moment of VAT-data collection until the VAT return is approved and filed).

During assessment of any solution determine the amount of increase of workforce efficiency, how much rework is avoided, risk exposures are decreased but as well how visibility and awareness are improved by which the tax function is able to set better priorities. The objective is to make the hidden factory visible (measure/calculate ROI) and as a result, return precious time and money to the business.

Research by PwC recently conducted of 100 manufacturing companies revealed that three-fourths (74 percent) of organizations surveyed don’t have a tax technology strategy in place – nor plans to develop one — and even fewer have thought about adding the use of data analytics to their tax function. Almost three-quarters (73 percent) said they don’t have a dedicated tax technology role in their organizations.

Benchmarking yourself against your peers

Click to enlarge

Arguments for VAT automation

Relevant chapters

  1. When is standard SAP (in)sufficient?
  2. Everything you always wanted to know about VAT in SAP * but were not aware to ask
  3. Tax engines questions to ask before you commit
  4. Indirect tax risk management
  5. Building blocks of a VAT control framework
  6. Reporting
  7. BEPS and Indirect Tax

Written by Richard Cornelisse
 Richard LinkedIn

Richard advises multinational businesses in improving the efficiency and effectiveness of their Indirect Tax Function and Tax Control Framework.

He started his career as a manager at Arthur Andersen and then became a partner in EY where I led the indirect tax performance team for Netherlands and Belgium. Currently he is a senior managing director of Phenix Consulting.

Richard has over 20 years’ experience advising clients on international VAT issues. He is specialized in the tax aspects of financial transformations, shared service centre migration, and post merger integration work. Richard is also somewhat of a mentor, giving back to the profession. If you are interested in conversation and discussion, please feel free to contact him.

Embrace new technologies and catch up: automate workflow, document management, calendaring and internal controls

Click to enlarge U2Presentation20160330 1

Compliant tax software solutions for the global management of tax processes

In essence, HRMC’s increases its expectations towards large businesses with regard to a more and more transparent tax management strategy. However, the publication of a tax strategy will clearly not be sufficient. It is just the starting point for the provision of a clear picture about the risk management and controls in place of tax relevant processes. The daily management turns on the radar.

State-of-the-art tax compliance management software is required.

In difference hereto, the view into the current daily practice provides a different and non-compliant picture:

Widespread use of Excel spreadsheets, decentralized storage of tax relevant documents, lack of documented controls, lack of automation, global lack of tax compliance software tracking individual changes and filings, lack of standardized reports immediately available upon request, lack of in-built double-checks for the calculation of current and deferred taxes on reporting entity level, lots of tax relevant data stored at external outsourcers (e.g. external tax advisors and accounting firms), several tax software tools in place at various locations which are neither interfaced among each other and with the ERP systems in place, etc.

It is obvious that tax departments which are not adapting its process management to the requirements addressed by HMRC and other tax authorities may struggle with regard to compliance, efficiency and transparency.

Therefore, compliant tax software solutions for integrated tax management like the U² software from Universal Units become more and more important

U2 products

This email address is being protected from spambots. You need JavaScript enabled to view it.

Phenix Consulting - our services - team - network