DATEV Export

Your team tracks time and writes invoices in Timesheet. Your tax advisor works in DATEV. The DATEV export creates the files your tax advisor imports: your outgoing invoices as a booking batch (Buchungsstapel), and worked time, overtime and absences as payroll movements. You download the files and hand them over. Nothing is sent to DATEV automatically.

What you export

Invoices (Buchungsstapel)

• One booking line per invoice with gross amount, debtor account, revenue account, invoice date and invoice number
• Credit notes booked on the credit side
• Reverse charge invoices on their own account, with the customer's VAT ID

Payroll (LODAS or Lohn und Gehalt)

• Tracked hours per employee
• Overtime or undertime of the period
• Approved absences per wage type
• Travel allowances taken from expenses

Before you start

• A Timesheet organization on the Business plan, or on a Business trial. See plans and pricing.
• Admin rights in that organization. The export cannot be installed on a personal profile.
• Your Beraternummer and Mandantennummer. For payroll, also the personnel numbers and wage types (Lohnarten) your tax advisor uses.

Set it up

In the Timesheet web app, open Integrations, select Browse Marketplace, and install DATEV Export. There is no connection step, because the files are downloaded and not sent.

1. Settings: enter the Beraternummer, the Mandantennummer, the chart of accounts (SKR03 or SKR04) and the payroll program.
2. Mappings: enter the wage type for each absence type, the personnel number for each employee and the debtor account for each customer.
3. DATEV Export: choose a period and create the booking batch or the payroll files.

You do not have to map everything first. Run an export, read the warnings, add the missing numbers and run it again.

Good to know

• Only invoices in EUR with one tax rate are exported. Others are skipped and listed as a warning.
• A payroll period must lie within one calendar month.
• On the first day of each month, the files for the previous month are created automatically.
• Ask your tax advisor to import one month into a test client before the first live import.

The full steps are in the documentation.