A distinction is made between two areas when transmitting the e-balance sheet in Tax Balance:

  • GCD (Global Common Data), which specifies which master data are to be transmitted, such as the name of the company, legal form etc.
  • GAAP (Generally Accepted Accounting Principles), which represents the taxonomy for the financial data, such as accounts and items of the balance sheet, P&L, etc.

In Tax Balance, you can assign and adjust the data for the GAAP area you have previously imported to the taxonomy structure under GAAP Reports.

The GAAP Reports functional area is displayed in the tree view in Tax Balance as soon as you open a tax balance sheet under Company:

Shows the 'Accounts' workspace in Tax Balance with the tree view on the left, where the 'GAAP Reports' functional area lists workspaces such as 'Balance Sheet', 'Accounts', 'Mappings', 'Adjustments', 'Footnotes', 'KKE - Equity Accounts' and 'Special Balance Sheets'. Highlighted in red is 'GAAP Reports' in the tree view.
'GAAP Reports' functional area

In the Balance Sheet workspace in Tax Balance, you can:

  • Display the values mapped to the balance sheet and P&L statement structure
  • Show accounts
  • Display, adjust, and add adjustments

To display only values of specific adjustment levels, you can restrict the selection of adjustment levels in the drop-down list at the top left edge:

Shows the opened adjustment level selection '3 / 3 levels' in the 'Balance Sheet' workspace in Tax Balance with the 'Adjustment levels' tab, the selected levels 'GTC Test', 'Adjustment level German GAAP' and 'JA', and the 'Apply' button. Highlighted in red is the adjustment level selection.
Selection of adjustment levels

Click the row of an account or an adjustment to open the detail view and edit the details. How to proceed is described in Accounts and Adjustments in the following.

The accounts for your GAAP reports in Tax Balance are managed in the Accounts workspace:

Shows the 'Accounts' workspace in Tax Balance with the 'Edit mapping', 'Add' and 'More actions' buttons and the opened 'More actions' menu with the options 'Apply mappings', 'New grouping account', 'Delete all accounts and mappings' and 'Delete all mappings'. Highlighted in red are the 'import accounts' link, the 'More actions' button and the options of the 'More actions' menu.
Functions for the 'Accounts' workspace.

The following functions are available for accounts in Tax Balance:

  • Import accounts

  • Display and, if necessary, adjust details for imported, manually created, and virtual accounts by clicking the account.

  • Via the More actions menu, you can:

    • Apply existing mappings
    • Create a new grouping account
    • Delete all accounts and mappings
    • Delete all mappings

You can also create accounts and the corresponding taxonomy mapping manually. To do this, click Add and enter the account number, a description, and the manual value for the account in the displayed dialog. You can additionally assign the taxonomy item for the account under Mappings.

Shows the details of the account '000-dpa' in Tax Balance with the fields 'Account number', 'Description', 'Imported value' (marked 'READ ONLY'), 'Manual value' and 'Mappings', and the 'Delete' and 'Save' buttons.
Editing account details

You can assign taxonomy items to the imported, manually created, or virtual accounts in the Mappings workspace in Tax Balance.

To do this, drag and drop the accounts on the left side to the desired taxonomy item on the right side.

Shows the 'Mappings' workspace in Tax Balance with the account list on the left, with the columns 'Account' and 'Account value' and accounts marked 'MAPPED' such as '10023 Sonstige VG', and the taxonomy on the right, with the columns 'Taxonomy item' and 'Value' and items such as 'Balance sheet in accordance with RechVersV' and 'Total assets [Mandatory sum-field]'. Highlighted in red is the drag handle of the account 'MK_1 Ergenbisverwedung'.
Assigning accounts to taxonomy items

With the More actions menu, the following functions are also available in Tax Balance:

  • Apply mappings from the previous year or any tax balance sheet. A wizard will guide you through the necessary steps.
  • Create a Mapping Report in XLSX format that provides information on mapped and unmapped accounts as well as grouping accounts.
  • Delete all mappings that have already been made.
Shows the 'Mappings' workspace in Tax Balance with the opened 'More actions' menu containing the options 'Apply mappings', 'Mapping Report' and 'Delete all mappings'. Highlighted in red are the options of the 'More actions' menu.
More actions for mappings

With the three-dot menu of a taxonomy item in Tax Balance, you can also:

  • Display detailed information on the taxonomy item
  • Delete all mappings of the item
  • Expand or collapse all subordinate items
Shows the opened three-dot menu of the taxonomy item 'Balance sheet in accordance with RechVersV' in Tax Balance with the options 'Detailed information', 'Delete all mappings of the item', 'Expand' and 'Collapse'. Highlighted in red are the three-dot icon and the menu options.
Three-dot menu of a taxonomy item

In the Adjustments workspace, you can enter tax deviations based on commercial-law values at adjustment levels and create any company-specific adjustment levels required for this purpose.

For detailed instructions, see Creating and Configuring Adjustments.

You can calculate the comparison of business assets in the Comparison of Business Assets workspace.

To do this, open the More actions menu at the top right and click Calculate.

Shows the 'Tax-based Comparison of Business Assets' page in Tax Balance with the columns 'Item' and 'Value' and items such as 'Net profit / net loss (accrual basis accounting)', 'Business assets at the end of the previous financial year' and 'Capital adjustments'. Highlighted in red are the 'More actions' button and the 'Calculate' option.
Calculating business asset comparison

If necessary, you can edit the calculated values manually by double-clicking the value.

The values of the comparison of business assets are calculated in accordance with the specifications of the technical guidelines of the taxonomy. At corporations, the values are calculated from the balance sheet of the current year and the balance sheet of the previous year. At partnerships, the values are calculated from the balance sheet and the capital account development of the current year.

Any values that have already been entered manually or calculated previously will be deleted. This action cannot be undone.

In the Statement of Changes in Fixed Assets workspace, all items of the statement of changes in fixed assets that have been mapped in the balance sheet and/or for which you have maintained a value are displayed. Furthermore, you can import a fixed asset schedule or transfer the closing balance from the previous year to the fixed asset schedule via the More actions menu:

Shows the upper section of the 'Statement of Changes in Fixed Assets' workspace in Tax Balance with the options 'Show item properties' and 'Show all items' and the columns 'Item', 'Commercial balance sheet v...', 'Reconciliation value' and 'Tax balance sheet value'. Highlighted in red are the 'More actions' button and the 'import the statement of changes in fixed assets' link.
Options for the statement of changes in fixed assets

If necessary, you can enter or edit the displayed values by clicking the desired item in the table and then selecting the item in the Asset schedule structure. The following dialog is displayed, where you can enter the values:

Shows the dialog 'Anschaffungs- und Herstellungskosten zum Anfang der Periode' for an item of the fixed asset schedule in Tax Balance with the fields 'Commercial balance sheet value' and 'Reconciliation value' and a table with the rows 'Imported values', 'Manual values', 'Calculated values from the value development', 'Calculated values from the balance sheet structure' and 'Value in e-balance sheet'. Highlighted in red are the 'Commercial balance sheet value' and 'Reconciliation value' fields.
Editing values in the fixed asset schedule

Activate the Show item properties option to display taxonomy-based properties in square brackets after each item, indicating whether the tax authority requires a value to be entered for that item.

The following item properties are displayed in Tax Balance, for example:

  • Mandatory field
  • Mandatory sum-field
  • Necessary for calculation, if available
Shows a section of the fixed asset schedule in Tax Balance with items such as 'Fixed assets [Mandatory sum-field]', 'Internally generated industrial property rights and similar values [Necessary for calculation, if available]' and 'Purchased concessions, industrial and similar rights and assets, licences in such rights and assets [Mandatory field]'. Highlighted in red are the 'Show item properties' option and the item properties displayed in square brackets next to the items.
Item properties in the fixed asset schedule

You can add footnotes to items in the Footnotes workspace.

Shows the 'Footnotes' workspace in Tax Balance with the 'Add' button, the 'Search footnotes' field and an empty table with the columns 'Title' and 'Text' and the message 'No elements exist'.
Adding footnote

To add a footnote in Tax Balance, proceed as follows:

1

In the Footnotes area, click Add.

2

Enter a meaningful title for the footnote.

3

Enter the content of the footnote.

4

Choose the item(s) to which the footnote should be added.

5

Click Save.

If explanations of several items are to be summarized in one footnote, we recommend transmitting this footnote to the Tax explanatory report item in the Notes section of the report.

You can enter the values for the development of equity accounts in the KKE - Equity Accounts workspace.

To do this, click the desired item in the Account type column and enter the values for the respective items in the displayed dialog by clicking the corresponding field.

Shows the 'Changes in Capital Accounts - Equity Accounts' page in Tax Balance with the 'capital account development - import equity accounts' link, the totals 'Commercial balance sheet value', 'Reconciliation value' and 'Tax balance sheet value', and an empty table with the columns 'Name', 'Account type', 'Commercial balance sheet value', 'Reconciliation value' and 'Tax balance sheet value'. Highlighted in red is 'KKE - Equity Accounts' in the tree view.
'Changes in Capital Accounts - Equity Accounts' page

You can also apply the closing balances from the previous year via the More actions menu.

You can edit the values for the development of debt capital accounts in the KKE - Debt Capital Accounts workspace.

To do this, click the desired item in the Account type column and enter the values for the respective items in the displayed dialog by clicking the respective field.

Shows the 'Changes in Capital Accounts - Debt Capital Accounts' page in Tax Balance with the 'capital account development - import debt capital accounts' link, the totals 'Commercial balance sheet value', 'Reconciliation value' and 'Tax balance sheet value', and an empty table with the columns 'Name', 'Account type', 'Commercial balance sheet value', 'Reconciliation value' and 'Tax balance sheet value'. Highlighted in red is 'KKE - Debt Capital Accou...' in the tree view.
'Changes in Capital Accounts - Debt Capital Accounts' page

You can also apply the closing balances from the previous year via the More actions menu.

You can add issues for individual partners and then edit the values of the issues in the Special Balance Sheets workspace.

You can also transfer the closing balances from the previous year to the special balance sheet via the More actions menu.

Only partners who have announced the special balance sheet in the GCD master data of the overall company and whose affiliation overlaps the balance sheet period are available for selection.

You can add issues for individual partners and then edit the values of the issues in the Supplementary Balance Sheets workspace.

You can also transfer the closing balances from the previous year to the supplementary balance sheet via the More actions menu.

Only shareholders who have announced the supplementary balance sheet in the GCD master data of the overall company and whose affiliation overlaps the balance sheet period are available for selection.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.