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

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

Excel Blank Invoice Templates and Related Invoice Templates

Invoicing is a critical aspect of any business operation, and Microsoft Excel proves to be an invaluable tool for creating professional and efficient invoice templates. Below, you'll find an extensive guide to crafting different types of invoice templates and related templates to suit various business requirements, including the essential "Blank Invoice Template." 1. Billing Invoice Template A Billing Invoice serves as a comprehensive financial document that includes all necessary details for a client to understand the charges associated with products or services. When creating a Billing Invoice Template in Excel: Begin with your company's name, address, phone number, email, and logo for a professional appearance. Include designated fields for a unique invoice number, invoice date, and due date. Construct a well-organized table for itemized charges, featuring columns for item descriptions, quantities, unit prices, and totals. Utilize Excel's built-in formulas to ...
Post a Comment
Read more