Z5 reporting

The Z5 report is a German report of claims on and liabilities to non-residents arising from transactions in goods and services. The report includes claims on and liabilities to non-resident associated enterprises and non-resident businesses other than banks, to which you are linked through common interests. You can use the Print Z5 Report (tfcmg3455m000) session to print a report of foreign payments, and to generate CSV files to be uploaded to the Deutsche Bundesbank.

Z5 reporting setup

To collect the data for the Z5 report:

  1. In the Financial Business Partner Groups (tfacr0110m000) and the Financial Business Partner Groups (tfacp0110m000) sessions, for the appropriate financial business-partner groups, in the Z5 Reporting field, select Affiliated or Non Affiliated as applicable.

  2. For each business partner that belongs to an Affiliated business partner group, verify their place in the hierarchy.

    In the Business Partner (tccom4100s000) session, on the Detailed tab, you can:

    • Click the Tree button to view the business partner's place in the hierarchy.
    • Specify a parent business partner in the Parent Business Partner field, if required.

    Important!: The place in the hierarchy determines the reporting section in which the data for the business partner are incorporated.

  3. In the Financial Customer Group of the Invoice-to Business Partner (tccom4112s000) and the Invoice-from Business Partner (tccom4122s000) sessions, select the business partner groups that you created for Z5 reporting.

Printing a Z5 report

To print the Z5 report:

  1. In the Print Z5 Report (tfcmg3455m000) session, specify a selection range and select options as required.
  2. To generate the CSV files to be uploaded to the Deutsche Bundesbank, select Export Summary, and then specify file locations for the reporting sections.

Reporting sections

For Affiliated business partner groups, LN generates CSV files for these reporting sections:

  • Reporting Section 81-86, for internal business partners that are parents in the business partner hierarchy.
  • Reporting Section 87-92, for internal business partners that are children in the business partner hierarchy.
  • Reporting Section 93-98, for internal business partners that are siblings in the business partner hierarchy.

For Non Affiliated business partner groups, LN generates a CSV file for Reporting Section 41-46.

The sections are grouped by country and currency.