My joining date 1st august 2019.
As per offer letter
Basic :11246
HRA :2856
Statutory bonus :1800
Gross salary :15902
--------------------------------
Company PF contri :1350
Gratuity :541
Mediclaim self :208
--------------------------------------
Total CTC :18000
In below terms mentioned ESIC deduction as 517rs as company esic contri
My aug month deduction as follow
Present days:31
Basic :11246
HRA :2922
STATUTORY BONUS :2250
GROSS :16418
-----------------------------------------
Deduction
PF :1350
PT :200
ESIC :124
------------------
Total deduction :1674
Inhand salary :14744
------------------------------------------------
September salary split up
present days 30
Basic :11246
HRA :787
Miscc allow :2092
STATUTORY BONUS :2250
GROSS :16375
-----------------------------------------
Deduction
PF :1601
PT :200
ESIC :124
mediclaim :208
------------------
Total deduction :2132
Inhand salary :14243
-----------------------------------------
October slip
present days :31
Basic :11246
HRA :787
Miscc allow :2092
STATUTORY BONUS :2250
GROSS :16375
-----------------------------------------
Deduction
PF :1601
PT :200
ESIC :124
mediclaim :208
------------------
Total deduction :2132
Inhand salary :14243
Each month I find different pattern in salary slip.In all 3 month I was present all days
Please some one guide me on urgent basis. There are Different HRA every month ,Sometimes miscellaneous allowance added sometimes not. different in hand each month
Please share salary slip calculation excel sheet base on present days. ( for employee not HR )
All expert HR .Please help me in above scenarios.
From India
As per offer letter
Basic :11246
HRA :2856
Statutory bonus :1800
Gross salary :15902
--------------------------------
Company PF contri :1350
Gratuity :541
Mediclaim self :208
--------------------------------------
Total CTC :18000
In below terms mentioned ESIC deduction as 517rs as company esic contri
My aug month deduction as follow
Present days:31
Basic :11246
HRA :2922
STATUTORY BONUS :2250
GROSS :16418
-----------------------------------------
Deduction
PF :1350
PT :200
ESIC :124
------------------
Total deduction :1674
Inhand salary :14744
------------------------------------------------
September salary split up
present days 30
Basic :11246
HRA :787
Miscc allow :2092
STATUTORY BONUS :2250
GROSS :16375
-----------------------------------------
Deduction
PF :1601
PT :200
ESIC :124
mediclaim :208
------------------
Total deduction :2132
Inhand salary :14243
-----------------------------------------
October slip
present days :31
Basic :11246
HRA :787
Miscc allow :2092
STATUTORY BONUS :2250
GROSS :16375
-----------------------------------------
Deduction
PF :1601
PT :200
ESIC :124
mediclaim :208
------------------
Total deduction :2132
Inhand salary :14243
Each month I find different pattern in salary slip.In all 3 month I was present all days
Please some one guide me on urgent basis. There are Different HRA every month ,Sometimes miscellaneous allowance added sometimes not. different in hand each month
Please share salary slip calculation excel sheet base on present days. ( for employee not HR )
All expert HR .Please help me in above scenarios.
From India
It appears from your submission that your organization like many other organization has also restructured the remuneration pattern based on Supreme Court Verdict-Feb,2019. That is the reason for different pattern of pay slips in different months. You Organization should communicate the same to the employees before implementation.
Even in your restructured remuneration there is 3 pockets of which one is Statutory Bonus 1800/- per month appears to me indifferent as statutory bonus ( Bonus under the payment of Bonus act) is paid annually . Instead there may be two pockets - Basic and HRA.
S K Bandyopadhyay ( Howrah, WB)
From India, New Delhi
337Even in your restructured remuneration there is 3 pockets of which one is Statutory Bonus 1800/- per month appears to me indifferent as statutory bonus ( Bonus under the payment of Bonus act) is paid annually . Instead there may be two pockets - Basic and HRA.
S K Bandyopadhyay ( Howrah, WB)
From India, New Delhi
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 slip calculation.xls