工資表簡易模板

工資表模板,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

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

編號,姓名,部門,進廠時間,"標準

工資","工作

天數(shù)",正班工作時間,伙食補貼,崗位補助,全勤獎,工資金額,平日加班,,休息日加班,,加班工資合計,補貼,扣社保,應發(fā)工資,扣款,,,,"扣款

小計",應付工資總額,員工簽名,"備

注",身份證號碼,銀行賬號,手機號

,,,,,,,,,,,工時,工資,工時,工資,,,,,住宿費,工衣,扣個稅,扣款,,,,,,,

A0001,李現(xiàn),辦公室,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",,,,,

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