{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Abrechnung","Adressierung","NeuesBlatt","Dropdownlisten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,14,5,19],[6,14,6,19],[7,14,7,19],[8,14,8,19],[9,14,9,19],[0,14,0,19],[1,14,1,19],[2,14,2,19],[3,14,3,19],[4,14,4,19],[20,2,20,3],[13,5,13,7],[14,5,14,7],[4,5,4,6],[4,8,4,10],[13,2,13,3],[14,2,14,3],[11,2,11,3],[11,5,11,7],[15,5,15,7],[19,5,19,7],[0,0,3,0],[0,2,2,10],[34,14,37,19],[15,2,15,3],[33,0,33,2],[16,2,16,3],[16,5,16,7],[17,2,17,3],[18,2,18,3],[19,2,19,3],[28,2,28,3],[23,2,23,3],[21,2,21,3],[27,2,27,3],[36,5,37,11],[29,2,29,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[22,2,22,3],[22,5,22,7],[27,5,27,7],[32,5,35,11],[31,5,31,11],[17,5,17,7],[18,5,18,7],[28,5,28,7],[23,5,23,7],[21,5,21,7],[26,5,26,7],[29,5,29,7],[24,5,24,7],[25,5,25,7],[20,5,20,7],[11,13,11,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[12,13,12,14],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[26,13,26,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[21,13,21,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[25,13,25,14]]}
[null,null,"Abrechnung über die Quellensteuern \nfür Lohn- und Ersatzeinkünfte",null,null,null,null,null,null,null,null,null,"SSL-Nr."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"UID"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Arbeitgeber/Versicherer"]
[null,null,"Abrechnungsperiode vom",null,null,null,null,"bis",null,null,null,null,"Adresse",null,null,null,null,null,null,null,{"$f":"YEAR($F$5)","v":1900},{"$f":"YEAR($I$5)","v":1900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V5=U5,\"OK\",\"Nein\")","v":"OK"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kontaktperson"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Telefon"]
[null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail"]
[]
["\nAHV-Nr.","\nName","\nVorname",null,"\nGeburts-datum","\nanspruchs-\nberechtigte\nGemeinde",null,null,"\nKT1","\nMG2","\nMutations-datum","\nMt. \n(1-12)","\nBruttolohn steuerbar","\nBruttolohn satzbestim-mend",null,"\nT3","\nK4","\nKi-St.5","\nSteuer-satz\n%","\nQuellensteuer (CHF)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M14=\"\",\"\",(ROUND(M14*S14%*20,0)/20))","v":""},{"$f":"IF(OR(AND(ISBLANK(A14),(OR(ISBLANK(B14),ISBLANK(C14),ISBLANK(E14)))),F14=\"\",I14=\"\",L14=\"\",M14=\"\",N14=\"\",P14=\"\",Q14=\"\",R14=\"\",S14=\"\",V14=\"Datum eingeben\"),\"unvollständig\",\"OK\")","v":"unvollständig"},{"$f":"IF(AND(J14<>\"\",K14=\"\"),\"Datum eingeben\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K15<>\"\",MONTH(K15),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(M15=\"\",\"\",(ROUND(M15*S15%*20,0)/20))","v":""},{"$f":"IF(OR(AND(ISBLANK(A15),(OR(ISBLANK(B15),ISBLANK(C15),ISBLANK(E15)))),F15=\"\",I15=\"\",L15=\"\",M15=\"\",N15=\"\",P15=\"\",Q15=\"\",R15=\"\",S15=\"\",V15=\"Datum eingeben\"),\"unvollständig\",\"OK\")","v":"unvollständig"},{"$f":"IF(AND(J15<>\"\",K15=\"\"),\"Datum eingeben\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig",{"$f":"IF(AND(J22<>\"\",K22=\"\"),\"Datum eingeben\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig",{"$f":"IF(AND(J23<>\"\",K23=\"\"),\"Datum eingeben\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
["Zeile einfügen"]
["Die Richtigkeit und Vollständigkeit bescheinigt:",null,null,null,null,"Erläuterungen:",null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(T14:T31)","v":0}]
["Ort und Datum:",null,null,null,null,"1) Wohnkanton / Grenzgänger: Kanton Arbeitsort\n2) E / A = Eintritt / Austritt\n3) Tarif = angewandter Tarif (A-Q) einsetzen\n4) Kinder = Anzahl Kinderabzüge einsetzen\n5) Ki-St. = \"Y\" mit Kirchensteuer oder \"N\" ohne Kirchensteuer",null,null,null,null,null,null,null,null,null,null,null,null,"abzüglich 1% Bezugsprovision",{"$f":"ROUND(T32*1%*20,0)/20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ablieferungspflichtiger Betrag",{"$f":"T32-T33","v":0}]
["(Stempel und Unterschrift)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Einzahlung erst auf Rechnung. Einzahlungsschein folgt.\n\nEinreichen an: quellensteuer@ur.ch"]
[]
[null,null,null,null,null,"Pro Monat jede Zeile vollständig ausfüllen."]

{"sheet":"Adressierung","index":1,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Amt für Steuern","Amt für Steuern"]
[null,"Quellensteuer","Quellensteuer"]
[null,"Tellsgasse 1","Tellsgasse 1"]
[null,"Postfach 950","Postfach 950"]
[null,"6460 Altdorf","6460 Altdorf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[false]

{"sheet":"NeuesBlatt","index":2,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":true,"merged":[[28,2,28,3],[28,5,28,7],[28,13,28,14],[26,2,26,3],[26,5,26,7],[26,13,26,14],[27,2,27,3],[27,5,27,7],[27,13,27,14],[24,2,24,3],[24,5,24,7],[24,13,24,14],[25,2,25,3],[25,5,25,7],[25,13,25,14],[22,2,22,3],[22,5,22,7],[22,13,22,14],[23,2,23,3],[23,5,23,7],[23,13,23,14],[20,5,20,7],[20,13,20,14],[21,2,21,3],[21,5,21,7],[21,13,21,14],[19,2,19,3],[19,5,19,7],[19,13,19,14],[20,2,20,3],[11,13,11,14],[12,13,12,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[17,2,17,3],[17,5,17,7],[17,13,17,14],[18,2,18,3],[18,5,18,7],[18,13,18,14],[6,13,6,14],[7,13,7,14],[8,13,8,14],[9,13,9,14],[10,13,10,14],[1,13,1,14],[2,13,2,14],[3,13,3,14],[4,13,4,14],[0,13,0,14],[5,13,5,14],[11,2,11,3],[1,2,1,3],[1,5,1,7],[2,2,2,3],[2,5,2,7],[11,5,11,7],[6,2,6,3],[6,5,6,7],[7,2,7,3],[7,5,7,7],[8,2,8,3],[8,5,8,7],[9,2,9,3],[9,5,9,7],[10,2,10,3],[0,2,0,3],[0,5,0,7],[3,2,3,3],[3,5,3,7],[4,2,4,3],[4,5,4,7],[16,2,16,3],[16,5,16,7],[12,2,12,3],[12,5,12,7],[13,2,13,3],[13,5,13,7],[14,2,14,3],[14,5,14,7],[5,2,5,3],[5,5,5,7],[10,5,10,7],[15,2,15,3],[15,5,15,7]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K1<>\"\",MONTH(K1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(M1=\"\",\"\",(ROUND(M1*S1%*20,0)/20))","v":""},{"$f":"IF(OR(AND(ISBLANK(A1),(OR(ISBLANK(B1),ISBLANK(C1),ISBLANK(E1)))),F1=\"\",I1=\"\",L1=\"\",M1=\"\",N1=\"\",P1=\"\",Q1=\"\",R1=\"\",S1=\"\",V1=\"Datum eingeben\"),\"unvollständig\",\"OK\")","v":"unvollständig"},{"$f":"IF(AND(J1<>\"\",K1=\"\"),\"Datum eingeben\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K2<>\"\",MONTH(K2),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(M2=\"\",\"\",(ROUND(M2*S2%*20,0)/20))","v":""},{"$f":"IF(OR(AND(ISBLANK(A2),(OR(ISBLANK(B2),ISBLANK(C2),ISBLANK(E2)))),F2=\"\",I2=\"\",L2=\"\",M2=\"\",N2=\"\",P2=\"\",Q2=\"\",R2=\"\",S2=\"\",V2=\"Datum eingeben\"),\"unvollständig\",\"OK\")","v":"unvollständig"},{"$f":"IF(AND(J2<>\"\",K2=\"\"),\"Datum eingeben\",\"OK\")","v":"OK"}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","unvollständig","OK"]

{"sheet":"Dropdownlisten","index":3,"n_rows":163,"n_cols":5,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["Gemeinden","Kantone","Mutationsgrund","Tarife","Kirchensteuer"]
["Adlikon","AG","E","A","Y"]
["Adliswil","AR","A","B","N"]
["Aesch","AI",null,"C"]
["Aeugst a.A.","BL",null,"D"]
["Affoltern a.A.","BS",null,"G"]
["Altikon","BE",null,"H"]
["Andelfingen","FR",null,"L"]
["Bachenbülach","GE",null,"M"]
["Bachs","GL",null,"N"]
["Bäretswil","GR",null,"O"]
["Bassersdorf","JU",null,"P"]
["Bauma","LU",null,"Q"]
["Benken","NE"]
["Berg a.I.","NW"]
["Birmensdorf","OW"]
["Bonstetten","SG"]
["Boppelsen","SH"]
["Brütten","SZ"]
["Bubikon","SO"]
["Buch a.I.","TI"]
["Buchs","TG"]
["Bülach","UR"]
["Dachsen","VD"]
["Dägerlen","VS"]
["Dällikon","ZH"]
["Dänikon","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"]