2024excel表格操作大全算工资

2025年工程结算工资表 - Sheet1 Unnamed: 0 Unnamed: 1 工资表工程项目名称：序号12345678910111213141516171819202122232425262728293031备注：Unnamed: 2 姓名Unnamed: 3 应发身份证号Unnamed: 4 职务Unnamed: 5 工种Unnamed: 6 工价Unnamed: 7 年 月 日 工天数Unnamed: 8 工资合计Unnamed: 9 应扣合计借支金额Unnamed: 10 罚款Unnamed: 11 生活费Unnamed: 12 交通费Unnamed: 13 应扣合计Unnamed: 14 实发工资Unnamed: 15 领款人Unnamed: 16 备注

2025年员工按数量结算工资表 - Sheet1 员工按数量结算工资表 员工姓名万辉李甜于张敏姓名1姓名2姓名3姓名4姓名5姓名6姓名7姓名8姓名9姓名10姓名11姓名12姓名13姓名14姓名15姓名16姓名17姓名18姓名19姓名20本月数量合计：Unnamed: 1 联系电话xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx82890Unnamed: 2 底薪10001000100010001000100010001000100010001000100......

2025小时工薪酬结算工资表 - 样表 Unnamed: 0 Unnamed: 1 小时工薪酬结算工资表单位名称：序号1234Unnamed: 2 姓名某某某某某某某某某某某某Unnamed: 3 身份证4302********00014302********00024302********00034302********0004Unnamed: 4 岗位收银员营业员服务员后勤员Unnamed: 5 小时 单价16151417Unnamed: 6 工时 合计148713Unnamed: 7 工资 总计448165140221Unnamed: 8 备注Unnamed: 9 Unnamed: 10 姓名某某某某某某某某某某某某某某某某某某某某某某某某Unnamed: 11 身份证4302********0001......

2025年单位分级扣税自动计算工资表(含扣减社保等) - Sheet2 工资表 编制单位： 序号01020304050607080910111213141516171819202122232425262728293031Unnamed: 1 姓名合计Unnamed: 2 基本工资1000010000Unnamed: 3 假日加班工时Unnamed: 4 平时加班工资Unnamed: 5 法定节假日期加班工资Unnamed: 6 伙食补贴Unnamed: 7 住房补贴Unnamed: 8 其他Unnamed: 9 提成金额0Unnamed: 10 应付工资 A1000000000000000000000000000000000010000Unnamed: 11 扣事假 D0Unnamed: 12 代扣保险 E0Unnamed: 13 扣其他Unnamed: 14 税前小计 F=C-D-E1000010000Unnamed: 15 应税所得 G=F-35006

2025年自动计算工资表 - Sheet1 Unnamed: 0 2019 年4月份工资表 单位： 岗位合计 单位负责人：Unnamed: 2 姓名Unnamed: 3 基本工资2500210017001700250015001500800170016000Unnamed: 4 增加工龄200200Unnamed: 5 饭补2001501001001501001001001000Unnamed: 6 奖励20200220Unnamed: 7 加班270680950Unnamed: 8 全勤300300300900Unnamed: 9 退押金0Unnamed: 10 小计327024502800180031501600160080018000019270Unnamed: 11 减少缺勤8508007007653115Unnamed: 12 第（ 1 ）页迟到0Unnamed: 13 违规0Unnamed: 14 小计0008500

2025年财务核算工资表 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表序号12345678910111213141516171819202122232425262728293031合计Unnamed: 2 姓 名王伟陈伟霆万和听林立王琴Unnamed: 3 在职职位HR02HR03HR04HR05HR06Unnamed: 4 应发工资月底薪50005000500050005000Unnamed: 5 平时加班342.4343.4344.4345.4346.4Unnamed: 6 双休加班256.8257.8258.8259.8260.8Unnamed: 7 节假加班567.43568.43569.43570.43571.43Unnamed: 8 超勤补贴5050505050Unnamed: 9 奖金100100000Unnamed: 10 补贴5050505050Unnamed: 11 其它00000Unnamed: 12 应发工资金额6366.636369.63627

2025年财务核算工资表 - 6月 Unnamed: 0 Unnamed: 1 工 资 表序号123456789101112131415Unnamed: 2 工号1002100310041005Unnamed: 3 部门岗位2岗位3岗位4岗位5Unnamed: 4 姓名姓名2姓名3姓名4姓名5Unnamed: 5 实发金额仟Unnamed: 6 佰Unnamed: 7 拾Unnamed: 8 万¥¥Unnamed: 9 仟55Unnamed: 10 佰25Unnamed: 11 拾00Unnamed: 12 元00Unnamed: 13 角00¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥Unnamed: 14 分0000000000000000000Unnamed: 15 Unnamed: 16 出勤天数30303030Unnamed: 17 加班 天数Unnamed: 18 缺勤天数Unnamed: 19 基本工资5000500050005000Unnamed: 20 绩效补贴20030040

2025年财务核算工资表-薪酬待遇 - Sheet1 Unnamed: 0 Unnamed: 1 员 工 工 资 表编号12345678910合计制表人： 审核人： 审批人： 付款人:Unnamed: 2 员工工号D1558D1559D1560D1561D1562D1563D1564D1565D1566D156710人Unnamed: 3 员工姓名王丽王丽王丽王丽王丽王丽王丽王丽王丽王丽10人Unnamed: 4 入职日期2013-04-28 00:00:002013-04-29 00:00:002013-04-30 00:00:002013-05-01 00:00:2024excel表格操作大全算工资

2025年财务核算工资表 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表序号1234567891011121314151617181920合 计Unnamed: 2 姓名王丽田晓术Unnamed: 3 岗位WBDBUnnamed: 4 银行卡号3287**8324287**833Unnamed: 5 应发工资基本底薪300035006500Unnamed: 6 加班工资5000500Unnamed: 7 车贴50100150Unnamed: 8 奖金100200300Unnamed: 9 报销费3000300Unnamed: 10 电话补贴0200200Unnamed: 11 全勤奖金100100200Unnamed: 12 其它补贴5050100Unnamed: 13 应发总金额410041500000000000000000008250Unnamed: 14 扣除部分扣工资0120120Unnamed: 15 罚款000Unnamed: 16 保

2025年财务核算工资表 - Sheet1 Unnamed: 0 Unnamed: 1 XXX公司工资表发放日期： 年 月 日基本资料序号12345678910111213141516171819202122232425262728合计Unnamed: 2 部门Unnamed: 3 工号Unnamed: 4 姓名Unnamed: 5 实际出勤Unnamed: 6 应发工资绩效考核奖金Unnamed: 7 加班工资Unnamed: 8 合计金额00000000000000000000000000000Unnamed: 9 福利补贴出差补贴Unnamed: 10 住房补贴Unnamed: 11 餐补贴Unnamed: 12 合计金额00000000000000000000000000000Unnamed: 13 其他扣款保险扣款Unnamed: 14 事假扣款Unnamed: 15 病假扣款Unnamed: 16 个人所得税U

2025年人事行政计算工资表 - Sheet1 Unnamed: 0 工 资 表 姓名姓名1姓名2姓名3姓名4合计Unnamed: 2 入职时间2018-01-07 00:00:002013-01-08 00:00:002012-01-09 00:00:002014-01-09 00:00:00Unnamed: 3 工龄278600000000000000000000000Unnamed: 4 出勤天数262626Unnamed: 5 基本工资500050005000Unnamed: 6 补贴100100100Unnamed: 7 奖金100010001000·Unnamed: 8 工龄303030Unnamed: 9 加班费Unnamed: 10 其它55050Unnamed: 11 小计61356180618000000000000000000000000018495Unnamed: 12 罚款100100100Unnamed: 13 请假Unnamed: 14 罚款Unnamed: 15 小计100100100

2025年财务部核算工资表 - Sheet1 工 资 表 序 号123456789101112负责人： 审核： 出纳： 制表人：Unnamed: 1 部门：姓 名合 计Unnamed: 2 出勤天数292929292929292929292929Unnamed: 3 基本工资0Unnamed: 4 应 发 金 额绩效工资0Unnamed: 5 加班 工资Unnamed: 6 交通 补助Unnamed: 7 话 费0Unnamed: 8 应发合计0Unnamed: 9 应 扣 金 额社保金Unnamed: 10 病事假Unnamed: 11 水电费Unnamed: 12 借款Unnamed: 13 2020--2迟到扣款Unnamed: 14 实发合计0Unnamed: 15 签 字

2025年自动计算工资表 - Sheet1 Unnamed: 0 工资表（单位：人民币元） 工号1230612307123081230912310123111231212313123141231512316123171231812319123201232112322123231232412325合计Unnamed: 2 姓名Unnamed: 3 入职日期Unnamed: 4 底薪3000300030003000300030003000300030003000300030003000300030003000300051000Unnamed: 5 岗位工资50050050010008008018028038048058068078089736Unnamed: 6 综合补贴1001001001011021031041051061071081091101111466Unnamed: 7 出差补助000000000000000000000Unnamed: 8 工资代扣社保基数00000000000000000000

2025年财务核算工资表 - Sheet1 Unnamed: 0 Unnamed: 1 财务核算工资表发放日期：年 月 日姓名AA1AA2AA3AA4AA5AA6合计Unnamed: 2 王1王2王3王4王5王6Unnamed: 3 职位Unnamed: 4 工作日数262626262626Unnamed: 5 工资底薪50005000500050005000500030000Unnamed: 6 加班0Unnamed: 7 奖励合计0Unnamed: 8 应得工资50005000500050005000500000000000000000000000000000000030000Unnamed: 9 扣款金额借支0Unnamed: 10 备10Unnamed: 11 备20Unnamed: 12 合计金额50005000500050005000500000000000000000000000000000000030000Unnamed: 13 实发金额（自动计算）拾¥Unnamed

2025年财务核算-工资表 - 工资表 Unnamed: 0 Unnamed: 1 工 资 表月份66666应发总人数Unnamed: 2 岗位岗位1岗位2岗位3岗位4岗位5Unnamed: 3 姓名姓名1姓名2姓名3姓名4姓名5Unnamed: 4 出勤（天）2830303030Unnamed: 5 实出勤（天）30322630305人Unnamed: 6 基本工资50005000500050005000Unnamed: 7 加班 天数22----------------------------Unnamed: 8 加班工资357.142857142857333.3333333333330000000000000000000000000000Unnamed: 9 补贴200200300400500Unnamed: 10 其它Unnamed: 11 应发 工资5557.142857142865533.33333333333530054005500000000000000000000

2025年薪酬核算工资表 - 1 Unnamed: 0 Unnamed: 1 工 资 表序号1234567891011121314151617181920212223Unnamed: 2 姓名姓名1合计Unnamed: 3 岗位Unnamed: 4 账号Unnamed: 5 银行卡号Unnamed: 6 出勤天数28Unnamed: 7 基本工资70007000Unnamed: 8 加 班10001000Unnamed: 9 奖 金500500Unnamed: 10 绩 效0Unnamed: 11 补贴0Unnamed: 12 应发合计85280000000000000000000008528Unnamed: 13 电 费0Unnamed: 14 扣款0Unnamed: 15 罚 款0Unnamed: 16 借 支00Unnamed: 17 应扣合计00000000000000000000000Unnamed: 18 个 税142.8000000000000000000000......2024excel表格操作大全算工资

2025年财务核算工资表 - 工资表 Unnamed: 0 Unnamed: 1 工 资 表序号1234567891011121314151617181920212223242526合 计Unnamed: 2 工号3289Unnamed: 3 姓名王伟伟Unnamed: 4 部门市场部Unnamed: 5 基本工资30003000Unnamed: 6 补贴100100Unnamed: 7 加班工时44Unnamed: 8 加班费300300Unnamed: 9 奖金5050Unnamed: 10 合计345400000000000000000000000003454Unnamed: 11 旷工0Unnamed: 12 缺勤0Unnamed: 13 扣税0Unnamed: 14 罚款2020Unnamed: 15 其它0Unnamed: 16 合计20000000000000000000000000020Unnamed: 17 实发工资3434000000000......

2025年新个税自动计算工资表 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表工号合计Unnamed: 2 姓名Unnamed: 3 职称Unnamed: 4 薪酬底薪Unnamed: 5 应发金额福利部分岗位补贴0Unnamed: 6 考核补贴0Unnamed: 7 全勤奖0Unnamed: 8 住宿补贴0Unnamed: 9 绩效补贴0Unnamed: 10 加班工资0Unnamed: 11 其他0Unnamed: 12 合计000000000000000000000Unnamed: 13 出勤栏迟到早退0Unnamed: 14 病假0Unnamed: 15 事假Unnamed: 16 旷工Unnamed: 17 小计000000000000000000000Unnamed: 18 应发合计000000000000000000000Unnamed: 19 应扣金额代缴费用社保0Unnamed: 20 个税00000000000000

2025年自动计算工资表 - Sheet1 工资表 公司：序号12345678910111213141516171819202122232425合计Unnamed: 1 姓名张一张二制表人：Unnamed: 2 入职时间Unnamed: 3 工资收入基本工资68006800Unnamed: 4 加班工资200200Unnamed: 5 年龄工资0Unnamed: 6 工资扣款养老保险0Unnamed: 7 失业保险0Unnamed: 8 医疗保险0Unnamed: 9 工伤保险0财务审核：Unnamed: 10 生育保险0Unnamed: 11 公积金0Unnamed: 12 其它0Unnamed: 13 税前工资70000000000000000000000000007000Unnamed: 14 专项附加抵扣子女教育0Unnamed: 15 继续教育0Unnamed: 16 大病医疗0Unnamed: 17 日期：

2025年薪酬结算工资表 - Sheet2 薪酬结算工资表 部门行政部行政部开发部开发部开发部开发部开发部Unnamed: 1 姓名黄梅梅詹琳陈宾开祝时苼张海万源飞李尼微Unnamed: 2 基本工资40005000120001000010000100008000Unnamed: 3 补贴餐补1000100010001000100010001000Unnamed: 4 交通补贴500500500500500500500Unnamed: 5 奖金提成0036002000200020000Unnamed: 6 工资总计5500650017100135001350013500950000000000000000000000000000000000000000000000000000000000000000000000000000000000000000......