No Tags Found!

hiiiiii please give a copy of excel sheet preparing salarry of the employees
From India, Chandigarh
Acknowledge(0)
Amend(0)

Dear Reena, Try this. Sheet attached. Regards, Viraj
From India, Pune
Attached Files (Download Requires Membership)
File Type: xls Salary Sheet & PF PT Calculation & Challan Nov 2010.xls (2.78 MB, 44003 views)

Acknowledge(11)
AM

+6 more

Amend(0)

Hi Viraj,

Thank you so much for your help. I need one more favor from you. I have to prepare an induction manual for the sales team at our company. Could you please provide me with some guidance on this? If possible, please share a proper format and the necessary materials for the sales team.

Thank you in advance for your assistance.

Best regards,
[Your Name]

From India, Chandigarh
Acknowledge(1)
Amend(0)

Hi Reena, i am attaching a sample salary excel sheet. Hope you find it useful. Below is the attachment.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Salary Sheet Format.xls (31.0 KB, 12063 views)

Acknowledge(5)
UM
RM
KI
Amend(0)

Dear Friends,

Kindly find attached the same Excel sheet that was provided before with protection. For a long time, everyone has been requesting the password but has been unable to obtain it.

Here is the unprotected Excel file; I hope it will benefit all of you.

Thank you,

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

Acknowledge(3)
MI
Amend(0)

Kindly download from the below link; it's unprotected. How to make a salary in Excel sheets?

URL: [https://www.citehr.com/307446-how-make-salary-excel-sheets-5.html](https://www.citehr.com/307446-how-make-salary-excel-sheets-5.html)

Thanks,

From Kuwait, Hawalli
Acknowledge(0)
Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The link provided is helpful for creating salary sheets in Excel. However, ensure the data is protected to maintain confidentiality. Thank you for sharing! (1 Acknowledge point)
    0 0

  • Please find attache the document and hope it will be helpful for you.. vikash
    From India, Delhi
    Attached Files (Download Requires Membership)
    File Type: xls Salary Sheet Format.xls (68.5 KB, 5081 views)

    Acknowledge(3)
    NC
    Amend(0)

    Why are you all still using Excel sheets when there are quality [payroll software](http://www.viksatinfotech.com/PayrollSoftware.aspx) available in the market? This makes salary calculation much easier and faster, and also generates a lot of statutory reports such as PF/ESI statements, salary register, salary slip, attendance card, leave details, salary history, birthday reminders, income tax computation, IFSC report (.txt or .csv), Form 16, and others. Additionally, it provides a lot of other reports for salary analysis.
    From India, Chandigarh
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The user's reply contains accurate information about the benefits of using payroll software over manual Excel sheets for salary calculations. (1 Acknowledge point)
    0 0

  • Kindly help me out in salary calculation and the detailed breakdown of the components. I have attached a sample payslip with the following information:

    Days Worked: 30
    Arrears Days: 0
    Basic: 3840
    TA Allowance: 2321
    HRA Allowance: 1650
    Medical Allowance: 2321
    Gross Salary: 10132
    PF Deduction: 461
    ESIC Deduction: 137
    PT Deduction: 98
    Total Deductions: 696
    Net Salary: 9436
    EPF Base: 3840
    EPS Base: 3840
    EPF Employee Contribution: 461
    EPF Employer Contribution: 141
    EPS Employer Contribution: 320
    EDLI: 19.2
    PF Administration: 42.24
    EDLI Administration: 0.384
    ESI Salary: 7811
    ESI Employee Contribution: 137
    ESI Employer Contribution: 372
    LWF Contribution by Employer: 0
    GPAI Employee: 35
    CTC: 11061.824

    I hope this helps in understanding the salary calculation details.

    From India, New Delhi
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The information provided in the user reply is accurate and detailed. Well done! (1 Acknowledge point)
    0 0

  • Dear Sir, Anyone can please share the PF calculation and salary preparation Sheet. Thnaks, Yogendra 09785080066
    From India, Delhi
    Acknowledge(2)
    Amend(0)

    Give me payroll :my salary 15000how to split this one

    Acknowledge(0)
    Amend(0)

    M.Sayeed ji, Kindly send the password
    From India, Tirunelveli
    Acknowledge(0)
    Amend(0)

    I get 12,000 Indian rupees as my salary. I work in a school. What should be the PF deducted amount from my salary if I am present only 18 days in the month of January? I know that 1,440 will be the amount for 12,000 if I am present for 31 days, but I was only present for 18 days.
    From India, Delhi
    Acknowledge(0)
    Amend(0)

    Calculate the same as ur salary and present days, like= (S*50/60%)*p*12%
    From India, undefined
    Acknowledge(0)
    Amend(0)

    Hi,

    Is there a new judgment by the Honorable Supreme Court of India stating that from now on, the PF will be deducted from the full salary and not just the basic salary (with the upper limit of deducting PF remaining the same)? Please confirm.

    From India, Mohali
    Acknowledge(1)
    Amend(0)

    I need Statutory bonus calculation in excel for the FY 2020-21 (Karnataka)
    From India
    Acknowledge(0)
    Amend(0)
  • CA
    CiteHR.AI
    (Fact Checked)-The request for statutory bonus calculation excel sheet for FY 2020-21 (Karnataka) aligns with labor laws for bonus entitlement. Well done! (1 Acknowledge point)
    0 0

  • Is there any provision in the EPFO employer portal to get Break in Service Details for a paticular member? If so how can we get it?
    From India, Puducherry
    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.