EXCEl模板：员工工资查询及工资条生成工具(任一编号在姓名后).xlsx

《EXCEl模板：员工工资查询及工资条生成工具(任一编号在姓名后).xlsx》由会员分享，可在线阅读，更多相关《EXCEl模板：员工工资查询及工资条生成工具(任一编号在姓名后).xlsx（17页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、 人力资源管理实用工具薪酬福利薪酬管理工具员工工资查询及工资条生成工具（编号查询，编号在姓名后面）注：本工具主要用于编号查询员工工资明细并自动生成对应工资条。使用方法：首先，在员工工资明细表中录入相关信息与数据（可更改项目），其中颜色标注部分无需录入数据，然后在本表格中只需要输入员工编号即可。注：只需要输入任一员工编号，即可自动生成员工个人工资明细及工资条；本工具可在员工工资明细表中随意添加信息及数据，查询工具中的标题及数据都将自动随之变化并生成您所需要的工资条。（表格中部分显示数字0的单元格为带函数的预留单元格，若无添加项目请忽略）姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效

2、效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注美美人人鱼鱼 美RY2016211910,000.00 12,000.00800.00200.00 5,200.00600.00200.00100.00600.00105.0028,195.005,168.75￥23,026.2523,026.25社保已扣姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利

3、利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注美美人人鱼鱼2 2 2016011921219,000.006,000.002,000.00200.00 4,000.00600.00100.00200.00600.000.0021,100.003,395.00￥17,705.0017,705.00社保已扣姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利

4、利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注美美RY8RY82016012521189,000.0018,000.00 8,000.00200.00800.00600.00200.00200.00600.0050.0035,950.007,107.50￥28,842.5028,842.500姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发

5、发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注何何小小虎虎 2016010621213,000.002,000.00200.00200.00 3,000.00600.00300.00200.00600.00100.008,400.00425.00￥7,975.007,975.00社保已扣版权所有：北京未名潮管理顾问有限公司何建湘姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税

6、税后后实实发发工工资资员员工工签签字字备备注注美美人人鱼鱼3 3 20160120212112,000.008,000.003,000.00200.00 7,500.00600.00500.0050.00600.00103.0031,047.005,881.75￥25,165.2525,165.250姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注何何大

7、大大大 20160115212025,666.672,000.008,266.67200.00500.00600.00300.00200.00600.00109.0036,624.337,276.08￥29,348.2529,348.250姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注满满满满20160117212030,666.672,000.00

8、10,066.67 200.00500.00600.00300.00200.00600.000.0043,533.339,255.00￥34,278.3334,278.330姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注赵赵六六20160112212018,166.672,000.005,566.67200.00500.00600.00300.000.

9、00600.000.0026,733.334,803.33￥21,930.0021,930.000姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注美美人人鱼鱼 鱼MRY00121206,000.004,000.001,000.00200.00500.00600.00300.00100.00600.00101.0011,799.001,104.80￥10,

10、694.2010,694.200姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字备备注注美美人人鱼鱼6 6 2016012321195,000.0014,000.00 6,000.00200.00800.00600.00400.00200.00600.00106.0026,094.004,643.50￥21,450.5021,450.500版权所有：北京未名潮管

11、理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司版权所有：北京未名潮管理顾问有限公司何建湘00000000000000000000000000000000版权所有：北京未名潮管理顾问有限公司何建湘000000000000000000000000000000000000000000000000版权所有：北京未名潮管理顾问有限公司何建湘 人力资源管理实用工具薪酬福利薪酬管理工具员工工资明细表（含最新税率计算公式）说明：本工资表适合一般中小企业，所列项目相对简单实用。（工资项目内容仅供参考，企业可根据实际需求略作调整，其中扣款后税前应发、个人所得税、最终实发工资等关键数据为自动生成（已用颜色

12、标注）；个人所得税计算方式是依据最新税率公式而编制，3500元起征。）姓姓名名员员工工编编号号应出勤实际出勤基基本本工工资资绩绩效效工工资资补补贴贴加加班班费费奖奖金金社社保保福福利利 其其它它应应发发考考勤勤扣扣款款社社保保福福利利代代缴缴扣扣款款其其它它应应扣扣扣扣款款后后税税前前应应发发个个人人所所得得税税税税后后实实发发工工资资员员工工签签字字何小虎2016010621213,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.007,975.00黄小马2016010721186,000

13、.004,000.001,000.00200.00500.00600.00300.00200.00600.00101.0011,699.001,084.8010,614.20何大马2016010821158,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.00102.0019,998.003,119.5016,878.50张三20160109211710,666.678,000.002,866.67200.00500.00600.00300.000.00600.00103.0022,430.333,727.5818,702.7

14、5李四20160110212013,166.6710,000.003,766.67200.00500.00600.00300.0050.00600.00104.0027,779.335,064.8322,714.50王五20160111212115,666.672,000.004,666.67200.00500.00600.00300.000.00600.00300.0023,033.333,878.3319,155.00赵六20160112212018,166.672,000.005,566.67200.00500.00600.00300.000.00600.000.0026,733.334

15、,803.3321,930.00圆圆20160113212020,666.672,000.006,466.67200.00500.00600.00300.00200.00600.00107.0029,826.335,576.5824,249.75黄小小20160114212023,166.672,000.007,366.67200.00500.00600.00300.000.00600.00500.0033,033.336,378.3326,655.00何大大20160115212025,666.672,000.008,266.67200.00500.00600.00300.00200.006

16、00.00109.0036,624.337,276.0829,348.25小鱼儿2016012721206,000.002,000.002,000.00200.004,000.00600.00100.0050.00600.00300.0013,950.001,607.5012,342.50圆圆20160116212028,166.672,000.009,166.67200.00500.00600.00300.00200.00600.00110.0040,023.338,202.0031,821.33满满20160117212030,666.672,000.0010,066.67200.0050

17、0.00600.00300.00200.00600.000.0043,533.339,255.0034,278.33美人鱼鱼MRY00121206,000.004,000.001,000.00200.00500.00600.00300.00100.00600.00101.0011,799.001,104.8010,694.20美人鱼2 2016011921219,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.000.0021,100.003,395.0017,705.00美人鱼3 20160120212112,000.008

18、,000.003,000.00200.007,500.00600.00500.0050.00600.00103.0031,047.005,881.7525,165.25美人鱼4 20160121212111,000.0010,000.004,000.00200.00600.00600.00500.00200.00600.00104.0025,996.004,619.0021,377.00美人鱼2016012221218,000.0012,000.005,000.00200.005,200.00600.00200.00200.00600.00105.0030,295.005,693.7524,6

19、01.25美人鱼6 2016012321195,000.0014,000.006,000.00200.00800.00600.00400.00200.00600.00106.0026,094.004,643.5021,450.50美人鱼7 2016012421202,000.0016,000.007,000.00200.00800.00600.00100.00200.00600.00107.0025,793.004,568.2521,224.75美RY82016012521189,000.0018,000.008,000.00200.00800.00600.00200.00200.00600.

20、0050.0035,950.007,107.5028,842.50美人鱼美RY2016211910,000.0012,000.00800.00200.005,200.00600.00200.00100.00600.00105.0028,195.005,168.7523,026.25合合计计271,000.00 134,000.00 99,400.00 4,200.00 36,200.00 12,600.00 5,800.00 2,850.00 12,600.00 2,612.00 545,138.00 230,232.10 314,905.90版权所有：北京未名潮管理顾问有限公司备备注注社保已扣社保已扣社保已扣说明：本工资表适合一般中小企业，所列项目相对简单实用。（工资项目内容仅供参考，企业可根据实际需求略作调整，其中扣款后税前应发、个人所得税、最终实发工资等关键数据为自动生成（已用颜色标注）；个人所得税计算方式是依据最新税率公式而编制，3500元起征。）社保已扣社保已扣