First page of the Country-by-Country Report Data Template (Table 1)Excel workbook preview

OECD transfer pricing and Pillar Two

Country-by-Country Report Data Template (Table 1)

Country by country reporting template in Excel: entity data in local currency rolled up into OECD Table 1 by formula, Table 2 activities, Table 3 notes and risk checks.

Excel workbook · 22 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

The Country-by-Country Report shows, for every tax jurisdiction where a large multinational group operates, its revenue, profit before tax, income tax paid and accrued, stated capital, accumulated earnings, employees and tangible assets. Groups with consolidated revenue of EUR 750 million or more in the preceding year file it once a year under the OECD standard.

This workbook follows the model template in Annex III to Chapter V of the OECD Transfer Pricing Guidelines (2022 edition). Entity data goes in once, in local currency, and Table 1 is built by formula, translated at average rates as the instructions describe. Table 2 lists the 13 business activities, Table 3 holds the additional information, and a checks sheet gives ratios to review before filing.

Who it is for

The group tax or reporting lead who must collect entity data from every subsidiary and turn it into the Country-by-Country Report before the filing deadline.

What is inside

  • Entity Data sheet with 11 worked constituent entities in 9 jurisdictions and 20 blank formatted rows
  • Table 1 built entirely by formula: each column summed by jurisdiction and translated at each entity's average rate
  • Table 2 with the 13 OECD business activity columns, a tick dropdown and a flag for entities with no activity ticked
  • Table 3 Additional Information sheet with 6 worked notes on sources, rates, headcount and permanent establishments
  • Checks sheet with 7 ratios per jurisdiction and review flags against thresholds you set
  • Filing threshold test against the EUR 750 million consolidated revenue rule, and a test for entities whose jurisdiction is missing from Table 1
  • Data source dropdown per entity, frozen headers and filters

How to use it

Enter the group name, fiscal year and currency on Table 1, then collect one row per constituent entity on the Entity Data sheet in local currency.

Files

  • XLSXcountry-by-country-report-data-template.xlsx22 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

Which groups must file a Country-by-Country Report?

Under Chapter V of the OECD Guidelines, groups with annual consolidated group revenue of EUR 750 million or more in the immediately preceding fiscal year file a report each year. Each country sets the local rule and currency amount. For a US parent, Treas. Reg. 1.6038-4 uses a USD 850 million threshold and Form 8975.

What is in Table 1 of the CbC report?

Table 1 shows, per tax jurisdiction, revenues from unrelated parties, related parties and in total, profit or loss before income tax, income tax paid on a cash basis, income tax accrued for the current year, stated capital, accumulated earnings, number of employees and tangible assets other than cash and cash equivalents.

Must the CbC report reconcile to the consolidated accounts?

No. The Annex III instructions say it is not necessary to reconcile the revenue, profit and tax in the template to the consolidated financial statements. The group must use the same data sources from year to year, describe them in the Additional Information section and explain any change.