Convert XRechnung to CSV
For the case where the destination is an import mask rather than a human. The invoice comes out flat, one row per line item, ready to paste into whatever your bookkeeping software expects.
| # | Description | Qty | Unit | Unit price | VAT % | Net amount |
|---|
| Category | Rate | Taxable base | VAT amount |
|---|
| # | Qualifier | Reference | Amount | Paid |
|---|
| Segment | Element | Value |
|---|
When CSV beats a spreadsheet
Most accounting packages import CSV and nothing else, and most of them choke on the workbook a converter hands you. The CSV here is deliberately plain: no merged headers, no formatting, no footnotes under the table, decimal points left as they were in the source so a locale setting cannot quietly move them.
What you get out
Every field below is read from the file itself. Nothing is inferred, and a field the invoice does not carry is left empty rather than filled in with a plausible guess.
- One row per invoice line, with the header fields repeated on each row
- Invoice number, dates, currency, buyer reference and Leitweg-ID
- Seller and buyer identification, including VAT numbers
- Quantity, unit of measure, unit price, VAT rate and net amount per line
- A separate tax export with taxable base and VAT amount per rate
Questions
Which separator does the file use?
Comma, with fields quoted where they contain one. If your Excel is set to a German locale and shows everything in one column, use Data, then From Text, and pick comma as the delimiter, or take the Excel export instead.
Can I get one CSV out of several invoices?
Not on this page yet. Each file exports on its own. Batching many invoices into one sheet is the first thing on the paid side, and there is a form on the home page for saying you need it.
Do the numbers keep their decimals?
Yes. Amounts are written exactly as the invoice states them, without rounding or locale conversion, because a cent that moves during an import is a cent someone has to chase later.