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(0)
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)

Please find attachments 1, With PF deduction 2, Without PF, just simple salary. Thanks,
From Kuwait, Hawalli
Attached Files (Download Requires Membership)
File Type: xls SALARY(1).xls (23.5 KB, 11193 views)
File Type: xls SALARY with out PF Deduction.xls (22.5 KB, 25661 views)

Acknowledge(6)
VK
AK
SB

+1 more

Amend(0)

Hi Supriya,

I'll suggest you to 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.

In the compensation policy, you will have to decide on a few things like:
1. Grade of employees
2. Basic pay as per the grade
3. Conveyance allowance as per the grade
4. HRA
5. Other allowances.

From India, Delhi
Acknowledge(0)
Amend(0)

Dear Sir,

I am Kumudha, and I am newly joining the HR department in my company. How should I handle the HR department? How do I follow the ledger? And how many ledgers does the department follow?

Kindly assist me.

Thanks & Regards,
Kumudha
7708959776

From India, Selam
Acknowledge(0)
Amend(0)

Dear Mr. Sayeed,

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)
PP
Amend(0)

Dear Hansa Vyas,

Whatever Sayeed is given is absolutely perfect. In that, there is no doubt at all. The basics may vary for different people, and there is a Skilled Base DA table provided at the Commercial office in Tardeo.

Regards,
Bhaven Gala

From India, Mumbai
Acknowledge(0)
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,

From Kuwait, Hawalli
Attached Files (Download Requires Membership)
File Type: xls Salary Sheet & PF PT Calculation & Challan.xls (2.81 MB, 12167 views)

Acknowledge(1)
Amend(0)

if you use attached sheet your work very easy
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls SALARY.xls (23.0 KB, 5239 views)

Acknowledge(0)
Amend(0)

Dear Supriya,

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
Attached Files (Download Requires Membership)
File Type: xls Sample Salary Statement.xls (34.0 KB, 2670 views)

Acknowledge(1)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.