首页 表格模板 人力资源 超实用工资表Excel管理系统

 超实用工资表Excel管理系统

开通vip
举报

爱问共享资料超实用工资表Excel管理系统文档免费下载,数万用户每天上传大量最新资料,数量累计超一个亿 ,c使用说明1本系统表中设置公式的表格请不要随意改动如果税率等变更请修改公式内的数据即可2本系统主要需要用户录入工资明细表比如相关人员的姓名部门身份证号基本工资绩效工资社保基数按社保部门规定的上年平均工资算公积金基数本系统按照标准工资即应发工资算社保和公积金等企业和个人缴费比例可根据企业实际修改公式中的相应缴费比例数字3本系统社保公积金年金医疗表需要选填部门即可分部门汇总数据4本系统比较简单并且已经过测试运行无问题工资明细表科目人数本月应出勤天数22序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职...

超实用工资表Excel管理系统

c使用说明1本系统 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 中设置公式的表格请不要随意改动如果税率等变更请修改公式内的数据即可2本系统主要需要用户录入工资明细表比如相关人员的姓名部门身份证号基本工资绩效工资社保基数按社保部门规定的上年平均工资算公积金基数本系统按照标准工资即应发工资算社保和公积金等企业和个人缴费比例可根据企业实际修改公式中的相应缴费比例数字3本系统社保公积金年金医疗表需要选填部门即可分部门汇总数据4本系统比较简单并且已经过测试运行无问题工资明细表科目人数本月应出勤天数22序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资验算公式银行账号调薪时间1张三销售部文员12320150303250025002225000028742874250028745460628743161457514373000014370135476229921437574800030000114967167317832700000000000028741754530002李四业务部经理45620160108400040002240000028742874400028745460628743161457514374800014370153476229921437574800048000114968967331032700000000000028743074530003002200000000000000000000000000000000000000000000000000000000000000000000000004002200000000000000000000000000000000000000000000000000000000000000000000000005002200000000000000000000000000000000000000000000000000000000000000000000000006002200000000000000000000000000000000000000000000000000000000000000000000000007002200000000000000000000000000000000000000000000000000000000000000000000000008002200000000000000000000000000000000000000000000000000000000000000000000000009002200000000000000000000000000000000000000000000000000000000000000000000000001000220000000000000000000000000000000000000000000000000000000000000000000000000110022000000000000000000000000000000000000000000000000000000000000000000000000012002200000000000000000000000000000000000000000000000000000000000000000000000001300220000000000000000000000000000000000000000000000000000000000000000000000000140022000000000000000000000000000000000000000000000000000000000000000000000000015002200000000000000000000000000000000000000000000000000000000000000000000000001600220000000000000000000000000000000000000000000000000000000000000000000000000170022000000000000000000000000000000000000000000000000000000000000000000000000018002200000000000000000000000000000000000000000000000000000000000000000000000001900220000000000000000000000000000000000000000000000000000000000000000000000000200022000000000000000000000000000000000000000000000000000000000000000000000000021002200000000000000000000000000000000000000000000000000000000000000000000000002200220000000000000000000000000000000000000000000000000000000000000000000000000230022000000000000000000000000000000000000000000000000000000000000000000000000024002200000000000000000000000000000000000000000000000000000000000000000000000002500220000000000000000000000000000000000000000000000000000000000000000000000000260022000000000000000000000000000000000000000000000000000000000000000000000000027002200000000000000000000000000000000000000000000000000000000000000000000000002800220000000000000000000000

超实用工资表Excel管理系统1

0000000000000000000000000000000000000000000000000002900220000000000000000000000000000000000000000000000000000000000000000000000000300022000000000000000000000000000000000000000000000000000000000000000000000000031002200000000000000000000000000000000000000000000000000000000000000000000000003200220000000000000000000000000000000000000000000000000000000000000000000000000330022000000000000000000000000000000000000000000000000000000000000000000000000034002200000000000000000000000000000000000000000000000000000000000000000000000003500220000000000000000000000000000000000000000000000000000000000000000000000000360022000000000000000000000000000000000000000000000000000000000000000000000000037002200000000000000000000000000000000000000000000000000000000000000000000000003800220000000000000000000000000000000000000000000000000000000000000000000000000390022000000000000000000000000000000000000000000000000000000000000000000000000040002200000000000000000000000000000000000000000000000000000000000000000000000004100220000000000000000000000000000000000000000000000000000000000000000000000000420022000000000000000000000000000000000000000000000000000000000000000000000000043002200000000000000000000000000000000000000000000000000000000000000000000000004400220000000000000000000000000000000000000000000000000000000000000000000000000450022000000000000000000000000000000000000000000000000000000000000000000000000046002200000000000000000000000000000000000000000000000000000000000000000000000004700220000000000000000000000000000000000000000000000000000000000000000000000000480022000000000000000000000000000000000000000000000000000000000000000000000000049002200000000000000000000000000000000000000000000000000000000000000000000000005000220000000000000000000000000000000000000000000000000000000000000000000000000510022000000000000000000000000000000000000000000000000000000000000000000000000052002200000000000000000000000000000000000000000000000000000000000000000000000005300220000000000000000000000000000000000000000000000000000000000000000000000000540022000000000000000000000000000000000000000000000000000000000000000000000000055002200000000000000000000000000000000000000000000000000000000000000000000000005600220000000000000000000000000000000000000000000000000000000000000000000000000570022000000000000000000000000000000000000000000000000000000000000000000000000058002200000000000000000000000000000000000000000000000000000000000000000000000005900220000000000000000000000000000000000000000000000000000000000000000000000000600022000000000000000000000000000000000000000000000000000000000000000000000000061002200000000000000000000000000000000000000000000000000000000000000000000000006200220000000000000000000000000000000000000000000000000000000000000000000000

超实用工资表Excel管理系统2

000630022000000000000000000000000000000000000000000000000000000000000000000000000064002200000000000000000000000000000000000000000000000000000000000000000000000006500220000000000000000000000000000000000000000000000000000000000000000000000000660022000000000000000000000000000000000000000000000000000000000000000000000000067002200000000000000000000000000000000000000000000000000000000000000000000000006800220000000000000000000000000000000000000000000000000000000000000000000000000690022000000000000000000000000000000000000000000000000000000000000000000000000070002200000000000000000000000000000000000000000000000000000000000000000000000007100220000000000000000000000000000000000000000000000000000000000000000000000000合计6500006500001562000000000000000065000057485748650057481092125748632281150287478000287400000002889524598428741149600078000229920000001613464886540000000000005748482906000制表人制表日期汇总表序号部门人数基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资1业务部140000040000022000000000000000040000028742874400028745460628743161457514374800014370000000153476229921437574800048000114960000008967331032700000000000028743074532销售部1250000250000220000000000000000250000287428742500287454606287431614575143730000143700000001354762299214375748000300001149600000071673178327000000000000287417545330000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000001518000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005000000015180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000700000001518000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000015180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000090000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000110000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000120000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000130000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000140000000151800000000000000000000000000000000000000000000000000000000000000

超实用工资表Excel管理系统3

000000000000000000000000000000000000000150000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000160000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000170000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000180000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000190000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000210000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000220000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000230000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000240000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000250000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000260000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000270000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000280000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000290000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000300000000151800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000合计200065000042548000000000000000065000057485748650057481092125748632281150287478000287400000002889524598428741149600078000229920000001613464886540000000000005748482906验算公式1716500006500001562000000000000000065000057485748650057481092125748632281150287478000287400000002889524598428741149600078000229920000001613464886540000000000005748482906验算公式2696500000004098600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000人工成本汇总表序号应发工资天津企业部分天津合计天津社保公积金年金年金企业5个人41650000182212780002874051732验算公式000000000000000个人所得税计算表月份2017年4月单位元税率计税工资计税人数个人所得税0-71-3-0-10-0-20-0-25-0-30-0-35-0-45-0-合计-07100-0备注1此表只统计员工的个人所得税2注意个人所得税公式中的费用扣除数需执行当地的个税起征点员工编号员工姓名员工账号支付金额币种1张三0175453人民币2李四0307453人民币300000人民币400000人民币500000人民币600000人民币700000人民币800000人民币900000人民币1000000人民币1100000人民币1200000人民币1300000人民币1400000人民币1500000人民币1600000人民币1700000人民币1800000

超实用工资表Excel管理系统4

人民币1900000人民币2000000人民币2100000人民币2200000人民币2300000人民币2400000人民币2500000人民币2600000人民币2700000人民币2800000人民币2900000人民币3000000人民币3100000人民币3200000人民币3300000人民币3400000人民币3500000人民币3600000人民币3700000人民币3800000人民币3900000人民币4000000人民币4100000人民币4200000人民币4300000人民币4400000人民币4500000人民币4600000人民币4700000人民币4800000人民币4900000人民币5000000人民币5100000人民币5200000人民币5300000人民币5400000人民币5500000人民币5600000人民币5700000人民币5800000人民币5900000人民币6000000人民币6100000人民币6200000人民币6300000人民币6400000人民币6500000人民币6600000人民币6700000人民币6800000人民币6900000人民币7000000人民币7100000人民币报税样表证照类型证照号码姓名税款负担方式收入额基本养老保险金基本医疗保险金失业保险金住房公积金其它年金个人部分免税所得准予扣除的捐赠额减免税额费用扣除标准居民身份证123张三自行负担25000022992574814373000011496居民身份证456李四自行负担40000022992574814374800011496居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000居民身份证00自行负担000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度

超实用工资表Excel管理系统5

工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资1张三销售部文员12320150303250000250000220000000025000028742874250028745460628743161457514373000014370000000135476229921437574800030000114960000007167317832700000000002874175453序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资2李四业务部经理45620160108400000400000220000000040000028742874400028745460628743161457514374800014370000000153476229921437574800048000114960000008967331032700000000002874307453序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资3000018991231000000220000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资4000018991231000000220000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资5000018991231000000220000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资6000018991231000000220000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资7000018991231000000220000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公积金个人年金4滞纳金利息个人小计税前工资应税工资税率扣除数代扣个人所得税1年金实发工资8000018991231000000220000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000序号职工姓名部门岗位身份证号码入职时间基本工资绩效工资岗位工资标准工资跨度工资职称津贴月出勤天数病假天数事假天数其他休假异常次数加班费其他应发缺勤扣款其他扣款应发工资社保基数医疗基数公积金基数年金基数企业养老企业失业企业医疗企业工伤企业生育企业公积金企业年金滞纳金利息企业小计个人养老个人失业个人医疗大额医疗个人公

本文档为【超实用工资表Excel管理系统】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑, 图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。

[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。

下载需要1个特权 ,已有0人下载

最新资料

热门推荐

推荐专题

普通用户 is_482581

暂无简介