excl工资表实例.xls

1、工资表2011 年 7月序部门姓名基本工资试用期工资出勤天数业务津贴加班工资奖金补发奖金补发工资缺勤天数扣扣扣押金应发工资代扣个税扣扣实发工资签字及缺勤工资房租处罚款宿舍水电号岗位1张行舟200031200020002高小辉200031200020003秦超200031200020004陈征200031200020005章永华200031200020006白亦文200031200020007刘彩枝200031200020008曾晓兰200031200020009管红霞2000312000200010董丹2000312000200011刘盼2000312000200012刘生华150031150

2、0150013彭开红1500311500150014小计250002500025000151617181920212223242526总计250002500025000 制表人：刘拓 财务总监：总经理：董事长：工资表2011 年12月11日2012年1月10日序部门姓名转正工资试用期工资出勤天数业务津贴加班工资奖金补发奖金补发工资缺勤天数扣扣扣押金应发工资代扣个税扣扣实发工资签字及缺勤工资房租处罚款宿舍水电号岗位1袁力斌30200020002马煜辉30200020003孙光泽30200020004吴栋30200020005桂凡30200020006曾伟30200020007严满30200020

3、008易方敏30200020009周磊302000200010黄帅军302000200011朱华山302000200012张志东302000200013祁波302000200014周威302000200015黄牛302000200016游晨露302000200017黄牛302000200018卢功元302000200019孔祥文302000200020周山302000200021杜娟302000200022卢秀云302000200023金明华302000200024陈琴302000200025刘飒302000200026李清302000200027于征宇302000200028刘玉霞30180

4、01800总计5200052000 制表人：审核人：财务总监：总经理：工资表2011 年 3月序部门姓名基本工资试用期工资出勤天数基本工资管理补贴电话补助交通补助社保补贴卫生费缺勤天数扣应发工资代扣制服押金奖金补发工资实发工资签字入职日期及固定工资绩效工资缺勤工资号岗位1餐饮服务员余琴10003150020010020010005010502010/10/62餐饮服务员吴阿芳10003150020010020010005010502010/10/63餐饮服务员万丹10003150020010020010005010502010/11/44餐饮服务员钱清100031500200100200100

5、05010502010/12/115餐饮服务员叶丹100090031500200100200951505010512011/2/156餐饮服务员吴洋90018500100100200522305522011/3/147餐饮服务员曾松10003150020010020010005010502010/10/138餐饮服务员王琴1000305002001002001329685010182010/10/259餐饮服务员魏静900115001001002003193192011/3/2110餐饮服务员方圆90085001001002002322322011/3/2411收银员伍龙君1100315003

6、0010020011005011502010/12/1012收银员付秀11003150030010020011005011502010/10/2613吧员王冠1000150020010020032322011/3/3114传菜员度小燕100029500200100200264936509862011/1/1515传菜员卢进强1000900315002001002009645010142011/2/1116传菜员严磊90014500100100200406204262011/3/1817传菜员郑红英90075001001002002032032011/3/2518餐饮领班桂璐1400316002

7、0020010010020014005014502010/11/1219餐饮领班冯君兰14003160020020010010020014005014502010/11/1820餐饮主管邓小路150018600200200200100200870309002011/3/1521客房服务员刘丹9003147020020030900309302010/12/1022客房服务员度红云9003147020020030900309302010/10/2523客房服务员戚玉莲9003147020020030900309302010/10/2524客房服务员陈梅珍9003147020020030900309

8、302010/10/2525客房服务员韦利妹9003147020020030900309302010/10/2626客房服务员郑桂圆9003147020020030900309302010/10/25小计22763 制表人：刘拓 人力资源部：财务总监：总经理：董事长：工资表2011 年 3月序部门姓名基本工资试用期工资出勤天数基本工资管理补贴电话补助交通补助社保补贴卫生费缺勤天数扣应发工资代扣制服押金奖金补发工资实发工资签字入职日期及固定工资绩效工资缺勤工资号岗位1客房领班刘晓莉1200316002001001002001200300309302011/3/12布草员万爱华1000315002

9、0010020010003010302010/10/253客房主管胡静18003190020020020010020018003018302011/1/274保洁员朱银萍90031470200200309009002010/12/115保洁员胡晚元90031470200200309009002011/1/156保洁员孙秋娟800215001002005423002422011/3/117保洁员李安云90031470200200309009002010/12/108管事领班饶浩夏1400120031600200200100100200130913092011/2/149洗碗工施新华9003147

10、0200200309003006002010/12/2510洗碗工施春华800315001002008003005002011/3/111洗碗工刘细荣90031470200200309003006002011/12/3112洗碗工黎琦90031470200200309003006002011/12/3113前台领班李文霞120031600300100200120012002010/11/1314前台接待葛蕾120031600300100200120012002010/12/2515前台接待李维成1000155002001002004844842011/3/1716前台接待詹双妮10007500

11、2001002002262262011/3/2517库管罗鹏1300100031600300100100200118311832011/2/1218会计刘红140031600400100100200140014002011/1/119出纳徐雪梅1300100031600300100100200119311932011/2/1120采购经理陈强2000319005002002002002000100030002010/12/1521司机陈宗武137031770300100200137010214722011/2/2122工程人员韩清15003170040010010020015001500201

12、1/1/123人事主管刘拓160031700400100100100200160016002010/10/124预订员曾艳1100185002001001002006386382010/11/125小计254372627总计48201 制表人：刘拓 人力资源部：财务总监：总经理：董事长：离职人员工资表2011 年 3月序部门姓名转正工资试用期工资出勤天数基本工资管理补贴电话补助交通补助社保补贴卫生费缺勤天数扣应发工资代扣制服押金奖金补发工资实发工资签字入职日期及固定工资绩效工资缺勤工资号岗位1迎宾员石玲1100187002002006986982010/10/62传菜员度波1000246002

13、002007747742010/10/263传菜员徐春凤1000266002002008388382011/1/154前台接待罗爱120031700300200120012002010/10/65前台接待甘晓霞1000195003002006136132011/2/166789101112131415161718192021222324252627总计4123 制表人：刘拓 人力资源部：财务总监：总经理：董事长：工资表2011 年 3月序部门姓名出勤天数基本工资管理补贴电话补助交通补助社保补贴卫生费缺勤天数扣应发工资代扣制服押金奖金补发工资实发工资签字入职日期及固定工资绩效工资缺勤工资号岗位1

14、餐饮服务员余琴3160020020010005010502010/10/62餐饮服务员吴阿芳3160020020010005010502010/10/63餐饮服务员万丹3160020020010005010502010/11/44餐饮服务员钱清3160020020010005010502010/12/115餐饮服务员叶丹316002002001000505011002011/2/156餐饮服务员吴洋18600100200900309302011/3/147餐饮服务员曾松3160020020010005010502010/10/138餐饮服务员王琴306002002001321028501078

15、2010/10/259餐饮服务员魏静116001002009009002011/3/2110餐饮服务员方圆86001002009009002011/3/2411收银员伍龙君3160030020011005011502010/12/1012收银员付秀3160030020011005011502010/10/2613吧员王冠1600200200100010002011/3/3114传菜员度小燕296002002002649965010462011/1/1515传菜员卢进强3160020020010005010502011/2/1116传菜员严磊14600100200900209202011/3/1

16、817传菜员郑红英76001002009009002011/3/2518餐饮领班桂璐31100020020014005014502010/11/1219餐饮领班冯君兰31100020020014005014502010/11/1820餐饮主管邓小路18110020020015003015302011/3/1521客房服务员刘丹31500200200900309302010/12/1022客房服务员度红云31500200200900309302010/10/2523客房服务员戚玉莲31500200200900309302010/10/2524客房服务员陈梅珍31500200200900309302010/10/2525客房服务员韦利妹31500200200900309302010/10/2626客房服务员郑桂圆31500200200900309302010/10/25小计27384 制表人：刘拓 人力资源部：财务总监：总经理：董事长：工资表2011 年 3月序部门姓名出勤天数基本工资管理补贴电话补助交通补助社保补贴卫生费缺勤天数扣应发工资代扣制服押金奖金补发工资实发工资签字入职日期及固定