员工社保费用计算器（-自动核准、计算）

财务管理工具,,,,,,,,,,,,,,

员工社保费用计算器（2018年7月至2019年6月，自动核准基数、自动计算）,,,,,,,,,,,,,,

说明：此工具主要用于计算任一员工的社保应缴费用，包括单位应缴及个人应缴两部分的明细。功能特点：根据北京地区2018-2019最新社保缴费基数标准（以城镇户口为例）进行自动函数公式设置，只需要录入计划缴费的工资基数，即可自动生成核准的基数，并按照相应比例自动计算出应缴明细。注：上面第一张表为政策规定的上下限缴费基数及标准，下面表格为自动计算器，左侧输入计划缴费基数即可。如果不属于北京地区，调整相应的基础、比例即可，表格中为自动计算。另：工伤保险缴费比例与企业所属行业有关，目前是按照工伤保险行业风险分类表第二类标准设定，即0.4%。,,,,,,,,,,,,,,

序号,社保险种,月缴费基数标准,,,单位缴费,,,,个人缴费,,,,合计,

,,最低基数,最高基数,,比例,大额互助缴费比例,最低,最高,比例,大额互助缴费金额,最低,最高,最低,最高

1,养老保险,"￥3,387.00","￥25,401.00",,19.00%,,￥643.53,"￥4,826.19",8.00%,,￥270.96,"￥2,032.08",￥914.49,"￥6,858.27"

2,失业保险,"￥3,387.00","￥25,401.00",,0.80%,,￥27.10,￥203.21,0.20%,,￥6.77,￥50.80,￥33.87,￥254.01

3,医疗保险,"￥5,080.00","￥25,401.00",,9.00%,1%,￥508.00,"￥2,540.10",2.00%,￥3.00,￥104.60,￥511.02,￥612.60,"￥3,051.12"

4,工伤保险,"￥5,080.00","￥25,401.00",,0.40%,,￥20.32,￥101.60,0.00%,,￥0.00,￥0.00,￥20.32,￥101.60

5,生育保险,"￥5,080.00","￥25,401.00",,0.80%,,￥40.64,￥203.21,0.00%,,￥0.00,￥0.00,￥40.64,￥203.21

合计,,,,,,,"￥1,239.59","￥7,874.31",,,￥382.33,"￥2,593.90","￥1,621.92","￥10,468.21"

,,,,,,,,,,,,,,,

员工姓名,,,序号,社保险种,月缴费核准基数,,单位缴费,,,个人缴费,,,合计,

未名潮A,,,,,,,比例,大额互助缴费比例,应缴金额,比例,大额互助缴费金额,应缴金额,月度应缴金额,年度应缴金额

计划缴费基数,,,1,养老保险,"￥4,900.00",,19.00%,,￥931.00,8.00%,,￥392.00,"￥1,323.00","￥15,876.00"

"￥4,900.00",,,2,失业保险,"￥4,900.00",,0.80%,,￥39.20,0.20%,,￥9.80,￥49.00,￥588.00

,,,3,医疗保险,"￥5,080.00",,9.00%,1%,￥508.00,2.00%,￥3.00,￥104.60,￥612.60,"￥7,351.20"

,,,4,工伤保险,"￥5,080.00",,0.40%,,￥20.32,0.00%,,￥0.00,￥20.32,￥243.84

,,,5,生育保险,"￥5,080.00",,0.80%,,￥40.64,0.00%,,￥0.00,￥40.64,￥487.68

,,,合计,,,,,,"