Union Complexity, Solved in Five Weeks: How a Multi-State Electrical Contractor Unified ADP® and QuickBooks with Dapt
Industry: Electrical Contracting / Whole Building Management Information Systems
Location: Illinois, Indiana, and Texas
Operating Model: Multi-state, multi-union workforce
Payroll Platform: ADP Workforce Now® Next Generation (New Implementation)
Time Tracking: ADP Workforce Now Next Generation Time and Attendance (New Implementation)
Accounting System: QuickBooks Online
Payroll Complexity: 20+ unions, 700+ pay rates, 790+ benefit rules, 190+ overtime rules, extracted from 200+ collective bargaining agreements and rate sheets
Time from Contract Signature to First Payroll: Five weeks (four weeks of active engagement)
This multi-state electrical contractor designs and implements whole-building management information systems across commercial and industrial projects in Illinois, Indiana, and Texas. Their tradespeople operate under collective bargaining agreements spanning more than 20 unions — each with their own pay structures, benefit rules, overtime calculations, and jurisdictional quirks.
Running payroll for an operation of this complexity is a full-time forensic exercise. Every pay period means interpreting rate sheets, cross-referencing CBA amendments, and applying the right union's rules to the right employee on the right job in the right state. Manual processes don't scale. Spreadsheets break. And when agreements get renegotiated, the entire payroll logic has to be rebuilt.
The company decided to rebuild their payroll operation from the ground up — new payroll provider, new time tracking, and a synchronization layer capable of handling the full scope of their union complexity. They selected the next generation of ADP Workforce Now as their payroll provider, paired with ADP Workforce Now Time and Attendance, with Dapt as the synchronization and rules engine connecting union logic, time data, payroll submission, and accounting.
They signed with Dapt at the start of Week 1. First payroll ran at the end of Week 5. Five weeks — with only four of them active, because the client team was on scheduled vacation during Week 1.
The Challenge: Twenty Unions, Three States, Two Hundred Documents
Before the implementation, the company's payroll process was a patchwork of manual interpretation and spreadsheet reconciliation. Each union brought its own complexity, and the complexity compounded across geography.
Union Complexity at Every Layer
More than 20 unions governed the workforce. Each union contract specified:
- Multiple pay rates by trade classification, experience level, and work type
- Distinct benefit structures — health, pension, annuity, apprenticeship, and fund contributions
- Overtime rules that varied by time of day, day of week, hours worked, and shift type
- Premium pay scenarios — shift differentials, hazard pay, travel premiums, show-up pay
- Jurisdiction-specific rules tied to work location, not employees’ home base
Across the union portfolio, this is resolved to:
- 700+ distinct pay rates
- 790+ benefit rules
- 190+ overtime rules
All of it documented across more than 200 collective bargaining agreements, rate sheet revisions, and benefit fund amendments.
Multi-State Layered on Multi-Union
Operating across Illinois, Indiana, and Texas adds state-level wage, tax, and reporting obligations on top of the union rules. An electrician working under the same union local can be paid differently on projects in different states, with different prevailing wage requirements and different state filing obligations.
The Business Need
The company needed a payroll operation that could:
- Ingest and interpret the full library of union agreements
- Apply the correct rates, benefits, and overtime rules to every employee on every job
- Deliver pre-calculated, audit-ready payroll inputs to ADP payroll
- Post accurate job-costed accounting entries into QuickBooks Online
- Scale as agreements get renegotiated and new unions come online
And they needed it running in weeks, not months.
The Solution: Dapt Extracts the Rules from the Union Documents
The breakthrough on this engagement was not just the integration — it was Dapt's ability to extract structured payroll logic directly from the union documents themselves.
From 200 Documents to Working Payroll Logic
Dapt ingested the full library of collective bargaining agreements, rate sheets, and benefit fund documentation. From those 200+ documents, Dapt's extraction process produced:
- A structured table of 700+ pay rates tied to the correct union, classification, and geography
- A structured ruleset of 190+ overtime rules encoded for automated evaluation
- A structured library of 790+ benefit rules covering employer contributions, employee deductions, and fund-specific reporting
What would have been months of manual payroll analyst work — reading every contract, transcribing rate tables, interpreting overtime language — became a tractable data extraction problem. The resulting structured payroll logic became the foundation for every pay run.
Synchronizing ADP Payroll, Time Data, and QuickBooks Online
With the union rules extracted and encoded, Dapt synchronizes the full payroll flow:
Time data intake
Time data flows into Dapt from ADP time tracking with custom fields identifying the union, trade classification, job, and work location — everything Dapt needs to apply the correct rules downstream.
Rule application (Dapt)
Dapt evaluates every time entry against the extracted union logic:
- Identifies the applicable pay rate based on union, classification, and jurisdiction
- Applies the correct overtime rule based on time of day, day of week, hours worked, and shift
- Calculates benefit contributions and fund allocations
- Flags premium pay scenarios and applies the right adjustments
Submission to ADP Payroll
Dapt delivers pre-calculated, pre-classified payroll inputs to ADP payroll. Because Dapt has already applied the union logic — rates, overtime, benefits, premiums — the pay run proceeds without manual intervention or post-run corrections.
Accounting synchronization
After each pay run, Dapt synchronizes the results into QuickBooks Online with full job costing — labor costs, burden, and benefits allocated to the correct jobs, union costs separated for reporting, and journal entries posted automatically.
Five Weeks, From Contract to First Payroll
The implementation timeline is worth naming directly because it demonstrates what becomes possible when union logic is treated as a data extraction problem rather than a manual interpretation problem.
- Week 1 — Contract signed. Client team on scheduled vacation; document delivery paused by design.
- Week 2 — Documents received: 200+ collective bargaining agreements, rate sheets, and benefit fund amendments. Dapt extraction process begins.
- Weeks 2–5 — Document extraction; ADP payroll and time tracking configuration; Dapt rules testing and validation.
- End of Week 5 — First production payroll run.
Five weeks total, four weeks of active engagement, across more than 20 unions and three states. For context, many multi-union payroll implementations take six to nine months to reach a first clean pay run — and that is without simultaneously adopting a new payroll provider and new time tracking.
The Result
The company now runs a modern, synchronized payroll operation. ADP is their payroll provider and time tracking system. Dapt handles union rule application, pay calculation, and accounting synchronization. QuickBooks Online is their accounting system.
✓ Accurate multi-union payroll on demand — Twenty-plus unions, 700+ rates, and 190+ overtime rules are applied automatically every pay period. One approval cycle, no manual recalculations.
✓ Multi-state complexity absorbed — Jurisdiction-specific rules across Illinois, Indiana, and Texas are evaluated automatically based on work location and union assignment.
✓ Real-time job costing — Labor costs are assigned to the correct jobs immediately after payroll, giving the team accurate project profitability visibility while work is still in progress.
✓ Union-ready reporting on demand — Reports separate hours, earnings, benefits, and deductions by union automatically, significantly reducing audit and filing preparation time.
✓ A foundation that scales — When agreements are renegotiated or new unions come online, Dapt's extraction process integrates the updated rules into the existing payroll logic without requiring a rebuild.
The company went from a payroll operation that was a full-time forensic exercise to a payroll operation that runs on structured data. And they did it in five weeks — four, if you don't count the vacation.
