Marketing reports, intake dashboards, and the firm's matter system can each show a different number of wins without any one system being broken. They may count different events. Reconcile those events before using conversion totals to renew a supplier or increase spending. The firm needs a traceable connection from a reported intake success to the work it actually opens and accepts under its own process.
Define Each Success Event In Plain Language
List the events the systems report: a consultation booked, a favorable review, documents completed, a final firm acceptance, and a matter opened. Identify who controls each event and the evidence that supports it. The firm's professional leadership should define the engagement and acceptance milestones; software labels should follow those definitions.
Do not collapse the sequence merely to create one attractive conversion number. Different milestones serve different decisions. Intake needs to know what is waiting for completion, while the owner may need opened matters for a specific acquisition report. Showing both with clear labels is more useful than forcing them to agree by definition.
Use Stable References To Connect Records
Connect the inquiry and potential matter to the official matter reference through an approved internal mapping. Preserve the original source and entry date even if the matter opens later. Avoid relying on names alone, especially where multiple people share a household or one person has more than one issue.
Keep the reconciliation data limited to what the business decision requires. An agency may need an approved aggregate result or a restricted reference rather than access to the matter file. The firm should decide which information leaves its systems and how reporting feedback will be handled.
Build A Bridge Between The Two Totals
Illustrative monthly reconciliation: intake reports 30 completed engagement packets. The matter system shows 24 corresponding openings by the reporting date. Of the six remaining records, three await an administrative setup step, one requires an unresolved firm approval, one duplicates an existing potential matter, and one cannot yet be matched. The bridge explains the difference without calling all six lost.
Assign each exception to an owner. Administrative setup needs a task, unresolved approval needs the proper reviewer, the duplicate needs a documented relationship, and the unmatched record needs investigation. Keep the report date visible because some exceptions may resolve naturally after month end while others require correction.
Apply Adjustments To The Right Period
Separate the date an event occurred from the date staff entered or corrected it. A matter opened late from last month's inquiries should improve that inquiry cohort's outcome without being represented as a new inquiry this month. Retain dated snapshots where earlier reports are used for vendor or compensation decisions.
Define how reopened matters, withdrawn engagements, transfers, and merged records affect each metric. The answer can differ by metric, but it should be consistent and documented. A vendor invoice may use a delivery event, while the owner's acquisition report uses a distinct opened matter. Neither should silently inherit the other's exclusions.
Review Exceptions Before Adjusting Spend
Run the reconciliation at a cadence that supports the actual budget decision. Review the size and age of unresolved differences, not only whether the totals are closer. A growing unmatched group can make a channel appear weak even when appropriate matters are opening under missing source references.
Once the bridge is dependable, compare equal-age cohorts and the firm's service economics. Do not treat a reconciled opened-matter count as collected revenue or proof that advertising caused every matter. Reconciliation improves the accuracy of the chosen measure; the owner still needs to decide what that measure can support.
Common Questions
Which System Should Be The Source Of Truth?
Assign authority by event. The matter system may govern official openings, while intake retains earlier contact and handoff events. A reconciliation connects those authorities. Calling one system the source of truth for every stage can erase useful evidence that exists elsewhere in the process.