IntegrationsDATEV

Travel expense reports with DATEV

Spesenfuchs calculates your travel expenses and transfers bookings and receipt images to DATEV: online, as a DATEV file or to payroll.

  • DATEV interface partner
  • Data service, file or payroll
  • No extra costs

Does your bookkeeping run on DATEV, in your own company or at your tax firm? Then your travel expense reports have to end up there: as a booking record on the right account, with cost centre and receipt image. This is exactly the route the travel expense software Spesenfuchs takes care of. You record trips and receipts, Spesenfuchs calculates the allowances, and once approved the data goes to DATEV. Spesenfuchs handles not only travel expenses but also expenses without a trip.

As a DATEV interface partner, Spesenfuchs offers several ways to do this. They are available in the PRO version and the TEAM version alike.

How your travel expense report gets into DATEV

  1. Capture: You record trips, journeys and receipts in the app or in the browser. The AI reads receipts automatically, and e-invoices in ZUGFeRD format are imported.
  2. Calculate: Spesenfuchs calculates meal allowances, overnight allowances and mileage using the current statutory rates, and abroad with the per diems by country.
  3. Approve: Only approved expenses are transferred. In the TEAM version, approvers review trips and receipts in the approval workflow.
  4. Transfer: Spesenfuchs books to your accounts according to SKR03, SKR04 or SKR42, passes the cost centre as KOST1 and includes the receipt images. Everything is entered only once, and nobody has to collect, file and carry receipts to the tax firm in a folder any more.


What arrives in DATEV

  • Booking records on your accounts according to SKR03, SKR04, SKR42 or your own chart of accounts, with posting text. The accounts for the receipt types are preset, and you can adjust them in the chart of accounts.
  • Cost centres are passed as KOST1. More on this under cost centres and cost units.
  • Receipt images go along with every booking, as a file or via the DATEV data services. With the format “receipt data with receipt images”, the total and tax of each receipt are transferred as well.
  • E-invoices in ZUGFeRD format go to DATEV as the original PDF with embedded XML, see e-invoice.
  • Wage types for DATEV LODAS and Lohn und Gehalt: payout, tax-free meal allowance, meals taxed at the 25% flat rate, tax-free overnight allowances and mileage. You can adjust the LODAS export, and the export for Lohn und Gehalt can be configured freely and includes the capital letter M for the payroll tax certificate.

You create the DATEV files in Spesenfuchs under Export › DATEV export files. Which file suits which purpose is explained under DATEV export. Other accounting programs with a DATEV import can usually read the file “booking data and receipt images” as well. The guide in the support centre shows how. There are also other export formats, for example for further processing in Excel, and the reports as a PDF export.


Export in Spesenfuchs: select period and export format

Company or tax firm: who does the booking?

Your tax firm does the booking: With the DATEV Rechnungsdatenservice 1.0, receipt images and receipt data go to DATEV Unternehmen online. From this, your tax firm receives booking suggestions in DATEV Rechnungswesen.

You book yourself, or your tax firm takes over finished bookings: The DATEV Buchungsdatenservice transfers booking records and receipt images automatically every night. If you prefer to decide yourself when to transfer, use the DATEV export files.

How to set up the two data services is described on the page DATEV Data Service.

What you need for the setup

  • Consultant and client number from your tax firm
  • Chart of accounts and length of the general ledger accounts
  • Start of the financial year
  • For the data services: activation by your tax firm and a DATEV login with a DATEV mIDentity stick or SmartLogin

You enter these details once in Spesenfuchs under Settings › Export settings. Agree on the chart of accounts, account length and financial year with your tax firm beforehand, and the bookings will fit right away.

Frequently asked questions about travel expense reports with DATEV

How do I integrate travel expense reports into DATEV?

The easiest way is travel expense software with a DATEV interface. In Spesenfuchs you set up the DATEV data service or the export of DATEV files once. After that, approved travel expenses go to DATEV with account, cost centre and receipt image, without retyping.

Does the DATEV interface cost extra?

No. The DATEV connection is included in the PRO version and the TEAM version, with no extra costs for interfaces, setup or support. You will find the prices on the page Prices.

Is there a DATEV template for travel expense reports?

You fill in a template in Excel or as a PDF by hand, and it still has to be booked afterwards. Which formats exist and how a DATEV file is structured is shown in the guide DATEV export of travel expenses. With Spesenfuchs, the booking is created directly from the expense report.

Where do I find the consultant and client number?

You get both numbers from your tax firm. If you work with DATEV Unternehmen online, you will also find them there under Anwendungen › Belege.

Are e-invoices transferred to DATEV?

Yes. Spesenfuchs processes e-invoices in ZUGFeRD format and passes the original PDF with the embedded XML to DATEV.