公司社保福利費用結(jié)構(gòu)分析表（含住房公積金）

公司社保福利費用結(jié)構(gòu)分析表（含住房公積金）,,,,,,,,,,,,,,,,,,,

說明：此表主要詳細記錄員工的月基本工資、各類社保項目（含住房公積金）公司繳納情況、個人繳納情況，便于每月對公司整體的保險繳納情況進行統(tǒng)計以及跟蹤分析，分析圖表包括：各費用項目結(jié)構(gòu)分析、員工社保福利費用對比分析。使用方法：按照對應項目填入每個月的實際數(shù)據(jù)即可，合計部分為自動生成。注：填入數(shù)據(jù)應該以每個月核準后的或者上繳的實際數(shù)據(jù)為準，所列數(shù)據(jù)僅供參考。,,,,,,,,,,,,,,,,,,,

序號,部門,姓名,月度基本工資,養(yǎng)老保險,,失業(yè)保險,,醫(yī)療保險,,工傷保險,,生育保險,,住房公積金,,公司繳納金額合計,個人繳納金額合計,總計,備注

,,,,公司繳納,個人繳納,公司繳納,個人繳納,公司繳納,個人繳納,公司繳納,個人繳納,公司繳納,個人繳納,公司繳納,個人繳納,,,,

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",

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

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

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

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