GoBD (Data Export)

Overview

GoBD, also known as Grundsätze zum Datenzugriff und zur Prüfbarkeit digitaler Unterlagen (GDPdU), is required in Germany if requested by the financial or tax authorities. The export is designed to provide external auditors and tax authorities in Germany and other countries with an extract of the General Ledger either in its entirety or for selected subsets of the General Ledger or sub-ledger.

The purpose of the GOBD data export is to produce several CSV files and one XML file for tables of contents that are based on the different books for submitting and receiving responses to and from German tax authorities. This data export consists of 28 sub-reports that are defined as CSV files for individual financial books and an XML file for the table of contents.

Report Workspace

Country reports share the same workspace layout. For information on the fields and actions available in the report workspace, refer to Workspace Layout.

Navigation

To open the report workspace, select Reporting » Country Reports » Germany » GoBD (Data Export).

Selection Criteria Dialog Box

Click the Generate Report action to open the selection criteria dialog box. This table describes the parameters you can define for the report.

Dialog Box Fields

Prompt	Description	Mandatory
Company No.	Only include entries belonging to the answered company number.	Yes
Period	Only include entries in between to the answered date interval	Yes
Comment	Additional information related to the report.	No
File types to Export	Only include entries for which the VAT data is one or more of the following: Company Master Data Customer Master Data Customer Transactions Vendor Master Data Vendor Transactions Asset Master Data Asset Transactions Finance Master Data Account/Local Account Finance and VAT Entries Item Master Data Job Order Transactions Subscription Master Data Order Master Data Employee data Banking Master Data Job Master Data Job Entries Tax Master Data	Yes; user must select at least one.

Selection Criteria Dialog Box Actions

Action	Description
Next	If applicable, click this for more prompts.
Back	Click this to return to the previous prompts.
Cancel	Click this to close the dialog box.
Ok	Click this to generate the report. If applicable, click Ok to close the dialog box.

Generate the Report

To generate the report:

Go to Reporting » Country Reports » Germany » GoBD (Data Export).
Click Generate Report to open the Selection Criteria dialog box.
Fill in the mandatory fields for the report:
- In the Company No. field, enter or search for the company you want to report on.
- Specify the Period duration to include in the report.
- For File types to Export, select at least one.
  If needed, enter other selection criteria (optional) for the report.
Click Ok to start generating the report.
A notification dialog box displays to let you know that the background task for the report has been created. Click Ok.

Note: Deltek recommends that you generate reports one at a time to avoid overwriting data. Wait for Maconomy to finish generating one report then immediately retrieve the data export to ensure you are getting the correct information.

View Background Task

To view the associated background task for your report:

Select the Background Tasks tab.
Click the Refresh icon to update the Execution Status.
While running the report, the Execution Status displays as "Pending". Once complete, it changes to "Succeeded ".

Download Report

To download the data export:

Select the Statutory Report Retrieval tab.
Select the row of the report you want to view, then choose one of the following methods:
- Click the icon under the Download File to download a .zip package containing the report.
  Or
- Click the Download icon located outside the table. In the dialog box, specify the parameters for the data export (file extension, file name and number of rows), then click Ok.
The data export is downloaded to the default download folder on your device.

Submit the Report

Not applicable for this report.

Report Description

Universes

The data export is based on the underlying universe(s):

Tax Settlement Universe

Export Fields and Descriptions

The following reports are included with the German GoBD Data Export. They are grouped here by type:

Type	Report Name
Asset Master Data	Asset Asset Group
Asset Transactions	Asset Entry
Banking Master Data	Payment Agent Information Payment Mode
Company Master Data	Company Information
Customer Master Data	Company Customer
Customer Transactions	Customer Entry
Employee Data	Employee
Finance and VAT Entries	Finance Entry
Finance Master Data	Account Local Account
Item Master Data	Item Item Group Information
Job Entries	Job Entry
Job Master Data	Activity Job Header Job Posting Reference Line Task List Header
Job Order Transactions	Job Order Transaction
Order Line Data	Order Line
Order Master Data	Order Header
Subscription Master Data	Subscription Order Header
Tax Master Data	FinanceVatCode VatCode
Vendor Master Data	Company Vendor
Vendor Transactions	Vendor Entry

The following files are generated as part of the export:

Report file(s) (.csv)
Index file (.xml)
DTD file (.dtd)

Report Files (.csv)

These report files are retrieved directly from the database after you choose the appropriate selection criteria and generate the report from the Workspace Client. They contain the actual report data returned from the Workspace Client and are provided in .csv format.

The following are the formatting rules that Maconomy uses when exporting the report data:

All values are semi-colon (;) delimited
String fields (indicated as String, Alphanumeric and Popup) are formatted with double quotes (“ “) in enclosing the value; this includes system numbers such as Account No.
Double quotes are not used for numeric (amount, real, integer, etc.), date, time and Boolean values
Dates are formatted as “YYYYMMDD”.

The report files are UTF-8 encoded.

Index File (.xml)

The index file serves as a table of contents to view the generated reports, and contains a description of the .csv files.

DTD File (.dtd)

The .dtd file specifies the attributes and elements used in the XML files. It is a supporting file to be included when submitting the report (.csv) and index (.xml) files to the tax authorities.

Limitations

Background Task Not Cancelled

In some cases where a Background Task is canceled, the report still attempts to generate and complete the data export. This can cause performance issues especially when run on a system with a large amount of data.

Missing Data on VendorEntry.csv File

The framework's data extraction process has a limitation that prevents the retrieval of date type fields from the database. As a result, the GoBD report's data export file, VendorEntry.csv, is missing some data even if records exist in the database.

Admin Setup

Maconomy Setup

Email Notification Setup

Configure Maconomy to send an email notification when it successfully generates a data export or encounters an error while running the report. The email specifies the report name, other information such as the report's format (if any), as well as the date and time the export is created. The alert is sent to the email address associated with the user who initiates the report. For reports with errors, the message points to the maconomy.log file for details.

To set up the email server and sender:

Open the Extension.ini file. It is located in the <Path to Maconomy installation>\CouplingService\Configuration\Settings folder.
Configure the email server and sender:
- Locate mailserver.address and change the value to smtp.deltek.com:25.
  Note: The email server can also be set via the Web Client. Go to Setup » System Setup » System Parameters » Mail Port and Server workspace and use the Server and Mail Port parameters.
- Locate email.from.default and provide an email address for the From field of the email.
Save the file.
Restart the Coupling Service to apply the changes.

External Setup