Hi, I have recently joined as an HR Executive in a small company with 25 to 30 employees. Could anyone help me in preparing the salary in a simple format? Currently, we only have the basic salary component and do not offer PF, ESI, HRA, etc. I would appreciate it if someone could share a format to calculate the salary with leave deductions.
Thanks
From India, Bangalore
Acknowledge(6)
Amend(0)
8Thanks
From India, Bangalore
Acknowledge(6)+1 more
Amend(0)
Hi Thanks for ur reply could u pls forward me the formulae for that,bcoz we dedute for more then one day salary and it would be fine for me if i get the formula for that
From India, Bangalore
Acknowledge(2)
Amend(0)
From India, Bangalore
Acknowledge(2)Amend(0)
Please find attachments 1, With PF deduction 2, Without PF, just simple salary. Thanks,
From Kuwait, Hawalli
Acknowledge(6)
Amend(0)
From Kuwait, Hawalli
Acknowledge(6)+1 more
Amend(0)
I'll suggest you make a compensation policy first. Yes, it will take time, but without a policy in HR, you will need the help of others at every step. Also, apply for ESI & PF as soon as possible.
Compensation Policy Considerations
In the compensation policy, you will have to decide on a few things like:
- Grade of employees
- Basic pay as per the grade
- Conveyance allowance as per the grade
- HRA
- Other allowances.
Regards
From India, Delhi
Acknowledge(0)Amend(0)
Compensation Policy Considerations
In the compensation policy, you will have to decide on a few things like:
- Grade of employees
- Basic pay as per the grade
- Conveyance allowance as per the grade
- HRA
- Other allowances.
Regards
From India, Delhi
Acknowledge(0)Amend(0)
Salary Sheet Queries
I have some doubts regarding the salary sheet with PF. I hope I can ask and clear my doubts.
1. In the Basic salary, you have used the formula 1200/D4*F4. Why have you taken 1200? What if different people have different basics?
2. In the DA column, it is 900. Where does this number come from, or is 900 the standard amount? What is it based on?
Regards,
Hansa Vyas
From India, Udaipur
Acknowledge(1)Amend(0)
I have some doubts regarding the salary sheet with PF. I hope I can ask and clear my doubts.
1. In the Basic salary, you have used the formula 1200/D4*F4. Why have you taken 1200? What if different people have different basics?
2. In the DA column, it is 900. Where does this number come from, or is 900 the standard amount? What is it based on?
Regards,
Hansa Vyas
From India, Udaipur
Acknowledge(1)Amend(0)
Dear Mr. Hansa,
1. 1200 is used as an example. If it's other than 1200, then the formula is the same: total days minus absent days.
2. Daily allowance of 900 is also used as an example; it's not standard.
Please review the attached document for more details; it is very well-explained. I downloaded it from this forum.
Thanks,
Regards
From Kuwait, Hawalli
Acknowledge(1)Amend(0)
1. 1200 is used as an example. If it's other than 1200, then the formula is the same: total days minus absent days.
2. Daily allowance of 900 is also used as an example; it's not standard.
Please review the attached document for more details; it is very well-explained. I downloaded it from this forum.
Thanks,
Regards
From Kuwait, Hawalli
Acknowledge(1)Amend(0)
The simple format for salary calculation with necessary formulas, including PF, ESIC, and PT. If it's not necessary for you, you can delete columns. It may fulfill your query.
Regards, Krishna Murthy
Bangalore
From India, Bengaluru
Acknowledge(1)
Amend(0)
Regards, Krishna Murthy
Bangalore
From India, Bengaluru
Acknowledge(1)Amend(0)
Hi all, I have been working for a sales company. In our company, we don't have a proper payroll format. Please suggest to me the proper salary format. Please shed light on how to calculate Basic, HRA, DA, Medical Reimbursement, and Special Allowances. Is it necessary to provide DA and conveyance for all categories of employees?
Thanks
From India, Madras
Acknowledge(0)Amend(0)
Thanks
From India, Madras
Acknowledge(0)Amend(0)
Hi,
I recently joined a small company with less than 20 employees as an HR executive. I wanted to inquire about the PF clauses. Is PF applicable to this company? If yes, how should I mention those clauses in the appointment letter?
Also, could you please provide me with a sample format of an appointment letter that includes TDS, PT, and PF rules mentioned in it?
Thank you.
From India, Pune
Acknowledge(0)Amend(0)
I recently joined a small company with less than 20 employees as an HR executive. I wanted to inquire about the PF clauses. Is PF applicable to this company? If yes, how should I mention those clauses in the appointment letter?
Also, could you please provide me with a sample format of an appointment letter that includes TDS, PT, and PF rules mentioned in it?
Thank you.
From India, Pune
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 & PF PT Calculation & Challan Nov 2010.xls
CiteHR.AI
(Fact Checked)-The mention of DA (Dearness Allowance) is not applicable for all categories of employees. DA is usually more common in government or public sector jobs. For private companies, it may not be a standard component. It's essential to adhere to the legal requirements and company policies when structuring salary components. (1 Acknowledge point)