Updating Country by Country Information

Download Tax Global Transparency Guide

Financial Information Input app (Table 1)

Use the Table 1 – Financial Information input app to enter and review Country-by-Country Reporting (CbCR) financial information.

If foreign exchange (FX) is enabled for CbCR, you can enter manual adjustments in the entity functional currency. The application automatically translates the values to the reporting currency. This input app allows you to :

• Manually adjust Table 1 financial data
• Review and Analyze Automated calculations
• Work with Comments and file attachments

To view the additional information entries, use the following reports:

• Table 1A - Financial Information.lvapp
• Table 1R - Financial Information.lvapp

To update the Financial information:

1. In the Global Transparency navigation pane, click Data Collection.
2. Expand Country by Country.
3. Expand the Actual or Return folder to access the apps in the appropriate period during launch.
4. Click Table 1 - Financial Data.lvapp

   Note: Depending on your configuration you may have a Table 1A - Financial Information for Actual periods and Table 1R - Financial Information for Return periods

5. For each needed entry, enter the following: 

   1. Unrelated Party Revenue: Enter the revenue generated from transactions with independent parties.

   2. Related Party Revenue: Enter the revenue generated from transactions with related parties.

   3. Total Revenue: Displays the total of Unrelated Party Revenue and Related Party Revenue.

   4. Profit (Loss) Before Income Tax: Enter the profit or loss amount before income tax.

   5. Income Tax Paid (on cash basis): Enter the amount of income tax paid during the reporting period.

   6. Income Tax Accrued - Current Year: Enter the accrued income tax amount for the current year.

   7. Stated Capital: Enter the stated capital amount.

   8. Accumulated Earnings: Enter the accumulated earnings amount.

   9. Number of Employees: Enter the total number of employees.

   10. Tangible Assets other than Cash and Cash Equivalents: Enter the value of tangible assets excluding cash and cash equivalents.

   11. Public Subsidies Received: Enter the amount of public subsidies received, if applicable.

   Values can be entered in the Manual Adjustment column, and the updated total is displayed in the Total column.

6. When you are finished, click Submit.

Foreign Exchange Functionality

When the foreign exchange functionality is enabled :

• Manual inputs are entered in the entity’s functional currency and automatically translated to the reporting currency.
• Automated calculations are performed in both functional and reporting currencies.
• For the Number of Employees field, an exchange rate of 1 is applied.

When the setting is disabled, the application continues to use the existing reporting currency behavior.

Australia Public CbC Financial Data

The Australia Public CbC Financial Data app enables tax preparers to review CbCR Table 1 financial data, enter Australia Public CbC adjustments, and view the resulting Australia Public CbC amounts.

To update Australia Public CbC financial data:

1. In the Global Transparency navigation pane, click Data Collection.
2. Expand Country by Country.
3. Expand the Actual or Return folder to access the appropriate reporting period.
4. Expand Financial Information. Do one of the following:
   1. For an Actual period, click Australia Public CbC Financial Data.lvapp under Actual > Financial Information.
   2. For a Return period, click Australia Public CbC Financial Data.lvapp under Return > Financial Information.
5. Select the appropriate Entity and Time Period using the drop-down lists from the Symbol Selector icons, and then click OK to proceed.
6. Review the data and enter adjustments in the Manual Adjustment Australia column as required.
7. Click Submit to save your changes.

The grid contains the following columns:

To enter adjustments, review the financial data and enter the required adjustment amounts in the Manual Adjustment Australia column. Click Submit to save your changes.

The Australia Public CbC values are updated automatically based on the adjustments entered.

The currency displayed on the page is determined by your organization's Global Transparency configuration and may vary depending on the reporting setup.

Use Select Symbols to choose the reporting period for the data, with available options including:

• CYTAXPER### (Current Year Tax Period)
• RTNTAXPER### (Return Tax Period)

Note: Changes made in the Manual Adjustment Australia column apply only to Australia Public CbC reporting and do not affect the original values displayed in the Total column.

EU Public CbC Financial Data

The EU Public CbC Financial Data app enables tax preparers to review CbCR Table 1 financial data, enter EU Public CbCR adjustments, and view the resulting EU Public CbC amounts.

To update EU Public CbC financial data:

1. In the Global Transparency navigation pane, click Data Collection.
2. Expand Country by Country.
3. Expand the Actual or Return folder to access the appropriate reporting period.
4. Expand Financial Information.
5. Do one of the following:
   • For an Actual period, click EU Public CbC Financial Data.lvapp under Actual > Financial Information.
   • For a Return period, click EU Public CbC Financial Data.lvapp under Return > Financial Information.
6. Select the appropriate Entity and Time Period using either the drop-down lists from the Symbol Selector icons, and then click OK to proceed.
7. Review the data and enter adjustments in the Manual Adjustment EU column as required.
8. Click Submit to save your changes.

The grid contains the following columns:

To enter adjustments, review the financial data and enter the required adjustment amounts in the Manual Adjustment EU column. Click Submit to save your changes.

The EU Public CbC values are updated automatically based on the adjustments entered.

The currency displayed on the page depends on the Global Transparency FX configuration.

• If FX is enabled, amounts are shown using the configured foreign exchange rates.
• if FX is not enabled, amounts are displayed in the source reporting currency.

Use Select Symbols to choose the reporting period for the data, with available options including:

• CYTAXPER### (Current Year Tax Period)
• RTNTAXPER### (Return Tax Period)

Note: Changes made in the Manual Adjustment EU column apply only to EU Public CbCR reporting and do not affect the original values in the Total column.

Main Business Activities input app (Table 2A and Table 2R)

Use this input app to identify the functional business activities of the various entities within the organization for submission to outside authorities. This input app allows you to enter the:

• Tax Jurisdiction of the constituent members if they are different from the Jurisdiction of Residence.
• Identify relevance of business activity categories to the constituent entities.
• Tax Identification Number and it's issuing country if applicable.
• (Entity) Identification Number and issuing country by entity if applicable.
• The organization name to be used during file submission if it is different from the description of the entity symbol.
• Relevant information specific to the individual constituent entities.

To view the business activities and tax jurisdiction of the constituent entities, use the following reports:

• Table 2A - Main Business Activities Report.lvapp
• Table 2R - Main Business Activities Report.lvapp

To update the business activities:

1. In the Global Transparency navigation pane, click Data Collection.
2. Expand Country by Country.
3. Expand the Actual or Return folder to access the apps in the appropriate period.
4. Expand Activities.
5. Use the drop-down list or the symbol selector to select the appropriate entity. For more information, seeUsing the Symbol Selector.
6. Do one of the following:
   • For Actual Period, click Table 2A - Main Business Activities.lvapp.
   • For Return Period, click Table 2R - Main Business Activities.lvapp.
7. For each entity, enter the following:

   1. CbC_JurisdictionDiff: Tax Jurisdiction of organization

   2. CbC_IncorpCountry: Tax Jurisdiction of incorporation

   3.  CbC_Omit_MBA: Include as Constituent Entity

   4.  CbC_RandD: Research and Development

   5.  CbC_IntellectProperty: Holding or Managing intellectual property

   6. CbC_Purchasing: Purchasing or Procurement

   7.  CbC_Manufacturing: Manufacturing or Production

   8.  CbC_SalesandMrkt: Sales, Marketing or Distribution

   9.  CbC_Adminstrative: Administrative, Management or Support Services

   10.  CbC_Services: Provision of Services to unrelated parties

   11.  CbC_InternalFinance: Internal Group Finance

   12.  CbC_FinancialServices: Regulated Financial Services

   13.  CbC_Insurance: Insurance

   14.  CbC_OtherEquity: Holding shares or other equity instruments

   15.  CbC_Dormant: Dormant

   16.  CbC_Other: Other

   17.  CbC_OtherExplan: Supplemental Explanation

   18.  CbC_Name: Submitted Oragnisation Name

   19.  CbC_TIN: Tax Identification Number (TIN)

   20.  CbC_TIN_Co: TIN - Issuing Country

   21.  CbC_IN: Entity Identification Number

   22.  CbC_IN_Co: Entity IN - Issuing Country

   23.  CbC_LegalAddressType: Legal Address Type

       Note: Valid settings per OECD schema: residentialOrBusiness, residential, business, registeredOffice, unspecified

   24.  CbC_Street: Street (Optional)
       

   25. CbC_BuildingIdentifier: Building (Optional)

   26. CBC_SuiteIdentifier: Suite (Optional)

   27. CbC_FloorIdentifier: Floor (Optional)

   28. CbC_DistrictName: District Name (Optional)

   29. CbC_POB: POB (Optional)

   30. CbC_PostCode: Post Code (Optional)

   31. CbC_City: City (Required)

   32. CbC_CountrySubEntity: Country SubEntity (Optional)

8. When you are finished, click Submit.

Additional Information input app (Table 3A and Table 3R)

Use this input app to supply brief information and explanations as necessary to facilitate the understanding of the compulsory financial and business activity information loaded into the system. This information should relate to more than one member of the Multinational Entity (MNE) group or the group as a whole. This input app allows you to enter the:

• Text content of the additional information entries relevant to the MNE Group as a whole.
• The Language data element is required for OECD schema 2.0 filing and specifies the language in which the content of the Additional Info element, if any, has been provided. When the Additional Information is repeated for transliteration purposes, the Language attribute must be provided.
• Related country of residence for the MNE group.
• Related list of summary elements.

To view the additional information entries, use the following reports:

• Table 3A - Additional Information Report.lvapp
• Table 3R - Additional Information Report.lvapp

To update the additional information:

1. In the Global Transparency navigation pane, click Data Collection.
2. Expand Country by Country.
3. Expand the Actual or Return folder to access the apps in the appropriate period during launch.
4. Do one of the following:
   • For Actual Period, click Table 3A - Additional Information.lvapp.
   • For Return Period, click Table 3R - Additional Information.lvapp.
5. For each needed entry, enter the following:

   1. Additional Information: Free text up to 3999 characters long.

      Note: To clear all values in a row, right-click the 'Additional Information' cell and select Clear from the context menu. This action removes the Additional Information and all other associated settings for the selected row.

   2. Language (OECD): This data element specifies the language in which the content of the Additional Info element, if any, has been provided. When the OtherInfo is repeated for transliteration purposes, the Language attribute must be provided.

   3. Relevant Country: A member of the list of active countries as defined in Countries.lvapp (Optional).

   4. Revenues - Unrelated: TRUE|FALSE

   5. Revenues - Related: TRUE|FALSE

   6. Revenues - Total: TRUE|FALSE

   7. Profit or Loss: TRUE|FALSE

   8. Tax Paid: TRUE|FALSE

   9. Tax Accrued: TRUE|FALSE

   10. Capital: TRUE|FALSE

   11. Earnings: TRUE|FALSE

   12. Number of Employees: TRUE|FALSE

   13. Assets: TRUE|FALSE

   14. Name of MNE Group: TRUE|FALSE

6. When you are finished, click Submit.

Specifying Jurisdiction Exemptions for Australia Public CbCR

Use the Australia Public CbCR Jurisdiction Exemptions page to specify which Australia Public Country-by-Country Reporting (CbCR) data should be exempt from public disclosure for each jurisdiction.

Exemptions are maintained by reporting period, allowing disclosure requirements to differ between reporting periods. During a rollover, exemption settings are copied to the new reporting period and can be modified as required.

The Australia Public CbCR Jurisdiction Exemptions page can be used to:

• Import jurisdiction exemption settings from a .csv file for a selected reporting period.
• Manage jurisdiction-specific disclosure exemptions by selecting the information that should be exempt from public disclosure.
• Export jurisdiction exemption settings to a .csv file for backup, review, or import into another environment.

Importing Australia Public CbCR Jurisdiction Exemptions

The Import option in the Australia Public CbCR Jurisdiction Exemptions dialog allows you to update jurisdiction exemption settings in the database from a .csv file for a selected reporting period.

To import Australia Public CbCR Jurisdiction Exemptions:

1. In the Global Transparency navigation pane, click Administration.
2. Expand Country by Country.

3. Expand Entities.

4. Click Australia Public CbCR Jurisdiction Exemptions. The Australia Public CbCR Jurisdiction Exemptions dialog appears.
5. Under Option, select Import.
6. In the File field, click Browse and select the appropriate .csv file to import.
7. In the TIMEPER field, select the reporting period for which you want to import the jurisdiction exemptions.
8. Click OK. A table is displayed showing the summary of all actions performed during the import.

Note: If there are any issues with the file, a table is displayed identifying the issues. No changes are made to the jurisdiction exemptions.

.csv file sample

Managing Australia Public CbCR Jurisdiction Exemptions

The Manage option in the Australia Public CbCR Jurisdiction Exemptions dialog allows you to specify disclosure exemptions for each jurisdiction for a selected reporting period.

To manage Australia Public CbCR Jurisdiction Exemptions:

1. Click Australia Public CbCR Jurisdiction Exemptions. The Australia Public CbCR Jurisdiction Exemptions dialog appears.
2. Under Option, select Manage.
3. In the TIMEPER field, select the reporting period for which you want to manage the jurisdiction exemptions.
4. Click OK.

The Australia Public CbCR Jurisdiction Exemptions screen is displayed.

Australia Public CbCR Jurisdiction Exemptions Screen

The Australia Public CbCR Jurisdiction Exemptions screen is used to define disclosure exemptions for each jurisdiction included in Australia Public Country-by-Country Reporting (CbCR). The screen contains the following components:

Toolbar Options

• Apply – Saves any changes made to the jurisdiction exemptions.

• Refresh – Reloads the jurisdiction exemption data for the selected reporting period.

• If there are unapplied changes, you are prompted to either apply or discard the changes before the data is refreshed.

  • Apply Changes saves your changes and refreshes the screen.
  • Discard Changes discards any unsaved changes and refreshes the screen.
  • Cancel returns to the screen without refreshing the data.
• Filter – Filters the displayed jurisdictions based on the selected criteria.
• Group By – Groups the displayed data by the selected column.
• Print Preview – Displays a printable view of the current grid.
• Export to Excel – Exports the displayed jurisdiction exemption data to Microsoft Excel.
• Search – Filters the displayed jurisdictions. For more information, refer to Searching Tables.

Jurisdiction

Displays all jurisdictions available for Australia Public CbCR reporting, including the aggregated jurisdiction. This field is read-only.

Exemption Fields

Each exemption column represents a data item that can be excluded from Australia Public CbCR public disclosure.The available exemption fields include:

Applying Exemptions

Select the check box for each disclosure item that should be exempt from public disclosure for a jurisdiction, or clear the check box to include the item in the Australia Public CbCR report.

After making your changes, click Apply to save the exemption settings.

Note: Exemption settings are maintained separately for each reporting period.

Exporting Australia Public CbCR Jurisdiction Exemptions

The Export option in the Australia Public CbCR Jurisdiction Exemptions dialog allows you to export jurisdiction exemption data for a selected reporting period from the database to a .csv file.

To export Australia Public CbCR Jurisdiction Exemptions:

1. Click Australia Public CbCR Jurisdiction Exemptions. The Australia Public CbCR Jurisdiction Exemptions dialog appears.

2. Under Option, select Export.

3. In the File field, specify the location and name of the .csv file to which you want to export the data, or click Browse to select a file location.

   Note: If the specified file does not exist, it will be created during the export process.

4. In the TIMEPER field, select the reporting period for which you want to export the jurisdiction exemptions.

5. Click OK.

6. A confirmation dialog appears when the export is completed successfully.

7. Click View File to open and review the exported .csv file.

Specifying Tax Difference Explanation for Australia Public CbCR

Importing Tax Difference Explanation

The Import Tax Difference Explanation activity allows you to import explanations for the difference between tax accrued (current year) and the amount of income tax due if the income tax rate applicable to the jurisdiction were applied to profit and loss before income tax for one or more jurisdictions from a .csv file.

The imported explanations are stored for the selected reporting period and can contain up to 5,000 characters per jurisdiction.

To import Tax Difference Explanation:

1. In the Global Transparency navigation pane, expand Country by Country.
2. Expand the required reporting period (Actual or Return).
3. Expand Activities.
4. Click Import Tax Difference Explanation.lvapp. The Import Tax Difference Explanation dialog appears.
5. In the File field, click Browse and select the .csv file to import.
6. In the TIMEPER field, select the reporting period to which you want to import the explanations. By default, the reporting period is set according to the system setting (Actual or Return).
7. Click OK.
8. A summary table is displayed showing the results of the import, including any records that were successfully imported or any validation issues encountered.

Note: If the import file contains validation errors, the affected records are identified in the summary table. Any invalid records are not imported.

.csv File sample

Exporting Tax Difference Explanation

The Export Tax Difference Explanation activity allows you to export the explanations for the difference between tax accrued (current year) and the amount of income tax due if the income tax rate applicable to the jurisdiction were applied to profit and loss before income tax for one or more jurisdictions to a .csv file.

To export Tax Difference Explanation:

1. In the Global Transparency navigation pane, expand Country by Country.

2. Expand the required reporting period (Actual or Return).

3. Expand Activities.

4. Click Export Tax Difference Explanation.lvapp. The Export Tax Difference Explanation dialog appears.

5. In the File field, specify the location and name of the .csv file to which you want to export the data.

   Note: If the specified file does not exist, it is created during the export process.

6. In the TIMEPER field, select the reporting period for which you want to export the explanations. By default, the reporting period is set according to the system setting (Actual or Return).

7. Click OK.

8. A confirmation dialog appears when the export completes successfully.

9. Click View File to open and review the exported file.