【薪酬福利管理工具】横版工资条生成工具 （打印剪裁随意改）.xlsx

人力资源管理工具薪酬福利2020年1月 员工工资明细表（含税率计算，自动提示发放记录）说明：本工资表适合一般中小企业，所列项目相对简单实用。（工资项目内容仅供参考，企业可根据实际需求略作调整，其中扣款后税前应发、个人所得税、最终实发工资等关键数据为自动生成（已用颜色标注）；个人所得税计算方式是依据最新税率公式而编制，3500元起征。）如果发放日期已经填入，名单会自动显示为绿色，表示已发放。关于数据修改：1、如果不增减任何项目（不操作行、列），直接修改名称即可，数据正常录入或者删除文字信息都没有问题。2、如果增加名单（即增加行），可直接在表格下方添加数据，但需要为新增单元格设置函数公式；3、如果增加工资标题项目（即增加列），可以直接插入列（新增控制在10列以内）；如果减少工资标题项目，直接删除列即可，但是需要注意：增减列以后，需要调整工资条中对应的单元格格式变化。序号月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字 发放日期12020/120160106何小虎3,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.007,975.007,975.002018/1/3022020/120160107黄小马6,000.004,000.001,000.00200.00500.00600.00300.00200.00600.00101.0011,699.001,084.8010,614.2010,614.202018/1/3032020/120160108何大马8,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.00102.0019,998.003,119.5016,878.5016,878.502018/1/3042020/120160109张三10,666.678,000.002,866.67200.00500.00600.00300.000.00600.00103.0022,430.333,727.5818,702.7518,702.7552020/120160110李四13,166.6710,000.003,766.67200.00500.00600.00300.0050.00600.00104.0027,779.335,064.8322,714.5022,714.502018/1/3062020/120160111王五15,666.672,000.004,666.67200.00500.00600.00300.000.00600.00300.0023,033.333,878.3319,155.0019,155.002018/1/3072020/120160112赵六18,166.672,000.005,566.67200.00500.00600.00300.000.00600.000.0026,733.334,803.3321,930.0021,930.0082020/120160113圆圆120,666.672,000.006,466.67200.00500.00600.00300.00200.00600.00107.0029,826.335,576.5824,249.7524,249.752018/1/3092020/120160114黄小小23,166.672,000.007,366.67200.00500.00600.00300.000.00600.00500.0033,033.336,378.3326,655.0026,655.002018/1/30102020/120160115何大大25,666.672,000.008,266.67200.00500.00600.00300.00200.00600.00109.0036,624.337,276.0829,348.2529,348.252018/1/30112020/120160127小鱼儿6,000.002,000.002,000.00200.004,000.00600.00100.0050.00600.00300.0013,950.001,607.5012,342.5012,342.502018/1/30122020/120160116圆圆228,166.672,000.009,166.67200.00500.00600.00300.00200.00600.00110.0040,023.338,202.0031,821.3331,821.332018/1/30132020/120160117满满30,666.672,000.0010,066.67200.00500.00600.00300.00200.00600.000.0043,533.339,255.0034,278.3334,278.332018/1/30142020/1鱼MRY001美人鱼S6,000.004,000.001,000.00200.00500.00600.00300.00100.00600.00101.0011,799.001,104.8010,694.2010,694.202018/1/30152020/120160119美人鱼29,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.000.0021,100.003,395.0017,705.0017,705.00162020/120160120美人鱼312,000.008,000.003,000.00200.007,500.00600.00500.0050.00600.00103.0031,047.005,881.7525,165.2525,165.25172020/120160121美人鱼411,000.0010,000.004,000.00200.00600.00600.00500.00200.00600.00104.0025,996.004,619.0021,377.0021,377.00182020/120160122美人鱼8,000.0012,000.005,000.00200.005,200.00600.00200.00200.00600.00105.0030,295.005,693.7524,601.2524,601.25192020/120160123美人鱼65,000.0014,000.006,000.00200.00800.00600.00400.00200.00600.00106.0026,094.004,643.5021,450.5021,450.50202020/120160124美人鱼72,000.0016,000.007,000.00200.00800.00600.00100.00200.00600.00107.0025,793.004,568.2521,224.7521,224.75212020/120160125美RY89,000.0018,000.008,000.00200.00800.00600.00200.00200.00600.0050.0035,950.007,107.5028,842.5028,842.50222020/1美RY2016美人鱼10,000.0012,000.00800.00200.005,200.00600.00200.00100.00600.00105.0028,195.005,168.7523,026.2523,026.25版权所有：北京未名潮管理顾问有限公司备注社保已扣社保已扣社保已扣说明：本工资表适合一般中小企业，所列项目相对简单实用。（工资项目内容仅供参考，企业可根据实际需求略作调整，其中扣款后税前应发、个人所得税、最终实发工资等关键数据为自动生成（已用颜色标注）；个人所得税计算方式是依据最新税率公式而编制，3500元起征。）如果发放日期已经填入，名单会自动显示为绿色，表示已发放。关于数据修改：1、如果不增减任何项目（不操作行、列），直接修改名称即可，数据正常录入或者删除文字信息都没有问题。2、如果增加名单（即增加行），可直接在表格下方添加数据，但需要为新增单元格设置函数公式；3、如果增加工资标题项目（即增加列），可以直接插入列（新增控制在10列以内）；如果减少工资标题项目，直接删除列即可，但是需要注意：增减列以后，需要调整工资条中对应的单元格格式变化。社保已扣社保已扣横版工资条生成工具（适合直接打印、剪裁，可随意修改数据）注：本工具主要用于通过编号自动生成任一员工的横版工资条（数据来源于工资明细表），方便直接打印、剪裁。功能特点：1、通过下拉菜单输入任一员工编号，即可自动生成工资条，非常便捷；2、工资条设计成可直接打印、剪裁的横条版式；3、可在工资明细表中随意添加信息及数据（包括标题行），工资条中的标题及数据都将自动随之变化并生成您所需要的工资条。月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160106何小虎3,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.007,975.007,975.002018/1/30社保已扣月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160107黄小马6,000.004,000.001,000.00200.00500.00600.00300.00200.00600.00101.0011,699.001,084.8010,614.2010,614.202018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160108何大马8,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.00102.0019,998.003,119.5016,878.5016,878.502018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160109张三10,666.678,000.002,866.67200.00500.00600.00300.00600.00103.0022,430.333,727.5818,702.7518,702.75月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160110李四13,166.6710,000.003,766.67200.00500.00600.00300.0050.00600.00104.0027,779.335,064.8322,714.5022,714.502018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160111王五15,666.672,000.004,666.67200.00500.00600.00300.00600.00300.0023,033.333,878.3319,155.0019,155.002018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160112赵六18,166.672,000.005,566.67200.00500.00600.00300.00600.0026,733.334,803.3321,930.0021,930.00月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160113圆圆120,666.672,000.006,466.67200.00500.00600.00300.00200.00600.00107.0029,826.335,576.5824,249.7524,249.752018/1/30社保已扣月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160114黄小小23,166.672,000.007,366.67200.00500.00600.00300.00600.00500.0033,033.336,378.3326,655.0026,655.002018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160115何大大25,666.672,000.008,266.67200.00500.00600.00300.00200.00600.00109.0036,624.337,276.0829,348.2529,348.252018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160116圆圆228,166.672,000.009,166.67200.00500.00600.00300.00200.00600.00110.0040,023.338,202.0031,821.3331,821.332018/1/30社保已扣月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160117满满30,666.672,000.0010,066.67200.00500.00600.00300.00200.00600.0043,533.339,255.0034,278.3334,278.332018/1/30月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160119美人鱼29,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.0021,100.003,395.0017,705.0017,705.00社保已扣月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/1美RY2016美人鱼10,000.0012,000.00800.00200.005,200.00600.00200.00100.00600.00105.0028,195.005,168.7523,026.2523,026.25社保已扣月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160120美人鱼312,000.008,000.003,000.00200.007,500.00600.00500.0050.00600.00103.0031,047.005,881.7525,165.2525,165.25月份员工编号姓名基本工资绩效工资补贴加班费奖金社保福利其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字发放日期备注2020/120160121美人鱼411,000.0010,000.004,000.00200.00600.00600.00500.00200.00600.00104.0025,996.004,619.0021,377.0021,377.00 使用方法：首先，在员工工资明细表中录入相关信息与数据，然后在本表格中通过下拉菜单输入员工编号即可查询并生成工资条。温馨提示：关于数据信息增减，此表数据来源于明细表，所以只需要在明细表中按照说明进行数据增减即可，不要操作本表格。需要注意：表格右侧预留了部分带函数公式的单元格（可增加数据10列），请勿删除，便于新增项目数据自动生成；另外，如果明细表数据增减，本表格数据会随之对应变化，但是部分单元格格式可能会发生变化，例如数字格式、日期格式、标题颜色标注，这些需要后期手工进行调整。