《Excel模板：工资表范本(已设计好公式自动计算-考勤表&工资表).xls》由会员分享，可在线阅读，更多相关《Excel模板：工资表范本(已设计好公式自动计算-考勤表&工资表).xls（5页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、工资表姓名职称月薪时薪出勤时间所得薪资扣款应得薪资个人扣税实发薪资员工签名应出勤天数出勤天数平时加班时数周末加班时数国假天数正班薪资平时加班薪资周末加班薪资国假薪资岗位津贴全勤奖事假缺勤扣款社保费用xxx员工13207.59212116001320.00182.070.000.0000.00113.601388.470.001388.5xxx员工13207.59212126001320.00295.860.000.000300.00113.601532.260.001532.3endgz共2人合计：227.202920.730.002920.7会计：批准：第 1 页，共 5 页第 2 页，共
2、5 页人员编号姓名部门白班(时)晚班(时)应出勤(天)实出勤(天)平时加班(时)公休加班(时)002 xxxxxx80212116003 xxxxxx128212126005 xxxxxx128212126010 xxxxxx128212126012 xxxxxx128212126014 xxxxxx128212126015 xxxxxx128212126016 xxxxxx128212126018 xxxxxx128212126019 xxxxxx128212126022 xxxxxx128212126023 xxxxxx128212126028 xxxxxx128212126029 xxx
3、xxx128212126032 xxxxxx128212126033 xxxxxx128212126034 xxxxxx128212126035 xxxxxx128212126036 xxxxxx1282121262001 xxxxxx1282121262002 xxxxxx1282121262003 xxxxxx1282121262005 xxxxxx1282121262007 xxxxxx1282121262008 xxxxxx1282121262010 xxxxxx1282121261001 xxxxxx1282121261003 xxxxxx882121181004 xxxxxx562
4、121121007 xxxxxx1282121261010 xxxxxx128212126025 xxxxxx1282121261002 xxxxxx1282121262004 xxxxxx128212126026 xxxxxx128212126027 xxxxxx1282121261011 xxxxxx128212126记录数:3737节日加班(时)事假(时)病假(时)年假(时)婚假(时)出差(时)外出(时)外出次(次)迟到(分)早退(分)缺勤(时)缺勤次数(次)应签到(次)未签到(次)出勤率(%)400100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100640100440100280100640100640100640100640100640100640100640100640100