Dear HR Family,
I have been working for a telecom company as Executive-HR for last 6 months. i do prepare the salary statement in MS-Excel and providing the pay slips on MS-Word one by one.
Could you please help in - how can we generate the payslips along with the salary statement? is there any procedure for automotive pay slip generation along with Salary Statement?
As of now Our Company is not in a position to buy payroll software and all. So please suggest me that is there any short keys on MS-Excel to generate the payslips and prepare the salary statement at a time?
Regards,
Babu. P
Hyderabad.
From India, Hyderabad
2I have been working for a telecom company as Executive-HR for last 6 months. i do prepare the salary statement in MS-Excel and providing the pay slips on MS-Word one by one.
Could you please help in - how can we generate the payslips along with the salary statement? is there any procedure for automotive pay slip generation along with Salary Statement?
As of now Our Company is not in a position to buy payroll software and all. So please suggest me that is there any short keys on MS-Excel to generate the payslips and prepare the salary statement at a time?
Regards,
Babu. P
Hyderabad.
From India, Hyderabad
Hello Mr.Babu It is possible to prepare both the salary statement and Payslip process in Excel form.Here i am attaching the file hope it will be help U with regards lalita
From India, Kakinada
From India, Kakinada
Hi,
Use mail merge to get the payslips.You need enter the details in excel and prepare a payslip format in word and then do mail merge.You can generate 500 to 1000 payslips in 5 minutes.
Regards,
Ramanjaneya Reddy.G.K
From India, Bangalore
Use mail merge to get the payslips.You need enter the details in excel and prepare a payslip format in word and then do mail merge.You can generate 500 to 1000 payslips in 5 minutes.
Regards,
Ramanjaneya Reddy.G.K
From India, Bangalore
Hi Reddy, thank you so much for your suggestion. But i am not well aware of mail merge? can you plz explain about that? if i am not killing your valuable time...
From India, Hyderabad
From India, Hyderabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Monthly Salary Statement - CTC and TDS Calculator.xls
Salary -bank credit statement( A-C NO).pdf