Search
Generic filters

Pay Stub Excel Template

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.

Paystubs

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.

Paystub Creator

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.

Download Pay Stub Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: