Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

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

  1. Open the payout and select Register Vacation Usage and Sickness.
  2. Select Import Entries and choose the .xlsx file.
  3. 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.
  4. If processed entries already exist, choose whether to skip them or overwrite them with the imported data.
  5. 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.
  6. 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.

What can go wrong

  • You cannot import a file into a closed payout. See Help.
  • If an employee or pay type is shown as undefined, correct the code in the file or create the record in Payroll, then import a file with only the rejected rows. See Help.