saravsist Started The Discussion:
Hi Guys,

I have to prepare the salary statement, can anyone help me how to calculate in excel and i need formula for basic by which keying gross salary and no of days present,,,

Please help me out,, its very urgent,,,

Thanks
Saravanan
Posted 3rd July 2008 From India, Ambala
Hi All,

Herewith I am attaching a Salary sheet .

Salary Sheet Format.xls


Hope this information would help you.
Posted 2nd August 2008 From India, Mumbai
I do not think there is any rule as to the dividing factor i.e. 31/30 or 26. It depends from organization to organization. Organizations either take 30 or 31 as they give advantage to the employees for LOP deductions. Presently, organizations like to be lenient because of intense competition. On the contrary most of the employees do not what dividing factor is considered while calculating LOP. But 26 days can be considered. For eg. If salary is 30,000, an organization stands to gain Rs.186 for one day's LOP, so if there are average 100 LOPS in an organization in one month, organization saves 18600 each month.
Posted 2nd August 2008 From India, Delhi
Hello HR Members, Here i am attaching the Excel Salary Format,U can Do Salaries in Excel.If u have any doubt in that u can contact to me throug My ID.sandhyahr.12@gmail.com Regards Sandhya
Posted 22nd January 2009 From India, Hyderabad
scrana 
Hi Please find the excel sheet with furmula of salary structure. Regards chennairana@gmail.com
Posted 22nd May 2009 From India, New Delhi
Attached Files
Shared By Cite.Community Member "scrana" For Public Download
File Type: xls Salary Format.xls (36.5 KB, 8223 views)
Sir,

My is Zubair Ansari please tell me All Excel formula results in Excel work all Excel formula write in Excel Sheet Fully tips & tricks to write on excel which formulas work this. Mere kahane ka matalab hai mujhe chahiye ki aap excel main jitne bhi formula hai uski working karke excel sheet par de koan sa formula kis kaam main aata hai koan sa kis kam main ye sare formula excel sheet par with formula show karte hue mujhe dene ki kripya karein main aapka jivanbhar ehsanmand rahuinga bas inhi formula ki wajah se main koi aachi job bhi kar paraha huin. Ek baar to ek company ka job ka offer aaya tha lekin excel must maang rahe aur salary 10,000 se 15000 tak de rahe the. lekin formula ka issued main puri tarah se nahi janta please mujhe puri working ke saath excel sheet par formula lagane ki tricks & trips batain aapka main jivanbhar ehsaanmand rahuinga. AAPKA shagird:idea:
Posted 31st August 2009 From India, Ghaziabad
SAK_82 
Hi,

Could you plz let me know in detail like Calculation of SALARY ie. Basic pay , DA , HRA etc in terms of percentages (as against CTC) for ex: 50% of CTC is taken as HRA , etc. Plz reply me soon and e-mail me to this ID :

Regards,
SAK_82
Posted 20th January 2010 From India, Hyderabad
hi all, Pls tell me, can we breakup the minimum wages or not under labour act, if yes what is the formula for calculation.
Posted 13th August 2010 From India, Delhi
thank you.. it is very easy to understand for every one.. i got knowledge after viewing this calculations.
Posted 13th August 2010 From India, Hyderabad
Hi, Plz find enclosed herewith salary sheets format as per your requirement. Hope this will help you to know.
Posted 13th August 2010 From India, Nasik
Attached Files
Shared By Cite.Community Member "Ganesh Chavan" For Public Download
File Type: xls Salary Sheet.xls (28.5 KB, 1146 views)
Hi, Plz find enclosed herewith Salary Sheet format as per your requirement. Hope this will help all of you to know.
Posted 13th August 2010 From India, Nasik
Attached Files
Shared By Cite.Community Member "Ganesh Chavan" For Public Download
File Type: xls Salary Sheet.xls (28.5 KB, 695 views)
Dear Guys, Thanks for your responses, i have posted a new thread, please look into this, saravanan
Posted 18th August 2010 From India, Ambala
hello everyone, I m vijay. Can anybody elaborate the meaning of the salary of Rs.9300-34800,Grade pay Rs.4200 & applicable allowances as per companies rules.??????
Posted 23rd August 2010 From India, Mumbai
Please send me the salary structure for plastic industry including basic, da, gross and deductions like pf pt etc. Regards, Ajit
Posted 7th August 2012 From India, Aurangabad
if the salary 21711 salry what wuld be the ctc


BASIC-10,001
Special Allw- 5,031
Conveyance- 800
HRA- 5,001
Medical Allw- 1,250
LTA- 833

Gross Salary- 22916

PF- 1250

bASe- salary- 24116

as per the above details what can be salry hike can be get
Posted 3rd September 2012 From India, Mumbai
Hi

am arunsinh

anything pl. guide me I have one query about counting salary

One new employee starting working 17th sep. in organisation
and inbetween 2 w/o fall on his total salary monthly 49270 so ( which type working day divide) we calculate

pl guide, and my counting is 28 day divide and one day salary and 12 working day + 2 w/o
made his salary correct or not
Posted 8th October 2012 From India, Nagpur
Dear Balram, As you are aware that in a month we will not calculate W\'off as working days. Only for PF and ESI only we will calculate on 31/30 /28 days. We can calculate the salaries on 26 days.
Posted 8th October 2012 From India, Hyderabad
how to deduct tds for employess. also i need to know what is the basis salary , how to deduct PF and ESI to employees. we are industrial automation based company
Posted 3rd May 2016 From India, undefined
Rajsvr 
Hi Saravanan,

Greetings from greytHR.

I would like to introduce greytHR is india,s leading cloud based HR & payroll service provider. Now no need to worry
about payslips, Just clicking one button you will generate payslip.

Kindly go through our website www.greytHR.com or click the below link for free software.
https://www.greythr.com/signup/?utm_...tm_campaign=ad

Regards,
Raj
Posted 3rd May 2016 From India, Bengaluru
Rajsvr 
Hi Saravanan,

Greetings from greytHR.

I would like to introduce greytHR is india,s leading cloud based HR & payroll service provider. Now no need to worry
about payslips, Just clicking one button you will generate payslip.

Kindly go through our website www.greytHR.com or click the below link for free software.
https://www.greythr.com/signup/?utm_...tm_campaign=ad

Regards,
Raj
Posted 3rd May 2016 From India, Bengaluru



 
 
 
 







Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network