2019新个税工资表模板.xls

公司部门社保费代扣率年度月份 公司1部门1养老保险8 20181 公司2部门2医疗保险2 420192 公司3部门3失业保险0 50 20203 公司4部门4年金20214 公司5部门5住房公积金8 20225 公司6部门66 部门77 部门88 部门99 部门1010 11 12 级数累计预扣预缴应纳税所得额预扣率速算扣除数 1 96000045 181920 级数全月应纳税所得额下限上限税率速算扣除数 一级3000 x 3 000 003 0 二级3000 x 120003 000 0012 000 0010 210 三级12000 x 2500012 000 0025 000 0020 1410 四级25000 x 3500025 000 0035 000 0025 2660 五级35000 x 5500035 000 0055 000 0030 4410 六级55000 x 8000055 000 0080 000 0035 7160 七级80000 x80 000 0045 15160 序序号号姓姓名名身身份份证证号号公公司司部部门门入入职职时时间间年年薪薪基基本本工工资资 1 张三320700000000001公司1 部门12015 6 1500 000 0040 000 00 2 李四320700000000002公司1 部门12015 6 2100 000 008 000 00 3 王二麻子320700000000003公司1 部门22015 6 3100 000 008 000 00 4 赵大320700000000002公司2 部门72015 6 4100 000 008 000 00 5 胡五320700000000003公司2 部门62015 6 5100 000 008 000 00 6 陈六320700000000002公司3 部门62015 6 6100 000 008 000 00 7 8 9 10 11 12 司司龄龄工工资资通通讯讯补补贴贴过过节节费费应应税税收收入入合合计计差差旅旅补补贴贴 200 003 000 00400 0043 600 00200 00 200 003 000 00400 0011 600 00200 00 200 003 000 00400 0011 600 00200 00 200 003 000 00400 0011 600 00200 00 200 003 000 00400 0011 600 00200 00 200 003 000 00400 0011 600 00200 00 免免税税收收入入合合计计考考核核餐餐补补履履职职保保证证金金扣扣款款项项合合计计 200 00200 00400 00300 00900 00 200 00200 00400 00300 00900 00 200 00200 00400 00300 00900 00 200 00200 00400 00300 00900 00 200 00200 00400 00300 00900 00 200 00200 00400 00300 00900 00 应应发发工工资资合合计计减减除除费费用用养养老老保保险险医医疗疗保保险险失失业业保保险险 42 900 005 000 00200 00300 00400 00 10 900 005 000 00200 00300 00400 00 10 900 005 000 00200 00300 00400 00 10 900 005 000 00200 00300 00400 00 10 900 005 000 00200 00300 00400 00 10 900 005 000 00200 00300 00400 00 公公积积金金专专项项扣扣除除合合计计子子女女教教育育继继续续教教育育大大病病医医疗疗 500 001 400 001 000 006 000 00 500 001 400 001 000 006 000 00 500 001 400 001 000 006 000 00 500 001 400 001 000 006 000 00 500 001 400 001 000 006 000 00 500 001 400 001 000 006 000 00 住住房房贷贷款款利利息息住住房房租租金金赡赡养养老老人人专专项项附附加加扣扣除除合合计计扣扣除除合合计计 1 000 008 000 009 400 00 1 000 008 000 009 400 00 1 000 008 000 009 400 00 1 000 008 000 009 400 00 1 000 008 000 009 400 00 1 000 008 000 009 400 00 自定义页眉 序序号号所所属属年年度度月月份份公公司司部部门门姓姓名名身身份份证证件件号号码码年年薪薪基基本本工工资资 120191公司1部门1张三320700000000001500 000 0040 000 00 220191公司3部门6陈六320700000000002100 000 008 000 00 320191公司2部门7赵大320700000000002100 000 008 000 00 420191公司1部门2王二麻子320700000000003100 000 008 000 00 520192公司1部门1张三320700000000001500 000 0040 000 00 620192公司3部门6陈六320700000000002100 000 008 000 00 720192公司2部门7赵大320700000000002100 000 008 000 00 820192公司1部门2王二麻子320700000000003100 000 008 000 00 920193公司1部门1张三320700000000001500 000 0040 000 00 1020193公司3部门6陈六320700000000002100 000 008 000 00 1120193公司2部门7赵大320700000000002100 000 008 000 00 1220193公司1部门2王二麻子320700000000003100 000 008 000 00 1320194公司1部门1张三320700000000001500 000 0040 000 00 1420194公司3部门6陈六320700000000002100 000 008 000 00 1520194公司2部门7赵大320700000000002100 000 008 000 00 1620194公司1部门2王二麻子320700000000003100 000 008 000 00 1720195公司1部门1张三320700000000001500 000 0040 000 00 1820195公司3部门6陈六320700000000002100 000 008 000 00 1920195公司2部门7赵大320700000000002100 000 008 000 00 2020195公司1部门2王二麻子320700000000003100 000 008 000 00 2120196公司1部门1张三320700000000001500 000 0040 000 00 2220196公司3部门6陈六320700000000002200 000 008 000 00 2320196公司2部门7赵大320700000000002100 000 008 000 00 2420196公司1部门2王二麻子320700000000003100 000 008 000 00 2520201公司1部门1张三320700000000001500 000 0040 000 00 2620201公司3部门6陈六320700000000002100 000 008 000 00 2720201公司2部门7赵大320700000000002100 000 008 000 00 2820201公司1部门2王二麻子320700000000003100 000 008 000 00 自定义页眉 司司龄龄工工资资通通讯讯补补贴贴过过节节费费应应税税收收入入5 5应应税税收收入入6 6应应税税收收入入7 7应应税税收收入入8 8应应税税收收入入9 9应应税税收收入入合合计计差差旅旅补补贴贴 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 4 43 3 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 200 003 000 00400 00 1 11 1 6 60 00 0 0 00 0200 00 自定义页眉 免免税税收收入入合合计计考考核核餐餐补补履履职职保保证证金金其其他他扣扣款款项项5 5扣扣款款项项6 6扣扣款款项项7 7扣扣款款项项8 8扣扣款款项项9 9扣扣款款项项合合计计 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 2 20 00 0 0 00 0200 00400 00300 00 9 90 00 0 0 00 0 自定义页眉 应应发发工工资资合合计计减减除除费费用用养养老老保保险险医医疗疗保保险险失失业业保保险险公公积积金金 其其他他专专项项扣扣除除 1 1 其其他他专专项项扣扣除除 2 2 其其他他专专项项扣扣除除 3 3 其其他他专专项项扣扣除除 4 4 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 4 42 2 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 1 10 0 9 90 00 0 0 00 05 000 00200 00300 00400 00500 00 自定义页眉 其其他他专专项项扣扣除除 5 5 专专项项扣扣除除合合计计子子女女教教育育继继续续教教育育大大病病医医疗疗住住房房贷贷款款利利息息住住房房租租金金赡赡养养老老人人 其其他他专专项项附附加加 扣扣除除1 1 其其他他专专项项附附加加 扣扣除除2 2 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 1 1 4 40 00 0 0 00 01 000 006 000 00 1 000 00 自定义页眉 其其他他专专项项附附加加 扣扣除除3 3 其其他他专专项项附附加加 扣扣除除4 4 其其他他专专项项附附加加 扣扣除除5 5 专专项项附附加加扣扣除除合合 计计 累累计计收收入入累累计计免免税税收收入入累累计计减减除除费费用用累累计计专专项项扣扣除除 累累计计专专项项附附加加 扣扣除除 8 8 0 00 00 0 0 00 042 900 00200 005 000 001 400 008 000 00 8 8 0 00 00 0 0 00 010 900 00200 005 000 001 400 008 000 00 8 8 0 00 00 0 0 00 010 900 00200 005 000 001 400 008 000 00 8 8 0 00 00 0 0 00 010 900 00200 005 000 001 400 008 000 00 8 8 0 00 00 0 0 00 085 800 00400 0010 000 002 800 0016 000 00 8 8 0 00 00 0 0 00 021 800 00400 0010 000 002 800 0016 000 00 8 8 0 00 00 0 0 00 021 800 00400 0010 000 002 800 0016 000 00 8 8 0 00 00 0 0 00 021 800 00400 0010 000 002 800 0016 000 00 8 8 0 00 00 0 0 00 0128 700 00600 0015 000 004 200 0024 000 00 8 8 0 00 00 0 0 00 032 700 00600 0015 000 004 200 0024 000 00 8 8 0 00 00 0 0 00 032 700 00600 0015 000 004 200 0024 000 00 8 8 0 00 00 0 0 00 032 700 00600 0015 000 004 200 0024 000 00 8 8 0 00 00 0 0 00 0171 600 00800 0020 000 005 600 0032 000 00 8 8 0 00 00 0 0 00 043 600 00800 0020 000 005 600 0032 000 00 8 8 0 00 00 0 0 00 043 600 00800 0020 000 005 600 0032 000 00 8 8 0 00 00 0 0 00 043 600 00800 0020 000 005 600 0032 000 00 8 8 0 00 00 0 0 00 0214 500 001 000 0025 000 007 000 0040 000 00 8 8 0 00 00 0 0 00 054 500 001 000 0025 000 007 000 0040 000 00 8 8 0 00 00 0