{"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-03-18T10:34:54","modified_gmt":"2026-03-18T09:34:54","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":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-9qw1x4-c3b86e4ea6e647e2c9ca89d65e60ed6e\">\n.avia-section.av-9qw1x4-c3b86e4ea6e647e2c9ca89d65e60ed6e{\nbackground-repeat:no-repeat;\nbackground-image:url(https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2019\/12\/IMG_0290-1500x430.jpg);\nbackground-position:50% 0%;\nbackground-attachment:scroll;\n}\n.avia-section.av-9qw1x4-c3b86e4ea6e647e2c9ca89d65e60ed6e .av-section-color-overlay{\nopacity:0.6;\nbackground-color:#9e9e9e;\n}\n<\/style>\n<div id='av_section_1'  class='avia-section av-9qw1x4-c3b86e4ea6e647e2c9ca89d65e60ed6e main_color avia-section-large avia-no-shadow  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first  avia-full-stretch avia-bg-style-scroll av-section-color-overlay-active container_wrap sidebar_right'  data-section-bg-repeat='stretch'><div class=\"av-section-color-overlay-wrap\"><div class=\"av-section-color-overlay\"><\/div><div class='container av-section-cont-open' ><main  role=\"main\" itemprop=\"mainContentOfPage\"  class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-7751'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9\">\n#top .av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9{\npadding-bottom:0;\ncolor:#ffffff;\nfont-size:40px;\n}\nbody .av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n#top #wrap_all .av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 .av-special-heading-tag{\nfont-size:40px;\n}\n.av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 .special-heading-inner-border{\nborder-color:#ffffff;\n}\n.av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 .av-subheading{\nfont-size:15px;\n}\n\n@media only screen and (min-width: 480px) and (max-width: 767px){ \n#top #wrap_all .av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 .av-special-heading-tag{\nfont-size:0.8em;\n}\n}\n\n@media only screen and (max-width: 479px){ \n#top #wrap_all .av-special-heading.av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 .av-special-heading-tag{\nfont-size:0.8em;\n}\n}\n<\/style>\n<div  class='av-special-heading av-kett5pzl-21b9b7864954de1d994401a0b62f1ae9 av-special-heading-h1 custom-color-heading blockquote modern-quote  avia-builder-el-1  avia-builder-el-no-sibling  av-inherit-size av-linked-heading'><h1 class='av-special-heading-tag '  itemprop=\"headline\"  >DATEV export of travel expenses<\/h1><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<\/div><\/div><\/main><!-- close content main element --><\/div><\/div><\/div><div id='after_section_1'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-7751'><div class='entry-content-wrapper clearfix'>\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 1-day business trip from Karlsruhe to Freiburg. Departure 6:00, return the following 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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. A proud 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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\" fetchpriority=\"high\" 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 Belegransfer into DATEV Unternehmen online and from there into Kanzlei Rechnungswesen. The UUID creates a link between the data.<\/p>\n<h2>Interface DATEV Online<\/h2>\n<p>The DATEV online interface uses the files of the XML interface described above. The data from XML interface is sent online from the external application itself directly to DATEV Unternehmen online. Manual handling is no longer necessary. However, the structure of the data is the same as for the XML interface. Since we are only devoted to file formats here, there is nothing more to say about this topic.<\/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. All described formats can be generated in Spesenfuchs.<\/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>\n","protected":false},"excerpt":{"rendered":"<p>An overview of the different file formats based on a travel expense report.<\/p>\n","protected":false},"author":3,"featured_media":7511,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[543,14],"tags":[548,554,538,561,555],"class_list":["post-7751","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-datev-en","category-unkategorisiert","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 v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DATEV export of travel expenses - Spesenfuchs<\/title>\n<meta name=\"description\" content=\"An overview of the different file formats for export to DATEV based on a travel expense report in Spesenfuchs.\" \/>\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 - Spesenfuchs\" \/>\n<meta property=\"og:description\" content=\"An overview of the different file formats for export to DATEV based on a travel expense report in Spesenfuchs.\" \/>\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-03-18T09:34:54+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=\"Spesenfuchs\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Spesenfuchs\" \/>\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\":\"Spesenfuchs\",\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/#\\\/schema\\\/person\\\/f57ac0db94fc98bee97866539de276ef\"},\"headline\":\"DATEV export of travel expenses\",\"datePublished\":\"2020-09-08T10:26:43+00:00\",\"dateModified\":\"2026-03-18T09:34:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.spesenfuchs.de\\\/en\\\/datev-export-of-travel-expenses\\\/\"},\"wordCount\":3115,\"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\":[\"DATEV\",\"Unkategorisiert\"],\"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 - Spesenfuchs\",\"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-03-18T09:34:54+00:00\",\"description\":\"An overview of the different file formats for export to DATEV based on a travel expense report in Spesenfuchs.\",\"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\\\/f57ac0db94fc98bee97866539de276ef\",\"name\":\"Spesenfuchs\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e59dc0b9eb4c13d85ee4c0ba0bb0f1734110e4e60de212dabb0c7f219ac32ba5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e59dc0b9eb4c13d85ee4c0ba0bb0f1734110e4e60de212dabb0c7f219ac32ba5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e59dc0b9eb4c13d85ee4c0ba0bb0f1734110e4e60de212dabb0c7f219ac32ba5?s=96&d=mm&r=g\",\"caption\":\"Spesenfuchs\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DATEV export of travel expenses - Spesenfuchs","description":"An overview of the different file formats for export to DATEV based on a travel expense report in Spesenfuchs.","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 - Spesenfuchs","og_description":"An overview of the different file formats for export to DATEV based on a travel expense report in Spesenfuchs.","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-03-18T09:34:54+00:00","og_image":[{"width":1135,"height":1031,"url":"https:\/\/www.spesenfuchs.de\/wp-content\/uploads\/2020\/09\/eingabemaske.png","type":"image\/png"}],"author":"Spesenfuchs","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Spesenfuchs","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":"Spesenfuchs","@id":"https:\/\/www.spesenfuchs.de\/en\/#\/schema\/person\/f57ac0db94fc98bee97866539de276ef"},"headline":"DATEV export of travel expenses","datePublished":"2020-09-08T10:26:43+00:00","dateModified":"2026-03-18T09:34:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.spesenfuchs.de\/en\/datev-export-of-travel-expenses\/"},"wordCount":3115,"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":["DATEV","Unkategorisiert"],"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 - Spesenfuchs","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-03-18T09:34:54+00:00","description":"An overview of the different file formats for export to DATEV based on a travel expense report in Spesenfuchs.","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\/f57ac0db94fc98bee97866539de276ef","name":"Spesenfuchs","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e59dc0b9eb4c13d85ee4c0ba0bb0f1734110e4e60de212dabb0c7f219ac32ba5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e59dc0b9eb4c13d85ee4c0ba0bb0f1734110e4e60de212dabb0c7f219ac32ba5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e59dc0b9eb4c13d85ee4c0ba0bb0f1734110e4e60de212dabb0c7f219ac32ba5?s=96&d=mm&r=g","caption":"Spesenfuchs"}}]}},"_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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/comments?post=7751"}],"version-history":[{"count":13,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/posts\/7751\/revisions"}],"predecessor-version":[{"id":11643,"href":"https:\/\/www.spesenfuchs.de\/en\/wp-json\/wp\/v2\/posts\/7751\/revisions\/11643"}],"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}]}}