49-【通用】自动生成工资表

编号养失医房姓名基本工资交通补贴公务补贴电话补贴123456780011111张三¥2,000.001,900.00100.0050.00150.00银行工资卡号岗位工资车补午餐补贴司龄补奖金考勤应扣其它应扣工资总额80.00150.0080.00#REF!#REF!20.00####VALUE!5.00#REF!加班天数加班工资缺勤天数实发工资#REF!#REF!#REF!#REF!¥0.00#REF!养老保险失业保险医疗保险住房公积金其它代扣代扣个人所得税银行工资卡号签字某信息技术有限公司所属期间：20XX/7/XX员工姓名：张三001基本工资2,000.00司龄补贴80.00养老保险#REF!岗位工资1,900.00加班工资#REF!失业保险#REF!交通补贴100.00奖金20.00医疗保险#REF!公务补贴50.00缺勤天数#VALUE!住房公积金#REF!电话补贴150.00考勤应扣#VALUE!其他扣款车补80.00其它应扣5.00午餐补贴150.00工资总额#REF!代扣个人所得税#REF!领款人签名：实发工资#REF!员工ID：PAYPAYRollPAYPAYRollPAYPAYRoll001002003MonthMonthMonth张三张三张三2,000.002,000.002,000.001,900.001,900.001,900.0050.0050.0050.00150.00150.00150.00150.00150.00150.0080.0080.0080.00工资总额#REF!工资总额#REF!工资总额#REF!#REF!#REF!#REF!20.0020.0020.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!5.005.005.00#REF!#REF!#REF!实发工资#REF!实发工资#REF!实发工资#REF!纳税所得额适用税率速算扣除数纳税所得额适用税率速算扣除数纳税所得额适用税率速算扣除数5%0.005%0.005%0.00500-200010%25.00500-200010%25.00500-200010%25.002000-500015%125.002000-500015%125.002000-500015%125.005000-2000020%375.005000-2000020%375.005000-2000020%375.0020000...