Dear Friends
I am using Excel for preparing Salary Statements.I want to know
how excel can be used to prepare payslips automatically.Can
any one tell me the process/function which is used to convert
salary statement into salary slips.I am expecting a quick and
positive response from you....Please help me friends....:-P
Thanks In advance
BINU.M.S
From India, Thiruvananthapuram
Acknowledge(0)
Amend(0)
I am using Excel for preparing Salary Statements.I want to know
how excel can be used to prepare payslips automatically.Can
any one tell me the process/function which is used to convert
salary statement into salary slips.I am expecting a quick and
positive response from you....Please help me friends....:-P
Thanks In advance
BINU.M.S
From India, Thiruvananthapuram
Acknowledge(0)Amend(0)
Hi,
lets see if I can help you a bit.
suppose if you are preparing salary statement in "SHEET1" then in sheet 2
you first prepare a salary slip format what information you want viz, basic, hra,cca etc.
and just link the particular cell with sheet 1.
I hope you got it.
Bye..............Joydeep
From India, Bhopal
Acknowledge(0)Amend(0)
2lets see if I can help you a bit.
suppose if you are preparing salary statement in "SHEET1" then in sheet 2
you first prepare a salary slip format what information you want viz, basic, hra,cca etc.
and just link the particular cell with sheet 1.
I hope you got it.
Bye..............Joydeep
From India, Bhopal
Acknowledge(0)Amend(0)
hello, heres a format which will help you in preparing a salary slip........... pls check it out...i hope this will be of your help.................
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
hi all, This is kd bakshi. I am joining today and anticipate a good help from u all . My self is master in management sciences and law graduate from pune
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
Hi,
Today I have joined.
In my office I am maintaining the salary statements in excel 2003. In my office during the Durga Puja Festival , an amount of Rs.2000.00 is paid to each grade IV employee(Peon) with the condition that the entire advance will be recovered in ten equal instalments @ Rs.200 from the salary .
I want to make it such a way that after recovering the advances @Rs. 200.00 per moth for 10 months , in the 11th monts this should be Zero automatically.
Kindly help me pleade.
waiting for reply eagerly. Further querry in the matter is highly appreciated.
Thanks in advance.
jhini000
From India, Guwahati
Acknowledge(0)Amend(0)
Today I have joined.
In my office I am maintaining the salary statements in excel 2003. In my office during the Durga Puja Festival , an amount of Rs.2000.00 is paid to each grade IV employee(Peon) with the condition that the entire advance will be recovered in ten equal instalments @ Rs.200 from the salary .
I want to make it such a way that after recovering the advances @Rs. 200.00 per moth for 10 months , in the 11th monts this should be Zero automatically.
Kindly help me pleade.
waiting for reply eagerly. Further querry in the matter is highly appreciated.
Thanks in advance.
jhini000
From India, Guwahati
Acknowledge(0)Amend(0)
Dear all,
In our company, approximately 200 people are currently employed. They have been requesting their salary payslips; however, our salary processing system is taking longer than usual. This delay is making it challenging to manage our employees effectively. I kindly request anyone who knows an easier method to create payslips to please discuss it with me. I am hopeful for a clear solution from your end.
Thanks and Regards,
UDAY
From India, Bangalore
Acknowledge(0)Amend(0)
In our company, approximately 200 people are currently employed. They have been requesting their salary payslips; however, our salary processing system is taking longer than usual. This delay is making it challenging to manage our employees effectively. I kindly request anyone who knows an easier method to create payslips to please discuss it with me. I am hopeful for a clear solution from your end.
Thanks and Regards,
UDAY
From India, Bangalore
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Salary-Note.doc
SALARY SHEET CALCULATION.xls