The Employer will give payslip to Employees for Salary Details purpose. Every organization, Firms, proprietorships, and Companies give payslips to employees. Payslip will be used for employee personal loan and Home Loans purpose. The below Salary Slip Format in Excel is very easy to use on different platforms. Different employers prepare payslip in different formats. Here is an example of sample payslip format in excel and PDF.
sample payslip format in excel with formulas:
We Need following details for preparing simple salary slip format in excel :
Employer Details :
- Employer Name
- Employer Logo
- Employer Address
Employee Details :
- Employee Name
- Employee Number
- Employee Department
- Employee Designation
- Date of Joining
- Bank Name
- Bank Account Number
- Branch
Attendance Details :
- No of WorkingDays
- Week Off Days
- CL and PH’s
- LOP
Salary Details :
- Basic Salary
- DA
- House Rent Allowances
- Conveyance
- Others
- Allowances
- PT.PF, ESI, TDS
- Loans and Others
- Advances
You May Also Like this: Tally ERP 9 Shortcut Keys List Excel Download
Salary Payslip is used as Salary proof where employees need it for Personal or Home or car loan application, Credit card loan application and Tax Attachment purpose. If you want to shift to the new company we need for payslip its proof of previous company identification and It refers to salary proof also.