Analytics
Aging reports
Aging groups unpaid balances by how long they have been outstanding. ArkCloud recalculates every account's aging bucket nightly; some screens use that bucket and others work out the age when you open them, so totals can differ between screens.
Written for: Revenue cycle managers · Billing staff · Finance
How buckets are assigned
Each account is placed in one of five buckets - 0-30, 31-60, 61-90, 91-120 and 121+ days - by a background job that runs at 02:00 every night, counting from the account's creation date. A bucket shown during the day is therefore as of last night. The Analytics Dashboard and the Aging Summary report use this bucket.
Where to see aging
| Field or control | What it means |
|---|---|
| A/R aging (/dashboard/ar/aging) | Patient account balances in five buckets as of a date you choose, with filters for account type, minimum balance and account status, total and balance-weighted average days, and the accounts behind each bucket. Age is counted from the service date, else the first charge, else the account's creation. Exports CSV (up to 500 accounts per bucket). It does not estimate expected collections. Supervisor and above; exporting also needs the export permission. Not in the sidebar - open it from the link on the AR Reports screen or by its address. |
| Insurance aging (Insurance → Aging) | Outstanding claim balances by payer and bucket, aged when you open the screen from the claim's submission date (else its service date), with a payer filter and a CSV export built in your browser. Needs permission to view accounts (Agent and above). |
| Executive dashboard → A/R Aging Distribution | Open balances in seven buckets (0-30 up to 181+), aged from each account's creation date when the page loads, with current, at-risk and critical shares. |
| Patient aging (Analytics Dashboard → Performance and Portfolio) | Account balances by aging bucket, and the count of accounts over 120 days. |
| Aging summary report (Reports) | Current balances by bucket, with the accounts behind each row, as a downloadable report - see reports for who can run it. |
Sidebar → Insurance → Aging
Measures that go with aging
Days in A/R and collection rates are defined once for every screen - see KPI definitions. ArkCloud does not hold target values for aging; any target distribution is your own policy. Commonly cited guidance is that most A/R should sit in the 0-30 bucket and only a small share above 120 days, but the right figures depend on your payer and patient mix.