Balerion LogoBalerion
Get started
← ManualZeit und Lohn

Hours Report

The hours report is the only calculation engine for minutes. Payroll, invoicing and controlling all use the same source.

Requirements

  • Shifts planned
  • Time tracking in use

The three times

Each row shows three values that must be kept separate:

  • Planned time: the planned shift duration minus the break maintained for the service.
  • Actual time: from check-in to check-out. If check-out is missing, the calculation runs until the end of the shift, but no later than now. The break is not deducted from the actual time.
  • Counted time: the number that counts. It is the basis for payroll and invoices.
Balerion Security, Hours Report: The three times
The hours report for one month.

How counted time is determined

Billing is generally based on the planned time, not the clocked time. This leads to three points that regularly prompt questions in practice:

  • Anyone who stays longer only has the additional time counted after approval.
  • Anyone who leaves early is still billed for the planned time. Negative time does not reduce the counted time.
  • Anyone who does not check in at all is also billed for the planned time. However, the row only appears after the shift ends.

There is one exception: if a shift ends early because the security officer reports sick, uncovered time is created. It only counts after separate approval, see below.

Time rounding

If required, the counted time is rounded to an interval. Configure this under Settings, Calculation behavior card: interval of 5, 10, 15 or 30 minutes, with commercial rounding, rounding down or rounding up.

Rounding happens exactly once, at a single point in the hours calculation. This is why the report, payroll, analysis and working time account use the same number.

Only rows with a complete pair of clock events are affected. Rows billed according to the plan, ongoing shifts and rows without check-out remain exact to the minute.

Rounding is off by default. Calculations are exact to the minute. The interval and direction can only be set together or cleared together.

Importing times from a CSV file

If the actual times come from a time clock or external system, you can import them through "Import times" in the hours report.

The file requires the header personalnummer;datum;von;bis. A comma is also recognized as a delimiter. Use TT.MM.JJJJ or JJJJ-MM-TT for the date and HH:MM for the time. If the end time is less than or equal to the start time, it is treated as the following day. An existing "pause" column is deliberately ignored and acknowledged in each row.

First, you get a preview that writes nothing. Each row shows a status: Ready, No match, Ambiguous, Outside limits, Locked or Invalid. Matching uses the personnel number and start date. Multiple assignments on the same day result in "Ambiguous".

The import checks exactly the same rules as manual entry, so the same limits apply: a period of no more than 24 hours, check-in no more than 12 hours before the planned start, and check-out no more than 12 hours after the planned end. A closed month results in "Locked" instead of stopping the import. When you apply the import, every row is checked again rather than accepting the preview without verification.

The file may be up to 1 MB.

Approving overtime

Additional time compared with the plan initially appears in parentheses as "open" and is not included in any total. One click on "Approve" makes it count, and a second click withdraws the approval.

Every approval and every withdrawal is recorded in the log. Because the counted time is the basis for both payroll and invoices, one click in the hours report changes both at the same time.

Approve all visible processes the entire filtered period at once, even when it contains several hundred assignments. Approval is processed in batches. You only see the result.

Balerion Security, Hours Report: Approving overtime
When approving multiple rows, you decide how estimates are handled.

Uncovered time

If a security officer reports sick during the shift and a replacement takes over, the post is divided. If the replacement checks in late, a gap remains.

These minutes are not billed without notice. They appear with the "Uncovered" label and, like overtime, require explicit approval. Only the row ended due to sickness for a post staffed by multiple people can contain uncovered time.

Reconciliation and labels

Each assignment has an approval status, open or approved, along with labels such as "Check-in missing", "Check-out missing", "Deviation" and "Overtime open". The deviation label appears when the difference between planned and actual time exceeds 15 minutes.

Only a completed assignment can be approved, meaning one with a check-out or the status "not started" or "rejected". Rows without check-out have an explicit special path that approves the planned hours while deliberately inventing no timestamp.

Totals are always calculated from the complete set of rows, even if "open only" is selected above.

Balerion Security, Hours Report: Reconciliation and labels
Corrections require a reason and remain traceable.

Searching filters

The filters for security officer, site and customer are search fields: type, select from the suggestions, and you are done. Filtering only starts after a person or entry has been selected. A text fragment alone does not change the report. Clearing the field removes the filter.

The suggestions include all records. Even with very large numbers of security officers, sites or customers, the search finds every entry.

Related

Updated on: 03.09.2026