pixi

Export Formats: ASCII & Lexware (Web)


ASCII

Export Files

Did you decide for export format ASCII, only one option will be shown - regardless of which export file type you choose:

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


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 profile's amount range.


File Structure

The structure of DATEV files in ASCII format is already described in this article:

DATEV Export - Aufbau der DATEV-Dateien


Lexware

In export format Lexware, only the Invoices file type can be exported. This export file type offers the following options and filters.


Options

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


Filters

  • 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.

  • 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.


Invoices File Structure

Basically, the Invoices file structure in export format Lexware equals the structure in export format ASCII. Only the format of the included date, which is "DD.MM.YYYY", is different. A sample file can be downloaded here: Invoices File


Back to top