{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Abrechnung","Adressierung","NeuesBlatt","Dropdwonlisten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[14,2,14,3],[21,2,21,3],[19,2,19,3],[20,2,20,3],[14,4,14,5],[18,2,18,3],[15,2,15,3],[17,2,17,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],[6,8,6,10],[8,8,8,10],[7,8,7,10],[12,2,12,3],[13,2,13,3],[10,10,11,10],[10,8,11,8],[10,9,11,9],[13,4,13,5],[10,2,11,3],[10,4,11,5],[10,6,11,6],[10,7,11,7],[28,4,28,5],[32,7,35,10],[29,5,30,6],[29,4,30,4],[34,5,35,6],[34,4,35,4],[31,5,33,6],[31,4,33,4],[27,4,27,5],[17,4,17,5],[15,4,15,5],[21,4,21,5],[25,2,25,3],[26,2,26,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[0,0,3,0],[31,0,31,1],[16,2,16,3],[16,4,16,5],[10,0,10,1],[28,2,28,3],[22,4,22,5],[23,4,23,5],[24,4,24,5],[18,4,18,5],[27,2,27,3],[19,4,19,5],[20,4,20,5],[12,4,12,5],[26,4,26,5],[25,4,25,5]]}
["Kantonales Steueramt\nDivision Quellensteuer\nBändliweg 21 / \nPostfach\n8090 Zürich","Abrechnung der Quellensteuer auf Vorsorgeleistungen",null,null,null,null,"Register-Nr."]
[null,"an Personen mit Wohnsitz im Ausland",null,null,null,null,"UID"]
[null,null,null,null,null,null,"Vorsorgeeinrichtung"]
[null,null,null,null,null,null,"Adresse"]
["www.zh.ch/quellensteuer","Abrechnungsperiode           vom",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,"Wohnsitzstaat",null,"Datum der Auszahlung",null,"Steuerbare Leistung (CHF)","Art1\nR, KL","Tarif2\nGT, VT, Grenzgänger","Steuer-satz \n(%)","Quellensteuer \n(CHF)"]
["Name","Vorname"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(H13=\"R\",K13*2%,(IF(K13*1%>50,50,K13*1%))),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I14 = \"DG\",4.5,IF(H14=\"R\",7,K14/G14*100)),\"\")","v":""},{"$f":"QST_RECHNER(G14,H14,I14)","v":""},{"$f":"IFERROR(IF(H14=\"R\",K14*2%,(IF(K14*1%>50,50,IF(K14*1%<-50,-50,K14*1%)))),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,{"$f":"IFERROR(IF(I15 = \"DG\",4.5,IF(H15=\"R\",7,K15/G15*100)),\"\")","v":""},{"$f":"QST_RECHNER(G15,H15,I15)","v":""},""]
[null,null,"",null,null,null,null,null,null,"",{"$f":"QST_RECHNER(G16,H16,I16)","v":""},""]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,"",null,null,null,null,null,null,"",{"$f":"QST_RECHNER(G18,H18,I18)","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,"","",{"$f":"IFERROR(IF(H28=\"R\",K28*2%,(IF(K28*1%>50,50,IF(K28*1%<-50,-50,K28*1%)))),\"\")","v":""}]
["Zeile einfügen"]
["Die Richtigkeit und Vollständigkeit bescheinigt:",null,null,null,"1) Art","R = Rente\nKL = Kapitalleistung",null,null,null,"Total",{"$f":"MROUND(IFERROR(SUM(K13:K29),\"Steuersatz?\"),0.05)","v":0}]
["Ort und Datum:",null,null,null,null,null,null,null,null,"abzüglich Bezugsprovision 3",{"$f":"MROUND(SUM(L13:L29),0.05)","v":0}]
[null,null,null,null,"2) Tarif bei KL","GT = für Alleinstehende (Grundtarif)\nVT = für Verheiratete (Verheiratetentarif)\nDG = für  Grenzgänger Deutschland - Schweiz",null,null,null,"Ablieferungspflichtiger Betrag",{"$f":"K30-K31","v":0}]
["(Stempel und Unterschrift)",null,null,null,null,null,null,"Die Quellensteuerabrechnung ist innert 30 Tagen nach Fälligkeit der Leistung beim Gemeindesteueramt, in welchem die Vorsorgeeinrichtung Sitz oder Betriebsstätte hat, einzureichen. Einzahlung erst auf Rechnung, Einzahlungsschein folgt."]
[]
[null,null,null,null,"3) Bezugsprovision","2% für Renten\n1% bzw. max. CHF 50.- pro KL"]

{"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":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[26,2,26,3],[26,4,26,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],[3,2,3,3],[3,4,3,5],[4,2,4,3],[4,4,4,5],[5,2,5,3],[5,4,5,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],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[22,2,22,3],[22,4,22,5],[9,2,9,3],[9,4,9,5],[10,2,10,3],[10,4,10,5],[14,2,14,3],[14,4,14,5],[11,2,11,3],[11,4,11,5],[12,2,12,3],[12,4,12,5],[13,2,13,3],[13,4,13,5],[24,2,24,3],[24,4,24,5],[25,2,25,3],[25,4,25,5],[17,2,17,3],[17,4,17,5],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,4,20,5],[21,2,21,3],[21,4,21,5],[23,2,23,3],[23,4,23,5]]}
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I1 = \"DG\",4.5,IF(H1=\"R\",7,K1/G1*100)),\"\")","v":""},{"$f":"QST_RECHNER(G1,H1,I1)","v":""},{"$f":"IFERROR(IF(H1=\"R\",K1*2%,(IF(K1*1%>50,50,IF(K1*1%<-50,-50,K1*1%)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(I2 = \"DG\",4.5,IF(H2=\"R\",7,K2/G2*100)),\"\")","v":""},{"$f":"QST_RECHNER(G2,H2,I2)","v":""},{"$f":"IFERROR(IF(H2=\"R\",K2*2%,(IF(K2*1%>50,50,IF(K2*1%<-50,-50,K2*1%)))),\"\")","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,"","",{"$f":"IFERROR(IF(H5=\"R\",K5*2%,(IF(K5*1%>50,50,IF(K5*1%<-50,-50,K5*1%)))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",{"$f":"IFERROR(IF(H7=\"R\",K7*2%,(IF(K7*1%>50,50,IF(K7*1%<-50,-50,K7*1%)))),\"\")","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,"","",{"$f":"IFERROR(IF(H21=\"R\",K21*2%,(IF(K21*1%>50,50,IF(K21*1%<-50,-50,K21*1%)))),\"\")","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,"",{"$f":"QST_RECHNER(G27,H27,I27)","v":""},{"$f":"IFERROR(IF(H27=\"R\",K27*2%,(IF(K27*1%>50,50,IF(K27*1%<-50,-50,K27*1%)))),\"\")","v":""}]

{"sheet":"Dropdwonlisten","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Art","Tarif"]
["R","GT"]
["KL","VT"]
[null,"DG"]