This is a simple pay stub slip in Excel with a general format you may use for your purposes. If you are a small business owners where you are running your business with a small number of employees, you might find this useful since you can modify it to meet your own needs. Or, if you are a Human Resources Manager, then you may need this as reference to generate your own format. The main benefit of having this form in Excel is you don’t have to calculate the salary manually. You just need to put the correct excel function to calculate the data.
Pay stub (also known as Salary Slip, Pay Slip, and Paycheck Stub -all mean the same thing) is used as payment proof where employees might need it for:
- home or car loan application
- also credit card application
- tax attachment
- insurance application
That’s why you must put some important information into a pay stub form instead of just salary amount to make sure your employee’s application pass into the administrative requirement.
Also, if you are an employee, you may simulate your salary including its allowance to calculate the amount you need in a new company. Or, to calculate how much raise you want to have in your current company after yearly company appraisal.
Pay Stub Template Format
In this model, you can add name, employee ID, title, directorate and department below the salary slip title. Then you can type salary description as well as their values in table below it. Earnings column is at the middle table, between description and deduction columns. Deductions column is at the right side. Net salary will be calculated automatically. There is an automatic amount of words converter that will convert its nominal value into words.
You must fill require information manually, except amount in words part. You may create your own employee database table with their salary details if you want to print it regularly as well as keeping your employee’s monthly salary record as well. Then you can group either employee’s name or ID as ref to pull their data. Use Data Validation function put in name/employee ID to select respective employees. And then, use VLOOKUP formula to pull particular employee into salary slip form based on the selection.
You can modify its layout, add more rows and columns, modify its title to meet your own requirements. Don’t forget to put your company logo. And depends on your company’s policy, you can add signature box at bottom in this salary slip form. Or, you can add one line note to inform that salary slip is valid without signature. Few examples are walmart paystub, dg paystub, dgme paystub etc.