{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Abrechnung","Adressierung","NeuesBlatt","Gemeinden-Kantone"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Abrechnung","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[32,2,32,3],[22,4,22,5],[23,4,23,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,2,29,3],[24,4,24,5],[25,2,25,3],[25,4,25,5],[24,2,24,3],[33,4,33,7],[34,4,38,7],[30,4,30,5],[29,4,29,5],[31,4,31,5],[32,4,32,5],[10,0,10,1],[10,2,10,7],[36,8,38,10],[11,0,12,0],[11,1,12,1],[11,2,12,3],[11,6,12,6],[11,7,12,7],[13,2,13,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[10,8,12,8],[10,10,12,10],[20,2,20,3],[21,2,21,3],[31,2,31,3],[0,8,0,10],[1,8,1,10],[2,8,2,10],[3,8,3,10],[5,8,5,10],[4,8,4,10],[19,4,19,5],[20,4,20,5],[21,4,21,5],[23,2,23,3],[22,2,22,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[0,0,3,0],[35,0,35,1],[6,8,6,10],[8,8,8,10],[7,8,7,10],[10,9,12,9],[19,2,19,3],[11,4,12,5],[13,4,13,5],[15,4,15,5],[16,4,16,5],[18,4,18,5],[17,4,17,5],[14,2,14,3],[14,4,14,5],[30,2,30,3]]}
["Kantonales Steueramt\nDivision Quellensteuer\nBändliweg 21 / \nPostfach\n8090 Zürich","Abrechnung der Quellensteuer auf Hypothekarzinsen",null,null,null,null,"Register-Nr."]
[null,"an Personen mit Wohnsitz im Ausland",null,null,null,null,"UID"]
[null,null,null,null,null,null,"Zinsschuldner"]
[null,null,null,null,null,null,"Adresse"]
["www.zh.ch/quellensteuer","Abrechnungsperiode von",null,"bis"]
[]
[null,null,null,null,null,null,"Kontaktperson"]
[null,null,null,null,null,null,"Telefon"]
[null,null,null,null,null,null,"E-Mail"]
[]
["Angaben zur quellensteuerpflichtigen Person",null,"Adresse der Liegenschaft",null,null,null,null,null,"Steuerbare Leistung (CHF)","Steuer-satz \n(%)","Quellensteuer \n(CHF)"]
["Name, Vorname \noder Firma","Adresse","Gemeinde",null,"Strasse",null,"Nr.","Kanton"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I15=\"\",\"\",(IF(J15=\"\",\"Steuersatz?\",(ROUND(I15*J15%*20,0)/20))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I16=\"\",\"\",(IF(J16=\"\",\"Steuersatz?\",(ROUND(I16*J16%*20,0)/20))))","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,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
["Zeile einfügen",null,null,null,null,null,null,null,null,null,{"$f":"IF(I33=\"\",\"\",I33*J33%)","v":""}]
["Die Richtigkeit und Vollständigkeit bescheinigt:",null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(K14:K33)","v":0}]
["Ort und Datum:",null,null,null,null,null,null,null,null,"abzüglich 2% Bezugsprovision",{"$f":"ROUND(K34*2%*20,0)/20","v":0}]
[null,null,null,null,null,null,null,null,null,"Ablieferungspflichtiger Betrag",{"$f":"K34-K35","v":0}]
["(Stempel und Unterschrift)",null,null,null,null,null,null,null,"Die Quellensteuerabrechnung ist innert 30 Tagen nach Fälligkeit der Leistung beim Gemeindesteueramt, in welchem sich die Liegenschaft befindet, einzureichen. Einzahlung erst auf Rechnung, Einzahlungsschein folgt."]

{"sheet":"Adressierung","index":1,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"IF($A$42=TRUE,\"Adresseingabe zuständiges Steueramt\",\"\")","v":"Adresseingabe zuständiges Steueramt"},{"$f":"IF($A$42=FALSE,\"Adresseingabe zuständiges Steueramt\",\"\")","v":""}]
[null,{"$f":"IF($A$42=TRUE,\"Abteilung\",\"\")","v":"Abteilung"},{"$f":"IF($A$42=FALSE,\"Abteilung\",\"\")","v":""}]
[null,{"$f":"IF($A$42=TRUE,\"Strasse\",\"\")","v":"Strasse"},{"$f":"IF($A$42=FALSE,\"Strasse\",\"\")","v":""}]
[null,{"$f":"IF($A$42=TRUE,\"Postfach\",\"\")","v":"Postfach"},{"$f":"IF($A$42=FALSE,\"Postfach\",\"\")","v":""}]
[null,{"$f":"IF($A$42=TRUE,\"PLZ_Ort\",\"\")","v":"PLZ_Ort"},{"$f":"IF($A$42=FALSE,\"PLZ_Ort\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[true]

{"sheet":"NeuesBlatt","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":true,"merged":[[25,2,25,3],[25,4,25,5],[12,2,12,3],[12,4,12,5],[13,2,13,3],[13,4,13,5],[15,2,15,3],[15,4,15,5],[21,2,21,3],[21,4,21,5],[22,2,22,3],[22,4,22,5],[23,2,23,3],[23,4,23,5],[9,2,9,3],[9,4,9,5],[10,2,10,3],[10,4,10,5],[11,2,11,3],[11,4,11,5],[6,2,6,3],[6,4,6,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[3,2,3,3],[3,4,3,5],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,5],[0,2,0,3],[0,4,0,5],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[26,2,26,3],[26,4,26,5],[14,2,14,3],[14,4,14,5],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[20,2,20,3],[20,4,20,5],[24,2,24,3],[24,4,24,5]]}
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I1=\"\",\"\",(IF(J1=\"\",\"Steuersatz?\",(ROUND(I1*J1%*20,0)/20))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I2=\"\",\"\",(ROUND(I2*J2%*20,0)/20))","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,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Gemeinden-Kantone","index":3,"n_rows":163,"n_cols":3,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["Gemeinden",null,"Kantone"]
["Adlikon",null,"AG"]
["Adliswil",null,"AR"]
["Aesch",null,"AI"]
["Aeugst a.A.",null,"BL"]
["Affoltern a.A.",null,"BS"]
["Altikon",null,"BE"]
["Andelfingen",null,"FR"]
["Bachenbülach",null,"GE"]
["Bachs",null,"GL"]
["Bäretswil",null,"GR"]
["Bassersdorf",null,"JU"]
["Bauma",null,"LU"]
["Benken",null,"NE"]
["Berg a.I.",null,"NW"]
["Birmensdorf",null,"OW"]
["Bonstetten",null,"SG"]
["Boppelsen",null,"SH"]
["Brütten",null,"SZ"]
["Bubikon",null,"SO"]
["Buch a.I.",null,"TI"]
["Buchs",null,"TG"]
["Bülach",null,"UR"]
["Dachsen",null,"VD"]
["Dägerlen",null,"VS"]
["Dällikon",null,"ZH"]
["Dänikon",null,"ZG"]
["Dättlikon"]
["Dielsdorf"]
["Dietikon"]
["Dietlikon"]
["Dinhard"]
["Dorf"]
["Dübendorf"]
["Dürnten"]
["Egg"]
["Eglisau"]
["Elgg"]
["Ellikon a.d.Th."]
["Elsau"]
["Embrach"]
["Erlenbach"]
["Fällanden"]
["Fehraltorf"]
["Feuerthalen"]
["Fischenthal"]
["Flaach"]
["Flurlingen"]
["Freienstein-Teufen"]
["Geroldswil"]
["Glattfelden"]
["Gossau"]
["Greifensee"]
["Grüningen"]
["Hagenbuch"]
["Hausen a.A."]
["Hedingen"]
["Henggart"]
["Herrliberg"]
["Hettlingen"]
["Hinwil"]
["Hittnau"]
["Hochfelden"]
["Hombrechtikon"]
["Horgen"]
["Höri"]
["Humlikon"]
["Hüntwangen"]
["Hüttikon"]
["Illnau-Effretikon"]
["Kappel a.A."]
["Kilchberg"]
["Kleinandelfingen"]
["Kloten"]
["Knonau"]
["Küsnacht"]
["Langnau a.A."]
["Laufen-Uhwiesen"]
["Lindau"]
["Lufingen"]
["Männedorf"]
["Marthalen"]
["Maschwanden"]
["Maur"]
["Meilen"]
["Mettmenstetten"]
["Mönchaltorf"]
["Neerach"]
["Neftenbach"]
["Niederglatt"]
["Niederhasli"]
["Niederweningen"]
["Nürensdorf"]
["Oberembrach"]
["Oberengstringen"]
["Oberglatt"]
["Oberrieden"]
["Oberweningen"]
["Obfelden"]
["Oetwil a.d.L."]
["Oetwil a.S."]
["Opfikon"]
["Ossingen"]
["Otelfingen"]
["Ottenbach"]
["Pfäffikon"]
["Pfungen"]
["Rafz"]
["Regensberg"]
["Regensdorf"]
["Rheinau"]
["Richterswil"]
["Rickenbach"]
["Rifferswil"]
["Rorbas"]
["Rümlang"]
["Rüschlikon"]
["Russikon"]
["Rüti"]
["Schlatt"]
["Schleinikon"]
["Schlieren"]
["Schöfflisdorf"]
["Schwerzenbach"]
["Seegräben"]
["Seuzach"]
["Stadel"]
["Stäfa"]
["Stallikon"]
["Stammheim"]
["Steinmaur"]
["Thalheim a.d.Th."]
["Thalwil"]
["Trüllikon"]
["Truttikon"]
["Turbenthal"]
["Uetikon a.S."]
["Uitikon"]
["Unterengstringen"]
["Urdorf"]
["Uster"]
["Volken"]
["Volketswil"]
["Wädenswil"]
["Wald"]
["Wallisellen"]
["Wangen-Brüttisellen"]
["Wasterkingen"]
["Weiach"]
["Weiningen"]
["Weisslingen"]
["Wettswil a.A."]
["Wetzikon"]
["Wiesendangen"]
["Wil"]
["Wila"]
["Wildberg"]
["Winkel"]
["Winterthur"]
["Zell"]
["Zollikon"]
["Zumikon"]
["Zürich"]