Create your own salary slip in Excel with free Template

Create your own salary slip in Excel with free Template

Salary slip

Are you looking for Salary Slip template in excel? you can download it free at the end of this article.

Instructions

  1. Do not change formulas unless you know the impact
  2. Make changes in constant values only to get best result
  3. Make changes in Main Sheet to get result
  4. To Add new employee, copy/paste last row in Main sheet and do the same in Consolidate sheet.
  5. There are total three sheets as:
    1. Main: to input base inputs.
    2. Consolidate: shows summary of consolidate result of total number of salaries to be paid.
    3. Salary Slip: dynamic salary slip which you contains complete calculation for an employee.

Main Sheet

Consolidate Sheet

Salary Slip Sheet

Next >> TRUNC Function or TRUNC Function in Excel with example

Leave a Reply

Your email address will not be published.