員工考勤表模板

員工考勤表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

"序

號(hào)","部門(mén)

編號(hào)",基本資料,,,,,,出勤數(shù)據(jù)（單位：天）,,,,,,,,,,,,加班時(shí)數(shù),,,考核,補(bǔ)給項(xiàng)(元),,,,扣除項(xiàng)(元),,,,,備注

,,"薪資

類型",工號(hào),姓名,部門(mén),職位,入職日期,"應(yīng)

出勤

天數(shù)","無(wú)

薪","事

假","病

假","工

傷","公

假","年

假","婚

假","產(chǎn)

假","喪

假","曠

工","實(shí)際

出勤

天數(shù)","平時(shí)

加班

時(shí)數(shù)","周末

加班

時(shí)數(shù)","法定

加班

時(shí)數(shù)","考核

系數(shù)","住房

補(bǔ)貼","夜班

補(bǔ)貼","高溫

補(bǔ)貼","其它

補(bǔ)給","應(yīng)扣

社保費(fèi)","應(yīng)扣

公積金","個(gè)稅專項(xiàng)

附加扣除額","應(yīng)扣

水電費(fèi)","其它

扣除",

1,A001,月薪,0001,員工1,行政部,經(jīng)理,2024/01/01,,,,,1,2,3,4,,,1,-11,,32,8,100.00%,400,,,,301.07,100,,3,10,

2,A002,月薪,0002,員工2,行政部,廚師,2024/01/02,,,,,,,,,,,,0,,32,,100.00%,200,,,,301.07,250,1600,,,

3,A003,提成,0003,員工3,業(yè)務(wù)部,經(jīng)理,2024/01/03,,,,,,,,,,,,0,10,32,,100.00%,100,,,,301.07,505,4000,,,

4,A004,計(jì)時(shí),0004,員工4,品質(zhì)部,品檢員,2024/01/04,,,,,,,,,,,,0,40,32,,100.00%,,200,,,301.07,146,,5,,

5,A005,月薪,0005,員工5,工程部,經(jīng)理,2024/01/05,,,,,,,,,,,,0,,32,,100.00%,500,,,,301.07,600,2000,,,

6,A006,月薪,0006,員工6,資材部,倉(cāng)庫(kù)組長(zhǎng),2024/01/06,,,,,,,,,,,,0,10,32,5,100.00%,,,,,301.07,250,2000,,,

7,A007,計(jì)時(shí),0007,員工7,品質(zhì)部,品檢員,2024/01/07,,,1,,,,,,,,,-1,40,32,,100.00%,,200,,,301.07,146,,10,,

8,A008,月薪,0008,員工8,工程部,工程師,2024/01/08,,,,,,,,,,,,0,,32,,100.00%,,,,,301.07,500,2000,,,

9,A009,計(jì)時(shí),0009,員工9,生產(chǎn)部,作業(yè)員,2024/01/09,,,,,,,,,,,,0,40,32,,100.00%,,120,,,301.07,131,,,,

10,A010,月薪,0010,員工10,品質(zhì)部,主管,2024/01/10,,,,,,,,,,,,0,,32,,100.00%,400,,,,301.07,400,1000,,,

11,A011,計(jì)時(shí),0011,員工11,生產(chǎn)部,作業(yè)員,2024/01/11,,,1,,,,,,,,,-1,40,32,,100.00%,,100,,,301.07,131,,,,

12,A012,月薪,0012,員工12,財(cái)務(wù)部,主管,2024/01/12,,,,,,,,,,,,0,,32,,100.00%,400,,,,301.07,400,1000,,,

13,A013,計(jì)時(shí),0013,員工13,生產(chǎn)部,作業(yè)員,2024/01/13,,,1,,,,,,,,,-1,40,32,,100.00%,,200,,,301.07,131,,,,

14,A014,計(jì)時(shí),0014,員工14,品質(zhì)部,品檢員,2024/01/14,,,,,,,,,,,,0,40,32,,100.00%,,200,,,301.07,141,,,,

15,A015,月薪,0015,員工15,品質(zhì)部,經(jīng)理,2024/01/15,,,,,,,,,,,,0,,32,,100.00%,500,,,,301.07,600,3100,,,

16,A016,月薪,0016,員工16,資材部,采購(gòu)員,2024/01/16,,,1,,,,,,,,,-1,,32,,100.00%,,,,,301.07,300,1000,,,

17,A017,提成,0017,員工17,業(yè)務(wù)部,經(jīng)理,2024/01/17,,,,,,,,,,,,0,,32,,100.00%,,,,,301.07,525,2000,,,

18,A018,計(jì)時(shí),0018,員工18,行政部,保安,2024/01/18,,,,,,,,,,,,0,