Help
Getting started
- Open a Google Sheet, Extensions → E-Rechnung für Sheets – XRechnung & ZUGFeRD → Set up tabs & template. This creates the tabs Rechnungen (invoice lines), Kunden (customers), Verkäufer (your company), Einstellungen (settings), a Drive folder “E-Rechnungen” and an editable Google Docs template.
- Replace the sample data with yours. One invoice = all rows with the same invoice number.
- Open the sidebar (Extensions → E-Rechnung für Sheets – XRechnung & ZUGFeRD → Open sidebar), pick an invoice, Check, then Create. Files land in the Drive folder.
Formats
ZUGFeRD-PDF: a PDF/A-3 with the invoice data embedded (profile EN 16931; XRECHNUNG when the customer has a Leitweg-ID or the output is an XRechnung variant, e.g. “ZUGFeRD-PDF + XRechnung (CII)”). XRechnung (CII/UBL): the pure XML required by public-sector buyers. Choose in Einstellungen → Ausgabe.
Tax cases
Column Steuer: S standard (19 %/7 %), Z zero-rated, E exempt / Kleinunternehmer § 19, AE reverse charge § 13b, K intra-EU supply, G export, O not taxable. The legally required note (e.g. “Steuerschuldnerschaft des Leistungsempfängers”) is added automatically.
Template
Edit the Google Doc “E-Rechnung Vorlage” freely – logo, colours, texts. Keep the placeholders in double curly braces. The line table needs the row with {{Bezeichnung}}. Keep the bottom-right corner free for the GiroCode.
Incoming e-invoices
Sidebar → Incoming → choose an XML or ZUGFeRD PDF. You see a readable view and can add it to the tab Eingangsrechnungen.
DATEV
Sidebar → DATEV creates a booking batch (EXTF) of one month for your tax advisor. Enter Beraternummer, Mandantennummer and chart of accounts (SKR03/SKR04) in Einstellungen; without Beraternummer and Mandantennummer the export stops. For the full DATEV workflow with Shopify, WooCommerce or Wix see buchungsstapel.de.
Trial and license
30 days with all features. Afterwards viewing, checking, importing and the DATEV export keep working; creating needs a license (pricing). Paste the key into Einstellungen → Lizenzschlüssel.