Jun-09 LEFT
JOIN
Apr-09
May-09
875
OPEN /BAL
AD
33
2
PR
57
10
CH
105
61
TW
24
14
TOTAL
219
87
MANOJ UNIT
KUMAR DEPT
875 ---->
1
1
TOTAL
192
OPEN /BAL
31
AD
13
48
PR
32
44
CH
1
LEFT
JOIN
Apr-09
May-09
13 4
28 1
10
TW
0
133
TOTAL
46
0 4
0
42
P.F. STATEMENT FOR THE MONTH OF SEPTEMBER 2004 EMPL
SALARY
P.F.
TOTAL
3.67%
10
26125
0
3135
3135
959
2176
31
90506
780
10861
11641
3322
7539
PR
48
63490
780
7618
8398
2330
5288
CH
44
34985
0
4193
4193
1281
2912
133
215106
1560
25807
27367
7892
17915
27367
7892
35259
TW AD
STRENGTH
V.P.F.
A/C 1 12%+3.67%
8.33%
A/C 2
1.1 %
2366
2366
219
A/C 10
8.33 %
17915
17915 1076
OPEN
Apr-09
JOINING
May-09
1
A/C 21
0.5 %
1076
LEFT
Apr-09
87
A/C 22
0.01%
22
22
29271
56638
CLOSING
192 ---->
133
27367
AD
13
32398
PR
28
86636
CH
1
3825
42
122859
STRENGTH
3887
3887
1189
2698
690
10395
11085
3182
7213
459
459
140
319
690
14741
15431
4511
10230
15431
4511
19942
A/C 1 12%+3.67% A/C 2
1.1 %
1351
1351
46
A/C 10
8.33 %
10230
10230 614
OPEN
Apr-09
JOINING
May-09
0
A/C 21
0.5 %
614
LEFT
Apr-09
4
A/C 22
0.01%
12
12
15431
16718
32149
42798
12403
55201
CLOSING
42
STRENGTH
OPEN
A/C 1 12%+3.67%
265
JOINING LEFT
3717
A/C 10
8.33 %
28145
28145 1690
A/C 21
0.5 %
1690
0.01%
34
34
42798
45989
88787
42798
12403
28145
175
875 ------->
3717
A/C 22
Total of 875 & 192
DEPT
1.1 %
1
175
UNIT
A/C 2
91
CLOSING
MANOJKUMAR
TOTAL
337965
2250
40548
56638
E.S.I. STATEMENT FOR THE MONTH OF SEPTEMBER 2004 EMPL
SALARY
1.75%
4.75%
AD
25
78821
1379.60
PR
37
107951
1889.55
CH
43
112440
1968.10
TW
10
26125
457.45
115
325337
5694.70
0.00
0.00
115
325337.00
5694.70
15453.55
ROUND-OFF
0.75
5694.70
TOTAL
0.00
SUS. ALLW. ARR (-)
192 ------->
115
325337
AD
13
39465
690.85
PR
20
69758
1221.05
33
109223
21148.25
21149.00
15454.30
21149.00
21149.00
7100.00
7100.00 7100.00
0
CH
Total of Unit -- 875 & 192
5188.1 0.00
0
33
109223
1911.90
5188.10
7100.00
148
434560
7606.60
20642.40
28249.00
Please make cheque for P.F. Rs.
pf
1911.90 ROUND-OFF
0
88787 /-
E.S.I. Rs. 28249 /-
1 2
One Two
0
Rs.
Only esi
Rs.
0 0 0
Only
0 0 0 0
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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
Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Eighteen Nineteen Twenty Twentyone Twentytwo Twentythree Twentyfour Twentyfive Twentysix Twentyseven Twentyeight Twentynine Thirty Thirtyone Thirtytwo Thirtythree Thirtyfour Thirtyfive Thirtysix Thirtyseven Thirtyeight Thirtynine Forty Fortyone Fortytwo Fortythree Fortyfour Fortyfive Fortysix Fortyseven Fortyeight Fortynine Fifty Fiftyone Fiftytwo Fiftythree Fiftyfour Fiftyfive Fiftysix Fiftyseven Fiftyeight Fiftynine Sixty Sixtyone Sixtytwo Sixtythree Sixtyfour Sixtyfive Sixtysix Sixtyseven Sixtyeight Sixtynine Seventy Seventyone Seventytwo Seventythree Seventyfour Seventyfive Seventysix Seventyseven Seventyeight Seventynine Eighty Eightyone Eightytwo Eightythree Eightyfour Eightyfive Eightysix Eightyseven Eightyeight Eightynine Ninety Ninetyone Ninetytwo Ninetythree Ninetyfour Ninetyfive
96 97 98 99
Ninetysix Ninetyseven Ninetyeight Ninetynine
MONTHYEAR EM'EE 9 10 11 12 1 2 arr1 3 4 5 6 7 8
0 1 1 1 0 0 1 0 0 0 0 0 0 0 1 1 1
9 0 1 2 1 2 0 3 4 5 6 7 8 9 0 1 2
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7
591
WAGES 1408176
12% 170571
3.67% 51804
1.1%
8.33%
15490
117207
0.5% 7041
0.01% open join 140
424 181
left 14
close 591
BANK STATE BANK OF INDIA
CHEQUE 439997
DT OF CHEQUE 10/13/2003
DATE OF REMITANCE 10/17/2003
MONTH SEPTEMBER ' 2003 OCTOBER ' 2003 NOVERMBER ' 2003 DECEMBER '2003 JANUARY ' 2004 FEBURARY ' 2004 ARR OF OCTOBER' 2003 MARCH ' 2004 APRIL ' 2004 MAY ' 2004 JUNE ' 2004 JULY ' 2004 AUGUST ' 2004 SEPTEMBER ' 2004 OCTOBER ' 2004 NOVERMBER ' 2004 DECEMBER '2004
MONTH
ESI STRENGH
ESI-WAGE
E'EE CONTRI
E'ER CONTRI
TLT-CONTRI
DECEMBER '2007
247
670910
11744.55
31869.45
43614.00
1
JANUARY ' 2007
2
FEBURARY ' 2004
3
MARCH ' 2004
4
APRIL ' 2004
5
MAY ' 2004
6
JUNE ' 2004
7
JULY ' 2004
8
AUGUST ' 2004
9
SEPTEMBER ' 2004
0.00
10
OCTOBER ' 2004
0.00
11
NOVERMBER ' 2004
0.00
DECEMBER '2004
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CHEQUE NO
Dt. Of Cheque
bank
80321
1/10/2004
State Bank of India
ENTER MONTH :
8
COMBINED CHALLAN OF A/C No. 1,2,10,21 & 22 Original / Duplicate / Triplicate / Quadruplicate STATE BANK OF INDIA
EMPLOYEE'S PROVIDENT FUND ORGANISATION (USE SEPARATE CHALLAN FOR EACH MONTH)
HR / FD / 10381
ESTABLISHMENT CODE NO. DUES FOR THE MONTH OF:
ACCOUNT GROUP NO
Employees Share
0
Employer Share
TOTAL NO. OF SUBSCRIBERS TOTAL WAGES DUE SL. PARTICULARS
8
0
0
8
0
………...……
7 7
A/c 1
PAID BY CHEQUE / CASH D
DATE OF PAYMENT
D 19
A/c 10 A/C No. 1
A/C No 2. A/C No. 10 …………….……. AMOUNT
M
……………..……… M
6
Y
Y 2009
A/c 21 A/C No. 21 A/C No.22 ………...…………
TOTAL
(IN RUPEES)
1 EMPLOYER'S SHARE OF CONT.
0
2 EMPLOYEE'S SHARE OF CONT.
0
3 ADM. CHARGES
0
4 INSP. CHARGES 5 PENAL DAMAGES 6 MISC. PAYMENT (PAST ACCUMULATIONS ONLY) TOTAL
0 (AMOUNT IN WORDS) Rs.
0
Only [FOR BANK'S USE ONLY]
NAME OF ESTABLISHMENT:
MANOJ KUMAR
ADDRESS: GURGAON, HARAYANA. NAME OF DEPOSITOR ……………………………..…………………………………. SIGNATURE OF THE DEPOSITOR ………………...…………………………………
AMOUNT RECEIVED Rs……...………..……….. FOR CHEQUES ONLY….……………………….. DATE OF PRESENTATION………....……….….. DATE OF REALISATION ……………..…………. BRANCH NAME …….……...…….…...………….. BRANCH CODE NO………….….………………..
(TO BE FILLED IN BY EMPLOYER) NAME OF THE BANK -------------
-------- CHEQUE NO
--------------------------
DATE
6/19/2009 19
8 Original / Duplicate / Triplicate / Quadruplicate
E.S.I.C.
Challan No. ……..
Original / Duplicate / Triplicate / Quadruplicate
E.S.I.C.
Challan No. ……..
EMPLOYEE'S STATE INSURANCE FUND ACCOUNT NO.01
EMPLOYEE'S STATE INSURANCE FUND ACCOUNT NO.01
PAY-IN-SLIP FOR CONTRIBUTION
PAY-IN-SLIP FOR CONTRIBUTION
STATE BANK OF INDIA
STATE BANK OF INDIA
Station :Dundahera, Udyog Vihar, Gurgaon
Date
6/19/2009
Particulars of Cash / Cheque
Rs. P.
Cheque No.
/-
Station :Dundahera, Udyog Vihar, Gurgaon Particulars of Cash / Cheque
6/19/2009 Rs. P.
Cheque No.
/-
TOTAL
Date
/-
/-
TOTAL
Paid into the credit of the employee's State Insurance Fund A/c No.01 Rs. /Rupees: Rs. Only
Paid into the credit of the employee's State Insurance Fund A/c No.01 Rs. /Rupees: Rs. Only
in Cash / by Cheque (on realisation) for Payment of Contribution as per details given below under the Employee's State Insurance Act,1948 for the Month of :AUGUST ' 2004
in Cash / by Cheque (on realisation) for Payment of Contribution as per details given below under the Employee's State Insurance Act,1948 for the Month of :AUGUST ' 2004
: 13 / 24431 / 23 : MANOJ KUMAR
Employer's Code No Name & Address of Factory / Establishment
Deposited By
Employer's Code No Name & Address of Factory / Establishment
UDYOG VIHAR, GURAON - 122016 No. of Employee's
:
Total Wages
:
/-
Deposited By UDYOG VIHAR, GURAON - 122016
No. of Employee's
:
Total Wages
:
/-
Employee's Contribution Rs.
Employee's Contribution Rs.
Employer's Contribution Rs.
Employer's Contribution Rs.
Total Contribution Rs.
Total Contribution Rs.
(For use in Bank)
(To be filled by depositor)
(For use in Bank)
ACKNOWLEDGEMENT
drawn in State Insurance Fund Account No.01 Sl. No. in Bank's Scroll ………
(To be filled by depositor) ACKNOWLEDGEMENT
Err:502
Dated: …………………
: 13 / 24431 / 23 : MANOJ KUMAR
Err:502
in favour of Employee's
Authorised Signatory of the receiving Bank
drawn in State Insurance Fund Account No.01 Sl. No. in Bank's Scroll ………
Dated: …………………
in favour of Employee's
Authorised Signatory of the receiving Bank
lan No. ……..
01
6/19/2009 Rs. P. /-
/-
given below under
Deposited By
e filled by depositor)
avour of Employee's
horised Signatory the receiving Bank
8
FORM 12 - A ( REVISED)
Only for Un-Exempted Establishments
(To be filled in by the EPFO)
Employees' Provident Fund and Miscllaneous Provisions Act, 1952 Employees' Pension Scheme [Paragraph 20(4)]
Establishment Status Group Code.
Currency Period from 1st April 2004 to 31st March 2005
.
Statement of contributions for the month of AUGUST ' 2004 Statutory rate of contribution - 12% Name & Address of the Establishment M/s MANOJ KUMAR
Code No. HR / FD / 10381 GURGAON, HARYANA - 122016
PARTICULARS
Wages on which Contributions are Payable
Amount of Contribtion Recovered from the Workers
Amount of contribution Remitted
Payable by the Worker's Share Employer
Employer's Share
Amount of Administrative Charges Due
Amount of Administrative Charges Remitted
NIL
NIL
Date of Remittance (Enclose Triplicate copies of Challan)
E.P.F. A/c No.01
Pension Fund A/c No. 10
NIL
NIL
D.L.I. A/c No. 21
NIL
NIL
Total No. of Employee's (a)
Contract
5
(b)
Rest
0
(c)
Total
5
Details of Subscribers No. of subscribers as per last month No. of New subscribers (Vide Form 5) No. of subscribers left service (Vide Form 10)
Security Guards covered under code no. DL-5431 M/s S.D.S. Security Pvt. Ltd.
E.P.F.
Pension Fund
E.D.L.I.
Name & Address of the Bank in which the amount is remitted
State Bank of India Dundahera, Gurgaon Harayana - 122016
(Nett.) Total No. of Subscriber
0
0
0
Signature of the Employer with official (Seal)
ENTER MONTH :
10
COMBINED CHALLAN OF A/C No. 1,2,10,21 & 22 Original / Duplicate / Triplicate / Quadruplicate STATE BANK OF INDIA
EMPLOYEE'S PROVIDENT FUND ORGANISATION (USE SEPARATE CHALLAN FOR EACH MONTH)
Vide your Letter no HR / GGN / Circle: 1 / HR / 10381 / CA / 8050 Dt. 19-11-2003 under section 7Q and 14B ESTABLISHMENT CODE NO. HR / FD / 10381 ACCOUNT GROUP NO ………...…… PAID BY CHEQUE / CASH DUES FOR THE MONTH OF:
Employees Share
D DATE OF PAYMENT
Employer Share
TOTAL NO. OF SUBSCRIBERS TOTAL WAGES DUE
A/c 1
SL. PARTICULARS
D 26
M 11
A/c 10 A/C No. 1
M
……………..……… Y
Y 2003
A/c 21
A/C No 2. A/C No. 10 …………….……. AMOUNT
A/C No. 21 A/C No.22 ………...…………
TOTAL
(IN RUPEES)
1 EMPLOYER'S SHARE OF CONT.
0
2 EMPLOYEE'S SHARE OF CONT.
0
3 ADM. CHARGES
0
4 INSP. CHARGES
0
5 PENAL DAMAGES
129
4
8
69
6 MISC. PAYMENT (PAST ACCUMULATIONS ONLY) TOTAL
129
4
8
69
0
210
0
0
0
210
(AMOUNT IN WORDS) Rs. [FOR BANK'S USE ONLY] NAME OF ESTABLISHMENT:
MANOJ KUMAR
ADDRESS: GURGAON, HARAYANA. NAME OF DEPOSITOR ……………………………..…………………………………. SIGNATURE OF THE DEPOSITOR ………………...…………………………………
AMOUNT RECEIVED Rs……...………..……….. FOR CHEQUES ONLY….……………………….. DATE OF PRESENTATION………....……….….. DATE OF REALISATION ……………..…………. BRANCH NAME …….……...…….…...………….. BRANCH CODE NO………….….………………..
(TO BE FILLED IN BY EMPLOYER) NAME OF THE BANK -------------
-------- CHEQUE NO
--------------------------
DATE
VLOOKUP($H$2,DATA!$A$3:$AM$15,18,0)
6/19/2009 19