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)

Hi Alok,

I am Alok. I have 3 years of experience in HR. My responsibility involves salary processing and HR backend data preparation with MIS.

Currently, I am in a situation where I have lost my job. Could someone please help me?

Thanks,
Regards,
Alok Kumar - 9560725164

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

Dear all if basic 10000, & pf deduction for 6500, att. 28 day for the month of sep-2011. how to calculate pf. kindly suggest me. Thanks Pramod Keshari
From India, Calcutta
Acknowledge(0)
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)
  • CA
    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)
    0 0

  • Dear Ms. Kumudha,

    The ledgers to be followed depend on the nature of the industry you are in. The muster roll, salary register, and late attendance registers are some of the basic registers that need to be maintained.

    Regards,
    Kumar

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

    You can do this with MS Access as well, very simply. See this link: [WHAT YOU GIVE TO WORLD LAST SECOND: Salary software for small Company](http://wygw.blogspot.com/2013/03/salary-software-for-small-company.html)
    From Maldives, Male
    Acknowledge(1)
    NI
    Amend(0)

    Dear Friends,

    I have recently joined as an accountant in a private college. Could you please guide me on the procedures for PF, ESI, TDS, and Professional Tax in Excel format with journal entries, please?

    Email: unnimenon2014p@rediffmail.com

    Thanks in advance.

    From India, Palakkad
    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)

    My CTC is 19700, and 900 is PF. Can I stop PF deduction from my salary even if I haven't completed my probation period in my company?

    My CTC is 19700, and 900 is PF. Can I stop PF deduction from my salary even if I haven't completed my probation period in my company?

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

    Hi, i am working in Karnataka Rural Infrastructure Development as Data entry Operator, My salary is 9734/-, how much deduct EPF amount in my Salary. and what are the rules about EPF deductions.
    From India, Arsapur
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The EPF contribution is calculated at 12% of Basic + DA. Employee contribution is 12% & Employer's is 13.15% (3.67% for EPF & 8.33% for pension). EPF rules must be followed. (1 Acknowledge point)
    0 0

  • Hello, Sir,

    I want to know if I am eligible for my salary PF contribution or not. We received our monthly payment of INR 24667.00 per month, but my company has not paid/contributed to PF.

    One of my other employees also worked here, with a salary above 80,000 taken by the employer, and the employer also paid/contributed to PF. I can't understand this condition. Could you explain why this is the case?

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

    Dear Sir/Mam, I am looking job , i have 3- years experience in HR Operation , so if you have any vacancy so please let me know. Regards Manikant Kumar
    From India, Delhi
    Acknowledge(0)
    Amend(0)

    Dear sir The simple format for salary Calculation with necessary formula including OT , with out ESI, PF, deductions.
    From India, Hyderabad
    Acknowledge(0)
    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.