Hi,
This time it's "Automated PF Ledger." Though there are many such kinds of formats as well as software, I am still sharing this with all of you.
Open the workbook and enable macros:
1. First of all, on "Add/Edit Company Detail," add the company details of your company.
2. Then, on "Add/Edit Company Detail," there are a few command buttons such as Data Sheet, Data... Click on Data Sheet, and in that sheet, you have to fill in Employee Details as well as Monthly PF Deductions.
3. After doing that, you will find that each form is updated automatically.
4. On the Challan sheet, just choose the month in the menu, and all figures will change according to the month.
5. Just like that, 3-A & 6-A will also be updated automatically with the DBF format too.
So, first of all, download it, then make suggestions for it.
From India, Jaipur
Acknowledge(0)
Amend(0)
83This time it's "Automated PF Ledger." Though there are many such kinds of formats as well as software, I am still sharing this with all of you.
Open the workbook and enable macros:
1. First of all, on "Add/Edit Company Detail," add the company details of your company.
2. Then, on "Add/Edit Company Detail," there are a few command buttons such as Data Sheet, Data... Click on Data Sheet, and in that sheet, you have to fill in Employee Details as well as Monthly PF Deductions.
3. After doing that, you will find that each form is updated automatically.
4. On the Challan sheet, just choose the month in the menu, and all figures will change according to the month.
5. Just like that, 3-A & 6-A will also be updated automatically with the DBF format too.
So, first of all, download it, then make suggestions for it.
From India, Jaipur
Acknowledge(0)Amend(0)
its really usefull but then when you enter the email id it tells that its password protected can you tell us the password
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
HI nitheesh, I want to remove the mail id and have to put my office mail ID. I tried to remove that, it s not working, and it shows to enter the password.
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
I have removed the password protection from that e-mail id place. now you can add your id in place of that.
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
first sheet after the contact number of the company and concerned person, it is showing your number & mail id
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
hi In challan page expect the original sheet rest are not updating, even in original sheet bank details are reflecting as ICICI only .....
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Dear followers of CiteHR,
I will make this sheet unprotected and post it here. I am not charging anything for it, as some of you have been asking for it. I just ask for suggestions - is making this sheet worth it or not?
Happy Holi to all of you...
From India, Jaipur
Acknowledge(0)Amend(0)
I will make this sheet unprotected and post it here. I am not charging anything for it, as some of you have been asking for it. I just ask for suggestions - is making this sheet worth it or not?
Happy Holi to all of you...
From India, Jaipur
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Automated PF Ledger.xls