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
Pinnacle CapitalPinnacle CapitalPinnacle CapitalPinnacle CapitalPinnacle CapitalMapped
Hillcrest SolutionsHillcrest SolutionsHillcrest Solutions Co.Hillcrest SolutionsHillcrest SolutionsMapped
Brookstone ConsultingBrookstone ConsultingBrookstone ConsultingBrookstone Consulting Corp.Brookstone ConsultingMapped
Golden WorksGolden WorksGolden Works Inc.Golden WorksGolden WorksMapped
Wellspring SupplyWellspring SupplyWellspring SupplyWellspring Supply Inc.Wellspring SupplyMapped
Redwood DesignRedwood DesignRedwood DesignRedwood Design Ltd.Redwood DesignMapped
Union DesignUnion DesignUnion DesignUnion Design Ltd.Union DesignMapped
Wellspring MotorsWellspring MotorsWellspring MotorsWellspring Motors Ltd.Wellspring MotorsMapped
Glenwood IndustriesGlenwood IndustriesGlenwood Industries—Glenwood IndustriesUnmapped
Wintergreen AdvisoryWintergreen AdvisoryWintergreen AdvWintergreen AdvWintergreenReview
Beacon LogisticsBeacon LogisticsBeacon LogisticsBeacon LogisticsBeacon LogisticsMapped
Bluepeak RealtyBluepeak RealtyBLUEPEAK REALTY INC.BluepeakBluepeakReview
Ironwood DentalIronwood DentalIronwood DentalIronwood DentalIronwood DentalMapped
Cedar SupplyCedar SupplyCedar Supply Co.Cedar SupplyCedar SupplyMapped
Westfield EnterprisesWestfield EnterprisesWestfield Enterprises LLCWestfield EnterprisesWestfield EnterprisesMapped
Crestline GroupCrestline GroupCrestline GroupCrestline Group Inc.Crestline GroupMapped
Bluepeak ManufacturingBluepeak ManufacturingBluepeak ManufacturingBluepeak ManufacturingBluepeak ManufacturingMapped
Crestline SupplyCrestline SupplyCrestline Supply Ltd.Crestline Supply LLCCrestline SupplyMapped
Ridgeline MotorsRidgeline MotorsRidgeline MotorsRidgeline MotorsRidgeline MotorsMapped
Sterling GroupSterling GroupSterling GroupSterling GroupSterling GroupMapped
Brookstone StudioBrookstone StudioBrookstone StudioBrookstone StudioBrookstone StudioMapped
Summit RealtySummit RealtySummit RealtySummit Realty Inc.Summit RealtyMapped
Bayview IndustriesBayview IndustriesBayview IndustriesBayview IndustriesBayview IndustriesMapped
Summit LabsSummit LabsSummit LabsSummit LabsSummit LabsMapped
Atlas WorksAtlas WorksAtlas WorksAtlas WorksAtlas WorksMapped
Wintergreen EnterprisesWintergreen EnterprisesWintergreen Enterprises Corp.Wintergreen Enterprises Inc.Wintergreen EnterprisesMapped
Redwood EnterprisesRedwood EnterprisesRedwood Enterprises Co.Redwood EnterprisesRedwood EnterprisesMapped
Vanguard CapitalVanguard CapitalVanguard Capital Co.Vanguard CapitalVanguard CapitalMapped
Horizon DesignHorizon DesignHorizon Design Inc.Horizon DesignHorizon DesignMapped
Atlas PartnersAtlas PartnersAtlas PartnersAtlas PartnersAtlas PartnersMapped
Granite NetworksGranite NetworksGranite Networks Co.Granite NetworksGranite NetworksMapped
Copper WorksCopper WorksCopper WorksCopper WorksCopper WorksMapped
Meridian WorksMeridian WorksMeridian WorksMeridian Works Ltd.Meridian WorksMapped
Prairie EnterprisesPrairie EnterprisesPrairie EnterprisesPrairie Enterprises Ltd.Prairie EnterprisesMapped
Union BuildersUnion BuildersUnion BuildersUnion Builders Corp.Union BuildersMapped
Bluepeak BuildersBluepeak BuildersBluepeak BuildersBluepeak Builders Co.Bluepeak BuildersMapped
Redwood BuildersRedwood BuildersRedwood BuildersRedwood Builders Co.Redwood BuildersMapped
Timberline VenturesTimberline VenturesTimberline Ventures Co.Timberline VenturesTimberline VenturesMapped
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
500 clients · page 10 of 10

Exceptions

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