Nothing Special   »   [go: up one dir, main page]

HR Sample Formats

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 42

1

2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

13-Nov-10

12-Nov-10

11-Nov-10

10-Nov-10

9-Nov-10

8-Nov-10

7-Nov-10

6-Nov-10

5-Nov-10

4-Nov-10

3-Nov-10

2-Nov-10

1-Nov-10

Total leaves

EMPLOYEE NAME EMP # DOJ DEPT

Leave credit

Opng bal

ATTENDANCE FOR THE MONTH OF NOV 201

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
Absent

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Pls enter the emp leave opeining bal in the Opn bal column
Pls enter the monthly leave credit in the leave credit column

0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Full day Leave

Halfday Leave

Total Leave

Leave balance

30-Nov-10

29-Nov-10

28-Nov-10

27-Nov-10

26-Nov-10

25-Nov-10

24-Nov-10

23-Nov-10

22-Nov-10

21-Nov-10

20-Nov-10

19-Nov-10

18-Nov-10

17-Nov-10

16-Nov-10

15-Nov-10

14-Nov-10

HE MONTH OF NOV 2010

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0

Emp Name
Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

16-Nov-10

17-Nov-10 Wed

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

20-Nov-10

Sat

Tue

21-Nov-10 Sun

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

23-Nov-10

24-Nov-10 Wed

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

27-Nov-10

Sat

Tue

28-Nov-10 Sun

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

30-Nov-10

Total

Total

Total

Late

Late

Late

Leave

Leave

Leave

Tue

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

Total

Total

Late

Late

Leave

Leave

In time

Out Time

Emp Name
Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

16-Nov-10

17-Nov-10 Wed

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

20-Nov-10

Sat

Tue

21-Nov-10 Sun

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

23-Nov-10

24-Nov-10 Wed

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

27-Nov-10

Sat

Tue

28-Nov-10 Sun

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

30-Nov-10

Total

Total

Total

Late

Late

Late

Leave

Leave

Leave

Tue

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

Total

Total

Late

Late

Leave

Leave

In time

Out Time

Emp Name
Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

16-Nov-10

17-Nov-10 Wed

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

20-Nov-10

Sat

Tue

21-Nov-10 Sun

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

23-Nov-10

24-Nov-10 Wed

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

27-Nov-10

Sat

Tue

28-Nov-10 Sun

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

30-Nov-10

Total

Total

Total

Late

Late

Late

Leave

Leave

Leave

Tue

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

Total

Total

Late

Late

Leave

Leave

In time

Out Time

Emp Name
Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

16-Nov-10

17-Nov-10 Wed

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

20-Nov-10

Sat

Tue

21-Nov-10 Sun

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

23-Nov-10

24-Nov-10 Wed

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

27-Nov-10

Sat

Tue

28-Nov-10 Sun

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

30-Nov-10

Total

Total

Total

Late

Late

Late

Leave

Leave

Leave

Tue

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

Emp Name
In time

Out Time

Rmks

Emp No
Date
Day

1-Nov-10

Mon

1-Nov-10

2-Nov-10

Tue

2-Nov-10

Mon
Tue

3-Nov-10

Wed

3-Nov-10

Wed

4-Nov-10

Thu

4-Nov-10

Thu

5-Nov-10

Fri

5-Nov-10

Fri

6-Nov-10

Sat

6-Nov-10

Sat

7-Nov-10

Sun

7-Nov-10

Sun

8-Nov-10

Mon

8-Nov-10

Mon

9-Nov-10

Tue

9-Nov-10

Tue

10-Nov-10 Wed

10-Nov-10 Wed

11-Nov-10 Thu

11-Nov-10 Thu

12-Nov-10

Fri

12-Nov-10

Fri

13-Nov-10

Sat

13-Nov-10

Sat

14-Nov-10 Sun

14-Nov-10 Sun

15-Nov-10 Mon

15-Nov-10 Mon

16-Nov-10 Tue

16-Nov-10 Tue

17-Nov-10 Wed

17-Nov-10 Wed

18-Nov-10 Thu

18-Nov-10 Thu

19-Nov-10

Fri

19-Nov-10

Fri

20-Nov-10

Sat

20-Nov-10

Sat

21-Nov-10 Sun

21-Nov-10 Sun

22-Nov-10 Mon

22-Nov-10 Mon

23-Nov-10 Tue

23-Nov-10 Tue

24-Nov-10 Wed

24-Nov-10 Wed

25-Nov-10 Thu

25-Nov-10 Thu

26-Nov-10

Fri

26-Nov-10

Fri

27-Nov-10

Sat

27-Nov-10

Sat

28-Nov-10 Sun

28-Nov-10 Sun

29-Nov-10 Mon

29-Nov-10 Mon

30-Nov-10 Tue

30-Nov-10 Tue

Total

Total

Late

Late

Leave

Leave

In time

Out Time

Rmks

Payroll for month of


S No Emp #

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Employee Name

FIXATION
Department

Basic

HRA

Con

Medi

Spl

3500
5000

1500
2500

800
800

1250
1250

3500
5500

8500

4000

1600

2500

9000

Note:
Please enter the salary breakup details under the fixation
Pls enter the Lop details in the LOP column for calculation the actual salary

Misc ESI Gross

10550
15050
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25600

Direct
Cost

10550
15050
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25600

No of P.D
Lop
Days ays
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
31
620

31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
31.0
620 0.0

ACTUAL
Basic

HRA

Con

Medi

3500
5000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8500

1500
800 1250
2500
800 1250
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4000
1600 2500

Spl

3500
5500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
9000

Emp'r Cost
Misc

Food
Allw

ESI
Gross

Direct
Cost

10550
15050
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25600

10550
15050
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25600

ESI
4.75%

501
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
501

Emp'r Cost
PF
12%

Employee Ded
PF
12%

420 420
600 600
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1020 1020

ESI
1.75%

PT

185 127
0 183
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
185
310

IT

Canteen Other
Ded
Ded

Net
Salary

CTC

9818 11471
14267 15650
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
24085 27121

You might also like