Record vacation and sickness
Record vacation usage and sickness in an open payout. Payroll can import an Excel file and create vacation and sickness entries based on the pay type.
Purpose
Imported data links an employee, pay type, and amount to the payout. The Create Entries action then creates the corresponding vacation and sickness entries.
Prerequisites
- The payout is open.
- The pay types to import exist and have Vacation Import Type set correctly.
- The Excel file has three columns: employee code, pay type, and hours. Row 1 is a header row and is not imported; data starts in row 2.
Steps
- Open the payout and select Register Vacation Usage and Sickness.
- Select Import Entries and choose the
.xlsxfile. - Review the import result. Rows with an unknown employee or pay type are shown but not registered. If a pay type has no vacation type, set Vacation Import Type. Then import a file that contains only the rejected rows. Importing the whole file again adds the hours of the rows that were already accepted a second time.
- If processed entries already exist, choose whether to skip them or overwrite them with the imported data.
- When the lines are correct, select Create Entries. The action creates entries for employees with an imported amount. If you run it again, it replaces the previous usage and sickness entries for the same employee and payout.
- Open the vacation and sickness entries to check the result, then continue to review paychecks.
Result
Vacation usage and sickness entries are recorded for the payout. Do not run Create Entries again unless the imported lines are correct, because the action rebuilds entries for the affected employee in the payout.