工资表简易模板

工资表模板,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

编号,姓名,部门,进厂时间,"标准

工资","工作

天数",正班工作时间,伙食补贴,岗位补助,全勤奖,工资金额,平日加班,,休息日加班,,加班工资合计,补贴,扣社保,应发工资,扣款,,,,"扣款

小计",应付工资总额,员工签名,"备

注",身份证号码,银行账号,手机号

,,,,,,,,,,,工时,工资,工时,工资,,,,,住宿费,工衣,扣个税,扣款,,,,,,,

A0001,李现,办公室,2020/1/2,2230,21.75,174,,,100,2330,20.0,384.48,16.0,410.11,795,600,205,3520,,,0.00,,-,"3,519.60",,管理费用,,,

A0002,王丽,办公室,2020/1/3,2230,21.75,174,200,1000,100,3530,30.0,576.72,20.0,512.64,1089,,205,4414,,,0.00,,-,"4,414.37",,管理费用,,,

A0003,钟敏,车间,2020/1/4,2230,21.75,174,200,800,100,3330,40.0,768.97,30,768.97,1538,,205,4663,,,0.00,,-,"4,662.93",,制造费用,,,

A0004,袁方,车间,2020/1/5,2230,21.75,174,200,600,100,3130,50.0,961.21,40.0,"1,025.29",1986,,205,4911,,,0.00,,-,"4,911.49",,制造费用,,,

A0005,陈铁,车间,2020/1/6,2230,21.75,174,200,500,100,3030,20.0,384.48,50,"1,281.61",1666,,205,4491,,,0.00,,-,"4,491.09",,制造费用,,,

A0006,张虹,办公室,2020/1/7,2230,21.75,174,200,600,100,3130,30.0,576.72,60.0,"1,537.93",2115,,205,5040,,,1.19,,1.19,"5,038.47",,销售费用,,,

A0007,肖玉,办公室,2020/1/8,2230,21.75,174,200,700,100,3230,40.0,768.97,70,"1,794.25",2563,,205,5588,,,17.65,,17.65,"5,570.57",,销售费用,,,

A0008,旷军,办公室,2020/1/9,2230,21.75,174,200,800,100,3330,50.0,961.21,66.0,"1,691.72",2653,,205,5778,,,23.34,,23.34,"5,754.59",,销售费用,,,

A0009,邱利,办公室,2020/1/10,2230,21.75,174,200,900,100,3430,18,346.03,28,717.70,1064,,205,4289,,,0.00,,-,"4,288.74",,销售费用,,,

A0010,苏翡,办公室,2020/1/11,2230,21.75,174,200,1200,100,3730,22,422.93,60.0,"1,537.93",1961,,205,5486,,,14.58,,14.58,"5,471.28",,销售费用,,,

,合计,,,"22,300.00",217.50,"1,740.00","1,800.00","7,100.00","1,000.00","32,200.00",320.00,"6,151.72",440.00,"11,278.16","17,429.89",600.00,"2,050.00","48,179.89",-,-,56.76,-,56.76,"48,123.13",,,,,

,制表人：,,,,审核人：,,,,日期：,,,,,,,,,,,,