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.