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,,,
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.
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 ...?
Herewith I am attaching a Salary sheet .
Salary Sheet Format.xls
Hope this information would help you.
Why Vote? User validation is extremely important for good content to prosper.