hiiiiii please give a copy of excel sheet preparing salarry of the employees
From India, Chandigarh
Acknowledge(10)
UM
BM
KG
KJ

+5 more

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, 44034 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

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, 12078 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, 7309 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, 5090 views)

    Acknowledge(3)
    NC
    Amend(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)

    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)

    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

  • CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







    Contact Us Privacy Policy Disclaimer Terms Of Service

    All rights reserved @ 2025 CiteHR ®

    All Copyright And Trademarks in Posts Held By Respective Owners.