Eliminating 1,900+ Hours of Manual Work: Automated, Transparent Commissions for System Pavers
Challenge
160 hours monthly were required to manually reconcile customer payments with project milestones and calculate commissions for more than 300 design consultants. As System Pavers continued to grow, this manual process significantly increased operational risk, reduced financial visibility, and made it difficult to maintain the accuracy and trust required for timely, scheduled commission payouts.
Solution
By centralizing data from legacy systems, Microsoft Dynamics 365, and Dayforce into a unified data warehouse, Epoc Labs created a single, governed data foundation. Using DOMO Magic ETL, System Pavers automated reconciliation logic and standardized commission calculations, giving finance and sales teams a reliable, shared view of performance and the financial visibility required to maintain organizational trust.
Impact
System Pavers eliminated over 160 hours of manual effort each month and reduced annual operating costs by more than $120K. By deploying this solution across the company’s entire geographic footprint, Epoc Labs helped restore confidence in commission accuracy and improve financial visibility across all branches. This data foundation enables finance and sales teams to operate with the consistency, transparency, and trust required to sustain growth as a national leader.
System Pavers automates consultant commissions and unifies national payroll operations with DOMO
System Pavers, a leading outdoor living company specializing in turf, pavers, and patio installations, manages hundreds of active projects each month through a nationwide network of more than 300 design consultants. Consultant compensation is tied to four defined project milestones: Deposit, Material Order, Job Start, and Final. Making accurate alignment between customer payments and commissions is critical.
As volume increased, commission tracking became fragmented across systems. The finance team relied heavily on manual spreadsheets to reconcile customer invoices with consultant payouts, introducing delays, inconsistencies, and rework. Limited visibility made it difficult for consultants to understand commission status, increasing inquiries and operational friction as the business scaled.
Epoc Labs addressed these challenges by replacing manual processes with a governed, automated data foundation designed to deliver clarity, consistency, and trust across all regional branches.
-
Industry
Construction / Outdoor Living
-
Departments Using DOMO
Accounting, Operations, Sales, Marketing
-
Domo Users
400
-
Company size
500
-
About
System Pavers designs and installs outdoor spaces across the U.S., including turf, patios, and paver systems, supported by a nationwide consultant network.
“We no longer rely on spreadsheets or manual checks. The accounting team runs payout reports in minutes instead of days.”
Ahmad Roowala
Chief Technology Office
Building a connected data foundation
Epoc Labs centralized data from legacy systems and Microsoft Dynamics 365, standardizing project, payment, and commission structures across all branches. A SQL Server data warehouse became the single source of truth, integrating near-real-time feeds from Dynamics and Ceridian Dayforce. Using DOMO Magic ETL, payment data was automatically aligned to project milestones and consultant assignments.
Every transaction could now be tracked end-to-end, from the initial customer payment to the final consultant payout, with consistent, precise calculations
- Commission logic is standardized by branch and region.
- Hourly synchronization between sales and payroll systems eliminates data lag.
- Secure, auditable processing includes validation alerts to catch discrepancies instantly.
This connected data layer established a reliable foundation for transparent reporting, accurate commissions, and total financial control.
Delivering real-time visibility
Epoc Labs implemented DOMO dashboards for every stakeholder level. Design consultants access personal views showing earned, paid, and pending commissions. Sales managers view aggregated team performance and commission forecasts. Finance teams can generate statements instantly and reconcile payments by pay cycle.
Data access is governed by role to ensure confidentiality and control. Consultants see only their own data, while managers and finance teams have tiered visibility. Every commission record is time-stamped, logged, and fully traceable for audit and review.
“The visibility changed everything. Everyone sees their numbers clearly, and trust in the system is complete.”
Ahmad Roowala
Chief Technology Office
Achieving operational impact
The automation fundamentally transformed how System Pavers manages commission cycles nationwide:
- 160+ hours saved monthly through end-to-end automation.
- $120,000 annual cost reduction by eliminating administrative overhead.
- 98% improvement in accuracy, reducing error rates from 5% to 0.1%.
- Real-time visibility for 300+ design consultants across all branches.
- Complete audit trail across every payment, milestone, and payout.
This transformation established total control over commission data while eliminating the risks of manual entry. Finance and accounting teams have shifted their focus from tedious reconciliation to strategic oversight, while consultants now operate with clear, consistent visibility into their earnings.
Establishing a data governance standard
By integrating Microsoft Dynamics 365, Dayforce, SQL Server, and Domo Magic ETL, System Pavers established a governed, auditable data foundation for financial operations. Data updates are now automated, every interaction is logged, and access is securely role-based, creating a transparent payout process and setting a higher standard for accuracy, accountability, and trust. This marked a foundational shift toward scalable, well-governed financial operations.
“We finally have a single, trusted view of commissions across every branch. The process is faster, cleaner, and fully traceable.”
Ahmad Roowala
Chief Technology Office
Related Case Studies
With 90% faster data preparation, Siphon Cloud unified 3.4 billion marketing records on Google BigQuery, transforming campaign reporting into a real-time, scalable analytics operation.
Cheyenne Products saved 500+ hours a year by building a comprehensive reporting architecture, which improved business foresight.
SmallBiz slashed reporting time by 90%, gained instant KPI visibility, and saved over $60K annually through real-time data automation.
