How a 17-Office CPA Firm Got Its Sales Team Back Into the CRM

Half the Firm Had Stopped Using the CRM

Of Blue's 60-plus directors, only 5 to 7 used Dynamics consistently. About a third logged contacts but skipped pursuits. The remaining half operated without pipeline tracking, working from email threads, OneDrive folders, and Excel exports.

Customer Data Lived in Four Disconnected Systems

Customer data lived across four systems: Dynamics, Maconomy, HubSync, and IntroHive. Each held different fields, formats, and identifiers. Reconciling them meant manual exports, lookups, and director-level cleanup.

Marketing Generated Leads That Sales Could Not Receive Cleanly

Web leads arrived through HubSpot. Marketing manually re-typed each one into Dynamics and assigned it by email. NAICS codes were typed by hand from thousands of options. Lead source data degraded with every handoff.

Pipeline Reporting Was Excel Exports

Sales reporting in Dynamics was list views exported into Excel for reformatting. Director Scorecards, Win/Loss Reports, and Pipeline Reports all required manual pulls. Leadership had no live view of revenue activity across offices, service lines, or directors.

Each Office Operated Differently

Adoption varied office by office and service line by service line. Audit entered leads at 90% confidence. Tax entered at Closed Won. Business Valuation operated in OneDrive and Trello. There was no shared template to scale across 17 offices.

Only One Person Got Credit for Each Win

Dynamics gave full deal credit to one named person. Directors, engagement managers, and billers who collaborated on the same client got nothing in the system. Cross-sell between sister entities went untracked despite shared clients.

Built a Custom Client Object for Multi-Engagement, Parent-Child Workflows

A custom HubSpot Client object replaced the native Company object. Each Client record holds contacts, deals, billing data, and parent-child relationships specific to a CPA firm. The structure mirrors how directors think about client relationships, not how generic CRMs model them.

Partitioned One HubSpot Portal for Multi-Entity Operation

Blue & Co. and Blue Benefits Consulting operate from one HubSpot portal today, with Alliant Purchasing in active migration. Each entity sees its own data by default. A defined cross-sell access group sees across entities where collaboration matters.

Connected One Pipeline to HubSync and Maconomy at EL Signature

A single sales pipeline runs nine action-based stages from Qualified Prospect through Closed Won. Properties differentiate Individual vs Entity clients and flag recurring deals. The pipeline syncs to Maconomy through the Shared Data Service to generate Client IDs at the engagement letter stage.

Replaced Excel Reporting With Live Dashboards and Microsoft Fabric

HubSpot dashboards handle operational reporting across the firm. A Growth Guide dashboard replaces the monthly Word document Healthcare directors filled by hand. Office and service-line versions clone across all locations for live visibility at every level.

Equipped Blue's Engineers With an Integration Starter Kit

Beyond configuration, Mole Street produced an Integration Starter Kit. The kit covers HubSpot APIs, middleware patterns, and Microsoft Fabric architecture. Blue's developers now build the data layer themselves with Mole Street advising on patterns.

Built Deal Team Attribution for Multi-Person Win Credit

A Deal Team Member multi-association on every Deal supports percentage, dollar, or replicated credit. This addresses Blue's long-standing "only one person gets credit" problem. Directors, engagement managers, and billers who collaborate on a deal now share the win.