表格模板-企业工资表模板 精品.xls

《表格模板-企业工资表模板 精品.xls》由会员分享，可在线阅读，更多相关《表格模板-企业工资表模板 精品.xls（9页珍藏版）》请在第一文库网上搜索。

1、员员工工薪薪资资管管理理表表员员工工编编号号员员工工姓姓名名所所属属部部门门基基本本工工资资业业绩绩奖奖金金住住房房补补助助应应扣扣请请假假费费00010001李海销售部￥4,600￥1,720￥600￥15300020002苏杨销售部￥5,000￥57,000￥800￥000030003陈霞销售部￥4,600￥5,600￥500￥7700040004武海销售部￥4,600￥0￥500￥3100050005刘繁销售部￥4,800￥4,080￥500￥000060006袁锦辉销售部￥3,700￥0￥500￥6200070007贺华销售部￥3,700￥12,000￥500￥000080008钟兵销

2、售部￥3,700￥13,200￥500￥2500090009丁芬销售部￥3,700￥1,200￥500￥000100010程静销售部￥3,900￥1,200￥400￥000110011刘健销售部￥3,000￥1,800￥400￥10000120012苏江销售部￥3,000￥14,760￥400￥000130013廖嘉销售部￥3,000￥5,200￥400￥000140014刘佳销售部￥3,000￥880￥400￥3000150015陈永销售部￥2,850￥0￥450￥000160016周繁销售部￥3,150￥6,400￥450￥4200170017周波销售部￥3,150￥22,200￥450￥

3、2100180018熊亮销售部￥3,150￥7,200￥450￥105 00010001李海销售部￥4,600￥1,720￥600￥15300020002苏杨销售部￥5,000￥57,000￥800￥000030003陈霞销售部￥4,600￥5,600￥500￥7700040004武海销售部￥4,600￥0￥500￥3100050005刘繁销售部￥4,800￥4,080￥500￥000060006袁锦辉销售部￥3,700￥0￥500￥6200070007贺华销售部￥3,700￥12,000￥500￥000080008钟兵销售部￥3,700￥13,200￥500￥2500090009丁芬销售部￥

4、3,700￥1,200￥500￥000100010程静销售部￥3,900￥1,200￥400￥000110011刘健销售部￥3,000￥1,800￥400￥10000120012苏江销售部￥3,000￥14,760￥400￥000130013廖嘉销售部￥3,000￥5,200￥400￥000140014刘佳销售部￥3,000￥880￥400￥3000150015陈永销售部￥2,850￥0￥450￥000160016周繁销售部￥3,150￥6,400￥450￥4200170017周波销售部￥3,150￥22,200￥450￥2100180018熊亮销售部￥3,150￥7,200￥450￥105工

5、工资资总总额额应应扣扣所所得得税税应应扣扣劳劳保保金金额额实实际际应应付付工工资资￥6,767￥0￥300￥6,467￥62,800 ￥6,280￥300￥56,220￥10,623 ￥1,062￥300￥9,261￥5,069￥0￥300￥4,769￥9,380￥0￥300￥9,080￥4,138￥0￥300￥3,838￥16,200 ￥1,620￥300￥14,280￥17,375 ￥1,738￥300￥15,338￥5,400￥0￥300￥5,100￥5,500￥0￥300￥5,200￥5,100￥0￥300￥4,800￥18,160 ￥1,816￥300￥16,044￥8,600￥0￥

6、300￥8,300￥4,250￥0￥300￥3,950￥3,300￥0￥300￥3,000￥9,958￥0￥300￥9,658￥25,779 ￥2,578￥300￥22,901￥10,695 ￥1,070￥300￥9,326 ￥6,767￥0￥300￥6,467￥62,800 ￥6,280￥300￥56,220￥10,623 ￥1,062￥300￥9,261￥5,069￥0￥300￥4,769￥9,380￥0￥300￥9,080￥4,138￥0￥300￥3,838￥16,200 ￥1,620￥300￥14,280￥17,375 ￥1,738￥300￥15,338￥5,400￥0￥300￥5,1

7、00￥5,500￥0￥300￥5,200￥5,100￥0￥300￥4,800￥18,160 ￥1,816￥300￥16,044￥8,600￥0￥300￥8,300￥4,250￥0￥300￥3,950￥3,300￥0￥300￥3,000￥9,958￥0￥300￥9,658￥25,779 ￥2,578￥300￥22,901￥10,695 ￥1,070￥300￥9,326员员工工薪薪资资记记录录表表员员工工编编号号员员工工姓姓名名所所属属部部门门最最后后一一次次调调薪薪时时间间调调整整后后的的基基础础工工资资调调整整后后的的岗岗位位工工资资调调整整后后的的工工龄龄工工资资调调整整后后总总基基本本工工

8、资资0001李海销售部2004/4/1 ￥2,000 ￥1,800￥800￥4,6000002苏杨销售部2004/4/1 ￥2,000 ￥2,000 ￥1,000 ￥5,0000003陈霞销售部2004/4/1 ￥2,000 ￥1,800￥800￥4,6000004武海销售部2004/4/1 ￥2,000 ￥1,800￥800￥4,6000005刘繁销售部2004/4/1 ￥2,000 ￥2,000￥800￥4,8000006袁锦辉销售部2004/4/1 ￥1,500 ￥1,400￥800￥3,7000007贺华销售部2004/4/1 ￥1,500 ￥1,400￥800￥3,7000008钟兵

9、销售部2004/4/1 ￥1,500 ￥1,400￥800￥3,7000009丁芬销售部2004/4/1 ￥1,500 ￥1,400￥800￥3,7000010程静销售部2004/4/1 ￥1,500 ￥1,400 ￥1,000 ￥3,9000011刘健销售部2004/4/1 ￥1,000 ￥1,000 ￥1,000 ￥3,0000012苏江销售部2004/4/1 ￥1,000 ￥1,000 ￥1,000 ￥3,0000013廖嘉销售部2004/4/1 ￥1,000 ￥1,000 ￥1,000 ￥3,0000014刘佳销售部2004/4/1 ￥1,000 ￥1,000 ￥1,000 ￥3,00

10、00015陈永销售部2004/4/1 ￥1,000 ￥1,000￥850￥2,8500016周繁销售部2004/4/1 ￥1,200 ￥1,100￥850￥3,1500017周波销售部2004/4/1 ￥1,200 ￥1,100￥850￥3,1500018熊亮销售部2004/4/1 ￥1,200 ￥1,100￥850￥3,150银银行行账账号号0000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-56

11、78-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-0010000-1234-5678-9123-001员员工工出出勤勤统统计计表

12、表员员工工编编号号员员工工姓姓名名所所属属部部门门事事假假病病假假00010001李海销售部100020002苏杨销售部00030003陈霞销售部0.500040004武海销售部100050005刘繁销售部00060006袁锦辉销售部0.500070007贺华销售部00080008钟兵销售部100090009丁芬销售部00100010程静销售部00110011刘健销售部100120012苏江销售部00130013廖嘉销售部00140014刘佳销售部1.500150015陈永销售部00160016周繁销售部0.400170017周波销售部100180018熊亮销售部1员员工工业业绩绩表表员员工工

13、编编号号员员工工姓姓名名所所属属部部门门销销售售业业绩绩额额业业绩绩总总奖奖金金00010001李李海海销售部￥43,000￥1,72000020002苏苏杨杨销售部￥280,000￥57,00000030003陈陈霞霞销售部￥70,000￥5,60000040004武武海海销售部￥16,000￥000050005刘刘繁繁销售部￥51,000￥4,08000060006袁袁锦锦辉辉销售部￥8,000￥000070007贺贺华华销售部￥100,000￥12,00000080008钟钟兵兵销售部￥110,000￥13,20000090009丁丁芬芬销售部￥30,000￥1,20000100010程

14、程静静销售部￥30,000￥1,20000110011刘刘健健销售部￥45,000￥1,80000120012苏苏江江销售部￥123,000￥14,76000130013廖廖嘉嘉销售部￥65,000￥5,20000140014刘刘佳佳销售部￥22,000￥88000150015陈陈永永销售部￥13,200￥000160016周周繁繁销售部￥80,000￥6,40000170017周周波波销售部￥90,000￥22,20000180018熊熊亮亮销售部￥90,000￥7,200员员工工福福利利表表员员工工编编号号员员工工姓姓名名所所属属部部门门住住房房补补贴贴劳劳保保金金额额00010001李海

15、销售部￥600￥30000020002苏杨销售部￥800￥30000030003陈霞销售部￥500￥30000040004武海销售部￥500￥30000050005刘繁销售部￥500￥30000060006袁锦辉销售部￥500￥30000070007贺华销售部￥500￥30000080008钟兵销售部￥500￥30000090009丁芬销售部￥500￥30000100010程静销售部￥400￥30000110011刘健销售部￥400￥30000120012苏江销售部￥400￥30000130013廖嘉销售部￥400￥30000140014刘佳销售部￥400￥30000150015陈永销售部￥450￥30000160016周繁销售部￥450￥30000170017周波销售部￥450￥30000180018熊亮销售部￥450￥300