{"id":355,"date":"2025-12-09T05:49:37","date_gmt":"2025-12-09T05:49:37","guid":{"rendered":"https:\/\/aboutpetertran.com\/?p=355"},"modified":"2025-12-09T05:49:37","modified_gmt":"2025-12-09T05:49:37","slug":"fixing-the-active-customer-problem-when-finance-and-the-business-dont-agree","status":"publish","type":"post","link":"https:\/\/aboutpetertran.com\/?p=355","title":{"rendered":"Fixing the Active Customer Problem When Finance and the Business Don\u2019t Agree"},"content":{"rendered":"<p>\n\n\n<\/p><p>\n\n\n<\/p>\n<p>\n\n\n<\/p><p>\n\n\n<\/p>\n<p>\n\n\n<\/p><p>\n\n\n<\/p>\n<h1><strong>Fixing the Active Customer Problem When Finance and the Business Don\u2019t Agree<\/strong><\/h1>\n<\/p>\n<p>If you\u2019ve ever asked, \u201cHow many active customers do we actually have?\u201d and received three different answers, you already know the pain of misaligned definitions. At this company, Finance and the U.S. business weren\u2019t just a little out of sync. They were operating with <strong>entirely different models<\/strong>, different assumptions, and no shared milestones.<\/p>\n<\/p>\n<p>Invoices were wrong, contractors were paid for customers who weren\u2019t live, and leadership had no reliable customer count. My job sounded simple: determine how many customers were active. In reality, the system made that nearly impossible.<\/p>\n<\/p>\n<p>Let\u2019s dig in.<\/p>\n<h2><strong>The Context: Two Countries, Two Models, Zero Shared Definition<\/strong><\/h2>\n<\/p>\n<p>When I arrived, the U.S. team was operating in a pre-revenue environment, focused on market share and speed. The Australian finance team was running under an e-commerce operational model with different regulations and workflows.<\/p>\n<\/p>\n<p>Both groups talked about \u201cactive customers,\u201d but each meant something different. Without a shared definition or consistent documentation, the CRM couldn\u2019t serve as a source of truth.<\/p>\n<\/p>\n<p>The workflow gaps were clear:<\/p>\n<ul>\n<li>No standardized lifecycle stages<\/li>\n<li>No required fields<\/li>\n<li>No reliable onboarding tracking<\/li>\n<li>No process alignment between Sales, Onboarding, Compliance, Operations, and Finance<\/li>\n<\/ul>\n<p>With no common checkpoints, \u201cactive\u201d was subjective\u2014and reporting became guesswork.<\/p>\n<h2><strong>The Scenarios Where Customer Counts Go Wrong<\/strong><\/h2>\n<\/p>\n<h3><strong>Scenario 1: Each team invents its own definition<\/strong><\/h3>\n<\/p>\n<p>Teams filled gaps however they could. Sales viewed \u201cactive\u201d as prospects who completed onboarding steps. Finance defined it based on project management tools and contractor workflows. None of these definitions matched.<\/p>\n<\/p>\n<p><strong>Signs this scenario is happening:<\/strong><\/p>\n<ul>\n<li>Every department gives a different customer count<\/li>\n<li>Finance disputes Sales data<\/li>\n<li>Documentation varies wildly across records<\/li>\n<li>Leadership can\u2019t get a straight answer during planning cycles<\/li>\n<\/ul>\n<h3><strong>Scenario 2: The CRM can\u2019t reflect reality<\/strong><\/h3>\n<\/p>\n<p>Because fields weren\u2019t required and lifecycle stages didn\u2019t exist, the CRM held more noise than signal. Even well-intentioned teams couldn\u2019t document consistently.<\/p>\n<\/p>\n<p><strong>Signs your CRM is in this state:<\/strong><\/p>\n<ul>\n<li>Records show missing or contradictory onboarding data<\/li>\n<li>Status fields don\u2019t map to operational milestones<\/li>\n<li>Manual review is the only way to confirm a customer\u2019s state<\/li>\n<\/ul>\n<h3><strong>Scenario 3: The business outgrew its definition but never replaced it<\/strong><\/h3>\n<\/p>\n<p>The medical regulatory differences between countries added complexity. Each region evolved independently, and without shared milestones, terms lost meaning.<\/p>\n<\/p>\n<p><strong>Signs this is happening:<\/strong><\/p>\n<ul>\n<li>Teams disagree not only on counts, but on what \u201cactive\u201d even means<\/li>\n<li>Finance relies on tools outside the CRM<\/li>\n<li>No one can identify the moment a customer becomes \u201clive\u201d<\/li>\n<\/ul>\n<h2><strong>How I rebuilt the system using milestones<\/strong><\/h2>\n<\/p>\n<h3><strong>Step 1: Establish a reliable baseline<\/strong><\/h3>\n<\/p>\n<p>Before fixing anything, I manually audited <strong>every single customer record<\/strong>. This was the only way to untangle conflicting documentation and confirm who was actually active. The audit gave us a number Finance could finally trust.<\/p>\n<\/p>\n<h3><strong>Step 2: Define universal milestones<\/strong><\/h3>\n<\/p>\n<p>I aligned the teams around shared, objective checkpoints in the customer journey\u2014milestones that applied regardless of country, business model, or regulatory constraints. Examples included:<\/p>\n<ul>\n<li>Onboarding completed<\/li>\n<li>Required documents submitted<\/li>\n<li>Customer ready for service<\/li>\n<\/ul>\n<p>These milestones became the backbone of the entire solution.<\/p>\n<\/p>\n<h3><strong>Step 3: Build the structure inside the CRM<\/strong><\/h3>\n<\/p>\n<p>I translated those milestones into concrete lifecycle stages and a simple, milestone-based pipeline that any stakeholder could understand. This replaced guesswork with clean, visible progression.<\/p>\n<\/p>\n<h3><strong>Step 4: Standardize documentation<\/strong><\/h3>\n<\/p>\n<p>Working with Sales and Onboarding, I created clear rules for:<\/p>\n<ul>\n<li>Which fields must be completed<\/li>\n<li>When those fields are required<\/li>\n<li>How onboarding progression must be documented<\/li>\n<\/ul>\n<p>This eliminated inconsistent recordkeeping and forced alignment between teams.<\/p>\n<\/p>\n<h3><strong>Step 5: Train and reinforce<\/strong><\/h3>\n<\/p>\n<p>I trained every stakeholder group, explained why milestones mattered, and provided SOPs to enforce consistent behavior even with the outdated system we had.<\/p>\n<\/p>\n<p><strong>Example:<\/strong><\/p>\n<p>Finance no longer needed to review external tools or interpret vague notes. They could view a CRM milestone and know, with confidence, whether a customer was billable.<\/p>\n<h2><strong>When You Don\u2019t Have Clean Data or Cross-Team Alignment<\/strong><\/h2>\n<\/p>\n<p>You can\u2019t fix this type of problem by adding automation or enforcing validation rules. When definitions differ by region or team, the CRM becomes a reflection of misalignment\u2014not the cause of it.<\/p>\n<\/p>\n<p>In environments like this:<\/p>\n<ul>\n<li>Manual auditing is often unavoidable<\/li>\n<li>You must build alignment before you build technology<\/li>\n<li>Milestones provide clarity when teams can\u2019t agree on processes<\/li>\n<li>Data hygiene only improves when documentation becomes universal<\/li>\n<\/ul>\n<p>When stakeholders see the CRM as \u201csomeone else\u2019s system,\u201d milestone alignment becomes the entry point to shared ownership.<\/p>\n<h2><strong>This Isn\u2019t a Data Problem\u2014It\u2019s a Definition Problem<\/strong><\/h2>\n<\/p>\n<p>The biggest barrier wasn\u2019t technology. It was the absence of shared language. Once the company aligned around a single definition of \u201cactive customer,\u201d everything else fell into place:<\/p>\n<ul>\n<li>Finance gained an accurate, trusted customer list<\/li>\n<li>Onboarding understood what needed to be logged<\/li>\n<li>Sales knew exactly when a customer became billable<\/li>\n<li>Leadership could finally interpret customer counts reliably<\/li>\n<\/ul>\n<p>A stable customer count isn\u2019t created by automation. It\u2019s created by definitions that every team understands, documents, and follows.<\/p>\n<\/p>\n<p>A system can only be as accurate as the milestones beneath it.<\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fixing the Active Customer Problem When Finance and the Business Don\u2019t Agree If you\u2019ve ever asked, \u201cHow many active customers do we actually have?\u201d and received three different answers, you already know the pain of misaligned definitions. At this company, Finance and the U.S. business weren\u2019t just a little out of sync. They were operating [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":358,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","post-wrapper","thrv_wrapper"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/posts\/355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=355"}],"version-history":[{"count":6,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/posts\/355\/revisions"}],"predecessor-version":[{"id":362,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/posts\/355\/revisions\/362"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=\/wp\/v2\/media\/358"}],"wp:attachment":[{"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aboutpetertran.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}