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
Horizon DistributionHorizon DistributionHorizon DistributionHorizon DistributionHorizon DistributionMapped
Cedar SolutionsCedar SolutionsCedar Solutions Inc.Cedar SolutionsCedar SolutionsMapped
Granite StudioGranite StudioGranite Studio Co.Granite StudioGranite StudioMapped
Silver IndustriesSilver IndustriesSilver Industries Corp.Silver IndustriesSilver IndustriesMapped
Ashford EnterprisesAshford EnterprisesAshford EnterprisesAshford Enterprises Corp.Ashford EnterprisesMapped
Atlas MediaAtlas MediaAtlas Media LLCAtlas Media Inc.Atlas MediaMapped
Evergreen ContractorsEvergreen ContractorsEvergreen ContractorsEvergreen ContractorsEvergreen ContractorsMapped
Atlas LogisticsAtlas LogisticsAtlas LogisticsAtlas LogisticsAtlas LogisticsMapped
River CapitalRiver CapitalRiver CapitalRiver CapitalRiver CapitalMapped
Vertex FoodsVertex FoodsVertex FoodsVertex FoodsVertex FoodsMapped
Prairie LabsPrairie LabsPrairie LabsPrairie LabsPrairie LabsMapped
Fieldstone FoodsFieldstone FoodsFieldstone Foods Co.Fieldstone Foods LLCFieldstone FoodsMapped
462 clients · page 10 of 10

Exceptions

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