Send hours to payroll

Owners and managers can export hours as a CSV file for their payroll software, so nobody types them in again. It's a file export, not a live connection.

Updated 16 November 2026 · Hosmere

Owners and managers can export hours as a CSV file for their payroll software, so nobody types them in again. It's a file export, not a live connection.

Before the first export, add each person's Payroll ID (works number) in their employee record, so the payroll software can match them.

  • In Rota, open Timesheets and approve the weeks you want to pay.
  • Tap Payroll, choose the period, then pick a Format:
  • Xero Payroll (UK timesheets): one line per person, day and earnings rate. Xero Payroll UK has no built-in CSV timesheet import, so use this file with a Xero timesheet import tool;
  • Sage 50 Payroll (hours and rates): Employee Reference, Payment Reference, Hours, Rate;
  • BrightPay (hourly payments): the BrightPay "Import Hourly Payments from CSV File" layout;
  • Generic CSV (one row per shift): for any payroll system;
  • Hosmere payroll summary.
  • Choose Overtime: No overtime split, hours over a weekly number, or hours over each person's contracted hours.
  • Download the file and import it in your payroll software.

Hours are worked hours from clock-ins, after unpaid breaks and manager adjustments. By default only approved weeks are exported. People without a payroll ID are listed so you can fix them (BrightPay can match by first name and surname). Hosmere does not calculate tax, deductions, sick pay or overtime premiums: your payroll provider does that.

Related: Logs, reports and backups.

Related guides

All help articles