2020年度工资表模板

20192019年年0101月月工工资资表表 填填报报单单位位 1 1 员工编号部门姓名岗位 工资部分福利补贴 加班费考勤扣款工工资资总总额额免免征征额额 代缴五险一金专项扣除 合计当当月月扣扣除除应应税税所所得得额额代扣个税实实发发工工资资工工资资累累计计扣扣除除累累计计前前0 0个个月月个个税税累累计计 基本工资奖金及提成合计午餐补贴交通补贴通讯补贴出差补助合计养老保险医疗保险失业保险住房公积金上月调整合计子女教育继续教育房贷利息房租赡养父母 001总经办卢子110 000 005 000 001 15 5 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 5 5 0 00 00 0 0 00 01 10 0 8 80 00 0 0 00 0324 001 15 5 4 47 76 6 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 002行政人事部卢子215 000 001 15 5 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 200 00300 0075 001 050 00 2 625 00 7 7 6 62 25 5 0 00 01 10 0 8 80 00 0 0 00 0245 251 15 5 5 55 54 4 7 75 51 15 5 8 80 00 0 0 00 07 7 6 62 25 5 0 00 0 003行政人事部卢子330 000 003 30 0 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 03 30 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 02 400 00600 00150 002 100 00 5 250 00 1 10 0 2 25 50 0 0 00 02 25 5 8 80 00 0 0 00 0616 503 30 0 1 18 83 3 5 50 03 30 0 8 80 00 0 0 00 01 10 0 2 25 50 0 0 00 0 004财务部卢子420 000 002 20 0 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 02 20 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 600 00400 00100 001 400 00 3 500 00 8 8 5 50 00 0 0 00 01 15 5 8 80 00 0 0 00 0369 002 20 0 4 43 31 1 0 00 02 20 0 8 80 00 0 0 00 08 8 5 50 00 0 0 00 0 005财务部卢子58 000 008 8 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 08 8 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0640 00160 0040 00560 00 1 400 006 6 4 40 00 0 0 00 03 3 8 80 00 0 0 00 072 008 8 7 72 28 8 0 00 08 8 8 80 00 0 0 00 06 6 4 40 00 0 0 00 0 006综合贸易部卢子616 000 001 16 6 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 01 16 6 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 280 00320 0080 001 120 00 2 800 007 7 8 80 00 0 0 00 01 11 1 8 80 00 0 0 00 0270 001 16 6 5 53 30 0 0 00 01 16 6 8 80 00 0 0 00 07 7 8 80 00 0 0 00 0 007综合贸易部卢子710 000 001 10 0 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0700 00 700 005 5 7 70 00 0 0 00 05 5 8 80 00 0 0 00 0153 001 10 0 6 64 47 7 0 00 01 10 0 8 80 00 0 0 00 05 5 7 70 00 0 0 00 0 008综合贸易部卢子810 000 001 10 0 0 00 00 0 0 00 0400 00200 00200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0800 00200 0050 00700 00 1 750 006 6 7 75 50 0 0 00 05 5 8 80 00 0 0 00 0121 501 10 0 6 67 78 8 5 50 01 10 0 8 80 00 0 0 00 06 6 7 75 50 0 0 00 0 合合计计119 000 005 000 001 12 24 4 0 00 00 0 0 00 03 200 001 600 001 600 00 6 6 4 40 00 0 0 00 0 1 13 30 0 4 40 00 0 0 00 04 40 0 0 00 00 0 0 00 07 920 001 980 00495 007 630 00 1 18 8 0 02 25 5 0 00 0 5 58 8 0 02 25 5 0 00 09 90 0 4 40 00 0 0 00 02 2 1 17 71 1 2 25 51 12 28 8 2 22 28 8 7 75 51 13 30 0 4 40 00 0 0 00 05 58 8 0 02 25 5 0 00 0 20192019年年0202月月工工资资表表 填填报报单单位位 员工编号部门姓名岗位 工资部分福利补贴 基本工资奖金及提成合计午餐补贴交通补贴 001总经办卢子110 000 005 000 001 15 5 0 00 00 0 0 00 0400 00200 00 002行政人事部卢子215 000 001 15 5 0 00 00 0 0 00 0400 00200 00 003行政人事部卢子330 000 003 30 0 0 00 00 0 0 00 0400 00200 00 004财务部卢子420 000 002 20 0 0 00 00 0 0 00 0400 00200 00 005财务部卢子58 000 008 8 0 00 00 0 0 00 0400 00200 00 006综合贸易部卢子616 000 001 16 6 0 00 00 0 0 00 0400 00200 00 007综合贸易部卢子710 000 001 10 0 0 00 00 0 0 00 0400 00200 00 008综合贸易部卢子810 000 001 10 0 0 00 00 0 0 00 0400 00200 00 合合计计119 000 005 000 001 12 24 4 0 00 00 0 0 00 03 200 001 600 00 加班费考勤扣款工工资资总总额额免免征征额额 代缴五险一金 通讯补贴出差补助合计养老保险医疗保险 200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 200 00300 00 200 00 8 80 00 0 0 00 03 30 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 02 400 00600 00 200 00 8 80 00 0 0 00 02 20 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 600 00400 00 200 00 8 80 00 0 0 00 08 8 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0640 00160 00 200 00 8 80 00 0 0 00 01 16 6 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 280 00320 00 200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0800 00200 00 1 600 00 6 6 4 40 00 0 0 00 0 1 13 30 0 4 40 00 0 0 00 04 40 0 0 00 00 0 0 00 07 920 001 980 00 20192019年年0202月月工工资资表表 福利补贴 专项扣除 合计当当月月扣扣除除 失业保险住房公积金上月调整合计子女教育继续教育房贷利息房租赡养父母 5 5 0 00 00 0 0 00 0 75 001 050 00 2 625 00 7 7 6 62 25 5 0 00 0 150 002 100 00 5 250 00 1 10 0 2 25 50 0 0 00 0 100 001 400 00 3 500 00 8 8 5 50 00 0 0 00 0 40 00560 00 1 400 006 6 4 40 00 0 0 00 0 80 001 120 00 2 800 007 7 8 80 00 0 0 00 0 700 00 700 005 5 7 70 00 0 0 00 0 50 00700 00 1 750 006 6 7 75 50 0 0 00 0 495 007 630 00 1 18 8 0 02 25 5 0 00 0 5 58 8 0 02 25 5 0 00 0 代缴五险一金 2 2 应应税税所所得得额额代扣个税实实发发工工资资工工资资累累计计扣扣除除累累计计前前1 1个个月月个个税税累累计计 1 10 0 8 80 00 0 0 00 0324 003 31 1 2 27 76 6 0 00 03 31 1 6 60 00 0 0 00 01 10 0 0 00 00 0 0 00 03 32 24 4 0 00 0 1 10 0 8 80 00 0 0 00 0245 253 31 1 3 35 54 4 7 75 53 31 1 6 60 00 0 0 00 01 15 5 2 25 50 0 0 00 02 24 45 5 2 25 5 2 25 5 8 80 00 0 0 00 0973 506 60 0 6 62 26 6 5 50 06 61 1 6 60 00 0 0 00 02 20 0 5 50 00 0 0 00 06 61 16 6 5 50 0 1 15 5 8 80 00 0 0 00 0369 004 41 1 2 23 31 1 0 00 04 41 1 6 60 00 0 0 00 01 17 7 0 00 00 0 0 00 03 36 69 9 0 00 0 3 3 8 80 00 0 0 00 072 001 17 7 5 52 28 8 0 00 01 17 7 6 60 00 0 0 00 01 12 2 8 80 00 0 0 00 07 72 2 0 00 0 1 11 1 8 80 00 0 0 00 0270 003 33 3 3 33 30 0 0 00 03 33 3 6 60 00 0 0 00 01 15 5 6 60 00 0 0 00 02 27 70 0 0 00 0 5 5 8 80 00 0 0 00 0153 002 21 1 4 44 47 7 0 00 02 21 1 6 60 00 0 0 00 01 11 1 4 40 00 0 0 00 01 15 53 3 0 00 0 5 5 8 80 00 0 0 00 0121 502 21 1 4 47 78 8 5 50 02 21 1 6 60 00 0 0 00 01 13 3 5 50 00 0 0 00 01 12 21 1 5 50 0 9 90 0 4 40 00 0 0 00 02 2 5 52 28 8 2 25 52 25 58 8 2 27 71 1 7 75 52 26 60 0 8 80 00 0 0 00 01 11 16 6 0 05 50 0 0 00 02 2 1 17 71 1 2 25 5 20192019年年0303月月工工资资表表 填填报报单单位位 员工编号部门姓名岗位 工资部分福利补贴 基本工资奖金及提成合计午餐补贴交通补贴 001总经办卢子110 000 005 000 001 15 5 0 00 00 0 0 00 0400 00200 00 002行政人事部卢子215 000 001 15 5 0 00 00 0 0 00 0400 00200 00 003行政人事部卢子330 000 003 30 0 0 00 00 0 0 00 0400 00200 00 004财务部卢子420 000 002 20 0 0 00 00 0 0 00 0400 00200 00 005财务部卢子58 000 008 8 0 00 00 0 0 00 0400 00200 00 006综合贸易部卢子616 000 001 16 6 0 00 00 0 0 00 0400 00200 00 007综合贸易部卢子710 000 001 10 0 0 00 00 0 0 00 0400 00200 00 008综合贸易部卢子810 000 001 10 0 0 00 00 0 0 00 0400 00200 00 合合计计119 000 005 000 001 12 24 4 0 00 00 0 0 00 03 200 001 600 00 加班费考勤扣款工工资资总总额额免免征征额额 代缴五险一金 通讯补贴出差补助合计养老保险医疗保险 200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 200 00300 00 200 00 8 80 00 0 0 00 03 30 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 02 400 00600 00 200 00 8 80 00 0 0 00 02 20 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 600 00400 00 200 00 8 80 00 0 0 00 08 8 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0640 00160 00 200 00 8 80 00 0 0 00 01 16 6 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 280 00320 00 200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0800 00200 00 1 600 00 6 6 4 40 00 0 0 00 0 1 13 30 0 4 40 00 0 0 00 04 40 0 0 00 00 0 0 00 07 920 001 980 00 20192019年年0303月月工工资资表表 福利补贴 专项扣除 合计当当月月扣扣除除 失业保险住房公积金上月调整合计子女教育继续教育房贷利息房租赡养父母 5 5 0 00 00 0 0 00 0 75 001 050 00 2 625 00 7 7 6 62 25 5 0 00 0 150 002 100 00 5 250 00 1 10 0 2 25 50 0 0 00 0 100 001 400 00 3 500 00 8 8 5 50 00 0 0 00 0 40 00560 00 1 400 006 6 4 40 00 0 0 00 0 80 001 120 00 2 800 007 7 8 80 00 0 0 00 0 700 00 700 005 5 7 70 00 0 0 00 0 50 00700 00 1 750 006 6 7 75 50 0 0 00 0 495 007 630 00 1 18 8 0 02 25 5 0 00 0 5 58 8 0 02 25 5 0 00 0 代缴五险一金 3 3 应应税税所所得得额额代扣个税实实发发工工资资工工资资累累计计扣扣除除累累计计前前2 2个个月月个个税税累累计计 1 10 0 8 80 00 0 0 00 0324 004 47 7 0 07 76 6 0 00 04 47 7 4 40 00 0 0 00 01 15 5 0 00 00 0 0 00 06 64 48 8 0 00 0 1 10 0 8 80 00 0 0 00 0245 254 47 7 1 15 54 4 7 75 54 47 7 4 40 00 0 0 00 02 22 2 8 87 75 5 0 00 04 49 90 0 5 50 0 2 25 5 8 80 00 0 0 00 02 055 009 90 0 3 34 45 5 0 00 09 92 2 4 40 00 0 0 00 03 30 0 7 75 50 0 0 00 01 1 5 59 90 0 0 00 0 1 15 5 8 80 00 0 0 00 0432 006 61 1 9 96 68 8 0 00 06 62 2 4 40 00 0 0 00 02 25 5 5 50 00 0 0 00 07 73 38 8 0 00 0 3 3 8 80 00 0 0 00 072 002 26 6 3 32 28 8 0 00 02 26 6 4 40 00 0 0 00 01 19 9 2 20 00 0 0 00 01 14 44 4 0 00 0 1 11 1 8 80 00 0 0 00 0270 005 50 0 1 13 30 0 0 00 05 50 0 4 40 00 0 0 00 02 23 3 4 40 00 0 0 00 05 54 40 0 0 00 0 5 5 8 80 00 0 0 00 0153 003 32 2 2 24 47 7 0 00 03 32 2 4 40 00 0 0 00 01 17 7 1 10 00 0 0 00 03 30 06 6 0 00 0 5 5 8 80 00 0 0 00 0121 503 32 2 2 27 78 8 5 50 03 32 2 4 40 00 0 0 00 02 20 0 2 25 50 0 0 00 02 24 43 3 0 00 0 9 90 0 4 40 00 0 0 00 03 3 6 67 72 2 7 75 53 38 87 7 5 52 27 7 2 25 53 39 91 1 2 20 00 0 0 00 01 17 74 4 0 07 75 5 0 00 04 4 6 69 99 9 5 50 0 20192019年年0404月月工工资资表表 填填报报单单位位 员工编号部门姓名岗位 工资部分福利补贴 基本工资奖金及提成合计午餐补贴交通补贴 001总经办卢子110 000 005 000 001 15 5 0 00 00 0 0 00 0400 00200 00 002行政人事部卢子215 000 001 15 5 0 00 00 0 0 00 0400 00200 00 003行政人事部卢子330 000 003 30 0 0 00 00 0 0 00 0400 00200 00 004财务部卢子420 000 002 20 0 0 00 00 0 0 00 0400 00200 00 005财务部卢子58 000 008 8 0 00 00 0 0 00 0400 00200 00 006综合贸易部卢子616 000 001 16 6 0 00 00 0 0 00 0400 00200 00 007综合贸易部卢子710 000 001 10 0 0 00 00 0 0 00 0400 00200 00 008综合贸易部卢子810 000 001 10 0 0 00 00 0 0 00 0400 00200 00 合合计计119 000 005 000 001 12 24 4 0 00 00 0 0 00 03 200 001 600 00 加班费考勤扣款工工资资总总额额免免征征额额 代缴五险一金 通讯补贴出差补助合计养老保险医疗保险 200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 200 00 8 80 00 0 0 00 01 15 5 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 200 00300 00 200 00 8 80 00 0 0 00 03 30 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 02 400 00600 00 200 00 8 80 00 0 0 00 02 20 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 600 00400 00 200 00 8 80 00 0 0 00 08 8 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0640 00160 00 200 00 8 80 00 0 0 00 01 16 6 8 80 00 0 0 00 05 5 0 00 00 0 0 00 01 280 00320 00 200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0 200 00 8 80 00 0 0 00 01 10 0 8 80 00 0 0 00 05 5 0 00 00 0 0 00 0800 00200 00 1 600 00 6 6 4 40 00 0 0 00 0 1 13 30 0 4 40 00 0 0 00 04 40 0 0 00 00 0 0 00 07 920 001 980 00 20192019年年0404月月工工资资表表 福利补贴 专项扣除 合计当当月月扣扣除除 失业保险住房公积金上月调整合计子女教育继续教育房贷利息房租赡养父母 5 5 0 00 00 0 0 00 0 75 001 050 00 2 625 00 7 7 6 62 25 5 0 00 0 150 002 100 00 5 250 00 1 10 0 2 25 50 0 0 00 0 100 001 400 00 3 500 00 8 8 5 50 00 0 0 00 0 40 00560 00 1 400 006 6 4 40 00 0 0 00 0 80 001 120 00 2 800 007 7 8 80 00 0 0 00 0 700 00 700 005 5 7 70 00 0 0 00 0 50 00700 00 1 750 006 6 7 75 50 0 0 00 0 495 007 630 00 1 18 8 0 02 25 5 0 00 0 5 58 8 0 02 25 5 0 00 0 代缴五险一金 4 4 应应税税所所得得额额代扣个税实实发发工工资资工工资资累累计计扣扣除除累累计计前前3 3个个月月个个税税累累计计 1 10 0 8 80 00 0 0 00 0828 006 62 2 3 37 72 2 0 00 06 63 3 2 20 00 0 0 00 02 20 0 0 00 00 0 0 00 09 97 72 2 0 00 0 1 10 0 8 80 00 0 0 00 0245 256 62 2 9 95 54 4 7 75 56 63 3 2 20 00 0 0 00 03 30 0 5 50 00 0 0 00 07 73 35 5 7 75 5 2 25 5 8 80 00 0 0 00 02 055 001 12 21 1 1 14 45 5 0 00 01 12 23 3 2 20 00 0 0 00 04 41 1 0 00 00 0 0 00 03 3 6 64 45 5 0 00 0 1 15 5 8 80 00 0 0 00 01 230 008 81 1 9 97 70 0 0 00 08 83 3 2 20 00 0 0 00 03 34 4 0 00 00 0 0 00 01 1 1 17 70 0 0 00 0 3 3 8 80 00 0 0 00 072 003 35 5 1 12 28 8 0 00 03 35 5 2 20 00 0 0 00 02 25 5 6 60 00 0 0 00 02 21 16 6 0 00 0 1 11 1 8 80 00 0 0 00 0270 006 66 6 9 93 30 0 0 00 06 67 7 2 20 00 0 0 00 03 31 1 2 20 00 0 0 00 08 81 10 0 0 00 0 5 5 8 80 00 0 0 00 0153 004 43 3 0 04 47 7 0 00 04 43 3 2 20 00 0 0 00 02 22 2 8 80 00 0 0 00 04 45 59 9 0 00 0 5 5 8 80 00 0 0 00 0121 504 43 3 0 07 78 8 5 50 04 43 3 2 20 00 0 0 00 02 27 7 0 00 00 0 0 00 03 36 64 4 5 50 0 9 90 0 4 40 00 0 0 00 04 4 9 97 74 4 7 75 55 51 16 6 6 62 25 5 2 25 55 52 21 1 6 60 00 0 0 00 02 23 32 2 1 10 00 0 0 00 08 8 3 37 72 2 2 25 5