Excel表格模板：工资表系统-自动生成工资条-工资汇总表.xlsx

会计帮帮网有限公司工资表员员工工编编号号姓姓名名部部门门职职务务考考勤勤天天数数在在岗岗天天数数基基本本工工资资岗岗位位工工资资补补助助奖奖金金考考勤勤扣扣款款罚罚款款应应发发工工资资1申璞综合部总经理30252,000.001,000.0060.0050.0030.0010.003,070.002赵丽综合部会计主管30252,000.001,500.0060.0050.0030.0010.003,570.003王栋技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.004李四技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.005周涛技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.006郑飞技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.007闫钢市场部销售员30252,000.001,500.0060.0050.0030.0010.003,570.008陈锋市场部销售员30252,000.001,500.0060.0050.0030.0010.003,570.009郭楠市场部销售员30252,000.001,500.0060.0050.0030.0010.003,570.00-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资1申璞综合部总经理30252,000.001,000.0060.0050.0030.0010.003,070.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资2赵丽综合部会计主管30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资3王栋技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资4李四技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资5周涛技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资6郑飞技术部研发员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资7闫钢市场部销售员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资8陈锋市场部销售员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资9郭楠市场部销售员30252,000.001,500.0060.0050.0030.0010.003,570.00员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-员工编号姓名部门职务考勤天数在岗天数基本工资岗位工资补助奖金考勤扣款罚款应发工资000000-