正版 人力资源总监教你做薪酬:操作实务与设计技巧:实用案例版 张

第一篇 薪资操作
第一章 读懂工资条的科目·························································································1
1.1 一级科目和二级科目····································································································2
1.2 二级工资科目的计算····································································································2
1.2.1 基本工资的计算·································································································3
1.2.2 代扣代缴的计算·································································································4
1.3 税后工资、人工成本····································································································6
1.4 月收入、年收入的计算口径························································································7
1.5 工资条涉及的《中华人民共和国劳动合同法》提示···············································7
第二章做工资的基本功·····························································································9
2.1 设计一套Excel月工资表···························································································10
2.2 设置Excel计算公式···································································································12
2.3 录入数据·······················································································································14
2.4 检查数据·······················································································································15
2.5 审核、审批···················································································································15
2.5.1 HR经理审核的内容························································································15
2.5.2 领导审批···········································································································16
2.5.3 后续发放：财务和银行··················································································16
2.6 薪酬专员须知···············································································································16
2.6.1 个人所得税的计算···························································································16
2.6.2 经济补偿金的个人所得税计算······································································17
2.6.3 社会保险、住房公积金代扣代缴的计算······················································19
2.6.4 年终奖的合理避税···························································································21
2.6.5 薪资计算的依据·······························································································23
2.6.6 工资标准···································································································24
2.6.7 工时的规定·······································································································24
2.6.8 加班工资的计算·······························································································25
2.6.9 员工离职经济补偿金、赔偿金的计算··························································26
人力资源总监教你做薪酬
2.7 劳动年报申报···············································································································27
2.8 人工成本统计···············································································································29
2.9 Excel特殊函数举例····································································································30
2.9.1 IF函数的运用及技巧······················································································30
2.9.2 多重IF条件函数的运用及技巧·····································································32
2.9.3 SUMIF条件函数的运用及技巧·····································································36

张明辉，毕业于浙江大学心理系、管理学院，管理学硕士。现任杭州考典信息科技有限公司总经理，浙江大学公共管理学院兼职教授。专注于人力资源管理图书创作、视频课程研发、咨询与培训。

曾就职于中国网通、柳桥集团、南都电源等大中型企业、上市公司，历任经理助理、薪酬与绩效主管、人力资源部经理、人力资源总监。曾获杭州市首届很好HR经理奖、浙江省首届双靠前HR经理奖、第四届中国人力资源管理大奖成果奖银奖。

曾为浙江电信、温州联通、浙江网通、上海建工集团、浙江能源集团、重庆市国资委、深圳燃气、华立集团、东冠集团、中粮包装等单位提供绩效薪酬培训。

       人力资源总监教你做薪酬是一本薪酬实务工具书，由HRD 手把手教你做薪酬的操作与设计。全书共22 章，先介绍了薪资操作的过程，从工资条的科目讲起，为薪酬专员介绍了制作工资需要掌握的技能、工资发放过程中的疑难问题以及如何处理调薪等内容，涉及很多实用的Excel 计算公式；然后介绍了薪酬体系设计，为薪酬主管介绍了薪点制的设计过程、职位分析与岗位评估的操作过程；*后介绍分类薪酬方案的设计与操作案例，包括：年薪制、奖金提成制、计件制、项目奖金制、项目补贴、股权期权、工资总额与业绩挂构、企业年金、职能部门绩效工资、薪酬调查、互联网公司薪等薪级表以及互联网公司股权案例等内容。全书架构合理，逻辑性强，讲解通俗易懂，以表析文，案例丰富，注重案例原创性、与时俱进，行文可读性强。本书可作为薪酬专员、薪酬主管、HR、企业高管、MBA、本科生等的参考用书。

      精通薪酬管理 实现职场晋级本书可以帮你解决如下问题：·制作工资表的基本功·避免薪资拖延发放、计算出错·薪酬体系的建立与设计·避免执薪不公、做到同工同酬、·合理分配人力、激励员工·有依据的绩效调薪，做到公平的绩效评核·股权期权的实务操作·薪酬测算的技巧......实战派作者15年的工作总结，快速解决你的薪酬难题 

张明辉著的《人力资源总监教你做薪酬（操作实务与设计技巧实用案例版）》主要是指导在薪资、人事、绩效模块摸索的新手来掌握薪资操作过程与设计的技巧，指导有3—5年工作经验的熟手拓展领域，触类旁通，将薪酬的设计作为一门手艺，学精学透，为自己的职业技能再增添一个筹码。 本书共分为四篇，分别是第一篇（第一章—第四章）薪资操作，主要包括薪资发放的过程、技巧以及薪资计算的依据，公司内部的薪酬制度、人事制度，外部的劳动政策法规等。第二篇（第五章—第八章）薪酬体系设计，包括薪酬体系的建立与修订、薪点制、职位分析与岗位评估。第三篇（第九章～第十八章）薪酬方案设计，包括年薪制、计件工资、销售奖、项目奖、补贴项目设计、股权设计、工资总额与业绩挂钩、企业年金设计等58个真实案例。第四篇（第十九章—第二十二章）薪酬高级专题。主要是拟上市公司的薪酬“规范”，32个体系审核的薪酬案例。 本书适合从事薪资、人事、绩效模块的人力资源专员、主管学以致用，也可供人力资源部经理、绩效主管、部门经理等参考，或对薪酬感兴趣的其他行业的读者了解。