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

{"sheet":"Buchungen","index":0,"n_rows":500,"n_cols":9,"rows_kept":500,"merged":[[0,0,0,6]]}
["Einnahmen & Ausgaben – Buchungen"]
["Jahr",2026,null,"Währung","EUR (€)"]
[]
[]
["Datum","Kategorie","Beschreibung","Einnahme (€)","Ausgabe (€)","Monat","Jahr",null,"Kategorien"]
["2026-01-03","Gehalt","Gehalt Januar",{"v":2800,"d":"€ 2,800.00"},{"v":0,"d":"€ 0.00"},{"$f":"IF(A6=\"\",\"\",TEXT(A6,\"yyyy-mm\"))","v":"yyyy-01"},{"$f":"IF(A6=\"\",\"\",YEAR(A6))","v":2026},null,"Gehalt"]
["2026-01-05","Miete","Wohnungsmiete",{"v":0,"d":"€ 0.00"},{"v":950,"d":"€ 950.00"},"yyyy-01",2026,null,"Verkauf"]
["2026-01-09","Strom","Stromabschlag",{"v":0,"d":"€ 0.00"},{"v":75,"d":"€ 75.00"},"yyyy-01",2026,null,"Honorar"]
["2026-01-15","Internet/Telefon","Internet",{"v":0,"d":"€ 0.00"},{"v":45,"d":"€ 45.00"},"yyyy-01",2026,null,"Erstattung"]
["2026-01-20","Reisekosten","Bahnfahrt",{"v":0,"d":"€ 0.00"},{"v":39.9,"d":"€ 39.90"},"yyyy-01",2026,null,"Zinsen"]
["2026-02-03","Gehalt","Gehalt Februar",{"v":2800,"d":"€ 2,800.00"},{"v":0,"d":"€ 0.00"},"yyyy-02",2026,null,"Sonstiges Einkommen"]
["2026-02-05","Miete","Wohnungsmiete",{"v":0,"d":"€ 0.00"},{"v":950,"d":"€ 950.00"},"yyyy-02",2026,null,"Miete"]
["2026-02-11","Software","Abo",{"v":0,"d":"€ 0.00"},{"v":15,"d":"€ 15.00"},"yyyy-02",2026,null,"Strom"]
["2026-02-18","Marketing","Ads Test",{"v":0,"d":"€ 0.00"},{"v":60,"d":"€ 60.00"},"yyyy-02",2026,null,"Internet/Telefon"]
["2026-02-25","Erstattung","Reisekosten Erstattung",{"v":45,"d":"€ 45.00"},{"v":0,"d":"€ 0.00"},"yyyy-02",2026,null,"Software"]
["2026-03-03","Gehalt","Gehalt März",{"v":2800,"d":"€ 2,800.00"},{"v":0,"d":"€ 0.00"},"yyyy-03",2026,null,"Bürobedarf"]
["2026-03-05","Miete","Wohnungsmiete",{"v":0,"d":"€ 0.00"},{"v":950,"d":"€ 950.00"},"yyyy-03",2026,null,"Marketing"]
["2026-03-08","Bürobedarf","Notizbuch & Stifte",{"v":0,"d":"€ 0.00"},{"v":18.5,"d":"€ 18.50"},"yyyy-03",2026,null,"Reisekosten"]
["2026-03-12","Honorar","Freelance Projekt",{"v":450,"d":"€ 450.00"},{"v":0,"d":"€ 0.00"},"yyyy-03",2026,null,"Versicherungen"]
["2026-03-22","Versicherungen","Haftpflicht",{"v":0,"d":"€ 0.00"},{"v":12.9,"d":"€ 12.90"},"yyyy-03",2026,null,"Steuern"]
["2026-04-03","Gehalt","Gehalt April",{"v":2800,"d":"€ 2,800.00"},{"v":0,"d":"€ 0.00"},"yyyy-04",2026,null,"Bewirtung"]
["2026-04-05","Miete","Wohnungsmiete",{"v":0,"d":"€ 0.00"},{"v":950,"d":"€ 950.00"},"yyyy-04",2026,null,"Gebühren"]
["2026-04-10","Reisekosten","Hotel",{"v":0,"d":"€ 0.00"},{"v":120,"d":"€ 120.00"},"yyyy-04",2026,null,"Wartung"]
["2026-04-18","Verkauf","Kleinanzeigen",{"v":80,"d":"€ 80.00"},{"v":0,"d":"€ 0.00"},"yyyy-04",2026,null,"Sonstiges"]
["2026-04-27","Steuern","Vorauszahlung",{"v":0,"d":"€ 0.00"},{"v":150,"d":"€ 150.00"},"yyyy-04",2026]
["2026-05-03","Gehalt","Gehalt Mai",{"v":2800,"d":"€ 2,800.00"},{"v":0,"d":"€ 0.00"},"yyyy-05",2026]
["2026-05-05","Miete","Wohnungsmiete",{"v":0,"d":"€ 0.00"},{"v":950,"d":"€ 950.00"},"yyyy-05",2026]
["2026-05-14","Gebühren","Bankgebühr",{"v":0,"d":"€ 0.00"},{"v":6.5,"d":"€ 6.50"},"yyyy-05",2026]
["2026-05-21","Bewirtung","Kundentermin",{"v":0,"d":"€ 0.00"},{"v":34.2,"d":"€ 34.20"},"yyyy-05",2026]
["2026-05-29","Zinsen","Zinsen",{"v":2.35,"d":"€ 2.35"},{"v":0,"d":"€ 0.00"},"yyyy-05",2026]
["2026-06-03","Gehalt","Gehalt Juni",{"v":2800,"d":"€ 2,800.00"},{"v":0,"d":"€ 0.00"},"yyyy-06",2026]
["2026-06-05","Miete","Wohnungsmiete",{"v":0,"d":"€ 0.00"},{"v":950,"d":"€ 950.00"},"yyyy-06",2026]
["2026-06-09","Wartung","Fahrrad Service",{"v":0,"d":"€ 0.00"},{"v":45,"d":"€ 45.00"},"yyyy-06",2026]
["2026-06-16","Sonstiges Einkommen","Bonus",{"v":120,"d":"€ 120.00"},{"v":0,"d":"€ 0.00"},"yyyy-06",2026]
["2026-06-25","Marketing","Tool",{"v":0,"d":"€ 0.00"},{"v":25,"d":"€ 25.00"},"yyyy-06",2026]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A70=\"\",\"\",TEXT(A70,\"yyyy-mm\"))","v":""},{"$f":"IF(A70=\"\",\"\",YEAR(A70))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A134=\"\",\"\",TEXT(A134,\"yyyy-mm\"))","v":""},{"$f":"IF(A134=\"\",\"\",YEAR(A134))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A198=\"\",\"\",TEXT(A198,\"yyyy-mm\"))","v":""},{"$f":"IF(A198=\"\",\"\",YEAR(A198))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A262=\"\",\"\",TEXT(A262,\"yyyy-mm\"))","v":""},{"$f":"IF(A262=\"\",\"\",YEAR(A262))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A326=\"\",\"\",TEXT(A326,\"yyyy-mm\"))","v":""},{"$f":"IF(A326=\"\",\"\",YEAR(A326))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A390=\"\",\"\",TEXT(A390,\"yyyy-mm\"))","v":""},{"$f":"IF(A390=\"\",\"\",YEAR(A390))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},{"$f":"IF(A454=\"\",\"\",TEXT(A454,\"yyyy-mm\"))","v":""},{"$f":"IF(A454=\"\",\"\",YEAR(A454))","v":""}]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]
[{"$nulls":5},"",""]

{"sheet":"Übersicht","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"merged":[[0,0,0,7],[1,2,1,3],[1,4,1,5],[1,6,1,7],[2,2,2,3],[2,4,2,5],[2,6,2,7],[33,0,33,4]]}
["Übersicht – Jahr"]
["Jahr auswählen",{"$f":"Buchungen!B2","v":2026},"Gesamteinnahmen",null,"Gesamtausgaben",null,"Saldo"]
[null,null,{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&DATE($B$2,1,1),Buchungen!$A$6:$A$500,\"<\"&DATE($B$2+1,1,1))","v":{"v":17497.35,"d":"€ 17,497.35"}},null,{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&DATE($B$2,1,1),Buchungen!$A$6:$A$500,\"<\"&DATE($B$2+1,1,1))","v":{"v":6347,"d":"€ 6,347.00"}},null,{"$f":"C3-E3","v":{"v":11150.349999999999,"d":"€ 11,150.35"}}]
[]
[]
["Monat","Einnahmen (€)","Ausgaben (€)","Saldo (€)","Kumuliert (€)"]
["Jan",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F7,Buchungen!$A$6:$A$500,\"<\"&$G7)","v":{"v":2800,"d":"€ 2,800.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F7,Buchungen!$A$6:$A$500,\"<\"&$G7)","v":{"v":1109.9,"d":"€ 1,109.90"}},{"$f":"B7-C7","v":{"v":1690.1,"d":"€ 1,690.10"}},{"$f":"D7","v":{"v":1690.1,"d":"€ 1,690.10"}},{"$f":"DATE($B$2,1,1)","v":"2026-01-01"},{"$f":"EDATE(F7,1)","v":"2026-02-01"}]
["Feb",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F8,Buchungen!$A$6:$A$500,\"<\"&$G8)","v":{"v":2845,"d":"€ 2,845.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F8,Buchungen!$A$6:$A$500,\"<\"&$G8)","v":{"v":1025,"d":"€ 1,025.00"}},{"v":1820,"d":"€ 1,820.00"},{"$f":"E7+D8","v":{"v":3510.1,"d":"€ 3,510.10"}},{"$f":"DATE($B$2,2,1)","v":"2026-02-01"},"2026-03-01"]
["Mär",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F9,Buchungen!$A$6:$A$500,\"<\"&$G9)","v":{"v":3250,"d":"€ 3,250.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F9,Buchungen!$A$6:$A$500,\"<\"&$G9)","v":{"v":981.4,"d":"€ 981.40"}},{"v":2268.6,"d":"€ 2,268.60"},{"v":5778.7,"d":"€ 5,778.70"},{"$f":"DATE($B$2,3,1)","v":"2026-03-01"},"2026-04-01"]
["Apr",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F10,Buchungen!$A$6:$A$500,\"<\"&$G10)","v":{"v":2880,"d":"€ 2,880.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F10,Buchungen!$A$6:$A$500,\"<\"&$G10)","v":{"v":1220,"d":"€ 1,220.00"}},{"v":1660,"d":"€ 1,660.00"},{"v":7438.7,"d":"€ 7,438.70"},{"$f":"DATE($B$2,4,1)","v":"2026-04-01"},"2026-05-01"]
["Mai",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F11,Buchungen!$A$6:$A$500,\"<\"&$G11)","v":{"v":2802.35,"d":"€ 2,802.35"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F11,Buchungen!$A$6:$A$500,\"<\"&$G11)","v":{"v":990.7,"d":"€ 990.70"}},{"v":1811.6499999999999,"d":"€ 1,811.65"},{"v":9250.35,"d":"€ 9,250.35"},{"$f":"DATE($B$2,5,1)","v":"2026-05-01"},"2026-06-01"]
["Jun",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F12,Buchungen!$A$6:$A$500,\"<\"&$G12)","v":{"v":2920,"d":"€ 2,920.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F12,Buchungen!$A$6:$A$500,\"<\"&$G12)","v":{"v":1020,"d":"€ 1,020.00"}},{"v":1900,"d":"€ 1,900.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,6,1)","v":"2026-06-01"},"2026-07-01"]
["Jul",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F13,Buchungen!$A$6:$A$500,\"<\"&$G13)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F13,Buchungen!$A$6:$A$500,\"<\"&$G13)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,7,1)","v":"2026-07-01"},"2026-08-01"]
["Aug",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F14,Buchungen!$A$6:$A$500,\"<\"&$G14)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F14,Buchungen!$A$6:$A$500,\"<\"&$G14)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,8,1)","v":"2026-08-01"},"2026-09-01"]
["Sep",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F15,Buchungen!$A$6:$A$500,\"<\"&$G15)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F15,Buchungen!$A$6:$A$500,\"<\"&$G15)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,9,1)","v":"2026-09-01"},"2026-10-01"]
["Okt",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F16,Buchungen!$A$6:$A$500,\"<\"&$G16)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F16,Buchungen!$A$6:$A$500,\"<\"&$G16)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,10,1)","v":"2026-10-01"},"2026-11-01"]
["Nov",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F17,Buchungen!$A$6:$A$500,\"<\"&$G17)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F17,Buchungen!$A$6:$A$500,\"<\"&$G17)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,11,1)","v":"2026-11-01"},"2026-12-01"]
["Dez",{"$f":"SUMIFS(Buchungen!$D$6:$D$500,Buchungen!$A$6:$A$500,\">=\"&$F18,Buchungen!$A$6:$A$500,\"<\"&$G18)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUMIFS(Buchungen!$E$6:$E$500,Buchungen!$A$6:$A$500,\">=\"&$F18,Buchungen!$A$6:$A$500,\"<\"&$G18)","v":{"v":0,"d":"€ 0.00"}},{"v":0,"d":"€ 0.00"},{"v":11150.35,"d":"€ 11,150.35"},{"$f":"DATE($B$2,12,1)","v":"2026-12-01"},"2027-01-01"]
{"$rows_empty":15}
["Hinweis: In 'Buchungen' eintragen – die Übersicht aktualisiert sich automatisch."]