We're introducing an automated sickness data import feature that transforms how users manage statutory sickness schedules. This new functionality eliminates the need for manual data entry by allowing users to import sickness-related data directly into the system.
Important: To successfully create a sick pay schedule through import, you must provide:
Start Date: The beginning date of the sickness period.
End Date: The end date of the sickness period.
Both fields are mandatory for schedule creation.
To import a sick pay schedule, follow the steps below.
Click Team then click Import.
Click CSV file, and drag and drop the file into the importer. Alternatively, click select it from your computer and click on the file you wish to import.
Validate the file.
Click Sick Pay Schedules block.
Map Sickness Start Date & Sickness End Date.
Click Import, then click Go to team area to view the schedule or Import with same file to continue importing.
Import Processing Logic
The system processes imported sick pay schedules in the order they appear in your import file. For each employee:
The first valid schedule is processed and imported
Subsequent schedules are checked against already processed schedules
Any overlapping schedules are skipped
Non-overlapping schedules continue to be processed
Example Scenario
If you import three schedules for the same employee:
Schedule 1: 01/01 - 31/01 ✅ Imported
Schedule 2: 15/01 - 10/02 ❌ Skipped (overlaps with Schedule 1)
Schedule 3: 01/02 - 28/02 ✅ Imported (no overlap with processed schedules)
Result: Schedules 1 and 3 are imported; Schedule 2 is skipped.
Validation Rules
Schedules That Will Be Ignored
The system will automatically ignore schedules that:
Start before the current payroll period
Overlap with existing statutory schedules already in the system
Overlap with previously processed schedules in the same import batch
Have incomplete employee profiles
Have an end date that comes before the start date
Date Overlap Handling
When entering sickness dates that overlap with existing leave periods, the system will automatically exclude the conflicting dates to prevent scheduling conflicts.
Import Restrictions
The sick pay schedule import follows the same validation rules as the manual schedule creation form, ensuring consistency across all methods of schedule creation.
Troubleshoot Common Issues
Schedule not imported: Check that start and end dates don't overlap with existing schedules
Multiple schedules skipped: Ensure dates don't conflict with each other within your import file
Profile errors: Verify that employee profiles are complete before importing