My joining date is 1st August 2019. As per the offer letter:
- Basic: 11246
- HRA: 2856
- Statutory bonus: 1800
- Gross salary: 15902
Company PF contribution: 1350
Gratuity: 541
Mediclaim self: 208
Total CTC: 18000
In the terms mentioned below, ESIC deduction is 517rs as company ESIC contribution. For my August month deduction, the details are as follows:
- Present days: 31
- Basic: 11246
- HRA: 2922
- Statutory Bonus: 2250
- Gross: 16418
Deductions:
- PF: 1350
- PT: 200
- ESIC: 124
Total deduction: 1674
Inhand salary: 14744
For September salary split up:
- Present days: 30
- Basic: 11246
- HRA: 787
- Misc allowance: 2092
- Statutory Bonus: 2250
- Gross: 16375
Deductions:
- PF: 1601
- PT: 200
- ESIC: 124
- Mediclaim: 208
Total deduction: 2132
Inhand salary: 14243
For October payslip:
- Present days: 31
- Basic: 11246
- HRA: 787
- Misc allowance: 2092
- Statutory Bonus: 2250
- Gross: 16375
Deductions:
- PF: 1601
- PT: 200
- ESIC: 124
- Mediclaim: 208
Total deduction: 2132
Inhand salary: 14243
Each month, I find a different pattern in the salary slip. In all three months, I was present all days. Can someone guide me urgently? There are different HRAs every month, sometimes miscellaneous allowance is added, sometimes not, resulting in a different in-hand amount each month. Please share the salary slip calculation in an Excel sheet based on present days. (For the employee, not HR). All expert HR personnel, please help me in the above scenarios.
From India
Acknowledge(0)
Amend(0)
- Basic: 11246
- HRA: 2856
- Statutory bonus: 1800
- Gross salary: 15902
Company PF contribution: 1350
Gratuity: 541
Mediclaim self: 208
Total CTC: 18000
In the terms mentioned below, ESIC deduction is 517rs as company ESIC contribution. For my August month deduction, the details are as follows:
- Present days: 31
- Basic: 11246
- HRA: 2922
- Statutory Bonus: 2250
- Gross: 16418
Deductions:
- PF: 1350
- PT: 200
- ESIC: 124
Total deduction: 1674
Inhand salary: 14744
For September salary split up:
- Present days: 30
- Basic: 11246
- HRA: 787
- Misc allowance: 2092
- Statutory Bonus: 2250
- Gross: 16375
Deductions:
- PF: 1601
- PT: 200
- ESIC: 124
- Mediclaim: 208
Total deduction: 2132
Inhand salary: 14243
For October payslip:
- Present days: 31
- Basic: 11246
- HRA: 787
- Misc allowance: 2092
- Statutory Bonus: 2250
- Gross: 16375
Deductions:
- PF: 1601
- PT: 200
- ESIC: 124
- Mediclaim: 208
Total deduction: 2132
Inhand salary: 14243
Each month, I find a different pattern in the salary slip. In all three months, I was present all days. Can someone guide me urgently? There are different HRAs every month, sometimes miscellaneous allowance is added, sometimes not, resulting in a different in-hand amount each month. Please share the salary slip calculation in an Excel sheet based on present days. (For the employee, not HR). All expert HR personnel, please help me in the above scenarios.
From India
Acknowledge(0)Amend(0)
It appears from your submission that your organization, like many other organizations, has also restructured the remuneration pattern based on the Supreme Court Verdict of February 2019. That is the reason for the different patterns of pay slips in different months. Your organization should communicate the same to the employees before implementation. Even in your restructured remuneration, there are three pockets, of which one is Statutory Bonus of 1800/- per month, which appears to me as 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
Acknowledge(0)Amend(0)
409S K Bandyopadhyay (Howrah, WB)
From India, New Delhi
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Salary slip calculation.xls