WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Payslip Template in Excel

Payslip Template in Excel

Excel Payslip Template

As an employee, we all get salary receipts so-called “Payslip” from our employers, which is an acknowledgment for salary credited to employee account from the employer. In the modern world, corporate companies use sophisticated software to prepare their employee’s payslip, but we can still rely on excel to prepare payslip. In this article, we will show you how to build a Free Payslip template in excel.

Pay Slip or Salary Slip template in excel is the receipt given by the employer to their employees every month upon payment of salary to the employee for the services rendered in the month. Pay Slip consists of all kinds of earnings and deductions under various heads as per the norms are given by the government in the respective financial year.

Payslip Template in Excel

Examples of Free Payslip Template in Excel

Let’s follow the below steps to build a Free Payslip excel template on your own.

You can download this Payslip Excel Template here – Payslip Excel Template

Step 1: First thing you need to set up is general information about the company. It should include Company Name, Address, Phone Number, and Company Logo. You can include any other information regarding the company.

Pay Slip Template Example 1

Step 2: Next, you need to specify which month salary is paying for.

Pay Slip Template Example 1-1

Step 3: Next, you have to include all the information related to employees. Employee information should include the following items.

Employee Name, Employee ID, Designation, Department, Gender, Date of Joining, and Location.

Pay Slip Template Example 1-2

Step 4: Once the employee information provides, we need to show the employee Bank Account Number, Bank Name, UAN Number, ESI Number & Pan Number.

Pay Slip Template Example 1-5

Step 5: Next, you need to show for the period paid days, LOP days, Days in a Month.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Pay Slip Template Example 1-3

Step 6: Once employer and employee information is inserted next, we need to insert salary details as per the break-up.

First, include gross salary as per break up.

Salary structure includes “Basic Salary,” “HRA,” and “Special Allowances.” These elements are common elements of a fixed salary.

Pay Slip Template Example 1-4

Step 7: Now, we need to include any other earnings like Incentives, Bonus, Overt Time, etc.

Payslip Template in Excel Example 1-6

Step 8: Once the earning part decided, we need to mention all the deductions under various heads as per the rules of the government.

The deduction part may include Provident Fund, ESI, Professional Tax, Income Tax (TDS), Salary Advance (If Any), and you can include any other deductions as well.

Payslip Template in Excel Example 1-7

When you include deductions, you need to be careful in terms of Professional Tax, Provident Fund, and Income Tax calculations.

PF will be 12% of basic pay; PT will be 200 if the gross salary is more than 15000 or else 150.

Income Tax calculation should be as per the rules and regulations of the government. You need to calculate TDS after deducting exemptions, so maintain a separate working for this. It is always a good practice to hire a good professional or consultant who is an expert in these matters.

Step 9: Next, we need to arrive at the Net Pay amount. To calculate this, simply apply the formula Total Earnings – Total Deductions.

Payslip Template in Excel Example 1-8

So once the net payment arrived, the payslip format is ready to use, and it looks like this.

Payslip Template in Excel Example 1-9

Pay Slip for Not Registered Companies

For small industries that are not registered themselves with the company, secretaries will not have any sort of TDS, PF, ESI deductions. For them, it is simple to payslip.

Keeping in mind those unorganized industries, we are providing a payslip template for them as well.

Small industries include Basic salary as part of their salary structure.

Example 2

In small industries, employees work overtime most of the time; in such cases, factories pay Over Time wages at 1.5 times of regular payment.

Over Time amount is calculated on an hourly basis, so it is important to mention OT hours, Rate, and OT amount.

Payslip Template in Excel Example 2-1

So Basic & OT Payment gives the total to Total payment.

Payslip Template in Excel Example 2-2

Next, in small industries, the deduction part includes only “salary advances,” so provide this column under deductions.

Payslip Template in Excel Example 2-3

So now arrive final net pay.

Payslip Template in Excel Example 2-4

Things to Remember

  • Pay Slip looks beautiful, but a lot of effort has been put by the payroll team to arrive net pay amount.
  • In today’s sophisticated software, you can design anything and everything. All the complicated calculations are automated in that.
  • You need to download the template and modify the contents if the salary structure is different in your organization.
  • TDS calculations are complicated, and always keep yourself up to date with rules.

Recommended Articles

This has been a guide to Payslip Template in Excel. Here we discuss how to build a Free Payslip template in excel using formulas with a downloadable excel sheet. You can learn more about excel from the following articles –

  • Top 5 Accounting Templates in Excel
  • Break-Even Point in Excel
  • Create a Database Template in Excel
  • Create a Blank Invoice Template in Excel
12 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download Payslip Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More