Reports for Germany

Overview

The reports for Germany provide the details needed by companies to meet the statistical reporting requirements of the Federal Bank. You can use these reports as a basis for submitting your official declarations to the Federal Bank. These reports also simplify the auditing of general ledger journals, and streamline the reconciliation of outstanding receivables and liabilities of foreign customers and suppliers with subledger records.

The reports for Germany include:

Z4 Report for Germany: Lists all incoming and outgoing payments made through a foreign bank for the selected ledger and date range. Only payments more than the legally defined threshold amount are printed.
Z5A Report for Germany: Provides details of receivables and liabilities of foreign customers and suppliers, both internal and external. Based on the Summarize option selected, the Z5A Reconciliation Report or Z5A Sheet 2 Report is printed. The Z5A Reconciliation Report lists single transaction amounts that reconcile with the aggregated amounts in the Z5A Sheet 2 Report. Detailed amounts are provided per customer or supplier for each transaction or invoice number on a given date.
Journal Details Report for Germany: Provides posted general ledger journal activity for a given period or date range for auditing posting sequences. In Germany, general ledger journals must be sequenced by posted date. The report is generated for a range of accounting or posting dates to show all details of the sequenced journals and daily total amounts.

The following figure is an example of the Z4 Report for Germany.

This image displays the Z4 Report for Germany.

The following figure is an example of the Z5A Reconciliation Report for Germany.

This image displays the Z5A Reconciliation Report for Germany.

The following figure is an example of the Z5A Sheet 2 Report for Germany.

This image displays the Z5A Sheet 2 Report for Germany.

The following figure is an example of the Journal Details Report for Germany.

This image displays the Journal Details Report for Germany.

Key Insights

For accurate statistical reporting on the Z4 Report for Germany, enter the following information for transactions:

For Payables:
- Record type
- Payment reason
For Receivables:
- Record type
- Reason

Only transactions that are accounted and posted to the general ledger are selected for reporting.

Before you submit the Journal Details Report for Germany, you must configure the general ledger accounting sequence to generate the sequence while posting the journal.

Report Parameters

The following table lists selected process parameters of the Z4 Report for Germany:

Name	Description
Ledger	Specify the ledger for reporting.
Legal Entity	Specify the legal entity for reporting. If you have set up ledgers with multiple legal entities, this parameter will allow you to generate the Z4 reports for a specific legal entity.
Threshold	Specify the statutory limit used to determine whether an individual payment is reported. The default value is the current statutory limit of 12,500 EUR, and only payments more than this limit are reported.

The following table lists selected process parameters of the Z5A Report for Germany:

Name	Description
Ledger	Specify the ledger for reporting.
Legal Entity	Specify the legal entity for reporting. If you have set up ledgers with multiple legal entities, this parameter will allow you to generate the Z5A reports for a specific legal entity.
Summarize	Select the Summarize option for the Z5A Reconciliation Report, or leave the option blank for the Z5A Sheet 2 Report.
Party Name	Indicate a supplier or customer to reconcile specific payments.
Threshold Amount	Specify the statutory limit used to determine whether an outstanding receivables or payables amount is reported.

The following table lists selected process parameters of the Journal Details Report for Germany.

Name	Description
Ledger	Specify the ledger for reporting.
Filter Conditions Defined	To audit a specific account, specify the segments and values.
Document Sequence Number	Specify the reporting sequence name used to number the posted journal. You can audit journals that have a specific reporting sequence name and number assigned.
From/To Document Number	Enter a specific range to verify that sequence numbers are assigned chronologically.
First Page Number	Specify the starting page number for the report.

Frequently Asked Questions

The following table lists frequently asked questions about the reports for Germany.

FAQ	Answer
How do I find these reports?	Schedule and run these reports from the Scheduled Processes work area on the Navigator menu.
Who uses these reports?	General Accounting Manager Payables Manager Receivables Manager Financial Analyst
When do I use these reports?	Use these reports to: Review the incoming and outgoing payments that exceed the statutory limit. Report all payments with payment reason, reason code, and record type. Report outstanding receivables and payables of foreign customers and suppliers that exceed a prescribed threshold. Print daily totals for a given period, or accounting and posting dates. Print journals that have posting errors. Audit reporting sequence name and numbers assigned to the journals, and verify they are assigned in ascending order based on the journal posting date. Audit posting document sequences for a range of accounting or posting dates.
What type of reports are these?	Oracle Analytics Publisher