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

Name

Select employee name(s) from list to filter report for name(s) selected 

Site

Site number

Emp #

Employee number

Name

Employee name

Job

Job assigned to employee

Job External Code

External code specified for job

Clock In

Clock-in time

Clock Out

Clock-out time

Reg. Hrs

Number of regular hours worked between clock-in and clock-out times

OT Hrs

Number of overtime hours worked

DT Hrs

Number 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 Hrs

Total hours worked (total of regular, overtime and double time hours)

Reg. Wages

Wages earned for regular hours worked 

OT Wages

Wages earned for overtime hours worked

DT Wages

Wages earned for double-time hours worked

Total Wages

Total 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 Tips

Declared 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: