To allow accounting to create personal accounts, ZEP can hand over selected customers as debtors and selected employees as creditors in a master data file. Both exports work independently of the booking export.
Exporting debtors
Under Export for Accounting > Debtors you export the customers stored in ZEP as a debtor master data set. ZEP delivers the following fields per customer:
Debtor number: Depending on the basic settings, either the ZEP customer number (Cust.No) or the dedicated Debtor number field on the customer.
Name and address: Company name, salutation, street, postal code, city, country, address suffix.
Invoice address: A separate address used for invoicing if needed.
Tax data: VAT ID (if stored), tax country and payment terms in days.
Contact data: Default email address, phone, fax, website, contact person.
Bank account: IBAN and BIC if maintained on the customer.
Use the filters to narrow down the exported customers – for example by department, customer category or customer industry.
Select the customers you want in the list and click Export Debtors. ZEP creates a CSV file in the format of the booking export (DATEV, Lexware or General) for download.
Exporting creditors
Under Export for Accounting > Creditors you export the employees stored in ZEP as a creditor master data set. ZEP delivers the following fields per employee:
Creditor number: Depending on the basic settings, either the ZEP personnel number (Emp.No) or the dedicated Creditor number field on the employee.
Personal data: Salutation, first name, last name, address.
Contact data: Email address, phone, fax.
Bank account: IBAN and BIC, if maintained on the employee – the prerequisite for reimbursement from the cost export.
Use the filters to narrow down the employees by department and optionally by employment period.
Select the employees you want in the list and click Export Creditors. ZEP creates a CSV file in the format of the booking export for download.
Note: If Creditor number must be specified for each employee as a separate field is selected in the basic settings, ZEP checks before the export whether all selected employees have a creditor number. If it is missing on individual employees, the export aborts and lists the affected employees – maintain the numbers on those employees afterwards.
Structure of the export file
Unlike the booking export, the debtor/creditor export does not contain booking records but master data. ZEP creates a separate CSV file that accounting imports into the personal-accounts module. This way you maintain customers and employees only in ZEP and hand over changes to accounting periodically.
The fields contained in the file per record depend on the chosen export format: DATEV delivers the most comprehensive master data set including bank details and invoice address, Lexware a more compact set focused on the fields required for the Buchhalter import, General a wide CSV record for manual import.
The debtor and creditor export always contains the records you selected in the list. ZEP does not maintain a "previously exported" status. When master data changes, export the affected records again and your accounting team picks up the changes.