公司社保缴纳明细表（内置公式）.xlsx

公司社保缴纳明细表（内置公式）工号姓名职务部门工资基数单位缴纳部分个人缴纳部分实发工资核对缴纳比例分配表养老医疗工伤失业生育小计养老医疗失业小计险种单位缴纳个人缴纳1员工1总经理总办8,000.00 1,600.00 480.00 64.00 160.00 80.00 2,384.00 640.00 160.00 80.00 880.00 7,120.00 □养老20.0%8.0%2员工2副总经理总办6,500.00 1,300.00 390.00 52.00 130.00 65.00 1,937.00 520.00 130.00 65.00 715.00 5,785.00 □医疗6.0%2.0%3员工3经理行政部5,000.00 1,000.00 300.00 40.00 100.00 50.00 1,490.00 400.00 100.00 50.00 550.00 4,450.00 □工伤0.8%4员工4专员行政部3,000.00 600.00 180.00 24.00 60.00 30.00 894.00 240.00 60.00 30.00 330.00 2,670.00 □失业2.0%1.0%5员工5经理财务部5,000.00 1,000.00 300.00 40.00 100.00 50.00 1,490.00 400.00 100.00 50.00 550.00 4,450.00 □生育1.0%6员工6会计财务部4,000.00 800.00 240.00 32.00 80.00 40.00 1,192.00 320.00 80.00 40.00 440.00 3,560.00 □合计14,006.00 5,170.00 7员工7经理销售部5,000.00 1,000.00 300.00 40.00 100.00 50.00 1,490.00 400.00 100.00 50.00 550.00 4,450.00 □8员工8专员销售部3,500.00 700.00 210.00 28.00 70.00 35.00 1,043.00 280.00 70.00 35.00 385.00 3,115.00 □部门单位缴纳个人缴纳9员工9专员销售部3,500.00 700.00 210.00 28.00 70.00 35.00 1,043.00 280.00 70.00 35.00 385.00 3,115.00 □总办4,321.00 1,595.00 10员工10专员销售部3,500.00 700.00 210.00 28.00 70.00 35.00 1,043.00 280.00 70.00 35.00 385.00 3,115.00 □行政部2,384.00 880.00 销售部4,619.00 1,705.00 技术部财务部2,682.00 990.00 后勤部