Dear HR Folks,

Please find attached the P.F. monthly and yearly returns sheet. Below is an explanation of the data handling process:

- Database: Enter P.F. Code, name of the employees, and their respective basic salary in the designated fields.
- Challan: Update the cell address every month with the data from the database.
- Form 12A: No changes required as it automatically updates with the Challan figures.
- Form 6A: Copy and paste the Employee Code and Employee name from the database sheet to compile the yearly contribution of each employee.
- Monthly Covering letter: No changes needed as it is based on the Challan data.
- Yearly returns covering letter: No modifications necessary.
- Challan yearly: No changes needed as it is derived from the database.

I believe this process is clear to everyone and will provide convenience for monthly and yearly returns. By dedicating just half an hour monthly, you can generate the required output efficiently.

For any queries, please feel free to contact me at 09959499969.

Regards,
Suraj Varma

From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls P.F MONTHLY & YEARLY.xls (1.33 MB, 3932 views)

Acknowledge(0)
Amend(0)

Dear Mr. Verma,

It shows continual improvement which enhances knowledge and skills, so we should look forward to further assignments because learning can never be stopped.

Warm Wishes, :)

From-
Vijay Vashisth
HR Head
09812596141


From India, Jaipur
Acknowledge(0)
Amend(0)

I am new to the HR field. Can you please guide me? Can you send a sample filled various forms of:
Form-6A
Form-19: To claim final settlement of Provident Fund by a member.
Form-20: To claim Provident Fund by nominee/legal heir on the death of the member.
Form-10-D: To claim a pension. (In duplicate: If within the state, In triplicate: If outside the state.)
Form-10-C: To claim withdrawal benefit/scheme certificate under Employees' Pension Scheme '95.
Form-5IF: To claim assurance benefit under Employees' Deposit Linked Insurance '76 by nominee/legal heir of a member.
Form-31: To claim temporary withdrawal/advance under Employees' Provident Fund scheme.
Email:

Thanks,
Sunita


Acknowledge(0)
Amend(0)

dear sir i am palak jain account exceutive in pvt company i have no good knowledge of computer byt i try to my best i have attached a very easy attandance sheet your p f file is too good thank you
From India, Vadodara
Attached Files (Download Requires Membership)
File Type: xls ATTANDENCE SHEET NOV 010.xls (41.0 KB, 844 views)

Acknowledge(0)
Amend(0)

Dear All How to settle P.F of Absconding or workmen left the site without any information. please guide me in this regard Thank You Rajnish
From India, Bangalore
Acknowledge(0)
Amend(0)

Dear All Please inform me how to settle P.F of absconding/workmen left site without intimation. Regards Rajnish
From India, Bangalore
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.