Columns for the Payroll Labor Detail Report

Use the Columns tab to select and set up columns for your report.

Contents

Field Description
Date This column displays the date on which the transaction was posted.
Employee Status This column displays an employee's status: Active, Inactive, Terminated, or Terminated (cannot reactivate).
Labor Code This column displays the labor code to which the employee charged time. An employee may be assigned different labor codes on different projects, if they are performing different types of work.
Organization If your enterprise uses organizations, this column displays the code for the employee's assigned organization. This column only displays if you select Include Employee Organization on the Options tab for the report.
Overtime Hours This column displays the number of standard overtime hours for which the employee was paid.
Overtime Pay Amount This column displays the amount paid for overtime hours, calculated as follows:
  • For hourly employees: Overtime hours x Hourly pay rate x Overtime percentage.
  • For salaried employees: Overtime hours x Annualized hourly rate x Overtime percentage. (Annualized hourly rate = Annual salary / Estimated annual regular hours. Estimated annual regular hours = Hours per week x 52.)
Overtime Pay Percentage This column displays the percentage applied to the employee's pay rate to calculate an overtime pay rate.
Overtime Pay Posting Sequence This column displays the accounting period in which the overtime payroll processing run was posted.
Overtime Pay Rate This column displays the rate at which the employee is paid for overtime hours.
Regular Hours This column displays the number of regular hours.
Regular Pay Amount This column displays the amount paid for the regular hours.
Regular Pay Posting Period This column displays the accounting period in which the regular payroll processing run was posted.
Regular Pay Posting Sequence This column displays the posting sequence number for the regular payroll run.

Vantagepoint assigns 1 to the first group of transactions posted during an accounting period; 2 to the second group, and so on. Vantagepoint assigns the letter C to any transactions brought in via history loading to indicate that the data came from a conversion or transfer.

To see a numbered list of all of the postings for the current accounting period, click Transaction Center > Posting Review Report.

Regular Pay Rate This column displays the rate at which the employee is paid for regular hours.
Row Count This column displays the total number of detail lines for each group, based on the sorting and grouping selections. If the report groups data at more than one level, this column displays row counts for all grouping levels.
Secondary Overtime Hours This column displays the number of secondary overtime hours. Secondary overtime is paid at a different rate than standard overtime. This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Secondary Overtime Pay Amount This column displays the amount paid for secondary overtime hours.

This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.

Secondary Overtime Pay Percentage This column displays the percentage applied to the employee's pay rate to calculate an overtime pay rate.
Secondary Overtime Pay Rate The rate at which the employee is paid for secondary overtime hours, which is different than the rate for standard overtime hours.

This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.

Transaction Date This column displays the date on which the transaction was posted.
Total Hours This column displays the total number of hours entered on the timesheet: Regular Hours + Total Overtime Hours.
Total Overtime Pay Amount This column displays the amount paid for the overtime hours.
Total Pay Amount This column displays the total amount paid for regular and overtime hours.
Transaction Date This column displays the date on which the transaction was posted.