{"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":2,"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":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[27,0,27,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[32,6,34,9],[29,4,29,5],[30,4,34,5],[11,6,12,6],[11,7,12,7],[11,9,12,9],[0,7,0,9],[2,7,2,9],[3,7,3,9],[4,7,4,9],[6,7,6,9],[5,7,5,9],[1,7,1,9],[7,7,7,9],[8,7,8,9],[31,0,31,2],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,8,12,8],[11,5,12,5],[9,7,9,9],[14,0,14,1],[15,0,15,1],[16,0,16,1],[13,0,13,1],[11,0,12,1],[17,0,17,1],[22,0,22,1],[0,0,3,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1]]}
["Kantonales Steueramt\nPrivatpersonen Quellensteuer\nBändliweg 21 / \nPostfach\n8090 Zürich",null,"Abrechnung über die Quellensteuer von geldwerten Vorteilen",null,null,null,"KStA Register-Nr."]
[null,null,"aus exportierten Mitarbeiterbeteiligungen gemäss",null,null,null,"Arbeitgeber-Nr."]
[null,null,"Art. 97a DBG und § 100 StG ZH",null,null,null,"UID"]
[null,null,null,null,null,null,"Arbeitgeber"]
["www.zh.ch/quellensteuer",null,"Abrechnungsperiode vom",null,"bis",null,"Adresse"]
[]
[]
[null,null,null,null,null,null,"Kontaktperson"]
[null,null,null,null,null,null,"Telefon"]
[null,null,null,null,null,null,"E-Mail"]
[]
["\nAHV-Nr.",null,"\nName","\nVorname","\nGeburts-\ndatum","\nWohnort (bei Ausübung)","\nSteuerbare Leistung\n(CHF)","\nSatzbestimmende Leistung \n(CHF)","\nSteuer-satz \n(%)","\nQuellensteuer \n(CHF)"]
[]
[]
[null,null,null,null,null,null,null,null,31.5,{"$f":"IF(G15=\"\",\"\",(ROUND(G15*I15%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,null,31.5,{"$f":"IF(G16=\"\",\"\",(ROUND(G16*I16%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,{"$f":"IF(G23=\"\",\"\",(ROUND(G23*I23%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
["Zeile einfügen"]
["Die Richtigkeit und Vollständigkeit bescheinigt:",null,null,null,"Beilagen:",null,null,null,"Total",{"$f":"SUM(J14:J29)","v":0}]
["Ort und Datum:",null,null,null,"Bescheinigung gemäss Art. 8 der Verordnung über \ndie Bescheinigungspflicht bei Mitarbeiterbeteiligungen \nvom 27.06.2012 (SR 642.115.325.1)",null,null,null,"abzüglich 2% Bezugsprovision",{"$f":"ROUND(J30*2%*20,0)/20","v":0}]
[null,null,null,null,null,null,null,null,"Ablieferungspflichtiger Betrag",{"$f":"J30-J31","v":0}]
["(Stempel und Unterschrift)",null,null,null,null,null,"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":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[[5,0,5,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[17,0,17,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[24,0,24,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1]]}
[null,null,null,null,null,null,null,null,31.5,{"$f":"IF(G1=\"\",\"\",(ROUND(G1*I1%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,{"$f":"IF(G4=\"\",\"\",(ROUND(G4*I4%*20,0)/20))","v":""}]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]
[null,null,null,null,null,null,null,null,31.5,""]