工资管理系统.xlsx

全年工资汇总10月工资表6月工资表2月工资表参数表11月工资表7月工资表3月工资表个人工资明细9月工资表5月工资表1月工资表工资管理系统（使用简单）使用说明12月工资表8月工资表4月工资表工资管理系统（使用简单）1月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039003900100380038001004900490010043504350000000000000000000000000000000000000000000000000000000001月工资表0000000000000000000000000000000000002月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000002月工资表0000000000000000000000000000000000003月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000003月工资表0000000000000000000000000000000000004月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000004月工资表0000000000000000000000000000000000005月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款1销售部张122203000100100400200100390050502销售部张2222230001002002002001003800801003财务部张32222400020030010020010049004人力资源部张4222135001502002002001004350100000000000000000000返返回回主主页页00000000000000000000005月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款返返回回主主页页0000005月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款返返回回主主页页实发工资备注38003620490042500000000000000000000000000000000000000000实发工资备注000000实发工资备注6月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000006月工资表0000000000000000000000000000000000007月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000007月工资表0000000000000000000000000000000000008月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000008月工资表0000000000000000000000000000000000009月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注10039005050380010038008010036201004900490010043501004250000000000000000000000000000000000000000000000000000000009月工资表00000000000000000000000000000000000010月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注100390050503800100380080100362010049004900100435010042500000000000000000000000000000000000000000000000000000000010月工资表00000000000000000000000000000000000011月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注100390050503800100380080100362010049004900100435010042500000000000000000000000000000000000000000000000000000000011月工资表00000000000000000000000000000000000012月工资表序号部门姓名应出勤实出勤基本工资绩效工资工龄工资加班工资午餐补助1销售部张1222030001001004002002销售部张2222230001002002002003财务部张3222240002003001002004人力资源部张422213500150200200200返返回回主主页页其他补助应发工资缺勤扣款社保房租费用个人所得税其他扣款实发工资备注100390050503800100380080100362010049004900100435010042500000000000000000000000000000000000000000000000000000000012月工资表000000000000000000000000000000000000公司2020员工张1工资明细张1月份基本工资 绩效工资 工龄工资 加班工资 午餐补助其他应发工资 缺勤扣款社保房租费用个人所得税其他扣款13000100100400200100390023000100100400200100390050503300010010040020010039005050430001001004002001003900505053000100100400200100390050506300010010040020010039005050730001001004002001003900505083000100100400200100390050509300010010040020010039005050103000100100400200100390050501130001001004002001003900505012300010010040020010039005050合计360001200120048002400120046800550550实发工资39003800380038003800380038003800380038003800380045700返返回回主主页页公司年度全年人员工资汇总姓名基本工资 绩效工资 工龄工资 加班工资 午餐补助 其他补助 应发工资 缺勤扣款社保房租费用个人所得税其他扣款张1360001200120048002400120046800550550张23600012002400240024001200456008801100张3480002400360012002400120058800张44200018002400240024001200522001100合计16200066009600108009600480020340014302750实发工资45700436205880051100返返回回主主页页199220参数表姓名部门张1销售部张2财务部张3人力资源部张4市场部返返回回主主页页使用说明参数表：先在参数表里录入员工姓名和部门。1月至12月：按要求依次填写，颜色区域自动生成，无需手动输入。个人工资明细：选择员工姓名，自动生成员工全年的工资记录。全年工资汇总：该表自动生成每个员工一年的工资统计，无需手动输入。返返回回主主页页