人事核算工资表模板(带公式).xlsx
- 文档编号:126258
- 上传时间:2022-10-04
- 格式:XLSX
- 页数:1
- 大小:19.90KB
人事核算工资表模板(带公式).xlsx
《人事核算工资表模板(带公式).xlsx》由会员分享,可在线阅读,更多相关《人事核算工资表模板(带公式).xlsx(1页珍藏版)》请在冰豆网上搜索。
自动化工资统计发放表编编号号姓姓名名部部门门职职系系应应发发金金额额应应扣扣金金额额实实发发工工资资(元元)基基本本工工资资绩绩效效工工资资应应发发合合计计(元元)代代缴缴费费用用请请假假栏栏迟迟到到栏栏其其它它扣扣款款(元元)应应扣扣合合计计(元元)岗岗位位工工资资餐餐补补车车贴贴通通讯讯补补贴贴地地区区差差异异补补贴贴合合计计(元元)绩绩效效标标准准(元元)管管理理绩绩效效比比例例管管理理绩绩效效考考评评经经营营绩绩效效比比例例经经营营绩绩效效考考评评合合计计(元元)社社保保(元元)住住房房公公积积金金(元元)个个税税(元元)天天数数(天天)扣扣款款(元元)迟迟到到(次次)扣扣款款(元元)%11李芳1测试部产品部120002004006012012780.00200050%80%50%80%160014380.00200.00200.00728260055002228.0012152.0022李芳2测试部产品部130003004006012013880.00200050%80%50%80%160015480.00200.00200.00838360055002338.0013142.0033李芳3测试部产品部140004004006012014980.00200050%80%50%80%160016580.00200.00200.00948460055002448.0014132.0044李芳4测试部产品部150005004006012016080.00200050%80%50%80%160017680.00200.00200.001126560055002626.0015054.0055李芳5测试部产品部160006004006012017180.00200050%80%50%80%160018780.00200.00200.001346660055002846.0015934.0066李芳6测试部产品部170007004006012018280.00200050%80%50%80%160019880.00200.00200.001566760055003066.0016814.0077李芳7测试部产品部180008004006012019380.00200050%80%50%80%160020980.00200.00200.001786860055003286.0017694.0088李芳8测试部产品部190009004006012020480.00200050%80%50%80%160022080.00200.00200.002006960055003506.0018574.0099李芳9测试部产品部2000010004006012021580.00200050%80%50%80%160023180.00200.00200.0022261060055003726.0019454.001010李芳10测试部产品部2100011004006012022680.00200050%80%50%80%160024280.00200.00200.0024461160055003946.0020334.001111李芳11测试部产品部2200012004006012023780.00200050%80%50%80%160025380.00200.00200.0026661260055004166.0021214.001212李芳12测试部产品部2300013004006012024880.00200050%80%50%80%160026480.00200.00200.0028861360055004386.0022094.001313李芳13测试部产品部2400014004006012025980.00200050%80%50%80%160027580.00200.00200.0031061460055004606.0022974.001414李芳14测试部产品部2500015004006012027080.00200050%80%50%80%160028680.00200.00200.0033261560055004826.0023854.001515李芳15测试部产品部2600016004006012028180.00200050%80%50%80%160029780.00200.00200.0035461660055005046.0024734.001616李芳16测试部产品部2700017004006012029280.00200050%80%50%80%160030880.00200.00200.0038101760055005310.0025570.001717李芳17测试部产品部2800018004006012030380.00200050%80%50%80%160031980.00200.00200.0040851860055005585.0026395.001818李芳18测试部产品部2900019004006012031480.00200050%80%50%80%160033080.00200.00200.0043601960055005860.0027220.001919李芳19测试部产品部3000020004006012032580.00200050%80%50%80%160034180.00200.00200.0046352060055006135.0028045.002020李芳20测试部产品部3100021004006012033680.00200050%80%50%80%160035280.00200.00200.0049102160055006410.0028870.002121李芳21测试部产品部3200022004006012034780.00200050%80%50%80%160036380.00200.00200.0051852260055006685.0029695.002222李芳22测试部产品部3300023004006012035880.00200050%80%50%80%160037480.00200.00200.0054602360055006960.0030520.002323李芳23测试部产品部3400024004006012036980.00200050%80%50%80%160038580.00200.00200.0057352460055007235.0031345.002424李芳24测试部产品部3500025004006012038080.00200050%80%50%80%160039680.00200.00200.0060102560055007510.0032170.002525李芳25测试部产品部3600026004006012039180.00200050%80%50%80%160040780.00200.00200.0063242660055007824.0032956.002626李芳26测试部产品部3700027004006012040280.00200050%80%50%80%160041880.00200.00200.0066542760055008154.0033726.002727李芳27测试部产品部3800028004006012041380.00200050%80%50%80%160042980.00200.00200.0069842860055008484.0034496.002828李芳28测试部产品部3900029004006012042480.00200050%80%50%80%160044080.00200.00200.0073142960055008814.0035266.002929李芳29测试部产品部4000030004006012043580.00200050%80%50%80%160045180.00200.00200.0076443060055009144.0036036.003030李芳30测试部产品部4100031004006012044680.00200050%80%50%80%160046280.00200.00200.0079743160055009474.0036806.003131李芳31测试部产品部4200032004006012045780.00200050%80%50%80%160047380.00200.00200.0083043260055009804.0037576.003232李芳32测试部产品部4300033004006012046880.00200050%80%50%80%160048480.00200.00200.00863433600550010134.0038346.00合合计计880000.0056000.0012800.001920.003840.00954560.0064000.0016.0025.6016.0025.6051200.001005760.006400.006400.00134568.000.0019200.00160.0016000.000.00182568.00823192.00批批准准:
出出纳纳:
制制表表:
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 人事 核算 工资表 模板 公式