Pay Rate Table Example

If you are new to Payroll, you may find it helpful to review a pay rate table example.

Richard Brady's company is located in Massachusetts and he performs most of his work in Massachusetts. Some projects, however, are located out of state, and Richard gets paid a higher hourly rate for these projects.

To configure Vision with multiple pay rates for Richard, and determine which to use based on where he performs work, you use pay rate tables.

The following sample steps explain how to establish an employee's default, in-state rate, and an override out-of-state rate. The example then shows how to associate the override rate with a project, and explains what happens when an employee charges time to a project the uses the default rate, and a project that uses the override rate. Finally, the example shows what the employee is paid when payroll is processed based on these rates.

Prerequisites: Before these steps occur, the pay rate tables feature must be enabled on the General tab of Accounting System Settings. Also, the role performing these steps must have the proper security rights.

1. Set the default pay rate.

   You set Richard's default pay rate to $45.00 in the Pay Rate field on the Payroll tab of the Employee Info Center. Set his pay Type to Hourly.

2. Establish the override rate in the OutofState labor pay rate table.

   You create an OutofState Labor Rate table on the Pay Labor Rate Tables form and add one entry for Richard Brady, with an Effective Date of 7/1/14 and a Rate of $55.

3. Associate the default rate with the in-state project.

   Open project 2000004.01 from the Project Info Center and set the Pay Rate Method field on the Time & Expense tab to From Employee Pay Rate. This means the project is configured to use the default pay rate established for Richard Brady in the Pay Rate field on the Employee Info Center's Payroll tab.

   You can also associate a pay rate table directly with an employee, rather than with a project, from the Time & Expense tab of the Employee Info Center. Note that if an employee has a valid pay rate table and rate established at both the project and employee level, Vision uses the table and rate specified at the project level.

4. Associate the override table with the out-of-state project.

   Open project 2000003.01 and set the Pay Rate Method field on the Time & Expense tab of the Project Info Center to From Labor Rate Table. Select OutofState as the Rate Table.

5. Post Richard Brady's timesheet.

   Assume Richard Brady charges 88 hours to two projects in a two week pay period ending July 15, 2014.

   All of the work on Project 2000004.01 was performed in Massachusetts. Work on Project 2000003.01 was performed in New Hampshire.

6. Process payroll.

   Process payroll for the period ending July 15.  

   For the first 40 hours charged to project 2000004.01, Vision looks to the Project Info Center to determine that, for this project, Vision should use the employee's default rate to determine pay. Vision multiplies the default pay rate of $45 by the hours worked on project 2000004.01 (40) for a total of $1800.00.

   For the next 48 hours charged to project 2000003.01, Vision looks to the Project Info Center to determine that, for this project, Vision should use the OutofState rate table to retrieve the pay rate. Vision compares the effective date in the table with the transaction dates on Richard Brady's timesheet and multiplies these 48 hours by the override rate of $55 for a total of $2640.00.

   Richard's gross pay for this period (prior to deducting withholdings) is $4,440.00: