Payroll summary

Payroll summary#

For: Manager | Admin You’ll need: Permission to view reports (your manager will know).

The payroll summary shows per-person pay totals for a pay period — regular hours, one ‘Overtime (h)’ column, premium hours, paid and unpaid absence, ‘Time compensation’, and gross pay. The CSV export is the file your payroll vendor expects.

Hours worked on a shift that was later cancelled, or that the person had declined, still count — the same shifts the timesheet shows.

Open the report#

  1. In the sidebar, open Reports → Payroll summary.

The report opens on a default period; pick your payroll cycle from the period dropdown.

Filter the data#

The period is the primary filter; everything else narrows the rows inside it.

  1. Open the period dropdown in the toolbar and pick a range: ‘Today’, ‘This week’, ‘Last week’, ‘This bi-weekly’, ‘Last bi-weekly’, ‘This month’, ‘Last month’, ‘Last 30 days’, ‘Last 3 months’, ‘This year’, ‘Last year’, ‘YTD’. The trailing ‘Custom’ option is what the dropdown shows once you set your own dates; it is not something you pick.

  2. (Optional) Click the filter icon in the toolbar, choose ‘Location’, tick one or more locations, and click ‘Apply’.

  3. (Optional) Open the filter menu again and do the same for ‘Person’, then for ‘Status’.

For free-form dates, choose ‘From’ and ‘To’ from that same menu — the dropdown switches to ‘Custom’. Each filter you add shows as a chip under the toolbar — click the chip to change it, × to remove it, or ‘Clear’ to drop them all.

Tip

‘This bi-weekly’ and ‘Last bi-weekly’ appear in the list regardless of your payroll frequency; their boundaries are computed from the company’s ‘Payroll anchor date’. If the cycles don’t line up with what your payroll vendor expects, ask your admin to update the anchor date.

Export#

See Export a report (CSV, XLSX, PDF) for CSV, XLSX, and PDF details.

The payroll CSV is semicolon-delimited and follows the payroll-vendor schema. Its first field is employee_external_id; the full header row is:

employee_external_id, last_name, first_name, shift_count, worked_hours, regular_hours, overtime_hours, night_hours, sunday_hours, holiday_hours, paid_absence_hours, unpaid_absence_hours, pay_period_start, pay_period_end, currency_code, hourly_rate, overtime_multiplier, night_multiplier, sunday_multiplier, holiday_multiplier, time_account_payout_hours, randstunde_cash, night_credit_payout_hours, meal_premium_hours, rest_premium_hours

The last five columns were added later, after the others, so an importer that reads columns by position keeps working.

Missed-break pay#

Where a break policy pays for missed breaks, add ‘Missed meal pay (h)’ and ‘Missed rest pay (h)’ with ‘Manage columns’. They show the extra hours owed for missed breaks on the workdays in the period — a workday still waiting for its break check adds nothing yet. The hours stand outside worked hours and gross pay: your payroll applies the rate. See How missed-break pay works.

Read the total row#

Under the per-person chart, a bold ‘Total’ row sums both the cost and the hours across everyone on the list — the numbers you hand to finance, without exporting and adding them up yourself.

Warning

The premium hour columns — night, Sunday, holiday — are tags that can overlap: an hour worked on a Sunday night counts in both the Sunday and the night column. Don’t expect them to sum to worked hours.

Verify it worked#

The period dropdown shows the option you picked — or ‘Custom’, with the dates on the ‘From’ and ‘To’ chips below the toolbar. Each row is one person, and gross pay reflects regular plus overtime plus premiums plus paid absence.