.subbutton {border: none; overflow: hidden;cursor:hand;} HOME RISE NEW TEAM →|

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,,,

Thanks
Saravanan

balaram -  Member Since: Oct 2006
Dear Experts,

I have doubt. Till now in my experience we are considering 30 / 31 / 28 days as the basis for salary computation. Where as the actual wage should be 26 days only. even we calculate gratuity for 26 base only.

then my doubt is that while calculating..the lop and net salary which method should be followed and any rule / act to refer as under:

1. Earned Salary = Actual Gross / No. of total days in a month * Actual working days.

or
2. Earned Salary = Actual Gross / 26 * Actual Working Days.

which is the correct Method ? I have been asked by the management that when we are paying for 26 days (gratuity), why cannot we calculate for 26 days for payroll also instead of 30 / 31 days ...?

balaram

harshu1112 -  Member Since: Jul 2008
Hi All,

Herewith I am attaching a Salary sheet .

Salary Sheet Format.xls

siddarthasapra -  Member Since: May 2008
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.

aneev.hr3 -  Member Since: Jan 2007
Hi I am interested to know about this. Can you please send me the same to my mail id. Thanking you in advance. Regards, Veena e-mail id: veena_aneev@yahoo.co.in

devarajan_2k -  Member Since: Dec 2008
hi , im not able to download the attached excel sheet, pls forward one on my id — > raj_dev_2k@yahoo.com. i am attaching one sample herewith , pls check and correct if i m wrong. devarajan:-P

 Salary_break_up_calculator_(1).xls (17.5 KB, 5251 views)
sureshkumar_2040 -  Member Since: Aug 2008
Please send me the salary excel sheet format to my mail id sureshkumar_2040@yahoo.co.in suresh:confused:

sanny.P -  Member Since: Oct 2008
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

scrana -  Member Since: Dec 2008
Hi Please find the excel sheet with furmula of salary structure. Regards chennairana@gmail.com

 Salary Format.xls (36.5 KB, 3557 views)
parvindersachdeva -  Member Since: May 2009
hi please send me to my mail id hrd@ubxpress.in

POSTING RULES OF CONDUCT
• Do not post anything derogatory about any company or person.
• Sharing articles from other websites should be done by posting a link to the original article.
• To discuss sensitive issues create a pseudo/anonymous account.
• Please avoid repeat posting your company profile - such accounts are removed automatically.

• 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.

3M Users, 100K+ Documents & 450K+ Discussions

Share »

Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Community Support & Professional Insights. Login or Register.