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

人力资源管理工具薪酬福利 员工工资查询及工资条生成工具C（根据编号查询，编号在姓名前面，可批量直接打印）注：本工具主要用于通过编号自动生成任一员工的工资条（数据来源于工资明细表），以下表格数据只需要输入编号即可，其他为全部自动生成，设置了一种彩色标题的、一种灰色标题的两种，供任意选择，且特意安排了多条内容，可以批量直接打印。功能特点：1、通过下拉菜单输入任一员工编号，即可自动生成员工姓名、个人工资明细及工资条，非常便捷；2、可在员工工资明细表中随意添加信息及数据（包括标题行），查询工具中的标题及数据都将自动随之变化并生成您所需要的工资条。使用方法：首先，在员工工资明细表中录入相关信息与数据，然后在本表格中通过下拉菜单输入员工编号即可查询并生成工资条。温馨提示：关于数据信息增减，此表数据来源于明细表，所以只需要在明细表中按照说明进行数据增减即可，不要操作本表格。需要注意：表格右侧预留了部分带函数公式的单元格（可增加数据6列），请勿删除，便于新增项目数据自动生成；另外，如果明细表数据增减，本表格数据会随之对应变化，但是部分单元格格式可能会发生变化，例如数字格式、标题颜色标注，这些需要后期手工进行调整。员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160106何何小小虎虎21213,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.00￥7,975.007,975.00社保已扣员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160111王王五五212115,666.672,000.004,666.67200.00500.00600.00300.00600.00300.0023,033.333,878.33￥19,155.0019,155.00员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160108何何大大马马21158,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.00102.0019,998.003,119.50￥16,878.5016,878.50员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注版权所有：北京未名潮管理顾问有限公司何建湘20160107黄黄小小马马21186,000.004,000.001,000.00200.00500.00600.00300.00200.00600.00101.0011,699.001,084.80￥10,614.2010,614.20员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160113圆圆圆圆1 1212020,666.672,000.006,466.67200.00500.00600.00300.00200.00600.00107.0029,826.335,576.58￥24,249.7524,249.75社保已扣员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160114黄黄小小小小212023,166.672,000.007,366.67200.00500.00600.00300.00600.00500.0033,033.336,378.33￥26,655.0026,655.00员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160115何何大大大大212025,666.672,000.008,266.67200.00500.00600.00300.00200.00600.00109.0036,624.337,276.08￥29,348.2529,348.25员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注鱼MRY001美美人人鱼鱼21206,000.004,000.001,000.00200.00500.00600.00300.00100.00600.00101.0011,799.001,104.80￥10,694.2010,694.20员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160119美美人人鱼鱼2 221219,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.0021,100.003,395.00￥17,705.0017,705.00社保已扣员工编号姓名应出勤实际出勤基本工资绩效工资补贴加班费奖金社保福利 其它应发考勤扣款社保福利代缴扣款其它应扣扣款后税前应发个人所得税税后实发工资员工签字备注20160116圆圆圆圆2 2212028,166.672,000.009,166.67200.00500.00600.00300.00200.00600.00110.0040,023.338,202.00￥31,821.3331,821.33社保已扣版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘版权所有：北京未名潮管理顾问有限公司何建湘 人力资源管理工具薪酬福利员工工资明细表（含最新税率计算公式）说明：本工资表适合一般中小企业，所列项目相对简单实用。（工资项目内容仅供参考，企业可根据实际需求略作调整，其中扣款后税前应发、个人所得税、最终实发工资等关键数据为自动生成（已用颜色标注）；个人所得税计算方式是依据最新税率公式而编制，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.84120160106何小虎21213,000.002,000.00200.00200.003,000.00600.00300.00200.00600.00100.008,400.00425.007,975.007,975.00社保已扣220160107黄小马21186,000.004,000.001,000.00200.00500.00600.00300.00200.00600.00101.0011,699.001,084.8010,614.2010,614.20320160108何大马21158,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.00102.0019,998.003,119.5016,878.5016,878.50420160109张三211710,666.678,000.002,866.67200.00500.00600.00300.000.00600.00103.0022,430.333,727.5818,702.7518,702.75520160110李四212013,166.6710,000.003,766.67200.00500.00600.00300.0050.00600.00104.0027,779.335,064.8322,714.5022,714.50620160111王五212115,666.672,000.004,666.67200.00500.00600.00300.000.00600.00300.0023,033.333,878.3319,155.0019,155.00720160112赵六212018,166.672,000.005,566.67200.00500.00600.00300.000.00600.000.0026,733.334,803.3321,930.0021,930.00820160113圆圆1212020,666.672,000.006,466.67200.00500.00600.00300.00200.00600.00107.0029,826.335,576.5824,249.7524,249.75社保已扣920160114黄小小212023,166.672,000.007,366.67200.00500.00600.00300.000.00600.00500.0033,033.336,378.3326,655.0026,655.001020160115何大大212025,666.672,000.008,266.67200.00500.00600.00300.00200.00600.00109.0036,624.337,276.0829,348.2529,348.251120160127小鱼儿21206,000.002,000.002,000.00200.004,000.00600.00100.0050.00600.00300.0013,950.001,607.5012,342.5012,342.501220160116圆圆2212028,166.672,000.009,166.67200.00500.00600.00300.00200.00600.00110.0040,023.338,202.0031,821.3331,821.33社保已扣1320160117满满212030,666.672,000.0010,066.67200.00500.00600.00300.00200.00600.000.0043,533.339,255.0034,278.3334,278.3314鱼MRY001美人鱼21206,000.004,000.001,000.00200.00500.00600.00300.00100.00600.00101.0011,799.001,104.8010,694.2010,694.201520160119美人鱼221219,000.006,000.002,000.00200.004,000.00600.00100.00200.00600.000.0021,100.003,395.0017,705.0017,705.00社保已扣1620160120美人鱼3212112,000.008,000.003,000.00200.007,500.00600.00500.0050.00600.00103.0031,047.005,881.7525,165.2525,165.251720160121美人鱼4212111,000.0010,000.004,000.00200.00600.00600.00500.00200.00600.00104.0025,996.004,619.0021,377.0021,377.001820160122美人鱼21218,000.0012,000.005,000.00200.005,200.00600.00200.00200.00600.00105.0030,295.005,693.7524,601.2524,601.251920160123美人鱼621195,000.0014,000.006,000.00200.00800.00600.00400.00200.00600.00106.0026,094.004,643.5021,450.5021,450.502020160124美人鱼721202,000.0016,000.007,000.00200.00800.00600.00100.00200.00600.00107.0025,793.004,568.2521,224.7521,224.752120160125美RY821189,000.0018,000.008,000.00200.00800.00600.00200.00200.00600.0050.0035,950.007,107.5028,842.5028,842.5022美RY2016美人鱼211910,000.0012,000.00800.00200.005,200.00600.00200.00100.00600.00105.0028,195.005,168.7523,026.2523,026.25社保已扣版权所有：北京未名潮管理顾问有限公司