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
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
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
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
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
462 clients · page 8 of 10

Exceptions

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