Skip to main content

Sample Salary Slip Format in Exce and Word Templates

[Company Name] For the Month of: [Month, Year]
Address: [Company Address] Pay Date: [DD/MM/YYYY]

1. Employee Details

Item Details Item Details
Employee Name [Worker's Full Name] Date of Joining [DD/MM/YYYY]
Employee ID / Code [Unique ID Number] Total Working Days in Month [e.g., 30]
Designation / Job Role [e.g., Operator, Assembler, Helper] Days Paid [Actual days worked/paid]
Department / Section [e.g., Production, Quality Control] Bank A/C No. (Last 4 Digits) [XXXX]
PAN / Aadhar No. (Last 4 Digits) [Optional: XXXX]

2. Earnings (Income)

Component Rate / Basis Amount (₹)
1. Basic Salary [Monthly/Daily Rate] [Amount]
2. Dearness Allowance (DA) [If Applicable] [Amount]
3. House Rent Allowance (HRA) [If Applicable] [Amount]
4. Overtime (OT) Pay [Hours Worked x OT Rate] [Amount]
5. Other Allowances (e.g., Travel) - [Amount]
Total Earnings (A) [Sum of all amounts]

3. Deductions (Money Withheld)

Component Basis / Statutory Amount (₹)
1. Provident Fund (PF) Contribution [Statutory % of Basic + DA] [Amount]
2. Employees' State Insurance (ESI) [Statutory % of Gross Pay] [Amount]
3. Professional Tax (PT) [If Applicable] [Amount]
4. Income Tax (TDS) [If Applicable] [Amount]
5. Loan/Advance Recovery [If Applicable] [Amount]
Total Deductions (B) [Sum of all amounts]

4. Net Pay Calculation

Gross Earnings (A) [Total Earnings]
Less: Total Deductions (B) [Total Deductions]
Net Pay (A - B) [Net Amount Paid]

Net Pay in Words: [Write the Net Pay amount in words]

5. Signatures and Notes

For Office Use:


Prepared By: [Signature / Name of HR/Accounts] 		For Employee Record:


Employee Signature: [Signature]
Note: This is a computer-generated statement and may not require a physical signature.
Labels:

Comments

Post a Comment

Popular posts from this blog

Streamlining Leave Requests with a Leave Application Form

Sick Leave Application Form (Printable/Editable Format) This form is ideal for companies that want a standardized process. [Company Name] Sick Leave Application Form Employee Information Full Name: Employee ID: Department: Position: Contact Number: Leave Details Type of Leave: Sick Leave Half-Day Sick Leave Other (Please specify) Start Date: End Date: Total Number of Working Days Requested: Date of Return to Work: Reason for Leave Please briefly state the nature of your illness/injury: Note: A medical certificate is req...
Post a Comment
Read more

Employee Time off Request From Template

Employee Holiday Request Form Template Vacation Time Request Form Template Sample Employee Vacation Request Form Employee Day Off Request Form Template Free Printable Employee Vacation Request Form Microsoft Word Vacation Request Form Template Employee Vacation Request Form 2018 Download Employee Time off Request From Template in Excel Format.   Time off Request From 1   Time off Request From 2
Post a Comment
Read more

Diverse Templates for Tenancy Agreements

Furnished Flat Tenancy Agreement This Agreement is made on [Date] between: The Parties The Landlord Full Name: [Landlord's Full Name] Address: [Landlord's Address] Phone: [Landlord's Phone Number] Email: [Landlord's Email Address] The Tenant(s) Full Name(s): [Tenant's Full Name(s)] Address: [Tenant's Address] Phone: [Tenant's Phone Number] Email: [Tenant's Email Address] (Collectively referred to as "the Parties") 1. The Property The Landlord agrees to let to the Tenant, and the Tenant agrees...
Post a Comment
Read more