Cost/Pay Labor Rate Tables

Use a cost/pay labor rate table to set up labor rates to override the cost and/or pay labor rates entered for employees in the Employees hub.

You can assign cost/pay rate tables to a project in the Projects hub when a project drives the cost and/or pay rates for the employees who work on the project. For example you could set up cost/rate pay tables for a specific project or group of projects when a specific industry or government entity defines the cost rates expected for the projects. A secondary use for cost/pay labor rate tables is to define effective dates for the cost and pay rates for employees. For example, you might update rates each year, and you can enter cost/pay labor rates with their effective dates in the rate tables. An effective date is the date on which to begin using the rate. Vantagepoint looks at the detail dates for an employee 's timesheet and for payroll processing to apply the correct rate to labor charges.

When you create a cost/pay labor rate table, you specify whether the rate table applies to cost rates, pay rates, or both. For each employee that you add to the table, enter a labor rate and an effective date for the rate if appropriate. Each employee in a labor rate table can have one row that does not specify an effective date; use this row to indicate a default rate to use if no other row has an applicable effective date.

You can assign a cost/pay labor rate table to projects, employees, or both in the following locations:

  • In the Projects hub: Assign cost/pay labor rate tables in the Cost and Pay Rates section of the Accounting tab. In the Cost Method field, select From Labor Rate Table. Then select the appropriate cost labor rate table in the Cost Table field. In the Pay Method field, select From Labor Rate Table, and then select the appropriate pay labor rate table in the Pay Table field.
  • In the Employees hub: Assign a cost labor rate table in the Job Cost section of the Accounting tab. In the Cost Rate Table Method field, select From Labor Rate Table. Then select the appropriate cost labor rate table in the Cost Rate Table field. Assign a pay labor rate table in the Payroll Information section of the Payroll tab. In the Pay Rate Table Method field, select From Labor Rate Table. Then select the appropriate pay labor rate table in the Pay Rate Table field.

To determine cost amounts, timesheet postings first look to the cost rate table assigned to the project, then to the cost rate table assigned to the employee, and finally to the cost rate entered directly for the employee in the Employees hub in the Cost Rate field in the Job Cost section of the Accounting tab. Vantagepoint uses the first cost rate it finds.

To determine an employee’s pay rate, payroll processing first looks to the pay rate table for the project, then to the pay rate table for the employee, and finally to the employee pay rate entered directly for the employee in the Employees hub in the Pay Rate field in the Payroll Information section of the Payroll tab. Vantagepoint uses the first pay rate it finds.

To access cost/pay labor rate tables, you must have access to the effective dates feature in Accounting (cost), Payroll (pay), or both.