{"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":5,"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":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,3,0],[10,7,11,7],[10,8,11,8],[10,0,11,0],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[34,0,34,2],[0,11,0,13],[1,11,1,13],[2,11,2,13],[3,11,3,13],[5,11,5,13],[4,11,4,13],[10,13,11,13],[6,11,6,13],[8,11,8,13],[7,11,7,13],[10,12,11,12],[10,5,10,6],[10,9,11,9],[10,10,11,10],[10,11,11,11],[35,5,36,6],[35,7,36,9],[35,4,36,4],[32,4,34,4],[35,10,37,13],[32,5,34,5]]}
["Kantonales Steueramt\nPrivatpersonen\nQuellensteuer\nBändliweg 21 / \nPostfach\n8090 Zürich",null,"Abrechnung der Quellensteuer auf Gagen von Künstlern,",null,null,null,null,null,null,null,"Register-Nr."]
[null,null,"Sportlern und Referenten mit Wohnsitz im Ausland",null,null,null,null,null,null,null,"UID"]
[null,null,null,null,null,null,null,null,null,null,"Veranstalter"]
[null,null,null,null,null,null,null,null,null,null,"Adresse"]
["www.zh.ch/quellensteuer",null,null,"Abrechnungsperiode","vom",null,"bis"]
[]
[null,null,null,null,null,null,null,null,null,null,"Kontaktperson"]
[null,null,null,null,null,null,null,null,null,null,"Telefon"]
[null,null,null,null,null,null,null,null,null,null,"E-Mail"]
[]
["\nName bzw. Künstler- oder Gruppenname","\nVorname oder Zusatz","\nWohn-sitz-\nstaat","\nK, S, R1","\nAnzahl Perso-nen","\nAuftrittsort",null,"\nAuftritts- und Probetage","\nBruttoentschädigung inkl. aller Zulagen \n(CHF)","\nAbzüglich Gewinnungskosten \n(CHF)2","\nSteuerbare Leistung\n(CHF)","\nDurchschnittliche Tageseinkünfte \n(CHF)","\nSteuer-satz \n(%)","\nQuellensteuer \n(CHF)"]
[null,null,null,null,null,"Gemeinde","Kanton"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I13=0,\"\",IF(D13=\"K\",I13*50%,I13*20%))","v":""},{"$f":"IF(J13=\"\",\"\",I13-J13)","v":""},{"$f":"IF(AND(H13=0,I13<>0),\"Anz.Tage?\",\nIF(OR(E13=0,I13=0),\"\",ROUND(K13/(H13*E13),0)))","v":""},{"$f":"IF(L13=\"\",\"\",IF(L13>3001,17,IF(L13>1001,15,IF(L13>201,12.4,10.8))))","v":""},{"$f":"IF(J13=\"\",\"\",K13/100*M13)","v":""}]
[null,null,null,null,null,null,"ZH",null,null,{"$f":"IF(I14=0,\"\",IF(D14=\"K\",I14*50%,I14*20%))","v":""},{"$f":"IF(J14=\"\",\"\",I14-J14)","v":""},{"$f":"IF(AND(H14=0,I14<>0),\"Anz.Tage?\",\nIF(OR(E14=0,I14=0),\"\",ROUNDDOWN(K14/(H14*E14),0)))","v":""},{"$f":"QST_STEUERSATZ(L14)","v":""},{"$f":"IFERROR(QST_RECHNER(K14,M14),\"\")","v":""},{"$f":"IF(OR(D14=\"\",E14=\"\",H14=\"\",I14=\"\")=TRUE,\"unvollständig\",\"OK\")","v":"unvollständig"}]
[null,null,null,null,null,null,"ZH",null,null,{"$f":"IF(I15=0,\"\",IF(D15=\"K\",I15*50%,I15*20%))","v":""},{"$f":"IF(J15=\"\",\"\",I15-J15)","v":""},{"$f":"IF(AND(H15=0,I15<>0),\"Anz.Tage?\",\nIF(OR(E15=0,I15=0),\"\",ROUNDDOWN(K15/(H15*E15),0)))","v":""},{"$f":"QST_STEUERSATZ(L15)","v":""},{"$f":"IFERROR(QST_RECHNER(K15,M15),\"\")","v":""},{"$f":"IF(OR(D15=\"\",E15=\"\",H15=\"\",I15=\"\")=TRUE,\"unvollständig\",\"OK\")","v":"unvollständig"}]
[null,null,null,null,null,null,"ZH",null,null,"","",{"$f":"IF(AND(H16=0,I16<>0),\"Anz.Tage?\",\nIF(OR(E16=0,I16=0),\"\",ROUNDDOWN(K16/(H16*E16),0)))","v":""},{"$f":"QST_STEUERSATZ(L16)","v":""},{"$f":"IFERROR(QST_RECHNER(K16,M16),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L17)","v":""},{"$f":"IFERROR(QST_RECHNER(K17,M17),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L18)","v":""},{"$f":"IFERROR(QST_RECHNER(K18,M18),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L19)","v":""},{"$f":"IFERROR(QST_RECHNER(K19,M19),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L20)","v":""},{"$f":"IFERROR(QST_RECHNER(K20,M20),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L21)","v":""},{"$f":"IFERROR(QST_RECHNER(K21,M21),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L22)","v":""},{"$f":"IFERROR(QST_RECHNER(K22,M22),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L23)","v":""},{"$f":"IFERROR(QST_RECHNER(K23,M23),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L24)","v":""},{"$f":"IFERROR(QST_RECHNER(K24,M24),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L25)","v":""},{"$f":"IFERROR(QST_RECHNER(K25,M25),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,{"$f":"IF(I26=0,\"\",IF(D26=\"K\",I26*50%,I26*20%))","v":""},{"$f":"IF(J26=\"\",\"\",I26-J26)","v":""},"",{"$f":"QST_STEUERSATZ(L26)","v":""},{"$f":"IFERROR(QST_RECHNER(K26,M26),\"\")","v":""},{"$f":"IF(OR(D26=\"\",E26=\"\",H26=\"\",I26=\"\")=TRUE,\"unvollständig\",\"OK\")","v":"unvollständig"}]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L27)","v":""},{"$f":"IFERROR(QST_RECHNER(K27,M27),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L28)","v":""},{"$f":"IFERROR(QST_RECHNER(K28,M28),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L29)","v":""},{"$f":"IFERROR(QST_RECHNER(K29,M29),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L30)","v":""},{"$f":"IFERROR(QST_RECHNER(K30,M30),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L31)","v":""},{"$f":"IFERROR(QST_RECHNER(K31,M31),\"\")","v":""},"unvollständig"]
["Zeile einfügen"]
["Die Richtigkeit und Vollständigkeit bescheinigt:",null,null,null,"1)\n\n","K = Künstler\nS = Sportler\nR = Referenten",null,null,null,null,null,null,"Total",{"$f":"SUM(N13:N32)","v":0}]
["Ort und Datum:",null,null,null,null,null,null,null,null,null,null,null,"abzüglich 2% Bezugsprovision",{"$f":"ROUND(N33*2%*20,0)/20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ablieferungspflichtiger Betrag",{"$f":"N33-N34","v":0}]
["(Stempel und Unterschrift)",null,null,null,"2)\n","Künstler\nSportler, Referenten",null,"-50% der Bruttoentschädigung inkl. aller Zulagen\n-20% der Bruttoentschädigung inkl. aller Zulagen",null,null,"Die Quellensteuerabrechnung ist innert 30 Tagen nach Fälligkeit der Leistung beim Gemeindesteueramt des Auftrittsortes einzureichen. \nEinzahlung 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":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"ZH",null,null,{"$f":"IF(I1=0,\"\",IF(D1=\"K\",I1*50%,I1*20%))","v":""},{"$f":"IF(J1=\"\",\"\",I1-J1)","v":""},{"$f":"IF(AND(H1=0,I1<>0),\"Anz.Tage?\",\nIF(OR(E1=0,I1=0),\"\",ROUNDDOWN(K1/(H1*E1),0)))","v":""},{"$f":"QST_STEUERSATZ(L1)","v":""},{"$f":"IFERROR(QST_RECHNER(K1,M1),\"\")","v":""},{"$f":"IF(OR(D1=\"\",E1=\"\",H1=\"\",I1=\"\")=TRUE,\"unvollständig\",\"OK\")","v":"unvollständig"}]
[null,null,null,null,null,null,"ZH",null,null,{"$f":"IF(I2=0,\"\",IF(D2=\"K\",I2*50%,I2*20%))","v":""},{"$f":"IF(J2=\"\",\"\",I2-J2)","v":""},{"$f":"IF(AND(H2=0,I2<>0),\"Anz.Tage?\",\nIF(OR(E2=0,I2=0),\"\",ROUNDDOWN(K2/(H2*E2),0)))","v":""},{"$f":"QST_STEUERSATZ(L2)","v":""},{"$f":"IFERROR(QST_RECHNER(K2,M2),\"\")","v":""},{"$f":"IF(OR(D2=\"\",E2=\"\",H2=\"\",I2=\"\")=TRUE,\"unvollständig\",\"OK\")","v":"unvollständig"}]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L3)","v":""},{"$f":"IFERROR(QST_RECHNER(K3,M3),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L4)","v":""},{"$f":"IFERROR(QST_RECHNER(K4,M4),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L5)","v":""},{"$f":"IFERROR(QST_RECHNER(K5,M5),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L6)","v":""},{"$f":"IFERROR(QST_RECHNER(K6,M6),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L7)","v":""},{"$f":"IFERROR(QST_RECHNER(K7,M7),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L8)","v":""},{"$f":"IFERROR(QST_RECHNER(K8,M8),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L9)","v":""},{"$f":"IFERROR(QST_RECHNER(K9,M9),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L10)","v":""},{"$f":"IFERROR(QST_RECHNER(K10,M10),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L11)","v":""},{"$f":"IFERROR(QST_RECHNER(K11,M11),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L12)","v":""},{"$f":"IFERROR(QST_RECHNER(K12,M12),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L13)","v":""},{"$f":"IFERROR(QST_RECHNER(K13,M13),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L14)","v":""},{"$f":"IFERROR(QST_RECHNER(K14,M14),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L15)","v":""},{"$f":"IFERROR(QST_RECHNER(K15,M15),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L16)","v":""},{"$f":"IFERROR(QST_RECHNER(K16,M16),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L17)","v":""},{"$f":"IFERROR(QST_RECHNER(K17,M17),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L18)","v":""},{"$f":"IFERROR(QST_RECHNER(K18,M18),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L19)","v":""},{"$f":"IFERROR(QST_RECHNER(K19,M19),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L20)","v":""},{"$f":"IFERROR(QST_RECHNER(K20,M20),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L21)","v":""},{"$f":"IFERROR(QST_RECHNER(K21,M21),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L22)","v":""},{"$f":"IFERROR(QST_RECHNER(K22,M22),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L23)","v":""},{"$f":"IFERROR(QST_RECHNER(K23,M23),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L24)","v":""},{"$f":"IFERROR(QST_RECHNER(K24,M24),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L25)","v":""},{"$f":"IFERROR(QST_RECHNER(K25,M25),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L26)","v":""},{"$f":"IFERROR(QST_RECHNER(K26,M26),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L27)","v":""},{"$f":"IFERROR(QST_RECHNER(K27,M27),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L28)","v":""},{"$f":"IFERROR(QST_RECHNER(K28,M28),\"\")","v":""},"unvollständig"]
[null,null,null,null,null,null,"ZH",null,null,"","","",{"$f":"QST_STEUERSATZ(L29)","v":""},{"$f":"IFERROR(QST_RECHNER(K29,M29),\"\")","v":""},"unvollständig"]

{"sheet":"Dropdwonlisten","index":3,"n_rows":163,"n_cols":2,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["Gemeinden","K, S, R"]
["Adlikon","K"]
["Adliswil","S"]
["Aesch","R"]
["Aeugst a.A."]
["Affoltern a.A."]
["Altikon"]
["Andelfingen"]
["Bachenbülach"]
["Bachs"]
["Bäretswil"]
["Bassersdorf"]
["Bauma"]
["Benken"]
["Berg a.I."]
["Birmensdorf"]
["Bonstetten"]
["Boppelsen"]
["Brütten"]
["Bubikon"]
["Buch a.I."]
["Buchs"]
["Bülach"]
["Dachsen"]
["Dägerlen"]
["Dällikon"]
["Dänikon"]
["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"]