{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Stammdaten","Textvorlagen","Kostenstellen","Zählprotokoll","Druckeinstellungen","Positionen","ASCII_Import","Eintragungen","Kommentare","Template","01.2024","02.2024","03.2024","04.2024","05.2024","06.2024","07.2024","08.2024","09.2024","10.2024","11.2024","12.2024","Blatt_13"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":187,"comments":14,"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":"Stammdaten","index":0,"n_rows":30,"n_cols":32,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,1,25],[17,16,17,22],[19,16,19,22],[21,16,21,22],[23,16,23,22],[9,16,9,22],[11,16,11,22],[13,16,13,22],[15,16,15,22],[7,16,7,39],[0,31,2,41]]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ToolInfo","v":"Kassen- und Warenerfassung f. Office\nCopyright © DATEV eG, 2001 - 2017\nV.3.11, Stand 21.08.2017"}]
[]
[]
[]
[]
[null,"Ihre aktuellen Einstellungen:"]
[]
[null,null,"Stammdaten",null,null,null,null,null,"Mandantenname:",null,null,null,null,null,null,null,{"$f":"IF(MName<>\"\",MName,\"\")","v":"Kassenvorerfassung 2022"}]
[]
[null,null,null,null,null,null,null,null,"Wirtschaftsjahresbeginn:",null,null,null,null,null,null,null,{"$f":"IF(WJBeginn<>\"\",WJBeginn,\"\")","v":"2024-01-01"}]
[]
[null,null,null,null,null,null,null,null,"Wirtschaftsjahresende:",null,null,null,null,null,null,null,{"$f":"IF(WJEnde<>\"\",WJEnde,\"\")","v":"2024-12-31"}]
[]
[null,null,null,null,null,null,null,null,"Kontonummer:",null,null,null,null,null,null,null,{"$f":"IF(KtoNummer<>\"\",KtoNummer,\"\")","v":1000}]
[]
[null,null,null,null,null,null,null,null,"Anfangssaldo:",null,null,null,null,null,null,null,{"$f":"IF(KtoSaldoStart<>\"\",KtoSaldoStart,\"\")","v":0},null,null,null,null,null,null,{"$f":"EingabeWährung","v":"EUR"}]
[]
[null,null,"Zusatzdaten",null,null,null,null,null,"Beraternummer:",null,null,null,null,null,null,null,{"$f":"IF(BNR<>\"\",BNR,\"\")","v":18359}]
[]
[null,null,null,null,null,null,null,null,"Mandantennummer:",null,null,null,null,null,null,null,{"$f":"IF(MNR<>\"\",MNR,\"\")","v":0}]
[]
[null,null,null,null,null,null,null,null,"Sachkontenlänge:",null,null,null,null,null,null,null,{"$f":"IF(KtoLänge<>0,KtoLänge,\"\")","v":4}]
[]
[null,null,null,null,null,null,null,null,"Verrechnungskonto:",null,null,null,null,null,null,null,{"$f":"IF(AND(KtoVerrechnung<>\"\",KtoVerrechnung<>0),KtoVerrechnung,\"\")","v":""}]
[]
[]
[null,null,{"$f":"IF(D27=\"\",\"\",\"•\")","v":""}]
[null,null,{"$f":"IF(D28=\"\",\"\",\"•\")","v":""}]
[null,null,{"$f":"IF(D29=\"\",\"\",\"•\")","v":""}]
[null,null,{"$f":"IF(D30=\"\",\"\",\"•\")","v":""}]

{"sheet":"Textvorlagen","index":1,"n_rows":4,"n_cols":32,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sortorder:",null,1,1,1,1]
[]
[null,"Textvorschläge für Spalte (erreichbar über das Kontextmenü der entsprechenden Spalte):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Gegenkonto","Text","Kost1","Kost2"]

{"sheet":"Kostenstellen","index":2,"n_rows":4,"n_cols":30,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sortorder:",null,1,1]
[]
[null,"Vorlagen für Kostenstellen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Kostenstelle","Bezeichnung"]

{"sheet":"Zählprotokoll","index":3,"n_rows":425,"n_cols":47,"rows_kept":425,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,"Kassenzählprotokoll zur Ergänzung eines Tages- oder Kassenberichts"]
[null,"Datum",0.01,0.02,0.05,0.1,0.2,0.5,1,2,5,10,20,50,100,200,500,"Summe","Name","Abweichung zum erfassten Betrag"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kassenzählprotokoll vom"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wert","Anzahl","Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,{"$f":"IF(Druckbereich_Einzeltag_Datum=\"\",\"\",IF(ISNA(MATCH(Druckbereich_Einzeltag_Datum,$B:$B,0)),0,INDIRECT(ADDRESS(MATCH(Druckbereich_Einzeltag_Datum,$B:$B,0),ROW()-ROW(Druckbereich_Einzeltag_Datum)))))","v":""},{"$f":"IF(Druckbereich_Einzeltag_Datum=\"\",\"\",AB404*AC404)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kassenbestand gesamt",{"$f":"IF(Druckbereich_Einzeltag_Datum=\"\",\"\",SUM(AD404:AD418))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(MATCH($AD$401,$B:$B)),\"\",INDIRECT(ADDRESS(MATCH($AD$401,$B:$B),COLUMN(ZP_Name))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name (in Druckbuchstaben)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum","Stempel/Unterschrift"]

{"sheet":"Druckeinstellungen","index":4,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,1,4,2],[13,1,13,2]]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"}]
[]
[]
[]
[null,"Kopf- und Fußzeilen für Erfassungsseiten"]
[null,"Position","Inhalt"]
[null,"Kopfzeile links","&L&\"Verdana,Standard\"&8 [ToolHeader]"]
[null,"Kopfzeile Mitte","&\"Verdana,Standard\"&10 [MName]"]
[null,"Kopfzeile rechts","&R&\"Verdana,Standard\"&8 [BNR]/[MNR]\n?[MonatJahr]"]
[null,"Fußzeile links","&L&\"Verdana,Standard\"&8 © DATEV eG, gedruckt am &D &T"]
[null,"Fußzeile Mitte"]
[null,"Fußzeile rechts","&R&\"Verdana,Standard\"&8 Seite &P von &N"]
[]
[null,"Kopf- und Fußzeile für Berichte"]
[null,"Position","Inhalt"]
[null,"Kopfzeile links","&L&\"Verdana,Standard\"&10 [MName]"]
[null,"Kopfzeile Mitte","&\"Verdana,Standard\"&10 [BerichtInfo]\n[BerichtZeitraum]"]
[null,"Kopfzeile rechts","&R&\"Verdana,Standard\"&10 [BNR]/[MNR]"]
[null,"Fußzeile links","&L&\"Verdana,Standard\"&8 [ToolHeader] [BerichtVersion] © DATEV eG [ToolJahr], erstellt am [BerichtDatum], gedruckt am &D &T"]
[null,"Fußzeile Mitte"]
[null,"Fußzeile rechts","&R&\"Verdana,Standard\"&8 Seite &P von &N"]

{"sheet":"Positionen","index":5,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Muster","Top","Left","Width","Height"]
["Stammdaten_Rectangle 14",0.75,0.75,6,16.5]
["Stammdaten_Button 27",20.25,4.5,94.5,18.75]
["Stammdaten_Button 28",20.25,294.75,94.5,18.75]
["Stammdaten_Button 29",20.25,101.25,94.5,18.75]
["Stammdaten_Button 30",20.25,198,94.5,18.75]
["Textvorlagen_btnImportKontenplan",20.25,4.5,94.5,18.75]
["Textvorlagen_btnExportTexte",20.25,101.25,94.5,18.75]
["Textvorlagen_Button 7",20.25,198,94.5,18.75]
["Kostenstellen_Button 1",20.25,4.5,94.5,18.75]
["Kostenstellen_Button 2",20.25,101.25,94.5,18.75]
["Kostenstellen_Button 8",20.25,198,94.5,18.75]
["Zählprotokoll_Button 1",20.25,4.5,94.5,18.75]
["Zählprotokoll_Button 2",20.25,101.25,94.5,18.75]
["Zählprotokoll_Button 3",20.25,198,94.5,18.75]
["Zählprotokoll_Button 4",20.25,294.75,94.5,18.75]
["Druckeinstellungen_Button 1",20.25,3,94.5,18.75]
["Druckeinstellungen_Button 2",20.25,99.75,94.5,18.75]
["Druckeinstellungen_Button 3",20.25,196.5,94.5,18.75]
["Daten_Button 1",20.25,4.5,90,18.75]
["Daten_Button 2",20.25,96.75,66.75,18.75]
["Daten_Button 3",20.25,165.75,66.75,18.75]
["Daten_Button 4",20.25,303.75,66.75,18.75]
["Daten_Button 5",20.25,372.75,90,18.75]
["Daten_Button 6",20.25,234.75,66.75,18.75]
["Daten_Button 7",20.25,465.75,66.75,18.75]
["Daten_Button 8",20.25,535.5,85.5,18.75]

{"sheet":"ASCII_Import","index":6,"n_rows":14,"n_cols":63,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"> Typdefinition der Spalten (N=Numerisch, A=Alphanumerisch, B=Belegdatum, D=Datum, F=Formel oder nicht schreiben)"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,"Laufende Nummer"]
[null,0,2,0,4,5,0,7,8,9,10,11,12,13,14,15,16,17,18,0,0,0,0,0,0,0,0,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,"Spaltennummer im Sheet"]
[null,0,0,0,1,1,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Muss-Spalte"]
[null,"F","N","F","N","N","F","N","N","N","A","A","B","A","A","N","N","A","N","F","F","F","F","F","F","F","F","F","F","F","F","F","F","F","F","F","F","D","D","D","D","N","N","N","N","F","F","F","F","F","F","D","A","A","D","F","A","D","Spaltentyp"]
[null,"(leer)","Lfd. Nr.","Status","Einnahmen","Ausgaben","Tagesbestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt in %","(leer)","(leer)","(leer)","(leer)","(leer)","(leer)","(leer)","(leer)","Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?","Tagesbestand","Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import","Spaltenüberschrift"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quell-version","Quell-variante","Quell-zeile"]
[null,"Quellspalten für Kopierblöcke",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"von","bis",250,null,{"$f":"SUM(BK11:BK14)","v":12}]
[null,null,null,null,4,5,null,7,8,9,10,11,12,13,14,15,16,17,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,38,39,40,41,42,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,240,{"$f":"IF(AND(Quellversion>=BG11,Quellversion<=BH11),TRUE,FALSE)","v":false},1,{"$f":"IF(BI11,ROW(BI11),0)","v":0}]
[null,null,null,null,4,5,null,7,8,9,10,11,12,13,14,15,16,17,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,38,39,40,41,42,43,44,null,null,null,null,null,null,null,null,null,null,null,null,null,241,270,{"$f":"IF(AND(Quellversion>=BG12,Quellversion<=BH12),TRUE,FALSE)","v":true},1,{"$f":"IF(BI12,ROW(BI12),0)","v":12}]
[null,null,null,null,4,5,null,7,8,9,10,11,12,13,14,15,16,17,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,38,39,40,41,42,43,44,null,null,null,null,null,null,51,52,53,54,null,56,57,300,1000,{"$f":"IF(AND(Quellversion>=BG13,Quellversion<=BH13,Quellvariante=1),TRUE,FALSE)","v":false},1,{"$f":"IF(BI13,ROW(BI13),0)","v":0}]
[null,null,null,null,5,6,null,8,9,10,11,12,13,14,15,16,17,18,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,38,39,40,41,42,43,44,null,null,null,null,null,null,51,52,53,54,null,56,57,300,1000,{"$f":"IF(AND(Quellversion>=BG14,Quellversion<=BH14,Quellvariante=2),TRUE,FALSE)","v":false},2,{"$f":"IF(BI14,ROW(BI14),0)","v":0}]

{"sheet":"Eintragungen","index":7,"n_rows":178,"n_cols":7,"rows_kept":178,"cut":false,"hidden":true,"merged":[[32,6,32,7],[34,6,34,7],[35,6,35,7],[31,6,31,7],[151,1,151,3],[141,1,141,3],[112,1,112,3],[136,1,136,3],[1,1,1,3],[22,1,22,3],[72,1,72,3],[96,1,96,3],[16,1,16,3]]}
[]
[null,"> Stammdaten Tool"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"ToolVersion","3.11",false]
[null,"ToolStand","39",false]
[null,"ToolDatum","21.08.2017",false]
[null,"ToolJahr",2017,false]
[null,"ToolHeader","Kassenerfassung für Office",false]
[null,"ToolTitel",{"$f":"\"Einnahmen/Ausgaben vorerfassen - V.\" & ToolVersion","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},false]
[null,"ToolInfo",{"$f":"\"Kassen- und Warenerfassung f. Office\nCopyright © DATEV eG, 2001 - \" & RIGHT(ToolDatum, 4) & \"\nV.\" & ToolVersion & \", Stand \" & ToolDatum","v":"Kassen- und Warenerfassung f. Office\nCopyright © DATEV eG, 2001 - 2017\nV.3.11, Stand 21.08.2017"},false]
[null,"ToolDebug",false,false]
[null,"ToolKasse",true,false]
[null,"ToolCountry","DE",true]
[null,"ToolCountryDialog",true,true]
[null,"ToolDatenDialog",true,true]
[null,"ToolDatenImport",false,true]
[null,"> Allgemeine Variablen"]
[null,"LokalerHilfePfad",null,false]
[null,"SpaltenOffsetDatum",32,true]
[null,"InsertTextKey1","^",true]
[null,"InsertTextKey2","{F2}",true]
[null,"InsertUStValue","voll",true]
[null,"> Stammdaten Erfassung"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"PCDO2","[DDE:Mandant/Nummer]",true]
[null,"MandNr",null,true]
[null,"BNR",18359,true]
[null,"MName","Kassenvorerfassung 2022",true]
[null,"MNR",0,true]
[null,"WJBeginnTag",{"$f":"IF(WJBeginn=\"\",\"\",DAY(WJBeginn))","v":1},true]
[null,"WJBeginnMonat",{"$f":"IF(WJBeginn=\"\",\"\",MONTH(WJBeginn))","v":1},true]
[null,"WJBeginnJahr",{"$f":"IF(WJBeginn=\"\",\"\",YEAR(WJBeginn))","v":2024},true]
[null,"WJBeginn","2024-01-01",false]
[null,"WJEnde","2024-12-31",false]
[null,"KtoNummer",1000,true]
[null,"KtoLänge",4,true]
[null,"KtoVerrechnung",0,true]
[null,"VerrechnungsKonto",false,true]
[null,"KtoSaldoStart",0,true]
[null,"EingabeWährung","EUR",true]
[null,"Datenpfad",null,true]
[null,"WarenEingang",false,false]
[null,"ShowDateOnStatus",true,true]
[null,"OverwriteFields",false,true]
[null,"NopOnLocked",false,true]
[null,"AddGegenKtoToList",true,true]
[null,"AddKost1ToList",true,true]
[null,"AddKost2ToList",true,true]
[null,"DefaultLineHeight",14,true,"ab V.2.4 neue Bedeutung"]
[null,"AutoUpdateHeight",true,true]
[null,"OptSpalteLfdNr",true,true]
[null,"OptSpalteStatus",true,true]
[null,"OptSpalteKost1",false,true]
[null,"OptSpalteKost2",false,true]
[null,"OptSpalteKostMenge",false,true]
[null,"OptSpalteBeleg2",true,true]
[null,"OptSpalteSkonto",true,true]
[null,"OptSpalteGegenkonto",true,true]
[null,"OptSpalteUSt",true,true]
[null,"NeedsSpalteBeleg1",false,true]
[null,"NeedsSpalteGegenKto",false,true]
[null,"NeedsSpalteKonto",false,true,"Immer FALSCH für Kasse!!"]
[null,"NeedsSpalteKost1",false,true]
[null,"NeedsSpalteKost2",false,true]
[null,"SpalteLfdNrReal",true,true]
[null,"BestandImmerZeigen",false,true,"Nur Kasse"]
[null,"SeitennummerZeigen",false,true]
[null,"SpeichernUnterVorgabe",false,true]
[null,"IgnoreDMS",false,true,{"$f":"IF(IgnoreDMS,\"Yes\",\"No\")","v":"No"},"obsolete"]
[null,"ShowCurrentMonth",false,true]
[null,"DontUseHookAddin",false,true]
[null,"Angelegt",true,false]
[null,"> Daten Dialog Einstellungen"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"DATEVEingabe",true,true]
[null,"ImmerPrüfen",true,true]
[null,"NurZeilePrüfen",false,true]
[null,"DatumPrüfen",true,true]
[null,"DatumMitMonat",false,true]
[null,"KassePrüfen",true,true]
[null,"VormonatZulassen",false,true]
[null,"BUErzwingtGegenkonto",false,true]
[null,"BUmitGegenkonto",false,true]
[null,"BUSpaltenSprung",true,true]
[null,"AllowZeroValues",false,true]
[null,"AllowDeleteChecked",true,true]
[null,"DefinedKostOnly",false,true]
[null,"KeinGegenkonto",true,true]
[null,"DatumExpandieren",true,true]
[null,"VorlaufNichtSortieren",false,true]
[null,"TextWarenArt",false,true,"Nur Ware"]
[null,"TextNameOrt",false,true,"Nur Ware"]
[null,"TextBeide",true,true,"Nur Ware"]
[null,"NameOrtZuerst",false,true,"Nur Ware"]
[null,"KostAlsStück",false,true]
[null,"SKey1",32,false]
[null,"> Daten für Export"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"ExportASCII",false,true]
[null,"ProtokollSchreiben",false,true]
[null,"ProtokollVerzeichnis",null,true]
[null,"BerichtUseExportPath",true,true]
[null,"BerichtVerzeichnis",null,true]
[null,"Festschreibekennung",false,true]
[null,"ZielVerzeichnis",null,true]
[null,"ZielVerzeichnisASCII",null,true]
[null,"AbrechnungsNummer",null,false]
[null,"AbrechnungsJahr",{"$f":"RIGHT(WJBeginnJahr,2)","v":"24"},false]
[null,"Namenskürzel",null,true]
[null,"Paßwort",null,false]
[null,"AB_EB_Buchung",true,true,"Nur für Kasse"]
[null,"E_WarenArt",true,true,"Obsolet"]
[null,"> Neu ab Version 2.2 (Build 22)"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"NumericKostOnly",false,true]
[null,"NoOverwriteWithEmpty",false,true]
[null,"BuchenAnzeigeSH",false,true]
[null,"AllowLongText",false,true]
[null,"LongTextMaxLen",210,true]
[null,"StandardTextLen",60,true]
[null,"AutoTextInsert",false,true]
[null,"AutoTextInsertSingle",false,true]
[null,"AutoKontoInsert",false,true]
[null,"AutoTextInsertAlways",false,true]
[null,"SortAllPages",false,true]
[null,"SchleppenGegKto",false,true]
[null,"SchleppenBeleg1",true,true]
[null,"SchleppenDatum",true,true]
[null,"SchleppenKonto",true,true]
[null,"SchleppenKost1",false,true]
[null,"SchleppenText",false,true]
[null,"SchleppenWarenArt",false,true]
[null,"SchleppenUSt",false,true]
[null,"DirectChange",false,true]
[null,"TrennzeichenEinAus"," / ",true]
[null,"ShowEinAusOnSaldo",false,true]
[null,"> Neu ab Verison 2.4 (Build 26)"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"DefaultLineHeightFont",14,true]
[null,"DefaultLineHeightSpacing",3,true]
[null,"BelegTransferPfad",null,true]
[null,"> Daten für Blankodruck"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"B_BNR",null,true]
[null,"B_MNR",null,true]
[null,"B_KtoNummer",null,true]
[null,"B_KtoSaldoStart",null,true]
[null,"B_Währung",null,true]
[null,"B_WJBeginn",null,true]
[null,"B_MName",null,true]
[null,"B_WarenEingang",null,true,"Nur für Ware!"]
[null,"> Daten für PrintSetup"]
[null,"Variable","Wert","Jahresübernahme"]
[null,"ErfassungHeaderLeft","&L&\"Verdana,Standard\"&8 [ToolHeader]",true]
[null,"ErfassungHeaderCenter","&\"Verdana,Standard\"&10 [MName]",true]
[null,"ErfassungHeaderRight","&R&\"Verdana,Standard\"&8 [BNR]/[MNR]\n?[MonatJahr]",true]
[null,"ErfassungFooterLeft","&L&\"Verdana,Standard\"&8 © DATEV eG, gedruckt am &D &T",true]
[null,"ErfassungFooterCenter",null,true]
[null,"ErfassungFooterRight","&R&\"Verdana,Standard\"&8 Seite &P von &N",true]
[null,"BerichtHeaderLeft","&L&\"Verdana,Standard\"&10 [MName]",true]
[null,"BerichtHeaderCenter","&\"Verdana,Standard\"&10 [BerichtInfo]\n[BerichtZeitraum]",true]
[null,"BerichtHeaderRight","&R&\"Verdana,Standard\"&10 [BNR]/[MNR]",true]
[null,"BerichtFooterLeft","&L&\"Verdana,Standard\"&8 [ToolHeader] [BerichtVersion] © DATEV eG [ToolJahr], erstellt am [BerichtDatum], gedruckt am &D &T",true]
[null,"BerichtFooterCenter",null,true]
[null,"BerichtFooterRight","&R&\"Verdana,Standard\"&8 Seite &P von &N",true]
[]
[null,"> Daten für Sortierung"]
[null,"Bezeichnung","Spalte","Zusatzspalte","DataOption","AlphaNum","DataOption:"]
[null,"Belegdatum",32,"Nein",0,0,"0 = xlSortNormal"]
[null,"Rechn. Nr.",10,"Nein",0,1,"1 = xlSortTextAsNumber"]
[null,"Beleg Nr.",11,"OptSpalteBeleg2",0,1,"nur relevant, wenn Spalte alphanumerisch ist"]
[null,"Lfd. Nr.",2,"OptSpalteLfdNr",0,0,"nur wirksam, wenn Office Version > 8"]
[null,"GegenKto.",9,"OptSpalteGegenkonto",0,0]
[null,"Kostenstelle",13,"OptSpalteKost1",0,1]
[null,"Kost 2",14,"OptSpalteKost2",0,1]
[null,"Kost-Menge",15,"OptSpalteKostMenge",0,0]
[null,"Buchungstext",17,"Nein",0,1]
[null,"Status",3,"OptSpalteStatus",0,0]

{"sheet":"Kommentare","index":8,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
[{"$f":"\"Kommentare \" & ToolTitel","v":"Kommentare Einnahmen/Ausgaben vorerfassen - V.3.11"}]
["Spalten#","Deutschland","Österreich","Breite","Höhe"]
[2,"Spalte Lfd. Nr.: \nZeigt die laufende Nummer an. \n\nDiese Spalte wird, abhängig von den gewählten Einstellungen, automatisch durch das Programm gefüllt.","Spalte Lfd. Nr.: \nZeigt die laufende Nummer an. \n\nDiese Spalte wird, abhängig von den gewählten Einstellungen, automatisch durch das Programm gefüllt.",250,66]
[{"$f":"A3+1","v":3},"Spalte Status:\nZeigt den Status der Erfassungszeile an.\n\nFolgende Anzeigen sind möglich:\n* Angelegt. Erstmaliges Anlegen der Erfassungszeile und erfolgreiche Prüfung.\n* Geändert. Erfassungszeile wurde gegenüber dem Status Angelegt geändert.\n* Geprüft. Manuell gesetztes Kennzeichen.\n* Exportiert. Die Erfassungszeile wurde in einem Vorlauf exportiert.\n\nBei Status Geprüft wird die Hintergrundfarbe Grün eingestellt und die Erfassungszeile gesperrt.\nBei Status Export wird die Hintergrundfarbe Gelb eingestellt und die Erfassungszeile gesperrt. Der Status Export kann nur im Dialog Exportverlauf zurück genommen werden. Der Dialog ist über Exportieren... | Verlauf erreichbar.","Spalte Status:\nZeigt den Status der Erfassungszeile an.\n\nFolgende Anzeigen sind möglich:\n* Angelegt. Erstmaliges Anlegen der Erfassungszeile und erfolgreiche Prüfung.\n* Geändert. Erfassungszeile wurde gegenüber dem Status Angelegt geändert.\n* Geprüft. Manuell gesetztes Kennzeichen.\n* Exportiert. Die Erfassungszeile wurde in einem Vorlauf exportiert.\n\nBei Status Geprüft wird die Hintergrundfarbe Grün eingestellt und die Erfassungszeile gesperrt.\nBei Status Export wird die Hintergrundfarbe Gelb eingestellt und die Erfassungszeile gesperrt. Der Status Export kann nur im Dialog Exportverlauf zurück genommen werden. Der Dialog ist über Exportieren... | Verlauf erreichbar.",380,156]
[{"$f":"A4+1","v":4},"Spalte Einnahmen: \nGeben Sie hier den Betrag der Einnahme an. \n\nDer Betrag darf nicht mehr als 10 Vorkommastellen und 2 Nachkommastellen (10.2)  haben. \n\nBeachten Sie, dass die Felder Einnahmen und Ausgaben in einer Zeile nicht gleichzeitig gefüllt sein dürfen.","Spalte Einnahmen: \nGeben Sie hier den Betrag der Ausgabe an. \n\nDer Betrag darf nicht mehr als 10 Vorkommastellen und 2 Nachkommastellen (10.2)  haben. \n\nBeachten Sie, dass die Felder Einnahmen und Ausgaben einer Buchung nicht gleichzeitig gefüllt sein dürfen.",250,99]
[{"$f":"A5+1","v":5},"Spalte Ausgaben: \nGeben Sie hier den Betrag der Ausgabe an. \n\nDer Betrag darf nicht mehr als 10 Vorkommastellen und 2 Nachkommastellen (10.2)  haben. \n\nBeachten Sie, dass die Felder Einnahmen und Ausgaben einer Buchung nicht gleichzeitig gefüllt sein dürfen.","Spalte Ausgaben: \nGeben Sie hier den Betrag der Entnahme an. \n\nDer Betrag darf nicht mehr als 10 Vorkommastellen und 2 Nachkommastellen (10.2)  haben. \n\nBeachten Sie, dass die Felder Einnahmen und Ausgaben einer Buchung nicht gleichzeitig gefüllt sein dürfen.",250,99]
[6,"Spalte Bestand: \nHier wird der aktuelle Saldo ausgewiesen. \n\nDiese Spalte wird automatisch durch das Programm gefüllt. Abhängig von den gewählten Einstellungen entspricht der Betrag dem Tagesendsaldo.","Spalte Bestand: \nHier wird der aktuelle Saldo ausgewiesen. \n\nDiese Spalte wird automatisch durch das Programm gefüllt. Abhängig von den gewählten Einstellungen entspricht der Betrag dem Tagesendsaldo.",250,77]
[7,"Spalte B-Schlüssel: \nGeben Sie hier einen eventuellen Berichtigungsschlüssel ein.\n\nZulässige Werte sind: \n* 2   Generalumkehr \n* 3   Generalumkehr bei aufzuteilender Vorsteuer \n* 5   Individueller USt-Schlüssel \n* 7   Generalumkehr bei individuellem USt-Schlüssel \n* 9   Aufzuteilende Vorsteuer \nWeitere Schlüssel erfragen Sie bei Ihrem Steuerberater.","Spalte B-Schlüssel: \nGeben Sie hier einen eventuellen Berichtigungsschlüssel ein.\n\nZulässige Werte sind: \n* 2   Generalumkehr \n* 3   Generalumkehr bei aufzuteilender Vorsteuer \n* 5   Individueller USt-Schlüssel \n* 7   Generalumkehr bei individuellem USt-Schlüssel \n* 9   Aufzuteilende Vorsteuer \nWeitere Schlüssel erfragen Sie bei Ihrem Steuerberater.",250,121]
[8,"Spalte U-Schlüssel: \nGeben Sie hier einen eventuellen Steuerschlüssel ein.\n\nZulässige Werte sind:\n* 1   Umsatzsteuerfrei (mit Vorsteuerabzug)\n* 2   Umsatzsteuer 7%\n* 3   Umsatzsteuer 19%\n* 8   Vorsteuer 7%\n* 9   Vorsteuer 19%\nWeitere Schlüssel erfragen Sie bei Ihrem Steuerberater.","Spalte U-Schlüssel: \nGeben Sie hier einen eventuellen Steuerschlüssel ein.\n\nZulässige Werte sind:\n* 1   Umsatzsteuerfrei (mit Vorsteuerabzug)\n* 2   Umsatzsteuer 10%\n* 3   Umsatzsteuer 20%\n* 4   Umsatzsteuer 13%\n* 6   Vorsteuer 13%\n* 8   Vorsteuer 10%\n* 9   Vorsteuer 20%\nWeitere Schlüssel erfragen Sie bei Ihrem Steuerberater.",250,143]
[9,"Spalte Gegenkonto: \nFalls bekannt, geben Sie hier das Gegenkonto ein. \n\nFolgende Eingaben sind zulässig:\n* 3400, bei Sachkontenlänge 4\n* 340000 oder 3400 00, bei Sachkontenlänge 6\nDie Länge des Gegenkontos kann nicht größer sein, als die Kontenlänge der Kasse plus 1.\n\nDieses Feld kann auch leer bleiben. \n\nFür ein fehlendes Gegenkonto kann beim Export automatisch das Verrechnungskonto übernommen werden. \nIst kein Verrechnungskonto angegeben, sind die fehlenden Daten beim späteren Import in die Finanzbuchhaltung zu ergänzen.","Spalte Gegenkonto: \nFalls bekannt, geben Sie hier das Gegenkonto ein. \n\nFolgende Eingaben sind zulässig:\n* 3400, bei Sachkontenlänge 4\n* 340000 oder 3400 00, bei Sachkontenlänge 6\nDie Länge des Gegenkontos kann nicht größer sein, als die Kontenlänge der Kasse plus 1.\n\nDieses Feld kann auch leer bleiben. \n\nFür ein fehlendes Gegenkonto kann beim Export automatisch das Verrechnungskonto übernommen werden. \nIst kein Verrechnungskonto angegeben, sind die fehlenden Daten beim späteren Import in die Finanzbuchhaltung zu ergänzen.",250,187]
[10,"Spalte Rech.Nr. (Belegfeld1): \nGeben Sie hier Ihre Rechnungsnummer ein.\n\nDie Rechnungsnummer darf ein alphanumerischer Wert mit maximal 12 Stellen sein.\n\nBeachten Sie, dass weiterverarbeitende Programme unter Umständen nur numerische Werte verarbeiten können. Fragen Sie Ihren Steuerberater, ob Sie nur numerische Werte verwenden dürfen.","Spalte Rech.Nr. (Belegfeld1): \nGeben Sie hier Ihre Rechnungsnummer ein.\n\nDie Rechnungsnummer darf ein alphanumerischer Wert mit maximal 12 Stellen sein.\n\nBeachten Sie, dass weiterverarbeitende Programme unter Umständen nur numerische Werte verarbeiten können. Fragen Sie Ihren Steuerberater, ob Sie nur numerische Werte verwenden dürfen.",250,121]
[11,"Spalte Beleg Nr. (Belegfeld2): \nGeben Sie hier Ihre Belegnummer ein.\n\nDie Belegnummer darf ein alphanumerischer Wert mit maximal 12 Stellen sein.\n\nBeachten Sie, dass weiterverarbeitende Programme unter Umständen nur numerische Werte verarbeiten können. Fragen Sie Ihren Steuerberater, ob Sie nur numerische Werte verwenden müssen.","Spalte Beleg Nr. (Belegfeld2): \nGeben Sie hier Ihre Belegnummer ein.\n\nDie Belegnummer darf ein alphanumerischer Wert mit maximal 12 Stellen sein.\n\nBeachten Sie, dass weiterverarbeitende Programme unter Umständen nur numerische Werte verarbeiten können. Fragen Sie Ihren Steuerberater, ob Sie nur numerische Werte verwenden müssen.",250,121]
[12,"Spalte Belegdatum:\nGeben Sie hier das Datum des zu erfassenden Belegs ein.\n\nFolgende Eingaben können verarbeitet werden:\n* Tag des Monats (z.B. 6 --> 06.03. im Blatt 03.2001)\n* Tag und Monat (z.B. 6.3. --> 06.03.)\n* Tag, Monat und Jahr (z.B. 6.3.2001 --> 06.03.)\nDie Eingabe des Datums kann auch ohne Punkt erfolgen\n(z.B. 603 --> 06.03.)","Spalte Belegdatum:\nGeben Sie hier das Datum des zu erfassenden Belegs ein.\n\nFolgende Eingaben können verarbeitet werden:\n* Tag des Monats (z.B. 6 --> 06.03. im Blatt 03.2001)\n* Tag und Monat (z.B. 6.3. --> 06.03.)\n* Tag, Monat und Jahr (z.B. 6.3.2001 --> 06.03.)\nDie Eingabe des Datums kann auch ohne Punkt erfolgen\n(z.B. 603 --> 06.03.)",250,110]
[13,"Spalte KOST1:\nGeben Sie hier Angaben zu Kostenstellen ein.\n\nKOST1 darf ein alphanumerischer Wert mit maximal 8 Stellen sein.","Spalte KOST1:\nGeben Sie hier Angaben zu Kostenstellen ein.\n\nKOST1 darf ein alphanumerischer Wert mit maximal 8 Stellen sein.",250,66]
[14,"Spalte KOST2:\nGeben Sie hier Angaben zu Kostenstellen ein.\n\nKOST2 darf ein alphanumerischer Wert mit maximal 8 Stellen sein.","Spalte KOST2:\nGeben Sie hier Angaben zu Kostenstellen ein.\n\nKOST2 darf ein alphanumerischer Wert mit maximal 8 Stellen sein.",250,66]
[15,"Spalte KOST-Menge:\nGeben Sie hier eine Mengenangabe ein.\n\nDie Mengenangabe darf höchstens 9 Vorkomma-\nund 2 Nachkommastellen (9.2) haben","Spalte KOST-Menge:\nGeben Sie hier eine Mengenangabe ein.\n\nDie Mengenangabe darf höchstens 9 Vorkomma-\nund 2 Nachkommastellen (9.2) haben",250,66]
[16,"Spalte Skonto: \nGeben Sie hier einen eventuellen Skontobetrag ein. \n\nDer Betrag darf höchstens 8 Vorkomma- und 2 Nachkommastellen (8.2) haben","Spalte Skonto: \nGeben Sie hier einen eventuellen Skontobetrag ein. \n\nDer Betrag darf höchstens 8 Vorkomma- und 2 Nachkommastellen (8.2) haben",250,66]
[17,"Spalte Text:\nGeben Sie hier einen beschreibenden Text zur Erfassungszeile ein.\n\nBeachten Sie, dass abhängig vom Exportformat nur eine begrenzte Anzahl Zeichen bei einem Export übertragen werden können.","Spalte Text:\nGeben Sie hier einen beschreibenden Text zur Erfassungszeile ein.\n\nBeachten Sie, dass abhängig vom Exportformat nur eine begrenzte Anzahl Zeichen bei einem Export übertragen werden können.",250,99]
[18,"Spalte USt-Satz:\nGeben Sie hier bei Bedarf den USt-Satz in Prozent ein.\n\nDer Wert darf nicht mehr als 2 Vorkommastellen und 2 Nachkommastellen (2.2) haben.\n\nDie Daten in dieser Spalten werden als Zusatzinformationen übertragen.","Spalte USt-Satz:\nGeben Sie hier bei Bedarf den USt-Satz in Prozent ein.\n\nDer Wert darf nicht mehr als 2 Vorkommastellen und 2 Nachkommastellen (2.2) haben.\n\nDie Daten in dieser Spalten werden als Zusatzinformationen übertragen.",250,99]
[null,"<== Spalte A muss in der letzten Zeile leer sein!!"]

{"sheet":"Template","index":9,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":" "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"/"}]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum",null,null,"Sortierspalte"]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" /"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum",null,null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"01.2024","index":10,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"KtoSaldoStart","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"01/2024"},"01",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-01-01","2024-01-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 01/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-01-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"02.2024","index":11,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'01.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"02/2024"},"02",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-02-01","2024-01-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 02/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-02-29",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"03.2024","index":12,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'02.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"03/2024"},"03",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-03-01","2024-02-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 03/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-03-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"04.2024","index":13,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'03.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"04/2024"},"04",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-04-01","2024-03-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 04/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-04-30",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"05.2024","index":14,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'04.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"05/2024"},"05",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-05-01","2024-04-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 05/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-05-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"06.2024","index":15,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'05.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"06/2024"},"06",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-06-01","2024-05-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 06/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-06-30",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"07.2024","index":16,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'06.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"07/2024"},"07",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-07-01","2024-06-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 07/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-07-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"08.2024","index":17,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'07.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"08/2024"},"08",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-08-01","2024-07-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 08/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-08-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"09.2024","index":18,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'08.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"09/2024"},"09",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-09-01","2024-08-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 09/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-09-30",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"10.2024","index":19,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'09.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"10/2024"},"10",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-10-01","2024-09-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 10/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-10-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"11.2024","index":20,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'10.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"11/2024"},"11",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-11-01","2024-10-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 11/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-11-30",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"12.2024","index":21,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'11.2024'!AC3","v":0},{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":"Belegdatum "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"12/2024"},"12",2024]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum","2024-12-01","2024-11-01","Sortierspalte",32,"Belegdatum",0]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" 12/2024"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum","2024-12-31",null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]

{"sheet":"Blatt_13","index":22,"n_rows":12,"n_cols":57,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"ToolTitel","v":"Einnahmen/Ausgaben vorerfassen - V.3.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daten","1 / 28","2 / 29","3 / 30","4 / 31","5 / 32","6 / 33","7 / 34","8 / 35","9 / 36","10 / 37","11 / 38","12 / 39","13 / 40","14 / 41","15 / 42","16 / 43","17 / 44","18 / 45","19 / 46","20 / 47","21 / 48","22 / 49","23 / 50","24 / 51","25 / 52","26 / 53","27 / 54","28 / 55","29 / 56","30 / 57"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AnfangsSaldo","SummeMonat","SummeKonto","Lfd. Nummer","Druck durchlaufen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D:D)-SUM(E:E)","v":0},{"$f":"AA3+AB3","v":0},0,false]
[]
[null,null,null,null,null,null,null,null,"Sortiert nach Spalte ",{"$f":"AF7& \" \"","v":" "},null,null,null,null,null,"Monatssaldo ",{"$f":"IF(ShowEinAusOnSaldo,TEXT(SUM(D:D),\"#.##0,00\") & TrennzeichenEinAus & TEXT(SUM(E:E),\"#.##0,00\"),SUM(D:D) - SUM(E:E))","v":0},null,null,null,null,null,null,null,null,null,"Monat/Jahr",{"$f":"AC5 & \"/\" & AD5","v":"/"}]
[]
[null,null,null,"Berater / Mandant ",{"$f":"\" \" & IF(BNR<>\"\",BNR,\"\") & IF(AND(BNR<>\"\",MNR<>\"\"), \" / \", \"\") & IF(MNR<>\"\",MNR,\"\")","v":" 18359 / 0"},null,null,null,"Kontonummer ",{"$f":"KtoNummer","v":1000},null,null,null,null,null,"Anfangssaldo ",{"$f":"AA3","v":0},null,null,null,null,null,null,null,null,null,"Anfangsdatum",null,null,"Sortierspalte"]
[]
[null,null,null,"Monat / Jahr ",{"$f":"\" \" & IF(AB5<>\"\",AB5,\"\")","v":" /"},null,null,null,"Währung ",{"$f":"EingabeWährung","v":"EUR"},null,null,null,null,null,"Endsaldo ",{"$f":"AC3","v":0},null,null,null,null,null,null,null,null,null,"Enddatum",null,null,"Tagesbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diese Spalten sind nur für die \"Buch\"-Varianten relevant und stehen hier nur zur Info"]
[]
[null,{"$f":"IF(AK11<>\"\",IF(SpalteLfdNrReal,AQ11, ROW(B11)-13+1),\"\")","v":""},{"$f":"IF(AE11<>\"\",AV11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(D11,E11)","v":0},{"$f":"IF(DatumPrüfen,IF(ISERROR(DATEVALUE(L11 & $AD$5)),FALSE,IF(OR(DATEVALUE(L11 & $AD$5) < IF(VormonatZulassen,$AC$7,$AB$7), DATEVALUE(L11 & $AD$5) > $AB$9),FALSE,TRUE)),TRUE)","v":false},{"$f":"IF(L11<>L12,TRUE,FALSE)","v":true},{"$f":"ROUND(AD10+IF(ISNUMBER(D11),D11,0)-IF(ISNUMBER(E11),E11,0),2)","v":0},{"$f":"LEN(TRIM(D11) &TRIM(E11) &TRIM(G11) &TRIM(H11) &TRIM(I11) &TRIM(J11) &TRIM(K11) &TRIM(L11) &TRIM(M11) &TRIM(N11) &TRIM(O11) &TRIM(P11) &TRIM(Q11) &TRIM(R11) )","v":0},{"$f":"IF(ISERROR(DATEVALUE(L11 & $AD$5)),\"\",DATEVALUE(L11 & $AD$5))","v":""},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)>=IF(ISNUMBER(P11),P11,0),FALSE,TRUE)","v":false},{"$f":"IF(BUErzwingtGegenkonto,IF(AND(COUNTA(G11:H11)>0,I11=\"\"),FALSE,TRUE),TRUE)","v":true},{"$f":"IF(OR(KtoLänge=0,I11=0),TRUE,IF(LEN(I11)>IF(KtoLänge>0,KtoLänge,8)+IF(BUmitGegenkonto,3,1),FALSE,TRUE))","v":true},{"$f":"IF(ROUND(ABS(IF(ISNUMBER(D11),D11,0) - IF(ISNUMBER(E11),E11,0)),2)=0,TRUE,FALSE)","v":true},null,null,null,null,null,null,null,null,{"$f":"IF(NumericKostOnly,IF(M11=\"\",TRUE,IF(ISERROR(VALUE(M11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"IF(NumericKostOnly,IF(N11=\"\",TRUE,IF(ISERROR(VALUE(N11)),FALSE,TRUE)),TRUE)","v":true},{"$f":"LEN(Q11) > StandardTextLen","v":false},{"$f":"IF(AN11<>\"\",IF(AO11=2,\"Übersprungen\",\"Exportiert\") & IF(ShowDateOnStatus,\"\nam \" & TEXT(AN11,\"TT.MM.JJJJ\"),\"\"),IF(AO11=1,\"Exportfehler\",IF(AM11<>\"\",\"Geprüft\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AM11,\"TT.MM.JJJJ\"),\"\"),IF(AR11=1,\"Zu prüfen\",IF(AL11<>\"\",\"Geändert\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AL11,\"TT.MM.JJJJ\"),\"\"),IF(AK11<>\"\",\"Angelegt\" & IF(ShowDateOnStatus,\"\nam \" & TEXT(AK11,\"TT.MM.JJJJ\"),\"\"),\"\"))))))","v":""},{"$f":"IF(AN11<>\"\",IF(AO11=2,19,36),IF(AO11=1,45,IF(AM11<>\"\",4,IF(AR11=1,37,IF(AL11<>\"\",39,IF(AK11<>\"\",39,39))))))","v":39}]
[null,"Lfd. Nr.","Status","Einnahmen","Ausgaben","Bestand","B","U","GegenKto","Rech.Nr. (Belegfeld1)","Beleg Nr. (Belegfeld2)","Beleg Datum","Kostenstelle (KOST1)","KOST2","KOST-Menge","Skonto","Text","USt \nin %",null,null,null,null,null,null,null,null,"Anzahl Einnahmen + Ausgaben > 0?","Datum >= Startdatum und <= Enddatum?","Letzte Tagesbuchung?",{"$f":"AA3","v":0},"Anzahl gefüllter Felder","Echtes Datum für Export","Skonto größer als Soll/Haben","BU-Feld nur mit Gegenkonto","Prüfung Länge Gegenkonto","Prüfung auf Nullbuchung","Angelegt am","letzte Änderung am","Geprüft am","Exportiert am","Exportstatus","aktuelle Prüfsumme","Original Lfd. Nr.","Zu prüfen","Kost1 numerisch","Kost2 numerisch","Feld Text Länge zu groß","Status Text","Status ColorIndex","Status gelöscht","Gelöscht am","GUID Aufteilen","Lfd. Nr. Aufteilen","Datum Aufteilen","Status Import","GUID Import","Datum Import"]