You can create an Excel sheet with relevant data such as:
- Reason for Separation
- Better Prospects
- Better Job Profile
- Relocation
- Higher Studies
- Medical Reasons
- Management Conflict
- Intra-Team Conflict
- Termination
- Retirement
- Abscond
- Death
- Job Titles
- Years Served
Certain data depends on the nature of the industry, size, hierarchy, etc. You can create an Excel sheet with this information:
Sr No / Name / Job Title / Department / Manager / DOJ / DOE / Years Served / Reason for Separation / DOB / Age / Gender / Comments
As you input the data under these columns, you can manipulate the data to generate various reports using graphs and pivot tables in Excel sheets.