Case Study: CbCR Table 1

Home Services Digital Case Studies Case Study CbCR Table I

PROJECT

CONTACT

Automatic creation of CbCR Table I

Since the transitional CbCR safe harbour rules for Pillar Two and new requirements for a EU public CbCR have been announced, many companies have started critically assessing how their CbCR data is calculated. In addition to ensuring data quality, many companies strive to also reduce the time it takes to prepare the CbCR. Often, spreadsheets become more and more complex to merge data from different sources and calculate the values for the individual CbCR categories.

Read the following case study based on a real-life example to find out more about our experiences from a successful optimization project using Low Code solutions.

The project

The project covered the analysis, optimization and automation of the processes to create CbCR Table I.

Challenge / initial situation

- Manual analysis of shareholding information as well as P&L and balance sheet data from various sources using Excel
- Manual consideration of adjustment amounts, e.g. for permanent establishments
- Repetitive execution of many individual work steps for a large number of companies
- Time-consuming updates in various files and spreadsheets in case of changes compared to the previous year
- Intransparent calculation files due to the combination of the CbCR calculation logic and various adjustments for permanent establishments and other corrections
- Insufficient data checks

Solution

- Merging of all relevant data and data preparation "at the push of a button"

- Automated calculation of the values for the different CbCR categories and transparent inclusion of the necessary adjustments

- Automated plausibility checks and review steps

- Output of the resulting CbCR Table I and audit files for all countries / companies in the desired format

- Visualization of key indicators for final plausibility checks and insights into the global distribution of essential KPIs

Our approach

- Status quo: analysis of current processes, weaknesses and improvement potential

- Target vision: definition of the optimization and automation strategy for future target processes

- Implementation in the common advanced analytics solution Alteryx

- Training in the general use of the software and onboarding to the specifics of the implemented use case

- Support in case of questions and troubleshooting after handover

Added value for the practice

- Time savings as relevant data is simultaneously processed and repetitive manual steps are eliminated

- Timely data availability for the calculation of Transitional CbCR Safe Harbours for Pillar Two

- High flexibility and easy implementation of changes, e.g. new companies or accounts to be considered

- Improved transparency thanks to automated checks and data visualization

- Increased reliability of processes and traceable documentation of work steps

Contact

Would you like to find out more about the case or your own optimization potential? Please let us know. Please fill in our short contact form. We will get in touch with you as soon as possible.

Main Contact

Miriam May

Director Digital

Digital Transfer Pricing & AI

Nuremberg

View Profile

Main Contact

David van Leuven

Director Digital

Dusseldorf

+49211957828537

View Profile

Further topics that might interest you

CbCR Risk Analyzer

XML Tool

WTS Transitional CbCR Safe Harbour Tool

Contact us today

Do you have any questions about our services or WTS? Please let us know. Please fill in our short contact form. We will get in touch with you as soon as possible.

Contact