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(2)
Amend(0)
From India, Kakinada
Acknowledge(2)Amend(0)
Hi Lalita, please send me the requested copy. I am awaiting that sheet.
Using Mail Merge for Payslip Generation
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)
Using Mail Merge for Payslip Generation
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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY EXCEL.zip
Monthly Salary Statement - CTC and TDS Calculator.xls
Salary -bank credit statement( A-C NO).pdf