Buy Now

Payroll
Excel 
Template

 

Our Payroll Excel Template allows you to quickly and easily calculate your company payroll. Equipped with dynamic filters and tables, simply input your payroll information and the template will do the rest.
 
Unlock Access
 

What's Inside the Payroll Template?

Details | 5 Sheets 

Supported Versions | Excel 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | Accounting, Small Business

Tags | Hours, Taxes, Calculator, Biweekly, Schedule, Ledger

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Payroll Excel Template

 
Input filing status, tax rates and payment periods for our Payroll Excel Template.

No business owner starts their venture excited about running administrative tasks. Still, your business won’t last very long if you aren’t on top of things like taxes and payroll. Our Payroll Excel Template is designed to organize, structure and keep records of your payroll. 

If you find this template useful, you’ll also want to check out our other small business tools like Employee Scheduling, Timesheet and Expense Report templates. Each is designed to streamline and organize your key business processes that otherwise can be fragmented across expensive software and programs. 

Let’s dive into how to use this spreadsheet. 

Start off in the Setup sheet where it has three columns for Tax Filing Status, Tax Rates and Current Pay Period. Adjust these as needed. If the Local Income Tax Rate changes, you can easily adjust it to fit the change. 

Move to the Employee Info sheet and enter employees on your payroll. Fill in the other relevant fields with white columns. These include Employee ID, Name, Hourly Wage, Overtime Wage, Tax Status, Federal Allowance (Form W-4), Other Tax %, 401K Deduction, Health Insurance Deduction, Vision Insurance Deduction, Dental Insurance Deduction, Other Pre-Tax Deduction 1 & 2 and Post-Tax Deduction 1 & 2. Grey columns are protected in this sheet as they contain formulas that will automatically calculate based on your inputs. 

Our Payroll Calculator sheet is where you log critical data like pay, hours and tax information.
The Dashboard sheet of our Payroll Excel Template breaks down hours, pay, overtime and vacation days for a given employee over a period of time.

Hop over to the Payroll Calculator sheet. Select an Employee ID from the drop-down menu and enter their Regular Hours Worked, Overtime Hours, Vacation Hours, Sick Hours, Bonus/Other Taxable Income, Federal Tax Withheld, State Tax Withheld, and Other Post-Tax Deductions. As with the prior sheet, the grey columns will calculate automatically. This includes the employee's Gross Pay and Net Pay for the period. Repeat the process for other employees by using the next row down. 

In the Dashboard sheet, you can view your payroll by Period, Week or Day. The aggregate of your company’s payroll will calculate and be displayed on a bar chart on the right hand side of the sheet so you can view Regular Hours Worked as it compares to Overtime Hours, Vacations Hours and Sick Hours. 

While running payroll may never be the most fun activity, it doesn’t have to be a hassle with this customizable and easy to use template. 

More Accounting Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW