Aging Summary Report

Aging Summary Report

Overview

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.

Why use this report?

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:

  • “Which clients have balances over 90 days old?”
  • “Which payer owes us the most?”
  • “Which clinician’s claims are aging the most?”

The Aging Summary Report answers these at a glance. Some common ways billers use it:

  • Spot clients who’ve reached a balance limit. If your practice reschedules or cancels appointments once a client’s unpaid balance hits a certain amount, summarize by Client to see each client’s total in one row.
  • Find problem payers. Summarize by Insurance to see which payers hold the most aged balances, then follow up on rebilling or appeals.
  • Review aging by clinician or site. Summarize by Clinician or Location to see where aging balances are building up, so you can fix issues at their source.
  • Prepare for collections. Use the Client Balance filter with the aging buckets to identify clients who may need pre-collection notices.

Key Benefits:

  • Faster answers: See totals by client, clinician, insurance, or location without scrolling through individual charges.
  • Same numbers, simpler view: The report uses the same aging buckets (0–30 through >180 days) and the same Client and Insurance responsibility logic as the Aging by Service Date Report.
  • Flexible filtering: Narrow results by responsibility, clinician, client, location, insurance, insurance ranking, and balance amount.
  • Export ready: Export the report in CSV, PDF, or Excel format for further analysis or external reporting.

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.

See Also

  • Aging by Service Date Report: Review aging balances charge by charge, including claim numbers, denial codes, and billing notes. 
  • Working with Reports: Learn how to access reports, manage permissions, and use common features such as search, export, and zoom. 

Step 1: Accessing the Aging Summary Report

To access the Aging Summary Report:

  1. Select More from the left sidebar.
  2. Select Reports.
  3. In the Report dropdown, select 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.

Step 2: Using Report Filters

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.

  • Summarize By: Determines how the report groups and rolls up balances. The report shows one row per selection. The default is Insurance. The available options are:
    • Insurance
    • Location
    • Clinician
    • Client
  • Responsibility: Filters the report by financial responsibility.
    • All: Default view. Displays amounts for both client and insurance responsibilities.
    • Client: Shows only client responsibility amounts. The total appears in the far-right column, labeled Client Total.
    • Insurance: Shows only insurance responsibility amounts. The total appears in the far-right column, labeled Insurance Total.
  • Clinician: Filters the report to show data for a specific clinician.
  • Client: Filters the report to include information for a selected client.
  • Location: Filters results by the practice location where services were provided.
  • Insurance: Filters the report based on the selected insurance provider.
  • Payer Ranking: Filters charges by payer order: Primary, Secondary, Tertiary, or Other.
  • Client Balance: Filters rows by whether the outstanding client balance is equal to zero (0), greater than zero (> 0), or less than zero (< 0).
  • Insurance Balance: Filters rows by whether the outstanding insurance balance is equal to zero (0), greater than zero (> 0), or less than zero (< 0).

All filters other than Start Date, End Date, Responsibility, and Summarize By default to -- (All).



Step 3: Running the Report

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:

  • Insurance / Location / Clinician / Client: The first column shows the group you selected in Summarize By. What it displays depends on that selection:
    • Insurance: Payer name and phone number.
    • Location: Service location name.
    • Clinician: Clinician name.
    • Client: Client name, date of birth (DOB), Chart ID, and Unapplied Payments.
  • 0-30 Days: The client and insurance balances in this column have been outstanding from 0 to 30 days (based on the service date).
  • 31-60 Days: The client and insurance balances in this column have been outstanding from 31 to 60 days (based on the service date).
  • 61-90 Days: The client and insurance balances in this column have been outstanding from 61 to 90 days (based on the service date).
  • 91-120 Days: The client and insurance balances in this column have been outstanding from 91 to 120 days (based on the service date).
  • 121-150 Days: The client and insurance balances in this column have been outstanding from 121 to 150 days (based on the service date).
  • 151-180 Days: The client and insurance balances in this column have been outstanding from 151 to 180 days (based on the service date).
  • >180 Days: The client and insurance balances in this column have been outstanding for more than 180 days (based on the service date).
  • Subtotal: The sum of all aging buckets for the group, shown separately for Client and Insurance.
  • Grand Total: The combined Client and Insurance total across all aging buckets for the group. A Grand Total row at the bottom of the report totals all groups. When Responsibility is set to Client or Insurance, this column is labeled Client Total or Insurance Total.

Report Appearance

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.



FAQs

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.


Need Help?

For further assistance, contact:
📞 Phone: 443-203-5857
📱 Text: 866-301-0085
📧 Email: ticket@icanotes.com
💬 Chat: https://app.icanotes.com



Proprietary Notice Information: This article is provided for informational purposes only, and the information herein is subject to change without notice. While every effort has been made to ensure that the information contained within this article is accurate, ICANotes cannot and does not accept any type of liability for errors in, or omissions arising from the use of this information.