Help CenterContact support
All Columna: Order PDF & Invoices articles

E-invoices and the DATEV export

Updated

On this page
  1. The formats
  2. Set up XRechnung
  3. Download e-invoices
  4. DATEV export (Pro)
  5. What is not included

Every invoice and credit note the app issues is stored exactly as it was issued (see Automatic invoices and the archive). From those stored documents the app can make structured e-invoices and a booking file for your tax advisor.

Columna creates files. It does not check that they meet your legal obligations, and it does not send them to any portal or network. Ask your tax advisor or accountant which formats and accounts you need.

The formats

  • ZUGFeRD / Factur-X — the invoice PDF carries an XML file (CII, profile EN 16931) inside it. This is part of every invoice and credit note once your business has a VAT ID in Settings › Business details. You can download the XML on its own from the archive (see below).
  • XRechnung (Pro) — an XML file (UBL, XRechnung 3.0) without a PDF, as German public-sector buyers ask for. It is made from the stored document whenever you download it, so documents issued before you upgraded get one too.

Both are made from what you entered in Settings:

  • Business details — your business name, address, VAT ID, email and phone.
  • Payment details — IBAN, BIC and the days until an unpaid invoice is due.
  • E-invoices (Pro) — the contact person and the Leitweg-IDs of public-sector buyers (see below).

The buyer’s VAT ID comes from the order, the same one the printed invoice shows.

Set up XRechnung

Open Settings › E-invoices:

  1. Contact person on e-invoices — XRechnung needs a seller contact. Leave it empty to use your business name.
  2. Attach the XRechnung XML to invoice emails — invoice and credit note emails then carry the XRechnung file next to the PDF. A document an XRechnung cannot be made for is sent with the PDF only.
  3. Public-sector buyers — a German public authority gives you its Leitweg-ID (for example 991-12345-73). Enter the buyer’s email address or VAT ID and the Leitweg-ID, then click Add buyer. The app checks the Leitweg-ID’s check digits. Their XRechnung then carries the Leitweg-ID as the buyer reference.

A Leitweg-ID can also be typed on the order as an order attribute named Leitweg-ID or Buyer reference; that one wins. Without either, the buyer reference is the order’s PO number, or else the order name.

Download e-invoices

In Orders › Issued invoices:

  • One document — click … on its row: Factur-X XML downloads the XML embedded in the stored PDF, XRechnung XML (Pro) makes the XRechnung. When an XRechnung cannot be made, the app says why, for example a missing buyer postcode, or a business phone number that was missing when the document was issued.
  • A period (Pro) — click Download e-invoices, choose the format and the dates (at most one year). The app first shows how many documents the period has and which ones it will leave out, and why. The ZIP holds one file per document; the ones left out are listed in skipped.csv inside it. If the download stops before it finishes, nothing is saved and the app says so; try again, or choose a shorter period.

DATEV export (Pro)

The DATEV export is a Buchungsstapel file (EXTF CSV) your tax advisor imports into DATEV.

Set it up once in Settings › DATEV:

  • Consultant number (Beraternummer) and Client number (Mandantennummer) — from your tax advisor.
  • Chart of accounts — SKR03 or SKR04. Switching the chart replaces the revenue accounts with that chart’s defaults.
  • Account length, Fiscal year starts in and the Debtor account every document is booked against.
  • Revenue accounts — one account per VAT category and rate, with an optional tax key (BU-Schlüssel). The defaults are the usual automatic revenue accounts for 19 % and 7 % VAT, intra-EU supplies, exports, reverse charge and sales without VAT. Add a row for any other rate you charge, for example OSS sales at another EU country’s rate.

Then, in Orders › Issued invoices, click DATEV export and choose the dates. The period must lie in one fiscal year. The file has:

  • one booking per VAT rate of each invoice and credit note, with the document number as Belegfeld 1;
  • credit notes booked the other way round (credit instead of debit);
  • the gross amount; the tax is worked out from the revenue account or the tax key;
  • for intra-EU supplies and reverse charge services, the buyer’s VAT ID (EU-Land u. UStID);
  • the customer’s name in the booking text, with letters DATEV’s character set lacks written without their accent (for example Łódź becomes Lódz).

The export leaves out, and lists before you download:

  • documents not in euros;
  • documents issued without a VAT breakdown;
  • documents with a VAT rate that has no account in Settings;
  • documents whose number has nothing DATEV accepts as Belegfeld 1;
  • documents with a total of zero, which have nothing to book.

Tips and import duties are not booked. Book anything left out by hand, or add the missing account and export again.

What is not included

  • Sending e-invoices to a portal or network (for example ZRE, OZG-RE or Peppol). Upload the files yourself.
  • Transmission through a French PDP (plateforme de dématérialisation partenaire). Columna is not a PDP and does not connect to one.
  • Changing a document after it was issued. Fix the settings and the documents issued afterwards use them; for an issued invoice, issue a credit note.

Built and supported by StoreFleet, Shopify app developers since 2021.