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
Eastgate PartnersEastgate PartnersEastgate PartnersEastgate PartnersEastgate PartnersMapped
Northstar SystemsNorthstar SystemsNorthstar Systems Ltd.Northstar SystemsNorthstar SystemsMapped
Foundry ContractorsFoundry ContractorsFoundry ContractorsFoundry ContractorsFoundry ContractorsMapped
Horizon SolutionsHorizon SolutionsHorizon SolutionsHorizon SolutionsHorizon SolutionsMapped
Atlas FoodsAtlas FoodsAtlas FoodsAtlas FoodsAtlas FoodsMapped
Copper TechnologiesCopper TechnologiesCopper Technologies Inc.Copper Technologies Ltd.Copper TechnologiesMapped
Evergreen SystemsEvergreen SystemsEvergreen Systems Ltd.Evergreen Systems Inc.Evergreen SystemsMapped
Highland SupplyHighland SupplyHighland SupplyHighland SupplyHighland SupplyMapped
Ironwood VenturesIronwood VenturesIronwood Ventures Co.Ironwood VenturesIronwood VenturesMapped
Northstar VenturesNorthstar VenturesNorthstar Ventures Corp.Northstar VenturesNorthstar VenturesMapped
Apex ContractorsApex ContractorsApex ContractorsApex ContractorsApex ContractorsMapped
Brookstone TechnologiesBrookstone TechnologiesBrookstone TechnologiesBrookstone Technologies Inc.Brookstone TechnologiesMapped
Bluepeak ContractorsBluepeak ContractorsBluepeak ContractorsBluepeak ContractorsBluepeak ContractorsMapped
Cascade SystemsCascade SystemsCascade Systems Corp.Cascade SystemsCascade SystemsMapped
Sterling CapitalSterling CapitalSterling CapitalSterling CapitalSterling CapitalMapped
Brookstone SolutionsBrookstone SolutionsBrookstone SolutionsBrookstone SolutionsBrookstone SolutionsMapped
Maple DentalMaple DentalMaple DentalMaple DentalMaple DentalMapped
Bayview AnalyticsBayview AnalyticsBayview Analytics Ltd.Bayview AnalyticsBayview AnalyticsMapped
Ashford RealtyAshford RealtyAshford RealtyAshford RealtyAshford RealtyMapped
Rockwood IndustriesRockwood IndustriesRockwood IndustriesRockwood Industries LLCRockwood IndustriesMapped
Union MediaUnion MediaUnion MediaUnion Media LLCUnion MediaMapped
Westfield HoldingsWestfield HoldingsWestfield HoldingsWestfield HoldingsWestfield HoldingsMapped
Union SystemsUnion SystemsUnion Systems Corp.Union Systems Inc.Union SystemsMapped
Summit DentalSummit DentalSummit DentalSummit DentalSummit DentalMapped
Granite EnterprisesGranite EnterprisesGranite EnterprisesGranite EnterprisesGranite EnterprisesMapped
Hillcrest NetworksHillcrest NetworksHillcrest Networks Ltd.Hillcrest NetworksHillcrest NetworksMapped
Bluepeak SupplyBluepeak SupplyBluepeak Supply Co.Bluepeak SupplyBluepeak SupplyMapped
Summit PartnersSummit PartnersSummit PartnersSummit PartnersSummit PartnersMapped
Foundry DentalFoundry DentalFoundry Dental Corp.Foundry Dental Inc.Foundry DentalMapped
Copper SolutionsCopper SolutionsCopper Solutions Ltd.Copper SolutionsCopper SolutionsMapped
Vertex SolutionsVertex SolutionsVertex Solutions Corp.Vertex Solutions Co.Vertex SolutionsMapped
Wellspring LabsWellspring LabsWellspring Labs LLCWellspring LabsWellspring LabsMapped
Beacon AnalyticsBeacon AnalyticsBeacon Analytics Corp.Beacon AnalyticsBeacon AnalyticsMapped
Evergreen SupplyEvergreen SupplyEvergreen Supply Corp.Evergreen SupplyEvergreen SupplyMapped
Fieldstone AdvisoryFieldstone AdvisoryFieldstone AdvisoryFieldstone Advisory Co.Fieldstone AdvisoryMapped
Wellspring ConsultingWellspring ConsultingWellspring Consulting Inc.Wellspring Consulting Inc.Wellspring ConsultingMapped
Cascade DesignCascade DesignCascade DesignCascade DesignCascade DesignMapped
Hillcrest DentalHillcrest DentalHillcrest DentalHillcrest Dental Ltd.Hillcrest DentalMapped
Cascade DistributionCascade DistributionCascade DistributionCascade DistributionCascade DistributionMapped
Glenwood RealtyGlenwood RealtyGlenwood RealtyGlenwood Realty LLCGlenwood RealtyMapped
Northstar DesignNorthstar DesignNorthstar Design LLCNorthstar Design Inc.Northstar DesignMapped
Fieldstone MotorsFieldstone MotorsFieldstone MotorsFieldstone Motors Ltd.Fieldstone MotorsMapped
Harbor LogisticsHarbor LogisticsHarbor Logistics Corp.Harbor LogisticsHarbor LogisticsMapped
Rockwood BuildersRockwood BuildersRockwood BuildersRockwood BuildersRockwood BuildersMapped
Copper LabsCopper LabsCopper LabsCopper LabsCopper LabsMapped
Granite LogisticsGranite LogisticsGranite Logistics Inc.Granite LogisticsGranite LogisticsMapped
Fieldstone ServicesFieldstone ServicesFieldstone ServicesFieldstone ServicesFieldstone ServicesMapped
Lakeside ManufacturingLakeside ManufacturingLakeside ManufacturingLakeside Manufacturing Inc.Lakeside ManufacturingMapped
Maple EnterprisesMaple EnterprisesMaple Enterprises LLCMaple EnterprisesMaple EnterprisesMapped
Fairview CapitalFairview CapitalFairview Capital Ltd.Fairview Capital LLCFairview CapitalMapped
462 clients · page 2 of 10

Exceptions

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