Audit Aging Receivables Weekly to Reduce Days-to-Collect
DentalSuite Team6 min read
Audit Aging Receivables Weekly to Reduce Days-to-Collect
Unreliable collections are an everyday drag: phone calls that go unanswered, insurance claims stuck with no activity, and balances that migrate from 30 to 90+ days before anyone escalates. An audit aging receivables weekly—brief, repeatable, and tied to clear actions—turns those slow drifts into visible, assigned work so the practice reduces days-to-collect on a predictable cadence.
Why a weekly audit beats ad-hoc follow-up
Ad-hoc follow-up lets receivables compound. A claim waiting two weeks for an adjuster response often produces no new activity the next week unless someone is explicitly assigned to push it. A weekly audit creates the rhythm that converts passive aging into active steps: identify the root cause (patient, insurance, internal rework), assign a named owner, and set a short deadline. That simple loop closes the accountability gap that turns 30-day balances into 90+ day write-offs.
Run the audit in 30–45 minutes: required data extract
Start with a single export from the practice system. The audit is only reliable if everyone reviews the same fields. Export these columns for all outstanding balances:
- Patient ID and name
- Date of service
- Current balance and patient-responsible portion
- Aging bucket (0–30, 31–60, 61–90, 91+)
- Claim ID and insurance status (submitted, pended, denied, processed)
- Last activity date and last contact note
- Collector assigned (if any)
- Promise-to-pay date or payment arrangement
- Estimate of insurance allowed and outstanding adjudication
- Provider and appointment originally scheduled (to tie back to production)
Triage rules to turn the extract into prioritized tasks
Apply a short set of triage rules so the audit produces a ranked to-do list rather than a spreadsheet to stare at. The rules below are operational — adjust thresholds to match practice size and cash-flow needs.
- 0–30 days with active claim: no immediate patient call. Assign insurance follow-up if last activity >7 days.
- 31–60 days with no claim submitted: prepare and submit claim within 48 hours; assign a person to complete coding/attachments.
- 61–90 days patient-responsible with no promise-to-pay: call within 48 hours and set written payment arrangement.
- 91+ days any balance: escalate to collections lead; send final notice and schedule manager review within 72 hours.
- Any denied claim: assign to claims specialist with required supporting documents and a 7-day follow-up.
- Small balances under $25 with no activity: batch for automated statement or single courtesy call; do not consume collector capacity for low-value items unless cumulative trend warrants it.
Assign actions and deadlines during the audit
Every line on the audit must have three attributes before you move on: owner, action, and deadline. Use these standard action codes so reports stay sortable: 'Call-Patient', 'Submit-Claim', 'Appeal-Denial', 'Send-Statement', 'Escalate-Manager', 'Close-WriteOff'. Apply deadlines as short windows: 48 hours for submission/first call, 7 days for appeals, 72 hours for escalation.
Sample weekly roles and a 10-minute morning-huddle script
Run the audit, then use a 10-minute huddle to assign and confirm. Keep it tight: the audit creates the facts; the huddle assigns accountability.
- Collections lead (2 minutes): Review top 10 items by dollar or by days-in-bucket and confirm owners and deadlines.
- Front-desk lead (2 minutes): Confirm claims that need attachments or resubmission and who will prepare them.
- Office manager (2 minutes): Agree on any escalations needing managerial sign-off or patient repayment plans.
- Hygiene/clinical lead (1 minute): Flag any scheduling dependencies tied to outstanding balances (e.g., treatment on hold).
- Everyone (3 minutes): Call out blocked items and confirm next huddle check-in if not resolved within the assigned deadline.
KPIs to track week-to-week and how to read them
Track these KPIs every week from the same data extract. Trends matter more than single-week changes.
- Days-to-collect (DSO): weekly rolling average. Watch direction; DSO should move down when the audit is working.
- % of AR in 91+ bucket: use this to trigger manager escalation thresholds.
- Claims pending >15 days with no activity: indicates insurance follow-up backlog or rework need.
- Promise-to-pay kept rate: percent of promised payments received on the agreed date; low rates require tighter follow-up or different payment terms.
- Collector touchpoints per balance per 30 days: measures activity vs. aging movement.
Common operational barriers and how to fix them
If the audit stalls, the cause is usually one of three operational problems: unclear ownership, too many low-value distractions, or missing attachments/coding that block claims. Fix each problem with an explicit rule.
- Ownership: name a single collector per account. If ownership changes, log the handoff and next deadline.
- Value focus: set a minimum-dollar threshold for manual collector work, but review cumulative low-dollar patterns monthly.
- Claim preparedness: require a checklist for submitted claims (radiographs, notes, itemized fees) and reject incomplete submissions back to the preparer within 24 hours.
How the weekly audit connects to other revenue playbooks
The weekly AR audit sits next to procedures for recovering unbilled work and for daily production recovery. Aligning these flows reduces rework and the number of items entering the aging report in the first place. See these operational guides for related steps: Weekly Production Recovery Playbook for Recovering Missed Revenue, Unbilled Procedures Reconciliation Process for Daily Closure, and Prioritize Daily Collections Tasks to Reduce Aging Receivables.
Measure whether the audit is working after 4–8 weeks
After running the audit for 4–8 weeks, compare the KPIs week-over-week. Look for a downward trend in DSO and a shrinking 91+ bucket. If you have fixed claim rework, the 'claims pending >15 days with no activity' metric should fall. If not, revise triage rules and reassign roles rather than adding more meetings.
Audit aging receivables weekly: a short checklist to start tomorrow
- Export the required fields and sort by aging bucket and last activity date.
- Apply triage rules to label each row with action, owner, and deadline.
- Run a 10-minute morning huddle to confirm owners on the top 20 actionable items.
- Update the practice dashboard KPIs and flag any items for manager escalation.
- Re-run the same audit next week and compare the KPIs before the huddle.
FAQ
How long will the weekly audit take?
With a prepared extract and a trained team, the triage and assignment cycle should take 30–45 minutes. The morning huddle to confirm assignments should take 10 minutes.
Who should own the audit?
Assign a collections lead (not necessarily the office manager) who runs the extract, applies triage rules, and runs the huddle. That lead is responsible for escalation and for weekly KPI reporting.
What if the practice management system can’t produce all the fields?
Create a minimal extract with balance, aging bucket, claim status, last activity date, and patient contact. Add missing fields manually where necessary, and document which fields are estimates until the system export can be improved.
How do we avoid wasting time on low-dollar accounts?
Set a working threshold for manual collector time and route sub-threshold items to automated statements or a monthly cleanup process. Track cumulative low-dollar trends monthly to see if they indicate systemic billing errors.
Final note
A short, repeatable weekly audit turns aging receivables from a passive report into a prioritized action list. It reduces days-to-collect by making ownership explicit, deadlines short, and follow-up visible. If the practice keeps the audit simple and enforces the triage rules, the weekly rhythm will expose bottlenecks early — claims that need rework, accounts that need escalation, and collectors that need support.