ATTENDENCE SHEET

START DATE 2/1/2024 LAST DATE 2/29/2024

Thu Fri Sat
EMP ID EMP NAME DESIGNATION DEPARTMENT 2/1/2024 2/2/2024 2/3/2024
EMP-101 SHYAM MANAGER MARKET p p
EMP-102 RAJ ADVISOR SALES p l
EMP-103 RAVI HEAD RECOVERY p p
EMP-104 ANIL ACCOUNTANT SALES p p
EMP-105 VIKRAM MANAGER MARKET p p
EMP-106 AJAY HEAD SALES l p
EMP-107 VIJAY MANAGER RECOVERY p l
EMP-108 ABIR ACCOUNTANT MARKET p a
EMP-109 RAM ACCOUNTANT SALES p a
EMP-110 RAJIV MANAGER MANAGEMENT p a
EMP-111 VIKAS ACCOUNTANT MANAGEMENT p l
EMP-112 NIKHIL ADVISOR MARKET l l
EMP-113 VIKRAM HEAD MARKET l l
EMP-114 ANKUSH ADVISOR MANAGEMENT l p
EMP-115 RICKY ACOUNTANT RECOVERY p p
 MONTH YEAR

E SHEET FEB 2024

Sun Mon Tue Wed Thu Fri Sat Sun

2/4/2024 2/5/2024 2/6/2024 2/7/2024 2/8/2024 2/9/2024 2/10/2024 2/11/2024
p l l a p p p
p l p p p a p
l l p p p p p
p l p p p a p
p l p a p a p
p p p p p a p
p p p a p a p
p p p p a p p
p p p p l p p
p p a a l p p
p p a p a p p
p p a p a p p
p p p p p l p
l p l l p l p
p p l p p p p
Mon Tue Wed Thu Fri Sat Sat Mon
2/12/2024 2/13/2024 2/14/2024 2/15/2024 2/16/2024 2/17/2024 2/18/2024 2/19/2024
p p p a p a p
p a p l a p p
p p p p p p p
p p p p p p p
p l p p p p p
p l l p p l p
a l a a p p p
p p p p p p a
p p p p p p p
l p l p p p p
a p p p a p p
p p a p p p p
p p a p l p p
p p p l p p l
p l p a p p p
Tue Wed Thu Fri Sat Sun Mon Tue
2/20/2024 2/21/2024 2/22/2024 2/23/2024 2/24/2024 2/25/2024 2/26/2024 2/27/2024
p l p a p a p
p p p p p p p
p p p p p p p
p p p p p p p
a p a p p p
a p a p l l a
a p l p p p l
a p l a p p a
p a l a p p a
p a p a p p a
p p p l p p p
p p p l p a p
l p p a p a p
l p p p p p p
l p p p p l l
Wed Thu
No.of present day No.of abesnt day No.of leave day
2/28/2024 2/29/2024
p a p 17 6 3
p p p 20 3 3
p p p 24 0 2
l p p 23 1 2
p p p 19 4 2
l a 13 5 7
a l p 14 7 5
p l p 18 6 2
p l p 19 4 3
p a p 16 7 3
p a p 19 5 2
l p p 18 4 4
l p p 17 3 6
l p p 17 0 9
a p p 19 2 5
No of sundays Total pay days

3 23
3 26
3 29
3 28
3 24
3 23
3 22
3 23
3 25
3 22
3 24
3 25
3 26
3 29
3 27
S.NO EMP ID EMP NAME DEPARTMENT DESIGNATION CTC PF YES/NO EMP PF

1 EMP-101 SHYAM MARKET MANAGER 40000 YES 1002

2 EMP-102 RAJ SALES ADVISOR 32000 YES 1002
3 EMP-103 RAVI RECOVERY HEAD 33000 YES 1002
4 EMP-104 ANIL SALES ACCOUNTANT 21000 NO 0
5 EMP-105 VIKRAM MARKET MANAGER 25000 NO 0
6 EMP-106 AJAY SALES HEAD 28000 YES 1002
7 EMP-107 VIJAY RECOVERY MANAGER 44000 YES 1002
8 EMP-108 ABIR MARKET ACCOUNTANT 32000 YES 1002
9 EMP-109 RAM SALES ACCOUNTANT 30000 NO 0
10 EMP-110 RAJIV MANAGEMENT MANAGER 25000 NO 0
11 EMP-111 VIKAS MANAGEMENT ACCOUNTANT 21000 NO 0
12 EMP-112 NIKHIL MARKET ADVISOR 23000 YES 1002
13 EMP-113 VIKRAM MARKET HEAD 29000 YES 1002
14 EMP-114 ANKUSH MANAGEMENT ADVISOR 46000 YES 1002
15 EMP-115 RICKY RECOVERY ACOUNTANT 55000 NO 0
 SALARY SHEET
EMP ESI GROSS SALARY BASIC HRA TA PAID DAYS BASIC

0 38998 23398.8 15599.2 800 23 18557.67

0 30998 18598.8 12399.2 800 26 16674.79
0 31998 19198.8 12799.2 800 29 18536.77
997.5 20002.5 12001.5 8001 800 28 11587.66
1187.5 23812.5 14287.5 9525 800 24 11824.14
0 26998 16198.8 10799.2 800 23 12847.32
0 42998 25798.8 17199.2 800 22 19571.5
0 30998 18598.8 12399.2 800 23 14750.77
0 30000 18000 12000 800 25 15517.24
1187.5 23812.5 14287.5 9525 800 22 10838.79
99750 -78750 8350 -87100 0 24 6910.345
1092.5 20905.5 12543.3 8362.2 800 25 10813.19
0 27998 16798.8 11199.2 800 26 15060.99
0 44998 26998.8 17999.2 0 29 26998.8
0 55000 33000 22000 0 27 30724.14
Y SHEET
HRA TA TOTAL SALARY EMP PF EMP ESI MOBIL BILL SPECIAL ADVANCE

12371.78 634.482759 39798 1002 0 230

11116.52 717.241379 31798 1002 0 429
12799.2 800 32798 1002 0 100
7725.103 772.413793 20802.5 0 364.04375 170
7882.759 662.068966 24612.5 0 430.71875 370
8564.883 634.482759 27798 1002 0 430
13047.67 606.896552 43798 1002 0 280
9833.848 634.482759 31798 1002 0 300
10344.83 689.655172 30800 0 0 318
7225.862 606.896552 24612.5 0 430.71875 160
-72082.76 0 -78750 0 -1378.125 269
7208.793 689.655172 21705.5 1002 379.84625 360
10040.66 717.241379 28798 1002 0 470
17999.2 0 44998 1002 0 250
20482.76 0 55000 0 0 170
L.W.F DEDUCATION NET SALARY BANK A/C

100 1232 38566 5350053782

100 1531 30267 6865470072
100 1202 31596 8889449374
100 634.04375 20169 5467865435
100 900.71875 23712 5463786438
100 1532 26266 4356784567
100 1382 42416 5246845637
100 1402 30396 7654356467
100 418 30382 9876543213
100 690.71875 23922 7685433246
100 -1009.125 -77741 6543644531
100 1841.84625 19864 8765545685
100 1572 27226 5435357654
100 1352 43646 8765432123
100 270 54730 7654876543
MONTH YEAR
JAN 2024
FEB 2025
MAR 2026
APR 2027
MAY 2028
JUN 2029
JUL 2030
AUG 2031
SEP 2032
OCT 2033
NOV 2034
DEC 2035