Salary On Attendance

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 23

MAAS INTERNATIO

1-Jan 2-Jan 3-Jan 4-Jan 5-Jan


EMP.CODE NAME POST
MON TUE WED THU FRI
243 VINEET KUMAR MANAGER P P P P P
244 GAVRAV GAUTAM AA.S MAN. P P P P P
245 AVIRAL MISHRA WORKER P P A P P
246 ARPITA NIGAM PEON P A P A P
247 PARUL BAJPAI PEON P P P P A
248 ARPIT SHING WORKER P P P P P
249 PRASANT KUMAR CLERK A P P P P
250 SURAJ KUMAR WORKER P P P P P
251 AKASH GAUTAM CLERK P P A P P
252 VIKASH KUMAR WORKER P P P P P
253 AJAY KUMAR WORKER P P P P P
254 VIJAY KUMAR SUPERVISER A P P P P
255 AMIT KUMAR STAFF P P P P P
256 SUMEET KUMAR WORKER P P P P P
257 REENA RAWAT PEON P P P P P
258 SEEMA RAWAT HELPER P P P P P
259 ANJALI VARMA HELPER P P P P P
260 AMAN SHING WORKER P P P P P
261 ANKIIT KUMAR MANAGER A P P P P
262 DHARMENDRA KUMAR WORKER P P P P P
263 ANIL KUMAR WORKER P P A P P
264 SUNEEL KUMAR MANAGER P P P P P
265 SUMAN RAWAT AA.S MAN. P P P P P
266 SUHANI RAWAT WORKER P P P P P
267 VISHAL RAWAT PEON P A P P P
268 SAURABH RAWAT PEON P P P P P
269 VIPIN VARMA WORKER P P P P P
270 SHIVA RAWAT CLERK P P P P P
271 SIVAM RAWAT WORKER P P P P P
272 KOMAL RAWAT CLERK P P P P P
273 KAJAL RAWAT WORKER P P P P P
274 KULDEEP RAWAT WORKER P P P P P
275 KARAN RAWAT SUPERVISER P P P P P
276 AAJEET RAWAT STAFF A P P P P
277 SUJEET RAWAT WORKER P P A P P
278 MOHIT SHING PEON P P P P P
279 ANKUSH RAJPOOT HELPER P P P P P
280 DEEPAK KUMAR HELPER P P P P P
281 DEEPAK SHING WORKER P P P P P
282 SANY SHING MANAGER P P P P P
283 POOJA RAWAT WORKER P P P P P
284 RAHUL RAWAT WORKER P P P P P
AS INTERNATIONNAL PVT LTD COMPANY EMPLOYEES ATTENDANCE SHEET

6-Jan 7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan 14-Jan 15-Jan
SAT SUN MON TUE WED THU FRI SAT SUN MON
P H P A A P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P A H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P A H P
A H P P P P P P H P
P H A P P P P P H P
P H P A P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P A P P P H P
P H P P P P P P H P
P H P P P P P A H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H A P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P A H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H P P P P P P H P
P H A P P P P P H P
P H P P P P P A H P
E SHEET

16-Jan 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan
TUE WED THU FRI SAT SUN MON TUE WED THU
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P A P P P H P P P P
P P P P P H P A P P
P P P P P H P P P P
A P P P P H P P P P
P P A P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P A P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P A P P
P A P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
A P A P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P A P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
P P P P P H P P P P
ABSE

ABSENCE PRESENCE HOLIDAY

26-Jan 27-Jan 28-Jan 29-Jan 30-Jan 31-Jan


FRI SAT SUN MON TUE WED
P P H P P P 2 25 4
P P H P P P 0 27 4
P P H P P P 1 26 4
P P H P P P 2 25 4
P P H P P P 2 25 4
P P H P P P 0 27 4
P P H P P P 1 26 4
P P H P P P 0 27 4
P P H P P A 2 25 4
P P H P P P 0 27 4
P P H P P P 0 27 4
P P H P P P 3 24 4
P P H P P P 2 25 4
P P H P P P 1 26 4
P P H P P P 2 25 4
P P H P A P 2 25 4
P P H P P P 0 27 4
P P H P P P 0 27 4
P P H A P P 2 25 4
P P H P P P 0 27 4
P P H P P P 2 25 4
P P H P P P 0 27 4
P P H P P P 1 26 4
P P H P P P 0 27 4
P P H P P P 2 25 4
P P H P P P 0 27 4
P P H P P P 0 27 4
P P H P P P 1 26 4
P P H P P P 1 26 4
P P H P P P 1 26 4
P P H P P P 0 27 4
P P H P P P 0 27 4
P P H P P P 3 24 4
P P H P P P 1 26 4
P P H P P A 2 25 4
P P H P P P 1 26 4
P P H P P P 0 27 4
P P H A P P 1 26 4
P P H P P P 0 27 4
P P H P P P 0 27 4
P P H P P P 1 26 4
P P H P P P 1 26 4
TOTAL
BASIC ONE DAY SALARY ON
DAYS PF 12% ESI 2%
SALARY SALARY ATTENDANCE
PAYABLE

29 12000 387 11226 1347 225


31 15000 484 15000 1800 300
30 18000 581 17419 2090 348
29 20000 645 18710 2245 374
29 25000 806 23387 2806 468
31 30000 968 30000 3600 600
30 35000 1129 33871 4065 677
31 10000 323 10000 1200 200
29 20000 645 18710 2245 374
31 12000 387 12000 1440 240
31 15000 484 15000 1800 300
28 18000 581 16258 1951 325
29 20000 645 18710 2245 374
30 25000 806 24194 2903 484
29 30000 968 28065 3368 561
29 35000 1129 32742 3929 655
31 10000 323 10000 1200 200
31 20000 645 20000 2400 400
29 12000 387 11226 1347 225
31 15000 484 15000 1800 300
29 18000 581 16839 2021 337
31 20000 645 20000 2400 400
30 25000 806 24194 2903 484
31 30000 968 30000 3600 600
29 35000 1129 32742 3929 655
31 10000 323 10000 1200 200
31 20000 645 20000 2400 400
30 12000 387 11613 1394 232
30 15000 484 14516 1742 290
30 18000 581 17419 2090 348
31 20000 645 20000 2400 400
31 25000 806 25000 3000 500
28 30000 968 27097 3252 542
30 35000 1129 33871 4065 677
29 10000 323 9355 1123 187
30 20000 645 19355 2323 387
31 12000 387 12000 1440 240
30 15000 484 14516 1742 290
31 18000 581 18000 2160 360
31 20000 645 20000 2400 400
30 25000 806 24194 2903 484
30 30000 968 29032 3484 581
PAY HAND SALARY

9654
12900
14981
16090
20113
25800
29129
8600
16090
10320
12900
13982
16090
20806
24135
28158
8600
17200
9654
12900
14481
17200
20806
25800
28158
8600
17200
9987
12484
14981
17200
21500
23303
29129
8045
16645
10320
12484
15480
17200
20806
24968
NAME EMP.CODEPOST SALARY (empty)
AJAY KUMAR
253
WORKER
9000
AKASH GAUTAM
251
CLERK
10000
AMAN SHING
260
WORKER
6000
AMIT KUMAR
255
STAFF
8000
ANIL KUMAR
263
WORKER
6000
ANJALI VARMA
259
HELPER
5000
ANKIIT KUMAR
261
MANAGER
10000
ARPIT SHING
248
WORKER
10000
ARPITA NIGAM
246
PEON
5000
AVIRAL MISHRA
245
WORKER
3000
DHARMENDRA KUMAR
262
WORKER
11000
GAVRAV GAUTAM
244
AA.S MAN.
21000
KOMAL RAWAT
272
CLERK
8000
PARUL BAJPAI
247
PEON
6000
PRASANT KUMAR
249
CLERK
11000
REENA RAWAT
257
PEON
21000
SAURABH RAWAT
268
PEON
8000
SEEMA RAWAT
258
HELPER
3000
SHIVA RAWAT
270
CLERK
9000
SIVAM RAWAT
271
WORKER
14000
SUHANI RAWAT
266
WORKER
9000
SUMAN RAWAT
265
AA.S MAN.
8000
SUMEET KUMAR
256
WORKER
5000
SUNEEL KUMAR
264
MANAGER
10000
SURAJ KUMAR
250
WORKER
6000
VIJAY KUMAR
254
SUPERVISER
14000
VIKASH KUMAR
252
WORKER
8000
VINEET KUMAR
243
MANAGER
5000
VIPIN VARMA
269
WORKER
8000
VISHAL RAWAT
267
PEON
14000
(empty)
(empty)
(empty)
(empty)
Total Result
S Column2 Column3 Column4
EMP.CODE NAME POST SALARY

243 VINEET KUMAR MANAGER 5000


244 GAVRAV GAUTAM AA.S MAN. 21000
245 AVIRAL MISHRA WORKER 3000
246 ARPITA NIGAM PEON 5000
247 PARUL BAJPAI PEON 6000
248 ARPIT SHING WORKER 10000
249 PRASANT KUMAR CLERK 11000
250 SURAJ KUMAR WORKER 6000
251 AKASH GAUTAM CLERK 10000
252 VIKASH KUMAR WORKER 8000
253 AJAY KUMAR WORKER 9000
254 VIJAY KUMAR SUPERVISER 14000
255 AMIT KUMAR STAFF 8000
256 SUMEET KUMAR WORKER 5000
257 REENA RAWAT PEON 21000
258 SEEMA RAWAT HELPER 3000
259 ANJALI VARMA HELPER 5000
260 AMAN SHING WORKER 6000
261 ANKIIT KUMAR MANAGER 10000
262 DHARMENDRA KUMAR WORKER 11000
263 ANIL KUMAR WORKER 6000
264 SUNEEL KUMAR MANAGER 10000
265 SUMAN RAWAT AA.S MAN. 8000
266 SUHANI RAWAT WORKER 9000
267 VISHAL RAWAT PEON 14000
268 SAURABH RAWAT PEON 8000
269 VIPIN VARMA WORKER 8000
270 SHIVA RAWAT CLERK 9000
271 SIVAM RAWAT WORKER 14000
272 KOMAL RAWAT CLERK 8000
UTTAR PRADESH 250000
DELHI 170000
BIHAR 150000
JHARKHAND 20000
HARYANA 35000 300000

250000

200000

VINEET KU
150000

100000

50000

0
UTTAR PRADESH DELHI BIHAR JHARKHA
ET KUMAR Column B

H DELHI BIHAR JHARKHAND HARYANA

You might also like