1. Country-Specific Features
  2. Germany Help Topics
  3. Germany-specific SuiteApps
  4. Germany Localization
  5. Germany Audit Files: euBP Data Extract

Germany Audit Files: euBP Data Extract

The Germany Localization SuiteApp supports the generation of euBP-compliant accounting reports. The euBP (elektronisch unterstützte Betriebsprüfung) process enables the electronic submission of payroll and financial accounting data to the German Pension Insurance (Deutsche Rentenversicherung / DRV) in accordance with § 28p Abs. 6a SGB IV. The submission of accounting data is required from January 1, 2025, with an option to request an exemption until January 1, 2027. Organizations that already transmit payroll data electronically can submit accounting data through the same payroll interface.

This feature enables accountants to extract general ledger transactions for selected accounts and generate trial balance data for all accounts within a specified reporting period. The extracted data is converted into the required euBP file format and can be submitted electronically to the German Pension Insurance.

To successfully generate the euBP Data Extract report, you must meet the following requirements:

The euBP Data Extract report supports Multi-Book Accounting and Period End Journal Entries features. For more information, see Multi-Book Accounting Overview and Period End Journal Entries.

The euBP Data Extract is generated as a TXT file. Click Download on the relevant line in the Report Execution Log table to start the download. For more information about specific report sections, see euBP Data Extract Report Sections.

To electronically submit your report file, use the partner portal Xisi Meldecenter GmbH. For more information about the portal and upload procedure, see the links below:

euBP Data Extract Setup

The euBP Data Extract setup is a necessary step to successfully generate the euBP report. Follow the procedure below.

To Complete the euBP Data Extract Setup:

  1. Go to Reports > Tax > Country Tax Reports.

  2. In the Report Name field, select euBP Data Extract.

  3. Click the euBP Setup button.

  4. In the Setup Tax Filing window, fill the following fields:

    Field Name

    Required Field

    Description

    DRV Company Number

    Y

    Enter the company number of the audited entity.

    DRV Sender Number

    N

    Enter the company number of the entity that is processing the audit file.

    Telephone Contact Person

    Y

    Enter the telephone number of the contact person that created the file.

    Data Transmission Period From

    Y

    Enter the start of the examination period as per order.

    Note:

    Make sure that:

    • The generated file or files cover the complete audit period scope without gaps.

    • The period selected on the Country Tax Report page falls entirely within the Data Transmission Period.

    Data Transmission Period To

    Y

    Enter the end of the examination period as per order.

    Note:

    Make sure that:

    • The generated file or files cover the complete audit period scope without gaps.

    • The period selected on the Country Tax Report page falls entirely within the Data Transmission Period.

    Reason for Data Transfer

    Y

    Select one of the following reasons for data transfer:

    • Existing audit notice/audit date

    • Change of system-audited billing program

    • Change of service provider

    Report Split

    Y

    Your report must be split into two or more files if its file size exceeds 100 MB or if it has more than 100000 lines. In this case, select the following in the Report Split field:

    • Select Submission Incomplete for every report file except the last one.

    • Select Submission Complete for the last report file.

    Note:

    For example, if your report is split into four files:

    • Select Submission Incomplete for files 1-3

    • Select Submission Complete for file 4

    Report Cancellation

    Y

    Report cancellation voids a previously submitted report. Based on your needs, select one of the following options:

    • No Cancellation

    • Cancellation

    Type of Financial Statement

    Y

    Select one of the following types of financial statement:

    • Tax book

    • Commercial book

  5. Click Save.

euBP Data Extract Report Sections

The generated TXT file of the euBP Data Extract report contains the following sections:

  • Section 1 VOSZ: Vorlaufsatz: Sender information

  • Section 2 DSKO: Datensatz Kommunikation: System and parties information

  • Section 3 DSST: Datensatz Steuerung: Report header

  • Section 4 DSKT: Datensatz Konto: Trial Balance - contains one line per account

  • Section 5 DSBU: Datensatz Buchungssätze: Transactions - contains one line per transaction

  • Section 6 NCSZ: Nachlaufsatz: Report Footer

Related Topics

General Notices