How to Use the Salary Slip Format in Excel

Written by meg north
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use the Salary Slip Format in Excel
Microsoft Excel's use of formulas makes it easy to calculate and keep track of employee financial data in a salary slip. (number background image by kuhar from Fotolia.com)

Keep employee financial details in one place by using a monthly salary slip spreadsheet template in Microsoft Excel. Excel offers many benefits for financial record-keeping in businesses, such as customising the template to your business's needs and including formulas for calculating data. In some places, it is a matter of legality to use a salary slip to track and maintain employee financial information. Furthermore, since it is updated on a monthly basis, it provides a quick at-a-glance summary of that month for that employee.

Skill level:
Easy

Other People Are Reading

Things you need

  • Microsoft Excel

Show MoreHide

Instructions

  1. 1

    Download a salary slip Excel template, like the one in the Resources section. You can also open a new Excel spreadsheet and make one according to your company's requirements.

  2. 2

    Customise the rows and columns with the information you wish to include. Sample information could include the employee name, department, designation, bank name, types of accounts, bank account number, location, payment method, training period and resign date.

  3. 3

    Format the cells in the spreadsheet with any appropriate formulas. For example, in the deductions cell, you could include a percentage formula that calculates the percentage of the tax deduction. This way, when you type in the gross earnings, the formula will calculate the tax deduction for you.

  4. 4

    Fill in the rows and columns with the employee's information each month.

  5. 5

    Tally up the employee's number of working days, number of absences, holiday pay, total earnings, total deductions and other information at the end of each month. Keep it with the employee's other records.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.