Dear All,
I am very glad to post my first assignment on CiteHR. I have been using this site for more than 4 months, and I am very happy with the information it provides on Admin, HR, Accounts, and Management. Especially, I enjoy the content related to management, personality development, and motivating presentations.
Now, it is my turn. I am attaching this Excel sheet. I am confident that you, good people, will really admire my work.
I have created this Excel sheet using VLOOKUP command and other functions. I assure you that these functions will definitely help you understand how to use the VLOOKUP command in Excel and its benefits.
I have highlighted some cells in yellow; you just need to input the necessary information in those cells.
Simply input the attendance in the Attendance sheet, and it will generate the Salary Sheet, Payslip, Bank List, PF ESIC Deduction List, and PT summary.
I am eagerly awaiting your responses and suggestions. I am also looking forward to new assignments from you.
I will update this Excel file regularly and post it on this site.
PASSWORD FOR FILE IS - 090909
Thanks & Regards,
(My email ID is sandeepmore_finance@rediffmail.com)
From India, Mumbai
Acknowledge(0)
Amend(0)
53I am very glad to post my first assignment on CiteHR. I have been using this site for more than 4 months, and I am very happy with the information it provides on Admin, HR, Accounts, and Management. Especially, I enjoy the content related to management, personality development, and motivating presentations.
Now, it is my turn. I am attaching this Excel sheet. I am confident that you, good people, will really admire my work.
I have created this Excel sheet using VLOOKUP command and other functions. I assure you that these functions will definitely help you understand how to use the VLOOKUP command in Excel and its benefits.
I have highlighted some cells in yellow; you just need to input the necessary information in those cells.
Simply input the attendance in the Attendance sheet, and it will generate the Salary Sheet, Payslip, Bank List, PF ESIC Deduction List, and PT summary.
I am eagerly awaiting your responses and suggestions. I am also looking forward to new assignments from you.
I will update this Excel file regularly and post it on this site.
PASSWORD FOR FILE IS - 090909
Thanks & Regards,
(My email ID is sandeepmore_finance@rediffmail.com)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Sandeep, the product seems to be good. keep up the good work. Kind regards, ASIF DANWAD
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
dear sandeep i downloaded the excel file but it says excel sheet is protected and asks password , pl help me rgds voichal
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
This is very nice data & valuable for everyone, you should be appricated for this by everyone, but plz. take care you are sharing valuable salary data which is confedential, plz. take care.
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Hi Sandeep I will really appriciate your great work.Its really helpful for processing of salary and the statutory also. Keep in touch..... Regards Manjunath Human Resources PSK Engg.Pvt.Ltd Bangalore
From India, Kochi
Acknowledge(0)Amend(0)
From India, Kochi
Acknowledge(0)Amend(0)
Started with Excellent,Fabulous,Awesome work Sandeep! no more words to express Get going Cheerz Jeeva
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Sandeep,
This is really good work, and thank you very much for your effort. I believe it needs some improvement, such as if an employee's salary attendance is not for a full month, then we need to calculate their salary manually and enter it into the sheet. It would be extremely beneficial if the number of days entered in the attendance sheet could be calculated automatically.
Overall, the work is excellent.
Thank you.
From India, Gurgaon
Acknowledge(0)Amend(0)
This is really good work, and thank you very much for your effort. I believe it needs some improvement, such as if an employee's salary attendance is not for a full month, then we need to calculate their salary manually and enter it into the sheet. It would be extremely beneficial if the number of days entered in the attendance sheet could be calculated automatically.
Overall, the work is excellent.
Thank you.
From India, Gurgaon
Acknowledge(0)Amend(0)
Hi,
The posting is very useful. In fact, I was looking for something like this. It would be a great help if you could prepare Form-16 as well as the full and final statement in this Excel sheet (it's just a suggestion).
Thank you.
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
The posting is very useful. In fact, I was looking for something like this. It would be a great help if you could prepare Form-16 as well as the full and final statement in this Excel sheet (it's just a suggestion).
Thank you.
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
Hi Vishal,
Could you please clarify if the TDS is deducted every month from the employee's salary or if it is deducted once a year? Additionally, could you describe the process of calculating TDS from an employee's salary in an industrial company?
Regards,
Vishal Harjani
From India, New Delhi
Acknowledge(0)Amend(0)
Could you please clarify if the TDS is deducted every month from the employee's salary or if it is deducted once a year? Additionally, could you describe the process of calculating TDS from an employee's salary in an industrial company?
Regards,
Vishal Harjani
From India, New Delhi
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.