employee attendance and salary sheet
TRANSCRIPT
KRISHSCRIBE IDENTITY CARD LIST
Sl # NAME DOB BLD GRP MOBILE DESIGNATION
1 Afsha Sangoli 11-Sep-1988 B+ 9743458948 Medical Transcriptionist
2 Amitkumar Dey 10-May-1980 B+ Medical Transcriptionist
3 Ashwin A. Vaz 10-Apr-1975 O+ 0831-2432614 Medical Transcriptionist
4 Dinesh L. Gaikwad 11-Jul-1973 AB+ 9972889427 Medical Transcriptionist
5 Fareed M Shaikh 20-May-1979 B+ 9986241033 Medical Transcriptionist
6 Farida Torgal 05-Sep-1989 O+ 9741261882 Medical Transcriptionist
7 Hasan M. Peerzade 10-Oct-1989 9008943875 Medical Transcriptionist
8 Manisha Kadam 14-Apr-1985 A+ 9343553161 Medical Transcriptionist
9 Poonam B. Pawar 14-Aug-1984 A+ 9900695590 Medical Transcriptionist
10 Prasanna V. Velangi 21-Oct-1989 B+ 0831-24379966 Medical Transcriptionist
11 Prashant M. Chachadi 28-Sep-1983 9972316217 Medical Transcriptionist
12 Prashant Narayanan 27-Sep-1979 O+ 9945687826 Medical Transcriptionist
13 Priya P. Sayanak 22-Aug-1984 9241076759 Medical Transcriptionist
14 Rahul Samrat 07-Jan-1982 A+ 9731868265 Medical Transcriptionist
15 Raju R. Mokashi 13-Mar-1985 O+ 9449625425 Medical Transcriptionist
16 Sheetal B. Huvekar 14-Oct-1985 9980387490 Medical Transcriptionist
17 Varun D. Karkhanis 13-May-1988 A+ 9886504549 Medical Transcriptionist
18 Vishal Desai 24-May-1987 9343868632 Medical Transcriptionist
1 Akshata . Bapat 16-sep-1978 B+ 9916885127 Editor
2 Keti S. Khanolkar 19-June-1985 B+ 9964134247 Editor
3 Vasanti S. Desai 08-Dec-1984 O+ 9343868632 Editor
4 Shubhangi Badave 21-Jan-1979 AB+ 9844495760 Jr. MLS
5 Kajal Tendulkar 03-Jan-1987 A+ 9844756561 Jr. MLS
6 Chetan Deshpande 10-Aug-1984 B+ 9980228200 System Administrator
7 Dhananjay B. Bogar 22-Oct-1978 O+ 9379512823 Receptionist
8 Bouy Singh 01-Mar-1978 B+ 9880495112 CEO
Sl No Designation Emp code Name Skill level1 MT M001 Gautam.Shinde 32 MT M002 Kajal.Tendulkar 13 MT M003 Meera Mutalik.Desai 14 MT M004 Prashant Khanolkar 15 MT M005 Savita Shedshale 16 MT M006 Shubhangi.Badave 17 MT M007 Swapnil.Gaikwad 289 E001 Editors Akashata.Bapat 3
10 E002 Editors Keti.S.Khanolkar 311 E003 Editors Vasanti.S.Desai 312
SA001 SYS Admin Chetan deshpande 2
QA001 QA Bouy Singh
RE001 Reception Dhananjay Bogar
HR01 HR Arun.A.Jadhav
salary Basic DA Allo Gross Epoy- PF Empy- ESI8000 3250 3050 3700 10000 756 475
2600 520 3415 6535 374.4 3102600 520 3750 6870 374.4 3262600 520 3750 6870 374.4 3262600 520 2700 5820 374.4 276
3000 2600 520 3415 6535 374.4 3107500 2600 520 975 4095 374.4 195
2600 520 6450 9570 374.49600 3250 650 6500 10400 4689600 3250 650 3300 7200 468 3429600 3250 650 6450 10350 468
3500 2600
1462.5 3050
1000
11000 9600
325000
ATTTENDANCE REGISTER FOR THE MONTH OF MARCH 2009
=SUM(D6,G6:L6,N6:S6,U6:Z6,AB6:AG6,AI6:AJ6)+4S M T' W T' F S S M T' W T' F S
Sl # Emp. Code Designation NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14
1 MT Geeta Kaddi 1 1 1 1 1 1 1 1 1 1 A 1
2 MT Pramod A. patil 1 A 1 1 1 1 1 1 A A A A
3 MT Rahul kolekar 1 1 1 1 A A A A A A A A
4 MT Rucha.R.Kolekar 1 1 1 1 A A A A A A A A
5 MT Shubhangi.Badave 1 1 1 1 1 1 A 1 1 A 1 1
6
7 Editors Akashata.Bapat 1 1 1 1 1 1 1 1 1 1 1 1
8 Editors Keti.S.Khanolkar 1 1 1 1 1 1 1 1 1 1 1 1
9 Editors Vasanti.S.Desai 1 1 1 1 1 1 1 1 1 1 1 1
10
11 SYS Admin Chetan deshpande 1 1 1 1 1 1 1 1 1 1 1 1
12
13 QA Bouy Singh 1 1 1 1 1 1 A 1 1 1 1 1
14
15 Reception Dhananjay Bogar 1 1 1 1 1 1 1 1 1 1 1 1
16
17
18
19
ATTTENDANCE REGISTER FOR THE MONTH OF MARCH 2009
S M T' W T' F S S M T' W T' F S S M T'
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Sty Signature
A A A A A A A A A A A A A A 15
1 1 1 A A A A A A A A A A A 14
A A A A A A A A A A A A A A 8
A A A A A A A A A A A A A A 8
1 1 1 A 1 1 A 1 1 1 1 1 1 1 26
A 1 A 1 1 1 1 1 1 1 1 1 1 1 28
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
4
1 1 1 1 1 1 1 1 1 1 1 1 1 1 29
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
Sl # Emp. Code Designation NAME Total Sty Signature
1 M002 MT Kajal.Tendulkar 4
2 M003 MT Shubhangi.Badave 28
4
4 E001 Editors Akashata.Bapat 30
5 E002 Editors Keti.S.Khanolkar 29
6 E003 Editors Vasanti.S.Desai 30
11 SA001 SYS Admin Chetan deshpande 30
4
13 QA001 QA Bouy Singh 30
4
15 RE001 Reception Dhananjay Bogar 28
Basic DA Allo Gross Epoy- PF Empy- ESI Canteen HRI CTC
2600 1000 3415 7015 432 333.2125 350 8130.213
2600 1000 3415 7015 432 333.2125 350 8130.213
2600 1000 3750 7350 432 349.125 350 8481.125
2600 1000 3750 7350 432 349.125 350 8481.125
2600 1000 2700 6300 432 299.25 350 7381.25
2600 1000 3415 7015 432 333.2125 350 8130.213
2600 1000 975 4575 432 217.3125 350 5574.313
2600 1000 6450 10050 432 350 10832
3250 1250 6500 11000 540 350 500 11890
2600 1000 3300 6900 432 327.75 350 8009.75
2600 1000 6450 10050 432 350 10832
3500 1500 7300 12300 600 350 500 13250
8130.213 7779 351.2125
8130.213 7779 351.2125
8481.125 8129 352.125
8481.125 8129 352.125
7381.25 7025 356.25
8130.213 7779 351.2125
5574.313 5025 549.3125
10832 10379 453
12390
8009.75
10832 10379 453
13750
ATTENDENCE REGISTER FOR THE MONTH OF MAY 20009
F S S M T' W T' F S S M T' W
Sl # Emp. Code Designation NAME 1 2 3 4 5 6 7 8 9 10 11 12 13
1 M002 MT Kajal.Tendulkar 1 1 1 1 1 1 1 1 1 1 1
2 M003 MT Shubhangi.Badave A A A A 1 1 1 1 1 1 1
3 M004 MT Sidhrayappa.G.Mailari 1 1 A 1 1 1 1 1 A A 1
4
5
6
7 E001 Editors Akashata.Bapat 1 1 1 1 1 A A A A A 1
8 E002 Editors Keti.S.Khanolkar 1 1 1 1 1 1 1 1 1 1 1
9 E003 Editors Vasanti.S.Desai 1 1 1 1 1 1 1 1 A 1 1
10
11 SA001 SYS Admin Chetan deshpande 1 1 1 1 1 1 1 1 1 1 1
12
13 QA001 QA Bouy Singh 1 1 1 1 1 1 1 1 1 1 1
14
15 RE001 Reception Dhananjay Bogar 1 1 1 1 1 1 1 1 1 1 1
16
17
18
19
ATTENDENCE REGISTER FOR THE MONTH OF MAY 20009
T' F S S M T' W T' F S S M T' W T F S S
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Sty Signature
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 26
1 1 1 A 1 A A A A A A A A A A 16
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 25
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 29
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
ATTENDENCE REGISTER FOR THE MONTH OF JUNE 2009
M T' W T' F S S M T' W T' F S
Sl # Emp. Code Designation NAME 1 2 3 4 5 6 7 8 9 10 11 12 13
1 M001 MT Gautam.Shinde 1 1 1 1 1 A A 1 1 1 1 1
2 M002 MT Kajal.Tendulkar 1 1 1 1 1 1 1 1 1 1 1 1
3 M003 MT Shubhangi.Badave 1 1 1 1 1 1 1 1 1 1 1 1
4 M004 MT Prashant Khanolkar 1 1 1 1 1 1 1 1 1 1 1 1
5
6
7 E001 Editors Akashata.Bapat 1 1 1 1 1 1 1 1 1 1 1 1
8 E002 Editors Keti.S.Khanolkar 1 1 1 1 1 1 A A A A 1 1
9 E003 Editors Vasanti.S.Desai 1 1 1 1 1 1 1 1 1 1 1 1
10
11 SA001 SYS Admin Chetan deshpande A 1 A 1 A A A A 1 1 1 1
12
13 SA001 QA Bouy Singh 1 1 1 1 1 1 1 1 1 1 1 1
14
15 RE001 Reception Dhananjay Bogar 1 1 1 1 1 1 1 1 1 1 1 1
16
17
18
19
ATTENDENCE REGISTER FOR THE MONTH OF JUNE 2009
S M T' W T' F S S M T' W T F S S M T
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Total Sty Signature
1 1 A 1 1 1 1 1 1 1 1 1 1 1 27
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 A 1 A 1 1 1 1 1 1 1 1 1 1 28
1 1 1 1 1 1 1 1 1 1 1 1 1 1 26
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 24
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
1 1 1 1 1 1 1 1 1 1 1 1 1 1 30
ATTENDENCE REGISTER FOR THE MONTH OF JULY 2009
W T' F S S M T' W T' F S S M T'
Sl # Emp. Code Designation NAME 1 2 3 4 5 6 7 8 9 10 11 12 13 14
1 M001 MT Gautam.Shinde 1 1 1 1 1 1 1 1 1 1 A 1
2 M002 MT Kajal.Tendulkar 1 1 1 1 1 1 1 1 1 1 1 1
3 M003 MT Meera Mutalik.Desai 1 1 1 1 1 1 1 1 1 1 1 1
4 M004 MT Prashant Khanolkar 1 1 1 1 1 1 1 1 1 1 1 1
5 M005 MT Savita Shedshale 1 1 1 1 1 1 1 1 1 1 1 1
6 M006 MT Shubhangi.Badave 1 1 1 1 1 A A A 1 1 1 1
7 M007 MT Swapnil.Gaikwad 1 1 1 1 1 1 1 1 1 1 A A
8
9 E001 Editors Akashata.Bapat A A A A A A A A A A 1 1
10 E002 Editors Keti.S.Khanolkar A 1 1 1 1 1 1 1 1 1 1 1
11 E003 Editors Vasanti.S.Desai 1 1 1 1 1 1 1 1 1 1 1 1
14
15 SA001 SYS Admin Chetan deshpande 1 1 1 1 1 1 1 1 1 1 1 1
16
17 QA001 QA Bouy Singh 1 1 1 1 1 1 1 1 1 1 1 1
18
19 RE001 Reception Dhananjay Bogar A 1 1 1 1 A A 1 1 1 1 1
21 HR01 HR Arun.A.Jadhav
ATTENDENCE REGISTER FOR THE MONTH OF JULY 2009
W T' F S S M T' W T F S S M T W T F
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Sty Signature
1 15
1 16
1 16
1 16
1 16
A 12
A 13
A
1 15
1 16
1 16
1 16
1 13
3
1 1 5
Salary for the month july Days 31
Days Basic DA Allo Gross PF ESI TDS
30 3250 1475.81 1790.32 6516.13 567.10 56.88
30 2600 268.39 3415.00 6535.00 344.21
2600 268.39 3750.00 6870.00 344.21
2600 268.39 3750.00 6870.00 344.21
2600 268.39 2700.00 5820.00 344.21
2600 201.29 3415.00 6535.00 336.15
2600 218.06 975.00 4095.00 338.17
2600 0.00 6450.00 9570.00 312.00
Total 2930.245 56.875 0
Net
5892.16
6190.79
6525.79
6525.79
5475.79
6198.85
3756.83
9258.00
49824.01
Sl # NAME ACC AWPM
1 Aditi S. Pawar
2 Afsha Sangoli
3 Amitkumar Dey
4 Ashwin A. Vaz
5 Dinesh L. Gaikwad
6 Fareed M Shaikh
7 Farida Torgal
8 Hasan M. Peerzade
9 Manisha Kadam
10 Poonam B. Pawar
11 Prasanna V. Velangi
12 Prashant M. Chachadi
13 Prashant Narayanan
14 Priya P. Sayanak
15 Rahul Samrat
16 Rajeshwari N. Kesarkar
17 Raju R. Mokashi
18 Sheetal B. Huvekar
19 Varun D. Karkhanis