Dear All,
I have been facing a few challenges as I am currently responsible for managing both Accounts and Payroll simultaneously. To streamline my workload, I have created a spreadsheet named "PAYROLL MASTER." This sheet is interconnected, encompassing Salary, ESI, PF, Salary Sheet, and Payslips. By simply inputting attendance data, all calculations are automatically processed. This tool simplifies the process of accounting and payroll entries.
I trust that you will find this initiative beneficial.
Regards,
Azhar Ansari
From India, New Delhi
Acknowledge(7)
Amend(0)
11I have been facing a few challenges as I am currently responsible for managing both Accounts and Payroll simultaneously. To streamline my workload, I have created a spreadsheet named "PAYROLL MASTER." This sheet is interconnected, encompassing Salary, ESI, PF, Salary Sheet, and Payslips. By simply inputting attendance data, all calculations are automatically processed. This tool simplifies the process of accounting and payroll entries.
I trust that you will find this initiative beneficial.
Regards,
Azhar Ansari
From India, New Delhi
Acknowledge(7)+2 more
Amend(0)
Hi Azahar,
Keep it up and thanks for sharing the XLS sheet. It is too helpful for so many people. I have a query regarding how you can print a salary slip.... Please reply.
Regards,
Vinay Kumar
Chandigarh
9216105395
From India, Chandigarh
Acknowledge(0)Amend(0)
Keep it up and thanks for sharing the XLS sheet. It is too helpful for so many people. I have a query regarding how you can print a salary slip.... Please reply.
Regards,
Vinay Kumar
Chandigarh
9216105395
From India, Chandigarh
Acknowledge(0)Amend(0)
Hello Azhar, Can we make changes this sheet as per our requirement.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Thanks to everyone for appreciating my work.
#RNM Consultants - Sure, you can make changes as per your requirement. This one is based on Delhi Govt Rules.
#Vinay Kumar - At the top, on the Salary Slip sheet, there is a numerical field. You just need to enter the serial numbers like 1, 2, 3, etc., then the payslip will automatically change the fields in the Salary Slips.
Regards, Azhar Ansari (M) +91-8860880991 New Delhi
From India, New Delhi
Acknowledge(0)Amend(0)
#RNM Consultants - Sure, you can make changes as per your requirement. This one is based on Delhi Govt Rules.
#Vinay Kumar - At the top, on the Salary Slip sheet, there is a numerical field. You just need to enter the serial numbers like 1, 2, 3, etc., then the payslip will automatically change the fields in the Salary Slips.
Regards, Azhar Ansari (M) +91-8860880991 New Delhi
From India, New Delhi
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.
Basics of Compensation Management.pdf
Compensation management.ppt