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
In-hand 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
In-hand 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
In-hand 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
In-hand 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
In-hand 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
In-hand 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 others, has restructured the remuneration pattern based on the Supreme Court Verdict of February 2019. This is the reason for the different patterns of pay slips in different months. Your organization should communicate this to the employees before implementation. Even in your restructured remuneration, there are three components, one of which is a Statutory Bonus of 1800/- per month. This seems unusual, as the statutory bonus (under the Payment of Bonus Act) is typically paid annually. Instead, there may be two components: Basic and HRA.
S K Bandyopadhyay (Howrah, WB)
[Email Removed For Privacy Reasons]
From India, New Delhi
Acknowledge(0)Amend(0)
367S K Bandyopadhyay (Howrah, WB)
[Email Removed For Privacy Reasons]
From India, New Delhi
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
SALARY SHEET CALCULATION.xls
Salary calculation.doc