完整工资表模板(带公式)

基本工资岗位工资职务工资交通补助应发工资工龄工资全勤奖销售奖励应发工资总额意外险社保个人所得税合计扣款工服迟/早罚款合计1王峰总经理130003127100001500120030013673.555010013823.5524500.001500.002024.00200305028011519.552王爽副总经理90003127700010008002009466.30501009616.3024400.00424.00200302308962.303候福人事助理5000312535008505001504869.504869.5024400.00424.00200102104235.504杨艺人事经理1000031278000100080020010518.1110518.112410001024.002002009294.11500.000.000.0000.00600.000.000.0000.00700.000.000.0000.00370001241062850043503300850152785.35100200038827.4696130025003896800408092034011.468王颖主管4000312030006502001503116.483116.4824400.00424.00200502502442.489李美收银领班3500312229003501001502999.612999.612424.002002002775.6110刘赛收银员3000311628501501869.891869.892424.00200102101635.891100.000.000.0000.001200.000.000.0000.001300.000.000.0000.001050093588750100030045023724.1900023724.19724000472.006001050660.0022592.1914张三值班经理5000312235008505001504285.162004485.162424.002002004261.1615李四汗蒸领班3500311029003501001501363.461363.462424.002002001139.4616王二汗蒸服务员3000311828501502103.622103.622424.002002001879.621700.000.000.0000.001800.000.000.0000.001900.000.000.0000.002000.000.000.0000.002100.000.000.0000.00221150093509250120060045022399.692000022599.69720072.006000060021927.6959000######46500655042001750198909.23300200085151.342401700.002500.004440.00200050130218078531.34总经理：店总：财务审核：制表人：部门办公室收银部汗蒸部序号姓名职务身份证号银行卡号月工资标准全月出勤日实际工作日合计合计

病事假未出勤婚丧违纪罚款迟到/漏打卡社保医保采购部1王文武3000251115.42884.628853003184.620.003184.62人事部2邓云3500251134.63365.433653365.383365.38信息部3胡哲明1000261000.010001000.001000.00信息部4李宁1000261000.010001000.001000.00

门店5王修实2200262200.0263.402463952002568.662568.66门店6黄嘉豪1600261600.0175.601776682001907.311907.31门店7吴双双1600261600.0175.6017762001975.601975.60门店8余娟1600206409.81190.2175.6013661365.831365.83门店9舒清清16005211434.1165.9175.60341341.46341.46门店10周宬婧16006201365.9234.2175.60410409.75409.75门店11於意16006201365.9234.2175.60410409.75409.75

合计203004825.615474.41317.00167910.016390017528.360.0017528.36应税工资个人所得税实发工资备注

人

2017年 07 月员工工资表2017年 06 月员工工资表

部门序号姓名薪资标准考核天数缺勤天数扣款金额出勤工资销售提成应发工资其他扣款其他工资

制表： 审核：病事假未出勤婚丧违纪罚款迟到/漏打卡社保医保采购部1王文武3000263000.003000.00300.003300.003300.00采购部2叶超12001251050.00150.00150.00150.00150.00人事部3邓云3500263500.003500.003500.003500.00信息部4胡哲明1000261000.001000.001000.001000.00财务部5李宁1000261000.001000.001000.001000.00门店6王修实220026472.261727.74255.801983.5418.422001.962001.96门店7黄嘉豪180026122.311677.69170.501848.1912.281860.471860.47门店8吴双双1600188558.541041.46170.501211.9612.281224.241224.24门店9杨苏16001313912.67687.33213.10900.4312.28912.71912.71门店10周颖16001214959.95640.05170.50810.5512.28822.83822.83门店11周宬婧160026408.581191.42170.501361.9212.281374.201374.20门店12於意16002630.001570.00170.501740.5012.281752.781752.78门店13郑思源16001313891.38708.62170.50879.1212.28891.40891.40合计233005405.717894.31491.9019386.21404.3819790.5919790.59其他扣款其他工资应税工资个人所得税部门序号姓名薪资标准考核天数缺勤天数扣款金额出勤工资销售提成备注

工作时数时薪金额时间单价金额时间单价金额时间单价金额1郑一建车间主任400016823.03862823.0184434.513824692110438610442822陈云妹工人16701689.6161289.676.8414.457.6219.238.4111189610517913徐爱兰工人8001684.677284.636.846.927.629.218.41129671068614赵欢亮工人16701689.6161289.676.8414.457.6219.238.4113189810717915徐东菊工人16701689.6161289.676.8414.457.6219.238.4114189910817916项金山工人16701689.6161289.676.8414.457.6219.238.4115190010917917林爱兰工人16701689.6161289.676.8414.457.6219.238.4116190111017918徐永芳工人16701689.6161289.676.8414.457.6219.238.4117190211117919成海亚工人16701689.6161289.676.8414.457.6219.238.41181903112179110杨爱丹工人16701689.6161289.676.8414.457.6219.238.41191904113179111顾林伟工人16701689.6161289.676.8414.457.6219.238.41201905114179112龚爱芬工人16701689.6161289.676.8414.457.6219.238.41211906115179113林海珍工人16701689.6161289.676.8414.457.6219.238.41221907116179114王仙斌工人16701689.6161289.676.8414.457.6219.238.41231908117179115张苏琴工人16701689.6161289.676.8414.457.6219.238.41241909118179116王雪兰工人16701689.6161289.676.8414.457.6219.238.412519101191791超时加班工资休息加班工资实发工资签名/日期高温补贴补足最低工资工资总额扣除养老保险工资表单位名称： 2010 年 9月序号姓名岗位基本工资计时工资节假日/ 休假17李树仙工人16701689.6161289.676.8414.457.6219.238.41261911120179118张发明工人16701689.6161289.676.8414.457.6219.238.41271912121179119戴慧明工人16701689.6161289.676.8414.457.6219.238.41281913122179120徐由其工人16701689.6161289.676.8414.457.6219.238.41291914123179121泮保卫工人16701689.6161289.676.8414.457.6219.238.41301915124179122徐成章工人8001684.677284.636.846.927.629.218.413198612586123沈伟工人8001684.677284.636.846.927.629.218.413298712686124吴秋英工人8001684.677284.636.846.927.629.218.413398812786125牛文瑞工人8001684.677284.636.846.927.629.218.413498912886126应杏娟工人8001684.677284.636.846.927.629.218.413599012986127林美丽工人16701689.6161289.676.8414.457.6219.238.41361921130179128陈月琴工人367016821.13543821.1169431.6127242.284.41374060131392929张爱平工人8001684.677284.636.846.927.629.218.413899313286130王丽华工人16701689.6161289.676.8414.457.6219.238.41391924133179131陈爱明工人16701689.6161289.676.8414.457.6219.238.41401925134179132徐秀利工人16701689.6161289.676.8414.457.6219.238.41411926135179133沈天云工人16701689.6161289.676.8414.457.6219.238.41421927136179134应水连工人8001684.677284.636.846.927.629.218.414399813786135周志明工人16701689.6161289.676.8414.457.6219.238.41441929138179136朱金水工人16701689.6161289.676.8414.457.6219.238.41451930139179137顾江成工人16701689.6161289.676.8414.457.6219.238.41461931140179138陈冬火工人16701689.6161289.676.8414.457.6219.238.41471932141179139张美香工人245016814.12366814.1113421.184.5228.256.31482767142262540林美芬工人16701689.6161289.676.8414.457.6219.238.41491934143179141刘建峰工人16701689.6161289.676.8414.457.6219.238.41501935144179142陈西叶工人245016814.12366814.1113421.184.5228.256.31512770145262543张国霞工人8701685.084085.04047.53021020152108214693644赵欢新工人16701689.6161289.676.8414.457.6219.238.41531938147179145徐承河工人16701689.6161289.676.8414.457.6219.238.41541939148179146王何连工人16701689.6161289.676.8414.457.6219.238.41551940149179147杨明祥工人16701689.6161289.676.8414.457.6219.238.41561941150179148张秀莲工人16701689.6161289.676.8414.457.6219.238.41571942151179149李军工人16701689.6161289.676.8414.457.6219.238.41581943152179150张年明工人245016814.12366814.1113421.184.5228.256.31592778153262551沈伟兵工人16701689.6161289.676.8414.457.6219.238.41601945154179152陈慧婷工人16701689.6161289.676.8414.457.6219.238.41611946155179153王金娥工人16701689.6161289.676.8414.457.6219.238.41621947156179154徐宝仙工人16701689.6161289.676.8414.457.6219.238.41631948157179155王卫平工人16701689.6161289.676.8414.457.6219.238.41641949158179156陈金星工人16701689.6161289.676.8414.457.6219.238.41651950159179157周敏志工人245016814.12366814.1113421.184.5228.256.31662785160262558曹凤侠工人16701689.6161289.676.8414.457.6219.238.41671952161179159张立忠工人16701689.6161289.676.8414.457.6219.238.41681953162179160王先弟工人16701689.6161289.676.8414.457.6219.238.41691954163179161吴顺梅工人16701689.6161289.676.8414.457.6219.238.41701955164179162王通海工人245016814.12366814.1113421.184.5228.256.31712790165262563赵德职工人16701689.6161289.676.8414.457.6219.238.41721957166179164龚建军工人245016814.12366814.1113421.184.5228.256.31732792167262565杨小刚工人16701689.6161289.676.8414.457.6219.238.41741959168179110980010920631.03106014520631.035048.3260946.553786.21301262.12524.1923001266028830.9117772制表人：总计主管审核：

序号姓名基础工资平时加班工时（小时）平时加班加班费假日加班工时(小时)假日加班加班费请假工时(小时)请假扣除 迟到/早退扣除违规扣除岗位补贴其它补贴社保扣除其它扣除工资个人所得税实发工资1asd 1,100.00 20.00 189.66 16.00 202.30 8.00 50.57 2,500.00 100.00 128.00 3,913.3812.43900.979312fgh 1,100.00 10.00 94.83 4.00 50.57 - - 2,500.00 100.00 128.00 3,717.406.523710.8822993hjk 1,100.00 15.00 142.24 4.00 50.57 - - 5,000.00 100.00 128.00 6,264.82171.486093.3360924qwe 1,100.00 2.00 18.97 4.00 50.57 4.00 25.29 2,500.00 100.00 128.00 3,616.253.493612.7628745rty 1,100.00 6.00 56.90 4.00 50.57 - - 2,500.00 100.00 128.00 3,679.475.383674.0912646yui 1,100.00 - - - - - 2,500.00 100.00 128.00 3,572.002.163569.847zsd 1,200.00 8.00 82.76 2.00 27.59 - - 2,500.00 100.00 128.00 3,782.3403782.3448288xcv 1,200.00 12.00 124.14 2.00 27.59 - - 2,500.00 100.00 128.00 3,823.7203823.7241389gvb 1,200.00 11.00 113.79 2.00 27.59 - - 2,500.00 100.00 128.00 3,813.3803813.3793110hre 1,200.00 10.00 103.45 2.00 27.59 3.00 20.69 500.00 100.00 128.00 1,782.3401782.34482811wbd 1,200.00 10.00 103.45 2.00 27.59 - - 2,500.00 100.00 128.00 3,803.0303803.03448312poj 1,200.00 9.00 93.10 2.00 27.59 - - 2,500.00 100.00 128.00 3,792.6903792.68965513kjy 1,200.00 - - - - - - 2,500.00 100.00 128.00 3,672.000367214jmm 2,000.00 - - - - - - 2,500.00 100.00 128.00 4,472.000447215yyt 2,000.00 - - - - - - 300.00 100.00 128.00 2,272.000227216gjk 2,000.00 - - - - 16.00 183.91 250.00 100.00 128.00 2,038.0902038.09195417eyn 2,000.00 - - - - - - 1,500.00 100.00 128.00 3,472.000347218bgf 3,500.00 8.00 241.38 3.00 120.69 - - 2,000.00 100.00 128.00 5,834.0725.025809.04896619yoi 3,500.00 6.00 181.03 1.00 40.23 - - 2,500.00 100.00 128.00 6,193.2635.86157.46436820azz 3,500.00 5.00 150.86 5.00 201.15 - - 2,500.00 100.00 128.00 6,324.0139.726284.291494合 计 33,500.00 132.00 1,696.55 53.00 932.18 31.00 280.46 - - 44,550.00 2,000.00 2,560.00 - - - 79,838.28 301.97 79,536.31