Back to Collections

Analytics Drilldown

Collections / chart-insurance-portion

Import payments, adjustments, write-offs, and collection dates before displaying collection percentage or goal variance.

What is happening

Unavailable compared with Requires payments export. Variance: Unavailable.

Current value

Unavailable compared with Requires payments export. Variance: Unavailable.

Target

Requires payments export

Variance

Unavailable compared with Requires payments export. Variance: Unavailable.

Recommended Next Action

Import payments, adjustments, write-offs, and collection dates before displaying collection percentage or goal variance.

Why it matters

Requires review: current approved exports include A/R but not payment transactions, so collections rate cannot be calculated honestly.

Success measure

Metric is reviewed, work is assigned, and the next measurement has a named owner.

Relevant SOP

Collections operating review

Data source and confidence

Active Open Dental export snapshot / Partial until every source export is validated

Take action

Every queue change opens a preview first.

View recordsOpen SOP
Create task

Preview: Create task

Kay will move this into active work so it can be owned, followed up, and marked complete.

Assign owner

Preview: Assign owner

Kay will assign this work to the selected owner before it appears as in-progress execution.

Mark reviewed

Preview: Mark reviewed

Kay will record that the recommendation was reviewed and no longer needs to lead the queue.

Intentional / N/A

Preview: Intentional / N/A

Kay will remove this from the active queue because the condition was intentional or does not apply.

Dismiss with reason

Preview: Dismiss with reason

Kay will dismiss this only after a reason is captured, so the decision can be reviewed later.

Escalate

Preview: Escalate

Kay will escalate this to the Director queue for leadership review before the day moves on.

BackClose

Likely Contributors

Requires review: current approved exports include A/R but not payment transactions, so collections rate cannot be calculated honestly.

Missing Data

No missing field blocks this workflow.

Calculation

Unavailable compared with Requires payments export. Variance: Unavailable.

Trend

Missing payments dataset

Target

Requires payments export

Underlying Records

A/R snapshot summary

MetricValueSourceAction
Total A/R$0accounts_receivableOpen work
Patient portion$0accounts_receivableOpen work
Insurance portion$0accounts_receivableOpen work
90+ aging$0accounts_receivableOpen work
Balances tied to schedule date$0accounts_receivable + appointmentsOpen work