{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Seite 1","Attribute","Drucken","Einstellungen","Eintragung","Stammdaten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":83,"comments":2,"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":122,"n_cols":65,"rows_kept":122,"cut":false,"hidden":false,"merged":[[14,3,15,59],[8,3,10,59],[11,3,13,59],[0,7,0,16],[3,3,3,24],[4,3,4,24],[5,3,5,24],[3,42,3,60],[4,42,4,60],[93,10,94,39],[29,4,29,16],[29,19,29,59],[23,4,23,10],[23,12,23,59],[25,4,25,59],[27,4,27,59],[39,4,39,59],[45,4,45,59],[19,4,19,59],[21,4,21,59],[4,26,4,41],[101,18,101,22],[116,27,116,59],[116,3,116,24],[31,4,31,43],[31,47,31,59],[51,8,52,54],[113,3,113,59],[87,10,87,59],[84,10,84,59],[36,3,37,59],[98,5,98,33],[41,13,41,26],[38,4,38,59]]}
[1]
[1]
[1,null,null,"An das Finanzamt",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,"gilt nur für das Bundesland"]
[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,"Gläubiger-Identifikationsnummer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(LandListe,LandListe_Auswahl,4)","v":"Baden-Württemberg"}]
[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,{"$f":"INDEX(LandListe,LandListe_Auswahl,5)","v":"DE20FA000000031231"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(LandListe_Auswahl=10,\"Eingangsstempel des FA\",\"\")","v":""}]
[1]
[1]
[1,null,null,"SEPA-Lastschriftmandat",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,{"$f":"IF(Mandantennummer=\"\",FALSE,IF(OR(Land=\"\",Bundesland<>Z_Bundesland),TRUE,FALSE))","v":false}]
[{"$f":"IF(LandListe_Auswahl=2,1,0)","v":0},null,null,"Ich ermächtige/Wir ermächtigen die zuständige Finanzbehörde (Zahlungsempfänger), Zahlungen von meinem/unserem Konto, frühestens zum jeweiligen Fälligkeitstag, mittels Lastschrift einzuziehen. Zugleich weise ich mein/weisen wir unser Kreditinstitut an, die vom Zahlungsempfänger auf mein/unser Konto gezogenen Lastschriften einzulösen."]
[{"$f":"IF(LandListe_Auswahl=2,1,0)","v":0}]
[{"$f":"IF(LandListe_Auswahl=2,1,0)","v":0}]
[{"$f":"IF(LandListe_Auswahl<>2,1,0)","v":1},null,null,"Ich ermächtige/Wir ermächtigen die zuständige Finanzbehörde (Zahlungsempfänger), Zahlungen von meinem/unserem Konto mittels Lastschrift einzuziehen. Zugleich weise ich mein/weisen wir unser Kreditinstitut an, die vom Zahlungsempfänger auf mein/unser Konto gezogenen Lastschriften einzulösen."]
[{"$f":"IF(LandListe_Auswahl<>2,1,0)","v":1}]
[{"$f":"IF(LandListe_Auswahl<>2,1,0)","v":1}]
[1,null,null,"Hinweis: Ich kann/wir können innerhalb von acht Wochen, beginnend mit dem Belastungsdatum, die Erstattung des belasteten Betrags verlangen. Es gelten dabei die mit meinem/unserem Kreditinstitut vereinbarten Bedingungen."]
[1]
[1]
[1,null,null,"Kontoinhaberin/Kontoinhaber"]
[1]
[1]
[1,null,null,null,"Name"]
[1]
[1,null,null,null,"Straße und Hausnummer"]
[1]
[1,null,null,null,"Postleitzahl",null,null,null,null,null,null,null,"Ort"]
[1]
[1,null,null,null,"Land"]
[1]
[1,null,null,null,"IBAN (International Bank Account Number)",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,"(Bitte kein Sparkonto angeben)"]
[1]
[1,null,null,null,"BIC (Business Identifier Code)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name der Bank"]
[1]
[1,null,null,null,"Ort",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,"Datum der Unterschrift"]
[1]
[1]
[1,null,null,null,"Unterschrift(en) des/der Kontoinhaber(s)/Kontoinhaberin"]
[1,null,null,"Zur Teilnahme am SEPA-Lastschriftverfahren sind die Zustimmung zu folgenden Vereinbarungen und Angaben zur Verwendung erforderlich:"]
[1]
[1,null,null,"•","Zur Erleichterung des Zahlungsverkehrs beträgt die Frist für die Information vor Einzug einer fälligen Zahlung mindestens einen Tag vor Belastung. Diese Information entfällt beim Einzug fälliger Beträge aufgrund von Steueranmeldungen."]
[1,null,null,"•","Die Mandatsreferenznummer wird im Steuerbescheid, in einem sonstigen Schreiben und/oder im Kontoauszug des Kreditinstituts mitgeteilt."]
[1]
[1,null,null,null,"Steuernummer"]
[1]
[1,null,null,null,"Sofern abweichend von den Angaben zum/zur Kontoinhaber/in:"]
[1]
[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,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,{"$f":"IF(Mandantennummer=\"\",FALSE,IF(Z_NameSteuerpflichtiger=\"\",FALSE,IF(Z_NameSteuerpflichtiger<>Z_KontoInhaber,TRUE,FALSE)))","v":false}]
[1,null,null,null,"Name des/der Steuerpflichtigen"]
[1]
[1,null,null,null,null,null,null,null,"Das Lastschriftmandat gilt für alle unter der o. a. Steuernummer zu entrichtenden Beträge."]
[1,null,null,null,null,null,null,null,"oder"]
[1]
[1,null,null,null,null,null,null,null,"Das Lastschriftmandat gilt nur für die folgenden unter der o. a. Steuernummer zu entrichtenden Beträge einschließlich steuerlicher Nebenleistungen und Folgesteuern:"]
[1]
[{"$f":"INDEX(LandListe,LandListe_Auswahl,BL54)","v":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,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,6]
[1,null,null,null,null,null,null,null,null,null,"Einkommen-/Körperschaftsteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ohne Abschlusszahlungen",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,6,"Spaltenindex für Anzeige Steuerzeile"]
[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,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,6]
[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,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,7]
[1,null,null,null,null,null,null,null,null,null,"Umsatzsteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ohne Abschlusszahlungen",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,7]
[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,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,7]
[0,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,null,null,10]
[0,null,null,null,null,null,null,null,null,null,"Gewerbesteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ohne Abschlusszahlungen",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,10]
[0,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,null,null,10]
[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,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,8]
[1,null,null,null,null,null,null,null,null,null,"Lohnsteuer",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,8]
[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,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,8]
[0,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,null,null,9]
[0,null,null,null,null,null,null,null,null,null,"Lohnsteuer und Arbeitskammerbeiträge",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,9]
[0,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,null,null,9]
[0,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,null,null,11]
[0,null,null,null,null,null,null,null,null,null,"Kapitalertragsteuer",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,11]
[0,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,null,null,11]
[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,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,12]
[1,null,null,null,null,null,null,null,null,null,"Kapitalertragsteuer und Steuerabzugsbeträge nach § 50a EStG",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,12]
[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,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,12]
[0,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,null,null,15]
[0,null,null,null,null,null,null,null,null,null,"Steuerabzug bei Bauleistungen",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,15]
[0,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,null,null,15]
[0,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,null,null,13]
[0,null,null,null,null,null,null,null,null,null,"Schuldner Kapitalertragsteuer (KapESt)",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,13]
[0,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,null,null,13]
[0,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,null,null,14]
[0,null,null,null,null,null,null,null,null,null,"Arbeitskammerbeiträge",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,14]
[0,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,null,null,14]
[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,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,16]
[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,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,16]
[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,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,16]
[0,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,null,null,17]
[0,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,null,null,17]
[0,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,null,null,17]
[0,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,null,null,18]
[0,null,null,null,null,null,null,null,null,null,"Personensteuern (z. B. Einkommen-/Körperschaftsteuer)",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,"nur Vorauszahlungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[0,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,null,null,18]
[0,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,null,null,19]
[0,null,null,null,null,null,null,null,null,null,"Betriebssteuern (z. B. Umsatzsteuer/Lohnsteuer/ Kapitalertragsteuer/Steuerabzug bei Bauleistungen)",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,"nur Vorauszahlungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[0,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,null,null,19]
[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,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,19]
[1]
[{"$f":"IF(LandListe_Auswahl=3,1,0)","v":0},null,null,null,null,"Optionale Angabe: Ordnungsbegriff zum Nachweis der Abbuchung*"]
[{"$f":"IF(LandListe_Auswahl=3,1,0)","v":0}]
[{"$f":"IF(LandListe_Auswahl=3,1,0)","v":0},null,null,null,null,"* Eigener Ordnungsbegriff, der im Kontoauszug zusätzlich als Verwendungszweck übermittelt wird (z. B. bei Grundsteuer-Fällen die Grundstücksbezeichnung)."]
[0]
[{"$f":"IF(LandListe_Auswahl=10,1,0)","v":0},null,null,null,null,null,null,null,"Das Mandat gilt für ab dem ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fällige Beträge."]
[0]
[0,null,null,null,null,"Das o. a. Konto wird auch für Steuererstattungen verwendet, sofern es sich nicht um einen sonstigen Kontoinhaber handelt."]
[0,null,null,null,null,"Der Kontoinhaber ist"]
[0]
[0,null,null,null,null,null,null,null,null,null,"Steuerpflichtiger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ehegatte/Lebenspartner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eheleute/Partnerschaft"]
[0]
[0,null,null,null,null,null,null,null,null,null,"gesetzlicher Vertreter/Bevollmächtigter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sonstiger Kontoinhaber"]
[0]
[{"$f":"IF(LandListe_Auswahl<>10,1,0)","v":1},null,null,null,null,"Das o.a. Konto wird auch für Steuererstattungen verwendet."]
[1]
[{"$f":"IF(LandListe_Auswahl<>2,1,0)","v":1},null,null,"Unterschrift(en) des/der Steuerpflichtigen und des/der ggf. abweichenden Kontoinhaber(s)/Kontoinhaberin:"]
[{"$f":"IF(LandListe_Auswahl=2,1,0)","v":0},null,null,"Bei abweichendem Kontoinhaber bedarf es der Unterschrift(en) des/der Steuerpflichtigen sowie des/der abweichenden Kontoinhaber(s)/Kontoinhaberin:"]
[1]
[1]
[1,null,null,"Unterschrift(en) des/der Steuerpflichtigen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift(en) des/der abweichenden Kontoinhaber(s)/Kontoinhaberin"]
[1]
[{"$f":"IF(LandListe_Auswahl=10,1,0)","v":0},null,null,"SEPA-Lastschriftmandat - Personen-/Betriebssteuern",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.","Daten in Grunddatei erfasst"]
[{"$f":"IF(LandListe_Auswahl=10,1,0)","v":0},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,"2.","z. d. A.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum, Nz"]
[{"$f":"IF(LandListe_Auswahl<>10,1,0)","v":1},null,null,"SEPA-Lastschriftmandat zum Einzug von Steuern"]
[1]

{"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":2018},"Jahr"]
["KAW010102",{"$f":"IF(FirstRun=\"\",\"\",MONTH(FirstRun))","v":7},"Monat"]
["KAW010103",{"$f":"\"SEPA-Basislastschrift-Mandat\" & IF(Z_FA_Name=\"\",\"\",\" Finanzamt \" & Z_FA_Name)","v":"SEPA-Basislastschrift-Mandat"},"Beschreibung"]
["KAW010105",null,"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,0,"SecurePrint auf bk-printserver (umgeleitet 2)#:11 auf TPVM:",true,true]

{"sheet":"Einstellungen","index":3,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Nummer\n1","Bundesland\n2","Nummer\n3","Bezeichnung\n4","Gläubiger-ID\n5","ESt\n6","USt\n7","LSt_1\n8","LSt_2\n9","GewSt\n10","KapESt_1\n11","KapESt_2\n12","KapESt_3\n13","Kammer\n14","StAb_Bau\n15","Leer_1\n16","Leer_2\n17","PersSt\n18","BetriebsSt\n19",null,"Liste"]
["1","BDW",1,"Baden-Württemberg","DE20FA000000031231",1,1,1,0,0,0,1,0,0,0,1,0,0,0,null,1]
["2","BAY",2,"Bayern","DE13ZZZ00000076365",1,1,1,0,0,0,1,0,0,1,0,0,0,0,null,0]
["3","BER",3,"Berlin","DE02HST00000026026",1,1,1,0,1,0,1,0,0,0,0,0,0,0,null,1]
["4","BBG",4,"Brandenburg","DE19ZZZ00000057730",1,1,1,0,0,0,1,0,0,1,0,0,0,0]
["5","BRE",5,"Bremen","DE12FA000000103834",1,1,1,0,1,1,0,0,0,1,0,0,0,0]
["6","HBG",6,"Hamburg","DE43ZZZ00000037898",1,1,1,0,1,0,1,0,0,0,1,1,0,0]
["7","HES",7,"Hessen","DE31ZZZ00000076720",0,0,0,0,0,0,0,0,0,0,0,0,1,1]
["8","MLB",8,"Mecklenburg-Vorpommern","DE5020000000062119",1,1,1,0,0,0,1,0,0,1,1,0,0,0]
["9","NRS",9,"Niedersachsen","DE77FAE00000137390",1,1,1,0,0,0,1,1,0,1,1,0,0,0]
["10","NRW",10,"Nordrhein-Westfalen","DE14NRW00000098851",0,0,0,0,0,0,0,0,0,0,0,0,1,1]
["11","RLP",11,"Rheinland-Pfalz","DE92LFK00000034688",1,1,1,0,0,0,1,0,0,1,1,1,0,0]
["12","SAR",12,"Saarland","DE53ZZZ00000055566",1,1,0,1,0,0,1,0,1,1,0,0,0,0]
["13","SAC",13,"Sachsen","DE17FA000000032546",1,1,1,0,0,0,1,0,0,1,1,1,0,0]
["14","SAA",14,"Sachsen-Anhalt","DE77ZZZ00000032824",1,1,1,0,0,0,1,0,0,1,0,0,0,0]
["15","SWH",15,"Schleswig-Holstein","DE88FIN00000001392",1,1,1,0,0,0,1,0,0,1,0,0,0,0]
["16","THG",16,"Thüringen","DE03ZZZ00000255025",1,1,1,0,0,0,1,0,0,1,1,1,0,0]

{"sheet":"Eintragung","index":4,"n_rows":37,"n_cols":17,"rows_kept":37,"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.Info.Bezeichnung1","$Betrieb.Hauptfinanzamt.Info.Bezeichnung1",null,"FA_Name",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Korrespondenz.Ort","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.Ort",null,"FA_K_Ort",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Korrespondenz.PLZ","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.PLZ",null,"FA_K_PLZ",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Korrespondenz.Postfach","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.Postfach",null,"FA_K_Postfach",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Info.Korrespondenz.Strasse","$Betrieb.Hauptfinanzamt.Info.Korrespondenz.Strasse",null,"FA_K_Strasse",""]
["ZMSD","$Steuerpflichtiger.Hauptfinanzamt.Steuernummer","$Betrieb.Hauptfinanzamt.Steuernummer",null,"Steuernummer",""]
["ZMSD","$Steuerpflichtiger.TitelAkademischerGrad","NA",null,"Titel"]
["ZMSD","$Steuerpflichtiger.Vorname","NA",null,"Vorname"]
["ZMSD","$Steuerpflichtiger.Nachname","$Betrieb.Unternehmensbezeichnung",null,"Name"]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Strasse","$Betrieb.Hauptstrasse.Strasse",null,"Anschrift",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.PLZ","$Betrieb.Hauptstrasse.PLZ",null,"Postleitzahl",""]
["ZMSD","$Steuerpflichtiger.Hauptstrasse.Ort","$Betrieb.Hauptstrasse.Ort",null,"Ort",""]
["ZMSD","$Steuerpflichtiger.PersoenlicheDaten.Bundesland","$Betrieb.BetrieblicheDaten.Bundesland",null,"Land"]
["ZMSD","$Steuerpflichtiger.Bank[].Bankkonto.Info.Bezeichnung1","$Betrieb.Bank[].Bankkonto.Info.Bezeichnung1","30","Banken_Name",null,1,"","","","","","","","","",""]
["ZMSD","$Steuerpflichtiger.Bank[].Bankkonto.IBAN","$Betrieb.Bank[].Bankkonto.IBAN","30","Banken_IBAN"]
["ZMSD","$Steuerpflichtiger.Bank[].Bankkonto.Info.BIC","$Betrieb.Bank[].Bankkonto.Info.BIC","30","Banken_BIC"]
["ZMSD","$Steuerpflichtiger.Bank[].AbwKontoinhaber","$Betrieb.Bank[].AbwKontoinhaber","30","Banken_AbwName"]
["ZMSD","$Steuerpflichtiger.Hauptbank.Bankkonto.IBAN","$Betrieb.Hauptbank.Bankkonto.IBAN",null,"BankHaupt_IBAN",null,{"$f":"IF(BankHaupt_IBAN<>\"\",IF(ISNA(MATCH(BankHaupt_IBAN,H17:IV17,0)),0,MATCH(BankHaupt_IBAN,H17:IV17,0)),0)","v":0}]
["COPY",null,null,null,"Z_FA_Name",{"$f":"IF(FA_Name=\"\",\"\",FA_Name)","v":""}]
["COPY",null,null,null,"Z_FA_Anschrift",{"$f":"IF(FA_K_Postfach=\"\",IF(FA_K_Strasse=\"\",\"\",FA_K_Strasse),\"Postfach \" & FA_K_Postfach)","v":""}]
["COPY",null,null,null,"Z_FA_PlzOrt",{"$f":"IF(FA_K_PLZ=\"\",\"\",FA_K_PLZ & \" \") & IF(FA_K_Ort=\"\",\"\",FA_K_Ort)","v":""}]
["COPY",null,null,null,"Z_Steuernummer",{"$f":"IF(Steuernummer=\"\",\"\", Steuernummer)","v":""}]
["COPY",null,null,null,"Z_NameSteuerpflichtiger",{"$f":"IF(Banken_AbwName=\"\",\"\",IF(Titel=\"\",\"\",Titel & \" \") & IF(Vorname=\"\",\"\",Vorname & \" \") & IF(Name=\"\",\"\",Name))","v":""}]
["BANK",null,null,null,"Z_NameSteuerpflichtiger",{"$f":"IF(Banken_AbwName=\"\",\"\",IF(Titel=\"\",\"\",Titel & \" \") & IF(Vorname=\"\",\"\",Vorname & \" \") & IF(Name=\"\",\"\",Name))","v":""}]
["COPY",null,null,null,"Z_Anschrift",{"$f":"IF(Anschrift=\"\",\"\",Anschrift)","v":""}]
["COPY",null,null,null,"Z_Postleitzahl",{"$f":"IF(Postleitzahl=\"\",\"\",Postleitzahl & \" \")","v":""}]
["COPY",null,null,null,"Z_Ort",{"$f":"IF(Ort=\"\",\"\",Ort)","v":""}]
["COPY",null,null,null,"Z_Ort2",{"$f":"IF(Ort=\"\",\"\",Ort)","v":""}]
["COPY",null,null,null,"Z_Bundesland",{"$f":"IF(ISNA(VLOOKUP(Land,LandListe_Kurz,3,FALSE)),\"\",VLOOKUP(Land,LandListe_Kurz,3,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP(Land,LandListe_Kurz,2,FALSE)),1,VLOOKUP(Land,LandListe_Kurz,2,FALSE))","v":1}]
["BANK",null,null,null,"Z_BankName",{"$f":"IF(Banken_Name=\"\",\"\",Banken_Name)","v":""}]
["BANK",null,null,null,"Z_IBAN",{"$f":"IF(Banken_IBAN=\"\",\"\",Banken_IBAN)","v":""}]
["BANK",null,null,null,"Z_BIC",{"$f":"IF(Banken_BIC=\"\",\"\",Banken_BIC)","v":""}]
["BANK",null,null,null,"Z_KontoInhaber",{"$f":"IF(Banken_AbwName=\"\",IF(Titel=\"\",\"\",Titel & \" \") & IF(Vorname=\"\",\"\",Vorname & \" \") & IF(Name=\"\",\"\",Name),Banken_AbwName)","v":""}]
["COPY",null,null,null,"Z_Datum_1",{"$f":"TEXT(TODAY(),\"TT.MM.JJJJ\")","v":"20.07.2018"}]
["COPY",null,null,null,"Z_Datum_2",{"$f":"\"\"","v":""}]

{"sheet":"Stammdaten","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Stammdaten"]
["ToolName","Neuanlage eines Mandats"]
["ToolVersion","V.4.3"]
["ToolDatum","(15.05.2017)"]
["ToolInfo",{"$f":"ToolName & \" \" & ToolVersion & \" \" & ToolDatum","v":"Neuanlage eines Mandats V.4.3 (15.05.2017)"}]
["Eingabekontrolle",true]
["FirstRun","20.07.2018"]