Blog

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

Blog

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

Blog

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

Blog

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

Blog

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

Why you should download

Why you should watch

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

29.10.2020

Put yourself in the position of tax authorities. There is limited time and resources available for tax audit such that risk assessment tools are used to identify high risk taxpayers and arrangements. Country-by-Country (“CbC”) reports, in combination with other sources of information, provide a useful source of global taxpayer data in standardized format that can be added to existing risk assessment tools. With CbC data now publicly available, taxpayers can use the Aibidia Transfer Pricing Cloud to compare their group data to their peers, enabling the swift identification of risk areas and proactively commenting in the submitted reports.

Basic Framework for Assessing Risk with CbC Data

CbC data is a perfect starting point for conducting a tax risk assessment of multinational enterprises. The data presents a harmonized global picture of a group’s country-level financials and entity-level business activities. CbC reports are submitted in a standardized format on a yearly basis and the data quality is relatively good because information is typically compiled centrally by the group’s parent. Over time, we can expect tax examiners to develop a clear understanding of which financial data thresholds, activity constellations, and manually-added notes imply potential base erosion and profit shifting (“BEPS”) activities.

Risk associated with BEPS activities can come from recurring and one-off transactions, both of which can skew financial and business activity data detectable in a CbC report. Tax authorities will want to establish a comparison of:

  1. Financials and activity profiles in different jurisdictions within the same group;
  2. Financials and activity profiles of one group with another group in a similar sector; and
  3. Financials and activity profiles for the same group over time.

In this article, we first describe publicly available CbC benchmark data and then present some of the standard tax risk indicators that tax authorities use to conduct a risk analysis.

Accessing OECD Benchmark Data

In 2019, almost 100 tax jurisdictions have automatically exchanged tax data (26 have exchanged CbC report data), covering 84 million financial accounts and a total asset base of EUR 10 trillion. In July 2020, the OECD made available 2016 data, accessible on http://oe.cd/corporate-tax-stats in the section for anonymized and aggregated CbC reporting statistics. Note the following characteristics of the data:

  1. CbC reports have been received from the following jurisdictions: Australia, Austria, Belgium, Bermuda, Brazil, Canada, Chile, China, Denmark, Finland, France, India, Indonesia, Ireland, Italy, Japan, Korea, Luxembourg, Mexico, Netherlands, Norway, Poland, Singapore, Slovenia, South Africa, Sweden and United States.
  2. Data is available on an aggregate and average basis.
  3. Measurement unit is in US Dollar.
  4. Updates to the data are available every year.
    The data is subject to a number of data limitations (https://www.oecd.org/tax/tax-policy/anonymised-and-aggregated-cbcr-statistics-disclaimer.pdf). For example, possible double counting of profits may result in effective tax rates biased downwards and profitability ratios and returns to capital biased upwards.
    Keeping the above points in mind, we present possible ways of how to prepare a high-level benchmark for your group’s CbC data.

Comparing Your Group Against an Average Group

Since taxpayers can only view CbC data on an aggregate level for a country, a sector-level comparison is not possible. The fact that certain countries did not provide any CbC data provides an additional restriction. In this case, a similar economy is the next best way to prepare a high-level comparison.

After you have selected CbC data for your own country or a broadly comparable country, you can download and import the chosen data into our Aibidia CbC module. You can then use the analytics tool within the Aibidia CbC module to analyze average statistics and compare them to your own group.

Let us now look at some of the most common tax risk indicators. Note that you can use average group data not only for a comparison of your group’s data against the average group’s data for a particular jurisdiction but also for a comparison of jurisdictional differences within your own group.

High or low tax risk indicators must be understood in the context of a comparison of one jurisdiction to another within the same group, of one jurisdiction to the group as a whole, of one group to another comparable group, or of observations of one group over time.

Tax Risk Indicators

Footprint

Identify jurisdictions with the largest footprint (e.g. revenue or number of employees) within your group and compare this against the business activities of average groups.

You can use benchmark data to view whether average groups have also been active in your jurisdictions.

Danish CbC Data (imported into Aibidia Transfer Pricing Cloud)

Danish CbC Data (imported into Aibidia Transfer Pricing Cloud)

Danish CbC Data (imported into Aibidia Transfer Pricing Cloud)

Danish CbC Data (imported into Aibidia Transfer Pricing Cloud)

Share of related party revenue

Analyze the value or portion of related party revenue by jurisdiction to prepare for increased scrutiny of affiliates whose share is high and subject to transfer pricing policy.
See what portion of revenues your average peers show in corresponding jurisdictions.

Financial ratios

Compare within the group, to your peers, or over time:

  1. Effective tax rates against profit margins, revenue, or profit rates
  2. Identify jurisdictions with high profit margins — i.e. profit before tax / total revenues
  3. Identify jurisdictions with low effective tax rates — i.e. income tax accrued / profit before tax
  4. Identify jurisdiction with high revenue or profit rates — i.e. revenue or profits before tax per unit of economic activity, such as number of employees or tangible assets.
Danish CbC Data (imported into Aibidia Transfer Pricing Cloud)

Business activity

Take a closer look at the geographical distribution of your group’s activities as entered into Table 2 of the CbC report.

Tax paid analysis

Compare your group’s discrepancy between income tax paid (on a cash basis) and income tax accrued to the level of discrepancy observed in other groups.

Danish CbC Data (imported into Aibidia Transfer Pricing Cloud)

There are a number of reasons the results of any comparison should be approached with caution. For example, group affiliates across jurisdictions can be of different sizes, operate in different markets, and or engage in varying activities. When comparing your group with peers, commercial reasons, such as strategy and business models, may go some way to explaining discrepancies in data.Connect with Aibidia to demo our CbC analytics tool and obtain the undeniable strategic benefits of group comparison.

Sources

Handbook on Effective Tax Risk Assessment, OECD 2017

stats.oecd.org

Meet the authors

Transform your approach to transfer pricing now

Cancel anytime. Backed by TP experts.
7-day free trial
Set up instantly
Up-to-date, accurate answers
REPORTS

How to Use Publicly Available Country-by-Country Data to Navigate Assessment Risk

Hereʼs Why You Should Get the Report

0

See how peers are adapting to global change

Understand how 140+ MNEs and advisory firms are responding to shifting regulations, heightened audit scrutiny, and technology-driven change, and where your approach stands in comparison.

0

Learn how others are driving compliance

Explore the approaches to resourcing, data management, and operational transfer pricing that teams are using to tackle growing workloads.

0

Identify emerging trends shaping the profession

Gain insight into how AI, automation, and operating models are redefining transfer pricing, so you can plan for the skills, tools, and processes youʼll need next.

Insights

What youʼll learn inside the Aibidia report 2025

The rising cost of tax scrutiny
01

The rising cost of tax scrutiny

Heightened tax authority demands are driving up the time and money TP teams spend on audits. Companies with stronger documentation processes, centralised data, and proactive OTP practices are better positioned to contain both costs and risk.

02

The state of OTP maturity

Only 35% of companies have a well-defined OTP process, while 24% have none at all. Barriers to OTP maturity include poor data access, complex business models, and limited coordination between tax, finance, and IT.

03

The importance of structured data

With 72% of companies in fragmented data environments, the report shows how centralised data helps TP teams insource more processes, ensure consistent compliance, and handle audits more efficiently.

04

Technology and AI adoption in practice

42% of MNEs are investing in specialist software, reducing reliance on traditional tools. AI interest is steady rather than explosive, hinting that TP teams need clean, structured data before advanced analytics can add value.

Download the report

Submit the form below to access your report.

By submitting this form, I confirm that I have read the Privacy Policy and agree to the processing of my personal data by Aibidia for the stated purposes.
Thank you! The report will be sent to your inbox.

Expert insights

Structured, reliable data is essential for executing a consistent, defensible transfer pricing strategy. Common barriers to structured data include siloed legacy source systems, unclear data ownership, and inconsistent definitions across entities and functions.

Prasad Parwidala
Head of Professional Services, Aibidia
Read the case study

We see significant variation in OTP maturity across companies. In many cases, if existing processes appear to work, there’s less motivation to change. However, where we see this changing, is within MNEs that have faced increased scrutiny or operate with more complex structures.

Pia Honkala
Global Commercial Head - Operational Transfer Pricing, Aibidia
Read the case study

While there are many challenges in accessing the right data for TP calculations and analysis, one of the most significant barriers to OTP adoption can be the misalignment of KPIs between Finance and Tax teams.

Marlon Manto
Director, Transfer Pricing Advisory, Aibidia
Read the case study

We’re seeing practical AI adoption in areas such as navigating country-specific documentation requirements, researching transfer pricing methods, comparing jurisdictional rules, and tracking global compliance timelines.

Maria Helander
VP Product, Aibidia
Read the case study