The Accounting Export page allows you to export DATEV data from pixi Web. You can also adjust the sorting of the DATEV data to ensure that the exported data can be imported into other accounting software.

Requirements

To use the Accounting Export feature, the DATEV interface is required.
Please contact your account manager to book this feature if you have not yet purchased the DATEV interface. Both DATEV 1.41 and 5.1, ASCII, Lexware, and customized formats are supported.

pixi Database Settings

In order to correctly handle POS accounting, the appropriate DATEV accounts need to be configures in pixi Control Center. For this, open pixi Control Center > Database Settings tab > Payments folder > DATEV export folder > Other defaults folder and fill the following fields:

• Default Account Number for POS Customer: Account number for all POS customers

• Default Account Number for POS Payments: Account number for all invoices with payment type cash

• Default Account Number for POS Invoices: Account number for all invoices with other payment types

Required API Calls

pixi Accounting Export requires the following API calls:

Activation for Users

All users whose role has the Accounting Export (Web pixi) permission enabled can access the Accounting Export page. To enable it, follow these steps:

1. In pixi Web, go to Administration > User Administration > Roles.

2. Scroll to the Reporting section and click Edit.

3. Check the box for Accounting Export (Web pixi) – Accounting Export (Web pixi).

4. Click Save.

Using Accounting Export

How to use Accounting Export in order to export accounting data, is described in the following steps.

1. The first step is to create a profile that includes the data you want to export. During this step, you’ll also need to select the correct export format. Depending on the selected format, different options and filters will be displayed.

2. Once you've created a profile, it will appear in the list of profiles. The next step is to create an export for that profile.

3. After creating the export, it will be shown in the list of exports along with its corresponding status. Exports with the status Completed can be downloaded, provided data is available.

Profiles

To create a new profile, click Create new export profile above the list of existing profiles. To edit an existing profile, click on the profile name. Fill out the displayed fields. Fields marked with an asterisk (*) are required. Click Create to create the profile, or Save to save your changes.

You can find more information about the individual fields in separate articles for each export format:

• DATEV

• ASCII & Lexware

• Personalisiert
  
  

Modify Account Numbers

After selecting the export format and export file, you can define rules to rebook standard accounts to specific accounts based on the currency. To do this, go to the Profiles page and click the gear icon on the right.

Note: This option is only available, in case multi-currency functionality is activated.

If you click the icon, a table gets shown, which contains all rules, that were created so far. You can view more information by moving the cursor over the icon.

By clicking you can add a new rule. Afterwards, all shown fields need to be filled:

• Account: Enter the account that is also configured in the pixi Control Center > tab Database Settings > Payments > DATEV Export folder.
  During the export, the value in this field will be replaced with the value from the New Account field.

• Currency: Select the currency from the dropdown for which the account should be replaced during data export from pixi.

• New Account: Enter the account that should replace the value in the Account field before the data is exported from pixi.
  

You can edit an already existing rule with and delete it with in the Action column.

Example:

The value of the database setting "EU companies, High VAT" (pixi Control Center > Database Settings tab > DATEV export folder > Default account numbers folder) is set to 17000.

You can now assign a separate account number to each currency:

In this configuration, the account number for turnovers in USD will be 17001 and for turnovers in GBP it will be 17002 instead of the value, which was set in pixi Control Center (17000).

Without a rule for USD currency, on DATEV export the value will be exported, which was set in pixi Control Center:

Währung;Vorzeichen;Betrag;MwSt-Schlüssel;Erlöskonto;Rechnungs-Nr;Kostenstelle;Belegdatum;Kunden-Nr.;;;;;Buchungstext;Wechselkurs;

USD;+;60,00;0;17000;TEST025406;;01092010;115604;;;;;26235;1;

In case a rule was defined for USD currency, the value, which was set in pixi Control Center, will be replaced with the value from New Account Number on DATEV export:

Währung;Vorzeichen;Betrag;MwSt-Schlüssel;Erlöskonto;Rechnungs-Nr;Kostenstelle;Belegdatum;Kunden-Nr.;;;;;Buchungstext;Wechselkurs;

USD;+;60,00;0;17001;TEST025406;;01092010;115604;;;;;26235;1;

Delete Profiles

To delete a profile, select the checkbox in front of the profile name and click Delete. You can select and delete multiple profiles at once.

Exports/Exporting Profiles

You can create an export for a profile, if you select the checkbox and click Export afterwards. In order to create exports for several profiles, simply select the desired profiles. One export will be created per profile.

After clicking Export a pop-up opens, in which you have to define a time span for the export. This time span can be confirmed by clicking Export.

Notes: You can export data for a period of up to one month. If you need data for a longer period, you’ll need to create multiple exports.
The time period does not automatically update to the next month, meaning you’ll need to create a new export for each month manually.

In the Exports list, a new entry is created with the label NEW in the Info column. The NEW label disappears once the export file has been downloaded.

If you have created one or more exports, they will be displayed in this overview. In addition to the profile name, the exported date range (From date, To date) and the status of each export are also shown.

Status

After an export has been created, it passes through several status until you can finally download it:

Download Exports

An export can be downloaded once its status is Completed. In this case, a Download button is displayed, allowing you to save the export file locally.

If the export does not contain any data for the selected time period, a NO DATA message is shown instead of the download button.

The export file is generated in either CSV or TXT format, depending on the selected export format. The file name follows this structure:
"Profile name"-"From date"-"To date".file extension

Notes:
- Spaces in the profile name are replaced with underscores (_).
- The values for From date and To date are displayed in the format YYYY-MM-DD.
- For the DATEV export format, the file name is prefixed with "EXTF_" to ensure the file is recognized by DATEV.
- The following characters should not be used in file names: \ / : * ? " < > |

Example:

You created a profile named "ASCII - Customers" in time span 01-01-2016 to 31-01-2016. The downloadable export file will have the following name: "ASCII_-_Customers-2016-01-01-2016-01-31.txt"

In case an export file is downloaded several times, "(1)", "(2)", "(n)" is additionally added to the name.

Delete Exports

Exports can be deleted in status Complete and Error. To do this, simply click button in the row of the concerning export. After clicking the button you will be asked, if you really want to delete the export. Confirm this with Delete.

Documents older than 1 year are automatically deleted.

Back to top