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
Cornerstone VenturesCornerstone VenturesCornerstone VenturesCornerstone VenturesCornerstone VenturesMapped
Beacon DesignBeacon DesignBeacon DesignBeacon DesignBeacon DesignMapped
Fairview DentalFairview DentalFairview DentalFairview Dental Co.Fairview DentalMapped
Golden ServicesGolden ServicesGolden Services Co.Golden ServicesGolden ServicesMapped
Cornerstone AdvisoryCornerstone AdvisoryCornerstone AdvisoryCornerstone Advisory Ltd.Cornerstone AdvisoryMapped
Rockwood MediaRockwood MediaRockwood MediaRockwood Media LLCRockwood MediaMapped
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
Bluepeak PartnersBluepeak PartnersBluepeak ParBluepeakBluepeakReview
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
Westfield GroupWestfield GroupWESTFIELD GROUP CO.Westfield GroWestfieldReview
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
Lighthouse ManufacturingLighthouse ManufacturingLIGHTHOUSE MANUFACTURING CO.LighthouseLighthouseReview
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
Brookstone AdvisoryBrookstone AdvisoryBrookstone AdvBrookstoneBrookstoneReview
Cascade DistributionCascade DistributionCascade DistributionCascade DistributionCascade DistributionMapped
Glenwood RealtyGlenwood RealtyGlenwood RealtyGlenwood Realty LLCGlenwood RealtyMapped
500 clients · page 2 of 10

Exceptions

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