Sound become music, Movement becomes dance, S mile becomes laughter Life becomes celebratio n.When old friend keep in touch.H.DIWALI MOHD RAFI password - 090909
From India, Indore
From India, Indore
Its godd but please check that esi has been deducting to those employees who are drawing 10000 and below but as per the ammendent it was raised to 15000 please check, but the work quiet appreciable..
From India, Anantapur
20From India, Anantapur
[QUOTE=sandeepmore_finance;865804]Dear All,
I am very glad to post my first assignment on CiteHR. I have use this site more than 4 months and I am very happy with this site which give me large information on Admin, HR, Accounts and Management. Specially I like management, personality development and motivating presentations.
Now it is my turn, So I am attaching this excel sheet. I am confident that you good people will really admire my work.
I have made this excel sheet using Vlookup command and other commands and I assure that these commands will definately help you how to use Vlookup command in excel and its benefits.
I have highlighted some cells in yellow, you just put necessary information in that cell.
You just put attendance in Attadance sheet and it will create Salary Sheet, Pay slip, Bank List, PF ESIC Deduction List and PT summary.
I am eagerly waiting for your response and suggestions. Also I am waiting for new assignments from you.
I will update this excel file time to time and post it on this site.
PASSWORD FOR FILE IS - 090909
:)Thanks & Regards,
The sheet posted by you is really very useful.. great work !!
From India, Mumbai
I am very glad to post my first assignment on CiteHR. I have use this site more than 4 months and I am very happy with this site which give me large information on Admin, HR, Accounts and Management. Specially I like management, personality development and motivating presentations.
Now it is my turn, So I am attaching this excel sheet. I am confident that you good people will really admire my work.
I have made this excel sheet using Vlookup command and other commands and I assure that these commands will definately help you how to use Vlookup command in excel and its benefits.
I have highlighted some cells in yellow, you just put necessary information in that cell.
You just put attendance in Attadance sheet and it will create Salary Sheet, Pay slip, Bank List, PF ESIC Deduction List and PT summary.
I am eagerly waiting for your response and suggestions. Also I am waiting for new assignments from you.
I will update this excel file time to time and post it on this site.
PASSWORD FOR FILE IS - 090909
:)Thanks & Regards,
The sheet posted by you is really very useful.. great work !!
From India, Mumbai
Good job done keep it up. Good job done keep it up. Good job done keep it up. Good job done keep it up. Good job done keep it up. Good job done keep it up.
From India, Pune
From India, Pune
Dear Sandeep , Appreciate your work but i was looking for a sheet in excel so i can see the whole year salary of all employee in one sheet. Thanks Gaurav
From India, Jaipur
From India, Jaipur
Hi, Sandeep, Appreciate your efforts. salary sheet is protect pls give password. .Regards RAJENDRAN
From India, Pune
From India, Pune
I want atleast 5 salary sheets in excel
1 in which all calculations are done like pf esi on monthly basis
2 in which calculations are done on per day wages act
3 in which ctc is defined and all calculations done
4 calculations done on the basis of lop days and total no of paid days
please send me these formats as soon as possible
thank you
From India, Chandigarh
1 in which all calculations are done like pf esi on monthly basis
2 in which calculations are done on per day wages act
3 in which ctc is defined and all calculations done
4 calculations done on the basis of lop days and total no of paid days
please send me these formats as soon as possible
thank you
From India, Chandigarh
Hi, Sandeep, Appreciate your efforts. salary sheet is protect pls give password. text me by Mail. beeresh47@gmail.com
From India, Bijapur
From India, Bijapur
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.
SALARY SHEET CALCULATION.xls