Companies operating on the German market are obliged to submit their financial statements in a digital form.  Data useful for preparing such statements may be exported from Comarch ERP Standard system. The generated files contain two groups of information concerning:

• balances of bookkeeping accounts
• fixed assets

The files can then be imported into Comarch eBilanz application in order to be used in the creation of the financial statements.

Functionality configuration

Before starting to use the functionality, it is necessary to perform configuration:

• select the parameter Export to eBilanz available in the Accounting section on the company form

• assign the value of the Firma attribute (an attribute of the Text type automatically attached to the Company Structure Center object) to an appropriate company
• assign the values of the attributes Gruppe 1 and Gruppe 2 (attributes of the List type automatically attached to the Subsidiary Account object) to appropriate accounts

The functionality also uses:

• a predefined generic directory Taxonomie containing a classification required for the needs of attaching features to journal entries and used in Comarch eBilanz application
• a Taxonomie attribute (an attribute of the Directory type), automatically attached to the Transaction The scope of using the attribute has been described in the section on the export of fixed assets.

Export of balances

On the basis of a calculated trial balance, it is possible to create a file containing information on the balances of displayed accounts. For this purpose, it is necessary to:

• select [Accounting] → [Trial Balance]
• set appropriate parameters in the filter and select the [Recalculate] button
• select the [Export to eBilanz] button and choose one of the three options determining the scope of data to be exported:
  • [Balances] – it exports the following data: the value of the Firma attribute, an account name, account balance, balance type
  • [Extended Balances] – it exports the same data as the [Balances] option and additionally: the values of the Gruppe 1 and Gruppe 2 attributes, information on groups 1 and 2, and an account description
  • [Extended Balances (Attributes)] – it exports data for the Balances option and, additionally, values of two first attributes displayed on the list on which the export is being executed, information regarding group 1 and group 2, account description

Whichever option is chosen, a dialog box will be opened, where it will be necessary to indicate the name and location of the file. Once the [Save] button is selected, a .csv file will be created in the specified location.

The table below presents information on the exported data:

Export of fixed assets

The export of fixed asset data is based on a financial statement using the predefined attribute Taxonomie. To perform the export, it is necessary to complete the following steps:

• assign the values of the Taxonomie attribute to single-sided entries. It is possible to assign multiple values in a single batch, following the identification of entries related to the same types of economic operations (e.g. on the basis of an account, description, or ledger). Additionally, on the basis of values of the assigned Taxonomie attribute, the user may filter single-sided entries in the following locations:
  • Trial Balance list
  • Clearings list
  • Journal Entries: Account Filter list

• define a financial statement and assign the values of the Taxonomie attribute to statement items

• recalculate the financial statement (it is necessary to select [Recalculate] and then [Recalculate] again)
• export the file using the [Export to eBilanz] button. A dialog box will be opened, where it will be necessary to indicate the name and location of the file. Once the [Save] button is selected, a .csv file will be created in the specified location.

The table below presents information on the exported data: