公司社保福利费用结构分析表（含住房公积金）

公司社保福利费用结构分析表（含住房公积金）,,,,,,,,,,,,,,,,,,,

说明：此表主要详细记录员工的月基本工资、各类社保项目（含住房公积金）公司缴纳情况、个人缴纳情况，便于每月对公司整体的保险缴纳情况进行统计以及跟踪分析，分析图表包括：各费用项目结构分析、员工社保福利费用对比分析。使用方法：按照对应项目填入每个月的实际数据即可，合计部分为自动生成。注：填入数据应该以每个月核准后的或者上缴的实际数据为准，所列数据仅供参考。,,,,,,,,,,,,,,,,,,,

序号,部门,姓名,月度基本工资,养老保险,,失业保险,,医疗保险,,工伤保险,,生育保险,,住房公积金,,公司缴纳金额合计,个人缴纳金额合计,总计,备注

,,,,公司缴纳,个人缴纳,公司缴纳,个人缴纳,公司缴纳,个人缴纳,公司缴纳,个人缴纳,公司缴纳,个人缴纳,公司缴纳,个人缴纳,,,,

1,,员工1,"￥4,600.00",874.00,368.00,36.80,9.20,462.40,95.48,13.87,0.00,36.99,0.00,552.00,552.00,"￥1,976.06","￥1,024.68","￥3,000.74",

2,,员工2,"￥12,000.00",2280.00,960.00,96.00,24.00,1200.00,243.00,36.00,0.00,96.00,0.00,1440.00,1440.00,"￥5,148.00","￥2,667.00","￥7,815.00",

3,,员工3,"￥6,000.00",1140.00,480.00,48.00,12.00,600.00,123.00,18.00,0.00,48.00,0.00,720.00,720.00,"￥2,574.00","￥1,335.00","￥3,909.00",

4,,员工4,"￥12,000.00",2280.00,960.00,96.00,24.00,1200.00,243.00,36.00,0.00,96.00,0.00,1440.00,1440.00,"￥5,148.00","￥2,667.00","￥7,815.00",

5,,员工5,"￥6,000.00",1140.00,480.00,48.00,12.00,600.00,123.00,18.00,0.00,48.00,0.00,720.00,720.00,"￥2,574.00","￥1,335.00","￥3,909.00",

6,,员工6,"￥12,000.00",2280.00,960.00,96.00,24.00,1200.00,243.00,36.00,0.00,96.00,0.00,1440.00,1440.00,"￥5,148.00","￥2,667.00","￥7,815.00",

7,,员工7,"￥4,600.00",874.00,368.00,36.80,9.20,462.40,95.48,13.87,0.00,36.99,0.00,552.00,552.00,"￥1,976.06","￥1,024.68","￥3,000.74",

8,,员工8,"￥3,500.00",665.00,280.00,28.00,7.00,462.40,95.48,13.87,0.00,36.99,0.00,420.00,420.00,"￥1,626.26",￥802.48,"￥2,428.74",

9,,员工9,"￥3,000.00",585.58,246.56,24.66,6.16,462.40,95.48,13.87,0.00,36.99,0.00,360.00,360.00,"￥1,483.50",￥708.20,"￥2,191.70",

10,,员工10,"￥2,000.00",585.58,246.56,24.66,6.16,462.40,95.48,13.87,0.00,36.99,0.00,258.00,258.00,"￥1,381.50",￥606.20,"￥1,987.70",

11,,员工11,"￥2,000.00",585.58,246.56,24.66,6.16,462.40,95.48,13.87,0.00,36.99,0.00,258.00,258.00,"￥1,381.50",￥606.20,"￥1,987.70",

12,,员工12,"￥2,000.00",585.58,246.56,24.66,6.16,462.40,95.48,13.87,0.00,36.99,0.00,258.00,258.00,"￥1,381.50",￥606.20,"￥1,987.70",

合计,,,"￥69,700.00",13875.32,5842.24,584.24,146.04,8036.80,1643.36,241.09,0.00,642.93,0.00,8418.00,8418.00,"￥31,798.38","￥16,049.64","￥47,848.02",

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

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

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

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