【薪酬福利管理工具】员工工资查询及工资条生成工具（任一编号）.xlsx

人力资源管理工具薪酬福利 员工工资查询及工资条生成工具B（根据编号查询，可批量直接打印）注：本工具主要用于通过编号自动生成任一员工的工资条（数据来源于工资明细表），以下表格数据只需要输入编号即可，其他为全部自动生成，设置了一种彩色标题的、一种灰色标题的两种，供任意选择，且特意安排了多条内容，可以批量直接打印。功能特点：1、通过下拉菜单输入任一员工编号，即可自动生成员工姓名、个人工资明细及工资条，非常便捷；2、可在员工工资明细表中随意添加信息及数据（包括标题行），查询工具中的标题及数据都将自动随之变化并生成您所需要的工资条。使用方法：首先，在员工工资明细表中录入相关信息与数据，然后在本表格中通过下拉菜单输入员工编号即可查询并生成工资条。温馨提示：关于数据信息增减，此表数据来源于明细表，所以只需要在明细表中按照说明进行数据增减即可，不要操作本表格。需要注意：表格右侧预留了部分带函数公式的单元格（可增加数据6列），请勿删除，便于新增项目数据自动生成；另外，如果明细表数据增减，本表格数据会随之对应变化，但是部分单元格格式可能会发生变化，例如数字格式、标题颜色标注，这些需要后期手工进行调整。姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注何小虎2016010621213,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.00￥7,975.007,975.00社保已扣姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注赵六20160112212018,166.672,000.005,566.67200.00500.00600.00300.00600.0026,733.334,803.33￥21,930.0021,930.00姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注满满20160117212030,666.672,000.0010,066.67200.00500.00600.00300.00200.00600.0043,533.339,255.00￥34,278.3334,278.33姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注版权所有：北京未名潮管理顾问有限公司何建湘美人鱼420160121212111,000.0010,000.004,000.00200.00600.00600.00500.00200.00600.00104.0025,996.004,619.00￥21,377.0021,377.00姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注美人鱼72016012421202,000.0016,000.007,000.00200.00800.00600.00100.00200.00600.00107.0025,793.004,568.25￥21,224.7521,224.75姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注美RY82016012521189,000.0018,000.008,000.00200.00800.00600.00200.00200.00600.0050.0035,950.007,107.50￥28,842.5028,842.50姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注美人鱼美RY2016211910,000.0012,000.00800.00200.005,200.00600.00200.00100.00600.00105.0028,195.005,168.75￥23,026.2523,026.25社保已扣姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注小鱼儿2016012721206,000.002,000.002,000.00200.004,000.00600.00100.0050.00600.00300.0013,950.001,607.50￥12,342.5012,342.50姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注李四20160110212013,166.6710,000.003,766.67200.00500.00600.00300.0050.00600.00104.0027,779.335,064.83￥22,714.5022,714.50姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注美人鱼320160120212112,000.008,000.003,000.00200.007,500.00600.00500.0050.00600.00103.0031,047.005,881.75￥25,165.2525,165.25版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘 人力资源管理工具薪酬福利员工工资明细表（含最新税率计算公式）说明：本工资表适合一般中小企业，所列项目相对简单实用。（工资项目内容仅供参考，企业可根据实际需求略作调整，其中扣款后税前应发、个人所得税、最终实发工资等关键数据为自动生成（已用颜色标注）；个人所得税计算方式是依据最新税率公式而编制，3500元起征。）注：1、若有重名，建议添加字母予以区分，使其名字唯一性。2、如果添加列，建议在对应栏中插入列，例如应发项，在E列与K列之间插入列；如果删除列，直接删除即可。3、如果添加行，直接在表格下方添加即可，但是需要为新增单元格设置函数公式。序号姓名员工编号应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注合计281,000.00146,000.00100,200.00 4,400.00 41,400.0013,200.006,000.002,950.0013,200.00 2,717.00573,333.00102,581.16470,751.841何小虎2016010621213,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.007,975.007,975.00社保已扣2黄小马2016010721186,000.004,000.001,000.00200.00500.00600.00300.00200.00600.00101.0011,699.001,084.8010,614.2010,614.203何大马2016010821158,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.00102.0019,998.003,119.5016,878.5016,878.504张三20160109211710,666.678,000.002,866.67200.00500.00600.00300.000.00600.00103.0022,430.333,727.5818,702.7518,702.755李四20160110212013,166.6710,000.003,766.67200.00500.00600.00300.0050.00600.00104.0027,779.335,064.8322,714.5022,714.506王五20160111212115,666.672,000.004,666.67200.00500.00600.00300.000.00600.00300.0023,033.333,878.3319,155.0019,155.007赵六20160112212018,166.672,000.005,566.67200.00500.00600.00300.000.00600.000.0026,733.334,803.3321,930.0021,930.008圆圆120160113212020,666.672,000.006,466.67200.00500.00600.00300.00200.00600.00107.0029,826.335,576.5824,249.7524,249.75社保已扣9黄小小20160114212023,166.672,000.007,366.67200.00500.00600.00300.000.00600.00500.0033,033.336,378.3326,655.0026,655.0010何大大20160115212025,666.672,000.008,266.67200.00500.00600.00300.00200.00600.00109.0036,624.337,276.0829,348.2529,348.2511小鱼儿2016012721206,000.002,000.002,000.00200.004,000.00600.00100.0050.00600.00300.0013,950.001,607.5012,342.5012,342.5012圆圆220160116212028,166.672,000.009,166.67200.00500.00600.00300.00200.00600.00110.0040,023.338,202.0031,821.3331,821.33社保已扣13满满20160117212030,666.672,000.0010,066.67200.00500.00600.00300.00200.00600.000.0043,533.339,255.0034,278.3334,278.3314美人鱼鱼MRY00121206,000.004,000.001,000.00200.00500.00600.00300.00100.00600.00101.0011,799.001,104.8010,694.2010,694.2015美人鱼22016011921219,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.000.0021,100.003,395.0017,705.0017,705.00社保已扣16美人鱼320160120212112,000.008,000.003,000.00200.007,500.00600.00500.0050.00600.00103.0031,047.005,881.7525,165.2525,165.2517美人鱼420160121212111,000.0010,000.004,000.00200.00600.00600.00500.00200.00600.00104.0025,996.004,619.0021,377.0021,377.0018美人鱼2016012221218,000.0012,000.005,000.00200.005,200.00600.00200.00200.00600.00105.0030,295.005,693.7524,601.2524,601.2519美人鱼62016012321195,000.0014,000.006,000.00200.00800.00600.00400.00200.00600.00106.0026,094.004,643.5021,450.5021,450.5020美人鱼72016012421202,000.0016,000.007,000.00200.00800.00600.00100.00200.00600.00107.0025,793.004,568.2521,224.7521,224.7521美RY82016012521189,000.0018,000.008,000.00200.00800.00600.00200.00200.00600.0050.0035,950.007,107.5028,842.5028,842.5022美人鱼美RY2016211910,000.0012,000.00800.00200.005,200.00600.00200.00100.00600.00105.0028,195.005,168.7523,026.2523,026.25社保已扣版权所有：北京未名潮管理顾问有限公司