Hi every body, Please find attachment of Excel Complete Payroll Administration including Payslip, Bank Statement(Based on Link and Excel Formula) Regards Siva
From India, Visakhapatnam
Attached Files (Download Requires Membership)
File Type: xls Excel Payroll Administration.Xls (150.0 KB, 23400 views)

Acknowledge(0)
Amend(0)

Hi, Siva, It was really a good work, but I realise that you didn’t take one factor in deduction Colum i:e ESI Plz edit the same Regds Deepak
From India, Delhi
Acknowledge(0)
Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply is correct. It highlights the omission of ESI deductions in the payroll administration, suggesting an edit. Well done for catching that detail! (1 Acknowledge point)
    0 0

  • Hello Siva
    Your details about Payroll administration will be a great for HR beginers like me.
    thanks a lot. I would request you to send such more practical tips because I am a fresher in HR field.
    Regards
    Sandip Soni
    (Ahmedabad)

    From India, Ahmadabad
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-[The user's reply does not address the content of the original post, which is about sharing an Excel file related to payroll administration. It is important to provide relevant feedback or ask for clarification if needed.]
    0 0

  • Hi Siva,
    I have gone through your attachment. Really a neat work. But why Profession Tax, ESI, Labour Welfare Fund have not figured under Deductions? Since these have not figured here, they may not tally with the payouts done by Fin department. It has to match your PF/ESI challan figures also.
    Please incorporate the same and the sheet becomes pucca.
    Regards,
    Chandru
    Manager -HR

    From India, Madras
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-[B]Response[/B]: Your attention to detail is commendable. Including Profession Tax, ESI, and Labour Welfare Fund under Deductions is crucial for accurate payroll. Thank you for your input! (1 Acknowledge point)
    0 0

  • Good posting. But what counter you use for priniting the salary slip.We have to write emplyee’s name or just put sl.no.and where? Sandipan
    From India, Delhi
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The salary slip should include the employee's name along with other relevant details. It's crucial for identification and legal purposes. Thank you for sharing your insights on payroll administration.
    0 0

  • Hi Raghav,
    I am searching for a job in Dubai in Administration field. I worked 7 years in Industrial relations in L&T Ltd, How much salary can i expect in Dubai in the same field. Kindly reply to me at the earliest.
    Regards,
    R.Raja

    From India, Bangalore
    Acknowledge(1)
    SS
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is not related to the original post, which is about payroll administration. It does not address the content or context of the original post.
    0 0

  • Kindly define all items for consideration like PF ,what its stand for.Im sorry I am new to salary and benefits administration. Thanks. Christian S.Casiño
    From Philippines, Quezon City
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply is incorrect. PF stands for Provident Fund, a mandatory retirement savings scheme for employees in India governed by the EPF Act, 1952.
    0 0

  • Hi,
    Really good piece of sharing!! Thanks
    Can anyone suggest me with good Payroll software as our org. is looking for the same and am confused as there are so many options. Please let me know the best software.
    Regards,
    Preeti

    From India, Mumbai
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-Great inquiry! One of the top-rated payroll software options is ADP Workforce Now, known for its comprehensive features and user-friendly interface. Thank you for your engagement! (1 Acknowledge point)
    0 0

  • really there is no gain saying this excel power point regarding pay rol administratrion is task executer ba bayee shoaib
    From India, Muzaffarpur
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Check Failed/Partial)-The user reply contains unclear language and does not provide any meaningful information related to the original post. It does not contribute to the discussion on payroll administration.
    0 0

  • hi shiva
    it is good enough but is any thing to develop a better payroll and reporting tool with the combination of cristal report or any other tool that can maintian a small/ medium organasition a necessary hr document like as persnal file and statury report
    hope some more amendment in this sheet and try it ot automised
    thanks in advanse
    Neeraj
    9911635921

    From India, New Delhi
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply contains suggestions for enhancing the payroll and reporting tool to include HR documents and automate processes, which aligns with best practices for efficiency. (1 Acknowledge point)
    0 0

  • Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.






    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.