View Poll Results: Is this helpful?
Yes 4 50.00%
Excellent very Useful 4 50.00%
More features required 0 0%
Voters: 8. You may not vote on this poll

Dear all,
Enclosed the zip file for your reference. U can use according to your organisation.
Usage : Update attendance, salary and verify.
  • In sal Stmt select all (Ctrl+A) copy and paste special as values.
  • Now go to word document and open, click yes (to update database).GO to Mailings in the document (OFF-07 users) change the company name logo at your convinience and and clik on finish and merge,select send mail messages and click ok.
This completes the operation(sal stmt,attandance and payslip generation).
31st October 2009 From India, Nizamabad

Attached Files
Membership is required for download. Create An Account First
File Type: zip (125.6 KB, 2706 views)

Hello Mani, can you please inform the steps in more detail for generating the sal stmt,attandance and payslip from those files you posted here using office 2007. Thanks.
1st November 2009 From India, Calcutta
please clear me below mentioned points
how does it calculate
is there any mandary % percentage formula from goverment of india
like x % of CTC is basic
x % of basic PF
x % of hra
x % of other allowance
My company deduct PF from my CTC how to calculate it then
my company gives education, and much other allowance in payslip
is there any percentage schemes if yes then how to get addition in those excel file
please let me know on
2nd November 2009 From India, Pune
Dear Sir,
I need some information on PF :
- What should be the minimum salary from which the PF is mandatory.
- What should be the maximum salary when PF becomes optional.
- what should be the employee strength of the organisation when PF becomes mandatory.
If anyone can give me information on the PF.

2nd November 2009 From India, Bangalore
Dear a2287884,
There is not mandatory % mentioned by GOI,but GOI Stated few rules/Acts like Minimum wages Act,Labour welfare Act,others for salary schemes.
All the companies will follow it relying on the nature of work.
U have stated that your Company deducts PF From your CTC (Cost To Company)according to company policy.
The CTC structure ,I think u have this details bcoz evry company will provide these details in the offer letter.
2nd November 2009 From India, Nizamabad
Dear Swaroop,
The minimum emp strength must be 20 to start PF for an organisation.
If the Basic is more than 6500 for all the employees in the organisation then company will send the nil return.
2nd November 2009 From India, Nizamabad
Dear Mani,
Thanks for the immediate reply.
But I thought minimum wages is Rs 3500/- gross salary.
When you say 6500 the basic does it mean it is 55% of the gross salary?
I understand that PF is applicable from a minimum salary of Rs 3500/- gross to Rs 6500/- gross salary.
Please guide me its confusing.
Pls reply me at

4th November 2009 From India, Bangalore
The Two Xls files are very useful for any organization, let it be small or big.
But the other 2 doc files could not work, may be due to absence of XLSM data base..or otherwise.
Thanks for the working excell file.
15th July 2010 From India, Hyderabad
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™