Reading the aging report

Aged billables = billables submitted >30 days ago and still unpaid. Here's how to read the report and what to do about aged items.

Updated 2026-04-24 · Edit this page on GitHub

title: "Reading the aging report" description: "Aged billables = billables submitted >30 days ago and still unpaid. Here's how to read the report and what to do about aged items." order: 2 category: "billables" updated_at: "2026-04-24"

Aging is the leading indicator for cash-flow issues. If your aging bucket grows faster than your paid bucket, something is stuck at the payer or the clearinghouse.

How Rounds defines aging

A billable is aged when:

  • status = 'submitted' (not yet paid, denied, or voided)
  • AND submitted_at is older than 30 days

The 30-day threshold matches the typical clean-claim payer turnaround; anything older is an exception worth investigating.

Where you see it

  • Billables page → aging report tab → bucketed list (31-60 / 61-90 / 91-120 / 120+ days) with total charges per bucket
  • Insights dashboard → YTD Billables panel → aging KPI card with the dollar total
  • CSV export → include the aging column for external reporting

Typical workflow

  1. Weekly review. Filter to 61-90 day bucket first — those are still within most payer appeal windows but demand attention.
  2. 120+ day bucket — likely write-offs. Investigate why they sat that long; often it's a denial that wasn't status-changed in Rounds even though the payer sent the denial.
  3. Compare provider-level aging. One provider with a spike in aging often means their modifier codes aren't matching the payer's rules.
  4. Per-payer aging — if one payer shows consistently older aging, it's time for a clearinghouse review (or a payer-contract renegotiation).

Filtering

Use the FilterBar at the top of the Billables page:

  • Provider — narrow to a single provider
  • Payer — narrow to a single payer label
  • Date range — custom start/end for reports covering specific periods

All filters chain — provider=Smith AND payer=BCBS AND submitted_at in Q1 2026.

CSV export

Click "Export CSV" on the aging report. Columns include:

  • billable_id, submitted_at, days_aging, provider, payer, cpt_code, charge_amount, status, notes

Max 10,000 rows per export (the v1 cap). For larger pulls, use the REST API — see MCP + REST overview.

If you hit a problem

  • Aging total doesn't match your EHR: Rounds only sees billables you've submitted to it; start by confirming counts match between systems
  • Aging shows $0 but you know you have aged items: check that the filters aren't excluding them; clear all filters + reload
  • Other: support@ralthealth.com