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
Union ManufacturingUnion ManufacturingUnion ManufacturingUnion Manufacturing Inc.Union ManufacturingMapped
Ashford DesignAshford DesignAshford Design Inc.Ashford Design LLCAshford DesignMapped
Maple VenturesMaple VenturesMaple Ventures Ltd.Maple VenturesMaple VenturesMapped
Maple RealtyMaple RealtyMaple RealtyMaple RealtyMaple RealtyMapped
Prairie MediaPrairie MediaPrairie Media Inc.Prairie MediaPrairie MediaMapped
Golden LogisticsGolden LogisticsGolden Logistics LLCGolden LogisticsGolden LogisticsMapped
Rockwood HoldingsRockwood HoldingsRockwood Holdings LLCRockwood HoldingsRockwood HoldingsMapped
Liberty WorksLiberty WorksLiberty WorksLiberty WorksLiberty WorksMapped
Clearwater DentalClearwater DentalClearwater DentalClearwater Dental Inc.Clearwater DentalMapped
Westfield ManufacturingWestfield ManufacturingWestfield Manufacturing Inc.Westfield Manufacturing Corp.Westfield ManufacturingMapped
Northstar SolutionsNorthstar SolutionsNorthstar Solutions Inc.Northstar Solutions Ltd.Northstar SolutionsMapped
Hillcrest SupplyHillcrest SupplyHillcrest SupplyHillcrest SupplyHillcrest SupplyMapped
Lakeside VenturesLakeside VenturesLakeside Ventures Inc.Lakeside VenturesLakeside VenturesMapped
Redwood LabsRedwood LabsRedwood LabsRedwood LabsRedwood LabsMapped
Brookstone EnterprisesBrookstone EnterprisesBrookstone Enterprises LLCBrookstone EnterprisesBrookstone EnterprisesMapped
Pinnacle CapitalPinnacle CapitalPinnacle CapitalPinnacle CapitalPinnacle CapitalMapped
Hillcrest SolutionsHillcrest SolutionsHillcrest Solutions Co.Hillcrest SolutionsHillcrest SolutionsMapped
Brookstone ConsultingBrookstone ConsultingBrookstone ConsultingBrookstone Consulting Corp.Brookstone ConsultingMapped
Golden WorksGolden WorksGolden Works Inc.Golden WorksGolden WorksMapped
Wellspring SupplyWellspring SupplyWellspring SupplyWellspring Supply Inc.Wellspring SupplyMapped
Redwood DesignRedwood DesignRedwood DesignRedwood Design Ltd.Redwood DesignMapped
Union DesignUnion DesignUnion DesignUnion Design Ltd.Union DesignMapped
Wellspring MotorsWellspring MotorsWellspring MotorsWellspring Motors Ltd.Wellspring MotorsMapped
Beacon LogisticsBeacon LogisticsBeacon LogisticsBeacon LogisticsBeacon LogisticsMapped
Ironwood DentalIronwood DentalIronwood DentalIronwood DentalIronwood DentalMapped
Cedar SupplyCedar SupplyCedar Supply Co.Cedar SupplyCedar SupplyMapped
Westfield EnterprisesWestfield EnterprisesWestfield Enterprises LLCWestfield EnterprisesWestfield EnterprisesMapped
Crestline GroupCrestline GroupCrestline GroupCrestline Group Inc.Crestline GroupMapped
Bluepeak ManufacturingBluepeak ManufacturingBluepeak ManufacturingBluepeak ManufacturingBluepeak ManufacturingMapped
Crestline SupplyCrestline SupplyCrestline Supply Ltd.Crestline Supply LLCCrestline SupplyMapped
Ridgeline MotorsRidgeline MotorsRidgeline MotorsRidgeline MotorsRidgeline MotorsMapped
Sterling GroupSterling GroupSterling GroupSterling GroupSterling GroupMapped
Brookstone StudioBrookstone StudioBrookstone StudioBrookstone StudioBrookstone StudioMapped
Summit RealtySummit RealtySummit RealtySummit Realty Inc.Summit RealtyMapped
Bayview IndustriesBayview IndustriesBayview IndustriesBayview IndustriesBayview IndustriesMapped
Summit LabsSummit LabsSummit LabsSummit LabsSummit LabsMapped
Atlas WorksAtlas WorksAtlas WorksAtlas WorksAtlas WorksMapped
Wintergreen EnterprisesWintergreen EnterprisesWintergreen Enterprises Corp.Wintergreen Enterprises Inc.Wintergreen EnterprisesMapped
Redwood EnterprisesRedwood EnterprisesRedwood Enterprises Co.Redwood EnterprisesRedwood EnterprisesMapped
Vanguard CapitalVanguard CapitalVanguard Capital Co.Vanguard CapitalVanguard CapitalMapped
Horizon DesignHorizon DesignHorizon Design Inc.Horizon DesignHorizon DesignMapped
Atlas PartnersAtlas PartnersAtlas PartnersAtlas PartnersAtlas PartnersMapped
Granite NetworksGranite NetworksGranite Networks Co.Granite NetworksGranite NetworksMapped
Copper WorksCopper WorksCopper WorksCopper WorksCopper WorksMapped
Meridian WorksMeridian WorksMeridian WorksMeridian Works Ltd.Meridian WorksMapped
Prairie EnterprisesPrairie EnterprisesPrairie EnterprisesPrairie Enterprises Ltd.Prairie EnterprisesMapped
Union BuildersUnion BuildersUnion BuildersUnion Builders Corp.Union BuildersMapped
Bluepeak BuildersBluepeak BuildersBluepeak BuildersBluepeak Builders Co.Bluepeak BuildersMapped
Redwood BuildersRedwood BuildersRedwood BuildersRedwood Builders Co.Redwood BuildersMapped
Timberline VenturesTimberline VenturesTimberline Ventures Co.Timberline VenturesTimberline VenturesMapped
462 clients · page 9 of 10

Exceptions

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