EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Formula and Functions Excel Template for Payroll
Secondary Sidebar
Excel Functions
  • Excel Formula and Functions
    • Compatibility Mode in Excel
    • VLOOKUP Names
    • Advanced Formulas in Excel
    • Excel Function for Range
    • Excel Template for Payroll
    • Excel Sum Time
    • Payroll in Excel
    • Complex Formulas in Excel
    • Pivot Chart in Excel 2016
    • Advanced Excel Formulas
    • Best Basic Excel Formulas
    • Use Excel As Your Calculator
    • Print Command Button in Excel
    • Excel SUM MAX MIN AVERAGE
    • Excel Basic Functions For Beginners
    • Interactive Excel Dashboard
    • Features of 2016 Excel Workbook
    • What's New In Excel 2016
    • Microsoft Excel Skills
    • Microsoft Excel Shortcuts
    • Microsoft Excel Tips and Tricks
    • Excel Skills
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Excel Training
  • Excel Advanced Training
  • Excel Data Analysis Training

Excel Template for Payroll

Excel Template for Payroll

Excel Payroll Template (Table of Contents)

  • Introduction to Excel Template for Payroll
  • How to Create Payroll Template in Excel?

Introduction to Excel Template for Payroll

Payroll is the process of calculation and distribution of the employees’ wages in an organization. Most businesses use software like ADP or Tally for payroll or hire some outsourcing companies to provide them the payroll services. However, this consumes a lot of time and manpower. So businesses these days prefer to do payroll manually, which is done via MS Excel. In order to run payroll in Excel, we require a standardized payroll Excel template that can be used month to month. The template should consist of tabs for each month with prefilled information like tax rates and formulas that can calculate the employee’s salary, taxes, and deductions.

Below is some general information that is included in most of the payroll templates:

Employee details like:

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • Employee Name
  • Date of Joining of employee
  • Wages or the pay of the employee
  • Number of hours worked by the employee
  • Leaves taken by an employee
  • Overtime rate of the employee
  • Total overtime hours worked by an employee
  • Gross pay paid to the employee
  • Income tax and other deductibles
  • Statutory payments made
  • Taxable benefits
  • Net pay paid to the employee

How to Create Payroll Template in Excel?

Let us say we wish to create or generate a payroll template in Microsoft Excel. Now following steps can be used to do so (basically in Excel 2013):

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,452 ratings)
  • Open a new workbook in Microsoft Excel and save it:

Excel Template for Payroll 1-1

Excel Template for Payroll 1-2

  • Now create the following column names in a fresh worksheet:
  • Employee Name: Consisting of a list of employees’ names
  • Pay: Consisting of the employee’s wages or pay per hour
  • Total Hours Worked: Consisting of the total number of hours worked by an employee in a month
  • Overtime: Consisting of an employee’s overtime rate per hour
  • Total Overtime Hours: Consisting of the total number of overtime hours worked by an employee in a month
  • Gross Pay: This is the monthly payment amount to the employee without any deductibles
  • Income Tax: This is the tax that is payable on gross pay
  • Other Deductibles (If any): These are the deductibles other than the income tax
  • Net Pay: This is the pay or salary the employee will receive after all the deductions from the gross pay.

Excel Template for Payroll 1-3

  • Now add these details of all the employees column-wise, like employee name in column A, per hour pay rate in column B, and so on till column E, i.e. till Total Overtime Hours. The following screenshot illustrates this:

Excel Template for Payroll 1-4

So we can see in the above screenshot that we have added the required employee details under relevant column names in the table created. Pay and overtime rate are on an hourly basis, while overtime hours, total hours worked, gross pay, and net pay are all on a monthly basis.

  • Now we calculate the Gross Pay, which is the sum of the product of per hour pay, total hours worked and per hour overtime rate, total overtime hours, i.e. Gross Pay can be calculated as Gross Pay= (Pay * Total Hours worked) + (Overtime* Total Overtime Hours). The following screenshot illustrates this:

Excel Template for Payroll 1-5

  • Now income tax is to be calculated on gross pay. Let us consider an 18% tax for all employees. So income tax can be calculated as Income Tax = (0.18 * Gross Pay). The following screenshot illustrates this:

income tax

  • Now other deductibles, if any, like some loans or health insurance premiums, can be mentioned under this. However, it would be zero for an employee if there is no other deductible. The following screenshot illustrates this:

other deduct

  • Now net pay is the final amount that an employee gets in hand after all the deductions from gross pay are made. So, if we deduct income tax and other deductibles from gross pay, we will get the net pay for an employee. So, Net Pay can be calculated as Net Pay= (Gross Pay – (Income Tax + Other Deductibles)). The following screenshot illustrates this:

Net pay

So this is how a payroll template is created by ourselves in MS Excel.

This way we can create the payroll for all other employees by adding their details to the table created and then calculating their wages, tax, etc. We can find the sum total of all under all the columns so that the template looks like the below:

Sum total

Now, this is the process for one month. We can now create tabs for each month in this manner so that this template is filled with prefilled information like tax rates and formulas that can calculate the employee’s salary, taxes, and deductions for each month and can be used and customized as and when required.

Things to remember about Excel Template for Payroll

  • Payroll is used to keep a record of the employees’ information, their wages, payment dates, taxes, deductions, and the number of hours worked.
  • Using payroll templates in business is a fast and easy method for them to standardize their payroll process.
  • There is no single standardized form for the use of a template.
  • Users can even create their own payroll templates in Microsoft Excel, which is beneficial as the payroll can be monitored by the user itself.
  • Payroll templates can help maintain a confidential detailed list of the employees of a business.
  • The free payroll templates are eligible or suitable for any number of customizations and can be edited or created just the way the user wants.
  • The payroll templates in MS Excel can be easily converted to PDF format and sent to the client via mail.
  • Some additional columns like the premium of health insurance, federal allowances, date of joining, pre-tax holdings, taxable benefits, statutory payments made, etc., can also be added to the payroll template.
  • Some other softwares used for payroll calculation and that are available for free are:
  • Employee Register
  • Dashboard Payroll
  • Employee Timesheet
  • Payroll Accounting
  • Employee Absence Schedule
  • Employee Payroll Calculator
  • Wage Tax Calculator
  • Blue Timesheet, etc.

Each of these has separate tabs and worksheets for each section of the employee details and payroll services.

Recommended Articles

This has been a guide to Excel Template for Payroll. Here we discuss How to create Excel Template for Payroll along with practical examples. You can also go through our other suggested articles –

  1. Confidence Interval in Excel
  2. HLOOKUP Formula in Excel
  3. Excel Timesheet Template
  4. Count Formula in Excel
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Data Analysis Training (17 Courses, 8+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Payroll Excel Template

EDUCBA

Download Payroll Excel Template

EDUCBA

डाउनलोड Payroll Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more