Z4 Bundesbank reporting

Requirement

German Authorities force German companies up from autumn 2013 (originally 01.07.2013) to report Z4 transactions in an electronic format only to German Bundesbank.

The Z4 report states all cross border in- and outgoing payment transactions for services/capital trade/cash transfers, transit trade, investments other than goods exceeding a total of 12.500 EUR (per payment) for all Z4 AWV reporting codes included.

The transactions must be reported until the seventh day of the month following the day of the payment of Z4 relevant services, at the latest.

The statistical data are required by the Deutsche Bundesbank for the purpose of compiling the German balance of payments.

M3 solution

In the basic data programs (AAS910 and AAS911) the definition of when a payment are to be reported and what reporting codes to be used to specify the reason of the payment are made.

The M3 BE program (AAS320) is used to create a report proposals for the Z4 to German Bundesbank. All ingoing and outgoing payments for specific services over a certain amount limit shall be reported.

The proposal must be reviewed. Note that the proposal shows all relevant transactions with a (proposed) indication which transactions shall be reported. There are filters on transactions classified to be reported.

When using the summary view in (AAS333), all transactions are summarized per reporting codes and country. From this view, the export to Excel can be used and a CSV file can be created and uploaded to the AWV Bundesbank portal.

Note: Rounding of the amounts to thousand EUR must be manually done in Excel.
Note: The Text field must be a column in the 'Summary' view and must be placed just before the Country column.

Configuration guidelines

We recommend that you check the KB2064486 and attachments and the M3 BE User Documentation Electronic Z4 Reporting to Bank and Manage Claim/Liability Reports.

Program ID Program name Description or comment
CRS165 Number Series. Open

Setup number series 86/0 - Electronic reporting of

payments to national bank
CRS405 FAM-Function Open

IDs AR30, AR 80, AP20, AP3x, set '3' for parameter 'VAT on cash discounts' method and value '3' for 'Split payment transaction'

AAS911 Settings. Electronic Bank Reporting Amount limit: 12500,00 EUR

Description 1: “BA Kennzeichen”, length =1, numeric; for ingoing amounts set the “BA Kennzeichen” = 1, for outgoing payments set the “BA Kennzeichen” = 2

Description 2: “Kennzahl” (Reporting code), length =3, numeric

Description 3: “Kapitel-Nummer”, length =2, only needed for specific “Kennzahl” codes

Description 4: free, do not use

Description 5: “V/E Kennzeichen", length =1, only applicable for quite specific cases

Set different rate types for AP and AR (Buy/Sell) according Bundesbank requirements.
AAS910 Electr. Bank Reporting Reason codes Set up definitions for a specific “Rule”; proposed value is “DE”. Basically, it can be anything. The rule is used as selection criteria when creating the Z4 proposal.

Setup per payer or payee and optional per account (used for specific services) the “BA Kennzeichen”, “Kennzahl”, “Kapitel-Nummer” and “V/E Kennzeichen”.