Table of Contents

Import public holidays into work calendars and check calendars

The Working Calendar determines which days are public holidays and how many hours apply per day. With the Public Holiday Import report, payroll professionals import public holidays from an ICS or VCS file into the calendar for a working group or canton, fill the calendar, and check it—before the start of the year, after cantonal or company calendar changes, and before times and absences are transferred.

Prerequisites

  • At least one working group is set up.
  • An ICS or VCS file with the public holidays is available (for example, a download from the canton).
  • The day types are defined.

Import public holidays

  1. Open the Public Holiday Import report.
  2. In the File field, select the ICS or VCS file.
  3. Specify either a Working Group or a County—not both.
  4. Select the Day Type for the imported public holidays.
  5. Enter the Hours per Day (default: 8 hours).
  6. Start the import.
Hinweis

You can specify either a working group or a canton. If you select a canton, the public holidays are imported for all working groups in that canton.

Tipp

Use the Download Link in the report to download current ICS files from a public source for Swiss public holidays.

Fill the calendar

After importing the public holidays, fill the working calendar for the entire year with the Calendar Autofill report:

  1. Open the Calendar Autofill report.
  2. Enter Date from and Date to for the required year.
  3. Select the Day Type for regular working days.
  4. Start the processing.

The report creates a calendar entry for each day in the period if one doesn't already exist. Public holidays that have already been imported aren't overwritten if the Keep Day Types option is turned on.

Check the calendar

Open the Working Calendar page to check the entries:

  • Check that all cantonal public holidays are entered correctly.
  • Check the number of hours per day.
  • Identify missing or duplicate entries.

Export the calendar to Excel

Use the Export Working Calendar to Excel report to export the calendar for an external check or documentation:

  1. Open the Export Working Calendar to Excel report.
  2. Select the Year and Working Group.
  3. Start the export.

Good to know

  • If you specify Working Group and County at the same time, the import stops—public holidays are missing and scheduled times in the payroll run are incorrect.
  • If you import public holidays without running Calendar Autofill, working days are missing; absences and hourly salaries calculate with gaps.
  • An incorrect Day Type or Hours per Day causes incorrect public holiday valuation and salary entries that are too high or too low.
  • If you don't spot-check the Working Calendar, duplicate or missing days remain undetected and affect the next run.

See also