DATEV export configuration

• Version: Version number of the header.
• Consultant no: Consultant number in DATEV.
• Default company no.
• Default supplier no.
• Lock: DATEV only allows this field to be empty = not defined, 0 = not locked, or 1 = locked.
• Ledger account length: DATEV only allows values between 4 and 8.
• FY begin: This corresponds to the Fiscal Year beginning day and month.
• Tick the cases to choose which exports you want to allow: Customer invoices, Customer payments and/or Supplier invoices.
  If unticked, you will not be able to configure the export in the Export settings below, and the export function in the corresponding list will be disabled.

Note: Personal account numbers for Customers can be set in the Contact edit, under the Settings tab. Personal account numbers for Suppliers can be set in the Supplier Edit dialog, under the Settings tab.

In these three sections, you can configure each export type separately. 

You can choose to use the same parameters for all companies by ticking the box Use configuration for all companies, or choose to configure each company separately, using the drop down list. 

Note! Remember to click on Save after setting up your company settings.

Customer Invoice

• Specific company no: If different from the Company number specified in the general settings.
• Cost center: KOST1/KOST2, is used to assign the transaction to a cost centre for subsequent cost accounting.
• Document field 1: Invoice number.
• VAT accounts

Customer Payment

• Specific company no: if different from the Company number specified in the general settings.
• Cost center: KOST1/KOST2, is used to assign the transaction to a cost centre for subsequent cost accounting.
• Document field 1: Payment number.
• Bank account
• Down payment account

Supplier Invoice

• Specific company no: if different from the Company number specified in the general settings.
• Cost center: KOST1/KOST2, is used to assign the transaction to a cost centre for subsequent cost accounting.
• Document field 1: Invoice number.
• Document filed 2: Payment Date.
• Goods receipt account

Once your export settings are ready, you can export the data. To do so, go to the list you wish to export and click on Export > Export accounting information.

Exports generate two files: the transaction data file and the Master Data file, with one file of each generated for each fiscal year. The Master data file contains information about the customer/supplier. The Transaction data file contains the accounting data (Customer invoices, the Supplier invoices or the Payments data, according to the export selected). 

The first line of the Master Data is the header, it contains less information than the header of the transaction data. Its structure is as follow:

• DATEV format label
• Version number
• Data category
• Format name
• Format version
• Created on
• Imported
• Origin
• Exported by
• Imported by
• Consultant
• Client 
• FY begin
• Length of Ledger Account

The header of the transaction data is as follow:

• DATEV format label
• Version number
• Data category
• Format name
• Format version
• Created on
• Imported
• Origin
• Exported by
• Imported by
• Consultant
• Client 
• FY begin
• Length of Ledger Account
• Date from
• Date to
• Label
• Initials
• Record type
• Accounting reason
• Locking
• Currency code