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
River DesignRiver DesignRiver Design Corp.River DesignRiver DesignMapped
Foundry ManufacturingFoundry ManufacturingFoundry ManufacturingFoundry Manufacturing Ltd.Foundry ManufacturingMapped
Glenwood TechnologiesGlenwood TechnologiesGlenwood TechnologiesGlenwood TechnologiesGlenwood TechnologiesMapped
Anchor ManufacturingAnchor ManufacturingAnchor Manufacturing Ltd.Anchor ManufacturingAnchor ManufacturingMapped
Sterling SystemsSterling SystemsSterling Systems Ltd.Sterling SystemsSterling SystemsMapped
Sterling ConsultingSterling ConsultingSterling Consulting Co.Sterling ConsultingSterling ConsultingMapped
Hillcrest ServicesHillcrest ServicesHillcrest ServicesHillcrest ServicesHillcrest ServicesMapped
Hillcrest AnalyticsHillcrest AnalyticsHillcrest AnalyticsHillcrest AnalyticsHillcrest AnalyticsMapped
Ridgeline NetworksRidgeline NetworksRidgeline NetworksRidgeline NetworksRidgeline NetworksMapped
Lakeside IndustriesLakeside IndustriesLakeside Industries Ltd.Lakeside Industries Co.Lakeside IndustriesMapped
Liberty MotorsLiberty MotorsLiberty MotorsLiberty Motors Inc.Liberty MotorsMapped
Lakeside DentalLakeside DentalLakeside DentalLakeside DentalLakeside DentalMapped
River EnterprisesRiver EnterprisesRiver Enterprises Corp.River Enterprises Inc.River EnterprisesMapped
Beacon PartnersBeacon PartnersBeacon Partners Co.Beacon Partners Co.Beacon PartnersMapped
Cascade VenturesCascade VenturesCascade Ventures Inc.Cascade Ventures Ltd.Cascade VenturesMapped
Eastgate SolutionsEastgate SolutionsEastgate SolutionsEastgate Solutions Inc.Eastgate SolutionsMapped
Wellspring ServicesWellspring ServicesWellspring ServicesWellspring Services Corp.Wellspring ServicesMapped
Beacon MotorsBeacon MotorsBeacon MotorsBeacon Motors Inc.Beacon MotorsMapped
Brookstone DentalBrookstone DentalBrookstone DentalBrookstone DentalBrookstone DentalMapped
Ironwood ManufacturingIronwood ManufacturingIronwood Manufacturing Corp.Ironwood Manufacturing Inc.Ironwood ManufacturingMapped
Ridgeline DistributionRidgeline DistributionRidgeline DistributionRidgeline DistributionRidgeline DistributionMapped
Bayview ConsultingBayview ConsultingBayview ConsultingBayview Consulting Co.Bayview ConsultingMapped
Sterling MediaSterling MediaSterling Media LLCSterling Media Corp.Sterling MediaMapped
Westfield DistributionWestfield DistributionWestfield DistributionWestfield Distribution Inc.Westfield DistributionMapped
Vertex DesignVertex DesignVertex Design Inc.Vertex DesignVertex DesignMapped
Hillcrest FoodsHillcrest FoodsHillcrest FoodsHillcrest Foods Co.Hillcrest FoodsMapped
Atlas IndustriesAtlas IndustriesAtlas IndustriesAtlas IndustriesAtlas IndustriesMapped
Fairview IndustriesFairview IndustriesFairview IndustriesFairview IndustriesFairview IndustriesMapped
Vanguard DesignVanguard DesignVanguard DesignVanguard DesignVanguard DesignMapped
Meridian DistributionMeridian DistributionMeridian DistributionMeridian DistributionMeridian DistributionMapped
Sterling PartnersSterling PartnersSterling Partners Inc.Sterling PartnersSterling PartnersMapped
Vanguard DentalVanguard DentalVanguard Dental Co.Vanguard DentalVanguard DentalMapped
Cascade LabsCascade LabsCascade LabsCascade LabsCascade LabsMapped
Cascade DentalCascade DentalCascade DentalCascade DentalCascade DentalMapped
Ridgeline PartnersRidgeline PartnersRidgeline Partners Corp.Ridgeline Partners Inc.Ridgeline PartnersMapped
Atlas GroupAtlas GroupAtlas Group Ltd.Atlas GroupAtlas GroupMapped
Lighthouse FoodsLighthouse FoodsLighthouse FoodsLighthouse FoodsLighthouse FoodsMapped
Brookstone WorksBrookstone WorksBrookstone WorksBrookstone Works Ltd.Brookstone WorksMapped
Vanguard ConsultingVanguard ConsultingVanguard Consulting Co.Vanguard ConsultingVanguard ConsultingMapped
Cedar CapitalCedar CapitalCedar CapitalCedar CapitalCedar CapitalMapped
Beacon WorksBeacon WorksBeacon WorksBeacon WorksBeacon WorksMapped
Highland AnalyticsHighland AnalyticsHighland Analytics LLCHighland Analytics Co.Highland AnalyticsMapped
Meridian HoldingsMeridian HoldingsMeridian HoldingsMeridian HoldingsMeridian HoldingsMapped
Granite ManufacturingGranite ManufacturingGranite Manufacturing Co.Granite ManufacturingGranite ManufacturingMapped
Anchor LabsAnchor LabsAnchor Labs Corp.Anchor Labs LLCAnchor LabsMapped
Bayview LogisticsBayview LogisticsBayview LogisticsBayview LogisticsBayview LogisticsMapped
Hillcrest LabsHillcrest LabsHillcrest LabsHillcrest LabsHillcrest LabsMapped
Wintergreen SupplyWintergreen SupplyWintergreen SupplyWintergreen SupplyWintergreen SupplyMapped
Granite AnalyticsGranite AnalyticsGranite AnalyticsGranite AnalyticsGranite AnalyticsMapped
Union DentalUnion DentalUnion Dental Co.Union Dental Inc.Union DentalMapped
462 clients · page 4 of 10

Exceptions

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