Payroll Summary

The Payroll Summary reports the hours, wages and other payroll information for selected sites(s) and/or site group(s) within a specified business date range. Employee records are in alphabetical order by employee name.

Optional feature - Account feature toggle required

Note: An optional feature allows Admin users to select the number of decimal places to use when rounding employee hours on time record reports. See Employee Reports for more information. 

An employee can have multiple records if they have multiple employee numbers and multiple jobs worked.

Records are shown by:

  • Employee name
    • Employee number(s)
      • Employee job(s) 

Columns can be filtered to show a subset of records. 

  • Expanded view: Default view shows records in expanded format. 

  • Collapsed view: Each layer (name, emp number, job) of each record can be collapsed to show summaries of each record by clicking the right-facing caret icon. 

Site(s), Group(s), Business Start/End Date
  • Select site(s) and/or site group(s)
  • Select start and end dates for date range of report

    • Default: current date
    • Select date from calendar tool or enter date
NameSelect employee name(s) from list to filter report for name(s) selected 
SiteSite number
Emp #Employee number
NameEmployee name
JobJob assigned to employee
Job External CodeExternal code specified for job
Clock InClock-in time
Clock OutClock-out time
Reg. HrsNumber of regular hours worked between clock-in and clock-out times
OT HrsNumber of overtime hours worked
DT HrsNumber of double time hours worked
Unpaid Break

Unpaid Break times

  • Count - Number of unpaid breaks taken
  • Mins - Number of minutes taken for unpaid breaks
Total HrsTotal hours worked (total of regular, overtime and double time hours)
Reg. WagesWages earned for regular hours worked 
OT WagesWages earned for overtime hours worked
DT WagesWages earned for double-time hours worked
Total WagesTotal wages for regular, overtime and double-time hours worked
Pay Rate

Hourly pay rate for job

Note: NorthStar has a feature that allows jobs and pay rates to be scheduled using an effective date. (Feature activation requires account feature toggle: Schedule Jobs and Rates.) If the feature is activated, changes made to the hourly pay rate and/or effective date will be reprocessed and the pay rate updated on the Payroll Summary report. After changes are made, payroll reprocessing is triggered by any of the following: 

  • Save changes in ECM 
  • Import Ultipro CSV file
  • ECM API update
Declared TipsDeclared tips
Net Sales (Total)Employee's net sales between clock-in and clock-out times 
Export report Save file in Excel, PDF or CSV format

Report exported to Excel format: