Help
Getting started
- Open a Google Sheet, Extensions → E-Rechnung → Set up. 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, 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, or XRECHNUNG when the customer has a Leitweg-ID). 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. For the full DATEV workflow with Shopify, WooCommerce or Wix see buchungsstapel.de.
Trial and license
30 days with all features. Afterwards viewing and checking keep working; creating needs a license (pricing). Paste the key into Einstellungen → Lizenzschlüssel.