Part 2: Union Jumpers and Pay Rate Chaos

If you’ve ever tried to calculate payroll for an employee who switched union locals mid-week, worked two different job roles, and qualified for three different pay rates—congratulations! You’ve officially entered the world of union payroll.

It’s complex. It’s messy. And if you’re doing it manually, it’s probably giving you a headache. But don’t worry—we’ll walk you through how to handle it the old-fashioned way… and then show you how Integrity Data HRP makes it feel easy. Because for us, it’s just another Tuesday.

Picture of Union Workers

Why Union Payroll Is So Complicated

Union employees often work under collective bargaining agreements (CBAs) that dictate:

  • Pay rates based on job role and union local
  • Shift differentials
  • Overtime rules
  • Benefits contributions
  • Reporting requirements

Now add in “union jumpers”—employees who move between union locals depending on where they’re working—and you’ve got a recipe for payroll chaos.

Interested in seeing how Payroll NOW handles complex Union payroll scenarios?

Check out our video

How to Handle Union Payroll

If you’re not using an automated system, here’s what your process might look like:

1. Track Union Codes and Job Roles

You’ll need to know:

  • Which union local the employee worked under for each shift
  • What job role they performed
  • What the CBA says about pay rates, benefits, and rules for that combination

Tip: Maintain a detailed matrix of union codes, job roles, and corresponding pay rates. Update it regularly as CBAs change.

2. Apply the Correct Pay Rate

Once you know the union and job role, apply the correct rate for each shift. This may include:

  • Base pay
  • Shift differentials
  • Overtime or double-time rules

Tip: Use conditional formulas in Excel to automate rate lookups based on union code and job title.

3. Calculate Benefits and Deductions

Many CBAs require specific contributions to union benefit funds. You’ll need to:

  • Calculate the correct deductions
  • Track employer contributions
  • Report to the appropriate union or benefits administrator

Tip: Set up templates for each union’s reporting format to save time.

4. Generate Union-Specific Reports

Unions often require detailed reports showing hours worked, pay rates, and contributions. You’ll need to:

  • Aggregate data by union local
  • Format reports according to each union’s requirements
  • Submit on time to avoid penalties

Tip: Use pivot tables to summarize hours and earnings by union code.

Common Pitfalls

  • Incorrect pay rates: Misapplying a rate can lead to grievances or audits.
  • Missed contributions: Forgetting a benefits deduction can result in penalties.
  • Late or inaccurate reporting: Unions don’t mess around with deadlines.

Or… Let Integrity Data HRP Handle It

We’ve worked with customers across industries—construction, manufacturing, energy—who deal with union complexities every day. That’s why we built Integrity Data HRP to handle it all automatically.

Here’s how we make it easy:

  • ✅ Union code tracking

Assign union codes to employees and time entries to ensure the right rules are applied.

  • ✅ Dynamic pay rate calculations

Automatically apply the correct rate based on union, job role, and shift—no spreadsheets required.

  • ✅ Built-in benefits logic

Calculate and track union-specific deductions and employer contributions.

  • ✅ Customizable reporting

Generate union-specific reports with the click of a button—formatted and ready to go.

  • ✅ No custom code needed

Configure everything within the system—no IT tickets, no delays, no version lock-in.

As your workforce grows and shifts, your payroll system should be able to keep up. Integrity Data HRP is designed to scale with your complexity—so you can focus on people, not paperwork.

Final Thoughts

Union payroll is one of the most complex parts of workforce management. But with the right tools, it doesn’t have to be overwhelming.

Whether you’re managing one union or ten, Integrity Data HRP helps you stay compliant, accurate, and efficient.

Because for us? Union jumpers and pay rate chaos aren’t a crisis.

They’re just Tuesday.

Integrity Data HRP – Your Complete HRIS for Dynamics Including Payroll for BC

Integrity Data HRP is your complete HR, Time Management, and Payroll platform from within Dynamics GP and D365 BC. Everything works together effortlessly so you can focus on what really matters, your people.

  • Escape the piles of paper and keep everything in one digital employee file.
  • From Applicant to Retirement, you can manage Recruitment & Onboarding, Benefit Elections, Performance Reviews, Certifications & Licenses, Reports, Payroll, Time & Attendance, and much more, all in one solution.
  • Employee Self-Service Portal is included for both Business Central and GP.
  • Full-Service Tax Filing and ACA Reporting Services available as well.

Reach out today and our no-pressure solution experts will answer your questions to see if we are a good fit for your organization.

Integrity Data has been serving the Dynamics community since 1996. Our passion is to help HR and payroll professionals own their time so they can focus on helping their people. As always, your people are our priority.

Integrity Data HRP Screenshot