工资计算表（含税自动计算）.xlsx

工资计算表（含税自动计算）说明：灰色部分有公式自动计算，只需要填写其他数据即可。序号姓名岗位基本工资补贴税前补差缺勤扣款出勤工资 应纳税收入纳税基数扣减个人所得税实发工资备注岗位津贴午餐补贴加班费其他补贴个税起征点代缴社会保险代缴纳公积金应纳税所得额税率速算扣除数应付个人所得税额1员工115000.0 30.0 20.0 250.0 15.0 150.0 200.0 15265.0 15265.0 5000.0 1050.0 2625.0 6590.0 10%210.0 449.0 11141.0 2员工28000.0 30.0 20.0 250.0 15.0 150.0 200.0 8265.0 8265.0 5000.0 1050.0 2625.0 0.0 3%0.0 0.0 4590.0 3员工39500.0 30.0 20.0 250.0 15.0 150.0 200.0 9765.0 9765.0 5000.0 1050.0 2625.0 1090.0 3%0.0 32.7 6057.3 4员工46200.0 30.0 20.0 250.0 15.0 150.0 200.0 6465.0 6465.0 5000.0 1050.0 2625.0 0.0 3%0.0 0.0 2790.0 5员工518000.0 30.0 20.0 250.0 15.0 150.0 200.0 18265.0 18265.0 5000.0 1050.0 2625.0 9590.0 10%210.0 749.0 13841.0 6员工625000.0 30.0 20.0 250.0 15.0 150.0 200.0 25265.0 25265.0 5000.0 1050.0 2625.0 16590.0 20%1410.0 1908.0 19682.0