How To Calculate One Day Salary For 31days Month And 28 Days Month

santhosh srivatsav
Shenbagarajan is trying to explain the payroll in general. the others are posting what they are following blindly in their company.
@Sharmila, can u share the excel sheet for Feb or Mar where the month days are not 30. Bcoz in your sheet it is for Apr where the calculation is easy. the issue going on is for the above or below 30days in a month.
dhana.M
Hi brindha,
As per Mr.shenbagarajan,
Actual Salary = Gross Salary / No. of Days in the month * No of days worked + Week -off
which one is right?
please guide me.
thanks,
dhana
santhosh srivatsav
Dear Dhana,
forget about weak offs at first point. Shenbagarajan's explanation is against to only LOP or absent whatever you take for your understanding. only the absent days are to be deducted from the month.
Say 2 absents(unpaid leaves) in march for 10000 salary employee
the actual paid is 10000/31*29. as simple as it is. clearly deducting 2 absent days from 31days of the month.
k_shenbagarajan
Dear All,
Hope this excel will help you out. check and revert.
Not added the PF & ESI deduction. you just change the LOP the salary will be calculated automatically.
1 Attachment(s) [Login To View]

santhosh srivatsav
The attached by Shenbagarajan is generally accepted anywhere.
Else the companies are following differently from the beginning and the people joined after are simply following the previous sheet without knowing the actual process.
santhosh srivatsav
It is as per the IT rules, the same can be read in Tax laws.
Basic = As defined by the company
HRA = 40% or 50% of basic (non metros and metros respectively)
Transport Allowance = 800 per month
Medical Allownace - 1250 per month (Medical should be submitted else taxable component)
remaining can be shown as other allowance/book allowance/special allowance/ executive allowance whatever you call it as a taxable component.
dhana.M
Hi santhosh,
Thanks.
So for example If A:March Month: 27 days working days. here 10000/27*no.of days worked
10000/27 *27=10000
370.37*27=9999.99=>10000
Am i Rite?
thanks,
santhosh
shobananair
Dear Sir / Madam,
I am working in public motor transport company.we are following 28/29/30/31 days caluclation. scheduled employments in respect of which minimum rates of wages have been fixed for public motor transport worker is Rs.4750/ per month.
Please advice me what we are caluclating is correct or wrong
With Warm regards
Shobana
lakshmi87*
Hi
calculating salary can be done in two ways
1) gms / 30 (irrespective of actual no of days in the month)X acutal no of days payable,
2) gms / total no of days in the month X no of days payable
you should follow one formule forever. it may help to convince others. Normally, all companies follow 30 days commonly for all the months. Auditors also accept this procedure. otherwise it may lead to wrong calcuation.
santhosh srivatsav
No.
Per day salary is important when there are LOP's or someone joined in mid of the month. for that the formula should be 10000/31=323 perday. on this now pay for the days or deduct for the days as applicable for the month.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute