Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
job_cost_setting_up_payroll_htm
job_cost_setting_up_payroll_htm
Set up Job Cost payroll in the following order:

...

Child pages (Children Display)

Anchor
job_cost_overview_of_overhead_co_7228
job_cost_overview_of_overhead_co_7228
Anchor
job_cost_overview_of_overhead_co_1950
job_cost_overview_of_overhead_co_1950
Overview of overhead codes

Overhead is the indirect, job-related cost your company incurs in the process of doing business. Examples of overhead costs are workmen's compensation and benefits earned by hourly employees. Overhead may also include items such as administrative salaries, rent expense, and other indirect expenses incurred in a job.

Job Cost allows you to recognize the overhead cost of labor by creating overhead detail codes and assigning those codes to overhead groups. The overhead groups are associated with position/department codes, which are associated with employees. The employee and job are entered in the payroll transaction. After a transaction is posted, the overhead is applied to the job.

Overhead detail codes

Overhead detail codes define how overhead amounts are calculated based on payroll costs. You can recognize indirect labor costs, not typically set up as cost codes on an hourly or piecework basis, as overhead. These costs are added to posted amounts for the detail and are not identified separately on customer invoices.

...

The methods for calculating overhead are flexible. You can allocate overhead on a cost-per-unit basis to a labor cost code or as a percentage of cost, or a combination of both.


Note

You must set up detail codes for overhead in Job Cost regardless if you apply overhead to your jobs. To do so, create an overhead detail code for zero percent or zero dollars per unit.

Overhead group codes

Overhead group codes organize overhead detail codes logically per departments, positions, and pay codes. For example, assume you set up detail codes for hourly workmen's compensation overhead and hourly driving time to a site. You combine these details under a group code named Hour and specify that the code applies to technicians assigned to the installation department.

...

To post payroll transactions, you must set up at least one overhead group. Even if your company does not assign overhead costs to jobs, you must create an overhead detail code for zero percent or zero dollars per unit. You then assign the code to overhead group codes for each job department/position combination. See Setting up overhead group codes.

...

Setting

...

up

...

Overhead

...

Note

If you have unposted payroll transactions (for either Microsoft Dynamics GP Payroll or TimeTrack), do not change overhead detail codes (or create new codes and assign them to affected overhead accounts) until all unposted transactions are posted. Otherwise, posting these transactions could result in unbalanced general ledger entries. Contact Key2Act Support for assistance.

...

  • Fixed portion: Allows you to allocate overhead on a cost per unit basis for payroll transactions. For example, if you want to apply hourly overhead to account for the cost of employees driving to and from a job site, you could add $1.50 per hour (the unit of measure) with an overhead detail code to cover the cost.
  • Percent portion: Allows you to allocate overhead on a percentage basis for payroll transactions. For example, you can set up an overhead detail code for the cost of taxes incurred on an employee's pay rate that adds 16 percent of the payroll wages.

...

If you use the Microsoft Dynamics GP Payroll module, Job Cost uses the departments, pay codes, and positions entered in that module for the overhead group codes. If you do not use Microsoft Dynamics GP Payroll, you must enter employee master records, department, position records, and pay codes if you want to recognize overhead.
Note: You must set up group codes for overhead in Job Cost regardless if you apply overhead to your jobs. To do so, create an overhead detail code for zero percent or zero dollars per unit. Assign this overhead detail code to the All overhead group code for job department, position, and pay code.

...

Group Codes

...

Facilitating setup by using All

Since the number of combinations of department, position, and pay code for a given overhead group code can become quite large, you can facilitate the setup by entering the word All in any of those fields. For example, if all departments, all positions, and all pay codes have a general overhead detail code, All could be used with each of those items.
If a specific combination of department, position, and pay code has a unique detail code, that combination will be used along with any All combinations for the overhead group that match the same criteria. For example, if the administration department, CEO position, and salary pay code combination had a special bonus overhead detail code, and the All departments, CEO position, and All pay codes combination also had a bonus overhead detail code, both detail codes would be used.

...

Federal classification codes are assigned to employees in the Employee Maintenance window or to transactions during Job Cost payroll entry.
If you use Microsoft Dynamics GP Payroll to print payroll checks, these classifications appear on certified payroll reports printed from Job Cost (Reports > Job Cost > Labor Reports > Certified Payroll).

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Federal Classification Codes.
  2. Enter a Fed Class Code and Description.
  3. Choose Save.
  4. To print the Federal Classification Codes report, choose File > Print or choose the printer button.

...

If you employ union members, you can enter benefit and deduction categories to be included on your Job Cost Union report. Benefit and deduction categories are assigned payroll benefits and/or deductions. These are calculated during payroll processing and printed on the Job Cost Union report.
Once union categories are created, you assign the categories to a union code using the Benefits and Deductions buttons in the Union Code Setup window.
Note: A maximum total of 150 benefits and deductions print on the Union report.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Union Categories.
  2. Enter a Union Category.
  3. Mark the appropriate check box to determine which window the union categories will be displayed in:
    • Display in union benefit window: Union categories will appear in the Union Benefits Setup window.
    • Display in union deduction window: Union categories will appear in the Union Deductions Setup window.
  4. Choose Save.
  5. To print the Union Categories List report, choose File > Print or choose the printer button.

...

You can set up union codes that identify the unions your company is required to report to. Once unions are created, you can assign benefits, pay codes, and deductions.
Step 1:         Create a union code.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Union Codes.
  2. Enter the union code, description, and address information. The Benefits, Hours, and Deductions buttons become enabled.
  3. Choose Save.

Note: Deduction and benefit codes must be set up in the Microsoft Dynamics GP Payroll module.

  1. To print the Union Code List report, choose File > Print or choose the printer button. The report includes a union employee's earned wages, benefit, and deduction amounts for a specified period of time.

...

  1. Choose the Benefits button in the Union Code Setup window. You can assign the benefits provided by a union to the union codes. Example benefits include 401K and life insurance.
  2. Choose a benefit category from the Benefit Category drop-down list. This list contains the benefit categories defined in the Union Category Setup window.
  3. Choose a Benefit Code in the list and then choose Insert >>. The benefit code appears in the Union Benefits list.
  4. Choose Save.
  5. To print the Unions Benefits/Deductions List report, choose File > Print or choose the printer button.

...

  1. Choose the Hours button in the Union Code Setup window. You can assign pay codes set up in Microsoft Dynamics GP Payroll to a union pay type for the union code. Example pay codes include hourly and overtime.
  2. Choose a pay type from the Union Pay Type drop-down list.
  3. Choose a Pay Code in the list, then choose Insert >>. The pay code appears in the Union Codes list.
  4. Choose Save.
  5. To print the Unions Benefits/Deductions List report, choose File > Print or choose the printer button.

...

  1. Choose the Deductions button in the Union Code Setup window. You can assign deductions associated with a union to the union codes.
  2. Choose a deduction from the Deduction Category drop-down list.
  3. Choose a Deduction Code in the list and then choose Insert >>. The deduction code appears in the Union Deductions list.
  4. Choose Save.
  5. To print the Unions Benefits/Deductions List report, choose File > Print or choose the printer button.

...

You can set up a relationship of employees to their union code and/or federal classification in the Employee Maintenance Codes window.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Employee Codes.
  2. Enter an Employee ID. The Name defaults.
  3. Enter a Rate Class. See Setting up rate classes for union payroll.
  4. Enter a Union Code.
  5. Enter a Federal Classification.
  6. Choose Save.
  7. To print the Employee Maintenance report, choose File > Print or choose the printer button.

...

Rate classes allow you to assign wage rates, benefits, and deductions to union employees by category. Within a particular rate class/union, you can create multiple rate classes based on different combinations of positions, pay codes, and deduction/benefit categories.

  • Multiple unions for one rate class: You can have multiple unions for the same rate class. This is useful if you have employees from multiple trades employed on the job, or an employee who works for another union local (besides his home local) for a short amount of time. Conversely, you can also have one union be part of multiple rate classes.
  • Multiple calculation methods for benefits and deductions: You can calculate benefits or deductions based on % of Net Wages, % of Gross Wages, % of Deduction, and % of Earnings Wages, just as you can in Microsoft Dynamics GP. In addition, the system allows fixed Microsoft Dynamics GP benefits and deductions to be calculated, even if they are not set up as being part of a rate class, for example, if an employee has garnishments set up in GP.
  • Prevailing wage and benefit determination: You can implement prevailing wage and fringe rates into your payroll calculations, based on the information from the government-supplied Davis-Bacon Act (DBA) wage determination sheet. This information is based on the union, county and occupational (fed class) code and includes standard and overtime rates for wage and fringe benefits.

The rate class feature allows employees to use the same "base" pay codes and benefit codes, relying on the system to substitute the appropriate pay rate or benefit/deduction calculation depending on several factors such as varying union local guidelines, job location (for example, Milwaukee vs. Chicago), or even the type of job (for example, heavy commercial vs. light commercial).
An example would be when an employee receives a completely different compensation package for a period of time, such as when a journeyman is the most senior person on a job site and thus qualifies for the Foreman wage and benefit package for that period of time.
The rate class calculates rates based on a matrix of job positions (classification), pay codes, and union codes; each of which can be changed on a line by line basis on the timesheet.

Note

Before you install the latest Microsoft Dynamics GP service pack relating to payroll issues, and before you use rate classes, contact Key2Act Support.

Before you begin

Before you use rate classes, make sure the following have been set up:

  • Employee pay codes, deductions, and benefits
  • Union categories and union codes

If the deductions and benefits are not set up for an employee, they will not be included in the paychecks.

  • To set up pay codes, choose Microsoft Dynamics GP > Tools > Setup > Payroll > Pay Code.
  • To set up deductions, choose Microsoft Dynamics GP > Tools > Setup > Payroll > Deductions.
  • To set up benefits, choose Microsoft Dynamics GP > Tools > Setup > Payroll > Benefits.
Note

Once you decide to use rate classes, make sure you set up all pay codes as part of a rate class. Otherwise, checks will be calculated based on Microsoft Dynamics GP Payroll instead of rate classes.

Setting up rate classes

Setting up rate classes involves the following:
Step 1: Enable the rate class feature
Step 2: Set up rate class codes
Step 3: Set up rate class detail
Step 4: Assign rate classes to union employees
Step 5: Assign rate classes to jobs
Step 1:         Enable the rate class feature
You enable the rate class feature in the Posting Options window.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Job Cost Setup > Posting Options.
  2. In the Payroll section, mark the Rate Class check box.
  3. Choose Save.

Step 2:         Set up rate class codes
This is where you enter your rate class codes, enable prevailing wage and fringe rate calculation feature (which includes use highest wage rate), or only the use highest wage rate (excluding prevailing calculation).

  1. Enter a Rate Class code name. Give some thought as to how you want to categorize/name your rate classes. For example, if you are setting up your rate classes to reflect the type of job, for example, heavy commercial vs. light commercial, indicate that in the rate class name.
  2. Complete the remaining fields, as necessary.
    • Rate Class: Enter the name of your rate class, being as descriptive as possible.
    • Description: It might be a good idea to include the names of the unions assigned to this rate class, in this description.
    • Use Prevailing Wage and Fringe (Davis Bacon): If your organization pays its employees' wages and fringes based on the government-supplied wage determination sheet, mark this check box so that you can set up rate classes to automatically calculate those rates and fringes. If this check box is marked, the second is automatically marked. When you mark this check box, the Use Highest Wage Rate check box is marked automatically, as the prevailing feature must first determine the highest wage rate for an employee.
    • Use Highest Wage Rate: If your organization pays its employees the highest rate no matter what, mark this check box, and leave the other check box unmarked. The system deter mines the highest rate from the following: 1) employee 2) rate class 3) job rate class and 4) transaction (if different).
  3. Choose Save.

...

Note

You can set up multiple rate classes for the same union.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Rate Class.
  2. Choose a Rate Class code.
  3. Fill the remaining fields, as necessary.
    • Federal Classification Code: The federal classification code is an assigned code for this type of work. This field acts as a filtering field, which allows you to view the rate classes for just one particular federal classification code.
    • Union Code: Enter a union code to be associated with this rate class.
    • Payroll Record Type: Choose from Pay Codes, Deductions and Benefits.
    • Position: The job position associated with this union/rate class.
    • Deduction/Benefit Code: If the Payroll Record Type is Deductions or Benefits, choose a Deduction/benefit code from the lookup.
    • Calculation Method: Choose from the following:
      • Percent of Gross Wages: e.g. 401K matching based on employee contribution
      • Percent of Net Wages: e.g. Vacation pay or employee garnishments
      • Amount Per Unit: e.g. Pension, Health and Welfare
      • Percent of Earnings Wages: e.g. Over-scale pay rates
    • Pay Code: The pay code associated with this rate class, for example, hourly, salary, overtime, double time, and so on.
    • Dollar Amount/Percentage: For pay rate or deduction/benefit, enter a dollar amount if the calculation method is Amount per Unit, or a percentage if the method involves a percentage, for example, % of gross wages. 

      Note

      If you will be printing the Microsoft Dynamics Worker's Compensation Summary report (Reports > Payroll > Period-End), you will need to up the Job Cost Rate Class amount so that it takes into account the pay factor for the pay codes set up in Microsoft Dynamics GP. For example, if you are creating an overtime rate class and in Microsoft Dynamics GP you've created a standard pay code that is $10/hr and then create an Overtime pay code that has a pay factor of 1.5 and is based on the standard pay code, you will need to enter $15 for the Overtime rate class.

       

  1. When finished, choose Save. Your new rate class will appear in the scrolling window in the lower portion of the window.Proceed with adding other unions to the current rate class - OR - create additional rate classes.
  2. To print the Rate Class report, choose the printer button. This report contains a list of all rate classes and their associated unions. If a rate class is selected when you choose the printer button that the rate class and union code will default as the selection criteria in the Rate Class Report window. To edit a rate class, double-click a record and edit the fields. If you change the Position, Pay Code, or Deduction/Category field, a new record will be created. The record you first selected is not overridden. The first record is overridden only if you change the amount or percentage in the Calculation Type field.
Note
You cannot delete a rate class if it is assigned to an employee, a job, an uncommitted TimeTrack transaction, or uncommitted Microsoft Dynamics GP Payroll transaction. You can delete an entire rate class (and all its records) if a rate class is selected and none of the individual records are selected.See Copying rate classes.

Step 4:         Assign rate classes to union employees
You can assign a rate class to each union employee. Each employee can be assigned to only one rate class.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Employee Codes.
  2. Enter an Employee ID.
  3. Enter a Rate Class. The Union Code field automatically defaults to the union code associated with that rate class.
  4. Enter a Federal Classification Code.
  5. Choose Save. You can also assign a rate class to an employee in the following ways:
    • Assign a rate class to a job that an employee is associated with. This overrides the rate class in the Employee Maintenance Codes window. See Assign rate classes to jobs.
    • Assign the rate class to payroll transactions. The rate class is assigned to the employee for that transaction only, and overrides the rate class assigned in the Job Maintenance and Employee Maintenance Codes windows.

...

  1. Choose Cards > Job Cost > Job.
  2. Complete the Job Maintenance window, assigning a rate class to the job. See Creating a job record.
  3. Choose Save.

For information on processing payroll with rate classes, see Processing payroll with union rate classes (optional). This section also contains examples of the many uses of the rate class feature.

...

You can copy an existing rate class to save time. When you copy a rate class, all position/pay code/deduction-benefit category combinations are copied also.
Only rate classes that contain valid pay codes and deductions/benefits will be copied.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Rate Class.
  2. Choose a Rate Class and choose Copy.
  3. Choose Copy to the message asking if you want to copy the rate class.
  4. Enter a New Rate Class, Rate Class Description, and New Union Code.
  5. Choose Copy.

...

In a union environment companies are faced with complex methods to determine the rate of pay for an employee. In addition to specific wage rates based on the worker's experience level and classification within a union, the location of the work and the employee's relationship with the company can become a factor. There are cases where the locality should dictate the rate for an employee, where the scale rate in the home union should dictate the rate, and cases where the employee is paid a rate above both of these. This features helps the scenario where the worker gets paid the highest rate. For example, the employee's home union might be Milwaukee, but could work temporarily on a job in Appleton. The Milwaukee union's pay rate is higher than Appleton's, hence, for incentive or other reasons, the Milwaukee union might agree to pay the employee their higher home rate. If your company supports similar over-scale scenarios, follow the steps below to implement this feature into your payroll system. This feature supports payroll transactions created in Payroll Transaction Entry in Microsoft Dynamics GP and in Time Track.

How it works

Once set up, the system will use the higher pay rate from one of the following:

  • Rate class for employee's union
  • Rate class assigned to the job
  • Employee personal rate (pay code)
Note

The highest pay rate feature applies only to pay rates, NOT to benefits and deductions.

Setup requirements

To set the system to use the highest pay rate, you must mark the check box Use higher pay rate, for ALL rate class groups, in the Rate Class Setup window.

  1. Choose Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Rate Class. The Rate Class Setup window opens.
  2. Choose a rate class.
  3. Mark this check box: Use higher pay rate.
  4. Choose Save. Proceed to mark this check box for all rate classes.

Transaction entry

When you create a payroll transaction with these rate classes, the higher rate will be filled into the respective Pay Rate fields. If you are using Signature TimeTrack, if the rate class and union differ between the employer's home union and the union he/she happens to be working on currently, you must change the union code on the transaction to a union code that is assigned to the job rate class (in the Edit Payroll Fields window). If the two venues are part of the same union, then the only thing that might change is the pay rate.
After entering payroll transactions, commit and/or post as you normally would.

Union Reports

On union reports, the union code that will display is the union that the employee worked with while on the job. On the Employee Union report, you will see the employee's home union and the union from the job.

Example:
Employee works on a job for a different union local, and has been approved to get paid the higher rate, which happens to be his home union local. This example uses TimeTrack for payroll transactions.

Employee, WILLIE GREEN, is working on a job for the Sheet Metal Local Appleton union. His home union is Milwaukee, and he is performing the same duties in Appleton as does in his home union. In spirit of reciprocity, the Appleton local has agreed to pay Willie his home rate, which is the higher rate of the two unions.

For purposes of this example, we will assume that the Use higher pay rate check box has been marked for all rate classes in the Job Cost system. This example uses TimeTrack.

Pay rates:
Our fictitious system is set up with the following pay rates:

  • Job pay rate (from a rate class assigned to job): $23.45/hour
  • Home union pay rate (from a rate class assigned to employee): $26.75
  • Pay code pay rate: $20.00

Transaction:
We will create TimeTrack transaction for WILLIE GREEN and show that the system will use the highest pay rate of the three:
Image Removed
The Pay Rate filled correctly with $26.75.
In the Edit Payroll Fields window (expansion button in Pay Code field), the Rate Class fills from the job, and the Union from employee. Because the rate class and union code for Willie's union differ from the Milwaukee union, we must change the union.
Image Removed
After changing the union, the Window looks like this:
Image Removed
If you create more transactions for this job, and the unions differ, you must change the Union field in the Edit Payroll Fields for every transaction.

...

You can implement prevailing wage and fringe rates into your payroll calculations, based on the information from the government-supplied Davis-Bacon Act (DBA) wage determination sheet. This information is based on the union, county and occupational code (fed class code) and includes standard, and overtime rates for wage and fringe benefits. You might have several different classes of workers on the same Davis-Bacon job (pipefitters, boilermakers, and so on). Each class of employee must be paid their appropriate determination. The actual wages plus employer-funded fringe benefits must equal or exceed the prevailing wage plus the prevailing fringe benefit amount equal or greater than the prevailing wage plus the fringe benefit amount - on an hourly basis (union or non-union) - as the base rate.
If an employee is due a cash fringe amount, which is paid in cash instead of contributing to the fringe benefit fund, the system calculates that amount and adds it to the employee's total hourly wage.
This feature accommodates several prevailing wage and benefit scenarios, including the following:

  • Prevailing wage is higher than employee standard wage.
  • Employee standard wage is higher than prevailing wage.
  • Prevailing fringe is higher than employee standard fringe.
  • Employee standard fringe is higher than prevailing fringe.
  • Prevailing wage is higher than employee standard wage but employee standard fringe is higher than prevailing fringe.
  • Prevailing fringe is higher than employee standard fringe but employee standard wage is higher than prevailing wage.

Note: An excess in either component (wage or fringe) can offset a shortfall in the other component under the Davis-Bacon Act.

About prevailing feature and rate classes

If you also set up pay rates that are higher than DBA prevailing wage rates within a federal class code, but separated by position code, you can still use the rate class feature to set up rates by position, and the prevailing feature to set up the prevailing wage. The system simply takes the higher pay rate. Either way, rate classes are required to take advantage of the prevailing wage and fringe features, whether union or non-union.

Calculation flow: Pay rate with cash fringe

The following diagram shows how the system calculates the pay rate involving prevailing wage and fringe amounts. Pay rate includes any cash fringe that may be due to the employee.
Image Removed
Example scenarios - prevailing wage and benefits
This section contains example scenarios to illustrate how prevailing wage and fringe benefits are calculated, including cash fringe, if applicable.
The Employee Standard rate in the examples below is the highest rate, taken from one of the following:

  • Employee (Employee Pay Code Maintenance window)
  • Employee rate class (Employee Maintenance Codes window)
  • Job rate class (Job Maintenance window)

EXAMPLE 1: Prevailing wage and fringe are greater than employee standard wage and fringe - In this example, the prevailing wage and fringe rates are higher than the bricklayer's standard wage and fringe. The bricklayer will get the prevailing wage of 32.71, plus the difference between the prevailing fringe and his/her standard fringe, making a cash fringe of 9.54.

...

 

...

Wage

...

Fringe

...

Cash fringe

...

Total package

...

Prevailing

...

32.71

...

14.54

...

 

...

47.25

...

Employee Standard

...

28.50

...

5.00

...

 

...

33.50

...

Result:

...

32.71

...

5.00

...

9.54

...

47.25

Cash fringe = (prevailing wage - employee fringe)
EXAMPLE 2: Prevailing wage is greater than employee standard wage; employee fringe is greater than prevailing fringe, by a greater difference than the wage difference - In this example, the prevailing wage for bricklayers is greater than the employee's standard rate for bricklayers. However, the employee's fringe benefits are higher than prevailing. Because the difference in fringe is greater than the difference in wage (in the example below, $5.21 - $4.21 = $1.00), the employee does not get the prevailing wage, there is no cash fringe, and the wage rate is reduced from $32.71 to $31.71. The total package for the employee is $38.25, which is equal to the prevailing total package.

...

 

...

Wage

...

Fringe

...

Cash fringe

...

Total package

...

Prevailing

...

32.71

...

4.54

...

 

...

37.25

...

Employee Standard

...

28.50

...

9.75

...

 

...

38.25

...

Result:

...

28.50

...

9.75

...

none

...

38.25

EXAMPLE 3: Employee wage is greater than prevailing wage; prevailing fringe is greater than employee standard fringe - In this example, the prevailing wage for bricklayers is $25.75 per hour but your company has Bricklayer 1 and Bricklayer 2, where Bricklayer 1 makes 25.50 per hour and Bricklayer 2 makes 28.00 per hour. (You can set up the different rates using a combination of the prevailing feature with the rate class feature to set up the three rates). In our example, Bricklayer 2 is used, and since the employee rate is higher than the rate class rate, $28.00 will be used. The prevailing fringe rate is greater than the employee fringe. In this example, the difference in the wages ($2.25) is subtracted from the greater difference in fringe ($3.00), giving us a cash fringe of $0.75.

 

Wage

Fringe

Cash fringe

Total package

Prevailing

25.75

8.00

 

33.75

Employee Standard

28.00

5.00

 

33.00

Result:

28.00

5.00

0.75

33.75

Cash fringe = (prevailing fringe - employee fringe)- (employee wage - prevailing wage)
EXAMPLE 4: Employee standard wage and fringe are higher than prevailing wage and fringe, respectively - In this example, the bricklayer's standard wage and fringe are higher than the prevailing wage and fringe, respectively. Therefore, the total package for the employee is higher than the prevailing package, and no adjustments are necessary.

...

 

...

Wage

...

Fringe

...

Cash fringe

...

Total package

...

Prevailing

...

25.75

...

5.00

...

 

...

30.75

...

Employee Standard

...

28.75

...

8.00

...

 

...

36.75

...

Result:

...

28.75

...

8.00

...

none

...

36.75

EXAMPLE 5: Employee standard wage is lower than prevailing wage, but the employee fringe is higher than the prevailing fringe - In this example, the prevailing wage is $1.00 higher than the employee standard wage, and the employee fringe is $1.00 higher than the prevailing fringe. Therefore, the employee will not get the prevailing wage of $34.00 but instead, the standard rate of $33.00 (34-1). There is no cash fringe and the total package is $39.00.

 

Wage

Fringe

Cash fringe

Total package

Prevailing

34.00

5.00

 

39.00

Employee Standard

33.00

6.00

 

39.00

Result:

33.00

6.00

(none)

39.00

Setup

Setting up the prevailing wage and benefits feature involves the following windows: Employee Fringe Maintenance, Prevailing Wage and Fringe Rate, Rate Class Codes, and Rate Class Detail. Information on the rate class windows appears in the Job Cost User Manual. Make sure to set up rate class codes and detail prior to setting up prevailing wage and fringe rates.

Prevailing Wage and Fringe Rate Maintenance window

This window is used to enter wage rate and fringe rate information from the government-supplied wage determination sheet. Information is based on the union, county and Standard Occupational Code (Fed Class Code). Fringe rate is an hourly accumulation of all the fringe benefits paid to a typical employee in a classification (union or non-union).
Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup > Prevailing Wage and Fringe Rate.

  • Rate Class: Choose the rate class for which you will be entering wage and fringe rates.
  • Union Code: This can be any union; it does not have to be assigned to the selected rate class in the Rate Class Detail window. This field is NOT required for non-union contractors.
  • Start Date: Enter a starting date for entering wage and fringe rates in this window. The default is the user date.
  • Filter Date: Use this field to filter the wage/fringe rate entries that appear in the window. Wage/fringe rate entries appear only if this Filter Date falls within the start and end dates of the entry. If there are multiple entries (rows) for the same federal classification, but with different start dates, only the most recent entry will appear, assuming the Filter Date falls within the date range of the entry.
  • Federal Classification: Sometimes referred to as the Standard Occupational Code.
  • Rates (straight time, overtime, and double time): Enter the wage rate for straight time, as supplied on the wage determination sheet. The overtime and double time are calculated automatically; you can change these amounts, if necessary.
  • Fringes (straight time, overtime, and double time): Enter the fringe rates for straight time, overtime, and double time - as supplied on the wage determination sheet. This will be an accumulated amount of several benefit categories. The default for overtime and double time is the same as straight time, however, you can override these defaults.
  • Start Date: The date that the wages for this federal classification code takes effect for this employee.
  • End Date: The system automatically fills in an end date as soon as you create a subsequent entry for the same federal classification code with a different start date (you cannot enter a date manually). For example, if wages for a fed code go into effect on 1/10/2010, but will increase on 6/1/2010, as soon as you enter the wage line for 6/1/2010, the End Date for the previous entry will be set to a day before, in this case, 5/30/2010.

Note: Entries are saved as soon as you enter data into a field. To delete a row of data, right-click and choose Delete Row. Also, if the Filter Date does not fall completely within the start and end date of the new entry, the entry will disappear from view as soon as you tab to the next line. The line is saved, but won't appear until you change the Filter Date.

Employee Fringe Maintenance window

This window is used to enter and manage fringe benefits paid to each employee, including a start (effective) date. The standard benefits entered in this window are compared to prevailing fringe benefits, based on the information from the government-supplied Davis-Bacon Act (DBA) wage determination sheet.
Note: If you want the correct prevailing wage amount to default into Time Card Entry, you must set up at least one default benefit in this window, even if the fringe amount is zero.
Microsoft Dynamics GP > Tools > Setup > Job Cost > Payroll Setup> Employee Fringe

  • Employee ID: This employee must be set up in the Employee Maintenance Code window in Job Cost.
  • Name: Fills automatically based on employee ID.
  • Start Date: Enter a starting date for entering fringe benefits. If no date is entered, today's date is used.
  • Filter Date: Use this field to filter the fringe rates that appear in the window. Fringe benefits appear only if this Filter Date falls within the start and end dates of the benefit.
  • Benefit: You can choose existing benefits, one by one, using the lookup (same lookup accessed through the Payroll module) - OR - you can create one benefit that is an accumulation of the individual benefits for this employee. You can give your own name to this new benefit; it does not have to be an existing benefit name. If you choose benefits individually, the system will add up the total automatically. If you already know the total benefit amount for this employee, you can create one new benefit name and enter the total in one line.
  • Start Date: The date that the benefit takes effect for this employee.
  • End Date: The system automatically fills in an end date as soon as you create a subsequent entry for the same benefit code with a different start date (you cannot enter a date manually). For example, if benefit code H&W goes into effect on 1/10/2010, and will increase on 6/1/2010, as soon as you enter the benefit line for 6/1/2010, the End Date for the previous entry will be set to a day before, in this case, 5/30/2010.
  • Fringe (straight time, over time, and double time): Enter the fringe rates for straight time, overtime, and double time - as supplied on the wage determination sheet. This can be an accumulated amount of several benefit categories (see Benefit above).

Note: Entries are saved as soon as you enter data into a field. To delete a row of data, right-click in the row and choose Delete Row. Also, if the Filter Date does not fall completely within the start and end date of the new entry, the entry will disappear from view as soon as you tab to the next line. The line is saved, but won't appear until you change the Filter Date..

Scroll ignore



See also: