2019年新个税工资表计算通用模版.xls

使用说明：1、1-12月份每个月的逻辑关系已设置完毕，只需填写员工信息、更改员工工资金额即可。2、此版本是根据最新税务局最新个税申报系统编制的，个税计算符合2019年综合计算要求3、个税附加项关系可修改可添加。4、下载后有问题请+V：wftx0536 2019年新个税工资表 2019年1月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假1150,000/-1258,000/-1320,000/-1420,453/-1517,000/-166,000/-1715,000/-186,000/-199,500/-1107,000/-11114,000/-合计222,953-备注：1、1-12月份每个月的逻辑关系已设置完毕，只需填写员工信息、更改工资金额即可。2、此版本是根据最新税务局个税申报系统编制的，个税计算符合2019年综合计税要求3、所有逻辑关系都可以更改，行列都可以灵活添加。4、下载后有问题请+V：wftx0536粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00 50,000.002,300.003,000.00-58,000.00800.001,500.002,300.00 58,000.002,300.00-20,000.00800.001,500.002,300.00 20,000.002,300.00-20,453.00800.001,500.002,300.00 20,453.002,300.00-17,000.00357.001,800.002,157.00 17,000.002,157.004,000.00-6,000.00800.001,500.002,300.006,000.002,300.001,000.00-15,000.00800.001,500.002,300.00 15,000.002,300.003,500.00-6,000.00800.001,500.002,300.006,000.002,300.001,000.00-9,500.00800.001,500.002,300.009,500.002,300.002,000.00-7,000.00800.001,500.002,300.007,000.002,300.002,000.00-14,000.00800.001,500.002,300.00 14,000.002,300.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年1月份绿色扣除区工资减项和1、1-12月份每个月的逻辑关系已设置完毕，只需填写员工信息、更改工资金额即可。2、此版本是根据最新税务局个税申报系统编制的，个税计算符合2019年综合计税要求黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育39,700.001,450.001,450.0046,250.0010001000 100050,700.002,550.002,550.0053,150.0012,700.00381.00381.0017,319.0013,153.00394.59394.5917,758.415,843.00175.29175.2914,667.7110001000 2000-2,300.00-3,700.0010004,200.00126.00126.0012,574.001500 2000-2,300.00-3,700.001000200.006.006.007,194.001000 1000-2,300.00-4,700.00100010006,700.00201.00201.0011,499.00-2019年新个税工资表 2019年2月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假2150,0002258,0002320,0002420,4532517,000266,0002715,000286,000299,5002107,00021114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00100,000.004,600.006,000.00-58,000.00800.001,500.002,300.00116,000.004,600.00-20,000.00800.001,500.002,300.0040,000.004,600.00-20,453.00800.001,500.002,300.0040,906.004,600.00-17,000.00357.001,800.002,157.0034,000.004,314.008,000.00-6,000.00800.001,500.002,300.0012,000.004,600.002,000.00-15,000.00800.001,500.002,300.0030,000.004,600.007,000.00-6,000.00800.001,500.002,300.0012,000.004,600.002,000.00-9,500.00800.001,500.002,300.0019,000.004,600.004,000.00-7,000.00800.001,500.002,300.0014,000.004,600.004,000.00-14,000.00800.001,500.002,300.0028,000.004,600.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年2月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育79,400.003,970.005,420.0043,730.00100010001000101,400.005,070.007,620.0050,630.0025,400.00381.00762.0017,319.0026,306.00394.59789.1817,758.4111,686.00175.29350.5814,667.71100010002000-4,600.00-3,700.0010008,400.00126.00252.0012,574.0015002000-4,600.00-3,700.001000400.006.0012.007,194.0010001000-4,600.00-4,700.001000100013,400.00201.00402.0011,499.00-10,323.88 15,607.76 187,472.12 2019年新个税工资表 2019年3月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假3150,0003258,0003320,0003420,4533517,000366,0003715,000386,000399,5003107,00031114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00150,000.006,900.009,000.00-58,000.00800.001,500.002,300.00174,000.006,900.00-20,000.00800.001,500.002,300.0060,000.006,900.00-20,453.00800.001,500.002,300.0061,359.006,900.00-17,000.00357.001,800.002,157.0051,000.006,471.00 12,000.00-6,000.00800.001,500.002,300.0018,000.006,900.003,000.00-15,000.00800.001,500.002,300.0045,000.006,900.00 10,500.00-6,000.00800.001,500.002,300.0018,000.006,900.003,000.00-9,500.00800.001,500.002,300.0028,500.006,900.006,000.00-7,000.00800.001,500.002,300.0021,000.006,900.006,000.00-14,000.00800.001,500.002,300.0042,000.006,900.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年3月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育119,100.003,970.009,390.0043,730.00100010001000152,100.005,880.00 13,500.0049,820.0038,100.00528.001,290.0017,172.0039,459.00636.721,425.9017,516.2817,529.00175.29525.8714,667.71100010002000-6,900.00-3,700.00100012,600.00126.00378.0012,574.0015002000-6,900.00-3,700.001000600.006.0018.007,194.0010001000-6,900.00-4,700.001000100020,100.00201.00603.0011,499.00-11,523.01 27,130.77 186,272.99 2019年新个税工资表 2019年4月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假4150,0004258,0004320,0004420,4534517,000466,0004715,000486,000499,5004107,00041114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00200,000.009,200.00 12,000.00-58,000.00800.001,500.002,300.00232,000.009,200.00-20,000.00800.001,500.002,300.0080,000.009,200.00-20,453.00800.001,500.002,300.0081,812.009,200.00-17,000.00357.001,800.002,157.0068,000.008,628.00 16,000.00-6,000.00800.001,500.002,300.0024,000.009,200.004,000.00-15,000.00800.001,500.002,300.0060,000.009,200.00 14,000.00-6,000.00800.001,500.002,300.0024,000.009,200.004,000.00-9,500.00800.001,500.002,300.0038,000.009,200.008,000.00-7,000.00800.001,500.002,300.0028,000.009,200.008,000.00-14,000.00800.001,500.002,300.0056,000.009,200.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年4月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育158,800.005,450.00 14,840.0042,250.00100010001000202,800.00 10,140.00 23,640.0045,560.0050,800.001,270.002,560.0016,430.0052,612.001,315.302,741.2016,837.7023,372.00175.29701.1614,667.71100010002000-9,200.00-3,700.00100016,800.00126.00504.0012,574.0015002000-9,200.00-3,700.001000800.006.0024.007,194.0010001000-9,200.00-4,700.001000100026,800.00201.00804.0011,499.00-18,683.59 45,814.36 179,112.41 2019年新个税工资表 2019年5月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假5150,0005258,0005320,0005420,4535517,000566,0005715,000586,000599,5005107,00051114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00250,000.00 11,500.00 15,000.00-58,000.00800.001,500.002,300.00290,000.00 11,500.00-20,000.00800.001,500.002,300.00100,000.00 11,500.00-20,453.00800.001,500.002,300.00102,265.00 11,500.00-17,000.00357.001,800.002,157.0085,000.00 10,785.00 20,000.00-6,000.00800.001,500.002,300.0030,000.00 11,500.005,000.00-15,000.00800.001,500.002,300.0075,000.00 11,500.00 17,500.00-6,000.00800.001,500.002,300.0030,000.00 11,500.005,000.00-9,500.00800.001,500.002,300.0047,500.00 11,500.00 10,000.00-7,000.00800.001,500.002,300.0035,000.00 11,500.00 10,000.00-14,000.00800.001,500.002,300.0070,000.00 11,500.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年5月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育198,500.007,940.00 22,780.0039,760.00100010001000253,500.00 10,140.00 33,780.0045,560.0063,500.001,270.003,830.0016,430.0065,765.001,315.304,056.5016,837.7029,215.00175.29876.4514,667.71100010002000-11,500.00-3,700.00100021,000.00126.00630.0012,574.0015002000-11,500.00-3,700.0010001,000.006.0030.007,194.0010001000-11,500.00-4,700.001000100033,500.00201.001,005.0011,499.00-21,173.59 66,987.95 176,622.41 2019年新个税工资表 2019年6月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假6150,0006258,0006320,0006420,4536517,000666,0006715,000686,000699,5006107,00061114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00300,000.00 13,800.00 18,000.00-58,000.00800.001,500.002,300.00348,000.00 13,800.00-20,000.00800.001,500.002,300.00120,000.00 13,800.00-20,453.00800.001,500.002,300.00122,718.00 13,800.00-17,000.00357.001,800.002,157.00102,000.00 12,942.00 24,000.00-6,000.00800.001,500.002,300.0036,000.00 13,800.006,000.00-15,000.00800.001,500.002,300.0090,000.00 13,800.00 21,000.00-6,000.00800.001,500.002,300.0036,000.00 13,800.006,000.00-9,500.00800.001,500.002,300.0057,000.00 13,800.00 12,000.00-7,000.00800.001,500.002,300.0042,000.00 13,800.00 12,000.00-14,000.00800.001,500.002,300.0084,000.00 13,800.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年6月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育238,200.007,940.0030,720.0039,760.00100010001000304,200.00 10,350.0044,130.0045,350.0076,200.001,270.005,100.0016,430.0078,918.001,315.305,371.8016,837.7035,058.00175.291,051.7414,667.71100010002000-13,800.00-3,700.00100025,200.00126.00756.0012,574.0015002000-13,800.00-3,700.0010001,200.006.0036.007,194.0010001000-13,800.00-4,700.001000100040,200.00495.001,500.0011,205.00-21,677.5988,665.54 176,118.41 2019年新个税工资表 2019年7月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假7150,0007258,0007320,0007420,4537517,000766,0007715,000786,000799,5007107,00071114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00350,000.00 16,100.00 21,000.00-58,000.00800.001,500.002,300.00406,000.00 16,100.00-20,000.00800.001,500.002,300.00140,000.00 16,100.00-20,453.00800.001,500.002,300.00143,171.00 16,100.00-17,000.00357.001,800.002,157.00119,000.00 15,099.00 28,000.00-6,000.00800.001,500.002,300.0042,000.00 16,100.007,000.00-15,000.00800.001,500.002,300.00105,000.00 16,100.00 24,500.00-6,000.00800.001,500.002,300.0042,000.00 16,100.007,000.00-9,500.00800.001,500.002,300.0066,500.00 16,100.00 14,000.00-7,000.00800.001,500.002,300.0049,000.00 16,100.00 14,000.00-14,000.00800.001,500.002,300.0098,000.00 16,100.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年7月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育277,900.007,940.0038,660.0039,760.00100010001000354,900.00 12,675.0056,805.0043,025.0088,900.001,270.006,370.0016,430.0092,071.001,315.306,687.1016,837.7040,901.00518.361,570.1014,324.64100010002000-16,100.00-3,700.00100029,400.00126.00882.0012,574.0015002000-16,100.00-3,700.0010001,400.006.0042.007,194.0010001000-16,100.00-4,700.001000100046,900.00670.002,170.0011,030.00-24,520.66113,186.20 173,275.34 2019年新个税工资表 2019年8月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假8150,0008258,0008320,0008420,4538517,000866,0008715,000886,000899,5008107,00081114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00400,000.00 18,400.00 24,000.00-58,000.00800.001,500.002,300.00464,000.00 18,400.00-20,000.00800.001,500.002,300.00160,000.00 18,400.00-20,453.00800.001,500.002,300.00163,624.00 18,400.00-17,000.00357.001,800.002,157.00136,000.00 17,256.00 32,000.00-6,000.00800.001,500.002,300.0048,000.00 18,400.008,000.00-15,000.00800.001,500.002,300.00120,000.00 18,400.00 28,000.00-6,000.00800.001,500.002,300.0048,000.00 18,400.008,000.00-9,500.00800.001,500.002,300.0076,000.00 18,400.00 16,000.00-7,000.00800.001,500.002,300.0056,000.00 18,400.00 16,000.00-14,000.00800.001,500.002,300.00112,000.00 18,400.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年8月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育317,600.008,820.0047,480.0038,880.00100010001000405,600.00 12,675.0069,480.0043,025.00101,600.001,270.007,640.0016,430.00105,224.001,315.308,002.4016,837.7046,744.00584.302,154.4014,258.70100010002000-18,400.00-3,700.00100033,600.00126.001,008.0012,574.0015002000-18,400.00-3,700.0010001,600.006.0048.007,194.0010001000-18,400.00-4,700.001000100053,600.00670.002,840.0011,030.00-25,466.60138,652.80 172,329.40 2019年新个税工资表 2019年9月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假9150,0009258,0009320,0009420,4539517,000966,0009715,000986,000999,5009107,00091114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00450,000.00 20,700.00 27,000.00-58,000.00800.001,500.002,300.00522,000.00 20,700.00-20,000.00800.001,500.002,300.00180,000.00 20,700.00-20,453.00800.001,500.002,300.00184,077.00 20,700.00-17,000.00357.001,800.002,157.00153,000.00 19,413.00 36,000.00-6,000.00800.001,500.002,300.0054,000.00 20,700.009,000.00-15,000.00800.001,500.002,300.00135,000.00 20,700.00 31,500.00-6,000.00800.001,500.002,300.0054,000.00 20,700.009,000.00-9,500.00800.001,500.002,300.0085,500.00 20,700.00 18,000.00-7,000.00800.001,500.002,300.0063,000.00 20,700.00 18,000.00-14,000.00800.001,500.002,300.00126,000.00 20,700.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年9月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育357,300.009,925.0057,405.0037,775.00100010001000456,300.00 14,490.0083,970.0041,210.00114,300.001,270.008,910.0016,430.00118,377.001,315.309,317.7016,837.7052,587.00584.302,738.7014,258.70100010002000-20,700.00-3,700.00100037,800.00252.001,260.0012,448.0015002000-20,700.00-3,700.0010001,800.006.0054.007,194.0010001000-20,700.00-4,700.001000100060,300.00670.003,510.0011,030.00-28,512.60167,165.40 169,283.40 2019年新个税工资表 2019年10月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假10150,00010258,00010320,00010420,45310517,0001066,00010715,0001086,0001099,50010107,000101114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00500,000.00 23,000.00 30,000.00-58,000.00800.001,500.002,300.00580,000.00 23,000.00-20,000.00800.001,500.002,300.00200,000.00 23,000.00-20,453.00800.001,500.002,300.00204,530.00 23,000.00-17,000.00357.001,800.002,157.00170,000.00 21,570.00 40,000.00-6,000.00800.001,500.002,300.0060,000.00 23,000.00 10,000.00-15,000.00800.001,500.002,300.00150,000.00 23,000.00 35,000.00-6,000.00800.001,500.002,300.0060,000.00 23,000.00 10,000.00-9,500.00800.001,500.002,300.0095,000.00 23,000.00 20,000.00-7,000.00800.001,500.002,300.0070,000.00 23,000.00 20,000.00-14,000.00800.001,500.002,300.00140,000.00 23,000.00-222,953.008,357.00 16,800.00 25,157.00 2019年新个税工资表 2019年10月份绿色扣除区工资减项和黄黄色色专专项项附附加加扣扣除除区区年度计税基数累计（-5000）当月代扣个税额年度代扣个税额累计本月实发工资额个税专项扣除项子女教育房贷利息或住房租金赡养老人继续教育397,000.009,925.0067,330.0037,775.00100010001000507,000.00 15,210.0099,180.0040,490.00127,000.001,270.0010,180.0016,430.00131,530.001,315.3010,633.0016,837.7058,430.00584.303,323.0014,258.70100010002000-23,000.00-3,700.00100042,000.00420.001,680.0012,280.0015002000-23,000.00-3,700.0010002,000.006.0060.007,194.0010001000-23,000.00-4,700.001000100067,000.00670.004,180.0011,030.00-29,400.60196,566.00 168,395.40 2019年新个税工资表 2019年11月份单位：元灰色收入区绿色扣除区月份序号部门姓名工资增项工资减项和工资基数午餐补助通讯补助工龄工资生产绩效全勤奖/其他绩效分数小计迟到/早退事假11150,00011258,00011320,00011420,45311517,0001166,00011715,0001186,0001199,50011107,000111114,000/-合计222,953-粉粉色色计计算算区区本月应发工资额代扣代缴年度应发工资额累计年度扣除五险一金累计年度专项附加扣除累计病假缺勤小计代缴个人社保代缴个人公积金五险一金个人合计-50,000.00800.001,500.002,300.00