{"id":7751,"date":"2020-09-08T12:26:43","date_gmt":"2020-09-08T10:26:43","guid":{"rendered":"https:\/\/www.spesenfuchs.de\/datev-export-of-travel-expenses\/"},"modified":"2026-11-11T22:55:25","modified_gmt":"2026-11-11T21:55:25","slug":"datev-export-of-travel-expenses","status":"publish","type":"post","link":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/","title":{"rendered":"DATEV export of travel expenses"},"content":{"rendered":"<br \/>\n<section  class='av_textblock_section av-rg-intro-84b6cfc67a7c50ab84612cc97782d53a '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>After the travel expense report, the costs have to go into financial accounting and the reimbursement to the employees. If your tax advisor works with DATEV, booking data and receipt images should arrive there without retyping. This article shows the four ways to DATEV using an example trip and explains the structure of the files for those who are interested.<\/p>\n<h2 id=\"ueberblick\">The four ways to DATEV at a glance<\/h2>\n<table>\n<thead>\n<tr>\n<th>Way<\/th>\n<th>What is transferred<\/th>\n<th>Receipt images<\/th>\n<th>Where it arrives<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>CSV file (DATEV format)<\/td>\n<td>Booking records<\/td>\n<td>no<\/td>\n<td>Imported by the tax firm into DATEV Rechnungswesen<\/td>\n<\/tr>\n<tr>\n<td>XML file<\/td>\n<td>Receipt data with receipt images<\/td>\n<td>yes<\/td>\n<td>DATEV Unternehmen online via DATEV Belegtransfer<\/td>\n<\/tr>\n<tr>\n<td>CSV and XML (ZIP file)<\/td>\n<td>Booking records, linked receipt images<\/td>\n<td>yes<\/td>\n<td>DATEV Rechnungswesen and Unternehmen online<\/td>\n<\/tr>\n<tr>\n<td>DATEV data services<\/td>\n<td>Booking records or receipt data with receipt images<\/td>\n<td>yes<\/td>\n<td>automatically online to DATEV<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Which way suits you is best decided together with your tax firm: if it does the bookkeeping itself and only needs the data, the CSV file is enough. If the receipts should also arrive digitally, XML, CSV with XML or a data service are suitable. The data service also saves passing files on. For payroll there are separate exports for DATEV LODAS and DATEV Lohn und Gehalt.<\/p>\n<h2>Is there a DATEV template for travel expense reports?<\/h2>\n<p>Many people look for an Excel or PDF template or a form for travel expense reports that fits DATEV. Such a template helps with filling in. However, accounting then has to transfer the figures into DATEV by hand, because DATEV only reads booking data in DATEV format or via the data services. Travel expense software creates both directly from the report, with the current allowances and the accounts from your chart of accounts. Figure 2 below shows what a finished travel expense report looks like as a PDF. How to create a report step by step is explained in the guide <a href=\"https:\/\/www.spesenfuchs.de\/en\/create-travel-expense-report\/\">Create travel expense report<\/a>. If you have used DATEV Reisekosten classic so far, you will find information in the article on the <a href=\"https:\/\/www.spesenfuchs.de\/en\/discontinuation-datev-reisekosten-classic\/\">discontinuation of DATEV Reisekosten classic<\/a>.<\/p>\n<\/div><\/section><\/p>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kett4d8q-8670add4f088f0d5bc7c6193122a9e4a\">\n#top .av_textblock_section.av-kett4d8q-8670add4f088f0d5bc7c6193122a9e4a .avia_textblock{\nfont-size:20px;\n}\n<\/style>\n<section  class='av_textblock_section av-kett4d8q-8670add4f088f0d5bc7c6193122a9e4a '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h2>An overview of the different file formats based on a travel expense report<\/h2>\n<p>In Germany, certain tax <a href=\"https:\/\/de.wikipedia.org\/wiki\/Reisekosten\" target=\"_blank\" rel=\"noopener\">regulations<\/a> apply to the settlement of travel expenses. There are some software solutions for travel expense reporting on the market that help to apply these regulations correctly. After that, the travel costs and expenses must be transferred to the financial accounting system and paid to the employees. However, if the data obtained has to be manually transferred to financial accounting after the payroll has been prepared, the fun stops.<\/p>\n<p>To avoid these so-called &#8220;media breaks&#8221;, there are interfaces from the travel expense software solutions to various accounting systems. <a href=\"https:\/\/www.datev.de\" target=\"_blank\" rel=\"noopener\">DATEV<\/a> can still be described as the &#8220;number one&#8221; among tax advisors. Therefore, this article explains the different possibilities how to transfer the data from a software for travel expenses, using the example of <a href=\"https:\/\/www.spesenfuchs.de\/en\/\" target=\"_blank\" rel=\"noopener\">Spesenfuchs<\/a>, to DATEV.<\/p>\n<p>A concrete example is used to run through all three possibilities. The structure of the files is explained in detail.<\/p>\n<h2>Products<\/h2>\n<p>First, we will very briefly introduce the products that we will be talking about below:<\/p>\n<p><strong>Kanzlei-Rechnungswesen<\/strong> is a software from DATEV for tax advisors, with which they can handle all activities from financial accounting to annual financial statements.<\/p>\n<p><strong>DATEV document transfer<\/strong> is a free tool from DATEV for sending (by the tax advisor) document data from the client to the DATEV Data centre.<\/p>\n<p><strong>DATEV Unternehmen Online, called DUO<\/strong>, replaces the &#8220;commuting folder&#8221;. Companies can send their receipts to the tax advisor via this online application. Here it is possible to send also accounting data such as amounts, descriptions and accounts.<\/p>\n<p><strong>Spesenfuchs <\/strong>is an online software solution for travel expense reporting.<\/p>\n<h2>Overview<\/h2>\n<p>By way of introduction it can be said that there are 3 (or 4) ways to bring the data to DATEV:<\/p>\n<ol>\n<li>CSV file that is imported into Kanzlei-Rechnungswesen<\/li>\n<li>XML file that is imported into DATEV Unternehmen online<\/li>\n<li>CSV file in combination with an XML file (mixture of 1. and 2.)<\/li>\n<li>Transfer of data from 2. through an online API (automated).<\/li>\n<\/ol>\n<h2>Example situation<\/h2>\n<p>The following data is taken as a basis for the examples: the self-employed pool builder Sepp Elmann goes on a one-day business trip from Karlsruhe to Freiburg. Departure 6:00, return the same day at 23:00. He submits a receipt for entertainment.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev4l4gb-b76feece83bb50442474600e84d0fccc\">\n.avia-image-container.av-kev4l4gb-b76feece83bb50442474600e84d0fccc img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev4l4gb-b76feece83bb50442474600e84d0fccc .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev4l4gb-b76feece83bb50442474600e84d0fccc av-styling- avia-align-center  avia-builder-el-3  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-7511 avia-img-lazy-loading-not-7511 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png\" alt='' title='Abb. 1: Eingabemaske Reisekostenabrechnung mit Spesenfuchs'  height=\"1031\" width=\"1135\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png 1135w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske-300x273.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske-1030x936.png 1030w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske-768x698.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske-705x640.png 705w\" sizes=\"(max-width: 1135px) 100vw, 1135px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev4ylyh-5b64414b84ad89eb6a58dd21d607eaaa '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>His statement of account is as follows:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev50qee-28aa6897001168db42b9841c6c25aab4\">\n.avia-image-container.av-kev50qee-28aa6897001168db42b9841c6c25aab4 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev50qee-28aa6897001168db42b9841c6c25aab4 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev50qee-28aa6897001168db42b9841c6c25aab4 av-styling- avia-align-center  avia-builder-el-5  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7512 avia-img-lazy-loading-not-7512 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/reisekostenabrechnung.png\" alt='' title='Abb.2: Reisekostenabrechnung Spesenfuchs'  height=\"1252\" width=\"1142\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/reisekostenabrechnung.png 1142w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/reisekostenabrechnung-274x300.png 274w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/reisekostenabrechnung-940x1030.png 940w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/reisekostenabrechnung-768x842.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/reisekostenabrechnung-643x705.png 643w\" sizes=\"(max-width: 1142px) 100vw, 1142px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev51ap0-b3629054f66a65fe4c055a979db6939f '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>While the statement is clear for the business traveler, it does not include the accounts for the bookings. For this there is a booking list for this trip, which contains all bookings.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev524au-1aa39d6eb0983253d33d8048ba379298\">\n.avia-image-container.av-kev524au-1aa39d6eb0983253d33d8048ba379298 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev524au-1aa39d6eb0983253d33d8048ba379298 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev524au-1aa39d6eb0983253d33d8048ba379298 av-styling- avia-align-center  avia-builder-el-7  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7513 avia-img-lazy-loading-not-7513 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/buchungsliste.png\" alt='' title='Abb 3: Buchungsliste der Beispielreise'  height=\"496\" width=\"981\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/buchungsliste.png 981w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/buchungsliste-300x152.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/buchungsliste-768x388.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/buchungsliste-705x356.png 705w\" sizes=\"(max-width: 981px) 100vw, 981px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev52it6-c08a43cef00eb5e8bc435f6c09629d7f '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>This posting list lists all the necessary posting records to correctly post the travel expenses, including VAT specials, etc. While this list makes it easy to transfer the entries to accounting, it is of course tedious. Wouldn&#8217;t it be nice to be able to transfer the whole thing directly to the accounting software? Here we are at the actual topic of this article, the interfaces.<\/p>\n<\/div><\/section>\n<div  class='hr av-3ohhqf-a96e922ef36d1d24573efafeb9781777 hr-default  avia-builder-el-9  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-kev53w81-37be7914894672a8faa1867f6f718c06 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h2>The CSV interface<\/h2>\n<p>The CSV interface is the oldest of the DATEV formats. With the CSV interface no document images can be transferred to Kanzlei Rechnungswesen. This format is also supported by many other programs and can therefore be considered almost a de facto standard. It is only one file that starts with EXTF_ and ends with .csv.<\/p>\n<p><strong>First line:<\/strong> The first line always has the same structure and contains information for the entire file, such as the DATEV consultant number and the DATEV client number.<\/p>\n<p><strong>Second line:<\/strong> The second line of the file also always has the same structure and provides the headings for the following data lines.<\/p>\n<p><strong>N data lines:<\/strong> One line per posting record. More than 120 columns, not all of which need to be filled in our case.<\/p>\n<p>The following image shows the CSV file. In the second line are the headings for the posting lines.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev54vc9-96286ec4825847e008ff2f229685d6e8\">\n.avia-image-container.av-kev54vc9-96286ec4825847e008ff2f229685d6e8 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev54vc9-96286ec4825847e008ff2f229685d6e8 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev54vc9-96286ec4825847e008ff2f229685d6e8 av-styling- avia-align-center  avia-builder-el-11  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7514 avia-img-lazy-loading-not-7514 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv.png\" alt='' title='Abb. 4: CSV Datei f\u00fcr die Beispielreise'  height=\"122\" width=\"1568\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv.png 1568w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv-300x23.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv-1030x80.png 1030w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv-768x60.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv-1536x120.png 1536w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv-1500x117.png 1500w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/screen_csv-705x55.png 705w\" sizes=\"(max-width: 1568px) 100vw, 1568px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev584d8-a38fa6c37b872469b34d9a70e64b9e0a '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The way of the data is simple: the user sends the file to the tax advisor and the latter reads it directly into Kanzlei Rechnungswesen. As described above, the disadvantage is that no document images can be transferred this way.<\/p>\n<h2>The XML interface<\/h2>\n<p>The <strong>DATEV XML interface<\/strong> is an XML-based file interface for importing data to <strong>DATEV Unternehmen online<\/strong>. With this file format, the entries can be transferred with both records and the corresponding document images. These files are imported via the desktop application <strong>DATEV Belegtransfer<\/strong>.<\/p>\n<p>A set of files for the bookings from our example contains the following files for the XML interface:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev58ymx-6e05c36ed385c1579a287425c43e37a5\">\n.avia-image-container.av-kev58ymx-6e05c36ed385c1579a287425c43e37a5 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev58ymx-6e05c36ed385c1579a287425c43e37a5 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev58ymx-6e05c36ed385c1579a287425c43e37a5 av-styling- avia-align-center  avia-builder-el-13  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7515 avia-img-lazy-loading-not-7515 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml.png\" alt='' title='Abb. 5: Dateien f\u00fcr den XML Export der Beispielreise'  height=\"132\" width=\"398\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml.png 398w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml-300x99.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev59iw9-3663547774df29b54fc100c47f1d9dc1 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>These files are discussed in detail below.<\/p>\n<p>A<strong>document.xml<\/strong>file<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5c1jc-8259e0070d83b6d4d17d8cb4d4b8f422\">\n.avia-image-container.av-kev5c1jc-8259e0070d83b6d4d17d8cb4d4b8f422 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5c1jc-8259e0070d83b6d4d17d8cb4d4b8f422 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5c1jc-8259e0070d83b6d4d17d8cb4d4b8f422 av-styling- avia-align-center  avia-builder-el-15  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7516 avia-img-lazy-loading-not-7516 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml.png\" alt='' title='Abb. 6: document.xml Datei \u2014 das \u201cInhaltsverzeichnis\u201d'  height=\"519\" width=\"816\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml.png 816w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml-300x191.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml-768x488.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml-705x448.png 705w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5ckxh-0fcb8fd558adc91a8fe82cb53b547c04 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Further, the set of files contains N files with the extension <strong>.xml<\/strong>. The number of files depends on how the manufacturer of the software that generates them divides the data. In the case of Spesenfuchs, one file is created per receipt and per trip, and another file is created for the trip and its per diems and, if applicable, the deductions for meals. So, in our example, there are 3 files, one for the trip with its additional meal expenses, one for the trip, and one for the receipt. These files are structured as follows:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5dp5s-cbd17d48cc6a307cc6bed3f292b8ec0d\">\n.avia-image-container.av-kev5dp5s-cbd17d48cc6a307cc6bed3f292b8ec0d img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5dp5s-cbd17d48cc6a307cc6bed3f292b8ec0d .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5dp5s-cbd17d48cc6a307cc6bed3f292b8ec0d av-styling- avia-align-center  avia-builder-el-17  el_after_av_textblock  el_before_av_image '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7517 avia-img-lazy-loading-not-7517 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml1.png\" alt='' title='Abb. 7: XML Datei f\u00fcr die Reise mit ihren Verpflegungsmehraufwendungen'  height=\"354\" width=\"802\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml1.png 802w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml1-300x132.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml1-768x339.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml1-705x311.png 705w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5f05w-968d0266a54faee46db2b0bcbb28093d\">\n.avia-image-container.av-kev5f05w-968d0266a54faee46db2b0bcbb28093d img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5f05w-968d0266a54faee46db2b0bcbb28093d .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5f05w-968d0266a54faee46db2b0bcbb28093d av-styling- avia-align-center  avia-builder-el-18  el_after_av_image  el_before_av_image '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7518 avia-img-lazy-loading-not-7518 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml2.png\" alt='' title='Abb. 8: XML Datei f\u00fcr den Bewirtungsbeleg'  height=\"537\" width=\"809\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml2.png 809w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml2-300x199.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml2-768x510.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml2-705x468.png 705w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5fqgc-bf7a65d7a965bf7eed09cbbb836d8ef5\">\n.avia-image-container.av-kev5fqgc-bf7a65d7a965bf7eed09cbbb836d8ef5 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5fqgc-bf7a65d7a965bf7eed09cbbb836d8ef5 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5fqgc-bf7a65d7a965bf7eed09cbbb836d8ef5 av-styling- avia-align-center  avia-builder-el-19  el_after_av_image  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7519 avia-img-lazy-loading-not-7519 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml3.png\" alt='' title='Abb. 9: XML Datei f\u00fcr die Fahrt'  height=\"340\" width=\"821\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml3.png 821w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml3-300x124.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml3-768x318.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xml3-705x292.png 705w\" sizes=\"(max-width: 821px) 100vw, 821px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5g86t-660fb864d79936fdd9adf8422629e1d1 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Other files are all receipt images and other files, in our example the travel expense report of the trip (already shown above, Figure 2) and the receipt for the hospitality.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5ha3n-3fca9eb91cb6ccbdd0114b9dfda62e56\">\n.avia-image-container.av-kev5ha3n-3fca9eb91cb6ccbdd0114b9dfda62e56 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5ha3n-3fca9eb91cb6ccbdd0114b9dfda62e56 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5ha3n-3fca9eb91cb6ccbdd0114b9dfda62e56 av-styling- avia-align-center  avia-builder-el-21  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7520 avia-img-lazy-loading-not-7520 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/beleg.png\" alt='' title='Abb. 10: Datei 202009071523\u2013316261422\u20131.png'  height=\"984\" width=\"521\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/beleg.png 521w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/beleg-159x300.png 159w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/beleg-373x705.png 373w\" sizes=\"(max-width: 521px) 100vw, 521px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5hqfq-9875bfae44ec002537844cf465863b96 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>If you now take a closer look at the files, you will notice that the document.xml is something like a table of contents for the entire package. The document.xml establishes the connection between the individual .xml files and the document images. We will look at this in more detail using the example of the receipt for hospitality.<\/p>\n<p>In the document.xml there is this section:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\"><document>\n <extension xsi:type=\"\u201dEingangsrechnungen\u201d\" datafile=\"\u201dSPF_1_559_002.xml\u201d\">\n <property value=\"\u201d2020\u201308\"\" key=\"\u201d1\"\/\">\n <property value=\"\u201dEingangsrechnungen\u201d\" key=\"\u201d3\"\/\">\n <\/property><\/property><\/extension>\n <extension name=\"\u201d202009071523\u2013316261422\u20131.png\u201d\" xsi:type=\"\u201dFile\u201d\/\">\n <\/extension><\/document><\/pre>\n<p>By this the picture for the hospitality with the file name <strong>202009071523-316261422-1.png<\/strong> can be assigned to the booking data in the file <strong>SPF_1_559_002.xml <\/strong>during the import.<\/p>\n<p>The file <strong>SPF_1_559_002.xml <\/strong>contains the posting data for this document (upper area omitted for clarity):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\">...\n <consolidate consolidatedamount=\"\u201d32.30\"\" consolidateddate=\"\u201d2020\u201308\u201331\"\" consolidatedcurrencycode=\"\u201dEUR\u201d\">\n <accountspayableledger>\n <date>2020\u201308\u201331<\/date>\n <amount>19.70<\/amount>\n <accountno>6640<\/accountno>\n <bucode>8<\/bucode>\n <currencycode>EUR<\/currencycode>\n <invoiceid\/>\n <bookingtext>Bewirtungskosten, Mahlzeit, Einladung Kunde nach erfolgreich<\/bookingtext>\n <accountname>Bewirtungskosten<\/accountname>\n <bpaccountno>70001<\/bpaccountno>\n <deliverydate>2020\u201308\u201331<\/deliverydate>\n <\/accountspayableledger>\n <accountspayableledger>\n <date>2020\u201308\u201331<\/date>\n <amount>12.60<\/amount>\n <accountno>6640<\/accountno>\n <bucode>9<\/bucode>\n <currencycode>EUR<\/currencycode>\n <invoiceid\/>\n <bookingtext>Bewirtungskosten, Getr\u00e4nke, Einladung Kunde nach erfolgreich<\/bookingtext>\n <accountname>Bewirtungskosten<\/accountname>\n <bpaccountno>70001<\/bpaccountno>\n <deliverydate>2020\u201308\u201331<\/deliverydate>\n <\/accountspayableledger>\n <\/consolidate>\n<\/LedgerImport><\/pre>\n<p>The same applies to the other sections or files.<\/p>\n<p>If negative amounts were necessary, such as a meal reduction, they would receive a minus.<\/p>\n<p>If now a document without image would be entered, one would have to transfer a dummy image, otherwise a transfer of the booking data with this interface format would not be possible.<\/p>\n<p>The data is sent from the user to the tax advisor, from there via the DATEV document transfer app to DATEV Unternehmen online and from there to Kanzlei Rechnungswesen.<\/p>\n<h2>The XML+ CSV interface<\/h2>\n<p>This interface is a mixture of the two XML and CSV described above. However, both XML and CSV contain other data in certain places.<\/p>\n<p>A set of files for the postings from our example contains the following files for the XML + CSV interface:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5npu2-195166347b62dd45c9bad5ce1bfae2fb\">\n.avia-image-container.av-kev5npu2-195166347b62dd45c9bad5ce1bfae2fb img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5npu2-195166347b62dd45c9bad5ce1bfae2fb .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5npu2-195166347b62dd45c9bad5ce1bfae2fb av-styling- avia-align-center  avia-builder-el-23  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7521 avia-img-lazy-loading-not-7521 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml_csv.png\" alt='' title='Abb. 11: Dateien in der XML + CSV Schnittstelle (a)'  height=\"40\" width=\"514\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml_csv.png 514w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml_csv-300x23.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/dateien_xml_csv-495x40.png 495w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5o1dt-f870cae6e9dca5e08237e46c8293fa68 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The zip file shown in Figure 11 is sent to the tax consultant without unpacking it. Their content is similar to the XML interface but not the same:<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5ouwc-abf8d7c80e650c32cfb2fbba12b9a8b1\">\n.avia-image-container.av-kev5ouwc-abf8d7c80e650c32cfb2fbba12b9a8b1 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5ouwc-abf8d7c80e650c32cfb2fbba12b9a8b1 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5ouwc-abf8d7c80e650c32cfb2fbba12b9a8b1 av-styling- avia-align-center  avia-builder-el-25  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7522 avia-img-lazy-loading-not-7522 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xmlcsvinhalt.png\" alt='' title='Abb. 12: Dateien in der XML + CSV Schnittstelle (b)'  height=\"59\" width=\"434\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xmlcsvinhalt.png 434w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/xmlcsvinhalt-300x41.png 300w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5pc2e-192ed5745523d02777c70bbe3c3f1417 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Since the booking data is taken from the CSV file, there is no need for the dummy image. Only the document images that are actually required are sent via the XML interface. This also eliminates all data about the documents in the XML file. The XML file is therefore much smaller. There are no XML files other than the document.xml file.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5q6r3-016a36ce864eed8cbbb280ebdca8447f\">\n.avia-image-container.av-kev5q6r3-016a36ce864eed8cbbb280ebdca8447f img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5q6r3-016a36ce864eed8cbbb280ebdca8447f .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5q6r3-016a36ce864eed8cbbb280ebdca8447f av-styling- avia-align-center  avia-builder-el-27  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7523 avia-img-lazy-loading-not-7523 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml_csv.png\" alt='' title='Abb. 13: document.xml f\u00fcr die XML + CSV Schnittstelle'  height=\"374\" width=\"816\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml_csv.png 816w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml_csv-300x138.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml_csv-768x352.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/document_xml_csv-705x323.png 705w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5qitn-6ae3e68b7d3e75f56ffc51116baa4e35 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Also with this interface format the document.xml file represents a kind of table of contents.<\/p>\n<p>But first we have to look at the CSV file: In the CSV file there is also a difference to the pure CSV interface: in the column &#8220;document link&#8221; the UUID or also GUID, i.e. a unique identifier is listed, which is also used in the document.xml. This allows to establish the connection between the images and the bookings in the CSV file.<\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kev5r8p7-92cc398904aa44eb57eb587ecba0a1dd\">\n.avia-image-container.av-kev5r8p7-92cc398904aa44eb57eb587ecba0a1dd img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-kev5r8p7-92cc398904aa44eb57eb587ecba0a1dd .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-kev5r8p7-92cc398904aa44eb57eb587ecba0a1dd av-styling- avia-align-center  avia-builder-el-29  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-7524 avia-img-lazy-loading-not-7524 avia_image ' src=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/csv_beleglink.png\" alt='' title='Abb. 14: Beleglink in der CSV Datei f\u00fcr die XML + CSV Schnittstelle'  height=\"139\" width=\"1359\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/csv_beleglink.png 1359w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/csv_beleglink-300x31.png 300w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/csv_beleglink-1030x105.png 1030w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/csv_beleglink-768x79.png 768w, https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/csv_beleglink-705x72.png 705w\" sizes=\"(max-width: 1359px) 100vw, 1359px\" \/><\/div><\/div><\/div>\n<section  class='av_textblock_section av-kev5sv7m-e896ffeff2241aa29917a468fe6ee704 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>To explain the hospitality receipt in this example as well, let&#8217;s look at this area in the XML file:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\"><document guid=\"\u201d72692374\u20131b6b-0d00\u20139e72-de9f0afb6aa0\"\">\n <extension name=\"\u201d202009071523\u2013316261422\u20131.png\u201d\" xsi:type=\"\u201dFile\u201d\/\">\n <\/extension><\/document>\n <document guid=\"\u201d72692374\u20131b6b-0d00\u20139e74\u2013461e0afb6aa0\"\">\n <extension name=\"\u201d202009071523\u2013316261422\u20131.png\u201d\" xsi:type=\"\u201dFile\u201d\/\">\n <\/extension><\/document><\/pre>\n<p>If the guid&#8217;s of the two lines in the CSV file for the hospitality are compared with these two entries, one recognizes the connection that is made here and links the document screens with the bookings when reading in via DUO or Kanzlei-Rechnungswesen.<\/p>\n<p>The path of the data is as follows:<\/p>\n<p>The CSV file is read by the tax advisor directly into Kanzlei Rechnungswesen. The XML file is imported by the tax advisor via the app DATEV Belegtransfer into DATEV Unternehmen online and from there into Kanzlei Rechnungswesen. The UUID creates a link between the data.<\/p>\n<h2>DATEV data services (online)<\/h2>\n<p>Instead of passing files on by hand, software can also send the data online directly to DATEV. Manual handling is no longer necessary. Today these ways are called DATEV data services:<\/p>\n<ul>\n<li><strong>DATEV Rechnungsdatenservice 1.0:<\/strong> transfers receipt images and structured receipt data to DATEV Unternehmen online, similar to the XML interface described above. Booking then takes place in DATEV Rechnungswesen.<\/li>\n<li><strong>DATEV Buchungsdatenservice:<\/strong> transfers finished booking records together with the receipt images. The receipt images end up in DATEV Unternehmen online, the booking data in the DATEV data centre.<\/li>\n<\/ul>\n<p>Once a data service is set up, Spesenfuchs transfers approved expenses automatically every night. Requirements and setup are described on the page <a href=\"https:\/\/www.spesenfuchs.de\/en\/datev-data-service\/\">DATEV Data Service<\/a>.<\/p>\n<\/div><\/section>\n<div  class='hr av-1y6h9z-7944d3d1fa90a6eed87b07a6f910125e hr-default  avia-builder-el-31  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-kev5vuv3-5fb24cff704ac0339ef6e717fbd6339d '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h2>Summary<\/h2>\n<p>Basically, the facts are not complicated. But even we at Spesenfuchs had to understand the differences first when we implemented the interfaces. Therefore this contribution.<\/p>\n<p>Further, we would like to give our users a more detailed overview of the export options to better decide which format to use. You can create all three file formats in the Spesenfuchs export.<\/p>\n<h2>Links to the topic<\/h2>\n<p><a href=\"https:\/\/www.datev-community.de\" target=\"_blank\" rel=\"noopener\">https:\/\/www.datev-community.de<\/a> moderated forum from DATEV<\/p>\n<p><a href=\"https:\/\/developer.datev.de\/portal\/\" target=\"_blank\" rel=\"noopener\">https:\/\/developer.datev.de\/portal\/<\/a> Developer Portal from DATEV (free login required)<\/p>\n<\/div><\/section><br \/>\n<section  class='av_textblock_section av-rg-sf-9f6e349ebd97be4f75667e2c4a5ea2d8 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h2>DATEV export with Spesenfuchs<\/h2>\n<p>For travel expense and expense reports in Spesenfuchs, you choose your chart of accounts (SKR03, SKR04, SKR42 or your own chart of accounts); the accounts for the receipt types are already preset. After approval, you export the booking data as a DATEV file, with receipt images if required, or have it transferred automatically every night via the DATEV data service. In the Spesenfuchs export you choose between booking data only (CSV), booking data with receipt images (CSV with receipt images) and receipt data with receipt images (XML with receipt images). More on the page <a href=\"https:\/\/www.spesenfuchs.de\/en\/features\/datev-export\/\">DATEV export<\/a>.<\/p>\n<p>More guides: <a href=\"https:\/\/www.spesenfuchs.de\/en\/create-travel-expense-report\/\">Create travel expense report<\/a>, <a href=\"https:\/\/www.spesenfuchs.de\/en\/post-entertainment-receipts-correctly\/\">Post entertainment receipts correctly<\/a>.<\/p>\n<\/div><\/section><br \/>\n<br \/>\n[av_hr class='invisible' icon_select='yes' icon='ue808' font='entypo-fontello' position='center' shadow='no-shadow' height='50' custom_border='av-border-thin' custom_width='50px' custom_margin_top='30px' custom_margin_bottom='30px' custom_border_color='' custom_icon_color='' av-small-hide='aviaTBav-small-hide' av-mini-hide='aviaTBav-mini-hide' id='' custom_class='' av_uid='av-k3y7pcut' admin_preview_bg='']\r\n\r\n[av_button label='Try free for 30 days' icon_select='no' icon='ue800' font='entypo-fontello' link='page,8766' link_target='' size='large' position='center' label_display='' title_attr='' size-text='' av-desktop-font-size-text='' av-medium-font-size-text='' av-small-font-size-text='' av-mini-font-size-text='' margin='' margin_sync='true' padding='' padding_sync='true' av-desktop-margin='' av-desktop-margin_sync='true' av-desktop-padding='' av-desktop-padding_sync='true' av-medium-margin='' av-medium-margin_sync='true' av-medium-padding='' av-medium-padding_sync='true' av-small-margin='' av-small-margin_sync='true' av-small-padding='' av-small-padding_sync='true' av-mini-margin='' av-mini-margin_sync='true' av-mini-padding='' av-mini-padding_sync='true' color_options='' color='custom' custom_bg='#9eae12' custom_font='#ffffff' btn_color_bg='theme-color' btn_custom_grad_direction='vertical' btn_custom_grad_1='#000000' btn_custom_grad_2='#ffffff' btn_custom_grad_3='' btn_custom_grad_opacity='0.7' btn_custom_bg='#444444' btn_color_bg_hover='theme-color-highlight' btn_custom_bg_hover='#444444' btn_color_font='theme-color' btn_custom_font='#ffffff' btn_color_font_hover='white' btn_custom_font_hover='#ffffff' border='' border_width='' border_width_sync='true' border_color='' border_radius='' border_radius_sync='true' box_shadow='' box_shadow_style='0px,0px,0px,0px' box_shadow_color='' animation='' animation_duration='' animation_custom_bg_color='' animation_z_index_curtain='100' hover_opacity='' sonar_effect_effect='' sonar_effect_color='' sonar_effect_duration='1' sonar_effect_scale='' sonar_effect_opac='0.5' css_position='' css_position_location=',,,' css_position_z_index='' av-desktop-css_position='' av-desktop-css_position_location=',,,' av-desktop-css_position_z_index='' av-medium-css_position='' av-medium-css_position_location=',,,' av-medium-css_position_z_index='' av-small-css_position='' av-small-css_position_location=',,,' av-small-css_position_z_index='' av-mini-css_position='' av-mini-css_position_location=',,,' av-mini-css_position_z_index='' id='' custom_class='' template_class='' av_uid='av-ju9gs2iy' sc_version='1.0' admin_preview_bg='']\r\n\r\n[av_hr class='invisible' icon_select='yes' icon='ue808' font='entypo-fontello' position='center' shadow='no-shadow' height='50' custom_border='av-border-thin' custom_width='50px' custom_margin_top='30px' custom_margin_bottom='30px' custom_border_color='' custom_icon_color='' av-desktop-hide='aviaTBav-desktop-hide' av-medium-hide='aviaTBav-medium-hide' id='' custom_class='' template_class='' av_uid='av-k3y7pcut-1' sc_version='1.0' admin_preview_bg='']\r\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An overview of the different file formats based on a travel expense report.<\/p>\n","protected":false},"author":1,"featured_media":7511,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[607],"tags":[548,554,538,561,555],"class_list":["post-7751","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accounting-and-datev","tag-datev-en","tag-travel-expense-management","tag-travel-expense-report","tag-travel-expense-software","tag-travel-expenses"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DATEV export of travel expenses: CSV, XML, data service and example<\/title>\n<meta name=\"description\" content=\"How travel expense reports get to DATEV with booking data and receipt images: CSV, XML or DATEV data service compared, with an example trip and file structure.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DATEV export of travel expenses: CSV, XML, data service and example\" \/>\n<meta property=\"og:description\" content=\"How travel expense reports get to DATEV with booking data and receipt images: CSV, XML or DATEV data service compared, with an example trip and file structure.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/\" \/>\n<meta property=\"og:site_name\" content=\"Spesenfuchs\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-08T10:26:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-11T21:55:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1135\" \/>\n\t<meta property=\"og:image:height\" content=\"1031\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"suelm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"suelm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/\"},\"author\":{\"name\":\"suelm\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#\\\/schema\\\/person\\\/67fe6175367c28f5eb24fcaf68030a00\"},\"headline\":\"DATEV export of travel expenses\",\"datePublished\":\"2020-09-08T10:26:43+00:00\",\"dateModified\":\"2026-11-11T21:55:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/\"},\"wordCount\":3672,\"publisher\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.spesenfuchs.de\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/eingabemaske.png\",\"keywords\":[\"DATEV\",\"Travel expense management\",\"Travel expense report\",\"Travel expense software\",\"Travel expenses\"],\"articleSection\":[\"Accounting and DATEV\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/\",\"url\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/\",\"name\":\"DATEV export of travel expenses: CSV, XML, data service and example\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.spesenfuchs.de\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/eingabemaske.png\",\"datePublished\":\"2020-09-08T10:26:43+00:00\",\"dateModified\":\"2026-11-11T21:55:25+00:00\",\"description\":\"How travel expense reports get to DATEV with booking data and receipt images: CSV, XML or DATEV data service compared, with an example trip and file structure.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.spesenfuchs.de\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/eingabemaske.png\",\"contentUrl\":\"https:\\\/\\\/www.spesenfuchs.de\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/eingabemaske.png\",\"width\":1135,\"height\":1031},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DATEV export of travel expenses\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/\",\"name\":\"Spesenfuchs\",\"description\":\"Reisekosten und Ausgaben online abrechnen\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#organization\",\"name\":\"Spesenfuchs GmbH\",\"url\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.spesenfuchs.de\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/Logo-scroll2x_neu-1.png\",\"contentUrl\":\"https:\\\/\\\/www.spesenfuchs.de\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/Logo-scroll2x_neu-1.png\",\"width\":340,\"height\":156,\"caption\":\"Spesenfuchs GmbH\"},\"image\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#\\\/schema\\\/person\\\/67fe6175367c28f5eb24fcaf68030a00\",\"name\":\"suelm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3f129b71f584d11465fb42a5af5cdad8d6539cab4ff6dc402d9779a38e359a06?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3f129b71f584d11465fb42a5af5cdad8d6539cab4ff6dc402d9779a38e359a06?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3f129b71f584d11465fb42a5af5cdad8d6539cab4ff6dc402d9779a38e359a06?s=96&d=mm&r=g\",\"caption\":\"suelm\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DATEV export of travel expenses: CSV, XML, data service and example","description":"How travel expense reports get to DATEV with booking data and receipt images: CSV, XML or DATEV data service compared, with an example trip and file structure.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/","og_locale":"en_US","og_type":"article","og_title":"DATEV export of travel expenses: CSV, XML, data service and example","og_description":"How travel expense reports get to DATEV with booking data and receipt images: CSV, XML or DATEV data service compared, with an example trip and file structure.","og_url":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/","og_site_name":"Spesenfuchs","article_published_time":"2020-09-08T10:26:43+00:00","article_modified_time":"2026-11-11T21:55:25+00:00","og_image":[{"width":1135,"height":1031,"url":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png","type":"image\/png"}],"author":"suelm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"suelm","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#article","isPartOf":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/"},"author":{"name":"suelm","@id":"https:\/\/www.spesenfuchs.de\/en\/#\/schema\/person\/67fe6175367c28f5eb24fcaf68030a00"},"headline":"DATEV export of travel expenses","datePublished":"2020-09-08T10:26:43+00:00","dateModified":"2026-11-11T21:55:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/"},"wordCount":3672,"publisher":{"@id":"https:\/\/www.spesenfuchs.de\/en\/#organization"},"image":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#primaryimage"},"thumbnailUrl":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png","keywords":["DATEV","Travel expense management","Travel expense report","Travel expense software","Travel expenses"],"articleSection":["Accounting and DATEV"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/","url":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/","name":"DATEV export of travel expenses: CSV, XML, data service and example","isPartOf":{"@id":"https:\/\/www.spesenfuchs.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#primaryimage"},"image":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#primaryimage"},"thumbnailUrl":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png","datePublished":"2020-09-08T10:26:43+00:00","dateModified":"2026-11-11T21:55:25+00:00","description":"How travel expense reports get to DATEV with booking data and receipt images: CSV, XML or DATEV data service compared, with an example trip and file structure.","breadcrumb":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#primaryimage","url":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png","contentUrl":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png","width":1135,"height":1031},{"@type":"BreadcrumbList","@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.spesenfuchs.de\/en\/"},{"@type":"ListItem","position":2,"name":"DATEV export of travel expenses"}]},{"@type":"WebSite","@id":"https:\/\/www.spesenfuchs.de\/en\/#website","url":"https:\/\/www.spesenfuchs.de\/en\/","name":"Spesenfuchs","description":"Reisekosten und Ausgaben online abrechnen","publisher":{"@id":"https:\/\/www.spesenfuchs.de\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.spesenfuchs.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.spesenfuchs.de\/en\/#organization","name":"Spesenfuchs GmbH","url":"https:\/\/www.spesenfuchs.de\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.spesenfuchs.de\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2019\/04\/Logo-scroll2x_neu-1.png","contentUrl":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2019\/04\/Logo-scroll2x_neu-1.png","width":340,"height":156,"caption":"Spesenfuchs GmbH"},"image":{"@id":"https:\/\/www.spesenfuchs.de\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.spesenfuchs.de\/en\/#\/schema\/person\/67fe6175367c28f5eb24fcaf68030a00","name":"suelm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3f129b71f584d11465fb42a5af5cdad8d6539cab4ff6dc402d9779a38e359a06?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3f129b71f584d11465fb42a5af5cdad8d6539cab4ff6dc402d9779a38e359a06?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3f129b71f584d11465fb42a5af5cdad8d6539cab4ff6dc402d9779a38e359a06?s=96&d=mm&r=g","caption":"suelm"}}]}},"_links":{"self":[{"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/posts\/7751","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/comments?post=7751"}],"version-history":[{"count":17,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/posts\/7751\/revisions"}],"predecessor-version":[{"id":13649,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/posts\/7751\/revisions\/13649"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/media\/7511"}],"wp:attachment":[{"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/media?parent=7751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/categories?post=7751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/tags?post=7751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}