1、20*年*月员工工资计算表（自动计算-含公式）序号薪资期间ID姓名岗位岗位基本工资补贴岗位津贴午餐补贴加班费其他补贴12019.65500.022019.65500.032019.65500.042019.65000.052019.65000.062019.65500.072019.65500.082019.65500.092019.65000.0102019.65000.0112019.65500.0122019.65500.0132019.65500.0142019.65000.0152019.65000.0162019.65500.0172019.65500.0182019.65500.
2、0192019.65000.0202019.65000.0LOGO稻代扣代缴五险一金税前补差缺勤扣款出勤工资应纳税收入纳税基数扣减公积金（公司）代缴公积金（个人）代缴社会保险法定费用扣除额代缴社会保险可扣除公积金5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,000.005,000.005,000.00-5,000.005,000.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,0
3、00.00-5,000.005,000.005,000.00-5,000.005,000.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,000.005,000.005,000.00-5,000.005,000.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,500.005,500.005,000.00-5,000.005,000.005,000.00-5,000.005,000.005,0
4、00.00-20*年*月员工工资计算表（自动计算-含公式）个人所得税税后补扣实发工资备注应纳税所得额税率速算扣除数应付个人所得税额500.003%-15.005,485.00500.003%-15.005,485.00500.003%-15.005,485.000.003%-5,000.000.003%-5,000.00500.003%-15.005,485.00500.003%-15.005,485.00500.003%-15.005,485.000.003%-5,000.000.003%-5,000.00500.003%-15.005,485.00500.003%-15.005,485.00500.003%-15.005,485.000.003%-5,000.000.003%-5,000.00500.003%-15.005,485.00500.003%-15.005,485.00500.003%-15.005,485.000.003%-5,000.000.003%-5,000.00
