二零一九年个税工资表

,说明：,1、1-12月份A-T列为手动录入，可复制到其他月份，U-Y列为公式，自动计算,2、查询表录入工号，自动生成1-12工资报表,3、查询表密码为空，可自行修改,查询表,工号A001姓名员工1,月份基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除应税,工资个税实发工资,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,合计96000.012000.0600.012000.033600.01800.054.095346.0,一月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,二月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,三月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,四月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,五月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,六月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,七月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,八月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,九月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,十月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,十一月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,十二月工资表 个税表,序号工号部门姓名基本工资加项1加项2加项3加项4加项5加项6扣项1扣项2扣项3扣项4扣项5扣项6五险,一金专项,扣除固定,起征点应税,工资税率扣除数个税实发工资,1.0A001员工18000.050.02800.0150.04.57945.5,2.0A002员工26000.0100.0900.027.05873.0,3.0A003员工310000.04000.0190.08810.0,4.0A004员工4500.0200.02800.084.07716.0,5.0A005员工56500.0500.015.05485.0,6.0A006员工67000.030.05970.0,7.0A007员工7400.02500.06900.0480.013920.0,8.0A008员工816500.03500.07000.0490.015010.0,9.0A009员工98000.0600.02600.078.07522.0,10.0A010员工102500.075.07425.0,11.0A011供应员工119000.03000.090.07910.0,12.0A012供应员工127500.01500.045.06455.0,13.0A013员工133000.06000.0390.013610.0,14.0A014员工149000.02000.030.07970.0,15.0A015员工151500.045.07455.0,16.0,17.0,18.0,19.0,20.0,合计143000.02900.0600.050.0100.0200.014800.0100000.041350.00.81050.02073.5129076.5,税率表,起征点5000.0,个人所得税预扣率表一 薪金所得预扣预缴,级别应纳税所得额税率速扣数,0.0不超过3000元的0.030.0,3000.0超过3000元至12000元部分0.1210.0,12000.0超过12000元至25000元部分0.21410.0,25000.0超过25000元至35000元部分0.252660.0,35000.0超过35000元至55000元部分0.34410.0,55000.0超过55000元至80000元部分0.357160.0,80000.0超过80000元部分0.4515160.0