2025日计件工资表的制作与核算
员工计件工资表(总金额统计核算)-Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 计件工资表(总金额统计核算)单位:元 产品名 工程名例1Unnamed: 3 例A(单位:罐)人数10Unnamed: 4 天数5Unnamed: 5 件数1000Unnamed: 6 件薪10Unnamed: 7 总金额10000000000000000000000000000000000000000000000000Unnamed: 8 人均产量100000000000000000000000000000000000000000000000Unnamed: 9 日均产量20000000000000000000000000000000000000......
2025年计件工资表-工资发放表-Sheet1 Unnamed: 0 Unnamed: 1 XXXX公司 年 月计件工资表人员编号&人员姓名1001张三1002李四1003王五1004刘二1001张三1002李四1003王五1004刘二1005张三1001张三合计人员编号&人员姓名1001张三1002李四1003王五1004刘二1005张三合计Unnamed: 2 人员编号1001100210031004100110021003100410051001基本工资150015001500150015007500Unnamed: 3 人员姓名张三李四王五刘二张三李四王五刘二张三张三 住房补贴5005005005005002500Unnamed: 4 部门名称不锈钢车间不锈钢车间清洗车间清洗车间不锈钢车间不锈钢车间清洗车间清洗车间不锈钢车
2025年计件工资员工薪酬待遇-Sheet1 计件工资员工薪酬待遇 序号1Unnamed: 1 年月43678Unnamed: 2 姓名黄东明Unnamed: 3 工号3294Unnamed: 4 生产商品名称A产品B产品Unnamed: 5 本月生产件数43235Unnamed: 6 每件单价8100Unnamed: 7 计件工资合计3456350000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2025年计件工资表(工厂计件薪资核算表-Sheet1 计件工资表-自动汇总年度工资 年度:2019序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
2025年计件工资表-Sheet1 计件工资表 序号12345678910111213141516171819202122232425262728293031Unnamed: 1 姓 名莉莉Unnamed: 2 基本工资1800Unnamed: 3 出勤31Unnamed: 4 计件25Unnamed: 5 计件工资2500Unnamed: 6 加班15Unnamed: 7 工龄8Unnamed: 8 全勤奖500Unnamed: 9 其他奖励1500Unnamed: 10 五险一金扣款1500Unnamed: 11 应发工资4800Unnamed: 12 领取人签字Unnamed: 13 备 注Sheet2 Sheet3
2025年计件工资表汇总统计-Sheet1 Unnamed: 0 计件工资表汇总统计 序号123456789101112Unnamed: 2 工单号130906213090621309063130906313090631309063130906213090621309062130906213090621309062Unnamed: 3 工序代号SF0039-23SF0039-24SF0039-25SF0039-26SF0039-31SF0039-32SF0039-37SF0039-38SF0039-39SF0039-40SF0039-41HF0039-18Unnamed: 4 产 品 名 称Manual comm JW H61M简易使用指南Manual comm JW H61M简易使用指南1、柏氏雪晶灵保湿乳液买1送3优惠装套盒1、柏氏雪晶灵保湿乳液买1送3优惠装套盒1、柏氏雪晶灵保湿乳液买1送3优惠装套盒1、柏氏雪晶灵保
2025年每日计件工资表-Sheet1 Unnamed: 0 Unnamed: 1 每日计件工资明细表序号1Unnamed: 2 姓名张三Unnamed: 3 日期Unnamed: 4 生产件数Unnamed: 5 每件单价Unnamed: 6 今天是:金额0Unnamed: 7 2018-11-20 00:00:00审核人Unnamed: 8 备注
2025年计件工资表(加入公式)-Sheet1 公司20XX年X月工资表 序号123456789101112131415合计Unnamed: 1 姓名李张主管:Unnamed: 2 编号111112Unnamed: 3 所属部门XX车间XX车间Unnamed: 4 计件明细完成件数300300Unnamed: 5 有效件数260280Unnamed: 6 每件金额1515Unnamed: 7 小计390042000000000000000审核:Unnamed: 8 非计件明细基本工资18001800Unnamed: 9 当月奖金500500Unnamed: 10 当月扣款400200Unnamed: 11 加班天数55Unnamed: 12 加班工资600600Unnamed: 13 实发工资64006900000000000000013300制表:Unnamed: 14 签字Sheet2 Sheet3
2025年计件工资表-自动计算-计件工资表 儿股份有限责任公司计件工资表 工资统计年月>>序号12Unnamed: 1 姓名张三三王四四Unnamed: 2 生产工序A工序A工序Unnamed: 3 单价(元)0.370.36Unnamed: 4 2019月工资金额5718.354134.960000000000000000000000000000000000000000000000000000
2025年计件工资表(简约)-Sheet1 XX公司20XX年XX月工资表(计件) 制表部门:序号1234567891011121314151617181920合计Unnamed: 1 工号Unnamed: 2 部门Unnamed: 3 姓名Unnamed: 4 产品Unnamed: 5 收入共计Unnamed: 6 单件工资Unnamed: 7 合格数Unnamed: 8 缴扣共计Unnamed: 9 单件损耗罚金Unnamed: 10 制表时间:损耗数Unnamed: 11 工资 合计Unnamed: 12 签名Unnamed: 13 备注Sheet2 Sheet3
2025年计件工资表-公式计算-Sheet1 Unnamed: 0 计件工资表-公式计算 生产日期:序号1234567891011Unnamed: 2 生产 日期2020-04-01 00:00:002020-04-02 00:00:002020-04-03 00:00:002020-04-04 00:00:002020-04-05 00:00:002020-04-06 00:00:002020-04-07 00:00:002020-04-08 00:00:002020-04-09 00:00:002020-04-10 00:00:002020-04-11 00:00:00Unnamed: 3 2020-04-01 00:00:00生产 工号M104M105107108109110111112113114116Unnamed: 4 姓名何明举牟兴贵黄丽坤丁慧李江孙秀群宁芳汪刚牟春梅王革伟陈溪生Unnamed: 5 工单号Unnamed: 6 工序代码Unnamed: 7 产品名称-----
2025年计件工资表-Sheet1 Unnamed: 0 Unnamed: 1 计件工资登记表公司名称:序号123456789101112131415Unnamed: 2 员工姓名123456789101112131415Unnamed: 3 入职日期2021-02-01 00:00:002021-02-02 00:00:002021-02-03 00:00:002021-02-04 00:00:002021-02-05 00:00:002021-02-06 00:00:002021-02-07 00:00:002021-02-08 00:00:002021-02-09 00:00:002021-02-10 00:00:002021-02-11 00:00:002021-02-12 00:00:002021-02-13 00:00:002021-02-14 00:00:002021-02-15 00:00:00Unnamed: 4 身份证号xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
2025年计件工资表-月份统计-Sheet1 Unnamed: 0 计件工资表-月份统计 日期2019-01-15 00:00:002019-02-15 00:00:002019-03-15 00:00:002019-04-15 00:00:002019-01-15 00:00:002019-02-15 00:00:002019-03-15 00:00:002019-04-15 00:00:002019-01-15 00:00:002019-02-15 00:00:002019-03-15 00:00:002019-04-15 00:00:002019-03-29 00:00:00Unnamed: 2 姓名编号ZATZATZATZHZHZHZHZHZHDJDJDJDJUnnamed: 3 姓名小李小赵小赵小陶小李小李小李小陶小陶小芳小芳小芳小芳Unnamed: 4 编号2002200320042005200620082009201020112012201420152016Unnamed: 5 工序名称YB2-180-2P
2025年计件工资表-合格率计算-Sheet1 Unnamed: 0 计件工资表-合格率计算 日期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姓名5Unn
2025年计件工资表-切割 Unnamed: 0 Unnamed: 1 计件工资表日期437704377143772437734377443775437764377743778437794378043781437824378343784437854378643787437884378943790437914379243793437944379543797437994380043801438024380343804438054380643807438084380943810438114381243813Unnamed: 2 计件员工周谷伟周谷伟肖文魁肖文魁邓剑峰邓剑峰邓剑峰邓剑峰邓剑峰邓剑峰邓剑峰邓剑峰肖文魁周谷伟邓剑峰邓剑峰肖文魁肖文魁肖文魁肖文魁肖文魁肖文魁肖文魁肖文魁周谷伟周谷伟周谷伟肖文魁肖文魁肖文魁肖文魁肖文魁肖文魁周谷伟邓剑峰吴国红黄文明黄文明黄
2025年计件工资表-自动计算查询-Sheet1 Unnamed: 0 计件工资表 工资总支出序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136Unnamed: 2 姓名马莎莎王林蔚蓝Unnamed: 3 54300身份证号......
2025年计件工资表-计件工资表 员工工资表(计件) 注:首先在K、L列维护员工工号和姓名,C列工号下拉选择,D列姓名自动,I列、M列自动计算序号1Unnamed: 1 日期2020-07-02 00:00:00Unnamed: 2 工号1001Unnamed: 3 姓名员工A1------------------------------------------------------------------------------------------------------------------------------------------------
2025年计件工资表(和合格率挂钩)-Sheet1 Unnamed: 0 计件工资表(和合格率挂钩) 序号12Unnamed: 2 计件日期2020-04-30 00:00:002020-04-30 00:00:00Unnamed: 3 员工1员工1员工1Unnamed: 4 产品产品A产品BUnnamed: 5 产品数量85120Unnamed: 6 合格数量77100Unnamed: 7 合格率0.9058823529411760.833333333333333Unnamed: 8 计件单价0.90.5Unnamed: 9 扣除比例00.1Unnamed: 10 应得工资69.345Unnamed: 11 Unnamed: 12 产品产品A产品BUnnamed: 13 计件单价0.90.5Unnamed: 14 Unnamed: 15 合格率最低(含)0.90.80.70.50Unnamed: 16 最高(包含)10.90.80.70.5Unnamed: 17 工资扣除
2025年计件工资表-Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 计件工资表序号Unnamed: 3 姓名Unnamed: 4 底薪Unnamed: 5 件数Unnamed: 6 提成标准Unnamed: 7 提成工资Unnamed: 8 罚款Unnamed: 9 应发工资Unnamed: 10 签字确认
2025年计件工资表-计件工资表 计件工资表 单位名称:XX科技研发有限工资序号1234567891011121314151617合计制表人: 审核人: 总经理:Unnamed: 1 姓名12345Unnamed: 2 基本工资3000300030003000300015000Unnamed: 3 全勤奖2002002002002001000Unnamed: 4 计件工资计件8138816867385893707Unnamed: 5 单价22222/Unnamed: 6 合计162617621372147611787414Unnamed: 7 加班补助2002002002002001000Unnamed: 8 工龄津贴501005010050350Unnamed: 9 其他奖励000000
2025年计件工资表-基础信息录入表 计件工基础信息表 姓名梁小慧周永启丁莉莉李雪莲沈宽敏李冲吴雪梅彭勇芳彭夕明Unnamed: 1 组别ABCDABCDAUnnamed: 2 职务四针六线锁边锁边锁边锁边平车平车坎车坎车Unnamed: 3 基本工资200020002000200020002000200020002000Unnamed: 4 账号123124125126127128129130131Unnamed: 5 身份证号456457458459460461462463464Unnamed: 6 备注员工计件工资表 Unnamed: 0 Unnamed: 1 Unnamed: 2 计件工资表姓名梁小慧周永启丁莉莉李雪莲沈宽敏沈宽敏李冲吴雪梅彭勇芳彭夕明Unnamed: 3 组别ABCDAABCDAUnnamed: 4 职位四针六线锁边锁
2025年计件工资表-自动-成型 Unnamed: 0 计件工资表 生产单位型体单价产能件资总权数:序号12345678合计Unnamed: 2 成型12.5200250080.85姓名8Unnamed: 3 0工种掹鞋敲鞋掹鞋普工磨底Unnamed: 4 组别:技能 系数1.651.61.80.81.57.35Unnamed: 5 每分权重:出勤 工时1111111111Unnamed: 6 分配 权数18.1517.619.88.816.500080.85Unnamed: 7 制表日期:30.921459492888065分配 件资561.2244897959183544.21768707483612.2448979591837272.108843537415510.20408163265310002500Unnamed: 8 元/分工时 补贴0Unnamed: 9 2020-06-30 00:00:00实得 件资561.2244897959183544.
2025年计件工资表-Sheet1 Unnamed: 0 Unnamed: 1 查询姓名张三底薪3000计件工资2500应发工资5800Unnamed: 2 Unnamed: 3 姓名张三Unnamed: 4 工号3003Unnamed: 5 底薪3000Unnamed: 6 件数5000Unnamed: 7 单价0.5Unnamed: 8 计件工资25000000000000000000Unnamed: 9 补贴300Unnamed: 10 社保600Unnamed: 11 罚款0Unnamed: 12 应发工资580000000000000
2025年计件工资表-计件工资表 计 件 工 资 表(公式自动汇总) 计 件 明 细序号123456789101112131415161718192021Unnamed: 1 姓名王晓燕王小五杨小平郭晓东吴苏苏梁雪雪王晓燕王小五杨小平郭晓东吴苏苏Unnamed: 2 日期2019-10-11 00:00:002019-10-11 00:00:002019-10-11 00:00:002019-10-11 00:00:002019-10-11 00:00:002019-10-11 00:00:002019-10-12 00:00:002019-10-12 00:00:002019-10-12 00:00:002019-10-12 00:00:002019-10-12 00:00:00Unnamed: 3 工序名称工序1工序2工序3工序4工序5工序6工序1工序2工序3工序4工序5Unnamed: 4 计件数量10008009009051
2025年计件工资表(含新个税、社保公式)-Sheet1 计件工资表(新个税、社保自动计算) 单位名称: 时 间: 序号1Unnamed: 1 工号A7001Unnamed: 2 姓名张小艾Unnamed: 3 性别女Unnamed: 4 工资部分保底工资3000Unnamed: 5 产出件数100Unnamed: 6 合格件数100Unnamed: 7 每件工资30Unnamed: 8 罚款200Unnamed: 9 奖金500Unnamed: 10 小计6300Unnamed: 11 社保缴款养老保险504Unnamed: 12 医疗保险126Unnamed: 13 失业保险25.2Unnamed: 14 小计655.2Unnamed: 15 个税19.34Unnamed: 16 实发工资5644.8Un
2025年计件工资表-Sheet1 Unnamed: 0 计件工资表 姓 名合 计Unnamed: 2 款式1工价1.1件数5040Unnamed: 3 款式2工价2.1件数5040Unnamed: 4 款式3工价3.1件数5040Unnamed: 5 款式4工价4.1件数5040Unnamed: 6 款式5工价5.1件数5040Unnamed: 7 款式6工价6.1件数5040Unnamed: 8 款式7工价7.1件数5040Unnamed: 9 款式8工价8.1件数5040Unnamed: 10 年 月 日收入小计1840147200000000Unnamed: 11 补助Unnamed: 12 其他Unnamed: 13 支出借支Unnamed: 14 其他扣款200Unnamed: 15 总支出200000000000200Unnamed: 16 总收入18401472000000003312Unnamed: 17 支出
2025年计件工资表(自动计算)-计件 Unnamed: 0 工资表 工资 姓名總計Unnamed: 2 考勤工时基本 工时1681681521601681441681521681601681681682112Unnamed: 3 正常加班工时62605757622761536056626262741Unnamed: 4 双休加班工时40404040404040324040404040512Unnamed: 5 节假日加班工时00000000000000制表:
2025年计件工资表-Sheet1 Unnamed: 0 计件工资表 序号1Unnamed: 2 姓名张可乐Unnamed: 3 岗位车间组长Unnamed: 4 基本工资5000Unnamed: 5 标准出勤天数26Unnamed: 6 出勤天数24Unnamed: 7 请假天数2Unnamed: 8 绩效津贴200Unnamed: 9 岗位津贴300Unnamed: 10 超标数量15000Unnamed: 11 单价0.2Unnamed: 12 超标金额300000000000000000000000000000000000Unnamed: 13 应发工资850000000000000000000000000000000000Unnamed: 14 社保200Unnamed: 15 公积金100Unnamed: 16 请假扣款384.615384615385Unnamed: 17 实发工资7815.38461538462Sheet2 Sheet3
2025年计件工资表-自动计算汇总-1 计件工资表-自动计算汇总 工资汇总表(自动汇总)姓名小花小明小罗小芳小熊合计计件明细所属月份7月7月7月7月7月8月8月8月8月8月9月9月合计Unnamed: 1 Unnamed: 2 1月000000计件日期2020-07-01 00:00:002020-07-02 00:00:002020-07-03 00:00:002020-07-05 00:00:002020-07-06 00:00:002020-08-01 00:00:002020-08-05 00:00:002020-08-06 00:00:002020-08-08 00:00:002020-08-30 00:00:002020-09-05 00:00:002020-09-07 00:00:00Unnamed: 3 2月000000姓名小花小明小花小罗小芳小熊小明小花小罗小芳小熊小花Unnamed: 4 3月000000计件工序工
2025年计件工资表-自动计算查询-Sheet1 工资表 时间:2019年6月序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135Unnamed: 1 姓名张明明王乐乐曹雯雯Unnamed: 2 身份证号Unnamed: 3 工资总支出工 种
2025年计件工资表-Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 计件工资表姓 名Unnamed: 3 工号Unnamed: 4 职位Unnamed: 5 工种Unnamed: 6 数量Unnamed: 7 单价Unnamed: 8 计件工资Unnamed: 9 打款账号Unnamed: 10 备注
2025年计件工资表-员工时间段统计计算-记录表 Unnamed: 0 员工计件工资明细表 序号12345678910Unnamed: 2 日期2020-03-01 00:00:002020-03-02 00:00:002020-03-03 00:00:002020-03-04 00:00:002020-03-05 00:00:002020-03-06 00:00:002020-03-07 00:00:002020-03-08 00:00:002020-03-09 00:00:002020-03-10 00:00:00Unnamed: 3 姓名梁小慧周永启丁莉莉李雪莲沈宽敏沈宽敏李冲吴雪梅彭勇芳梁小慧Unnamed: 4 组别ABCDAABCDAUnnamed: 5 计件工序四针六线锁边锁边锁边锁边锁边平车平车坎车四针六线Unnamed: 6 计件件数38045144720147623282328366817203804Unnamed: 7 计件片数22225
2025年计件工资表-计件工资表 Unnamed: 0 Unnamed: 1 Unnamed: 2 Unnamed: 3 序号1Unnamed: 4 姓名员工1Unnamed: 5 部门生产部Unnamed: 6 工位装配Unnamed: 7 工号AUnnamed: 8 出勤 天数28Unnamed: 9 基本工资2200Unnamed: 10 产品1工时1Unnamed: 11 数量1500Unnamed: 12 计件工资1500Unnamed: 13 产品2工时2Unnamed: 14 数量2000Unnamed: 15 计件工资4000Unnamed: 16 奖金500Unnamed: 17 应发总额8200Unnamed: 18 应扣金额缺勤扣款50Unnamed: 19 社保390Unnamed: 20 其他扣款200Unnamed: 21 小计640Unnamed: 22 实发工资7560计件明细表 计件明细表(天) 序
2025年计件工资表-公式自动计算-计件工资表 Unnamed: 0 工厂(车间)计件工资统计明细表序号123Unnamed: 1 日期2020-05-02 00:00:002020-05-03 00:00:002020-05-03 00:00:00Unnamed: 2 姓名张三三张三三李四_2Unnamed: 3 工作内容拉链拉链衣服Unnamed: 4 数量100089020Unnamed: 5 单价0.230.2313Unnamed: 6 金额230204.726000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2025年计件工资表-hlkjvi 7月 Unnamed: 0 员工薪资明细表 序123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
2025年计件工资表-Sheet1 计件工资表 序号12345678910合计Unnamed: 1 姓名小美小芳Unnamed: 2 计件 分类计件计时计件计时计件计时计件计时计件计时计件计时计件计时计件计时计件计时计件计时计件计时Unnamed: 3 单价1.2251.2525Unnamed: 4 金额合计5735.35986.25Unnamed: 5 数量合计439418.54529130000000000000000892331.5Unnamed: 6 1三380244618263Unnamed: 7 2四340249218323Unnamed: 8 3五5203512110324Unnamed: 9 4六6802.5555112353.5Unnamed: 10 5日00Unnamed: 11 6一562136539274Unnamed: 12 7二372246528374Unnamed: 13 8三3402685110253Unnamed:
2025年计件工资表-Sheet1 Unnamed: 0 Unnamed: 1 计件工资明细表所属区间:序号12345678910Unnamed: 2 工号25615455256154562561545725615458256154592561546025615461256154622561546325615464Unnamed: 3 姓名张三李四王五刘丽王思王伟乔海王丹刘华赵倩Unnamed: 4 工序工序1工序2工序3工序4工序5工序6工序7工序8工序9工序10Unnamed: 5 单价150220310420150220310420120150Unnamed: 6 制表人:计件个数34363841353838283940Unnamed: 7 不合格件数2441423143Unnamed: 8 合格件数32323440313635273537Unnamed: 9 确认件数32323440313635273537Unnamed: 10 应发
2025年计件工资表-Sheet1 工资表 公司: 日期: 年 月 日 制表人:序号1合计金额(大写)Unnamed: 1 姓名儿Unnamed: 2 本月生产件数12003985Unnamed: 3 合格件数1195Unnamed: 4 单价3Unnamed: 5 计件工资3585000000000000000000Unnamed: 6 加班280Unnamed: 7 夜班补贴200Unnamed: 8 应发工资4065000000000000000000Unnamed: 9 代扣保险50Unnamed: 10 其他代扣30Unnamed: 11 实发工资39850000000000000000003985Unn
2025年计件工资表-Sheet1 计件工资表 年度:2018序号12Unnamed: 1 姓名黄东明谢名Unnamed: 2 本月总生产件数1560869Unnamed: 3 合格件数1500860Unnamed: 4 月份:6月损耗件数60900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000......