Excel人事考勤工资核算系统.xlsx

工资表序号部门姓 名 基本工资 岗位工资 津贴 加班工时 加班费 缺勤工时 缺勤扣发 应发工资 养老保险 公积金 扣税 扣款 实发工资 17500.00 - - 0 - - - 7,500.00 - 75.00 7,425.0028000.00 2,000.00 0 - 0 - 10,000.00 - 290.00 9,710.0033552.00 - 0 - 0 - 3,552.00 - - 3,552.0043553.00 0 - 0 - 3,553.00 - - 3,553.0053554.00 55 814.5 44 651.6 3,716.90 - 3,716.9063555.00 - 44 651.8 16 237.0 3,969.80 - 3,969.8073556.00 32 474.2 - 4,030.20 - 4,030.2083557.00 44 652.2 12 177.9 4,031.30 - 4,031.3093558.00 11 163.1 8 118.6 3,602.50 - 3,602.50103559.00 8 118.7 8 118.7 3,559.00 - 3,559.00113560.00 6 89.0 8 118.7 3,530.30 - 3,530.30123561.00 7 103.9 8 118.7 3,546.20 - 3,546.20133562.00 9 133.6 8 118.8 3,576.80 - 3,576.80143563.00 3 44.6 - - 0.00153564.00 163565.00 173566.00 183567.00 193568.00 20戊4 - - 0.00----6 - - - 0.00合 计 76,020.00 3,245.60 1,660.00 58,168.00 - 365.00 57,803.00 制表: 复核: 批准: