Build a finance dashboard that exposes unresolved reconciliation with fictional control totals, exception arithmetic, cutoffs, and buyer acceptance tests.
A behavioral health finance dashboard should show the defined control total, explained allocations, unresolved difference, and observation cutoff so readers can reconstruct what remains uncertain.
A dashboard can be visually tidy while a material amount remains unassigned. If the unresolved amount is omitted, executives may read the visible total as a complete answer. The practical buying question is whether the proposed reporting process can show its population and explain its uncertainty. Start with a small synthetic deposit exercise that finance can reproduce by hand, then evaluate the software against that result.
behavioral health finance dashboard unresolved reconciliation
CMS distinguishes payment movement from remittance information. CMS describes claim, service-line, and provider-level remittance adjustments. Those distinctions explain why a bank total and claim allocation total can require a bridge. The dashboard specimen here is original and fictional.
Choose one financial question before selecting charts. “How much cash arrived?” and “How much received cash has been explained?” require different measures. A dashboard that calls both “collections” invites readers to compare numbers that do not share a definition.
The first acceptance requirement is plain language beside the metric. Name the selected accounts or entities, date basis, cutoff, included transaction types, and any unresolved population. A footnote that says only “data may vary” does not help the CFO reconstruct the figure.
Calculate a fictional control total by hand
Assume a fictional bank deposit of $10,000 at the November 6 observation cutoff. Finance has explained $7,400 as claim-linked receipts, $1,200 as a provider-level item under review with supporting evidence, and $900 as another identified receipt. A remaining $500 has not yet been explained.
| Component | Amount | Meaning in this specimen |
|---|---|---|
| Bank control total | $10,000 | Money observed in selected deposit |
| Claim-linked receipts | $7,400 | Explained destination with evidence |
| Identified provider-level item | $1,200 | Classified separately from claims |
| Other explained receipt | $900 | Identified and supported |
| Unresolved difference | $500 | No accepted allocation yet |
The identity is $10,000 equals $7,400 plus $1,200 plus $900 plus $500. Explained amounts total $9,500. Unresolved value is 5% of the selected deposit, calculated as $500 divided by $10,000. That percentage describes this invented sample, not an industry benchmark.
Decide what the headline actually represents
If the headline is bank cash, it shows $10,000 with a separate explanation status. If the headline is explained allocation, it shows $9,500 and identifies the $500 difference to the bank control. Neither measure should be relabeled as recognized revenue without an appropriate finance definition.
The $1,200 item needs careful wording. “Identified” can mean the source has been located while the business treatment remains under review. A dashboard can therefore distinguish source matching from final disposition. The example does not assume that locating a remittance settles every accounting question.
Make the drill-down support the label. A reader selecting “unresolved $500” should receive the selected items and reasons that actually make up $500. A generic worklist containing other dates, accounts, or entities breaks the explanation even if its total happens to match.
Show why balancing totals can still be wrong
Create two fictional claim allocations: claim A receives $300 too much and claim B receives $300 too little. The net difference is zero. The dashboard can balance to $10,000 while both claim balances remain wrong. This is why a control-total exercise should include transaction-level matching as well as arithmetic.
The acceptance sample should identify the evidence supporting the destination of each receipt: payer or remitter context, relevant reference, selected payee or entity, and associated claim or other explanation. Avoid matching solely by amount when several receipts share the same value.
Now reverse the two misallocations. The bank total stays $10,000, the explained total may stay $9,500, and the detail changes. The dashboard's history or supporting record should explain that change rather than suggesting new cash arrived. The committee is testing whether a correct total has a correct composition.
Separate distinct items from overlapping reasons
Suppose the $500 unresolved amount consists of two receipts: U-1 for $300 and U-2 for $200. U-1 has both a missing remittance reference and an uncertain payee. U-2 has only a missing reference. There are two distinct receipts but three reason occurrences.
A reason chart can show two missing-reference occurrences and one uncertain-payee occurrence. Its bars sum to three, not two. If the same dollars are attached to both reasons for U-1, the reason-dollar bars sum to $800 even though unresolved value is $500. Label the chart as overlapping exposure or use mutually exclusive primary reasons.
Do not divide three reasons by two receipts and call the result an unresolved rate. Choose the denominator that matches the measure. The row-level specimen makes this error easy to detect before a visually convincing chart reaches an executive meeting.
Expose freshness and late-arriving explanations
At a later cutoff, staff identify U-2's $200 destination. The bank total remains $10,000; explained allocation becomes $9,700 and unresolved difference becomes $300. That is information progress, not new cash. Save both observations or a sufficient change record to explain the movement.
If another $400 deposit arrives between refreshes, the next population contains $10,400. The dashboard should separately explain the new money and the $200 resolution. Otherwise users may interpret a changed unresolved percentage as an operating improvement when the denominator simply grew.
Show when each source was observed and when the dashboard refreshed. A current bank extract combined with an older remittance extract can produce a legitimate temporary difference. Calling the dashboard “real time” does not resolve that mismatch. The buyer should request actual freshness behavior and failure handling in the demonstrated scope.
Use a reproducibility test before committee sign-off
Give the synthetic rows to one reviewer and the dashboard output to another. Ask each to calculate $10,000, $9,500, and $500, then identify the two unresolved receipts. They should also explain why the reason chart does not add to the distinct receipt count. Differences reveal either a definition problem or missing detail.
Repeat after resolving U-2 and after adding the $400 deposit. A successful test preserves the earlier cutoff, explains the population change, and produces the new totals using stated rules. It does not require a particular dashboard design. A modest table that can be reproduced may serve the committee better than an unexplained score.
Accept the metric only for the uses supported by its evidence. A deposit-allocation specimen does not validate every revenue report, payer reconciliation, accounting export, or finance dashboard the organization may later request.
Review the unresolved amount across the platform
Ease offers a unified CRM, EHR, and RCM platform for behavioral health. Bring the deposit control-total and overlapping-reason specimen to a joint review of CRM, EHR, and RCM. Ask the committee to evaluate unexplained finance dashboard totals using the specific evidence and exception cases in this article. Record the demonstrated scope, any configuration or external work required, and the unresolved requirements that could change the purchase decision.
Related reading
Frequently Asked Questions
Should unresolved reconciliation be subtracted from the headline total?
Show the control total and unresolved amount as separately defined measures. The appropriate presentation depends on whether the headline describes bank cash, allocation, charges, or another measure.
Can reason counts be added to get unresolved item counts?
Only if the reasons are mutually exclusive. One item can have several reasons, so show distinct items and reason occurrences separately.
Does an equal total prove each payment is correct?
No. Offsetting misallocations can balance a total. Test the transaction detail and evidence linking each item to its financial destination.
What should a finance dashboard acceptance sample contain?
Include a known control total, explained items, one unresolved item, a late correction, cutoff metadata, and detail sufficient for another reviewer to reproduce the arithmetic.
