Understanding the Z5a Sheet 2 Report
Some European countries require that the balance of outstanding payables and receivables with foreign entities be reported on a periodic basis. The Deutsche Bundesbank (German Federal Bank) requires that various reports be submitted on a monthly basis, including the Z5a sheet 2. The Z5a Sheet 2 report is used to collect data that you can transfer to the official form for the Deutsche Bundesbank (German Federal Bank). The Z5a sheet 2 report details of "Forderungen und Verbindlichkeiten gegenuber Gebietsfremden aus dem Waren-und Dienstleistungs verkehr or Claims on and liabilities to nonresidents arising from transactions in goods and services. Foreign payables and receivables are classified by country, and they are reported in thousands of euros.
The Z5a Sheet 2 reports the group's data by affiliated or nonaffiliated companies, by accounts payable or accounts receivable, by prepayments, short-term payments or long-term payments, and by country and currency.
The basic requirement of the Z5a Sheet 2 is to report the company's open accounts payable and open accounts receivable amounts that were transacted with a foreign entity. For the purpose of generating foreign payables tables, all WF - As Of Accounts Payable Ledger table (F0411A) records that are posted but not paid are considered open.
All records written to the Foreign Receivables and Payables - EMEA table (F74900) should:
Relate to the reporting company.
For the Z5a Sheet 2 report, the value that is entered during data selection must be equal to the reporting company.
Be posted.
All records in tables F0411A and F03B11 must have a status equal to D, where D equals the transactions that have been successfully posted or that have been processed through the cash entries programs with a one-to-one record relationship with the general ledger (for example, adjustments, journal entry from cash receipts, and so on).
Have transaction dates falling on or before the report ending date.
The report ending date is the general ledger date.
Have a customer country code that is different from the country code of the reporting company.
Be identified for affiliation or nonaffiliation.
Be identified for EMU membership.
For the program to determine which currencies to summarize as euro currencies, you must set up the user-defined code list for European Union Members (00/EU).
Be identified as a prepayment, long-term obligation, or short-term payment.
A long-term obligation is normally defined as a payable that is due one year from the processing date of the transaction. The value that is entered in this processing option is added to the general ledger date (processing date) and is compared with the due date of the transaction. If the calculated date is equal to or beyond the due date, the transaction is considered a long-term obligation. The system writes a 2 to the Foreign Receivables and Payables - EMEA table (F74900) for long-term obligations. A short-term obligation is normally defined as the calculated date minus the due date. The system writes a 3 to table F74900 for short-term obligations.
Prepayments are determined by their general ledger offset for accounts receivable transactions and by their document type for accounts payable transactions.
The Z5a Sheet 2 Report - Summary (R74414) report provides totals of both accounts receivable and accounts payable records for prepayments, short-term payments, and long-term payments for affiliated companies and nonaffiliated companies. The totals are listed separately by country and currency.
The German Z5a Sheet 2 Report - Detail (R74415) is not required for reporting the accounts receivable and accounts payable totals to the Deutsche Bundesbank (German Federal Bank). This report contains transaction level detail, and it can be used for the review and audit of transactions.