Sign Up
← All guides

Attendance sheet examples: vacation, home office and half days

Collabin can prefill a monthly attendance sheet from assigned work schedules and recorded absences. Home office, full-day leave and half-day leave affect the result differently. Review and correct the sheet before signing: prefilling does not measure actual clock-in and clock-out times.

What is needed for prefilling?

On Advanced and Pro, open Reports β†’ Attendance sheets, choose the month and employees, and enable Prefill working times. The option is off by default. Each employee receives one A4 page, which can also be saved as PDF through the print dialog.

An effective-dated work schedule must be assigned to the employee. For example, 08:00–16:30 with a 30-minute unpaid break produces 8 working hours. The break is an illustration, not a universal requirement. Follow the work schedule guide to create and assign templates.

How are different days filled?

These examples use the same eight-hour schedule and a workday in the organization's calendar.

DayPrefilled timesWhat to check
Office work08:00–16:30, net 8 hoursDoes it match actual work?
Full-day home officeSame, if the type counts as working timeIs that type setting enabled?
Approved full-day vacationBlank timesAre the absence and dates correct?
Half-day vacationManual time entry neededWhat were the actual start, end and break?
Half-day home officeDoes not by itself shorten the workdayWas the rest of the day worked too?
Non-working day or public holidayBlank timesIs the company calendar correct?
Missing work scheduleBlank times and a warningAssign a schedule or fill manually.

Previously approved leave awaiting cancellation approval still counts as an absence until decided. A merely pending leave request is not an approved absence.

Why is a home-office day blank?

The name is not enough. An Admin must enable Counts as working time for the home-office type and check the schedule assignment. That setting affects attendance prefilling; the monthly home-office quota is configured separately.

What happens when a schedule changes mid-month?

If a new schedule starts on 16 November, earlier days use the previously applicable schedule. A backdated correction changes the affected days on regenerated sheets too. Check the effective date before reprinting a month that has already been reviewed.

To change template hours, create a replacement template and a new assignment. Selecting No schedule / manual entry stops prefilling from the chosen date.

Checklist before signing

  1. Check the employee, month and workplace.
  2. Reconcile holidays and additional working days.
  3. Review absence statuses, including cancellation requests.
  4. Complete blanks caused by half-day leave or missing schedules.
  5. Correct prefilled values that differ from actual work.
  6. Check daily and monthly totals, then obtain signatures under your process.

When data is incomplete, the monthly total may remain blank rather than show a misleading partial total. The feature does not calculate overtime or support overnight shifts and rotating multi-week schedules.

Frequently asked questions

Does hiding absence labels fill working hours on vacation days?

No. Hiding labels does not turn off absence handling.

Is a prefilled sheet automatically a verified working-time record?

Prefilling starts from configuration. Actual work and the applicable record-keeping requirements still need to be checked.

Next, configure work schedules or compare the available plans.

Next steps

Free attendance sheet template: Excel and print.