TABLE OF CONTENTS

• Pay Rate Schedules
  • Managing Employee Trade Level Classification
• Creating a Pay Rate Schedule
  • Edit Pay Rate Schedule
• Applying a Schedule
  • Priority Rules
  • How a Rate Is Found
• Viewing Rates in a Payroll Period
• Understanding External Payroll Items
  • Mapping Internal to External
• Standard Mapping for External Items
• How Cost Rates are Calculated Using External Items
  • Step 1: Syncing Time Card hours to payroll (Table 1)
  • Step 2: Pulling paycheck data back (Table 2)
  • Handling Variances
  • Step 3: Determining Applied Addition Types
  • Step 4: Calculating the Adjusted Rate
  • Logic for Fringe and Training Components
• Calculating Labor Costs (Burden) based on Adjusted Cost Rates
• Deducting Fringe
• When the Average Rate is Used

Pay Rate Schedules

Pay Rate Schedules are the main place to store and manage compensation rates. They can be applied to a Build Plan or directly to an Employee.

Schedules use Start Date and End Date to show the life of a record. The actual logic is driven by fields on each payroll item:

Required:

• Increase Applied Date: Date the rate takes effect; defaults to the Start Date.
• Base Hourly Rate (BHR): The core hourly pay.

Optional:

• Registration Cutoff Date: Used for apprenticeship programs. The system checks the employee’s Apprenticeship Registration Date; it must be on or before this cutoff to qualify for the rate.
• Fringe Benefits: Non-wage compensation.
• Training Contributions: Training fund amounts.

Example: Using Registration Cutoff Dates

You can differentiate pay rates for the same payroll item based on when an employee registered for their apprenticeship.

• Employee 1: Registered on 11/15/2023 (Before 12/1/2023)
• Employee 2: Registered after 12/1/2023

Schedule Configuration:

Results:

• Employee 1: Their registration is before the Row 1 cutoff. The system applies Row 1 ($35.00) for all hours from 12/01/2025 until the next scheduled increase on 6/1/2025 Row 3 ($37.00).
• Employee 2: Their registration matches the Row 2 cutoff. The system applies Row 2 ($30.00) for all hours from 12/01/2025 until the next scheduled increase on 6/1/2025 Row 4 ($32.00).

The Total Calculation

The system automatically calculates the total rate using the following formula:

Managing Employee Trade Level Classification

In the Pay Rate management tool, an employee's trade level classification can be managed through Classifiers. A classifier designates a specific term of employment (e.g., "Apprentice Level 1").

How Mapping Works:

1. Direct Mapping: Each employee classifier maps to a specific Payroll Item.

2. Schedule Rows: A row is added to the Pay Rate Schedule for that specific payroll item with a different rate.

3. Automatic Updates: Changing a classifier indicates that a term of employment has increased. The new classifier matches a different payroll item, which automatically pulls a higher pay rate from the schedule.

4. Example: apprentice to a Journeyman.

Creating a Pay Rate Schedule

1. Open Pay Rate Schedule in the HR group.
2. Click the + ADD PAY RATE SCHEDULE button.
3. Complete required fields and click Save.
4. Use the Documents tab to attach any relevant supporting files.
   • Tip: You can also click the + icon next to the Pay Rate Schedule field on an Employee or Build Plan card to create one on the fly.

Edit Pay Rate Schedule

Manage your pay rate tiers directly within the schedule card using these simple controls:

• Add Row: Click Add Row to enter a new pay rate. For example, schedule future increases (by setting a new Increase Applied Date) or to account for a different Registration Cutoff.
• Delete Row: To delete an entry, find the Trash icon on the right and click to delete.

Applying a Schedule

To assign a schedule:

1. Open the desired Employee or Build Plan record.
2. Locate the Pay Rate Schedule field.
3. Select a schedule from the dropdown and save.

Priority Rules

When more than one schedule could apply, the system uses:

1. Employee-Specific Schedule: Highest priority. If a schedule is assigned directly to an employee card, it overrides all other settings.
2. Build Plan Schedule: Secondary priority. Used when no employee-specific schedule is set.

How a Rate Is Found

Every row in your Payroll Period Allocation represents a specific combination of labor data. To determine the correct pay rate for a single entry, the system scans your schedules for an exact match based on the following criteria:

• Employee
• Internal Payroll Item (e.g., Hourly Regular, Overtime)
• Build Plan
• Time Card Date (compared to Increase Applied Date

Search order:

The system follows a "Most Specific to Most General" path to find a rate:

• Direct Employee Match: Check the employee’s schedule for a matching payroll item.
• Build Plan Fallback: If none is found, use the Build Plan schedule.
• Time Card Date Filter
  The system only considers rows where the Increase Applied Date is on or before the Date on the Time Card.
• Registration Date Validation (First-Match): Within the valid rows, the system sorts by Registration Cutoff and compares it to the employee’s Apprenticeship Registration Date:
  • Registered Apprentices: The system scans the list and selects the first row where the employee's registration date is on or before the cutoff.
  • Non-Apprentices: If an employee has no registration date, the system selects the row with an empty cutoff field.
    

Viewing Rates in a Payroll Period

To see how rates were applied:

1. Open the relevant Payroll Period.
2. Go to the Pay Rates tab.
3. Review how Time Card hours map to payroll items, external payroll items, and rate components (BHR, Fringe, Training, and Total).

Understanding External Payroll Items

External Payroll Items let you group multiple internal items under a single external code (such as BHR, Fringe, Training) for your payroll system.

Mapping Internal to External

To set up this mapping, you must define the relationship on each Payroll Item record:

• For Base Rates: Open the Internal Payroll Item and select the corresponding external code in the Basic Hourly field.
• For Benefits: Fill in the Fringe and Training Contribution fields with their respective external identifiers.

Mapping Example

Several shift variants for Apprentice Shift 1 can all map to the same external BHR and Fringe codes. This consolidates hours for the payroll provider while preserving internal detail.

Standard Mapping for External Items

In most standard configurations, the following Addition Types are applied to your primary external categories:

• Base Hourly Rate (BHR): Typically set to N/A. 
• Fringe: Typically set to Ignore. 
• Training contribution: set to Ignore. 

Note: Even when syncing with an external system, the values for BHR, Fringe, and Training Contribution are bypassed. The system always relies on your internal Time Card hours and Pay Rate Schedule to calculate these amounts.  

For a deeper dive into how these configurations affect cost rates calculation, please refer to our dedicated article on Payroll Item Configuration.

How Cost Rates are Calculated Using External Items

In this workflow, cost rates are determined by syncing Time Card hours to a payroll system and then syncing the resulting paycheck data back into the system. These rates are then adjusted based on the Addition Type assigned to each payroll item.

Example Table 1: Pay rates per payroll period for employee Aidan

Step 1: Syncing Time Card hours to payroll (Table 1)

When hours are synced, the system looks for matches between internal and external payroll items.

• Matched Items: Rows 1–5 map the internal item Apprentice Shift 1 to the external BHR - Base Hourly Rate.
  • Total BHR Hours: 31.5
• Unmatched Items: Row 6 (marked as REG - Regular) has no external mapping. These hours sync under their internal names.
  • Total Regular Hours: 7.65
• Total Combined Hours: 39.15

Step 2: Pulling paycheck data back (Table 2)

Once the paycheck is processed, the system retrieves the actual amounts paid. 

Internal Calculation Priority

Instead of using the external paycheck amounts for BHR, Fringe, and Training Contribution, the system recalculates these components using your internal Pay Rate Schedule and Time Card hours.

Example for BHR:

Table 2: Paycheck Data for Aidan - Cost Rates tab of the Payroll Period 

Handling Variances

Because the system prioritizes internal rates, there can be a difference between the external synced total and the internal calculated total. To see this difference, review the Original Amount column on the Cost Rates dashboard.

• Positive delta: If the synced paycheck amount is higher than the internal calculated amount, the difference is automatically written off to Payroll Period Overhead Expenses.
• Negative delta: If the synced amount is lower than the internal calculated amount, the system cannot allocate this shortfall in Financial Distribution. In this case, the recalculation fails with an error, and designated administrators are notified so they can resolve the issue.

Step 3: Determining Applied Addition Types

The Applied Addition Type column determines how a line item impacts the final Adjusted Rate. While the Addition Type usually matches the setting on the payroll item, the system applies exceptions. Read more in the article.

Step 4: Calculating the Adjusted Rate

Adjusted Rates are only calculated for lines with recorded hours. The system factors in Proportional and Fixed increases to find the true cost of labor.

1. Proportional Increase

This is the ratio of proportional company contributions to the total gross wages paid.

• Proportional Total: $145.74 (Medicare + Medicare Employer + OASDI Employer)
• Gross Wages: $1,332.00 ($1,102.50 + $229.50)

2. Fixed Increase

This is the total amount of fixed allowances divided by the total hours worked across all items.

• Fixed Total: $99.30 (SS - OASDI)
• Total Hours: 39.15

3. Final Adjusted Rate Calculation

The final cost to the company for a BHR hour is the sum of the base rate and all applicable increases:

Adjusted Rate for BHR = $41.37

Logic for Fringe and Training Components

For Fringe and Training:

• External Fringe and Training items are set to Ignore.
• The system uses internal schedule rates instead of paycheck values.

To calculate the fringe amount, the system takes the BHR hours and multiplies them by the fringe pay rate defined in the internal Pay Rate Schedule. This total is then recorded against the fringe payroll item for accurate job costing.

Example:

• BHR Hours: 31.5
• Fringe Pay Rate: $12.26
  

Total Fringe Amount: $386.19 

Calculating Labor Costs (Burden) based on Adjusted Cost Rates

The final step in the process is calculating the Labor Cost (often referred to as the "fully burdened" cost).

Labor Cost combines:

• Adjusted Cost Rate: base rate + increases.
• Internal Fringe and Training rates.

The Labor Cost Formula

The system determines the final Labor Cost by finding the internal payroll item mapping and summing the adjusted rate with any retrieved internal contributions:

3. Calculation Example

This is the fully burdened hourly cost for that employee and any payroll items that match the BHR category.

Deducting Fringe

The Deduct Fringe setting allows the system to offset specific employer contributions against the total Fringe amount. This ensures that company-paid benefits (like health benefits contributions) are deducted from the employee's fringe pool rather than added on top.

Configuration

Enable the Deduct Fringe toggle within the Payroll Item settings for items in the Employer Contribution group, such as:

• ERMED - ER Cost of Medical
• HSAER: HSA Employer Contribution

The Calculation Logic

When active, the total Fringe amount decreases by the sum of these specified contributions.

Example:

• Original Fringe Amount: $386.19
• Employer Contributions: ERMED = $122.52
• Fringe After Deduction: $386.19 - $122.52 = $263.67

Adjusting Labor Costs

To calculate the final hourly burden, the system applies a Fringe Deduction Coefficient to the original pay rate.

1. Find the Coefficient:

2. Calculate Adjusted Fringe Rate:

3. Final Labor Cost Per Hour:

When the Average Rate is Used

The Average Rate acts as a real-time estimate for your labor costs before a payroll cycle is finalized.

Because your actual employer taxes and fixed increases are only known after the check is processed, the system uses the 6-month average coefficient as a placeholder to ensure your project reports show a realistic burden.

How it works:

• Detects Open Period: The system identifies that the Time Card date has no synced paycheck data.
• Applies Average Coefficient: It retrieves the 6-month sum of proportional and fixed increases for that employee.
• Calculates Estimate:

Transition to Actuals

Once you close the payroll period and sync the data, the system automatically replaces the Average Rate with the Actual Adjusted Cost Rate. This ensures your mid-month tracking is meaningful while your historical reports remain 100% accurate.