You have to create the Masters before you create employee entries and process Salary. Masters are the data entry forms in which you create item lists. In other forms, you will use these items. Master entries are required mainly to maintain uniformity, and most of the master items will be helpful while filtering the data else wherein the application.

Entering Department Master is explained in detail and all remaining Master entries to be created on almost the similar lines.


Under the Master Menu, Click on the Department sub-menu. In the window that opens, enter the Department name.

Department Masters of Excel Payroll Software in Salary & Leave

Click on Save Button to save details.

You can add as many departments as you require. Click on NEW and follow the same process to make more entries.

Add Department in Salary & Leave Details screen of Excel Payroll

To edit a record, click on the pen icon present in theAction, make the necessary corrections and click on Save.

Edit Department record in Leave Details screen of excel Payroll

To delete an item, click on the delete icon present on the Action and click Ok.

Delete Department record in Leave Details and Salary screen of excel
    Payroll Software

Similarly, you can enter data in

  1. Designation Master: Enter various designations you assign to employees. Usually, the designation field is displayed in Payslip.
  2. Branch Master: Enter various ESI branches the employees are covered under.
  3. Qualification: You can enter various Qualification in Qualification master
  4. Country, State and Place: To enter a Place in Payroll, you must first create respective State. Entry ‘India’ will be available as a country in country master. You have to enter a different country only if some of your employees are from a different nation.

Data entry for Leave Details and salary of employee in excel Payroll