Export XRechnung invoices to Excel and DATEV

Drop several e-invoices and get one spreadsheet with every header and line item, CSV files, or a booking batch for DATEV. It is all made in your browser.

Drop your e-invoices here

XRechnung XML, ZUGFeRD PDF or ZIP, up to 10 files for free

No files at hand?

What the batch export is for

One XRechnung is easy to read in a viewer. Twenty a month need a list: every invoice with number, date, supplier, net, VAT and amount due side by side, so deliveries can be ticked off, amounts matched with orders and open items tracked. That is what this page builds, from XRechnung files in UBL or CII and from ZUGFeRD PDFs.

How it works

  1. Drop the files on the sheet above or choose several with “Choose files”. A ZIP archive of invoices works too.
  2. The overview lists each invoice read, with number, date, seller and amount due. Files that are not e-invoices are listed with the reason.
  3. Download the Excel workbook, the CSV files or the DATEV batch.

What the workbook contains

  • Invoices: one row per invoice with file, format, number, type, issue, due and delivery dates, seller and buyer with VAT IDs, Leitweg-ID, order number, net, VAT, gross, prepaid, amount due, IBAN, payment reference, terms and any failed arithmetic checks
  • Lines: one row per line item with item number, name, quantity, unit, unit price, net amount, VAT category and rate
  • VAT: one row per invoice and rate with taxable amount, tax and exemption reason

The CSV files hold the same columns as the invoices and lines sheets, comma-separated with a decimal point.

The DATEV export

For German bookkeeping the page also writes a CSV in DATEV’s published “Buchungsstapel” format (EXTF header version 700, format version 13, all 125 columns, Windows-1252): one booking per invoice and VAT rate over the gross amount, on the creditor or debtor account you choose against the usual automatic accounts (SKR 03: 3400/3300 for purchases, 8400/8300 for sales; SKR 04: 5400/5300 and 4400/4300). Credit notes reverse the debit/credit flag, and invoices from different years go into separate files. It is an import aid, not a booking recommendation, and not tested or certified by DATEV. DATEV is a trademark of DATEV eG.

The exports show what the files say; they do not correct anything, and they do not replace the XML originals, which German law requires you to keep for eight years.

Frequently asked questions

How many invoices can I export at once?

Up to 10 files at a time for free. Pick them one by one or drop a ZIP archive, which is unpacked in your browser. Larger batches, up to 500 files, are planned for Pro.

Are the invoices uploaded?

No. Every file is read in your browser, and the Excel and CSV files are created there too. Nothing is sent to a server.

Do sums and pivot tables work in Excel?

Yes. Amounts, quantities and VAT rates are stored as real numbers and dates as real dates, so you can sum, filter and pivot straight away.

Are ZUGFeRD PDFs included?

Yes. The XML embedded in ZUGFeRD and Factur-X PDFs is read. Ordinary PDF invoices without XML are listed as unreadable, because they contain no structured data.

What is the DATEV export?

DATEV is the accounting software most German tax advisers use. The export writes a CSV in DATEV’s published “Buchungsstapel” booking-batch format, with one booking per invoice and VAT rate. It is an import aid, not tested or certified by DATEV; agree the accounts with your accountant.

What happens to invoices with errors?

They are exported anyway. The “Issues” column names the rules that failed, such as BR-CO-16 when the amount due does not match the totals. The XRechnung validator on this site explains each one.

Sources

  1. DATEV-Format: Buchungsstapel (Formatbeschreibung, Version 700, Formatversion 13)DATEV eG, Developer Portal
  2. Häufige Fragen zum Thema E-RechnungDATEV eG
  3. § 14b UStG – Aufbewahrung von RechnungenBundesministerium der Justiz, gesetze-im-internet.de
  4. XRechnung – Versionen und BundlesKoSIT / xeinkauf.de

Last reviewed:

Pro for accounting teams

In preparation. Not available to buy yet.

If you receive dozens of e-invoices or signed files every month, opening them one by one is not a workflow. Pro handles the batch work and runs locally in your browser, like the free tools.

  • Batch processing: a ZIP of up to 500 XRechnung and ZUGFeRD files in one go (FatturaPA and .p7m planned)
  • Export to Excel and CSV with header data and every line item
  • Export in DATEV format (Buchungsstapel) for German bookkeeping
  • A validation report as PDF for each invoice (planned)
  • Create ZUGFeRD invoices in batches, with saved company details (planned)

See Pro and try it

Single export€2.99per file
Pro monthly€12per month
Pro yearly€99per year

Planned prices including VAT, subject to change. Viewing, printing and saving a single file as PDF stays free.

The waitlist is not live yet: this form stores and sends nothing.