Ready-to-Print PF Form-5 (Fully Automated)
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Human Resource Management

Ready-to-Print PF Form-5 (Fully Automated)

M.Peer Mohamed Sardhar Started The Discussion:

Dear HR Faternity,

Filling out EPF Forms, whether handwritten or on a PC
is a tedious task, especially when the attrition is
substantial. To make the life of my buddies
comfortable, attached pl. find “AUTOMATED” Form 5. The
form shall be generated at a click of a button.

The form can have a maximum of 15 employees. As with
any software, you have to follow certain rules. Follow
the rules and you shall get the forms in around 15 to
30 seconds flat. (Depending on the configuration of
your PC, the amount of data to be entered viz.
attrition etc).

1. To generate the forms, you MUST maintain the
Employee Master as per attached sample file
“Dummy_Emploee_Master-07-08.xls” (Source File – Name
of the file may be different).
a. The first record MUST appear on row no. 18.
b. Do not change the names of sheets (i. e.
Employee_Records and Resignations).
c. DO NOT delete the sheet named “Template”.
d. If the format of the source file is changed, you
will not get the proper output.
2. Before you generate the form, ensure that the
source file is closed. You will not get the proper
output if the source file is open. The source file
shall open automatically when you generate Form 5 and
10 and close automatically.
3. The form is setup for a standard A4 paper.
4. Open the file “Form-5.xls”
5. Make sure that the macros security is set to
“medium”. To do this do the following:
a. Go to Tools -> Macros ->Security.
b. Click the Medium radio button.
c. This shall ensure that you get a message to enable
the macros when you open the workbook.
6. Enable the macros. If you disable the macros, you
will not get results.
7. You shall be prompted to choose the Source File.
Choose the source file which forms an input.
8. Run the macro. Press <Alt>+<F8> and click <Run>
9. You shall be prompted for the month and year for
which the form is to be generated.
10. Choose the Month & Year & keep your fingures
crossed.
11. The desired form shall be generated.
12. The only shortcoming in this form is that you will
have to put in the PF nos. manually. I shall update
the code and post ASAP.

I have a few records in the source file. Pl. generate
the form-5 for the month of September 2007 before you
decide to use this.

Courtesy,,,, Mr.Deepak Kanade...


Attached FilesProvided by community member M.Peer Mohamed Sardhar. Join us to learn and grow with your peers.
File Type: xls form-5_687.xls (114.0 KB, 3064 views)
File Type: xls dummy_emploee_master-07-08_565.xls (151.0 KB, 1562 views)
anju.mnjl@gmail.com - Member Since: Apr 2009
Hello, which form is to be filled at the time of new joining by an Employee for PF enrolment.

Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


5525
VIEWS

1
REPLY

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network