The Aging Summary Report shows your outstanding client and insurance balances rolled up into one row per client, clinician, insurance, or service location. It uses the same aging buckets as the Aging by Service Date Report, without the encounter-level detail.
The Aging by Service Date Report lists every charge with an open balance. That’s the right view when you need to work a specific claim. But when your practice has a lot of charges, finding the answer to a bigger question means scrolling through pages of detail or exporting the data first. For example:
The Aging Summary Report answers these at a glance. Some common ways billers use it:
Tip: Start with the Aging Summary Report to find where the problem is. Then use the Aging by Service Date Report to see the individual charges behind it.
To access the Aging Summary Report:
Note: Access to this report is controlled by the permission Access the Aging Summary Report. Administrator roles have this permission by default. If you don’t see the report, ask your administrator to turn on the permission for your role.
By default, the report includes Start Date and End Date filters. The report filters results based on the encounter date. The Start Date defaults to the first day of the current month, and the End Date defaults to the current date.
Additional filters are available in the expandable filters section. Select Filters to show them.
All filters other than Start Date, End Date, Responsibility, and Summarize By default to -- (All).
After selecting the filter options you want, select Run Report. The report is generated and displayed as shown in the screenshot below. A description of each column follows the screenshot.
When you run or export the report, it includes the following columns:
In the example below, the report is summarized by Clinician. The clinician name appears on the far left followed by the aging bucket columns, Subtotal, and Grand Total.
When you summarize by Client, each row shows the client’s name, DOB, Chart ID, and Unapplied Payments, so you can see a client’s open balance alongside any payments not yet applied.
When you summarize by Location, the name appears on the far left, and the rest of the row follows the same layout.
What’s the difference between the Aging Summary Report and the Aging by Service Date Report?
The Aging by Service Date Report lists every charge with an outstanding balance, including claim numbers, denial codes, and billing notes. The Aging Summary Report rolls those balances up into one row per client, clinician, insurance, or location. Use the summary to find where balances are aging. Use the detail report to work the individual charges.
How does the report calculate the aging of outstanding balances?
The report categorizes outstanding client and insurance balances into aging periods based on the service date: 0–30, 31–60, 61–90, 91–120, 121–150, 151–180, and more than 180 days.
What’s the difference between the Start Date and End Date filters and the aging periods?
The Start Date and End Date filters determine which encounters are included in the report, based on the encounter date. The aging periods categorize outstanding balances based on the service date.
Can I summarize the report by more than one field at a time?
No. Summarize By supports one selection at a time: Insurance, Location, Clinician, or Client. To combine groupings such as Payer, Service Location, and Clinician, use the Group By filter in the Aging by Service Date Report.
How can I find clients with a balance above a certain amount?
Set Summarize By to Client, then review the Subtotal and Grand Total columns. To narrow the list to clients who currently owe a balance, set the Client Balance filter to > 0.
Can I find clients or payers with a zero or negative balance?
Yes. Use the Client Balance or Insurance Balance filter and select 0 or < 0. Negative balances are uncommon, but they can occur, for example when a payment exceeds the amount owed.
Can I view client and insurance balances separately?
Yes. Use the Responsibility filter to select All, Client, or Insurance. When you select Client or Insurance, the total appears in the far-right column, labeled Client Total or Insurance Total.
Can I filter insurance balances by payer order?
Yes. Use the Insurance Ranking filter to view charges associated with Primary, Secondary, Tertiary, or Other payers.
Do expected copays appear in the client aging totals?
No. Expected copays don’t appear as client aging until the insurance company processes the claim and establishes formal client responsibility. Until then, charges pending insurance adjudication remain under insurance responsibility.
Can I export the Aging Summary Report?
Yes. You can export the report in CSV, PDF, or Excel format. The export reflects the Summarize By selection and filters currently applied on screen.
Why can’t I see the Aging Summary Report?
The report requires the permission Access the Aging Summary Report. Ask your administrator to turn it on for your role.