Skip to content
Regsta
Regsta

How do I get hours into payroll?

Written for
  • Admin
  • Payroll

Short answer

Approve the hours first, then open Close period & export. Generate the payroll file for a pay summary at each person's hourly rate, or download the time entries as CSV or Excel. You import the file yourself: Regsta sends nothing to the payroll system.

The payroll file

  1. Open Close period & export and find Payroll file.
  2. Choose From and To for the pay period. Each person's stored hourly rate is used; type a rate to override it for this run only.
  3. Choose Generate payroll file, then Download file.

The file is one CSV for every country, in your company's currency, with one line per person and hourly rate: Employee number, Name, Period start, Period end, Hours, Hourly rate, Currency and Gross pay. Only approved hours are in it. Regsta adds no overtime or supplements: your payroll system applies your pay rules. A person without an employee number or without an hourly rate for a worked day is left out and named on the screen, and the totals come with a SHA-256 checksum.

Import files for QuickBooks Online, Gusto, Sage 50 Payroll and BrightPay

In the Payroll file panel, File format also offers an import file for each of these payroll systems. They contain the same approved hours as the pay summary: regular hours with breaks deducted, one line per person, identified by employee number. Regsta calculates no overtime or premiums, so the files carry none; your payroll system applies them. These are files you import yourself, not a connection. Xero Payroll UK is not offered because Xero does not document a CSV timesheet import for it. Each vendor's own help page is the final word on its screens; the page used is named under each heading.

QuickBooks Online (columns: Date, Employee, Employee name, Hours)

  1. Choose File format: Import file for QuickBooks Online, then Generate payroll file and Download file.
  2. In QuickBooks, open Payroll, then Employees, then Manage Employees, then Import Timesheets, and choose Custom file upload.
  3. Select the file and set the date format to MM/DD/YYYY.
  4. Assign a data type to each column in the preview: Date for Date, Hours (units) for Hours, and Employee for the employee number. Choose how the timesheets are approved, then select Import.
  5. Source: https://quickbooks.intuit.com/learn-support/en-uk/help-article/time-tracking/importing-timesheets-quickbooks-online-advanced/L5RR0QwSw_GB_en_GB

Gusto (columns: Last name, First name, Employee number, Regular hours)

  1. Choose File format: Import file for Gusto, then Generate payroll file and Download file.
  2. In Gusto, start the payroll and choose to upload a spreadsheet or CSV.
  3. Upload the file. Gusto matches the columns and the people by name; check each match before you continue. A blank cell leaves an entry unchanged, a zero overwrites it.
  4. Source: https://support.gusto.com/payroll/payroll-settings/CSV-Upload/999914471/Upload-payroll-data-with-a-CSV.htm

Sage 50 Payroll (columns: Employee Reference, Payment Reference, Hours)

  1. Choose File format: Import file for Sage 50 Payroll, then Generate payroll file and Download file.
  2. Open the file and enter your pay element code in Payment Reference for each line, then save it as CSV and close it in Excel.
  3. In Sage, take a backup, then choose File, Data Import, Sage Payroll data, and the template Employee Payments (Hours and Rates).
  4. Browse to the file and choose Finish. Employee Reference must equal the employee number held in Sage exactly. If Sage's own template uses different headings, copy the columns into its template.
  5. Source: https://gb-kb.sage.com/portal/app/portlets/results/view2.jsp?k2dockey=200427112158188

BrightPay (columns: Works number, First name, Surname, Normal hours)

  1. Choose File format: Import file for BrightPay, then Generate payroll file and Download file.
  2. In BrightPay, choose Payroll, then More, then Import Pay Records from CSV File, then Import Hourly Payments, and browse to the file.
  3. For each column, choose the payment data it stands for: Works number, first name, surname and normal hours. BrightPay matches people on works number, name or NI number.
  4. Select Import.
  5. Source: https://www.brightpay.co.uk/docs/24-25/importing-pay-data-using-csv-file/importing-hourly-payments-using-csv-file/
Check the first import against your own records. The employee number from Regsta must match the reference your payroll system holds for each person; map or correct it once.

Export for any payroll system

  1. Open Close period & export.
  2. Under New export, choose the type and the period. You can narrow it to one person or to approved time entries only.
  3. Choose Generate export. The file downloads, and the export is logged with its number of rows.
Regsta has no connection to your payroll system and sends nothing to it. You download a file and import it yourself.

Did this not answer your question?

Tell us what you were looking for and we will answer it.

Contact us