{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Seite 1","Attribute","Drucken","Eintragung","Stammdaten"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":53,"comments":0,"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":"Seite 1","index":0,"n_rows":52,"n_cols":17,"rows_kept":52,"cut":false,"hidden":false,"merged":[[26,3,26,5],[30,4,30,5],[27,12,28,12],[26,7,26,10],[9,9,11,13],[12,3,13,5],[14,3,15,5],[12,9,13,13],[23,7,23,10],[17,9,21,12],[14,9,16,12],[23,6,25,6],[24,12,25,12],[22,7,22,10],[24,7,25,10],[24,11,25,11],[4,3,4,5],[24,4,25,5],[6,3,7,5],[22,3,22,5],[8,3,9,5],[10,3,11,5],[16,3,16,5],[23,3,23,5],[53,3,53,7],[51,3,51,4],[34,5,34,7],[27,4,28,5],[40,3,40,4],[42,5,42,7],[43,5,43,7],[40,5,40,7],[27,7,28,10],[50,10,50,12],[37,3,37,4],[34,3,34,4],[41,3,41,4],[34,8,34,10],[37,8,37,10],[30,7,30,10],[3,9,3,11],[4,9,6,12],[41,5,41,7],[36,5,36,7],[37,5,37,7],[38,5,38,7],[3,3,3,5],[39,8,39,10],[38,3,38,4],[36,8,36,10],[33,3,33,4],[38,8,38,10],[39,5,39,7],[39,3,39,4],[40,8,40,10],[35,8,35,10],[49,10,49,11],[29,6,30,6],[29,7,29,10],[27,11,28,11],[41,8,41,10],[42,8,42,10],[49,3,49,7],[48,3,48,4],[47,3,47,4],[42,3,42,4],[43,3,43,4],[48,10,48,11],[36,3,36,4],[35,3,35,4],[26,6,28,6],[35,5,35,7]]}
[]
[]
[]
[null,null,null,"Steuernummer",null,null,null,null,null,"  Eingangsstempel"]
[]
[]
[null,null,null,"Name/Firmenstempel"]
[]
[null,null,null,""]
[null,null,null,null,null,null,null,null,null,"Verrechnungsantrag"]
[null,null,null,""]
[]
[null,null,null,"",null,null,null,null,null,"an das"]
[]
[null,null,null," ",null,null,null,null,null,"Finanzamt (Finanzkasse)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"(Bitte kein Übertrag auf künftige Steueranmeldungszeiträume)"]
[]
[]
[]
[]
[null,null,null,"Ich (Wir) beantrage(n), das Guthaben aus der",null,null,null,"für Zeitraum",null,null,null,"in Höhe von -Euro-","-Ct-"]
[]
[null,null,null,null,"        Umsatzsteuer-Voranmeldung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L25+(M25/100)","v":0}]
[]
[null,null,null,null,"        Lohnsteuer-Anmeldung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L28+(M28/100)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L31+(M31/100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Summe:",{"$f":"IF(TRUNC(Q32)>0,TRUNC(Q32),IF(COUNTA(ein_zs_1,ein_zs_2,ein_zs_3,ein_zs_1_nk,ein_zs_2_nk,ein_zs_3_nk)=0,\"\",0))","v":""},{"$f":"IF((Q32-TRUNC(Q32))*100>0,(Q32-TRUNC(Q32))*100,IF(COUNTA(ein_zs_1_nk,ein_zs_2_nk,ein_zs_3_nk)=0,\"\",0))","v":""},null,null,null,{"$f":"Q26+Q29+Q31","v":0}]
[]
[null,null,null,"umzubuchen auf"]
[null,null,null,"Steuernummer",null,"Steuerart / Abgabeart",null,null,"Zeitraum",null,null,"Betrag in -Euro-","-Ct-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L36+(M36/100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Summe:",{"$f":"IF(TRUNC(Q44)>0,TRUNC(Q44),IF(COUNTA(ein_zs_4_nk,ein_zs_5_nk,ein_zs_6_nk,ein_zs_7_nk,ein_zs_8_nk,ein_zs_9_nk,ein_zs_10_nk,ein_zs_11_nk)=0,\"\",0))","v":""},{"$f":"IF((Q44-TRUNC(Q44))*100 > 0,(Q44-TRUNC(Q44))*100,IF(COUNTA(ein_zs_4_nk,ein_zs_5_nk,ein_zs_6_nk,ein_zs_7_nk,ein_zs_8_nk,ein_zs_9_nk,ein_zs_10_nk,ein_zs_11_nk)=0,\"\",0))","v":""},null,null,null,{"$f":"Q36+Q37+Q38+Q39+Q40+Q41+Q42+Q43","v":0}]
[]
[]
[]
[null,null,null,"Ort,Datum:"]
[null,null,null,null,null,null,null,null,null,null,"Das verbleibende Restguthaben von"]
[null,null,null,null,null,null,null,null,null,null,{"$f":" Q50","v":""},null,"Euro",null,null,null,{"$f":"IF(Q32-Q44 > 0,Q32-Q44, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"bitte(n) Ich (wir) auf das dem Finanzamt bekannte Konto zu überweisen."]
[null,null,null,"Unterschrift:"]

{"sheet":"Attribute","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["KAW-Variable","Wert","Bezeichnung"]
["KAW020001",{"$f":"IF(Mandantennummer=\"\",\"\",Mandantennummer)","v":""},"Nummer"]
["KAW010101",{"$f":"IF(FirstRun=\"\",\"\",YEAR(FirstRun))","v":2021},"Jahr"]
["KAW010102",{"$f":"IF(FirstRun=\"\",\"\",MONTH(FirstRun))","v":2},"Monat"]
["KAW010103","Verrechnungsantrag an das Finanzamt (Finanzkasse)","Beschreibung"]
["KAW010105","Verrechnungsantrag, Finanzamt, Finanzkasse","Stichworte"]

{"sheet":"Drucken","index":2,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Sheetname","Header","Caption","Checked","Druck","Linebreak","WithBlankSheet","BlankSheetName","Seiten","Drucker","BeraterMandant","Duplex"]
["Seite 1","Header",null,"true",true,null,null,null,1,null,true,true]

{"sheet":"Eintragung","index":3,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Art","Person","Betrieb","VF","Quelle / Ziel","Wert","VF","Wert 1","Wert 2","Wert 3","Wert 4","Wert 5","Wert 6","Wert 7","Wert 8","Wert 9","Wert 10"]
["ZMSD","$Mandant.Nummer","$Mandant.Nummer",null,"Mandantennummer",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Steuernummer","$Betrieb.Hauptfinanzamt.Steuernummer",null,"Steuernummer",""]
["ZMSD","NA","$Betrieb.Unternehmensgegenstand",null,"UGegenstand",""]
["ZMSD","$Steuerpflichtiger.TitelAkademischerGrad","NA",null,"Titel"]
["ZMSD","$Steuerpflichtiger.Vorname","NA",null,"Vorname"]
["ZMSD","$Steuerpflichtiger.Nachname","$Betrieb.Unternehmensbezeichnung",null,"Unternehmen",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Strasse","$Betrieb.Hauptstrasse.Strasse",null,"Straße",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.PLZ","$Betrieb.Hauptstrasse.PLZ",null,"PLZ",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Ort","$Betrieb.Hauptstrasse.Ort",null,"Ort",""]
["ZMSD","$Steuerpflichtiger.Hauptpostfach.Postfach","$Betrieb.Hauptpostfach.Postfach",null,"Postfach",""]
["ZMSD","$Steuerpflichtiger.Hauptpostfach.PLZ","$Betrieb.Hauptpostfach.PLZ",null,"PLZPostfach",""]
["ZMSD","$Steuerpflichtiger.Hauptpostfach.Ort","$Betrieb.Hauptpostfach.Ort",null,"OrtPostfach",""]
["COPY",null,null,null,"ZSteuernummer",{"$f":"IF(Steuernummer =\"\",\"\",Steuernummer)","v":""}]
["COPY",null,null,null,"ZUGegenstand",{"$f":"IF(UGegenstand=\"\",\"\",UGegenstand)","v":""}]
["COPY",null,null,null,"ZUnternehmen",{"$f":"IF(Titel=\"\",\"\",Titel&\" \")&IF(Vorname=\"\",\"\",Vorname&\" \")&IF(Unternehmen=\"\",\"\",Unternehmen)","v":""}]
["COPY",null,null,null,"ZStraße",{"$f":"IF(Postfach=\"\",IF(Straße=\"\",\"\",Straße), \"Postfach \" & Postfach)","v":""}]
["COPY",null,null,null,"ZPLZOrt",{"$f":"IF(Postfach=\"\",IF(PLZ=\"\",\"\",PLZ & \" \") & IF(Ort=\"\",\"\",Ort),IF(PLZPostfach=\"\",\"\",PLZPostfach & \" \") & IF(OrtPostfach=\"\",\"\",OrtPostfach))","v":""}]
["COPY",null,null,null,"ZOrtDatum",{"$f":"IF(Ort=\"\",\"\",Ort & \", den \" & TEXT(TODAY(),\"TT.MM.JJJJ\"))","v":""}]

{"sheet":"Stammdaten","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Stammdaten"]
["ToolName","Neuanlage eines Mandats"]
["ToolVersion","V.4.5"]
["ToolDatum","(19.11.2018)"]
["ToolInfo",{"$f":"ToolName & \" \" & ToolVersion & \" \" & ToolDatum","v":"Neuanlage eines Mandats V.4.5 (19.11.2018)"}]
["Eingabekontrolle",true]
["FirstRun","23.02.2021"]
["ToolId","VerAntr"]
["ToolKompId","T0000023"]