Reporting on global transparency information

This chapter provides information on these main topics:

• CSV File Creation
• XML File Creation – HMRC Format
• XML File Creation – OECD Format

CSV File Creation

Use this app to create an CSV 2 column export file for import into third party filing tool. This file will consist of a series of identification tags indicating identifying record.field information and the associated data points.

Note: Before this option is selected the address and identification numbers should be submitted to the reporting entity using the Table 2 - Main Business Activities app.

To export the CSV file:

1. In the Global Transparency navigation pane, click Administration.
2. Expand Country Filing Export.
3. Click CSV File creation.lvapp.
4. A symbol selection form will open in the workspace. Complete the following fields:

   Field	Notes
   Time Period	Select a leaf symbol for the period. Type the name of a period, use the drop-down list, or use the symbol selector to select the symbol. For more information on searching for symbols see "Using the Symbol Selector" in the Tax Administrator Guide.
   Reporting Entity	Select a parent or leaf symbol for the entity on which the export is to run. Type the name of an entity, use the drop-down list, or use the symbol selector to select the symbol. For more information on searching for symbols see "Using the Symbol Selector" in the Tax Administrator Guide.

5. Click OK. CSV File form is displayed.
6. Complete the following fields:

   Field	Notes
   MNE Name	Type the full trade or operating name of the organization under which the filing is to be made.
   Reporting Entity Name	Type the name of the reporting entity making the filing
   Reporting Entity Country	Select the country in which the reporting entity resides from the list of active countries as defined in the Countries.lvapp
   Reporting Entity Role	Select the role of the entity with respect to the filing of the report.
   Message Type	Select if this is new file or a correction to a submitted file.
   Language Tag	Identify the language in which the content of the additional information has been provided. Select the relevant language from the supplied list per ISO 639.
   Contact    Type	Type contact information for the sender of the message.
   Output File	Type the name of the generated output file.
   Period Ending	Identify the last day of the reporting period to which the message relates.
   Reporting Entity Period Start	Identify the first day of the reporting period for the reporting entity to which the message relates.
   Reporting Entity Period End	Identify the last day of the reporting period for the reporting entity to which the message relates.

7. Click OK.
8. A Successful generation message will be displayed with “View File” button. Click the button to view the CSV file using the default system editor.
9. Click Close.
10. The file can be found in your local My Documents\Longview directory.

XML File Creation - HMRC Format

Use this app to create an XML export file for electronic submission to the HMRC agency. This app allows you to enter the filing header information for the file, tag previous files as submitted and then generate the output file.

To export the XML file:

1. In the Global Transparency navigation pane, click Administration.
2. Expand Country Filing Export.
3. Click XML File creation - HMRC Format.lvapp
4. A symbol selection form will open in the workspace. Complete the following fields:

   Field	Notes
   Time Period	Select a leaf symbol for the period. Type the name of a period, use the drop-down list, or use the symbol selector to select the symbol. For more information on searching for symbols see "Using the Symbol Selector" in the Tax Administrator Guide.
   Reporting Entity	Select a parent or leaf symbol for the entity on which the export is to run. Type the name of an entity, use the drop-down list, or use the symbol selector to select the symbol. For more information on searching for symbols see "Using the Symbol Selector" in the Tax Administrator Guide.

5. Click OK. The Filing Information - HMRC form is displayed.
6. Complete the following fields:
7. To identify a previous file as submitted, Click Submitted File. Else go to step 16.
8. Select the last file submitted from the list of generated files starting from last identified submission.
9. Click OK to return to the Filing Information form.
10. Update form content.
11. To update the tax identification information for the reporting entity, Click Tax Identification. Else go to step 17.
12. Complete the following fields:

    Field	Notes
    Tax Identification Number	Type in tax identification number of the reporting entity.
    Issued By	Select the country issuing the tax identification number.
    Entity Identification Number	Type in entity identification number of the reporting entity.
    Entity IN - Issued By	Select the country issuing the entity identification number.

13. Click OK to return to the Filing Information form.
14. To update the reporting entity address, Click Set Address. Else go to step 17.
15. Complete the following fields:

    Field	Notes
    Legal Address Type	Select the address type of the reporting entity
    Street	Type the street address of the reporting entity
    Building	Type the building identifier of the reporting entity
    Suite	Type the Suite identifier of the reporting entity if relevant
    Floor	Type the floor of the reporting entity if relevant
    District Name	Type the district of the reporting entity if relevant
    POB	Type the post office box identifier of the reporting entity if relevant.
    Post Code	Type the postal code/zip code of the reporting entity if relevant.
    City	Type the city name of the reporting entity
    Country SubEntity	Type the region name for the country of the reporting entity if relevant

16. Click OK to return to the Filing Information form.
17. Click OK. If a correction file is requested continue to step 18. Else go to step 20.
18. Complete the following fields:

    Field	Notes
    Delete Data Previously Filed	Select if previously filed data should be deleted
    Reporting entity	Select if the correction replaces the Reporting Entity section in the XML file previously submitted
    Report Body	Select if the correction replaces the Summary and Main Business Activities section in the XML file previously submitted
    Additional Information	Select if the correction replaces the Additional Information section in the XML file previously submitted

19. Click OK.
20. A successful generation message will be displayed with "View File" button. Click the button to view the XML file using the default system editor.
21. Click Close.
22. The file can be found in your local My Documents\Longview directory.

XML File Creation - OECD Format

Use this app to create an XML export file for electronic submission to those authorities utilizing the Organization for Economic Co-operation and Development (OECD) standard. This app allows you to enter the filing header information for the file, tag previous files as submitted and then generate the output file.

To export the XML file:

1. In the Global Transparency navigation pane, click Administration.
2. Expand Country Filing Export.
3. Click XML File creation - OECD Format.lvapp
4. A symbol selection form will open in the workspace. Complete the following fields:

   Field	Notes
   Time Period	Select a leaf symbol for the period. Type the name of a period, use the drop-down list, or use the symbol selector to select the symbol. For more information on searching for symbols see "Using the Symbol Selector" in the Tax Administrator Guide.
   Reporting Entity	Select a parent or leaf symbol for the entity on which the export is to run. Type the name of an entity, use the drop-down list, or use the symbol selector to select the symbol. For more information on searching for symbols see "Using the Symbol Selector" in the Tax Administrator Guide.

5. Click OK. The Filing Information – OECD form is displayed.
6. Complete the following fields:

   Field	Notes
   Transmitting Country	Select the Jurisdiction of the Competent Authority transmitting the message. All active countries defined in the Countries.lvapp are available for selection.
   Entity Name	Type the full legal name of the organization under which the filing is to be made.
   Reporting Entity Country	Select the country in which the reporting entity resides from the list of active countries as defined in the Countries.lvapp
   Reporting Entity Role	Select the role of the entity with respect to the filing of the report.
   Message Type	This will identify the type of submission being made.
   Language Tag	Identify the language in which the content of the additional information has been provided. Select the relevant language from the supplied list per ISO 639.
   Cautionary Instruction	Type free form specific cautionary instructions about the use of the file content. If the data is for a period other than the full fiscal year it should be given here as a narrative, e.g. "ten month period"
   Contact Information	Type contact information for the sender of the message.
   Test Data	Flag if the file being submitted is part of a testing period to avoid mingling of test data with "live" data.
   Output File	Type an override the name of the generated output file.
   Period Ending	Identify the last day of the reporting period to which the message relates.
   Reporting Entity Period Start	Identify the first day of the reporting period for the reporting entity to which the message relates.
   Reporting Entity Period End	Identify the last day of the reporting period for the reporting entity to which the message relates.

7. To identify a previous file as submitted, Click Submitted File. Else go to step 16.
8. Select the last file submitted from the list of generated files starting from last identified submission.
9. Click OK to return to the Filing Information form.
10. Update form content.
11. To update the tax identification information for the reporting entity, Click Tax Identification. Else go to step 17.
12. Complete the following fields:

    Field	Notes
    Tax Identification Number	Type in tax identification number of the reporting entity
    Issued By	Select the country issuing the tax identification number
    Entity Identification Number	Type in entity identification number of the reporting entity
    Entity IN - Issued By	Select the country issuing the entity identification number

13. Click OK to return to the Filing Information form.
14. To update the reporting entity address, Click Set Address. Else go to step 17.
15. Complete the following fields:

    Field	Notes
    Legal Address Type	Select the address type of the reporting entity
    Street	Type the street address of the reporting entity
    Building	Type the building identifier of the reporting entity
    Suite	Type the Suite identifier of the reporting entity if relevant
    Floor	Type the floor of the reporting entity if relevant
    District Name	Type the district of the reporting entity if relevant
    POB	Type the post office box identifier of the reporting entity if relevant
    Post Code	Type the postal code/zip code of the reporting entity if relevant
    City	Type the city name of the reporting entity
    Country SubEntity	Type the region name for the country of the reporting entity if relevant

16. Click OK to return to the Filing Information form.
17. Click OK. If a correction file is requested continue to step 18. Else go to step 20.
18. Complete the following fields:

    Field	Notes
    Delete Data Previously Filed	Select if previously filed data should be deleted
    Reporting entity	Select if the correction replaces the Reporting Entity section in the XML file previously submitted
    Report Body	Select if the correction replaces the Summary and Main Business Activities section in the XML file previously submitted
    Additional Information	Select if the correction replaces the Additional Information section in the XML file previously submitted

19. Click OK.
20. A successful generation message will be displayed with "View File" button. Click the button to view the XML file using the default system editor.
21. Click Close.
22. The file can be found in your local My Documents\Longview directory.