We will manage three sheets in this File, as seen below.
Staff Member Database
In this sheet, we will input data about staff, i.e.
- ID No.
- Employee Name
- Joining Date
- Basic Pay
- Net Salary
We will now give the name of staff member data table (Range). In this case Staff Data table is named as StaffDetail.
Salary Record entries will work the same as Student Fee collection Record works. select the table range and give it the name.
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)
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.