{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Abrechnung","Adressierung","NeuesBlatt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,3,0],[31,0,31,1],[32,6,35,8],[10,5,11,5],[10,6,11,6],[10,8,11,8],[10,0,10,2],[10,4,11,4],[11,2,11,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[6,6,6,8],[8,6,8,8],[7,6,7,8],[10,7,11,7],[0,6,0,8],[1,6,1,8],[2,6,2,8],[3,6,3,8],[5,6,5,8],[4,6,4,8],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3]]}
["Kantonales Steueramt\nPrivatpersonen\nQuellensteuer\nBändliweg 21 / \nPostfach\n8090 Zürich","Abrechnung der Quellensteuer von Verwaltungsrats-",null,null,null,"Register-Nr."]
[null,"entschädigungen an Personen mit Wohnsitz im Ausland",null,null,null,"UID"]
[null,null,null,null,null,"Arbeitgeber"]
[null,null,null,null,null,"Adresse"]
["www.zh.ch/quellensteuer","Abrechnungsperiode vom",null,"bis"]
[]
[null,null,null,null,null,"Kontaktperson"]
[null,null,null,null,null,"Telefon"]
[null,null,null,null,null,"E-Mail"]
[]
["Angaben zur quellensteuerpflichtigen Person",null,null,null,"Beginn \nVR-Mandat","Ende \nVR-Mandat","Steuerbare Leistung (CHF)","Steuer-satz \n(%)","Quellensteuer \n(CHF)"]
["Name","Vorname","Adresse"]
[]
[null,null,null,null,null,null,null,25,{"$f":"IF(G14=\"\",\"\",(ROUND(G14*H14%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,25,{"$f":"IF(G15=\"\",\"\",(ROUND(G15*H15%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
["Zeile einfügen"]
["Die Richtigkeit und Vollständigkeit bescheinigt:",null,null,null,null,null,null,"Total",{"$f":"SUM(I14:I29)","v":0}]
["Ort und Datum:",null,null,null,null,null,null,"abzüglich 2% Bezugsprovision",{"$f":"ROUND(I30*2%*20,0)/20","v":0}]
[null,null,null,null,null,null,null,"Ablieferungspflichtiger Betrag",{"$f":"I30-I31","v":0}]
["(Stempel und Unterschrift)",null,null,null,null,null,"Die Quellensteuerabrechnung ist innert 30 Tagen nach Fälligkeit der Leistung beim Gemeindesteueramt, in welchem die Gesellschaft Sitz oder Betriebsstätte hat, 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":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[[11,2,11,3],[0,2,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[23,2,23,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3]]}
[null,null,null,null,null,null,null,25,{"$f":"IF(G1=\"\",\"\",(ROUND(G1*H1%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,25,{"$f":"IF(G2=\"\",\"\",(ROUND(G2*H2%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]
[null,null,null,null,null,null,null,25,""]