实用工资管理系统表

1.员工基本信息表录入对应员工信息,2.参数表根据实际情况进行修改录入，包括社保公积金比率，个税以及考勤扣款、工龄工资，后面表格都是根据这里的比率自动计算,3.基本工资表蓝色底纹列自动更新，只需要填写基础工资，岗位工资，计划奖金,4.福利统计表蓝色底纹列自动更新，其他列根据实际情况填写,5.社会保险表无须手动，由公式自动统计,6.奖金计算表蓝色底纹列自动计算，只需要填写考勤天数，实际奖金会根据参数表设定的数据自动计算,7.工资结算表、工资条全部由公式自动计算,8.查询表、下拉选择员工，后面自动显示,工资管理查询系统,基础数据员工福利结算查询,公司职工基本情况一览表,编号姓 名部门职务职称参加工作时间性别出生日期身份证号码户口所在地联系电话E-mail银行账号,A01张三自定义A处长42370.0男123,A02李四自定义B经理42736.0男456,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101,工资计算比率表,社会保险及住房公积金奖金计算标准,扣缴比例,项目单位个人出勤情况每天扣款（元）,养老保险0.20.08迟到/早退20.0,医疗保险0.080.02病假15.0,失业保险0.020.01事假30.0,住房公积金0.120.12旷工100.0,个人应税所得税工资费用分配表,起征点3500.0项目扣除比例,应税所得额=应发合计-起征点职工福利费,级数全月应纳税所得额税率速扣数工会经费,1.0不超过1500元的部分0.030.0教育经费,2.0超过1500元--4500元的部分0.1105.0,3.0超过4500元--9000元的部分0.2555.0,4.0超过9000元--35000元的部分0.251005.0工龄工资计算标准,5.0超过35000元--55000元的部分0.32755.0年限每年金额最高限,6.0超过55000元--80000元的部分0.355505.01.015.0500.0,7.0超过80000元的部分0.4513505.0,8.0,9.0,公司职工工资一览表,编号姓 名部门基础工资岗位工资工龄工资计划奖金工资合计,A01张三自定义A6000.02000.030.08030.0,A02李四自定义B4500.01800.015.06315.0,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101,公司职工福利费一览表,编号姓 名部门住房补贴伙食补贴交通补贴医疗补助合计,A01张三自定义A,A02李四自定义B800.0600.01000.0300.02700.0,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101,公司职工社会保险缴纳情况一览表 ,编号姓 名部门养老保险医疗保险失业保险合计,A01张三自定义A642.4160.680.3883.3,A02李四自定义B505.2126.363.15694.65,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101,奖金计算表,编号姓名计划奖金实际奖金计算请假天数统计,病假事假旷工迟到早退,A01张三-575.01.02.03.04.06.0,A02李四-460.02.04.0,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101,工资结算清单,月份编号姓 名部门基本工资岗位工资工龄工资住房补贴伙食补贴交通补贴医疗补助奖金应发合计住房公积金养老保险医疗保险失业保险应税所得额个人所得税应扣合计实发合计,A01张三自定义A6000.02000.030.0-575.07455.0894.6642.4160.680.35677.1112.711890.615564.39,A02李四自定义B4500.01800.015.0800.0600.01000.0300.0-460.08555.01026.6505.2126.363.156833.75228.381949.636605.37,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101,工 资 条,A01张三自定义A6000.02000.030.0-575.07455.0894.6642.4160.680.35677.1112.711890.615564.39,A02李四自定义B4500.01800.015.0800.0600.01000.0300.0-460.08555.01026.6505.2126.363.156833.75228.381949.636605.37,A03,A04,A05,A06,A07,A08,A09,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33,A34,A35,A36,A37,A38,A39,A40,A41,A42,A43,A44,A45,A46,A47,A48,A49,A50,A51,A52,A53,A54,A55,A56,A57,A58,A59,A60,A61,A62,A63,A64,A65,A66,A67,A68,A69,A70,A71,A72,A73,A74,A75,A76,A77,A78,A79,A80,A81,A82,A83,A84,A85,A86,A87,A88,A89,A90,A91,A92,A93,A94,A95,A96,A97,A98,A99,A100,A101, 职工工资查询表,查询的职工姓名：张三,基本情况,姓名：张三,职务：处长,应发薪金应扣薪金,项目金额项目金额,基本工资6000.0住房公积金894.6,岗位工资2000.0养老保险642.4,工龄工资30.0医疗保险160.6,住房补贴失业保险80.3,伙食补贴个人所得税112.71,交通补贴,医疗补助,奖金-575.0,应发合计7455.0应扣合计1890.61,实发合计5564.39