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
Bluepeak DesignBluepeak DesignBluepeak DesignBluepeak Design Corp.Bluepeak DesignMapped
Copper SystemsCopper SystemsCopper Systems LLCCopper Systems LLCCopper SystemsMapped
Golden ConsultingGolden ConsultingGolden Consulting Corp.Golden ConsultingGolden ConsultingMapped
Eastgate HoldingsEastgate HoldingsEastgate HoldingsEastgate HoldingsEastgate HoldingsMapped
Silver ServicesSilver ServicesSilver ServicesSilver ServicesSilver ServicesMapped
Granite GroupGranite GroupGranite GroupGranite GroupGranite GroupMapped
Beacon BuildersBeacon BuildersBeacon BuildersBeacon Builders LLCBeacon BuildersMapped
Cornerstone RealtyCornerstone RealtyCornerstone Realty Ltd.Cornerstone RealtyCornerstone RealtyMapped
Atlas BuildersAtlas BuildersAtlas BuildersAtlas BuildersAtlas BuildersMapped
Timberline SystemsTimberline SystemsTimberline SystemsTimberline SystemsTimberline SystemsMapped
Foundry MotorsFoundry MotorsFoundry MotorsFoundry MotorsFoundry MotorsMapped
Prairie SolutionsPrairie SolutionsPrairie SolutionsPrairie SolutionsPrairie SolutionsMapped
Harbor StudioHarbor StudioHarbor StudioHarbor StudioHarbor StudioMapped
Lakeside ContractorsLakeside ContractorsLakeside Contractors Corp.Lakeside Contractors Ltd.Lakeside ContractorsMapped
Crestline SystemsCrestline SystemsCrestline Systems Corp.Crestline Systems LLCCrestline SystemsMapped
Lighthouse ConsultingLighthouse ConsultingLighthouse ConsultingLighthouse ConsultingLighthouse ConsultingMapped
Cornerstone LabsCornerstone LabsCornerstone Labs LLCCornerstone LabsCornerstone LabsMapped
Apex IndustriesApex IndustriesApex IndustriesApex Industries Ltd.Apex IndustriesMapped
Union ServicesUnion ServicesUnion ServicesUnion ServicesUnion ServicesMapped
Cornerstone TechnologiesCornerstone TechnologiesCornerstone Technologies Co.Cornerstone Technologies Corp.Cornerstone TechnologiesMapped
Cascade PartnersCascade PartnersCascade Partners—Cascade PartnersUnmapped
Apex ConsultingApex ConsultingAPEX CONSULTING INC.Apex ConApexReview
Crestline DistributionCrestline DistributionCrestline DisCrestline DisCrestlineReview
Foundry PartnersFoundry PartnersFoundry Partners LLCFoundry Partners Ltd.Foundry PartnersMapped
Pinnacle FoodsPinnacle FoodsPinnacle FoodsPinnacle FoodsPinnacle FoodsMapped
Atlas DesignAtlas DesignAtlas DesignAtlas DesignAtlas DesignMapped
Lighthouse DistributionLighthouse DistributionLighthouse DistributionLighthouse DistributionLighthouse DistributionMapped
Foundry HoldingsFoundry HoldingsFoundry HoldingsFoundry HoldingsFoundry HoldingsMapped
Lakeside PartnersLakeside PartnersLAKESIDE PARTNERS LLCLakeside ParLakesideReview
Fieldstone StudioFieldstone StudioFieldstone Studio Ltd.Fieldstone Studio Corp.Fieldstone StudioMapped
Westfield MotorsWestfield MotorsWestfield Motors LLCWestfield Motors Ltd.Westfield MotorsMapped
Cornerstone FoodsCornerstone FoodsCornerstone Foods Co.Cornerstone FoodsCornerstone FoodsMapped
Highland StudioHighland StudioHighland StudioHighland StudioHighland StudioMapped
Bayview ContractorsBayview ContractorsBayview ContractorsBayview Contractors Corp.Bayview ContractorsMapped
Prairie WorksPrairie WorksPrairie Works Corp.Prairie Works Corp.Prairie WorksMapped
Union ManufacturingUnion ManufacturingUnion ManufacturingUnion Manufacturing Inc.Union ManufacturingMapped
Ashford DesignAshford DesignAshford Design Inc.Ashford Design LLCAshford DesignMapped
Maple VenturesMaple VenturesMaple Ventures Ltd.Maple VenturesMaple VenturesMapped
Maple RealtyMaple RealtyMaple RealtyMaple RealtyMaple RealtyMapped
Prairie MediaPrairie MediaPrairie Media Inc.Prairie MediaPrairie MediaMapped
Golden LogisticsGolden LogisticsGolden Logistics LLCGolden LogisticsGolden LogisticsMapped
Rockwood HoldingsRockwood HoldingsRockwood Holdings LLCRockwood HoldingsRockwood HoldingsMapped
Liberty WorksLiberty WorksLiberty WorksLiberty WorksLiberty WorksMapped
Clearwater DentalClearwater DentalClearwater DentalClearwater Dental Inc.Clearwater DentalMapped
Westfield ManufacturingWestfield ManufacturingWestfield Manufacturing Inc.Westfield Manufacturing Corp.Westfield ManufacturingMapped
Northstar SolutionsNorthstar SolutionsNorthstar Solutions Inc.Northstar Solutions Ltd.Northstar SolutionsMapped
Hillcrest SupplyHillcrest SupplyHillcrest SupplyHillcrest SupplyHillcrest SupplyMapped
Lakeside VenturesLakeside VenturesLakeside Ventures Inc.Lakeside VenturesLakeside VenturesMapped
Redwood LabsRedwood LabsRedwood LabsRedwood LabsRedwood LabsMapped
Brookstone EnterprisesBrookstone EnterprisesBrookstone Enterprises LLCBrookstone EnterprisesBrookstone EnterprisesMapped
500 clients · page 9 of 10

Exceptions

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