Staff Salary – MS Excel Sheet

We will manage three sheets in this File, as seen below.

Staff Salary Sheets
Staff Salary Sheets
Staff Member Database

In this sheet, we will input data about staff, i.e.

  • ID No.
  • Employee Name
  • Designation
  • Joining Date
  • Basic Pay
  • Deduction
  • Allowance
  • Net Salary

We will now give the name of staff member data table (Range).  In this case Staff Data table is named as StaffDetail.

Staff Salary Staff Detail range name
Staff Salary Staff Detail range name

Learn How to give name to your table (Range)

Salary Record

Salary Record entries will work the same as Student Fee collection Record works. select the table range and give it the name.

Salary Slip

This is the last sheet of Salary File, in which we will print the salary payable. we will pick the value from Salary Record sheet (not Staff database)

Staff Salary Slip
Staff Salary Slip

The highlighted value is Employee’s ID that will fetch the employees information. you can also change total working days. For example an employee came in our school in the mid of the month, then you need to change total working days 30 to 15 or any other value according to requirement. Always Print 2 copies, one for employee and other for your hard record.