{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["E-Rechnung","Rechnungsdaten","Konfiguration"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":165,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"E-Rechnung","index":0,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,0,3,3],[3,6,3,9],[18,0,18,1],[38,0,38,9],[25,5,25,7],[34,0,34,9],[26,5,26,7],[22,0,22,3],[23,0,23,3]]}
[]
[]
[]
[{"$f":" RecipientName & IF(ISBLANK(RecipientBusinessName),\"\",CHAR(10) & RecipientBusinessName) & CHAR(10) & RecipientStreet & IF(ISBLANK(RecipientStreet2),\"\",CHAR(10) & RecipientStreet2) & IF(ISBLANK(RecipientAdditional),\"\",CHAR(10) & RecipientAdditional) & CHAR(10) & RecipientZip & \" \" & RecipientLocation & CHAR(10) & RecipientCountry","v":"Name des Rechnungsempfängers\nStraße Hausnummer\n12345 Ort\nDeutschland"},null,null,null,null,null,{"$f":" SenderName & IF(ISBLANK(SenderBusinessName),\"\",CHAR(10) & SenderBusinessName) & CHAR(10) & SenderStreet & IF(ISBLANK(SenderStreet2),\"\",CHAR(10) & SenderStreet2) & IF(ISBLANK(SenderAdditional),\"\",CHAR(10) & SenderAdditional) & CHAR(10) & SenderZip & \" \" & SenderLocation & CHAR(10) & SenderCountry","v":"Name des Rechnungserstellers\nStraße Hausnummer\n12345 Ort\nDeutschland"}]
[]
[{"$f":" RecipientVatId & IF(OR(ISBLANK(RecipientVatId), ISBLANK(RecipientTaxId)), \"\", \" / \") & RecipientTaxId","v":"DE100000000"},null,null,null,null,null,{"$f":" SenderVatId & IF(OR(ISBLANK(SenderVatId), ISBLANK(SenderTaxId)), \"\", \" / \") & SenderTaxId","v":"DE200000000"}]
[{"$f":" IF(ISBLANK(RecipientId), \"\", RecipientId)","v":""},null,null,null,null,null,{"$f":" IF(ISBLANK(SenderId), \"\", SenderId)","v":""}]
[{"$f":" IF(ISBLANK(RecipientLeitwegId), \"\", \"Leitweg-ID: \" & RecipientLeitwegId)","v":""},null,null,null,null,null,{"$f":" IF(ISBLANK(SenderContactName), \"\", SenderContactName)","v":""}]
[{"$f":" IF(ISBLANK(RecipientContactEmail), \"\", RecipientContactEmail)","v":""},null,null,null,null,null,{"$f":" IF(ISBLANK(SenderContactEmail), \"\", SenderContactEmail)","v":""}]
[null,null,null,null,null,null,{"$f":" IF(ISBLANK(SenderContactPhone), \"\", SenderContactPhone)","v":""}]
[]
[]
["Rechnung"]
[]
[]
["Rechnungsnummer:",null,{"$f":" InvoiceNumber","v":"R12345"},null,null,null,{"$f":" IF(ISBLANK(ProjectId), \"\", \"Projekt \" & ProjectId) & IF(OR(ISBLANK(ProjectId), ISBLANK(ProjectName)), \"\", \" / \") & ProjectName","v":""}]
["Rechnungsdatum:",null,{"$f":" InvoiceDate","v":"2026-04-07"},null,null,null,{"$f":" IF(ISBLANK(RecipientOrderId), \"\", \"Bestellnummer \" & RecipientOrderId)","v":""}]
["Leistungsdatum/-zeitraum:",null,{"$f":" TEXT(InvoiceDeliveryDate, \"TT.MM.JJJJ\") & IF(ISBLANK(InvoiceDeliveryDate2),\"\", \" bis \" & TEXT(InvoiceDeliveryDate2, \"TT.MM.JJJJ\"))","v":"01.01.2026 bis 31.03.2026"}]
["Fälligkeitsdatum:",null,{"$f":" InvoiceDueDate","v":"2026-04-29"}]
[]
[]
[]
["Gegenstand/Leistung",null,null,null,"Menge","Einheit","Einzelpreis netto","Rabatt","Steuer-\nsatz","Gesamtpreis netto"]
[{"$f":"IF(ISBLANK(ItemName1),\"\",ItemName1)","v":"Beispielgegenstand"},null,null,null,{"$f":"IF(ISBLANK(ItemName1),\"\",ItemQuantity1)","v":2},{"$f":" IF(ISBLANK(ItemName1), \"\", LEFT(ItemUnit1, FIND(\" (\", ItemUnit1)-1))","v":"Stück"},{"$f":"IF(ISBLANK(ItemName1),\"\",ItemBasePrice1)","v":800},{"$f":"IF(ISBLANK(ItemName1),\"\",ItemDiscount1/100)","v":0.03},{"$f":"IF(ISBLANK(ItemName1),\"\",ItemTaxRate1/100)","v":0.19},{"$f":"IF(A24<>\"\",ROUND(E24*G24*(1-H24),2),\"\")","v":1552}]
[null,null,null,null,null,null,null,null,"Zwischensumme netto",{"$f":"SUM(J24:J24)","v":1552}]
[null,null,null,null,null,{"$f":" IF(ChargePercent > 0, ChargeReason,\"\")","v":"Aufschlaggrund"},null,null,{"$f":" IF(ChargePercent > 0, ChargePercent/100, \"\")","v":0.03},{"$f":" IF(ChargePercent > 0, ROUND(J25*I26,2), \"\")","v":46.56}]
[null,null,null,null,null,{"$f":" IF(DiscountPercent > 0, DiscountReason, \"\")","v":"Rabattgrund"},null,null,{"$f":" IF(DiscountPercent > 0, DiscountPercent/100, \"\")","v":0.1},{"$f":" IF(DiscountPercent > 0, -ROUND(J25*I27,2), \"\")","v":-155.19999999999999}]
[null,null,null,null,null,null,null,null,"Summe mit Aufschlag",{"$f":"SUM(J25:J27)","v":1443.36}]
[null,null,null,null,null,null,null,null,"zuzüglich 7 % Umsatzsteuer",{"$f":"ROUND(SUMIF(I24:I24,\"7 %\",J24:J24)*0.07 + IF(AND(ChargePercent > 0, ChargeTaxRate=7),J26*0.07,0) + IF(AND(DiscountPercent > 0, DiscountTaxRate=7),J27*0.07,0),2)","v":0}]
[null,null,null,null,null,null,null,null,"zuzüglich 19 % Umsatzsteuer",{"$f":"ROUND(SUMIF(I24:I24,\"19 %\",J24:J24)*0.19+IF(AND(ChargePercent>0,ChargeTaxRate=19),J26*0.19,0)+IF(AND(DiscountPercent>0,DiscountTaxRate=19),J27*0.19,0),2)","v":274.24}]
[null,null,null,null,null,null,null,null,{"$f":" IF(PrepaidAmount > 0, \"Vorauszahlungsbetrag\", \"\")","v":""},{"$f":" IF(PrepaidAmount > 0, -PrepaidAmount, \"\")","v":""}]
[null,null,null,null,null,null,null,null,"Rechnungsbetrag",{"$f":"SUM(J28:J31)","v":1717.6}]
[]
[]
[{"$f":" IF(ISBLANK(SenderIBAN), \"\", \"Bitte überweisen Sie den Rechnungsbetrag \" & TEXT(J32, \"#.##0,00 €\") & \" bis zum \" & TEXT(InvoiceDueDate, \"TT.MM.JJJJ\") & \" an \" & IF(ISBLANK(SenderBankAccountName), \"\", SenderBankAccountName & \", \") & \"IBAN \" & SenderIBAN & \", BIC \" & SenderBIC & \".\")","v":"Bitte überweisen Sie den Rechnungsbetrag 1.717,60 € bis zum 29.04.2026 an Name des Kontoinhabers, IBAN DE11111111111111111111, BIC BANK0BIC000."}]
[]
[{"$f":" IF(ISBLANK(InvoicePaymentTermsDescription),\"\",InvoicePaymentTermsDescription)","v":""}]
[]
[{"$f":" IF(ISBLANK(DirectDebitIBAN), \"\", \"Der Rechnungsbetrag in Höhe von \" & TEXT(J32, \"#.##0,00 €\") & \" wird am \" & TEXT(InvoiceDueDate,\"TT.MM.JJJJ\") & \" von Ihrem Konto per SEPA-Lastschrift eingezogen (Mandatsreferenz \" & DirectDebitMandate & \", Gläubiger-ID \" & DirectDebitCreditorReferenceID & \").\")","v":""}]
[]
["ZUGFeRD-Dokument mit eingebetteter digitaler Rechnung"]
["Weitere Vorlagen erhältlich auf digitale-vorlagen.de"]

{"sheet":"Rechnungsdaten","index":1,"n_rows":166,"n_cols":2,"rows_kept":166,"cut":false,"hidden":true,"merged":[]}
["Enthaltene Datenfelder (Nicht verändern!)"]
["InvoiceNumber","R12345"]
["InvoiceDate","2026-04-07"]
["InvoiceDueDate","2026-04-29"]
["InvoiceDeliveryDate","2026-01-01"]
["InvoiceDeliveryDate2","2026-03-31"]
["ProjectId"]
["ProjectName"]
["RecipientOrderId"]
["InvoiceFormatPDF",true]
[]
["SenderName","Name des Rechnungserstellers"]
["SenderBusinessName"]
["SenderStreet","Straße Hausnummer"]
["SenderStreet2"]
["SenderAdditional"]
["SenderZip","12345"]
["SenderLocation","Ort"]
["SenderCountry","Deutschland"]
["SenderVatId","DE200000000"]
["SenderTaxId"]
["SenderId"]
["SenderContactName"]
["SenderContactEmail"]
["SenderContactPhone"]
[]
["RecipientName","Name des Rechnungsempfängers"]
["RecipientBusinessName"]
["RecipientStreet","Straße Hausnummer"]
["RecipientStreet2"]
["RecipientAdditional"]
["RecipientZip","12345"]
["RecipientLocation","Ort"]
["RecipientCountry","Deutschland"]
["RecipientVatId","DE100000000"]
["RecipientTaxId"]
["RecipientId"]
["RecipientLeitwegId"]
["RecipientContactEmail"]
[]
["ItemName1","Beispielgegenstand"]
["ItemQuantity1",2]
["ItemUnit1","Stück (H87)"]
["ItemBasePrice1",800]
["ItemTaxRate1",19]
["ItemDiscount1",3]
["ItemDiscountReason1","Rabattgrund"]
["ItemName2"]
["ItemQuantity2"]
["ItemUnit2","Stück (H87)"]
["ItemBasePrice2"]
["ItemTaxRate2",19]
["ItemDiscount2"]
["ItemDiscountReason2"]
["ItemName3"]
["ItemQuantity3"]
["ItemUnit3","Stück (H87)"]
["ItemBasePrice3"]
["ItemTaxRate3",19]
["ItemDiscount3"]
["ItemDiscountReason3"]
["ItemName4"]
["ItemQuantity4"]
["ItemUnit4","Stück (H87)"]
["ItemBasePrice4"]
["ItemTaxRate4",19]
["ItemDiscount4"]
["ItemDiscountReason4"]
["ItemName5"]
["ItemQuantity5"]
["ItemUnit5","Stück (H87)"]
["ItemBasePrice5"]
["ItemTaxRate5",19]
["ItemDiscount5"]
["ItemDiscountReason5"]
["ItemName6"]
["ItemQuantity6"]
["ItemUnit6","Stück (H87)"]
["ItemBasePrice6"]
["ItemTaxRate6",19]
["ItemDiscount6"]
["ItemDiscountReason6"]
["ItemName7"]
["ItemQuantity7"]
["ItemUnit7","Stück (H87)"]
["ItemBasePrice7"]
["ItemTaxRate7",19]
["ItemDiscount7"]
["ItemDiscountReason7"]
["ItemName8"]
["ItemQuantity8"]
["ItemUnit8","Stück (H87)"]
["ItemBasePrice8"]
["ItemTaxRate8",19]
["ItemDiscount8"]
["ItemDiscountReason8"]
["ItemName9"]
["ItemQuantity9"]
["ItemUnit9","Stück (H87)"]
["ItemBasePrice9"]
["ItemTaxRate9",19]
["ItemDiscount9"]
["ItemDiscountReason9"]
["ItemName10"]
["ItemQuantity10"]
["ItemUnit10","Stück (H87)"]
["ItemBasePrice10"]
["ItemTaxRate10",19]
["ItemDiscount10"]
["ItemDiscountReason10"]
["ItemName11"]
["ItemQuantity11"]
["ItemUnit11","Stück (H87)"]
["ItemBasePrice11"]
["ItemTaxRate11",19]
["ItemDiscount11"]
["ItemDiscountReason11"]
["ItemName12"]
["ItemQuantity12"]
["ItemUnit12","Stück (H87)"]
["ItemBasePrice12"]
["ItemTaxRate12",19]
["ItemDiscount12"]
["ItemDiscountReason12"]
["ItemName13"]
["ItemQuantity13"]
["ItemUnit13","Stück (H87)"]
["ItemBasePrice13"]
["ItemTaxRate13",19]
["ItemDiscount13"]
["ItemDiscountReason13"]
["ItemName14"]
["ItemQuantity14"]
["ItemUnit14","Stück (H87)"]
["ItemBasePrice14"]
["ItemTaxRate14",19]
["ItemDiscount14"]
["ItemDiscountReason14"]
["ItemName15"]
["ItemQuantity15"]
["ItemUnit15","Stück (H87)"]
["ItemBasePrice15"]
["ItemTaxRate15",19]
["ItemDiscount15"]
["ItemDiscountReason15"]
[]
["ChargeReason","Aufschlaggrund"]
["ChargePercent",3]
["ChargeTaxRate",19]
[]
["DiscountReason","Rabattgrund"]
["DiscountPercent",10]
["DiscountTaxRate",19]
[]
["InvoicePaymentTermsDescriptionTemplate","Bei Bezahlung bis zum {Datum} erhalten Sie {Skonto} % Skonto."]
["InvoicePaymentTermsDescription",{"$f":" IF(ISBLANK(InvoicePaymentTermsDueDate),\"\",SUBSTITUTE(SUBSTITUTE(InvoicePaymentTermsDescriptionTemplate,\"{Datum}\",TEXT(InvoicePaymentTermsDueDate,\"TT.MM.JJJJ\")),\"{Skonto}\",InvoicePaymentTermsDiscountPercent))","v":""}]
["InvoicePaymentTermsDueDate"]
["InvoicePaymentTermsDiscountPercent"]
[]
["SenderBankAccountName","Name des Kontoinhabers"]
["SenderIBAN","DE11111111111111111111"]
["SenderBIC","BANK0BIC000"]
["DirectDebitIBAN"]
["DirectDebitMandate"]
["DirectDebitCreditorReferenceID"]
["PrepaidAmount"]

{"sheet":"Konfiguration","index":2,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Konfiguration"]
[]
["E-Rechnung Expert 2.16.0 Demo"]
[]
["Vordefinierte Mengeneinheiten:"]
["Arbeitsmonat (WM)"]
["Arbeitsstunde (LH)"]
["Arbeitstag (E49)"]
["Eins (C62)"]
["Kalenderjahr (ANN)"]
["Kalendertag (DAY)"]
["km (KMT)"]
["Stück (H87)"]
["Stunde (HUR)"]
[]
["Umsatzsteuersätze:"]
[7]
[19]