I want to develop an Payslip/salary slip for my company employess in the following ways:
1) pay slip generation (Excel) and
2) conver to PDF automatically(if possible) (or i can do manually and split each and every page)
3) PDF should be protected/secured with there pan num/DOB or any password that should not be the same to each and every employees it a one time password.
hi
except last step, you can do so by VBA
is it fine?
To generate Pay Slip in Excel, please visit my blog site :
https://getmis.weebly.com/mis-blog/new-post
Ensure that you have installed Excel2007 or higer version. The pay slip format considered in this file can be customised as per your requirement. Please leave a comment in my blog for any clarification.
Import attendance data from excel to Tally using udi-Magic Software.
Download link : https://www.rtslink.com/downloads
For more information refer : https://www.udimagic.com
As an employer, your payslip needs to be designed in consultation with your HR, your CA or your accounts person. Otherwise, you can have a look at some of the following samples of Salary Slip formats and pick the one you think you need. They’re in Excel, Word, and PDF formats.
CAclubindia
