In export format Personalized you can define the export order of the fields, that are shown. For every export file different values are shown. You can change the position of the fields via drag'n'drop.
Export Files
In export format Personalized, different options and filters are shown for every export file type.
All export file types contain the following option:
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.
Note: The export order of the fields is done how it was specified in the profile.
Customer
In the Customer file type the following options are additionally shown:
Street: street and house number from the customer's address
Accounts receivable nr.: customers DATEV account number
E-mail address: customer's e-mail address
Fax: customer's fax number
Company: company from the customer's address
Short code: always empty
Country: country from the customer's address
Name: customer's first and last name
City: city from the customer's address
ZIP: zip code from the customer's address
Phone: customer's telephone number
VAT ID.: customers VAT ID
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
In the Invoices file type, the following options are additionally shown:
Invoice date: invoice creation date
Order currency: invoice currency
Amount
Bookkeeping account
Invoice text: Invoice reference
Contra account
Cost Center: cost center of the shop, in which the invoice was created
Accounts receivable nr.: customers DATEV account number
-
VAT rate
0 / "empty": no VAT
1: high VAT
2: low VAT
Invoice number: invoice or shop order number
Sign: "+" or "-"
Exchange rate: the exchange rate to the home currency
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
In the Payments file type the following options are additionally shown:
Bank account number: booking account of the inpayment account (e.g. PayPal)
Amount
Bank date: bank or book date in the format "DD.MM.YYYY"
Wire text: payment reference
Accounts receivable nr.: customers or collective accounts DATEV account number
Cost center: The cost center of the shop, in which the invoice was created
Invoice number: invoice reference (e.g. invoice, credit)
Sign: "+" or "-"
Currency: payment currency
Exchange rate: exchange rate to home currency
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.