Payroll in Excel Format
Payroll in Excel Format
S.NO. NAME Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri
DESIGNATION
STAFF ATTENDANCE FOR DEC'09 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
01 Mr. XXXX Corporate Chef W/O P P P P P P W/O P P P P P P W/O P P P P P P W/O P C/O P
02 Mr. XXXX G.M. OPS P P P P P P P P P P P P P W/O P P P P P P P P P P P
03 Mr. XXXX H.R. Executive P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P P
04 Mr. XXXX SECURITY OFFICER P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
05 Mr. XXXX STORES IN-CHARGE P P P P P P W/O P P P P P P P P P W/O P P P P P P P P
06 Mr. XXXX STORES ASSISTANT P P P P P P P P P P P W/O P P P P P P P P P P P P P
07 Mr. XXXX CASHIER P P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P
08 Mr. XXXX CASHIER W/O P P P C/O C/O C/O P P P P P W/O P P P P P P P P P P P P
09 Mr. XXXX ACCOUNTANT P P P P P W/O P P P P P P W/O P P P P P P W/O P P P CL P
10 Mr. XXXX ACCOUNTANT P P CL P P W/O P P P P P P W/O P P P P P P W/O P CL P P P
11 Mr. XXXX Maintenance P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
12 Mr. XXXX DRIVER P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
13 Mr. XXXX DRIVER P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
14 Mr. XXXX DRIVER P P P P P P P P P W/O P P P P W/O P P P P P P P P P P
15 Mr. XXXX DRIVER W/O P P P P P P W/O P P P P P P P W/O P P P P P W/O P P P
16 Mr. XXXX DRIVER CL SL SL SL SL SL SL PL PL PL PL PL P P P P W/O P P P P P P W/O P
17 Mr. XXXX BOUNCER P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P A
18 Mr. XXXX BOUNCER OD P OD P P A A A P P P P P P OD P P P P P P W/O P P P
19 Mr. XXXX F&B EXECUTIVE P P P P P P/O P P P W/O C/O C/O P P P P P P P P P P P P P
20 Mr. XXXX Asst. MANAGER P W/O P P P P W/O P P P P P P P W/O P P P P P W/O P P P P
21 Mr. XXXX BAR INCHARGE P P P P P W/O P P P P P LF LF LF LF LF LF LF LF LF LF LF LF LF LF
22 Mr. XXXX BAR TENDER P P P P W/O P P P P W/O P P P P P P P P P P P P P P W/O
23 Mr. XXXX CAPTAIN C/O C/O P P P P P P P P P P P W/O P P P P P P P W/O P P P
24 Mr. XXXX Asst. BAR TERNER CL P/CL P P P W/O P P P W/O P P P P W/O P P P P W/O P P P P P
25 Mr. XXXX Asst. BAR TERNER P P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P
26 Mr. XXXX Tr. CAPTAIN C/O C/O P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
27 Mr. XXXX STEWARD P P P P P P W/O P P P P P P P W/O P P P P P P P P W/O P
28 Mr. XXXX Sr. CAPTAIN P P P P P P W/O P/O P/O P P P P P W/O P P P P P P P P/O P/O P
29 Mr. XXXX Sr. STEWARD W/O P P P P P P W/O CL P P P P P W/O P P P P P P W/O P P P
30 Mr. XXXX STEWARD P P W/O P P P P P P P/O P/O P P P P P W/O P P P P P P W/O P
31 Mr. XXXX Tr. CAPTAIN P P/O P/O P P P P P P/O P/O P P P P/O P P/O P P P P P P/O P/O P P
32 Mr. XXXX STEWARD P P P P P W/O P P P P P P P W/O P P P P P P W/O P P P P
33 Mr. XXXX STEWARD P W/O P P P P P P P P W/O P P P P W/O P P P P P P W/O P P
34 Mr. XXXX G.S.A. P P W/O P P P P/O P P W/O P P P W/O P P P P P P W/O P P P P
35 Mr. XXXX G.S.A. W/O P P P P P W/O CL P P P P P W/O P P P P P P P P/O P P P
36 Mr. XXXX Sr. Bar Tender P P P P P P W/O P P P P P P P W/O P P P P P W/O P P P P
37 Mr. XXXX Bar Tender W/O P P P P P W/O P P P P P P/CL W/O P P P P P P P P P W/O P
38 Mr. XXXX Bar Tender P P P P P P W/O P P P P P P W/O P P P P P P P P P W/O P
39 Mr. XXXX STEWARD P P P W/O P P P P P/O P P P P P W/O P P P P P P P W/O P P
40 Mr. XXXX HOSTESS P P P P P W/O P P P P P P P P W/O P P P P P P W/O P C/O P
41 Mr. XXXX Tr. HOSTESS P P P P P P P W/O P P P P P W/O P P P P P P W/O P P P P
42 Mr. XXXX BAR TENDER P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
43 Mr. XXXX Tr. CAPTAIN NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ P P P P P P P A A A P P P
44 Mr. XXXX HOSTESS P P P P P P W/O P P P P P P P W/O P P P P P P W/O P C/O P
45 Mr. XXXX Tr. HOSTESS W/O P P P P P P W/O P P P P P W/O P P LOP LOP LOP LOP LOP P P P P
46 Mr. XXXX Sous Chef P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
47 Mr. XXXX CDP P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
48 Mr. XXXX CDP PL PL PL PL PL PL PL P P P P P P P P P P P P P P W/O P P P
49 Mr. XXXX Pro - commis W/O P P P P P P P P P W/O P P P P P W/O P P P P P P W/O P
50 Mr. XXXX Pro - commis C/O C/O C/O P P P P P P P P P W/O P P P P P P W/O P P P P P
51 Mr. XXXX Pro - commis P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
52 Mr. XXXX Pro - commis P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P P
53 Mr. XXXX Pro - commis P P P P W/O P P P P P P P W/O CL P P P P W/O CL P P P P P
54 Mr. XXXX Pro - commis P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
55 Mr. XXXX Pro - commis CL CL SL SL PL PL PL C/O C/O C/O A A A A A A A A A A A P P P P
56 Mr. XXXX Pro - commis P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
57 Mr. XXXX CDP W/O P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P
58 Mr. XXXX Pro - commis W/O P P P P P P P W/O P P P P P P W/O P P P P P P W/O P P
59 Mr. XXXX Pro - commis P W/O P P P P P P P P P W/O P P P P P P P P P W/O P P P
60 Mr. XXXX H.K. SUPERVISOR P P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P
61 Mr. XXXX HK BOY P W/O P P P P P P W/O P P P P P P W/O P P P P P P P W/O P
62 Mr. XXXX HK BOY W/O P P P P P P W/O CL P P P P P W/O P P P P P P W/O P P P
63 Mr. XXXX HK BOY P P W/O P P P P P P W/O P P P P P P W/O P P P P P P W/O P
64 Mr. XXXX HK BOY P P P W/O P P W/O P P P P P W/O P P P P P P W/O P P P P P
65 Mr. XXXX HK BOY P P P P P W/O P P P P P P P W/O CL P P P P P W/O P P P P
66 Mr. XXXX LINEN BOY W/O P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
67 Mr. XXXX KST SUPERVISOR P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
68 Mr. XXXX KST W/O P P P P P W/O P P P P P P P W/O CL P P P P P W/O P CL P
69 Mr. XXXX KST P W/O P P P P W/O PL PL PL PL PL PL PL P P P P P P W/O P P CL P
70 Mr. XXXX KST P P P P P P P W/O P P P P P P P W/O P P P P P P W/O P P
71 Mr. XXXX KST P P W/O P P P P P P W/O P P P P P P W/O P P P P P P W/O P
72 Mr. XXXX KST P P P W/O P CL P P P P W/O P P P P P P W/O P P P P P P W/O
73 Mr. XXXX KST P P P P W/O P P P W/O P P P P P P P P P W/O P P P P P P
74 Mr. XXXX KST W/O P P P P P P W/O P P P P P P P W/O P P P P P W/O P P P
75 Mr. XXXX IET P C/O C/O C/O C/O C/O LOP LOP LOP LOP LOP LOP LOP LOP LOP LOP LOP P P P W/O P P P P
76 Mr. XXXX LIFT OPERATTGOR P P P P P P W/O P P P P P P W/O P P P P P P W/O P P P P
Sat Sun Mon Tue Wed Thu Working Payble
Leave Lop Days
Days Days
26 27 28 29 30 31
P P P W/O P P 30 1 0 31 31
P P P P P P 31 0 0 31 31
P W/O P P P P 31 0 0 31 31
P P W/O P P P 31 0 0 31 31
P P W/O P P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P P P P 28 3 0 31 31
P W/O P P P P 30 1 0 31 31
P W/O P P P P 29 2 0 31 31
P P W/O P P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P P W/O P 31 0 0 31 31
P P P P W/O P 31 0 0 31 31
P P P P P P 19 12 0 31 31
P P W/O P P P 30 0 1 31 30
P P P W/O P P 28 0 3 31 28
P P P P/O P P 29 2 0 31 31
P P W/O P P P 31 0 0 31 31
LF LF LF LF LF LF 11 0 20 31 11
P P P P P P 31 0 0 31 31
P P W/O P P P 29 2 0 31 31
P W/O P P P P 29.5 1.5 0 31 31
P W/O C/O C/O P P 29 2 0 31 31
P P W/O P P P 29 2 0 31 31
P P P W/O P P 31 0 0 31 31
P P P P/O P P 31 0 0 31 31
P P P W/O P P 30 1 0 31 31
P P P P W/O P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P W/O P P P 31 0 0 31 31
P P P P W/O P 31 0 0 31 31
P P P/O P P P 31 0 0 31 31
P P P P P P 30 1 0 31 31
P P W/O P P P 31 0 0 31 31
P P W/O P P P 30.5 0.5 0 31 31
P P P W/O P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P W/O A P 29 1 1 31 30
P/CL P W/O P P P 30.5 0.5 0 31 31
P P W/O P P P 31 0 0 31 31
P P P P P P 16 0 15 31 16
P P P W/O P P 30 1 0 31 31
P P W/O P P P 26 0 5 31 26
P P W/O P P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P W/O P P P 24 7 0 31 31
P P P P P P 31 0 0 31 31
P W/O P P P P 28 3 0 31 31
P P W/O P P P 31 0 0 31 31
P W/O P P P P 31 0 0 31 31
P W/O P P P P 29 2 0 31 31
P P W/O P P P 31 0 0 31 31
P P W/O P P P 10 10 11 31 20
P P P W/O P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P P W/O P 31 0 0 31 31
W/O P P W/O P P 31 0 0 31 31
CL W/O P P P P 30 1 0 31 31
P P P P P P 31 0 0 31 31
P P P W/O C/O P 29 2 0 31 31
P P W/O P P P 31 0 0 31 31
P W/O P P P P 31 0 0 31 31
W/O P P P P P 30 1 0 31 31
P P P P P P 31 0 0 31 31
P P W/O P P P 31 0 0 31 31
P P P P W/O P 29 2 0 31 31
P P P P W/O P 23 8 0 31 31
P P W/O P P P 31 0 0 31 31
P P P W/O P P 31 0 0 31 31
P P P P P P 30 1 0 31 31
W/O P P P P P 31 0 0 31 31
P CL W/O P P P 30 1 0 31 31
P P P W/O P P 15 5 11 31 20
P P P W/O P P 31 0 0 31 31
Grow More Hospitality Services Private Limited
Salary Statement for the month of December'2009
S. Wash. Spl. Gross No.of Wash. Spl. Gross PF ESI P.
ID.No Name Basic VDA HRA CONV Medical Others Total Basic VDA HRA CONV Medi. Others Total EPF ESIC
No Allow Allow Total Days Allow Allow Total Gross Gross Tax
Administration
01 GM001 Mr. XXXX 50000 1001 20000 800 1250 600 26349 0 100000 100000 31 50000 1001 20000 800 1250 600 26349 0 100000 100000 6500 780 0 0 200
02 GM002 Mr. XXXX 30000 1001 0 800 1250 0 26949 0 60000 60000 31 30000 1001 0 800 1250 0 26949 0 60000 60000 6500 780 0 0 200
03 Mr. XXXX 5000 1001 2000 800 0 600 599 0 10000 10000 31 5000 1001 2000 800 0 600 599 0 10000 10000 6001 720 9400 165 80
Total: 85000 3003 22000 2400 2500 1200 53897 0 170000 170000 93 85000 3003 22000 2400 2500 1200 53897 0 170000 170000 19001 2280 9400 165 480
Security
04 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
Total: 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
Accounts
05 113 Mr. XXXX 6000 1001 2150 800 1250 0 799 0 12000 12000 31 6000 1001 2150 800 1250 0 799 0 12000 12000 6500 780 0 0 100
06 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 0
07 652 Mr. XXXX 3250 1001 600 250 0 600 799 0 6500 6500 31 3250 1001 600 250 0 600 799 0 6500 6500 4251 510 5900 104 80
08 Mr. XXXX 3500 1001 600 500 0 600 799 0 7000 7000 31 3500 1001 600 500 0 600 799 0 7000 7000 4501 540 6400 112 80
09 Mr. XXXX 4250 1001 800 600 0 600 1249 0 8500 8500 31 4250 1001 800 600 0 600 1249 0 8500 8500 5251 630 7900 139 80
10 Mr. XXXX 7500 1001 2600 800 1250 0 1849 0 15000 15000 31 7500 1001 2600 800 1250 0 1849 0 15000 15000 6500 780 0 0 100
Total: 26750 6006 7300 2950 2500 2400 5594 148 53648 53648 186 26750 6006 7300 2950 2500 2400 5594 148 53500 53648 30254 3630 24248 426 440
Maintenance
11 824 Mr. XXXX 3250 1001 600 250 0 600 799 0 6500 6500 31 3250 1001 600 250 0 600 799 0 6500 6500 4251 510 5900 104 80
Total: 3250 1001 600 250 0 600 799 0 6500 6500 31 3250 1001 600 250 0 600 799 0 6500 6500 4251 510 5900 104 80
Drivers
12 114 Mr. XXXX 3250 1001 600 250 0 600 799 0 6500 6500 31 3250 1001 600 250 0 600 799 0 6500 6500 4251 510 5900 104 80
13 Mr. XXXX 2450 1001 400 0 0 600 1049 0 5500 5500 31 2450 1001 400 0 0 600 1049 0 5500 5500 3451 414 4900 86 60
14 Mr. XXXX 2450 1001 400 0 0 600 1049 0 5500 5500 31 2450 1001 400 0 0 600 1049 0 5500 5500 3451 414 4900 86 60
15 Mr. XXXX 2450 1001 400 0 0 600 1049 0 5500 5500 31 2450 1001 400 0 0 600 1049 0 5500 5500 3451 414 4900 86 60
16 Mr. XXXX 2450 1001 400 0 0 600 1049 0 5500 5500 31 2450 1001 400 0 0 600 1049 0 5500 5500 3451 414 4900 86 60
Total: 13050 5005 2200 250 0 3000 4995 0 28500 28500 155 13050 5005 2200 250 0 3000 4995 0 28500 28500 18055 2167 25500 448 320
Bouncer
17 Mr. XXXX 4500 1001 700 700 0 600 1499 0 9000 9000 30 4355 969 677 677 0 581 1451 0 8710 8710 5324 639 8129 143 80
18 Mr. XXXX 4500 1001 700 700 0 600 1499 0 9000 9000 28 4065 904 632 632 0 542 1354 0 8129 8129 4969 596 7587 133 80
Total: 9000 2002 1400 1400 0 1200 2998 0 18000 18000 58 8419 1873 1310 1310 0 1123 2805 0 16839 16839 10292 1235 15716 276 160
F&B Service
19 Mr. XXXX 6000 1001 2400 800 0 600 1199 0 12000 12000 31 6000 1001 2400 800 0 600 1199 0 12000 12000 6500 780 0 0 100
20 Mr. XXXX 7500 1001 2600 800 1250 0 1849 0 15000 15000 31 7500 1001 2600 800 1250 0 1849 0 15000 15000 6500 780 0 0 100
21 Mr. XXXX 4500 1001 700 700 0 600 1499 0 9000 9000 31 4500 1001 700 700 0 600 1499 0 9000 9000 5501 660 8400 147 80
22 Mr. XXXX 3500 1001 600 500 0 600 799 0 7000 7000 31 3500 1001 600 500 0 600 799 0 7000 7000 4501 540 6400 112 80
23 Mr. XXXX 2500 1001 750 0 0 600 149 0 5000 5000 31 2500 1001 750 0 0 600 149 0 5000 5000 3501 420 4400 77 0
24 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
25 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
Grow More Hospitality Services Private Limited
Salary Statement for the month of December'2009
S. Wash. Spl. Gross No.of Wash. Spl. Gross PF ESI P.
ID.No Name Basic VDA HRA CONV Medical Others Total Basic VDA HRA CONV Medi. Others Total EPF ESIC
No Allow Allow Total Days Allow Allow Total Gross Gross Tax
26 Mr. XXXX 2500 1001 750 0 0 600 149 0 5000 5000 31 2500 1001 750 0 0 600 149 0 5000 5000 3501 420 4400 77 0
27 Mr. XXXX 4000 1001 1600 0 0 600 799 0 8000 8000 31 4000 1001 1600 0 0 600 799 0 8000 8000 5001 600 7400 130 80
28 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
29 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
30 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
31 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
32 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
33 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
34 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
35 Mr. XXXX 4000 1001 1600 0 0 600 799 0 8000 8000 31 4000 1001 1600 0 0 600 799 0 8000 8000 5001 600 7400 130 80
36 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
37 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
38 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
39 Mr. XXXX 4000 1001 1000 600 0 600 799 0 8000 8000 30 3871 969 968 581 0 581 773 0 7742 7742 4840 581 7161 126 80
40 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
41 Mr. XXXX 4000 1001 1600 0 0 600 799 0 8000 8000 31 4000 1001 1600 0 0 600 799 0 8000 8000 5001 600 7400 130 80
42 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 16 1548 517 206 0 0 310 516 0 3097 3097 2065 248 2787 49 60
Total: 77750 24024 20550 3400 1250 13800 14726 3078 158578 158578 728 76169 23507 20324 3381 1250 13490 14217 3078 152339 155417 97175 11661 115526 2033 980
Front Office
43 Mr. XXXX 5000 1001 2000 800 0 600 599 0 10000 10000 31 5000 1001 2000 800 0 600 599 0 10000 10000 6001 720 9400 165 80
44 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 26 1887 840 461 0 0 503 83 287 3774 4061 2727 327 3558 63 0
Total: 7250 2002 2550 800 0 1200 698 342 14842 14842 57 6887 1841 2461 800 0 1103 682 287 13774 14061 8728 1047 12958 228 80
F&B Production
45 608 Mr. XXXX 11900 1001 5000 800 1250 600 4449 0 25000 25000 31 11900 1001 5000 800 1250 600 4449 0 25000 25000 6500 780 0 0 200
46 KF8 Mr. XXXX 5000 1001 2000 800 0 600 599 0 10000 10000 31 5000 1001 2000 800 0 600 599 0 10000 10000 6001 720 9400 165 80
47 KC2 Mr. XXXX 5000 1001 2000 800 0 600 599 0 10000 10000 31 5000 1001 2000 800 0 600 599 0 10000 10000 6001 720 9400 165 80
48 Mr. XXXX 4500 1001 700 700 0 600 1499 0 9000 9000 31 4500 1001 700 700 0 600 1499 0 9000 9000 5501 660 8400 147 80
49 385 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
50 Mr. XXXX 3500 1001 600 500 0 600 799 0 7000 7000 31 3500 1001 600 500 0 600 799 0 7000 7000 4501 540 6400 112 80
51 Mr. XXXX 2500 1001 600 0 0 600 1049 0 5750 5750 31 2500 1001 600 0 0 600 1049 0 5750 5750 3501 420 5150 91 60
53 Mr. XXXX 2500 1001 600 0 0 600 1049 0 5750 5750 31 2500 1001 600 0 0 600 1049 0 5750 5750 3501 420 5150 91 60
54 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 20 1452 646 355 0 0 387 64 221 2903 3124 2097 252 2737 48 0
55 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
56 Mr. XXXX 5000 1001 2000 800 0 600 599 0 10000 10000 31 5000 1001 2000 800 0 600 599 0 10000 10000 6001 720 9400 165 80
57 Mr. XXXX 3000 1001 400 0 0 600 999 0 6000 6000 31 3000 1001 400 0 0 600 999 0 6000 6000 4001 480 5400 95 60
New Joining
58 Mr. XXXX 2250 1001 550 0 0 600 99 342 4842 4842 31 2250 1001 550 0 0 600 99 342 4500 4842 3251 390 4242 75 0
53400 13013 15800 4400 1250 7800 13837 684 110184 110184 392 52602 12658 15605 4400 1250 7587 13802 563 107903 108466 58858 7063 76479 1344 900
Housekeeping
59 67 Mr. XXXX 3250 1001 600 250 0 600 799 0 6500 6500 31 3250 1001 600 250 0 600 799 0 6500 6500 4251 510 5900 104 80
60 259 Mr. XXXX 2300 1001 575 0 0 600 124 48 4648 4648 31 2300 1001 575 0 0 600 124 48 4600 4648 3301 396 4048 71 -
Grow More Hospitality Services Private Limited
Salary Statement for the month of December'2009
S. Wash. Spl. Gross No.of Wash. Spl. Gross PF ESI P.
ID.No Name Basic VDA HRA CONV Medical Others Total Basic VDA HRA CONV Medi. Others Total EPF ESIC
No Allow Allow Total Days Allow Allow Total Gross Gross Tax
61 Mr. XXXX 2000 1001 400 0 0 600 62 585 4648 4648 31 2000 1001 400 0 0 600 62 585 4063 4648 3001 360 4048 71 -
62 Mr. XXXX 2000 1001 400 0 0 600 62 585 4648 4648 31 2000 1001 400 0 0 600 62 585 4063 4648 3001 360 4048 71 -
63 Mr. XXXX 2000 1001 400 0 0 600 62 585 4648 4648 31 2000 1001 400 0 0 600 62 585 4063 4648 3001 360 4048 71 -
64 Mr. XXXX 2000 1001 400 0 0 600 62 585 4648 4648 31 2000 1001 400 0 0 600 62 585 4063 4648 3001 360 4048 71 -
65 Mr. XXXX 2000 1001 400 0 0 600 62 585 4648 4648 31 2000 1001 400 0 0 600 62 585 4063 4648 3001 360 4048 71 -
Total: 15550 7007 3175 250 0 4200 1233 2973 34388 34388 217 15550 7007 3175 250 0 4200 1233 2973 31415 34388 22557 2707 30188 530 80
Kitchen Stewarding
66 Mr. XXXX 2500 1001 750 0 0 600 149 0 5000 5000 31 2500 1001 750 0 0 600 149 0 5000 5000 3501 420 4400 77 -
67 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
68 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
69 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
70 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
71 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
72 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
73 Mr. XXXX 2250 1001 550 0 0 600 99 148 4648 4648 31 2250 1001 550 0 0 600 99 148 4500 4648 3251 390 4048 71 -
Total: 18250 8008 4600 0 0 4800 842 1036 37536 37536 248 18250 8008 4600 0 0 4800 842 1036 36500 37536 26258 3151 32736 574 0
Trainees
74 Mr. XXXX 3000 0 0 0 0 0 0 0 3000 3000 20 1935 0 0 0 0 0 0 0 1935 1935 0 0 0 0 -
75 Mr. XXXX 3500 0 0 0 0 0 0 0 3500 3500 31 3500 0 0 0 0 0 0 0 3500 3500 0 0 0 0 -
Total: 6500 0 0 0 0 0 0 0 6500 6500 51 5435 0 0 0 0 0 0 0 5435 5435 0 0 0 0 0
Grand Total: 318750 72072 80575 16100 7500 40800 100618 8261 644676 644676 2247 314363 70910 79975 15990 7500 40103 99864 8084 628705 636790 299430 35932 354051 6223 3580
H. R. Department
Misc. Other Phone Tot. Net Round off
I.Tax Signature
Ded Dedu Bill Ded Salary NET Sal
0 0 0 0 1935 1936
0 0 0 0 3500 3500
0 0 0 0 0 5435 5436
General Manager
MIS Report for the month of Dec'09
Gross
S. No. of Gross PF PF ESIC ESIC Misc Other Credit Phone Income Total Net PF ESIC
Particulars Salary Salary PT Remarks
No. Staff Salary Gross EMP Gross EMP Ded Dedu Bills Bill Tax Dedu Salary EMPL EMPL
Payable
01 H.R. & Admin 3 170,000 170,000 170,000 19,001 2,280 9,400 165 480 - - - 365 28,000 31,290 138,710 2,586 447
02 Security 1 6,000 6,000 6,000 4,001 480 5,400 95 60 - - - - - 635 5,365 545 257
03 Accounts 6 53,648 53,500 53,648 30,254 3,630 24,248 426 440 148 - - - - 4,644 49,004 4,118 1,152
04 Maintenance 1 6,500 6,500 6,500 4,251 510 5,900 104 80 - - - - - 694 5,806 579 280
05 Drivers 5 28,500 28,500 28,500 18,055 2,167 25,500 448 320 - - - - - 2,935 25,566 2,457 1,211
06 Bouncer 2 18,000 16,839 16,839 10,292 1,235 15,716 276 160 - - - - - 1,671 15,168 1,401 747
07 F&B Service 24 158,578 152,339 155,417 97,175 11,661 115,526 2,033 980 3,078 600 - 57 - 18,409 137,011 13,225 5,488
08 Front Office 2 14,842 13,774 14,061 8,728 1,047 12,958 228 80 287 100 - - - 1,742 12,319 1,188 615
09 F&B Production 14 110,184 107,903 108,466 58,858 7,063 76,479 1,344 900 563 - - - - 9,870 98,598 8,011 3,633
10 House Keeping 7 34,388 31,415 34,388 22,557 2,707 30,188 530 80 2,973 - - - - 6,290 28,099 3,070 1,434
11 Kitchen Stewarding 8 37,536 36,500 37,536 26,258 3,151 32,736 574 - 1,036 - - - - 4,761 32,776 3,574 1,555
Gross
Earnings Salary
Salary
Deductions Amount
Basic 50000 50000 PF 780
VDA 1001 1001 ESI -
HRA 20000 20000 PT 200
Conveyance 800 800 Misc. Ded -
Medical Allow. 1250 1250 Phone Bill -
Washing Allow. 600 600 I. Tax 22000
Spl. Allowance 26349 26349
Others 0 0 Other deduction -
100000 100000 22,980
Net Pay in words: Rupees Seventy Seven Thousand & twenty only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 30000 30000 PF 780
VDA 1001 1001 ESI -
HRA 0 0 PT 200
Conveyance 800 800 Misc. Ded -
Medical Allow. 1250 1250 Phone Bill 365
Washing Allow. 0 0 I. Tax 6000
Spl. Allowance 26949 26949
Others 0 0 Other deduction -
60000 60000 7,345
Net Pay in words: Rupees Fifty Two Thousand Six Hundred & Fifty Five Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 5000 5000 PF 720
VDA 1001 1001 ESI 165
HRA 2000 2000 PT 80
Conveyance 800 800 Misc. Ded -
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax -
Spl. Allowance 599 599
Others 0 Other deduction -
10000 10000 965
Net Pay in words: Rupees Nine Thousand & Thirty Five Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3000 3000 PF 480
VDA 1001 1001 ESI 95
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 999 999
Others 0 0 Other deduction -
6000 6000 635
Net Pay in words: Rupees Five Thousand Three Hundred & Sixty Five Only
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 6000 6000 PF 780
VDA 1001 1001 ESI -
HRA 2150 2150 PT 100
Conveyance 800 800 Misc. Ded -
Medical Allow. 1250 1250 Phone Bill -
Washing Allow. 0 0 I. Tax
Spl. Allowance 799 799
Others 0 0 Other deduction -
12000 12000 880
Net Pay in words: Rupees Eleven Thousand One Hunderd & Twenty only
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 71
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 148
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax
Spl. Allowance 99 99
Others 148 148 Other deduction -
4648 4648 609
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3250 3250 PF 510
VDA 1001 1001 ESI 104
HRA 600 600 PT 80
Conveyance 250 250 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax
Spl. Allowance 799 799
Others 0 0 Other deduction -
6500 6500 694
Net Pay in words: Rupees Five Thousand Eight Hundred & Six only
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3500 3500 PF 540
VDA 1001 1001 ESI 112
HRA 600 600 PT 80
Conveyance 500 500 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax
Spl. Allowance 799 799
Others 0 0 Other deduction -
7000 7000 732
Net Pay 6268
Net Pay in words: Rupees Six Thousand Two Hundred & Sixty Eight Only
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 4250 4250 PF 630
VDA 1001 1001 ESI 139
HRA 800 800 PT 80
Conveyance 600 600 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax
Spl. Allowance 1249 1249
Others 0 0 Other deduction -
8500 8500 849
Net Pay in words: Rupees Seven Thousand Six Hundred & Fifty One Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 7500 7500 PF 780
VDA 1001 1001 ESI -
HRA 2600 2600 PT 100
Conveyance 800 800 Misc. Ded -
Medical Allow. 1250 1250 Phone Bill -
Washing Allow. 0 0 I. Tax
Spl. Allowance 1849 1849
Others 0 0 Other deduction -
15000 15000 880
Net Pay in words: Rupees Forteen Thousand One Hundred & Twenty Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3250 3250 PF 510
VDA 1001 1001 ESI 104
HRA 600 600 PT 80
Conveyance 250 250 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 799 799
Others 0 0 Other deduction -
6500 6500 694
Net Pay in words: Rupees Five Thousand Eight Hundred & Six Only
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3250 3250 PF 510
VDA 1001 1001 ESI 104
HRA 600 600 PT 80
Conveyance 250 250 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 799 799
Others 0 0 Other deduction -
6500 6500 694
Net Pay in words: Rupees Five Thousand Eight Hundred & Six Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2450 2450 PF 414
VDA 1001 1001 ESI 86
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 1049 1049
Others 0 0 Other deduction -
5500 5500 560
Net Pay in words: Rupees Four Thousand Nine Hundred & Forty Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2450 2450 PF 414
VDA 1001 1001 ESI 86
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 1049 1049
Others 0 0 Other deduction -
5500 5500 560
Net Pay in words: Rupees Four Thousand Nine Hundred & Forty Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2450 2450 PF 414
VDA 1001 1001 ESI 86
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 1049 1049
Others 0 0 Other deduction -
5500 5500 560
Net Pay in words: Rupees Four Thousand Nine Hundred & Forty Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2450 2450 PF 414
VDA 1001 1001 ESI 86
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 1049 1049
Others 0 0 Other deduction -
5500 5500 560
Net Pay in words: Rupees Four Thousand Nine Hundred & Forty Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 4500 4355 PF 639
VDA 1001 969 ESI 143
HRA 700 677 PT 80
Conveyance 700 677 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 581 I. Tax -
Spl. Allowance 1499 1451
Others 0 0 Other deduction -
9000 8709.6774194 862
Net Pay in words: Rupees Seven Thousand Eight Hundred & Fourty Eight Only
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 4500 4065 PF 596
VDA 1001 904 ESI 133
HRA 700 632 PT 80
Conveyance 700 632 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 542 I. Tax -
Spl. Allowance 1499 1354
Others 0 0 Other deduction -
9000 8129 809
Net Pay in words: Rupees Seven Thousand Three Hundred & Twenty Only
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 6000 6000 PF 780
VDA 1001 1001 ESI -
HRA 2400 2400 PT 100
Conveyance 800 800 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 1199 1199
Others 0 0 Other deduction -
12000 12000 880
Net Pay in words: Rupees Eleven Thousand One Hundred & Twenty Only.
H. R. Department
Net Pay in words: Rupees Eight Thousand One Hundred & Thirteen Only
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2500 2500 PF 420
VDA 1001 1001 ESI 77
HRA 750 750 PT -
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 149 149
Others 0 0 Other deduction -
5000 5000 497
Net Pay in words: Rupees Four Thousand Five Hundred & Three Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 75
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 342
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 99 99
Others 342 342 Other deduction -
4842 4842 807
Net Pay in words: Rupees Four Thousand & Thirty Five Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3000 3000 PF 480
VDA 1001 1001 ESI 95
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill -
Washing Allow. 600 600 I. Tax -
Spl. Allowance 999 999
Others 0 Other deduction -
6000 6000 635
Net Pay in words: Rupees Five Thousand Three Hundred & Sixty Five Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2500 2500 PF 420
VDA 1001 1001 ESI 77
HRA 750 750 PT -
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 149 149
Others 0 0 Other deduction -
5000 5000 497
Net Pay in words: Rupees Four Thousand Five Hundred & Three Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 4000 4000 PF 600
VDA 1001 1001 ESI 130
HRA 1600 1600 PT 80
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 799 799
Others 0 0 Other deduction 100
8000 8000 910
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 75
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 342
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 99 99
Others 342 342 Other deduction -
4842 4842 807
Net Pay in words: Rupees Four Thousand & Thirty Five Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 75
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 342
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 99 99
Others 342 342 Other deduction -
4842 4842 807
Net Pay in words: Rupees Four Thousand & Thirty Five Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 3000 3000 PF 480
VDA 1001 1001 ESI 95
HRA 400 400 PT 60
Conveyance 0 0 Misc. Ded -
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 999 999
Others 0 0 Other deduction 100
6000 6000 735
Net Pay in words: Rupees Five Thousand Two Hundred & Sixty Five Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 75
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 342
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 99 99
Others 342 342 Other deduction -
4842 4842 807
Net Pay in words: Rupees Four Thousand & Thirty Five Only.
H. R. Department
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 75
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 342
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 99 99
Others 342 342 Other deduction 100
4842 4842 907
Net Pay in words: Rupees Three Thousand Nine Hundred & Thirty Five Only.
H. R. Department
XXXXXXXXXXX SERVICES PRIVATE LIMITED
Address
Address
Address
Gross
Earnings Salary
Salary
Deductions Amount
Basic 2250 2250 PF 390
VDA 1001 1001 ESI 75
HRA 550 550 PT -
Conveyance 0 0 Misc. Ded 342
Medical Allow. 0 0 Phone Bill
Washing Allow. 600 600 I. Tax
Spl. Allowance 99 99
Others 342 342 Other deduction 100
4842 4842 907
Net Pay in words: Rupees Three Thousand Nine Hundred & Thirty Five Only.
H. R. Department
PF Statement for the month of December'09
No.of PF EPF EPF EPF
S.No Name
Days Gross 12% 8.33% 3.67%
01 Mr. XXXX 31 6500 780 541 239
02 Mr. XXXX 31 6500 780 541 239
03 Mr. XXXX 31 6001 720 500 220
04 Mr. XXXX 31 4001 480 333 147
05 Mr. XXXX 31 6500 780 541 239
06 Mr. XXXX 31 3251 390 271 119
07 Mr. XXXX 31 4251 510 354 156
08 Mr. XXXX 31 4501 540 375 165
09 Mr. XXXX 31 5251 630 437 193
10 Mr. XXXX 31 6500 780 541 239
11 Mr. XXXX 31 4251 510 354 156
12 Mr. XXXX 31 4251 510 354 156
13 Mr. XXXX 31 3451 414 287 127
14 Mr. XXXX 31 3451 414 287 127
15 Mr. XXXX 31 3451 414 287 127
16 Mr. XXXX 31 3451 414 287 127
17 Mr. XXXX 30 5324 639 443 195
18 Mr. XXXX 28 4969 596 414 182
19 Mr. XXXX 31 6500 780 541 239
20 Mr. XXXX 31 6500 780 541 239
21 Mr. XXXX 31 5501 660 458 202
22 Mr. XXXX 31 4501 540 375 165
23 Mr. XXXX 31 3501 420 292 128
24 Mr. XXXX 31 3251 390 271 119
25 Mr. XXXX 31 4001 480 333 147
26 Mr. XXXX 31 3501 420 292 128
27 Mr. XXXX 31 5001 600 417 184
28 Mr. XXXX 31 3251 390 271 119
29 Mr. XXXX 31 3251 390 271 119
30 Mr. XXXX 31 4001 480 333 147
31 Mr. XXXX 31 3251 390 271 119
32 Mr. XXXX 31 3251 390 271 119
33 Mr. XXXX 31 3251 390 271 119
34 Mr. XXXX 31 3251 390 271 119
35 Mr. XXXX 31 5001 600 417 184
36 Mr. XXXX 31 4001 480 333 147
37 Mr. XXXX 31 4001 480 333 147
38 Mr. XXXX 31 3251 390 271 119
39 Mr. XXXX 30 4840 581 403 178
40 Mr. XXXX 31 3251 390 271 119
41 Mr. XXXX 31 5001 600 417 184
42 Mr. XXXX 16 2065 248 172 76
43 Mr. XXXX 31 6001 720 500 220
44 Mr. XXXX 26 2727 327 227 100
45 Mr. XXXX 31 6500 780 541 239
46 Mr. XXXX 31 6001 720 500 220
47 Mr. XXXX 31 6001 720 500 220
48 Mr. XXXX 31 5501 660 458 202
49 Mr. XXXX 31 4001 480 333 147
50 Mr. XXXX 31 4501 540 375 165
51 Mr. XXXX 31 3501 420 292 128
52 Mr. XXXX 31 4751 570 396 174
53 Mr. XXXX 31 3501 420 292 128
54 Mr. XXXX 20 2097 252 175 77
55 Mr. XXXX 31 4001 480 333 147
56 Mr. XXXX 31 6001 720 500 220
57 Mr. XXXX 31 4001 480 333 147
58 Mr. XXXX 31 3251 390 271 119
59 Mr. XXXX 31 4251 510 354 156
60 Mr. XXXX 31 3301 396 275 121
61 Mr. XXXX 31 3001 360 250 110
62 Mr. XXXX 31 3001 360 250 110
63 Mr. XXXX 31 3001 360 250 110
64 Mr. XXXX 31 3001 360 250 110
65 Mr. XXXX 31 3001 360 250 110
66 Mr. XXXX 31 3501 420 292 128
67 Mr. XXXX 31 3251 390 271 119
68 Mr. XXXX 31 3251 390 271 119
69 Mr. XXXX 31 3251 390 271 119
70 Mr. XXXX 31 3251 390 271 119
71 Mr. XXXX 31 3251 390 271 119
72 Mr. XXXX 31 3251 390 271 119
73 Mr. XXXX 31 3251 390 271 119
Grand Total: 2227 304181 36502 25338 11163
ESTABLISHMENT CODE No.: AP HYD/61880 ACCOUNT GROUP No. PAID BY CHEQUE/ CASH
M M Y Y Y Y
Employees Share 1 2 2 0 0 9 D D M M Y Y Y Y
DUES FOR THE MONTHS OF: DATE OF PAYMENT - -
Employers Share 1 2 2 0 0 9
A/c No. 1 A/c No. 2 A/c No. 10 A/c No. 21 A/c No. 22 TOTAL
S. NO. PARTICULARS
AMOUNT (in Rupees)
PART - 01
1. EMPLOYER'S SHARE OF CONTR. 35,932 24,943 1,497 62,371
2. EMPLOYEES' SHARE OF CONTR. 10,989 10,989
3. ADM. CHARGES 3,294 30 3,324
4. INSP. CHARGES
7(Q)
5. PENAL DAMAGES
14(B)
6. MISC. PAYMENT 76,684
46,921 3,294 24,943 1,497 30 76,685
(Amounts in words Rs. Seventy Seven Thousand Nine Hundred & One only)
(for Banks use only)
NAME OF ESTABLISHMENT: XXXXXXXXXXXXXXXXXXXXX Services Pvt. Ltd. Amount Received Rs. :………………………………………………
ADDRESS: For Cheques only :………………………………………………………
Date of Presentation : ………………………………………………..
Date of Realisation :…………………………………………………….
Branch Name: ……………………………………………………………….
NAME OF THE DEPOSITOR………………………………………………………………. Branch Code No. : ……………………………………………………….
SIGNATURE OF THE DEPOSITER………………………………… (TO BE FILLED IN BY EMPLOYER)
ESTABLISHMENT CODE No.: AP HYD/61880 ACCOUNT GROUP No. PAID BY CHEQUE/ CASH
M M Y Y Y Y
Employees Share 1 2 2 0 0 9 D D M M Y Y Y Y
DUES FOR THE MONTHS OF: DATE OF PAYMENT - -
Employers Share 1 2 2 0 0 9
A/c No. 1 A/c No. 2 A/c No. 10 A/c No. 21 A/c No. 22 TOTAL
S. NO. PARTICULARS
AMOUNT (in Rupees)
PART - 01
1. EMPLOYER'S SHARE OF CONTR. 35,932 24,943 1,497 62,371
2. EMPLOYEES' SHARE OF CONTR. 10,989 10,989
3. ADM. CHARGES 3,294 30 3,324
4. INSP. CHARGES
7(Q)
5. PENAL DAMAGES
14(B)
6. MISC. PAYMENT 76,684
46,921 3,294 24,943 1,497 30 76,685
(Amounts in words Rs. Seventy Seven Thousand Nine Hundred & One only)
(for Banks use only)
NAME OF ESTABLISHMENT: XXXXXXXXXXXXX Services Pvt. Ltd. Amount Received Rs. :………………………………………………
ADDRESS: For Cheques only :………………………………………………………
Date of Presentation : ………………………………………………..
Date of Realisation :…………………………………………………….
Branch Name: ……………………………………………………………….
NAME OF THE DEPOSITOR………………………………………………………………. Branch Code No. : ……………………………………………………….
ESTABLISHMENT CODE No.: AP HYD/61880 ACCOUNT GROUP No. PAID BY CHEQUE/ CASH
M M Y Y Y Y
Employees Share 1 2 2 0 0 9 D D M M Y Y Y Y
DUES FOR THE MONTHS OF: DATE OF PAYMENT - -
Employers Share 1 2 2 0 0 9
A/c No. 1 A/c No. 2 A/c No. 10 A/c No. 21 A/c No. 22 TOTAL
S. NO. PARTICULARS
AMOUNT (in Rupees)
PART - 01
1. EMPLOYER'S SHARE OF CONTR. 35,932 24,943 1,497 62,371
2. EMPLOYEES' SHARE OF CONTR. 10,989 10,989
3. ADM. CHARGES 3,294 30 3,324
4. INSP. CHARGES
7(Q)
5. PENAL DAMAGES
14(B)
6. MISC. PAYMENT 76,684
46,921 3,294 24,943 1,497 30 76,685
(Amounts in words Rs. Seventy Seven Thousand Nine Hundred & One only)
(for Banks use only)
NAME OF ESTABLISHMENT: XXXXXXXXXXXXXXXXXXXXX Services Pvt. Ltd. Amount Received Rs. :………………………………………………
ADDRESS: For Cheques only :………………………………………………………
Date of Presentation : ………………………………………………..
Date of Realisation :…………………………………………………….
Branch Name: ……………………………………………………………….
NAME OF THE DEPOSITOR………………………………………………………………. Branch Code No. : ……………………………………………………….
SIGNATURE OF THE DEPOSITER………………………………… (TO BE FILLED IN BY EMPLOYER)
ESTABLISHMENT CODE No.: AP HYD/61880 ACCOUNT GROUP No. PAID BY CHEQUE/ CASH
M M Y Y Y Y
Employees Share 1 2 2 0 0 9 D D M M Y Y Y Y
DUES FOR THE MONTHS OF: DATE OF PAYMENT - -
Employers Share 1 2 2 0 0 9
A/c No. 1 A/c No. 2 A/c No. 10 A/c No. 21 A/c No. 22 TOTAL
S. NO. PARTICULARS
AMOUNT (in Rupees)
PART - 01
1. EMPLOYER'S SHARE OF CONTR. 35,932 24,943 1,497 62,371
2. EMPLOYEES' SHARE OF CONTR. 10,989 10,989
3. ADM. CHARGES 3,294 30 3,324
4. INSP. CHARGES
7(Q)
5. PENAL DAMAGES
14(B)
6. MISC. PAYMENT 76,684
46,921 3,294 24,943 1,497 30 76,685
(Amounts in words Rs. Seventy Seven Thousand Nine Hundred & One only)
(for Banks use only)
NAME OF ESTABLISHMENT: XXXXXXXXXXXXXXXXXXXXX Services Pvt. Ltd. Amount Received Rs. :………………………………………………
ADDRESS: For Cheques only :………………………………………………………
Date of Presentation : ………………………………………………..
Date of Realisation :…………………………………………………….
Branch Name: ……………………………………………………………….
NAME OF THE DEPOSITOR………………………………………………………………. Branch Code No. : ……………………………………………………….
SIGNATURE OF THE DEPOSITER………………………………… (TO BE FILLED IN BY EMPLOYER)
Return of tax payable for the month ending on: December 2009
Address:
I certify that all the employees who are liable to pay the tax is employ durig the period of return have
been covered by the foregoing particulars. I also certify that the mecessary revision in the amount of
deductioble from the salaru or wages of the employees on account of variation in the salary or wages
earned by them has been made wherever ncessary.
I..................................................................................................................................................
solemnly declare that the above statements are true to the best of my knowledge and belief.
Date……………………………….. Signature…………………………………
Total: 23529
ESIC
ORIGINAL (for Bank)
DUPLICATE (for ESIC through Bank)
TRIPLICATE (for Depositor)
QUADPUPLICATE (through Depositgor)
Deposited by:
No. of Employees: 65
Total Wages Rs.: 354051
Employee's Contribution Rs.: 6223
Employer's Contribution Rs.: 16817
Total Rs.: 23040
(For use in Bank)
ACKNOWLEDGEMENT
(to be filled by depositor)