{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Übersicht","Einnahmen","Ausgaben","Kassenbuch","EÜR","Bericht","Anleitung"],"read":"whole","date_system":"1900"}

{"sheet":"Übersicht","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"merged":[[0,0,0,5],[2,1,2,3],[6,0,6,5]]}
["VEREINS-JAHRESABSCHLUSS 2026"]
[]
["Vereinsname:"]
["Geschäftsjahr:","01.01.2026 - 31.12.2026"]
["Erstellt am:",{"$f":"TODAY()","v":"2026-01-28"}]
[]
["ZUSAMMENFASSUNG JAHRESABSCHLUSS"]
[]
["Kategorie","Einnahmen","Ausgaben","Ergebnis"]
["1. Ideeller Bereich",{"$f":"Einnahmen!B28","v":{"v":0,"d":"0.00 €"}},{"$f":"Ausgaben!B28","v":{"v":0,"d":"0.00 €"}},{"$f":"B10-C10","v":{"v":0,"d":"0.00 €"}}]
["2. Vermögensverwaltung",{"$f":"Einnahmen!B29","v":{"v":0,"d":"0.00 €"}},{"$f":"Ausgaben!B29","v":{"v":0,"d":"0.00 €"}},{"$f":"B11-C11","v":{"v":0,"d":"0.00 €"}}]
["3. Zweckbetrieb",{"$f":"Einnahmen!B30","v":{"v":0,"d":"0.00 €"}},{"$f":"Ausgaben!B30","v":{"v":0,"d":"0.00 €"}},{"$f":"B12-C12","v":{"v":0,"d":"0.00 €"}}]
["4. Wirtschaftl. Geschäftsbetrieb",{"$f":"Einnahmen!B31","v":{"v":0,"d":"0.00 €"}},{"$f":"Ausgaben!B31","v":{"v":0,"d":"0.00 €"}},{"$f":"B13-C13","v":{"v":0,"d":"0.00 €"}}]
["GESAMT",{"$f":"SUM(B10:B13)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C10:C13)","v":{"v":0,"d":"0.00 €"}},{"$f":"B14-C14","v":{"v":0,"d":"0.00 €"}}]
[]
["Jahresergebnis:",{"$f":"D14","v":{"v":0,"d":"0.00 €"}}]
[]
["Ergebnis:",{"$f":"IF(D14>=0,\"Überschuss\",\"Fehlbetrag\")","v":"Überschuss"}]
[]
["VERMÖGENSÜBERSICHT"]
[]
["Position","Betrag"]
["Kassenbestand Anfang",{"v":0,"d":"0.00 €"}]
["Bankguthaben Anfang",{"v":0,"d":"0.00 €"}]
["Kassenbestand Ende",{"v":0,"d":"0.00 €"}]
["Bankguthaben Ende",{"v":0,"d":"0.00 €"}]
["Vermögensänderung",{"$f":"(B25+B26)-(B23+B24)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Einnahmen","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"merged":[[0,0,0,13],[3,0,3,13],[10,0,10,13],[16,0,16,13],[22,0,22,13]]}
["EINNAHMEN 2026"]
[]
["Einnahmeart","Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","GESAMT"]
["1. IDEELLER BEREICH"]
["Mitgliedsbeiträge",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B5:M5)","v":{"v":0,"d":"0.00 €"}}]
["Aufnahmegebühren",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B6:M6)","v":{"v":0,"d":"0.00 €"}}]
["Spenden",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B7:M7)","v":{"v":0,"d":"0.00 €"}}]
["Zuschüsse (öffentlich)",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B8:M8)","v":{"v":0,"d":"0.00 €"}}]
["Erbschaften/Schenkungen",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B9:M9)","v":{"v":0,"d":"0.00 €"}}]
["Summe Ideeller Bereich",{"$f":"SUM(B5:B9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C5:C9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D5:D9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E5:E9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F5:F9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G5:G9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H5:H9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I5:I9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J5:J9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K5:K9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L5:L9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M5:M9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N5:N9)","v":{"v":0,"d":"0.00 €"}}]
["2. VERMÖGENSVERWALTUNG"]
["Zinserträge",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B12:M12)","v":{"v":0,"d":"0.00 €"}}]
["Miet-/Pachteinnahmen",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B13:M13)","v":{"v":0,"d":"0.00 €"}}]
["Dividenden",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B14:M14)","v":{"v":0,"d":"0.00 €"}}]
["Kapitalerträge",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B15:M15)","v":{"v":0,"d":"0.00 €"}}]
["Summe Vermögensverwaltung",{"$f":"SUM(B12:B15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C12:C15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D12:D15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E12:E15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F12:F15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G12:G15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H12:H15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I12:I15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J12:J15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K12:K15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L12:L15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M12:M15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N12:N15)","v":{"v":0,"d":"0.00 €"}}]
["3. ZWECKBETRIEB"]
["Veranstaltungserlöse",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B18:M18)","v":{"v":0,"d":"0.00 €"}}]
["Kursgebühren",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B19:M19)","v":{"v":0,"d":"0.00 €"}}]
["Startgelder/Teilnahmegebühren",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B20:M20)","v":{"v":0,"d":"0.00 €"}}]
["Sportliche Veranstaltungen",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B21:M21)","v":{"v":0,"d":"0.00 €"}}]
["Summe Zweckbetrieb",{"$f":"SUM(B18:B21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C18:C21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D18:D21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E18:E21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F18:F21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G18:G21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H18:H21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I18:I21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J18:J21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K18:K21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L18:L21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M18:M21)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N18:N21)","v":{"v":0,"d":"0.00 €"}}]
["4. WIRTSCHAFTLICHER GESCHÄFTSBETRIEB"]
["Getränkeverkauf",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B24:M24)","v":{"v":0,"d":"0.00 €"}}]
["Essensverkauf",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B25:M25)","v":{"v":0,"d":"0.00 €"}}]
["Werbung/Sponsoring",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B26:M26)","v":{"v":0,"d":"0.00 €"}}]
["Merchandising",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B27:M27)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Ideeller Bereich",{"$f":"N10","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B28:M28)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Vermögensverwaltung",{"$f":"N16","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C24:C28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D24:D28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E24:E28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F24:F28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G24:G28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H24:H28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I24:I28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J24:J28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K24:K28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L24:L28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M24:M28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N24:N28)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Zweckbetrieb",{"$f":"N22","v":{"v":0,"d":"0.00 €"}}]
["Ref: Wirtschaftl. GB",{"$f":"N29","v":{"v":0,"d":"0.00 €"}},{"$f":"C10+C16+C22+C29","v":{"v":0,"d":"0.00 €"}},{"$f":"D10+D16+D22+D29","v":{"v":0,"d":"0.00 €"}},{"$f":"E10+E16+E22+E29","v":{"v":0,"d":"0.00 €"}},{"$f":"F10+F16+F22+F29","v":{"v":0,"d":"0.00 €"}},{"$f":"G10+G16+G22+G29","v":{"v":0,"d":"0.00 €"}},{"$f":"H10+H16+H22+H29","v":{"v":0,"d":"0.00 €"}},{"$f":"I10+I16+I22+I29","v":{"v":0,"d":"0.00 €"}},{"$f":"J10+J16+J22+J29","v":{"v":0,"d":"0.00 €"}},{"$f":"K10+K16+K22+K29","v":{"v":0,"d":"0.00 €"}},{"$f":"L10+L16+L22+L29","v":{"v":0,"d":"0.00 €"}},{"$f":"M10+M16+M22+M29","v":{"v":0,"d":"0.00 €"}},{"$f":"N10+N16+N22+N29","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Ausgaben","index":2,"n_rows":32,"n_cols":14,"rows_kept":32,"merged":[[0,0,0,13],[3,0,3,13],[10,0,10,13],[16,0,16,13],[23,0,23,13]]}
["AUSGABEN 2026"]
[]
["Ausgabenart","Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","GESAMT"]
["1. IDEELLER BEREICH"]
["Verwaltungskosten",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B5:M5)","v":{"v":0,"d":"0.00 €"}}]
["Porto/Telefon/Internet",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B6:M6)","v":{"v":0,"d":"0.00 €"}}]
["Büromaterial",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B7:M7)","v":{"v":0,"d":"0.00 €"}}]
["Mitgliederverwaltung",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B8:M8)","v":{"v":0,"d":"0.00 €"}}]
["Vereinsfeste (nicht wirtschaftl.)",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B9:M9)","v":{"v":0,"d":"0.00 €"}}]
["Summe Ideeller Bereich",{"$f":"SUM(B5:B9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C5:C9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D5:D9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E5:E9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F5:F9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G5:G9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H5:H9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I5:I9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J5:J9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K5:K9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L5:L9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M5:M9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N5:N9)","v":{"v":0,"d":"0.00 €"}}]
["2. VERMÖGENSVERWALTUNG"]
["Bankgebühren",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B12:M12)","v":{"v":0,"d":"0.00 €"}}]
["Depotgebühren",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B13:M13)","v":{"v":0,"d":"0.00 €"}}]
["Instandhaltung Vermögen",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B14:M14)","v":{"v":0,"d":"0.00 €"}}]
["Versicherungen (Vermögen)",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B15:M15)","v":{"v":0,"d":"0.00 €"}}]
["Summe Vermögensverwaltung",{"$f":"SUM(B12:B15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C12:C15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D12:D15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E12:E15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F12:F15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G12:G15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H12:H15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I12:I15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J12:J15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K12:K15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L12:L15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M12:M15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N12:N15)","v":{"v":0,"d":"0.00 €"}}]
["3. ZWECKBETRIEB"]
["Veranstaltungskosten",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B18:M18)","v":{"v":0,"d":"0.00 €"}}]
["Trainerhonorar",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B19:M19)","v":{"v":0,"d":"0.00 €"}}]
["Sportausrüstung",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B20:M20)","v":{"v":0,"d":"0.00 €"}}]
["Reisekosten",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B21:M21)","v":{"v":0,"d":"0.00 €"}}]
["Schiedsrichterkosten",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B22:M22)","v":{"v":0,"d":"0.00 €"}}]
["Summe Zweckbetrieb",{"$f":"SUM(B18:B22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C18:C22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D18:D22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E18:E22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F18:F22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G18:G22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H18:H22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I18:I22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J18:J22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K18:K22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L18:L22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M18:M22)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N18:N22)","v":{"v":0,"d":"0.00 €"}}]
["4. WIRTSCHAFTLICHER GESCHÄFTSBETRIEB"]
["Wareneinkauf Getränke",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B25:M25)","v":{"v":0,"d":"0.00 €"}}]
["Wareneinkauf Speisen",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B26:M26)","v":{"v":0,"d":"0.00 €"}}]
["Werbematerial",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B27:M27)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Ideeller Bereich",{"$f":"N10","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B28:M28)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Vermögensverwaltung",{"$f":"N16","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(B29:M29)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Zweckbetrieb",{"$f":"N23","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C25:C29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D25:D29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E25:E29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F25:F29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G25:G29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H25:H29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I25:I29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(J25:J29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(K25:K29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(L25:L29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M25:M29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N25:N29)","v":{"v":0,"d":"0.00 €"}}]
["Ref: Wirtschaftl. GB",{"$f":"N30","v":{"v":0,"d":"0.00 €"}}]
["GESAMTAUSGABEN",{"$f":"B10+B16+B23+B30","v":{"v":0,"d":"0.00 €"}},{"$f":"C10+C16+C23+C30","v":{"v":0,"d":"0.00 €"}},{"$f":"D10+D16+D23+D30","v":{"v":0,"d":"0.00 €"}},{"$f":"E10+E16+E23+E30","v":{"v":0,"d":"0.00 €"}},{"$f":"F10+F16+F23+F30","v":{"v":0,"d":"0.00 €"}},{"$f":"G10+G16+G23+G30","v":{"v":0,"d":"0.00 €"}},{"$f":"H10+H16+H23+H30","v":{"v":0,"d":"0.00 €"}},{"$f":"I10+I16+I23+I30","v":{"v":0,"d":"0.00 €"}},{"$f":"J10+J16+J23+J30","v":{"v":0,"d":"0.00 €"}},{"$f":"K10+K16+K23+K30","v":{"v":0,"d":"0.00 €"}},{"$f":"L10+L16+L23+L30","v":{"v":0,"d":"0.00 €"}},{"$f":"M10+M16+M23+M30","v":{"v":0,"d":"0.00 €"}},{"$f":"N10+N16+N23+N30","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Kassenbuch","index":3,"n_rows":107,"n_cols":7,"rows_kept":107,"merged":[[0,0,0,7]]}
["KASSENBUCH 2026"]
[]
["Anfangsbestand Kasse:",{"v":0,"d":"0.00 €"}]
[]
["Beleg-Nr.","Datum","Buchungstext","Kategorie","Einnahme","Ausgabe","Saldo"]
[{"$nulls":6},{"$f":"B3+E6-F6","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G6+E7-F7","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G7+E8-F8","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G8+E9-F9","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G9+E10-F10","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G10+E11-F11","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G11+E12-F12","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G12+E13-F13","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G13+E14-F14","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G14+E15-F15","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G15+E16-F16","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G16+E17-F17","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G17+E18-F18","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G18+E19-F19","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G19+E20-F20","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G20+E21-F21","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G21+E22-F22","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G22+E23-F23","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G23+E24-F24","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G24+E25-F25","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G25+E26-F26","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G26+E27-F27","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G27+E28-F28","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G28+E29-F29","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G29+E30-F30","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G30+E31-F31","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G31+E32-F32","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G32+E33-F33","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G33+E34-F34","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G34+E35-F35","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G35+E36-F36","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G36+E37-F37","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G37+E38-F38","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G38+E39-F39","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G39+E40-F40","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G40+E41-F41","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G41+E42-F42","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G42+E43-F43","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G43+E44-F44","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G44+E45-F45","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G45+E46-F46","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G46+E47-F47","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G47+E48-F48","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G48+E49-F49","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G49+E50-F50","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G50+E51-F51","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G51+E52-F52","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G52+E53-F53","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G53+E54-F54","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G54+E55-F55","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G55+E56-F56","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G56+E57-F57","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G57+E58-F58","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G58+E59-F59","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G59+E60-F60","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G60+E61-F61","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G61+E62-F62","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G62+E63-F63","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G63+E64-F64","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G64+E65-F65","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G65+E66-F66","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G66+E67-F67","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G67+E68-F68","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G68+E69-F69","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G69+E70-F70","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G70+E71-F71","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G71+E72-F72","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G72+E73-F73","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G73+E74-F74","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G74+E75-F75","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G75+E76-F76","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G76+E77-F77","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G77+E78-F78","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G78+E79-F79","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G79+E80-F80","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G80+E81-F81","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G81+E82-F82","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G82+E83-F83","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G83+E84-F84","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G84+E85-F85","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G85+E86-F86","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G86+E87-F87","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G87+E88-F88","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G88+E89-F89","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G89+E90-F90","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G90+E91-F91","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G91+E92-F92","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G92+E93-F93","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G93+E94-F94","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G94+E95-F95","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G95+E96-F96","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G96+E97-F97","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G97+E98-F98","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G98+E99-F99","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G99+E100-F100","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G100+E101-F101","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G101+E102-F102","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G102+E103-F103","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G103+E104-F104","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":6},{"$f":"G104+E105-F105","v":{"v":0,"d":"0.00 €"}}]
[]
["SUMMEN:",{"$nulls":3},{"$f":"SUM(E6:E106)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F6:F106)","v":{"v":0,"d":"0.00 €"}},{"$f":"G106","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"EÜR","index":4,"n_rows":25,"n_cols":3,"rows_kept":25,"merged":[[0,0,0,3],[2,1,2,3],[6,0,6,2],[14,0,14,2]]}
["EINNAHMEN-ÜBERSCHUSS-RECHNUNG (EÜR) 2026"]
[]
["Vereinsname:",{"$f":"Übersicht!B3","v":0}]
["Zeitraum:","01.01.2026 - 31.12.2026"]
[]
["Position","Betrag (€)","Anmerkungen"]
["EINNAHMEN"]
["Mitgliedsbeiträge",{"$f":"Einnahmen!N5","v":{"v":0,"d":"0.00 €"}}]
["Spenden",{"$f":"Einnahmen!N7","v":{"v":0,"d":"0.00 €"}}]
["Zuschüsse",{"$f":"Einnahmen!N8","v":{"v":0,"d":"0.00 €"}}]
["Zinserträge",{"$f":"Einnahmen!N12","v":{"v":0,"d":"0.00 €"}}]
["Veranstaltungserlöse",{"$f":"Einnahmen!N17+Einnahmen!N22","v":{"v":0,"d":"0.00 €"}}]
["Sonstige Einnahmen",{"$f":"Einnahmen!N26","v":{"v":0,"d":"0.00 €"}}]
["SUMME EINNAHMEN",{"$f":"SUM(B8:B13)","v":{"v":0,"d":"0.00 €"}}]
["AUSGABEN"]
["Verwaltungskosten",{"$f":"Ausgaben!N5","v":{"v":0,"d":"0.00 €"}}]
["Personalkosten",{"$f":"Ausgaben!N24","v":{"v":0,"d":"0.00 €"}}]
["Material/Ausstattung",{"$f":"Ausgaben!N19","v":{"v":0,"d":"0.00 €"}}]
["Versicherungen",{"$f":"Ausgaben!N15","v":{"v":0,"d":"0.00 €"}}]
["Bankgebühren",{"$f":"Ausgaben!N12","v":{"v":0,"d":"0.00 €"}}]
["Veranstaltungskosten",{"$f":"Ausgaben!N17","v":{"v":0,"d":"0.00 €"}}]
["Sonstige Ausgaben",{"$f":"Ausgaben!N25","v":{"v":0,"d":"0.00 €"}}]
["SUMME AUSGABEN",{"$f":"SUM(B16:B22)","v":{"v":0,"d":"0.00 €"}}]
[]
["JAHRESERGEBNIS (Überschuss/Fehlbetrag)",{"$f":"B14-B23","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Bericht","index":5,"n_rows":31,"n_cols":4,"rows_kept":31,"merged":[[0,0,0,3],[2,1,2,3],[6,0,6,3]]}
["JAHRESABSCHLUSSBERICHT"]
[]
["Vereinsname:",{"$f":"Übersicht!B3","v":0}]
["Geschäftsjahr:","2026"]
["Erstellt am:",{"$f":"TODAY()","v":"2026-01-28"}]
[]
["FINANZERGEBNIS"]
[]
["Bereich","Einnahmen","Ausgaben","Ergebnis"]
["Ideeller Bereich",{"$f":"Übersicht!B10","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!C10","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!D10","v":{"v":0,"d":"0.00 €"}}]
["Vermögensverwaltung",{"$f":"Übersicht!B11","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!C11","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!D11","v":{"v":0,"d":"0.00 €"}}]
["Zweckbetrieb",{"$f":"Übersicht!B12","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!C12","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!D12","v":{"v":0,"d":"0.00 €"}}]
["Wirtschaftl. Geschäftsbetrieb",{"$f":"Übersicht!B13","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!C13","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!D13","v":{"v":0,"d":"0.00 €"}}]
["GESAMT",{"$f":"Übersicht!B14","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!C14","v":{"v":0,"d":"0.00 €"}},{"$f":"Übersicht!D14","v":{"v":0,"d":"0.00 €"}}]
[]
["VERMÖGENSSTAND"]
[]
["Position","Betrag"]
["Anfangsbestand (01.01.)",{"$f":"Übersicht!B23+Übersicht!B24","v":{"v":0,"d":"0.00 €"}}]
["Endbestand (31.12.)",{"$f":"Übersicht!B25+Übersicht!B26","v":{"v":0,"d":"0.00 €"}}]
["Vermögensänderung",{"$f":"B20-B19","v":{"v":0,"d":"0.00 €"}}]
[]
["UNTERSCHRIFTEN"]
[]
["________________________",null,"________________________"]
["Kassenwart/in",null,"1. Vorsitzende/r"]
[]
["________________________",null,"________________________"]
["Kassenprüfer/in 1",null,"Kassenprüfer/in 2"]
[]
["Datum: ________________"]

{"sheet":"Anleitung","index":6,"n_rows":42,"n_cols":2,"rows_kept":42,"merged":[[0,0,0,4]]}
["ANLEITUNG ZUR NUTZUNG DER JAHRESABSCHLUSS-VORLAGE"]
[]
[]
["ÜBERSICHT DER ARBEITSBLÄTTER"]
[]
["1. Übersicht","Dashboard mit Gesamtübersicht und Vermögensstand"]
["2. Einnahmen","Monatliche Erfassung aller Einnahmen nach Kategorien"]
["3. Ausgaben","Monatliche Erfassung aller Ausgaben nach Kategorien"]
["4. Kassenbuch","Detaillierte Erfassung einzelner Transaktionen"]
["5. EÜR","Automatische Einnahmen-Überschuss-Rechnung"]
["6. Bericht","Druckfertiger Bericht für Mitgliederversammlung"]
[]
["SCHRITT-FÜR-SCHRITT ANLEITUNG"]
[]
["Schritt 1: Vereinsdaten eintragen","Auf dem Blatt 'Übersicht' den Vereinsnamen eingeben"]
["Schritt 2: Vermögensstand erfassen","Anfangs- und Endbestände von Kasse und Bank eintragen"]
["Schritt 3: Einnahmen buchen","Monatliche Einnahmen im Blatt 'Einnahmen' erfassen"]
["Schritt 4: Ausgaben buchen","Monatliche Ausgaben im Blatt 'Ausgaben' erfassen"]
["Schritt 5: Kassenbuch führen","Einzelne Transaktionen mit Belegnummer dokumentieren"]
["Schritt 6: Berechnungen prüfen","Die automatischen Berechnungen auf Plausibilität prüfen"]
["Schritt 7: Bericht drucken","Das Blatt 'Bericht' für die Mitgliederversammlung ausdrucken"]
[]
["FARBCODIERUNG"]
[]
["Gelb hinterlegt","Eingabefelder - hier Ihre Daten eintragen"]
["Blau hinterlegt","Summen und Ergebnisse (automatisch berechnet)"]
["Dunkelblau","Überschriften und Gesamtsummen"]
[]
["DIE VIER STEUERLICHEN BEREICHE"]
[]
["1. Ideeller Bereich","Mitgliedsbeiträge, Spenden, Zuschüsse - steuerfrei"]
["2. Vermögensverwaltung","Zinsen, Mieten, Kapitalerträge - eingeschränkt steuerpflichtig"]
["3. Zweckbetrieb","Veranstaltungen zur Satzungszweckerfüllung - begünstigt"]
["4. Wirtschaftl. Geschäftsbetrieb","Getränkeverkauf, Werbung - steuerpflichtig"]
[]
["WICHTIGE HINWEISE"]
[]
["• Aufbewahrungspflicht:","Belege 6-10 Jahre aufbewahren (§ 147 AO)"]
["• Buchführungspflicht:","Chronologisch, lückenlos, verständlich"]
["• Bilanzierungsgrenze:","Ab 600.000 € Umsatz oder 60.000 € Gewinn"]
["• Regelmäßig buchen:","Mindestens monatlich alle Transaktionen erfassen"]
["• Belege kopieren:","Thermopapier verblasst - Kopien anfertigen!"]