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
Wellspring AnalyticsWellspring AnalyticsWellspring AnalyticsWellspring AnalyticsWellspring AnalyticsMapped
Cedar FoodsCedar FoodsCedar Foods LLCCedar Foods Inc.Cedar FoodsMapped
Sterling EnterprisesSterling EnterprisesSterling EnterprisesSterling Enterprises Corp.Sterling EnterprisesMapped
Cornerstone HoldingsCornerstone HoldingsCornerstone HoldingsCornerstone Holdings Co.Cornerstone HoldingsMapped
Pinnacle ContractorsPinnacle ContractorsPinnacle ContractorsPinnacle ContractorsPinnacle ContractorsMapped
Hillcrest StudioHillcrest StudioHillcrest StudioHillcrest StudioHillcrest StudioMapped
Prairie MotorsPrairie MotorsPrairie Motors Corp.Prairie Motors LLCPrairie MotorsMapped
Harbor BuildersHarbor BuildersHarbor BuildersHarbor Builders Co.Harbor BuildersMapped
Northstar RealtyNorthstar RealtyNorthstar RealtyNorthstar RealtyNorthstar RealtyMapped
Maple StudioMaple StudioMaple Studio Co.Maple StudioMaple StudioMapped
Vertex StudioVertex StudioVertex StudioVertex StudioVertex StudioMapped
Cedar BuildersCedar BuildersCedar BuildersCedar BuildersCedar BuildersMapped
Westfield RealtyWestfield RealtyWestfield Realty Inc.Westfield RealtyWestfield RealtyMapped
Brookstone SystemsBrookstone SystemsBrookstone Systems Co.Brookstone Systems Corp.Brookstone SystemsMapped
Rockwood PartnersRockwood PartnersRockwood PartnersRockwood Partners Inc.Rockwood PartnersMapped
Lighthouse AdvisoryLighthouse AdvisoryLighthouse AdvisoryLighthouse AdvisoryLighthouse AdvisoryMapped
River SupplyRiver SupplyRiver Supply Co.River SupplyRiver SupplyMapped
Cascade LogisticsCascade LogisticsCascade Logistics Corp.Cascade LogisticsCascade LogisticsMapped
Anchor BuildersAnchor BuildersAnchor BuildersAnchor Builders Co.Anchor BuildersMapped
Clearwater RealtyClearwater RealtyClearwater RealtyClearwater RealtyClearwater RealtyMapped
Bayview DistributionBayview DistributionBayview DistributionBayview Distribution Ltd.Bayview DistributionMapped
Ashford NetworksAshford NetworksAshford NetworksAshford NetworksAshford NetworksMapped
Wellspring NetworksWellspring NetworksWellspring NetworksWellspring NetworksWellspring NetworksMapped
Wintergreen NetworksWintergreen NetworksWintergreen Networks Corp.Wintergreen Networks Ltd.Wintergreen NetworksMapped
Brookstone PartnersBrookstone PartnersBrookstone PartnersBrookstone PartnersBrookstone PartnersMapped
Westfield DesignWestfield DesignWestfield Design Co.Westfield DesignWestfield DesignMapped
Wintergreen StudioWintergreen StudioWintergreen Studio Inc.Wintergreen StudioWintergreen StudioMapped
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
Cedar HoldingsCedar HoldingsCedar HoldingsCedar Holdings Corp.Cedar HoldingsMapped
Fairview LabsFairview LabsFairview LabsFairview Labs Inc.Fairview LabsMapped
Apex CapitalApex CapitalApex Capital Corp.Apex CapitalApex CapitalMapped
Maple ContractorsMaple ContractorsMaple ContractorsMaple ContractorsMaple ContractorsMapped
Liberty DistributionLiberty DistributionLiberty Distribution Inc.Liberty DistributionLiberty DistributionMapped
462 clients · page 7 of 10

Exceptions

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