Germany Financial Statements

Important:

If you want to use this feature of the Germany Localization SuiteApp, you must have the Country-Specific Reports SuiteApp installed. To learn more about this SuiteApp, see Recommended SuiteApps.

With the Germany Localization SuiteApp, NetSuite can generate and display supported German financial statements with the content and in the format prescribed by law. The following financial statements are currently supported by the Germany Localization SuiteApp:

Balance Sheet mapped to SKR 03 Chart of Accounts
Balance Sheet mapped to SKR 04 Chart of Accounts
Income Statement in total costs format mapped to SKR 03 Chart of Accounts
Income Statement in total costs format mapped to SKR 04 Chart of Accounts
Income Statement in the cost of sales format mapped to SKR 03 Chart of Accounts
Income Statement in the cost of sales format mapped to SKR 04 Chart of Accounts
Trial Balance (Summen-Salden-Liste, or SuSa in German) mapped to SKR 03 Chart of Accounts
Trial Balance (Summen-Salden-Liste, or SuSa in German) mapped to SKR 04 Chart of Accounts

Important:

SKR03 and SKR04 accounts are mapped to Country-Specific Reports. When creating new account, make sure you assign it to respective variable.

Note:

Accounts that fall within the SKR03 and SKR04 account intervals don't need to be mapped manually in the balance sheet equity section by the user.

All German Financial Statements can be exported in PDF and CSV formats. For more information, see Exporting a Report.

Installing Germany Financial Statements

After installing the Germany Localization SuiteApp and installing one of the Charts of Accounts, you should install German financial statements as well. If you are using the SKR 03 Chart of Accounts template, install SKR 03 reports. If you are using the SKR 04 Chart of Accounts template, use SKR 04 reports.

To install Germany financial statements:

Go to Setup > Customization > Germany Localization.
Click the Install action link for the set of reports that you would like to use (either SKR 03 or SKR 04).
The installation process usually takes up to 20 minutes to accomplish. To monitor the progress, go to Setup > Import/Export > View CSV Import Status.
Go to Reports > Financial > Country-Specific Reports and check whether the new reports have been installed and can be properly displayed.

Important:

When the Germany Localization SuiteApp is updated to a newer version, go to the Germany Localization overview page (Setup > Customization > Germany Localization) to ensure your financial statements are installed and up to date. For more information, see Germany Localization Overview.

Net Amount Calculation Method

To calculate net amount values correctly, all financial statements delivered by the Germany Localization SuiteApp use the special method “Debit minus Credit”. Note that this only applies to financial statements provided by the Germany Localization SuiteApp; net amount values in your other financial statements will be calculated as usual.

Displaying Germany Financial Statements

The following procedure describes how to view the German financial statements.

To view one of the Germany financial statements:

Go to Reports > Financial > Country-Specific Reports.
Select the financial statement that you would like to display from the Report dropdown list.
Click the Show Report button.

Germany Balance Sheets

The Balance Sheet page is displayed including two forms – Assets and Equity and Liabilities. Each report section or line is based on a selection of SKR 03 or SKR 04 accounts as prescribed by law. The forms are presented in the format prescribed by law and prevailing accounting practices. Columns for the current period (Selected period (N)) and previous period (Selected period (N-1)) are also provided. Use the Period To filter to select the end of the period and click the Show Report button again to refresh the report data.

You can also check the Show Individual Accounts box to display individual accounts under each category.

To export the report in the PDF, click on the Export to PDF button.

Germany Income Statements

Note:

The German Income Statements (both SKR 03 and SKR 04) are available in two different formats: cost of sales format and total cost format.

Each section or line of every Income Statement is based on a selection of SKR 03 or SKR 04 accounts as prescribed by law. The form is presented in the format prescribed by law and prevailing accounting practices. Columns for the current period (Selected period (N)) and previous period (Selected period (N-1)) are also provided. Use the Period From and Period To filter to select the period and click the Show Report button again to refresh the report data.

You can also check the Show Individual Accounts box to display individual accounts under each category.

To export the report in the PDF, click on the Export to PDF button. The download will start.

German Trial Balance

German Trial Balance (Summen-Salden-Liste, or SuSa in German) contain the list of current totals and account balances. Each section or line in German Trial Balance is based on a selection of SKR 03 or SKR 04 accounts as prescribed by law. The form is presented in the format prescribed by law and prevailing accounting practices. Use the Selected Period filter to select the month, quarter, or the fiscal year that you would like to filter out. Then click the Show Report button again to refresh the report data.

Filters Available for Germany Financial Statements

The Filters section (above financial statements) allows you to select data on your reports in different ways:

Filter	Description
Subsidiary Context	Select the subsidiary from the dropdown list. Note: This filter is only available on OneWorld accounts. See Introduction to NetSuite OneWorld chapter for more information.
Period From	Define the beginning of the period to recalculate. Select either a fiscal year, a quarter, or a month.
Period To	Define the end of the period to recalculate. Select either a fiscal year, a quarter, or a month.
Selected Period	Select the period for which the data will be displayed. Select either a fiscal year, a quarter, or a month.

Filter

Description

Subsidiary Context

Select the subsidiary from the dropdown list.

Note:

This filter is only available on OneWorld accounts. See Introduction to NetSuite OneWorld chapter for more information.

Period From

Define the beginning of the period to recalculate. Select either a fiscal year, a quarter, or a month.

Period To

Define the end of the period to recalculate. Select either a fiscal year, a quarter, or a month.

Selected Period

Select the period for which the data will be displayed. Select either a fiscal year, a quarter, or a month.

After adjusting your filters, click the Show Report button. The form will be automatically updated with the accounts and balances of the selected subsidiary.

Displaying Consolidated Balance Sheets

This option is only available if you are using NetSuite OneWorld account with Multiple Currencies enabled. From the list of subsidiaries on the Balance Sheet page, select a consolidated subsidiary (one that has one or more subsidiaries using a different currency than the parent subsidiary). You will recognize them by having the word consolidated in brackets next to their name. Next, click the Show Report button. The form will be automatically updated.

Note:

In NetSuite, the CTA (Cumulative Translation Adjustment) is used on consolidated reports to make them balance. This is necessary because the exchange rate types of the accounts (with multi-currency enabled) on reports may differ and different rates may be used, resulting in an imbalance. For more information, see General Company Features and Cumulative Translation Adjustment (CTA) Overview.

General Notices