pixi
Ask AI
What's an 'Ideas Portal'?
DE

Export Format: DATEV (Web)


Export Files

In export format DATEV, the following options are shown - regardless of which export file type you choose:

  • Fixation: Defines, if the bookings should be changeable or not. By default bookings are changeable because you should decide on your own, what data should be changeable. The following values can be used (only for export format DATEV 5.1!):

    • (0) No fixation

    • (1) Fixation

  • Consultant

  • Client

  • FY start (start of the financial year)

  • Imperial accounts length

  • Description

  • Dictation token

  • Booking type

  • Bill description

  • Country format: Choose between "ISO2-Code", "ISO3-Code" and "KFZ-Code".

Hint: Please ask your bookkeeper in case you need help in filling the fields.


There are more possibilities to choose from when it comes to filters. But the following filters are the same for every export file type:

  • Shop/POS/CC: With this filter you can choose, for which shop, POS location or cost center (CC) the profile should be created.

  • Country: With this filter you can choose, for which shop country the profile should be created.


Customer

The Customer file type offers the following filters:

  • Accounts receivable nr.: With this filter you can choose, for which DATEV account number the profile should be created.

  • E-mail address: With this filter you can choose, for which customer e-mail address the profile should be created.


Invoices

The Invoices file type offers the following filters:

  • Invoice nr.: With this filter you can choose, for which invoice number the profile should be created.

  • Order nr.: With this filter you can choose, for which shop order number the profile should be created.

  • Account nr.: With this filter you can choose, for which bookkeeping account the profile should be created.


Payments

The Payments file type offers the following filters:

  • Bookkeeping account: With this filter you can choose, for which bookkeeping account the profile should be created.

  • Amount range (€) ... to ...: With this filter you can define the profiles amount range.


File Structure

The export files in both DATEV export formats contain several column headers. You can download a sample for each export file type here:

DATEV 5.1

The structure of the files follows the DATEV specification version 5.1.


Back to top