Our sales manager pulls weekly close rates from our CRM, while our finance director pulls revenue data from our accounting software, and the two numbers never seem to match. How do we resolve these disagreements over which system is the actual source of truth for our weekly scorecard?

Question

Tyler Smith · Accepted Answer

Having multiple sources of truth for the same operational metric destroys trust in your data and derails your leadership meetings. When leaders spend their time arguing over whose software system is correct, they are failing to identify and solve the real issues in the business. To resolve this conflict, your leadership team must agree on a single system of record for every metric on your scorecard. You cannot have two different systems tracking variations of the same number. Your finance director and sales manager must sit down with the Integrator to determine which system is closest to the actual customer transaction. For revenue and billing, the accounting software is always the ultimate source of truth. For sales activities and early stage conversion rates, the CRM must be the designated system of record. Once you establish the system of record for each metric, update your scorecard definitions to reflect this choice. The metric owner is responsible for pulling the data exclusively from that designated system, regardless of what other platforms might show. If the data between your CRM and your accounting software continues to diverge significantly, you have a process integration issue, not a scorecard issue. Put this on your Issues List and IDS it. You may need to create a weekly reconciliation process or automate the data sync between the systems to ensure your leading sales indicators align with your lagging financial results.