员工月工资结算单模板.xls

员员工工月月工工资资结结算算单单 单位：元平均值 2,537.50最大值5,000.00最小值0.00计数7工 号隶属部门姓 名基本工资奖 金缺勤扣款应发工资代缴社会保险费职务工资工龄工资学历工资合 计养老保险医疗保险失业保险住房公积金合 计1609销售部王 瑛500.00200.00400.001,100.0098.22300898.2201602销售部赵 兵3,000.001,000.001,000.005,000.001680.403506680.403501620销售部马汉民2,000.00800.001,000.003,800.0015550535501604销售部叶清宏1,500.00500.00500.002,500.00720.0403220.0401618销售部宋海涛800.00200.00800.001,800.0010550285501607销售部洪 嘉2,000.001,000.00800.003,800.00118040494001616销售部朝晓霞800.00500.001,000.002,300.00240.0402540.0400.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000代缴个税实发工资0.00898.22457.066223.3435287.055067.9557.003163.0431.702823.3224.804715.28.602531.44员员工工月月工工资资结结算算单单 单位：元员工奖金计算表 单位：元工 号隶属部门姓 名销售金额奖金比例奖金总额1602销售部赵 兵336,080.700.50%1680.40351604销售部叶清宏180,010.000.40%720.041605销售部李艳新183,000.000.40%7321607销售部洪 嘉236,000.000.50%11801609销售部王 瑛65,480.000.15%98.221616销售部朝晓霞120,020.000.20%240.041618销售部宋海涛211,000.000.50%10551620销售部马汉民311,000.000.50%155500000000000000000000000000000000000000000000员工考勤表 单位：元工 号隶属部门姓 名请假天数缺勤薪资(日)缺勤扣款1609销售部王 瑛5203001602销售部赵 兵2001620销售部马汉民2001604销售部叶清宏2001618销售部宋海涛2001607销售部洪 嘉220401616销售部朝晓霞20000000000