Dear HR Family,
I have been working for a telecom company as an Executive-HR for the last 6 months. I prepare the salary statement in MS-Excel and provide the payslips in MS-Word one by one.
Could you please help me with how to generate the payslips along with the salary statement? Is there a procedure for automated payslip generation along with the Salary Statement?
As of now, our company is not in a position to buy payroll software. Please suggest if there are any shortcuts in MS-Excel to generate the payslips and prepare the salary statement simultaneously.
Regards, Babu. P Hyderabad.
From India, Hyderabad
Acknowledge(0)
Amend(0)
2I have been working for a telecom company as an Executive-HR for the last 6 months. I prepare the salary statement in MS-Excel and provide the payslips in MS-Word one by one.
Could you please help me with how to generate the payslips along with the salary statement? Is there a procedure for automated payslip generation along with the Salary Statement?
As of now, our company is not in a position to buy payroll software. Please suggest if there are any shortcuts in MS-Excel to generate the payslips and prepare the salary statement simultaneously.
Regards, Babu. P Hyderabad.
From India, Hyderabad
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Kakinada
Acknowledge(0)Amend(0)
[QUOTE=BabuPaluru;1684222]Hi Lalita,
Please send me the requested copy. I am awaiting that sheet.
Hi,
Use mail merge to generate the payslips. You need to enter the details in Excel, prepare a payslip format in Word, and then perform the mail merge. This way, you can generate 500 to 1000 payslips in 5 minutes.
Regards,
Ramanjaneya Reddy.G.K
From India, Bangalore
Acknowledge(0)Amend(0)
Please send me the requested copy. I am awaiting that sheet.
Hi,
Use mail merge to generate the payslips. You need to enter the details in Excel, prepare a payslip format in Word, and then perform the mail merge. This way, you can generate 500 to 1000 payslips in 5 minutes.
Regards,
Ramanjaneya Reddy.G.K
From India, Bangalore
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of 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.
SALARY EXCEL.zip
Monthly Salary Statement - CTC and TDS Calculator.xls