Datev Export

If you work as an accountant, tax advisor, or business owner in Germany, you’d be familiar with DATEV and might already be using it. DATEV is a software designed for managing accounting, taxes, payroll, and finances. You can use the DATEV export feature in Zoho Books to convert all your transactions to the DATEV format, which can then be downloaded to your device.

Configuring Export Preferences for DATEV

You can export your accounting data to DATEV, by configuring preferences for individual exports or setting common preferences for all of your exports.

To configure common preferences for all your exports:

• Go to Accountant on the left sidebar and select DATEV Export.
• Click Export Data.
• Enter the required details in the popup that appears.

Field	Description
Client Number	Enter the client number that was assigned to you when your account was created in DATEV. This number helps the DATEV system differentiate between the various clients using the system.
Consultant Number	Enter the unique identifier assigned to your tax advisor or consultant. This number helps to identify the consultant associated with a specific client.
Accounting Reason	Select the reason for accounting from the dropdown (options include tax or business laws, IFRS, calculation, reserved, or not specified).
Select Recipient	Select a user to whom the export file should be sent. The selected user and the organization admin(s) will receive an email with the download link for the exported file. You can only select one user.
Account Length	Select the length of the account. This can be 4 to 8 characters long.
Data Locking	Mark the Do not modify the exported data in DATEV option if you want to restrict changes being made to the exported data.
Recurring Transactions	Mark the Include recurring invoices and recurring bills in the export file option if you want to include the recurring bills and recurring invoices in the export.
Recurring Transaction Naming Preference	Select a naming option from the dropdown for transactions created from recurring profiles.
Tax in Export File	Mark the Export taxes and items in the same row option to display the tax and total amount in the same row.

• Click Save and Next.

Now, with your export preferences configured, you can export files through DATEV.

Export Data

Once you’ve configured preferences for your DATEV export, you can export your transactions from Zoho Books in the DATEV format. Here’s how:

• Go to Accountant on the left sidebar, and select DATEV Export.
• Click Export Data.
• In the Export Your data for DATEV popup, fill in the following fields:

Field	Description
Export Start Date	Choose the start date for exporting transactions.
Export End Date	Choose the end date for exporting transactions. You can only select transactions for export within a maximum date range of 6 months.
Attachments and PDF	Check Include the attachments and PDF of transactions to export PDF copies of invoices and credit notes, along with an attachment of bills and debit notes for one month. If you select Include the attachments and PDF of transactions, you can only export data and attachments for one month, and not for six months.
Tax in Export File	Check Export taxes and items in the same row if you want to include taxes with the export.

Now, you can view and download the exported files in the Export History section on the DATEV Export page. Note that You can export your data up to 15 times a day. Zoho Books exports your accounting data to DATEV in the Direct Booking format, where each transaction’s partial amount appears as a separate row.

Schedule Data

You can set up a schedule to automatically export data through DATEV eliminating the need for manual exports each time.

To schedule data exports through DATEV:

• Go to Accountant on the left sidebar, and select DATEV Export.
• Click the Schedule Export icon in the top-right corner.
• In the popup that appears, enter the following fields:

Field	Description
Frequency	Choose how often you want to export the data, either Monthly or Quarterly. If you select Monthly, your files will be exported once a month on the date you select as the Export Start Date. Each monthly export will only include files from the previous month, regardless of the date the export occurs. If you select Quarterly, your files will be exported once every three months on the date you select as the Export Start Date. Each quarterly export will only include files from the previous quarter, regardless of the date the export occurs.
Export Start Date	Choose the date on which the monthly scheduled export should begin.
Enable this export schedule	Check this option to enable the schedule.

• Click Save.

These preferences will be applicable every time you export your accounting data to DATEV from Zoho Books.

Exporting Data to DATEV

Once you configure your export preferences, you can export your invoices, bills, chart of accounts, customers, vendors, payments, recurring invoices and recurring bills from Zoho Books in the DATEV format.

• Click the Accountant tab in the left sidebar (Go back to the Dashboard, if you are in the Settings page).
• Click DATEV Export from the dropdown and click Export Data.

• Select the date range for the data you would like to export.

• Select the Include recurring bills and recurring invoices in the export file checkbox if you wish to export your recurring bills and invoices along with invoices, bills, chart of accounts, customers, vendors and payments.
• Select the Include the attachments and PDF of transactions to export the PDF copies of invoices and credit notes along with the first attachments of bills and credit notes.

Once you finish exporting the files you can download DATEV transactions and attachments. Here’s how:

• Go to Accountant on the left sidebar, and select DATEV Export.
• Under Export History, hover over the export for which you want to download DATEV transactions and attachments, and click the Download icon.

Now, the transactions and attachments will be downloaded to your device as a ZIP file.