Download a Free Word or Excel Pay Stub Template

Download a Free Word or Excel Pay Stub Template
Page content

No Paper Paycheck?

Excel pay stub template

Use Word and Excel pay stub templates to make payroll easier

Many businesses no longer offer paper paychecks as a way to compensate employees. Instead, they offer paperless options such as direct deposit or prepaid debit cards. Doing so is cost effective and saves time. This article will give you an Excel pay stub template as well as a Word pay stub template to offer to employees in lieu of a paper check. 

These options are more secure than paper checks, as well, as payments made by direct deposit are traceable and cannot be lost or stolen as a paper check might be. Unlike a paper paycheck, there is no risk of someone forging a direct deposit. Prepaid debit cards can be set up to require a PIN so that, even if lost or stolen, the money cannot be accessed by anyone but the employee. Even if there is no PIN, an employee can call and cancel a lost or stolen debit card and have a new one issued immediately. A lost or stolen paper check must have a stop put on it and a specified amount of time must pass before a new one can be issued.

With all of these benefits, there are few reasons not to switch to a paperless pay plan. However, nothing is truly paperless, it would seem. You still must provide check stubs to your employees. You can simplify this process using one of the following pay stub templates. There is a pay stub template in .dot format for use in Microsoft Word and compatible word processing programs, and a .xlt template for use in MS Excel.

Pay Stub Template Word

[caption id="" align=“aligncenter” width=“600”]Pay Stub Template for Word Pay Stub Template for Word[/caption]

This pay stub template is compatible with all current versions of Word, including 2003 up to 2016. Replace the sample logo with your company logo in the header of the template. You will also need to edit the header to replace the sample text with your business information and the employee’s information.

The first table in the template lists the descriptions, rates, hours, totals and year to date totals for a variety of payment types, such as regular, overtime and holiday pay. The second column describes deductions for the current pay period and year to date totals. These tables will automatically perform certain calculations. For instance, the Earnings column in the first table multiplies the rate by the hours in the same row. To perform these calculations, you must update the fields. You can do this by pressing the F9 key at the top of your keyboard.

The column at the bottom of the page provides an overview of the current pay period and the year to date earnings, including the amount deposited into the employee’s account.

Download Page: Pay Stub Template for Word

Pay Stub Template Excel

[caption id="" align=“aligncenter” width=“600”]Pay stub template Excel Pay Stub Template for Excel[/caption]

This Microsoft Excel pay stub template is very similar to the one for Word, but with many more built-in functions.

Replace the sample logo with your company logo in the header of the template. You will also need to edit the header to replace the sample text with your business information and the employee’s information.

The first table in the template lists the descriptions, rates, hours, totals and year to date totals for a variety of payment types, such as regular, overtime and holiday pay. The second column describes deductions for the current pay period and year to date totals. The column at the bottom of the page provides an overview of the current pay period and the year to date earnings, including the amount deposited into the employee’s account.

All of the earnings are automatically calculated, as are the deduction totals and most of the items in the table at the bottom of the pay stub.

Download Page: Pay Stub Template for Excel

You may wish to download each of these templates and try them out to determine which one works best for you. On the other hand, you may simply prefer Excel to Word or vice versa. Either way, you can customize these pay stub templates to suit your needs.

References

  • Photo Credit: PhotoSpin
  • Screenshots taken by author.