What if sales commissions could be calculated instantly across every branch with transparency?
Challenge
System Pavers had to perform 160 hours of manual reconciliation each month to match customer payments against project milestones and calculate commissions for over 300 design consultants, which it had to pay as per schedule. This increased the workload and the risk of cheque fraud.
Solution
By centralizing data from legacy systems, Microsoft Dynamics 365, and Dayforce HRM into a data warehouse, System Pavers, with the help of Epoc Labs, connected customer and design consultant data on a single platform and leveraged DOMO’s Magic ETL to automate reporting and deliver on-demand insights.
Impact
System Pavers eliminated 160+ hours of manual data work per month and reduced resource costs by over $120K annually, enabling one-click generation of design consultant commissions across all branches with transparency.
System Pavers automates consultant commissions and unifies payroll operations with Domo.
System Pavers, a leading outdoor living company specializing in turf, pavers, and patio installations, runs hundreds of projects each month through its network of 300+ design consultants. Each consultant earns based on four defined milestones – Deposit, Material Order, Job Start, and Final. With customer payments linked to these milestones, tracking commissions was complex and inconsistent.
The finance team relied on manual spreadsheets to connect project payments with consultant payouts. Reconciling customer invoices across systems meant errors, delays, and rework. Consultants had little insight into what they were owed, leading to confusion and repeated inquiries. The growing number of projects only amplified the problem.
Epoc Labs introduced a data-driven solution that replaced manual work with automation and visibility.
-
Industry
Construction / Outdoor Living
-
Departments Using DOMO
Accounting, Operations, Sales, Marketing
-
Engagement Model
Long-term Consulting & Implementation
-
Project Type / Services Offered
Centralized Data Warehouse, DOMO Magic ETL, DOMO Reporting
-
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 helped centralize data from legacy systems and Microsoft Dynamics 365, standardizing project and payment structures across branches. A SQL Server data warehouse became the single source of truth, integrating real-time feeds from both Dynamics and Ceridian Dayforce for payroll. Using DOMO Magic ETL, payment data was automatically mapped to project milestones and consultant assignments.
Every transaction could now be tracked from payment to payout with precise calculations.
- Commission logic is encoded for each branch and region.
- Hourly synchronization between sales and payroll systems.
- Secure, auditable processing with automated validation alerts.
This connected data layer created a reliable foundation for transparent reporting and accurate financial control.
Delivering real-time visibility
Epoc Labs implemented DOMO dashboards for every stakeholder level. Consultants access personal dashboards showing earned, paid, and pending commissions. Team managers view collective team performance and commission forecasts. Finance teams can instantly generate statements and reconcile payments per pay cycle.
Data access is governed by role, ensuring confidentiality and control. Consultants see only their data, while managers and finance teams have tiered visibility. Every commission record is timestamped, logged, and traceable.
“The visibility changed everything. Everyone sees their numbers clearly, and the trust in the system is complete.”
Ahmad Roowala
Chief Technology Office
Achieving operational impact
The automation reshaped how System Pavers runs its commission cycles:
- 160+ hours saved monthly through end-to-end automation
- $120,000 annual cost reduction in administrative overhead
- 0.1% error rate compared to 5% in manual processing
- Real-time commission visibility for 300+ design consultants
- Full audit trail and visibility for every payment and milestone
This transformation gave the organization full control over commission data while removing dependency on manual input. Accounting and finance can now focus on performance insights rather than data cleanup, and consultants have complete clarity on their payouts.
Establishing a data governance standard
By combining Dynamics 365, Dayforce, SQL Server, and DOMO Magic ETL, System Pavers created an auditable, governed data structure for its financial operations. Data updates are automated, and every user interaction is logged. The system supports secure role-based permissions and a transparent payout process, setting a higher bar for accuracy, accountability, and trust.
“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, redefining campaign reporting into a real-time 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.
