{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kontoauszug"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Kontoauszug","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"merged":[[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[43,0,45,2]]}
["Musterfirma GmbH"]
["Musterstraße 12",null,null,"Auszugsdatum",{"$f":"TODAY()","v":"2026-02-10"}]
["26121 Oldenburg",null,null,"Fälligkeitsdatum",{"$f":"E2+14","v":"2026-02-24"}]
["+49 441 123456"]
[]
["Kontoauszug"]
["Max Mustermann"]
["Kundenweg 5"]
["10115 Berlin"]
["Datum","Beschreibung","Abbuchungen","Einzahlungen","Kontostand"]
[]
[null,"Übertrag",null,"Anfangssaldo",{"v":1250,"d":"€ 1,250.00"}]
["2026-01-05","Gehalt Januar",null,{"v":2500,"d":"€ 2,500.00"},{"$f":"IF(COUNTA(C13:D13)=0,\"\",$E$12 + IF(D13=\"\",0,D13) - IF(C13=\"\",0,C13))","v":{"v":3750,"d":"€ 3,750.00"}}]
["2026-01-06","Miete",{"v":980,"d":"€ 980.00"},null,{"$f":"IF(COUNTA(C14:D14)=0,\"\",E13 + IF(D14=\"\",0,D14) - IF(C14=\"\",0,C14))","v":{"v":2770,"d":"€ 2,770.00"}}]
["2026-01-07","Strom",{"v":85.5,"d":"€ 85.50"},null,{"v":2684.5,"d":"€ 2,684.50"}]
["2026-01-08","Supermarkt",{"v":123.4,"d":"€ 123.40"},null,{"v":2561.1,"d":"€ 2,561.10"}]
["2026-01-10","Rückerstattung",null,{"v":45,"d":"€ 45.00"},{"v":2606.1,"d":"€ 2,606.10"}]
["2026-01-12","Internet",{"v":39.99,"d":"€ 39.99"},null,{"v":2566.11,"d":"€ 2,566.11"}]
["2026-01-15","Kreditrate",{"v":250,"d":"€ 250.00"},null,{"v":2316.11,"d":"€ 2,316.11"}]
["2026-01-18","Barabhebung",{"v":100,"d":"€ 100.00"},null,{"v":2216.11,"d":"€ 2,216.11"}]
["2026-01-20","Freelance Zahlung",null,{"v":600,"d":"€ 600.00"},{"v":2816.11,"d":"€ 2,816.11"}]
["2026-01-25","Versicherung",{"v":75,"d":"€ 75.00"},null,{"v":2741.11,"d":"€ 2,741.11"}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[]
["Hinweis / Nachricht an den Kunden:\nBitte überweisen Sie den offenen Betrag bis zum Fälligkeitsdatum.",null,null,"Endsaldo",{"$f":"IF(COUNTA(C42:D42)>0,E42,IF(COUNTA(C41:D41)>0,E41,IF(COUNTA(C40:D40)>0,E40,IF(COUNTA(C39:D39)>0,E39,IF(COUNTA(C38:D38)>0,E38,IF(COUNTA(C37:D37)>0,E37,IF(COUNTA(C36:D36)>0,E36,IF(COUNTA(C35:D35)>0,E35,IF(COUNTA(C34:D34)>0,E34,IF(COUNTA(C33:D33)>0,E33,IF(COUNTA(C32:D32)>0,E32,IF(COUNTA(C31:D31)>0,E31,IF(COUNTA(C30:D30)>0,E30,IF(COUNTA(C29:D29)>0,E29,IF(COUNTA(C28:D28)>0,E28,IF(COUNTA(C27:D27)>0,E27,IF(COUNTA(C26:D26)>0,E26,IF(COUNTA(C25:D25)>0,E25,IF(COUNTA(C24:D24)>0,E24,IF(COUNTA(C23:D23)>0,E23,IF(COUNTA(C22:D22)>0,E22,IF(COUNTA(C21:D21)>0,E21,IF(COUNTA(C20:D20)>0,E20,IF(COUNTA(C19:D19)>0,E19,IF(COUNTA(C18:D18)>0,E18,IF(COUNTA(C17:D17)>0,E17,IF(COUNTA(C16:D16)>0,E16,IF(COUNTA(C15:D15)>0,E15,IF(COUNTA(C14:D14)>0,E14,IF(COUNTA(C13:D13)>0,E13,$E$12))))))))))))))))))))))))))))))","v":{"v":2741.11,"d":"€ 2,741.11"}}]
[{"$nulls":3},"Offener Betrag",{"$f":"IF($E$44<0,ABS($E$44),\"\")","v":""}]
[{"$nulls":3},"Guthaben",{"$f":"IF($E$44>0,$E$44,\"\")","v":{"v":2741.11,"d":"€ 2,741.11"}}]