员工工资表模板(带公式)

病事假未出勤婚丧违纪罚款迟到/漏打卡社保 医保采购部1王文武3000251115.42884.628853003184.620.003184.62人事部2邓云3500251134.63365.433653365.383365.38信息部3胡哲明1000261000.010001000.001000.00信息部4李宁1000261000.010001000.001000.00门店5王修实2200262200.0263.402463952002568.662568.66门店6黄嘉豪1600261600.0175.601776682001907.311907.31门店7吴双双1600261600.0175.6017762001975.601975.60门店8余娟1600206409.81190.2175.6013661365.831365.83门店9舒清清16005211434.1165.9175.60341341.46341.46门店10 周宬婧16006201365.9234.2175.60410409.75409.75门店11於意16006201365.9234.2175.60410409.75409.75合计203004825.615474.41317.00167910.016390017528.360.0017528.36应税工资个人所得税实发工资备注人2017年 07 月员工工资表2017年 06 月员工工资表部门序号姓名薪资标准考核天数缺勤天数扣款金额出勤工资销售提成应发工资其他扣款其他工资 制表： 审核：病事假未出勤婚丧违纪罚款迟到/漏打卡社保 医保采购部1王文武3000263000.003000.00300.00 3300.003300.00采购部2叶超12001251050.00 150.00150.00150.00150.00人事部3邓云3500 263500.003500.003500.003500.00信息部4 胡哲明1000261000.001000.001000.001000.00财务部5李宁1000261000.001000.001000.001000.00门店6 王修实220026472.261727.74 255.801983.5418.42 2001.962001.96门店7黄嘉豪180026122.31 1677.69170.50 1848.1912.281860.471860.47门店8吴双双1600188558.541041.46170.50 1211.9612.281224.241224.24门店9杨苏16001313912.67 687.33213.10 900.4312.28912.71912.71门店10周颖16001214959.95640.05170.50 810.5512.28822.83822.83门店11 周宬婧160026408.581191.42170.50 1361.9212.281374.201374.20门店12於意16002630.00 1570.00 170.50 1740.5012.281752.781752.78门店13郑思源16001313891.38 708.62 170.50 879.1212.28891.40891.40合计233005405.717894.31491.9019386.21404.3819790.5919790.59其他扣款其他工资应税工资个人所得税部门序号姓名薪资标准考核天数缺勤天数扣款金额出勤工资销售提成备注人2017年 08 月员工工资表其他扣款个人缺勤天数应发工资实发工资 制表： 审核：病事假未出勤婚丧违纪罚款迟到/漏打卡社保 医保采购部1王文武3000263000.003000.0057.69300.00 3242.313242.31采购部2王修...