New to HR? How Do I Create a Salary Sheet for a New IT Company?

Hello all, please help me; I am a fresher in HR. I don't know how to prepare a salary sheet for employees in a newly started IT company.

Hi Asha, do you have any salary structure? If so, could you please prepare it in an Excel format? If not, please provide me with your email ID so that I can send you a sample salary statement.

Thank you.

CTC Break-up Formats

- Basic
- PF Company Contribution

- HRA
- ESI - Yes or No

- Personal Allowances
- LTA Monthly

- Conveyance
- Professional Tax

- Mobile
- Bonus

- Medical Allowances

- Vehicle Maintenance
- Others

Cost to the company

Regards

Basic Salary Components

- PF Company Control
- HRA
- ESI - Yes or No
- Personal Allowances
- LTA Monthly
- Conveyance
- Professional Tax
- Mobile
- Bonus
- Medical Allowances
- Vehicle Maintenance
- Others
- Cost to the Company

Hi Asha, please find the attached format for the salary sheet. Kindly take a look and format it in an Excel sheet.

Thanks,
Hemant

It is better for you to purchase a statutory wage register as per the Shops and Establishment Act and prepare it according to that structure. Even if you have any existing salary structure, it is advisable for you to follow the above guidelines and use the appropriate components.

Regards,
P. Manoz Kumar

Hi Manish, I would like to know how many days are generally considered when calculating salary. Is it 30 days or 25 days?

sksurender73, you can deduct PF on 34,000 only when the PF office gives permission. If you want to deduct on 34,000, obtain permission from the PF Office.

Formats of Salary Sheets

There are various formats of salary sheets. I am attaching just three of them which can be used. If you are trying to do it all manually, it would be a very time-consuming and error-prone exercise. You should use payroll software.

Regards

Can anyone help me create a salary spreadsheet in Excel? We currently do it manually, so please assist me.

Thank you.

Regards