Leave Balance Calculation Pro
Import your employee data from an Excel (.xlsx, .xls) or CSV (.csv) file. The file must contain the following columns:
Required & Optional Columns:
- Employee number: Employee unique identifier (e.g., 12345) - Required
- Field worker names and surname: Employee's Name and Surname (e.g., Joe Soap) - Required
- Organization: Orginization Name (e.g., Coca-Cola) - Optional (defaults to 'N/A')
- Starting date: Employment start date (YYYY-MM-DD preferred, e.g., 2022-01-15) - Required
- Medical Leave Opening Balance: Initial medical leave balance (number, e.g., 15) - Required
- Family Responsibility Opening Balance: Initial family leave balance (number, e.g., 3) - Required
Employee Leave Data & Calculations
| Employee number | Field worker names and surname | Organization | Starting date | Medical Leave Opening Balance | Family Responsibility Opening Balance | Monthly Medical leave | Monthly Family Responsibility leave | Medical Cycle Months Left | Family Cycle Months Left | Medical Reset Date | Family Reset Date |
|---|
| No employee data loaded. Please import a file using the button above. The table shows the required headers and calculated fields. |