Automated PF Ledger

nitesh_barman
Hi,
This time it's "Automated PF Ledger"
Though there are many such kind of formats as well as software.
Still sharing with all of you.
Open Workbook and Enable Macros...
1. First of all on "Add/Edit Company Detail" add company details of your company.
2. Then on "Add/Edit Company Detail" there are few command buttons as Data Sheet, Data.. Click on Data Sheet and in that sheet you have to fill Employee Details as well as Monthly PF Deductions.
3.After doing that you will found that each forms are updated automatically.
4. As one Challan sheet just choose month on menu and all figures will change according to month.
5. Just that 3-A & 6-A also be updated automatically with that dbf format too.
So, first of all download it then make suggestion for it.
madhukarmc
its really usefull but then when you enter the email id it tells that its password protected can you tell us the password
Deeparaji
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.
nitesh_barman
I have removed the password protection from that e-mail id place. now you can add your id in place of that.
madhukarmc
first sheet after the contact number of the company and concerned person, it is showing your number & mail id
ngndrs
hi
In challan page expect the original sheet rest are not updating, even in original sheet bank details are reflecting as ICICI only .....
nitesh_barman
well all dear followers of citehr, i will make this sheet unprotected and will post it here, and i am not charging anything for it.
as some of dear followers are asking this.
i just ask suggestion, making this sheet worth or not ?
and Happy Holi to all of you...
nitesh_barman
There are some faults in that sheet, i will upload it after rectified it.
Hope all will understand this.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute