{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Stornorechnung"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":1,"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":"Stornorechnung","index":0,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,0,29,3],[30,0,30,3],[7,0,7,2],[11,1,11,2],[5,6,5,8],[13,6,13,8],[9,1,9,2],[6,1,6,2],[10,1,10,2],[12,1,12,2],[4,6,4,8],[3,6,3,8],[3,0,3,2],[5,0,5,2],[12,6,12,8],[4,0,4,2],[39,6,39,8],[6,7,6,8],[34,5,34,7],[9,6,9,8],[7,6,7,8],[31,5,31,7],[32,5,32,7],[33,5,33,7],[38,6,38,8],[14,6,14,8],[10,6,10,8]]}
[]
[]
[]
["Name des Rechnungsempfängers",null,null,null,null,null,"Name des Rechnungserstellers"]
["Straße Hsnr.",null,null,null,null,null,"Straße Hsnr."]
["Adresszeile 2",null,null,null,null,null,"Adresszeile 2"]
[12345,"Ort",null,null,null,null,12345,"Ort"]
["Deutschland",null,null,null,null,null,"Deutschland"]
[]
["Ust-IdNr.:","DE1000000000",null,null,null,null,"DE200000000"]
["Kundennr.:","K12345",null,null,null,null,"Lieferantennummer"]
["Leitweg-ID:","991-1234512345-06"]
["E-Mail:","empfänger@example.com",null,null,null,null,"Name der Kontaktperson"]
[null,null,null,null,null,null,"kontakt@example.com"]
[null,null,null,null,null,null,"+49 123 456789"]
[]
["Stornorechnung"]
[]
[]
["Rechnungsnummer:",null,"R12346"]
["Rechnungsdatum:",null,"2026-04-20"]
[]
["Angaben zur zu stornierenden Rechnung:"]
["Urspr. Rechnungsnummer:",null,"R12345"]
["Urspr. Rechnungsdatum:",null,"2026-04-15"]
["Leistungsdatum/-zeitraum:",null,"2026-01-01",{"$f":"IF(ISBLANK(InvoiceDeliveryDate2),\"\",\"bis\")","v":"bis"},"2026-03-31"]
[]
[{"$f":"\"Hiermit wird die Rechnung \" & OriginalInvoiceNumber & \" vom \" & TEXT(OriginalInvoiceDate,\"TT.MM.JJJJ\") & \" mit folgenden Positionen storniert.\"","v":"Hiermit wird die Rechnung R12345 vom 15.04.2026 mit folgenden Positionen storniert."}]
[]
["Gegenstand/Leistung",null,null,null,"Menge","Einheit","Einzelpreis netto","Steuer-\nsatz","Gesamtpreis netto"]
["Beispielgegenstand",null,null,null,-1,"Stück (H87)",800,7.0000000000000007E-2,{"$f":"IF(G31>0,ROUND(E31*G31,2),\"\")","v":-800}]
[null,null,null,null,null,"Summe netto",null,null,{"$f":"SUM(I31:I31)","v":-800}]
[null,null,null,null,null,"zuzüglich 7 % Umsatzsteuer",null,null,{"$f":"SUMIF(ItemTaxRate,\"7%\",I31:I31)*0.07","v":-56.000000000000007}]
[null,null,null,null,null,"zuzüglich 19 % Umsatzsteuer",null,null,{"$f":"SUMIF(ItemTaxRate,\"19%\",I31:I31)*0.19","v":0}]
[null,null,null,null,null,"Rechnungsbetrag brutto",null,null,{"$f":"SUM(I32:I34)","v":-856}]
[]
[]
[null,null,null,null,null,null,"Bankverbindung:"]
["ZUGFeRD-Dokument mit eingebetteter digitaler Rechnung",null,null,null,null,null,"DE11111111111111111111"]
["Weitere Vorlagen erhältlich auf digitale-vorlagen.de",null,null,null,null,null,"BANK0BIC000"]
[]
[]
["E-Stornorechnung 2.13.4 Demo"]
[]
["Vordefinierte Mengeneinheiten:"]
["Arbeitsmonat (WM)"]
["Arbeitsstunde (LH)"]
["Arbeitstag (E49)"]
["Eins (C62)"]
["Kalenderjahr (ANN)"]
["Kalendertag (DAY)"]
["km (KMT)"]
["Stück (H87)"]
["Stunde (HUR)"]