2025工资薪金excel计算公式
2025年工资表-自动计算 - Sheet1 Unnamed: 0 Unnamed: 1 工资表-自动计算日期2019-03-15 00:00:002019-03-16 00:00:002019-03-17 00:00:002019-03-18 00:00:002019-03-19 00:00:002019-03-20 00:00:002019-03-21 00:00:002019-03-22 00:00:002019-03-23 00:00:002019-03-24 00:00:002019-03-25 00:00:002019-03-26 00:00:002019-03-27 00:00:002019-03-28 00:00:002019-03-29 00:00:002019-03-30 00:00:00Unnamed: 2 姓名编号ZATZATZATZHZHZHZHZHZHZHDJDJDJDJDJDJUnnamed: 3 姓名姓名2姓名2姓名2姓名3姓名3姓名3姓名3姓名3姓名3姓名3姓名5姓名5姓名5姓名5姓名5姓名
2025年工资表-自动计算查询 - Sheet1 工资表 部门：序号1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495Unnamed: 1 姓名李白王洪礼刘邦Unnamed: 2 基本 工资6000Unnamed: 3 奖金 提成500Unnamed: 4 财务：工龄 工资600Unnamed: 5 补贴50Unnamed: 6 加班费750Unnamed: 7 医疗 保险70Unnamed: 8 会计：生育 保险35Unnamed: 9 工伤 保险15Unnamed: 10 失业 保险0Unnamed: 11 时间：养老 保险280Unnamed: 12 2019-01-01 00:00:00住
2025年薪酬工资表-自动计算 - 工资表模板 薪 资 发 放 明 细 表 填报部门： 序号1234567891011121314Unnamed: 1 姓名批准：Unnamed: 2 应发工资基本工资2000Unnamed: 3 日工资日工资Unnamed: 4 工作日Unnamed: 5 加班工资1.5倍Unnamed: 6 2倍Unnamed: 7 所属月份： 月 3倍Unnamed: 8 绩效工资200Unnamed: 9 小计2200000000000000Unnamed: 10 其他应发全勤奖200Unnamed: 11 交通补贴200Unnamed: 12 通讯补贴200审核：Unnamed: 13 生活补贴200Unnamed: 14 年资补贴200Unnamed: 15 其他补贴200Unnamed: 16 小计12000000000000000Unnamed: 17 其他应扣缺勤扣款天数200
2025年工资表（自动计算） - Sheet1 Unnamed: 0 Unnamed: 1 工资表（自动计算）编号12345678910111213141516171819202122232425合计：制表人： 审批人： 出纳：Unnamed: 2 姓名Unnamed: 3 出勤Unnamed: 4 基本工资岗位工资Unnamed: 5 全勤奖Unnamed: 6 提成Unnamed: 7 合计00000000000000000000000000Unnamed: 8 扣款请假0Unnamed: 9 迟到0Unnamed: 10 旷工0Unnamed: 11 罚款0Unnamed: 12 其它0Unnamed: 13 代缴费用社保（元）0Unnamed: 14 住房公积金（元）0Unnamed: 15 应扣合计000000000
2025年5月工资表自动计算 - 工资表 Unnamed: 0 工 资 表（自动计算） 公司名称：序号1234567891011121314151617合 计Unnamed: 2 姓名王亮亮Unnamed: 3 职工编号236Unnamed: 4 部门财务部Unnamed: 5 职位出纳Unnamed: 6 应发工资基本工资40004000Unnamed: 7 工龄工资100Unnamed: 8 岗位津贴200Unnamed: 9 奖金500500Unnamed: 10 其他10001000Unnamed: 11 合计58005800Unnamed: 12 扣款工资社保700700Unnamed: 13 公积金400400制表人：Unnamed: 14 其他100100Unnamed: 15 合计12001200Unnamed: 16 2019年 5 月份实发工资46004600Unnamed: 17 确认签字说明 Unnamed:
2025年计件工资表-自动计算查询 - Sheet1 工资表 时间：2019年6月序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135Unnamed: 1 姓名张明明王乐乐曹雯雯Unnamed: 2 身份证号Unnamed: 3 工资总支出工 种
2025年工资表(自动计算，图表显示) - 员工工资表 部门工资总额 月份 部门 财务部技术部综合部人力资源部市场开发部工程管理部Unnamed: 1 一月份450000340000220000340000450000350000Unnamed: 2 二月份440000420000670000200000120000230000Unnamed: 3 三月份300000654320230000340000650000520000Unnamed: 4 四月份560000450000500000210000500000450000Unnamed: 5 五月份580000120000340000230000300000440000Unnamed: 6 六月份340000500000450000340000220000340000Unnamed: 7 七月份510000300000440000420000670000450000Unnamed: 8 八月份900000120000340000230000
2025年工资表（自动计算） - 工资表明细 Unnamed: 0 Unnamed: 1 工资表公司名称：序号1234567891011121314合计Unnamed: 2 姓名姓名1姓名2姓名3姓名4姓名5姓名6姓名7姓名8姓名9姓名10姓名11姓名12姓名13姓名14Unnamed: 3 部门职位Unnamed: 4 入职时间Unnamed: 5 基本工资上班天数3131313131313131313131313131Unnamed: 6 制表人：基本工资3500350035003500350035003500350035003500350035003500350049000Unnamed: 7 全勤奖2002002002002002002002002002002002002002002800Unnamed: 8 提成奖励提成10005001000500500100010005001000500500100050050010000Unnamed: 9 审核2025工资薪金excel计算公式
2025年工资表-函数计算 - Sheet1 Unnamed: 0 工资表 序号1234567891011121314151617181920212223242526272829303132333435363738394041424344合计Unnamed: 2 姓名姓名1姓名2姓名3姓名4姓名5姓名6姓名7姓名8姓名9姓名10姓名11姓名12姓名13姓名14Unnamed: 3 应发工资基本工资4200370058003800400032007200430060003000800046004900370066400Unnamed: 4 岗位津贴200200400Unnamed: 5 工龄津贴303060Unnamed: 6 奖金0Unnamed: 7 加班工资工时24122112151721122712321197Unnamed: 8 时薪66666606660666Unnamed: 9 金额1447212672901020126721620721812600
2025年工资表（自动计算） - 工资表 Unnamed: 0 工资表 项目部名称：序号1234567891011121314151617181920项目经理审批：Unnamed: 2 姓名合计Unnamed: 3 核定月劳务费月基本 劳务费200040005000300014000Unnamed: 4 加班费200200复核：Unnamed: 5 其他0Unnamed: 6 劳务队（班组）名称：扣项缺勤 扣款300300Unnamed: 7 其它 扣款0Unnamed: 8 管理人员应发 合计2000400052002700000000000000000013900制表：Unnamed: 9 代扣代缴个人所得税所得额2000400052002700000000000000000013900Unnamed: 10 所属月份：个税 起征点35003500350035003500350035003500350035003500350035
2025年工资表自动计算 - 员工工资明细表 Unnamed: 0 Unnamed: 1 员工工资明细表员工编号BH9527Unnamed: 2 姓名张帆Unnamed: 3 所属部门技术部Unnamed: 4 基本工资5500Unnamed: 5 工龄工资300Unnamed: 6 奖金500Unnamed: 7 出勤扣款20Unnamed: 8 社保630Unnamed: 9 应发工资5690000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2025年工资表-个税计算 - 1 Unnamed: 0 工资表-个税计算 工 号合计Unnamed: 2 姓 名Unnamed: 3 部 门Unnamed: 4 正常 上班 工资Unnamed: 5 工作 天数Unnamed: 6 实际 工资880070005000600036006500250078005600200054800Unnamed: 7 应发款项(元)其它 工资5005005005002005003005001505004150Unnamed: 8 岗位 津贴3003003003003003003003003003003000Unnamed: 9 夜班 津贴2002002002002002002002002002002000Unnamed: 10 补款50505050505050505050500Unnamed: 11 应发 工资985080506050705043507550335088506300305064450Unnamed: 12 应扣款项(元)扣个 人所 得税170
2025年员工工资表（自动计算） - Sheet1 Unnamed: 0 Unnamed: 1 员工工资表工号NO001NO002NO003NO004NO005NO006NO007NO008NO009合计Unnamed: 2 部门财务部财务部财务部财务部财务部财务部财务部财务部财务部Unnamed: 3 姓 名赵三王五丽丽六六王黄刘丽大华贝佳王丽Unnamed: 4 基本 工资40004000500040004000500050006000600043000Unnamed: 5 加班工资平时加班2004004003005003002005001002900Unnamed: 6 周末加班6005007006005007007006005005400Unnamed: 7 节假日加班1000100010001000100010001000100010009000Unnamed: 8 合计180019002100190020002000190021001600000000
2025年工资表-个税计算 - Sheet2 Unnamed: 0 Unnamed: 1 工资表-个税计算序号123456789101112131415161718Unnamed: 2 部门财务部财务部财务部财务部财务部Unnamed: 3 姓名姓名1姓名2姓名3姓名4姓名5Unnamed: 4 职位出纳出纳出纳出纳出纳Unnamed: 5 状态实习正式员工实习正式员工实习Unnamed: 6 工资底薪48005000500040003500Unnamed: 7 工资奖项岗位 补贴2600120020008001400Unnamed: 8 保密津贴800100010006001000Unnamed: 9 绩效奖金10002000010000Unnamed: 10 加班费用200200200200200Unnamed: 11 其它奖励10002000010000Unnamed: 12 小计560064003200360026000
2025年工资表-查询计算 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表工资查询工号1000110002合 计Unnamed: 2 姓名叶知秋陆河Unnamed: 3 姓名出勤天数2726Unnamed: 4 叶知秋应发工资底薪300030006000Unnamed: 5 生产奖金10008001800Unnamed: 6 应发工资假日津贴300300Unnamed: 7 4450全勤奖金100100200Unnamed: 8 加班津贴5050Unnamed: 9 实发工资小计44503900000000000000000008350Unnamed: 10 3350扣除部分缺勤扣款0Unnamed: 11 伙食费200200400Unnamed: 12 实发工资总额罚款100100Unnamed: 13 借支10001000Unnamed: 14 7250实发工资33503900000000000000000007
2025年工资表财务计算 - Sheet2 Unnamed: 0 Unnamed: 1 20XX 年 XX 月 工 资 表Unnamed: 2 部门：序号12345678910111213141516171819Unnamed: 3 基本信息姓名Unnamed: 4 职位Unnamed: 5 月工资底薪6000100001000080007000102748128700058646000Unnamed: 6 工资加项加班费260012002000800140036742528120010641000Unnamed: 7 全勤80010001000600100012006001000400400Unnamed: 8 补贴100020000100001200120010008001000Unnamed: 9 本月绩效考核得分1010101010910101010Unnamed: 10 绩效奖金1001001001001000100100100100Unnamed: 11 小计1050014310131101051095102025工资薪金excel计算公式
2025年员工工资表（自动计算） - Sheet1 Unnamed: 0 Unnamed: 1 员工工资表序号12345678合计Unnamed: 2 员工姓名12345678Unnamed: 3 部门财务部技术部技术部技术部技术部技术部技术部技术部Unnamed: 4 应发工资基本工资5000600070005000600070006000700049000Unnamed: 5 绩效工资60080012003009007006008005900Unnamed: 6 全勤奖2002002002002001000Unnamed: 7 奖金5003002001000Unnamed: 8 合计6100700085005500710079006800800056900Unnamed: 9 应扣工资五险一金养老保险7979797979797979632Unnamed: 10 医疗保险2392392392392392392392391912Unnamed: 11 失业保险77777
2025年工资表-自动计算 - Sheet1 Unnamed: 0 Unnamed: 1 工资表-自动计算序号123456789101112131415161718192021222324Unnamed: 2 编号101251012610127101281012910130101311013210133101341013510136101371013810139101401014110142101431014410145101461014710148Unnamed: 3 姓名张三李四王麻子***************************************************************Unnamed: 4 日期2019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:002019-10-15 00:00:00
2025年工资表-自动计算 - 工资结算单 Unnamed: 0 Unnamed: 1 工 资 表 - 自 动 计 算序号1234567891011121314Unnamed: 2 姓名张三李四王五马六赵七钱八孙九周一吴二郑三章四韩五刘六A14Unnamed: 3 部门办公室办公室销售部销售部销售部后勤部后勤部制造部制造部制造部制造部制造部制造部制造部Unnamed: 4 岗位工资 标准20001500120014001300170010001300160015001300130013000Unnamed: 5 岗位工资1000800800800800800600100010006006006006000Unnamed: 6 绩效工资 标准5005005005004805005005005005005005005000Unnamed: 7 绩效 工资54365543554323434525566447
