• Christian Krämer, Expert |

Overly manual processes make documentation a time consuming and expensive matter. Technology can provide a solution to this problem by automating (parts of) these processes. However, companies first need to look at where automation really benefits them – there is no “one size fits all” solution.


In recent years, global groups have had to fulfil more and more documentation requirements in order to comply with local legislation. This worldwide trend is mainly propelled by OECD’s Base Erosion and Profit Shifting framework (BEPS), which aims to guarantee increased tax transparency for multinationals by requiring additional documentation such as Country by Country Reporting. 

Since the preparation of documentation is quite resource intensive, the goal of tax functions must be to maximise the efficiency of the documentation process. Technology is the key to solving this problem by virtue of its ability to automate selected repetitive tasks.

Key aspects to consider

Although it sounds compelling, it is wrong to view automation as the unconditional solution to all problems. One still needs to create the right prerequisites to fully leverage the capabilities of automation and carefully consider which steps in the preparation process of documentation should be automated to ensure that a solution suitable for the purpose is implemented.

Understanding the process:
Before thinking about automating its TP documentation, companies first need to see the preparation of documentation as a process and completely understand the manual logic behind it (e.g. where exactly does the data come from, how is the data afterwards mapped?). Automation only pays off if there is a clear underlying logic; every exception from the general rule makes the process less efficient. 

Recognise which steps to automate:
The preparation of TP documentation is divided into six steps:

  1. Structuring the documentation into modules
  2. Creating a Master Template and list of information request
  3. Providing the information
  4. Processing the information
  5. Generating the reports
  6. Reviewing the documentation

To determine which steps in the process to automate, companies need to look at where they can replace the most manual and repetitive tasks.

One option is to solely automate the generation of the reports. In this scenario the data is manually transformed into the required form and merged into a Master Data File. Afterwards this information is fed into a Master Template to fill all placeholders.

Another option is to additionally automate the processing of information. In this case, the raw data (e.g. transaction data from the ERP system) is fed into the automation tool. Before generating the reports, the system processes the data according to predefined rules and converts it into the required format. To ensure a smooth processing of information, it is paramount for the company to understand the hitherto manual logics applied in preparing data for the TP documentation.

Automation shows its benefits best when combined with standardisation. Every deviation from a standard makes the system more complex, creates room for error and reduces the efficiency gains from automating a process. 

However, it is critical for companies to decide how to balance standardisation and localisation to know to which extent automation it generates added value. The more complexity in documentation and the more localisation to incorporate (different content for different jurisdictions) is required, the less benefit can be expected from automation. The stronger alignment of documentation regulations across jurisdictions that the BEPS project of the OECD has brought about is certainly helpful in this regard.

Further use:
One by-product of an automated compliance process is the Master Data File, which holds all relevant information used in the TP documentation process (e.g. transaction volumes, profitability of subsidiaries, etc.) in one place. As a consequence the review of the input data is simplified and the file additionally provides a holistic overview of the data used for documentation. 

This file can be used for further analytics. If there is already a solution in place which automates the data processing part. Such solution can often relatively easily be extended to more analytical topics. As the origin of these solutions is data analytics anyway, adding additional steps into the system to get further insights is not too complicated. 

One could for instance think of using the data for preparing other compliance documents such as the TP returns or Country by Country Reporting. Another expansion of the system could be a dynamic inter-company price-setting, where the system would be used to observe the profitability of different entities or products to adjust the IC prices prospectively.


By making use of technology, companies have the capability to automate parts of the process of preparing transfer pricing documentation. However, there are four things companies should bear in mind:

  • Understand the logic in the process of documentation preparation and accompanying repetitive tasks
  • Assess which steps in the process can be optimized by automation
  • Decide how to balance standardisation versus complexity and localisation
  • Determine if the system should be expanded by using data analytics

Our services and further information