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
Brookstone PartnersBrookstone PartnersBrookstone PartnersBrookstone PartnersBrookstone PartnersMapped
Westfield DesignWestfield DesignWestfield Design Co.Westfield DesignWestfield DesignMapped
Wintergreen StudioWintergreen StudioWintergreen Studio Inc.Wintergreen StudioWintergreen StudioMapped
Prairie SystemsPrairie SystemsPrairie SysPrairie SysPrairieReview
Glenwood SolutionsGlenwood SolutionsGlenwood SolutionsGlenwood Solutions LLCGlenwood SolutionsMapped
Lighthouse BuildersLighthouse BuildersLighthouse BuildersLighthouse BuildersLighthouse BuildersMapped
Wellspring DesignWellspring DesignWellspring DesignWellspring Design LLCWellspring DesignMapped
Brookstone ManufacturingBrookstone ManufacturingBrookstone ManufacturingBrookstone ManufacturingBrookstone ManufacturingMapped
Ashford VenturesAshford VenturesAshford VenturesAshford VenturesAshford VenturesMapped
Lighthouse WorksLighthouse WorksLighthouse WorksLighthouse WorksLighthouse WorksMapped
Atlas EnterprisesAtlas EnterprisesAtlas EnterprisesAtlas EnterprisesAtlas EnterprisesMapped
Summit LogisticsSummit LogisticsSummit LogisticsSummit LogisticsSummit LogisticsMapped
Westfield MediaWestfield MediaWestfield Media Ltd.Westfield MediaWestfield MediaMapped
Lighthouse ServicesLighthouse ServicesLighthouse Services Co.Lighthouse ServicesLighthouse ServicesMapped
Crestline ServicesCrestline ServicesCrestline Services Ltd.Crestline ServicesCrestline ServicesMapped
Crestline WorksCrestline WorksCrestline Works Corp.Crestline WorksCrestline WorksMapped
Acme VenturesAcme VenturesAcme VenturesAcme VenturesAcme VenturesMapped
Beacon ContractorsBeacon ContractorsBeacon ContractorsBeacon ContractorsBeacon ContractorsMapped
Ridgeline SolutionsRidgeline SolutionsRidgeline SolutionsRidgeline SolutionsRidgeline SolutionsMapped
Golden HoldingsGolden HoldingsGolden Holdings LLCGolden HoldingsGolden HoldingsMapped
Cascade WorksCascade WorksCascade WorksCascade WorksCascade WorksMapped
Bluepeak StudioBluepeak StudioBluepeak Studio Co.Bluepeak StudioBluepeak StudioMapped
Bluepeak WorksBluepeak WorksBLUEPEAK WORKS LLCBluepeakBluepeakReview
Cedar HoldingsCedar HoldingsCedar HoldingsCedar Holdings Corp.Cedar HoldingsMapped
Fairview LabsFairview LabsFairview LabsFairview Labs Inc.Fairview LabsMapped
Highland GroupHighland GroupHighland GroHighland GroHighlandReview
Apex CapitalApex CapitalApex Capital Corp.Apex CapitalApex CapitalMapped
Maple ContractorsMaple ContractorsMaple ContractorsMaple ContractorsMaple ContractorsMapped
Glenwood AnalyticsGlenwood AnalyticsGlenwood Analytics—Glenwood AnalyticsUnmapped
Liberty DistributionLiberty DistributionLiberty Distribution Inc.Liberty DistributionLiberty DistributionMapped
Vertex AnalyticsVertex AnalyticsVertex Analytics Corp.Vertex Analytics Co.Vertex AnalyticsMapped
Crestline DentalCrestline DentalCrestline DentalCrestline DentalCrestline DentalMapped
Copper PartnersCopper PartnersCopper Partners Ltd.Copper PartnersCopper PartnersMapped
Beacon TechnologiesBeacon TechnologiesBeacon TechnologiesBeacon TechnologiesBeacon TechnologiesMapped
Rockwood MotorsRockwood MotorsRockwood MotorsRockwood MotorsRockwood MotorsMapped
Redwood PartnersRedwood PartnersRedwood PartnersRedwood PartnersRedwood PartnersMapped
Foundry SystemsFoundry SystemsFoundry Systems Co.Foundry Systems Co.Foundry SystemsMapped
Summit WorksSummit WorksSummit WorksSummit Works Co.Summit WorksMapped
Northstar DentalNorthstar DentalNorthstar Dental Corp.Northstar DentalNorthstar DentalMapped
River TechnologiesRiver TechnologiesRiver Technologies Co.River Technologies Corp.River TechnologiesMapped
Cedar IndustriesCedar IndustriesCedar IndustriesCedar IndustriesCedar IndustriesMapped
Cornerstone AnalyticsCornerstone AnalyticsCornerstone Analytics LLCCornerstone AnalyticsCornerstone AnalyticsMapped
Foundry SolutionsFoundry SolutionsFoundry Solutions Corp.Foundry Solutions Ltd.Foundry SolutionsMapped
Timberline ContractorsTimberline ContractorsTimberline ContractorsTimberline ContractorsTimberline ContractorsMapped
Horizon MotorsHorizon MotorsHorizon Motors Ltd.Horizon MotorsHorizon MotorsMapped
Apex WorksApex WorksApex WorksApex Works LLCApex WorksMapped
Lakeside AnalyticsLakeside AnalyticsLakeside Analytics Ltd.Lakeside AnalyticsLakeside AnalyticsMapped
Clearwater AdvisoryClearwater AdvisoryClearwater Advisory LLCClearwater Advisory Co.Clearwater AdvisoryMapped
Northstar LabsNorthstar LabsNorthstar Labs LLCNorthstar LabsNorthstar LabsMapped
Eastgate SystemsEastgate SystemsEastgate Systems—Eastgate SystemsUnmapped
500 clients · page 8 of 10

Exceptions

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