Customizing CbCR Table 1

You can customize CbCR Table 1 to enhance reporting for your organization by adding details or grouping columns to manage data at a more granular level. You might divide columns to report on jurisdictions and regions, or extend columns to display additional details for selected accounts. For example, for the Total Unrelated Party Revenue column, you could create items such as Third Party Revenue, Other Income, and so on to suit your organization's requirements.

For each account on CbCR Table 1, you can customize any of the Total tables under TRCS_Table 1 by adding child accounts for your organization. These are added using the Dimension Editor. You must assign the newly created child to a book account, so when you run Consolidation, the assigned member is automatically populated under Mapped Data.
Customized member added as a child

You can add children only to the following parent members:

  • TRCS_CBCRTotalRevenuesRelatedParties
  • TRCS_CBCRTotalRevenuesUnrelatedParties
  • TRCS_CBCRTotalTax
  • TRCS_CBCRCurrentProvisionTotal
  • TRCS_CBCRTotalStatedCapital
  • TRCS_CBCRTotalAccumulatedEarnings
  • TRCS_CBCRTotalNumberOfEmployees
  • TRCS_CBCRTotalNetTangibleAssets

The following hierarchy is automatically created for TRCS Table 1.

Table 12-2 TRCS_Table 1 Total Accounts

Total Account Parent Account Default Alias



Total Revenue


Revenue Related Parties


Revenue Unrelated Parties



Profit (Loss) Before Income Tax

Earnings Before Interest and Tax (EBIT) is a measure of a company's profit that includes all expenses except interest and income tax expenses. The value represents the difference between operating revenues and operating expenses.


Earnings Before Interest and Tax (EBIT)



Total Income Tax Paid (on cash basis)


National Income Tax Paid (on cash basis)


Regional Income Tax Paid (on cash basis)



Total Income Tax Accrued - Current Year


National Income Tax Accrued (Current Year)


Regional Income Tax Accrued (Current Year)



Stated Capital


Stated Capital - Entry



Accumulated Earnings


Accumulated Earnings - Entry



Accumulated Earnings


Accumulated Earnings - Entry



Number of Employees


Number of Employees - Entry



Tangible Assets, Net


Tangible Assets, Net - Entry

To add customized accounts for CbCR Table 1:

  1. From the Home page, click the Navigator Navigator icon.
  2. Under Create and Manage, select Dimensions.
  3. Under TRCS_CountryByCountryReporting, expand TRCS_Table1.
  4. Select the Total parent member to which you want to add a child, and then click Add Child Add Child Icon.
  5. On the Member Properties tab, enter a Name and Alias for the new member, then set the default properties, and then click Save.

    When you add children to a parent member, the child members are also automatically added in the following locations:

    • All CbCR Tax Automation forms, such as Table 1 Data Entry.
    • Under TRCS_CbCR Override Rate Accounts as a Shared member so users can directly enter an FX override rate on the TRCS_CbCR FX Rates Override form. For more information, see Entering CbCR FX Override Rates.
    • A Custom attribute with the same name as the new member is created so that new member can be mapped to pull book data. For example, when an EBIT1 member under TRCS_TotalEBIT is added, a new custom attribute member named "EBIT1" is created under the CBCR custom attribute parent so that the column can be mapped to source book Account.
  6. Review the added columns on the CbCR Table 1 Data Entry form.
    Children added to CbCR Table 1 are automatically added to other forms.