Practice Reporting. Prepared for Rowan Bexley on Oct 7, 2026. Whole organization.
October 2025 · prove it
A/R aging, 61 to 90 days
$26,964.21MatchedReconciled with athena
How old is the money we are owed?
How the number is made
Definition version 1, in force since Aug 3, 2025.
- Formula
- Open balance on each claim at close of business on the last day of the month, grouped by days since the date of service: 0 to 30, 31 to 60, 61 to 90, 91 to 120, over 120.
- Open A/R in the bucket (dollars)
- $26,964.21
- Total open A/R (dollars)
- $296,373.67
- Result
- $26,964.21
- Filters
- All payers including self pay
- Every claim with an open balance, whatever its date of service
- Payment reversals and recoupments add back to the balance
- Aged by date of service
- Credit balances excluded
- Scope
- 61 to 90 days
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, aged by date of service
- athena’s figure
- $26,964.21
- Difference (ours minus athena)
- None
- Tolerance
- Up to $100.00 either way
- Evidence
- Open the athena report athena-2025-10-ar-aging-detail (sample), sample report, opens in a new tab
- Checked
- Nov 4, 2025, 9:00 AM EST 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
- Nov 3, 2025, 5:00 AM EST
- Records counted
- 43,095 claims, 1,521 appointments
- Internal checks
- All 11 passed
For your IT team
Software version
rpt-pipeline 1.1.0.Open question on this definition
athena can age by date of service or by claim creation date. This definition ages by date of service. Confirm the setting on the practice’s report.