v0.2.0·SYNTHETIC DATA

Business Rules

See how the business is mapped across systems.

BR-PROFIT-001

Profit per Client = Revenue - Service Cost - Acquisition Cost

Service Cost includes Operations hours at $85/hr. Acquisition Cost allocates 12% of closed-won CRM opportunity value. Calculated live per client on the Exchange tab; see “View Calculation” there for the full source breakdown.

Total

500

Mapped

462

Review

26

Unmapped

12

% Mapped

92.4%

Canonical ClientCRMBillingAccountingOperationsStatus
Fairview BuildersFairview BuildersFairview Builders—Fairview BuildersUnmapped
Eastgate ConsultingEastgate ConsultingEastgate Consulting—Eastgate ConsultingUnmapped
Golden GroupGolden GroupGolden Group—Golden GroupUnmapped
Cedar AnalyticsCedar AnalyticsCedar Analytics—Cedar AnalyticsUnmapped
Northstar BuildersNorthstar BuildersNorthstar Builders—Northstar BuildersUnmapped
Horizon AnalyticsHorizon AnalyticsHorizon Analytics—Horizon AnalyticsUnmapped
Cornerstone EnterprisesCornerstone EnterprisesCornerstone Enterprises—Cornerstone EnterprisesUnmapped
Pinnacle PartnersPinnacle PartnersPinnacle Partners—Pinnacle PartnersUnmapped
Glenwood AnalyticsGlenwood AnalyticsGlenwood Analytics—Glenwood AnalyticsUnmapped
Eastgate SystemsEastgate SystemsEastgate Systems—Eastgate SystemsUnmapped
Cascade PartnersCascade PartnersCascade Partners—Cascade PartnersUnmapped
Glenwood IndustriesGlenwood IndustriesGlenwood Industries—Glenwood IndustriesUnmapped
12 clients · page 1 of 1

Exceptions

  • 12 clients have no Accounting match
  • 8 duplicate client records
  • 3 Billing customers have no CRM company