Dear All,
I was facing few problems because here I'm the one handling Account & Payroll together. So to make my work smarter, I created a sheet and named it PAYROLL MASTER. Salary, ESI, PF, Salary Sheet & Payslips all are connected with each other. You just need to put attendance, all the calculations will be done automatically. With the help of this one, all accounting & payroll entries can be done easily.
I hope you'll like my work.
Regards,
Azhar Ansari
From India, New Delhi
11I was facing few problems because here I'm the one handling Account & Payroll together. So to make my work smarter, I created a sheet and named it PAYROLL MASTER. Salary, ESI, PF, Salary Sheet & Payslips all are connected with each other. You just need to put attendance, all the calculations will be done automatically. With the help of this one, all accounting & payroll entries can be done easily.
I hope you'll like my work.
Regards,
Azhar Ansari
From India, New Delhi
Good job! All in one sheets linked with base sheet.. Very helpful for many people here..keep sharing
From India, Delhi
From India, Delhi
Hi Azahar,
Keep it up and thanks for sharing the XLS sheet. It is too helpfull so many people.
I have some query like how you can print salary slip....
Pls reply
Regards
Vinay Kumar
Chandigarh
9216105395
From India, Chandigarh
Keep it up and thanks for sharing the XLS sheet. It is too helpfull so many people.
I have some query like how you can print salary slip....
Pls reply
Regards
Vinay Kumar
Chandigarh
9216105395
From India, Chandigarh
Thanks to everyone for appreciating my work.
#RNM Consulatants - Sure, you can make changes as per your requirement. This one is based as per Delhi Govt Rules.
#Vinay Kumar - At the top, on Salary Slip sheet, there is numerical field. You just need to enter the serial numbers like 1, 2, 3 etc., then payslip will automatically changes the fields in in Salary Slips.
Regards,
Azhar Ansari
(M) +91-8860880991
New Delhi
From India, New Delhi
#RNM Consulatants - Sure, you can make changes as per your requirement. This one is based as per Delhi Govt Rules.
#Vinay Kumar - At the top, on Salary Slip sheet, there is numerical field. You just need to enter the serial numbers like 1, 2, 3 etc., then payslip will automatically changes the fields in in Salary Slips.
Regards,
Azhar Ansari
(M) +91-8860880991
New Delhi
From India, New Delhi
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.
Payroll.xls
Payroll.doc
Folklore Payroll.pdf