Excel表格模板：工资管理系统(简单实用).xlsx

《Excel表格模板：工资管理系统(简单实用).xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：工资管理系统(简单实用).xlsx（122页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、职工基本信息基本工资表社会保险表考勤表计算比率表员工福利表工资结算表奖金计算表工资条工资管理系统(简单实用版）员工查询表使用说明工资管理系统(简单实用版）职工基本信息表编号姓 名部门职务参加工作时间性别出生日期身份证号码A001张三董事会董事长2015/1/1男1992/1/1A002李四行政部部门经理2005/1/1男1984/1/1户口所在地联系电话E-mail银行账号返回主页职工福利费一览表编号姓 名部门住房补贴伙食补贴交通补贴医疗补助A001张三董事会200010002000500A002李四行政部80060010003000000000000000000000000000000000

2、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

3、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000合计5500270000000000000000000000000000返回主页000000

4、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000工资计算比率表社会保险及住房公积金奖金计算标准扣缴比例项目单位个人出勤情况每天扣款（元）养老保险20%8%全勤0医疗保险8%2%病假15失业保险2%1%事假30住房公积金12%12%旷工60个人应税所得税工资费用分配表起征点2000项目扣除比例应税所得额=应发合计-起征点职

5、工福利费14%级数全月应纳税所得额税率速扣数工会经费2%1不超过500元的部分5.00%0教育经费2.5%2超过500元2000元的部分10.00%253超过2000元5000元的部分15.00%1254超过5000元20000元的部分20.00%375工龄工资计算标准5超过20000元40000元的部分25.00%1375年限每年金额6超过40000元60000元的部分30.00%33751307超过60000元80000元的部分35.00%63758超过80000元100000元的部分40.00%103759超过100000元的部分45.00%15375最高限500返回主页奖金计算标准工资

6、费用分配表工龄工资计算标准职工工资一览表编号姓 名部门基础工资岗位工资工龄工资计划奖金A001张三董事会200001000090500A002李四行政部60002000390150000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

7、000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

8、000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

9、000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050000050

10、0000500000500000500000500000500000500000500000500000500000500000500000500工资合计300908390500500500500500500500500500500500500500500500500500500500500500500500500500500500500返回主页500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500

11、500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500500

12、500500500500500500500500500500500500500500500500500500500500500500500500500500500职工社会保险缴纳情况一览表编号姓 名部门养老保险医疗保险失业保险A001张三董事会2407.20601.80300.90A002李四行政部671.20167.8083.9000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005

13、.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.00

14、10.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000

15、040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.00

16、5.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0

17、010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.000

18、0040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.0

19、05.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.

20、0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.00

21、00040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.

22、005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040

23、.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.0000040.0010.005.00 合计3309.90922.9055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.00

24、55.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.00返回主页55.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.005

25、5.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.005

26、5.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.0055.00选

27、择年月2018年1月2018年1月份考勤表编号姓 名部门1234567891011一二三四五六日一二三四A001张三董事会出勤出勤出勤出勤出勤A002李四行政部出勤出勤出勤出勤事假000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000返回主页00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

28、00000000000000000000000000000000000000000000000000000000000000000000000001213141516171819202122232425五六日一二三四五六日一二三四2018年1月份考勤表262728293031五六日一二三奖金计算表编号姓名计划奖金实际奖金计算请假天数统计病假事假旷工A001张三500500.00100A002李四15001450.000100000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.00000

29、0.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.0000

30、00.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000

31、000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.00

32、0000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.0

33、00000.000000.000000.000000.000000.000000.000000.000000.000000.000000.000000.00返回主页1 月工资结算清单月份编号姓 名部门基本工资岗位工资工龄工资住房补贴伙食补贴交通补贴医疗补助奖金应发合计住房公积金养老保险医疗保险1A001张三董事会20000100009020001000200050050036090433124076021A002李四行政部600020003908006001000300145012540150567116815005006040101500500604010150050060401015005

34、0060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010返回主页1500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015

35、005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150

36、050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500

37、500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005

38、006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050

39、060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500

40、604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006

41、040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010150050060

42、401015005006040101500500604010150050060401015005006040101500500604010150050060401015005006040101500500604010失业保险应税所得额个人所得税应扣合计实发合计30128449523212873232178410112767319593455385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

43、538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

44、538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

45、538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

46、538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

47、538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

48、538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385538511538553851153855385115385

49、538511538553851153855385115385工 资 条月份编号姓 名 部门 基本工资岗位工资工龄工资住房补贴 伙食补贴 交通补贴 医疗补助 奖金 应发合计住房公积金 养老保险医疗保险失业保险应税所得额个人所得税应扣合计1A001 张三董事会 200001000090200010002000500500360904330.82407.2601.8300.928449.35232.3312873月份编号姓 名 部门 基本工资岗位工资工龄工资住房补贴 伙食补贴 交通补贴 医疗补助 奖金 应发合计住房公积金 养老保险医疗保险失业保险应税所得额个人所得税应扣合计1A002 李四行政部60

50、00200039080060010003001450125401504.8671.2167.883.910112.3767.463195.16月份编号姓 名 部门 基本工资岗位工资工龄工资住房补贴 伙食补贴 交通补贴 医疗补助 奖金 应发合计住房公积金 养老保险医疗保险失业保险应税所得额个人所得税应扣合计1000005000000050060401053850115月份编号姓 名 部门 基本工资岗位工资工龄工资住房补贴 伙食补贴 交通补贴 医疗补助 奖金 应发合计住房公积金 养老保险医疗保险失业保险应税所得额个人所得税应扣合计1000005000000050060401053850115月份编