Practice Reporting. Prepared for Rowan Bexley on Oct 6, 2026. Whole organization.
August 2026 · prove it
Days in A/R, practice total
43.6 daysMatchedReconciled with athena
How many days of charges are sitting unpaid?
How the number is made
Definition version 2, in force since Aug 7, 2026.
- Formula
- Total open A/R at close of business on the last day of the month, divided by average daily charges over the 90 days ending that day.
- Open A/R (dollars)
- $304,245.25
- Average daily charges, last 90 days (dollars)
- $6,981.17
- Result
- 43.6 days
- Filters
- All payers including self pay
- All providers
- Every claim with an open balance, whatever its date of service
- Payment reversals and recoupments add back to the balance
- Credit balances excluded
- Scope
- Practice total
Checked against athena
The athena report to run, what it showed, and how far apart the two are.
- athena report
- athenaOne Accounts Receivable Aging report (Financials), run for the same practice and as-of date, with the days in A/R figure from its summary
- athena’s figure
- 43.6 days
- Difference (ours minus athena)
- None
- Tolerance
- Up to 0.5 days either way
- Evidence
- Open the athena report athena-2026-08-ar-aging-summary (sample), sample report, opens in a new tab
- Checked
- Sep 4, 2026, 10:00 AM EDT by Rowan Bexley
- Why they differ
- No explanation needed: the figures match or sit inside the tolerance.
The run behind it
- Source
- Demo data
- Pulled from athena
- Sep 3, 2026, 6:00 AM EDT
- Records counted
- 42,994 claims, 1,379 appointments
- Internal checks
- All 11 passed
For your IT team
Software version
rpt-pipeline 1.1.0.Other days in A/R numbers this month
Open question on this definition
Days in A/R has several common formulas (30, 90 or 180 day charge windows; gross or net charges). Version 2 uses 90 days of gross charges. Confirm which one the practice’s own athena report uses before the first real reconciliation.