SAP Implementation for VAT

Written by Richard Cornelisse and Robbert Hoogeveen

For nearly every company, the accuracy and efficiency of local-country VAT compliance is nearly completely dependent on the functionality of the underlying ERP system. Operational malfunctions in a system that is used to manage VAT compliance can lead to substantial financial risks.

There are countless examples of the mismatching of VAT treatment of purchases and sales in chain transactions, double payments of VAT and “forgotten” manual adjustments to the VAT filing, all attributable to shortcomings in SAP’s automated VAT solution.

Errors in the basic VAT configuration of ERP systems can also carry consequences for an organization. Without the proper VAT rules, many systems are incapable of processing transaction information correctly, so that transactions may become blocked. This has a great impact on logistics processes, invoicing processes and financial processes.

Tax and financial departments are under increasing pressure to reduce the costs of compliance processes. One result of this is the increasing transfer of VAT-relevant processes from national tax supervision to Shared Service Centers.

These Shared Service Centers are not generally manned by tax specialists. They trust the functionality of the group’s ERP system to determine, calculate and report local VAT.

SAP introduction

The SAP VAT determination logic was developed a long time ago (1980’s) and except for the “plants abroad” logic SAP’s VAT determination logic has not changed much. This in contrast with the VAT rules and business models as these have changed significantly.

SAP historical final

As a result, there has been a huge increase in the complexity for the SAP system to meet all VAT requirements, which leads to necessary modifications to the standard SAP VAT for many multinational businesses.

Modifications of already very complicated SAP systems create a risk for maintenance and half-hearted solutions. At the same time, tax authorities across the world both sharpen their focus on non-compliant taxpayers and increase their focus on reviewing ERP systems as a source of VAT compliance risks.

Businesses have to ensure that the VAT determination logic in the SAP systems is correct, easy to implement and remains VAT compliant.


Distinguishing capability

The added value often needed is the capability to free up resources, reduce manual activities and manage risks. Important is besides practical experience and understanding of both SAP’s possibilities, and its its limitations.

With respect to the possibilities, we can express the wishes to the external SAP consultant in his own language and we can demonstrate how these can actually be achieved in SAP.

In practice, we note that certain functionality intended for the support of indirect tax objectives does not get used – due either to reluctance (not within budget) or to a lack of knowledge in this area (e.g. activating plant abroad functionality and understanding impact on current SAP set up).

From an indirect tax standpoint, the realization that you are part of a larger team in which each of the participants has other priorities is key. This means that effective communication and agreements are essential. Instructions must be understandable and so short and compact that they can also be used as a reference framework and material for the tests.

In practice, Excel is often used to record all transactions and to indicate what the VAT treatment, etc., should be for each transaction individually. This cannot be imported and is difficult to evaluate for this reason. Moreover, the use of Excel carries the risk of making copy/paste errors.

The question is: what is the best format for providing instructions to other workstreams and for making the test phase efficient and effective? It turns out in practice that ‘decision trees‘ are a particularly effective communication resource with the IT consultant.

SAP has its limitations and not all transactions can be implemented in the systems in an automated fashion.

  • For example, in the standard configuration, it is not always possible to have SAP automatically determine the VAT treatment of chain transactions within a concern or with third parties (3 parties or more)
  • Solve the actual problem not a SAP VAT symptom

2 Simplified Triangulation

Customer Pick Up

service tax groups

Hard coding predefined VAT treatments

One of the solutions is to work with assumptions and to implement these in the system (hard coding of transactions via a predefined VAT treatment). This means that a VAT treatment is no longer deduced using information present in the system.

Assumptions may be incorrectly implemented during the actual execution or may undergo a change after “going live.” An incorrect VAT treatment is the potential risk. If such solution is used, periodic audits as detective control need to be set up since the risks at hand will likely exceed the company’s risk tolerance.

This results in extra man-hours, representing additional costs due to rework and retrospective corrections.

“An important question to raise for sound business decision process is what tools are available in the market for still achieving full automation without making use of assumptions and determine the VAT treatment on real time data in the system:  SAP add-on for VAT.”

Maintenance after go-live

The indirect tax objective of an SAP implementation should not be only that everything functions at the moment of “going live,” but that the maintenance and logic of the structure and the persistence of that logic in case of changes have been considered.

An example

  • In a given country, tax code VI is used for the standard VAT rate at the moment of “going live.” This means that a print can be made of the standard VAT rate used in various countries using the simple tax code selection, essential for monitoring the function and for the selection of the proper tax code for AP coding.
  • If a rate increase occurs, a tax code for the new standard rate must be created – VD, for example – one that deviates from the chosen standard. VAT rate increases are a worldwide trend and the result is that the logic of the tax code structure will no longer be present after the increase. This increases the chance of errors when selecting the correct tax code.
  • So the question is: how do you implement the rate changes in SAP without this having an impact on the logic of your tax code structure?: Tax Code Structure always remains the same

Examples of possible errors in SAP

  • Not making use of the proper partner functions in SAP for a supplier who provides services in multiple countries and invoices VAT locally. Result: the standard VAT calculation generates incorrect results.
  • Missing/improper VAT registration numbers in customer master data, such that invoicing requirements are not satisfied for cross-border transactions.
  • Master data is adjusted and tested in the test environment, but the changes are not included in the final upload to the production system.
  • The logic of the tax code structure is disrupted by VAT rate changes, something that could have been prevented using the SAP configuration.
  • When performing reverse charge bookings, VAT rate changes do not get changed.
  • For cross-border A-B-C transactions (goods are sold twice but only are shipped once), a VAT mismatch between the VAT on procurement and the VAT on sales arises for party B.
  • Blocked so-called iDoc (electronic interface documents) because of errors in the OBCD design.
  • Suppliers with invoices in other currencies and the VAT amount in Euro, so that the booked VAT amount is incorrect due to an incorrect exchange rate.
  • Incorrect derivation of VAT registration numbers for cross-border transactions caused by incorrect SAP configuration.
  • Analytics: Gain real hindsight, insight and foresight
  • Automated Controls: SAP Integrated VAT Control Framework

Template for SAP implementation roadmap

SAP implementation

See Forum

About Richard Cornelisse

I advise multinational businesses in improving the efficiency and effectiveness of their Indirect Tax Function and Tax Control Framework. I started my 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 I am a senior managing director of Phenix Consulting. I have over 20 years’ experience advising clients on international VAT issues. I am specialized in the tax aspects of financial transformations, shared service centre migration, and post merger integration work. I am also somewhat of a mentor, giving back to the profession. If you are interested in conversation and discussion, please feel free to contact me.
This entry was posted in Automating complex VAT flows in SAP, Control Framework, enhancement implementation, SAP add on, SAP enhancement point, SAP for VAT, SAP implementation, user exit, VAT automation, VAT Control. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s