Recapitulative statement

Use this function to collect and display the values for the German Recapitulative Statement. The output of the calculated data can be printed or exported to the X3 ELSTER Client for online submission.

Exported files are current with 2025 regulations.

The data selection is controlled on by a company or a group of companies and by the start and end dates for the selection. The data is extracted from the main legal ledger, which must be in Euros.

 The time range can only be either a calendar month, a calendar quarter or a calendar year.

Prerequisites

Refer to documentation on Implementation.

Screen management

The calculated values from the data extraction are shown on two tabs. The Result tab shows the data grouped by EU VAT no. and turnover type. When you select a line on the Result tab, details for the underlying documents display on the Documents tab.

In addition, the results are shown with a traffic light status indicator. By default, an export is only possible when all entries have a green status. You can change this setting in the GERRSEXTMP - Temporary journal export (LOC chapter, GER group) parameter. Set the parameter to Yes and select the option to Hide invalid in the header of the screen.

Selection

Group (GRP)

Enter a company group to extract values for the group.

Company (CPY)

Enter a company.

Legislation (LEG)

This field displays the legislation for the selected company.

Site (FCYLIN)

Enter a site for the selected company to limit the extraction to that site. This field is not available if you enter a company group.

Tax identifier (CRN)

This field displays the tax identifier for the company or company group.

EU VAT no. (GEREECNUM)

Displays the EU VAT No.:

  • In the header information, this fields relates to the legal master data of the company or group of companies, depending on the entered selection.
  • In the table, this field relates to the EU VAT No. of the BP.
ELMA5 ID (GERCODELMA)

Displays the ELMA5 ID  according to the legal master data of the company or group of companies. The ELMA5 ID is provided by the German fiscal authorities and is only needed for Recapitulative Statements with more than 1000 detail lines.

Start date (DATDEB)

Enter a date rate to select records within those dates. The date range can only be a calendar month, a calendar quarter, or a calendar year. Generating the statement for a calendar year is only for internal reconciliation purposes, and it is not an official declaration time range.

End date (DATFIN)

Enter an end date for records to be include or the end date for the validity of an configuration entry.
Currency (CUR)

This field displays the currency from main legal ledger.

Exclude invalid entries (FLGVALIDON)

If activated, invalid records are suppressed on data processing and not exported. This is only available when the GERRSEXTMP - Temporary journal export parameter (LOC chapter, GER group) is active.

Result tab

Grid

Status indicator (FLG)

The status is indicated by color:

  • Green: the results include all necessary information available and can be exported
  • Yellow: the results include temporary postings and cannot be exported
  • Red: the results include missing information or documents with an incorrect status like simulated, template, and so on, and cannot be exported

A detailed information about the status of each entry is displayed in the "Result" tab in the column "Comment".
EU VAT no. (GEREECNUM)

Displays the EU VAT No.:

  • In the header information, this fields relates to the legal master data of the company or group of companies, depending on the entered selection.
  • In the table, this field relates to the EU VAT No. of the BP.
Turnover (AMTTRN)

Amount considered in the Recapitulative Statement.

Tax (TAX)

Displays the tax code of the entry.

Turnover type (TRNTYP)

Displays the type of the turnover. It is determined by the matching between turnover types and tax rules defined in the Recapitulative Statement Parameter screen.

Country (CRY)

Displays the BP's country.

Documents tab

Grid

Status indicator (FLG)

This traffic light-like indicator displays the status of an entry:

  • Green: all necessary information available
  • Yellow: Warning, because the result contains temporary postings. No export possible
  • Red: Error, because the result contains missing information or documents with wrong status like simulated, template etc. No export possible.

A detailed information about the status of each entry is displayed in the "Result" tab in the column "Comment".
EU VAT no. (GEREECNUM)

Displays the EU VAT No.

  • In the header information, this fields relates to the legal master data of the company or group of companies, depending on the entered selection.
  • In the table, this field relates to the EU VAT No. of the BP.
Customer (OFFACC)

This field is used to specify the contra account.

 The counterpart of each entry line is updated upon creation. If left blank, it will be initialized upon journal posting.
Turnover (AMTTRN)

Amount considered in the Recapitulative Statement.

VAT code (TAX)

Displays the tax code of the entry.

BP tax rule (VACBPR)

This column relates to the accompanying BP tax rule. The BP tax rule must have the setting EU (intra-community) tax.

Document type (TYP)

The invoice type suggested by default is linked to the SIVTYP - User invoice type parameter. You can modify it if necessary by choosing an invoice type from the list of invoice types that have been defined.
The customer invoice type:

  • Is used for the Sales and BP Customer invoices;
  • Identifies a category of invoice (invoice, credit memo etc.) along with a posting structure for the posting of the invoices;
  • Is associated with a type of journal for which a counter (manual or automatic) is specified.
    • If no counter is specified in the journal type and no journal number is manually specified on invoice entry the program will attribute a journal number according to the counter set up in the Counter assignment table.
    • When no journal type is associated to the invoice type the journal type specified on the automatic journal is used (as well as the associated counter).

On invoice entry, only an invoice type with a legislation and company group consistent with those of the company linked to the sales site can be entered.

For further information, click here.
Document no. (NUM)

Displays the document number of the underlying invoice.
Description (DESVCR)

Description text of the document.

Turnover type (TRNTYP)

Displays the type of the turnover. It is determined by the matching between turnover types and tax rules defined in the Recapitulative Statement Parameter screen.

County (CRY)

Displays the BP's country.

Comment (COMMENT)

Displays a descriptive comment for the entry. In case of red (errors) or yellow (warnings) status, the reason is displayed in more detail.

Document
Customer

Specific buttons

Report

This button is used to display the result of the data extraction as a print report.

Export

This screen is used to export the result of the Recapitulative statement's data extraction as a file suitable for online transmission with the Sage X3 ELSTER Client.

Two different types of export are available:

  • CSV for Sage ELSTER Client: Generates an export suitable for processing by the Sage X3 ELSTER Client
  • CSV for ELSTER Online: Generates an export suitable for manual uploading to the ELSTER Online webportal

The Sage X3 ELSTER Client is a tool for the online transmission of German tax declarations. It must be installed separately on the workstation where needed. The file exported by this function can be imported into the Sage X3 ELSTER Client for further processing.

For more detailed information refer to the documentation provided with the setup of the Sage X3 ELSTER Client.
Memo Select this action to save the current settings to reuse later using a unique memo code. The memo code is linked to your user profile, not to the function or the screen.
Recall Enter or select the unique memo code you created to apply the settings saved with that code.
Delete memo This action deletes a saved memo code and cannot be undone.