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

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

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

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

,,,,公司繳納,個(gè)人繳納,公司繳納,個(gè)人繳納,公司繳納,個(gè)人繳納,公司繳納,個(gè)人繳納,公司繳納,個(gè)人繳納,公司繳納,個(gè)人繳納,,,,

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

合計(jì),,,"￥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",

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

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

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

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