No Tags Found!

Hi
I newly joined as HR-Executive in one small concern with 25 to 30 members,can anyone help me in preparing the salary in simple format.And still we don't have PF,ESI and HRA etc only the Basic salary.Could any one forward me the format to calculate the salary in simple form with leave deduction
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)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply requires the provision of the formula for salary calculation with leave deductions. However, the user did not provide the necessary details to formulate the specific formula. Please provide more details on the leave policy for accurate assistance. Thank you.
    0 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, 11102 views)
    File Type: xls SALARY with out PF Deduction.xls (22.5 KB, 25562 views)

    Acknowledge(6)
    VK
    AK
    SB

    +1 more

    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply lacks the requested format for calculating salary. Please provide a clear breakdown with the necessary deductions and components.
    0 0

  • Hi
    Supriya
    I`ll suggst u to make compensation policy first... ya it will take time but without policy in Hr you will be needing the help of othr at every step....and aply for ESI & PF asap...
    In Compnsation policy you will have to decide few things like
    1. Grade of empolyees
    2. Basic pay as per the grade
    3. Conv. allw. as per the grade
    4. HRA
    5 . othr allw.

    From India, Delhi
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user's reply contains valuable advice on creating a compensation policy and applying for ESI & PF. However, it missed providing the requested simple salary calculation format and leave deductions.
    0 0

  • dear sir,
    i am kumudha, i am new joining in my company at hr department .how to handle the hr department? how to follow the ledger? and how many ledger follows the department?
    kindly help me.
    thanks & regards,
    kumudha.7708959776

    From India, Selam
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is not directly related to the original post about salary calculations and leave deductions. It seems to be seeking guidance on HR department management. For salary calculations, refer to labor laws and HR practices.
    0 0

  • dear Mr. sayeed,
    I have some doubts in the salary sheet with PF.i hope i can ask & clear my doubt.
    1.In Basic salary u had used formula 1200/D4*F4,why you had taken 1200 & suppose if different people hv different basic than.
    2. In DA column it is 900 from where does or only 900 is used ,is it standard or for what it is taken.
    Regards,
    Hansa Vyas

    From India, Udaipur
    Acknowledge(1)
    PP
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user's reply contains inaccuracies in the formula used for Basic salary calculation and the reasoning behind the DA amount. Corrections are needed.
    0 0

  • Dear Hansa Vyas,
    Whatever Sayeed is given that is absolute perfect. in that there is no doubt at all.
    Basic may be different for different people & DA there is Skilled Base & that there is table given Commercial office (Tardeo).
    Regards,
    Bhaven Gala

    From India, Mumbai
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-[B]Response[/B]: The information provided in the reply is unclear and lacks specific guidance on preparing salaries. It's essential to follow legal requirements and industry standards when calculating salaries.
    0 0

  • Dear Mr. Hansa,
    1, 1200 is used as an example, if its other then 1200, then formula is same, total days - absent days..
    2, Daily allowance 900 is also used as an example, its not standard.
    Please review below attached for more detials its really very well explain..this I have downloded from this forum only.
    Thanks,

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

    Acknowledge(1)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user's reply needs clarification. There is no attachment mentioned in the original post. The formula for salary calculation should be based on legal requirements and company policies. Thank you for your contribution.
    0 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, 5154 views)

    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The response provided does not address the specific requirements related to salary calculation, PF, ESI, HRA, and leave deductions.
    0 0

  • Dear Supriya,
    The simple format for salary Calculation with necessary formula including PF, ESIC & PT. If its not necessary to you can delete columns. Its may be full fill your query.
    Regards,
    Krishna Murthy
    Bangalore

    From India, Bengaluru
    Attached Files (Download Requires Membership)
    File Type: xls Sample Salary Statement.xls (34.0 KB, 2605 views)

    Acknowledge(1)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is incorrect as the original post mentioned that the organization does not have PF, ESI, and HRA, but the user included formulas for PF, ESIC, and PT which are not applicable in this case.
    0 0

  • Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.






    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.