IBIS AUGUST-2022 (1).xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM
1	Name & Address of the Contractor:-													FORM XVII														PRINCIPAL EMPLOYER
2	GAURUSHI ASSOCIATES													SEE RULE (78)(2)(a)														HOTEL IBIS DELHI
3	85-c, Dda Flats,, Mansarover Park,,Shahdara, Dist: EAST, State: DELHI, Pin: 110032													REGISTER OF WAGES
4	WAGES SHEET FOR MONTH OF AUGUST-2022
5														MONTH DAY		31
6	S. No.			Name	Father's Name				Desig.	Paid Days	Extra Days	RATE OF WAGES							WAGES EARNED								DEDUCTION					Net Amount Paid	Signature/Thumb impression of workman & Bank A/c	Employer Share			Total [A + B + C + D] =(E)	Service Charge @6% (F)	Grand Total (For Billing ) in INR (E + F)
7	S. No.	ESI NO	UAN	Name	Father's Name	dob	doj		Desig.	Paid Days	Extra Days	Wage Rate/Basic	HRA	CONV.	SPL. ALLO	LEAVE	BONUS	Total	Wage Rate/Basic	HRA	CONV.	SPL. ALLO	LEAVE	BONUS	O.T.WAGES	Total (A)	ESI @ .75%	EPF @ 12%	LWF @ 0.2%	OTHERS	Total Ded.	Net Amount Paid	Signature/Thumb impression of workman & Bank A/c	PF @ 13% (B)	ESIC @ 3.25% ©	LWF @ 50/= (D)	Total [A + B + C + D] =(E)	Service Charge @6% (F)	Grand Total (For Billing ) in INR (E + F)
8	1	1014708665	101247576005	SATISH CHANDER	RAMKJILADI SINGH	15-Oct-1978	5/5/2022	229780784106 SBIN0006147 11824332621	HK	32		16506				1164	1375	19045	17038	0	0	0	1202	1419	0	19659	128	2045	0	0	2173	17486		2215	554	0	22428	1022	23450
9	2	1014708662	101389737528	YATENDRA SINGH	UDAY VEER SINGH	10-Jan-1988	5/5/2022	523384323990 9520730397 IPOS0000001 056410147606	HK	19		16506				1164	1375	19045	10117	0	0	0	713	843	0	11673	76	1214	0	0	1290	10383		1315	329	0	13317	607	13924
10	3	1014719539	100868332150	RAJENDAR KUMAR DAS	SIDHANI DAS	15-Apr-1982	5/26/2022	705453709986 9910115348	HK	32		16506				1164	1375	19045	17038	0	0	0	1202	1419	0	19659	128	2045	0	0	2173	17486		2215	554	0	22428	1022	23450
11	4	1014708658	101310650683	JAYPAL SINGH	JAYVEER SINGH	8/5/1984	5/21/2022	219385741270 BKID0007714 7714105010010210	HK	32		16506				1164	1375	19045	17038	0	0	0	1202	1419	0	19659	128	2045	0	0	2173	17486		2215	554	0	22428	1022	23450
12	5	1014719546	101423305556	KAUKLESH	PREM SHANKAR	1/1/1995	6/1/2022	215907587848	HK	26		16506				1164	1375	19045	13844	0	0	0	976	1153	0	15973	104	1661	0	0	1765	14208		1800	450	0	18223	831	19054
13	6	1014729465	101198993881	RAVI SHANKER	RADHE SHYAM	7/14/1997	7/2/2022	713668237344 SBIN0001158 35498457017	HK	0		16506				1164	1375	19045	0	0	0	0	0	0	0	0	0	0	0	0	0	0		0	0	0	0	0	0
14	7	1014729483	101716515107	AKASH	KAPOOR CHAND	2/2/2000	7/16/2022	386161320673	HK	30		16506				1164	1375	19045	15974	0	0	0	1126	1331	0	18431	120	1917	0	0	2037	16394		2077	520	0	21028	958	21986
15	8	1014729491	101742586261	AKAASH KAUSHIK	MOHAN KAUSHIK	1/1/2001	7/25/2022	827419484435	HK	32		16506				1164	1375	19045	17038	0	0	0	1202	1419	0	19659	128	2045	0	0	2173	17486		2215	554	0	22428	1022	23450
16	9	1014729513	101439759307	AAKASH	JAI SINGH	4/13/1995	7/2/2022	881540424275	HK	31		16506				1164	1375	19045	16506	0	0	0	1164	1375	0	19045	124	1981	0	0	2105	16940		2146	537	0	21728	990	22718
17	9	1014738631	101431104467	SWATI	AMIT KUMAR	7/6/1994	8/5/2022	88022210012650 CNRBINBBBFD (7011955268) 658612189989	LAUNDRY	28		16506				1164	1375	19045	14909	0	0	0	1051	1242	0	17202	112	1789	0	0	1901	15301		1938	485	0	19625	895	20520
18	9	1014738634	100639903211	INDRAPAL	HAUSILA PRASHAD	5/15/1996	8/24/2022	3691101001770 CNRB0003691 415591842426	HK	9		16506				1164	1375	19045	4792	0	0	0	338	399	0	5529	36	575	0	0	611	4918		623	156	0	6308	288	6596
19	9	1014738642	101315047737	VINAY	LALAN MAHTO	8/1/2022	3/16/1988	52828100015370 BARB0KOTEAX 476695111254	LAUNDRY	30		16506				1164	1375	19045	15974	0	0	0	1126	1331	0	18431	120	1917	0	0	2037	16394		2077	520	0	21028	958	21986
20	TOTAL									301	0								160268	0	0	0	11302	13350	0	184920	1204	19234	0	0	20438	164482		20836	5213	0	210969	9615	220584
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100