Germany Financial Statements
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
SKR03 and SKR04 accounts are mapped to Country-Specific Reports. When creating new account, make sure you assign it to respective variable.
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.
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
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. |
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.
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.