Practice Reporting. Prepared for Rowan Bexley on Oct 7, 2026. Whole organization.
May 2026 · prove it
Days in A/R, practice total
How many days of charges are sitting unpaid?
How the number is made
Definition version 1, in force since Aug 3, 2025.
- Formula
- Total open A/R at close of business on the last day of the month, divided by average daily charges over the 30 days ending that day.
- Open A/R (dollars)
- $301,773.97
- Average daily charges, last 30 days (dollars)
- $6,500.00
- Result
- 46.4 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
- 46.4 days
- Difference (ours minus athena)
- None
- Tolerance
- Up to 0.5 days either way
- Evidence
- Open the athena report athena-2026-05-ar-aging-summary (sample), sample report, opens in a new tab
- Checked
- Jun 4, 2026, 10:00 AM EDT by Rowan Bexley
- Why they differ
- No explanation needed: the figures match or sit inside the tolerance.
Published figure and restated figure
The definition changed after May 2026 was published. To compare months like for like, the same data is also worked out on version 2. The published figure is the record and never changes.
- Published, version 1
- 46.4 days$301,773.97 over $6,500.00
- Restated, version 2
- 43.4 days$301,773.97 over $6,958.22. Used only for comparisons and trends; never published.
The run behind it
- Source
- Demo data
- Pulled from athena
- Jun 3, 2026, 6:00 AM EDT
- Records counted
- 43,021 claims, 1,363 appointments
- Internal checks
- All 11 passed
For your IT team
rpt-pipeline 1.1.0.