Aged Claims Report (GB106)
Use the Aged Claims report to understand how long outstanding carrier or patient balances have been unpaid. The report analyzes billing transactions to categorize unpaid balances by age from the service date (30, 60, 90, 120, and 150+ days).
The report only includes claims with outstanding balances that have valid service dates. It excludes claims that are fully paid, have prepaid carriers, and/or have service dates that are in the future or are otherwise beyond the cutoff dates selected for the report.
Understanding the Report Filters
Use the report filters to control the data shown on the report. Filter conditions are combined using AND logic, which means a claim must meet every setting you select to be included.
For example, selecting VSP from the Select Carrier list and an office number from the Select Location list will generate a report that shows only VSP claims originated by that office. Claims for other carriers from that office, as well as VSP claims originated by other offices will be excluded.
Selecting Data to Include on the Report
Use the report filters to select the Carrier, Plan, Location(s), Patient, method to calculate the Total By, and Aging Type (Carrier or Patient), along with the billing month or date ranges to include on the report.
When you select a carrier, the report will print information for all claims associated with that carrier. If you do not select a carrier, and leave the field blank, the report will be generated for all carriers.
If you selected a carrier: the Select Plan drop-down list shows only plans associated with that carrier. If you do not select a plan, and leave the field blank, the report will be generated for all the carrier's plans.
If you did not select a carrier: the Select Plan drop-down list shows all the plans in your system, for all carriers. Leave the field blank to generate the report for all plans. If you select a plan from the list, the Select Carrier field automatically updates with the associated carrier.
All offices in your company are listed in the Select Location drop-down list and are selected by default. Deselect any offices you do not want to include on the report.
When you select a patient, the report will print information for claims associated with that patient. If you leave the field blank, the report will include all patients with claims that match the other filter criteria.
Select how you want to view the report totals.
- By Location By Carrier: Shows outstanding balances listed by carrier and grouped by office.
- By Carrier: Shows outstanding balances listed by carrier.
- By Claim: Shows outstanding balances listed by claim.
To filter what types of claims are included in the report, select one of the following options from the Select Aging Type drop-down list:
- All: Includes all claims with carrier and patient outstanding balances
- Carrier Only: Includes claims with outstanding carrier balances only (Ready to Bill or Billed status).
- Patient Only: Includes claims with outstanding patient balances only (Ready to Bill Patient or Billed to Patient status).
To set a specific time frame for the report, select one of the following options.
Select Dates
Select this option to enter date ranges to print. Allows you to select dates from the Cut Off Date, Last Deposit Date, and From/To Service Date fields.
-
Cut Off Date: Transactions completed up to this date are included on the report. Transactions after this date are excluded. This field defaults to the current date.
-
Last Deposit Date: Deposits made up to this date are included on the report. Deposits after this date are excluded. This field defaults to the current date. ERA payments are included only if they have posted.
-
From Service Date: Claims with service dates on or after the date you enter are included on the report. Leave this field blank to include all claims in your claim history (no start date filter).
-
To Service Date: Claims with Service Dates up to this date are included on the report. Claims with Service Dates after this date are excluded. This field defaults to the current date.
Billing Month
Allows you to select a billing month. This field defaults to the current month but you can change it.
The way the Billing Month filter is applied depends on the available Month Close data that is available:
-
If Month Close data is available for both the selected month and the prior month, the range is set from the prior month's close date to the selected month's close date, and only transactions linked to the selected month’s close are included. The CloseId will be for the selected month.
Example: August is selected for Billing Month. July’s Month Close was run on August 2. August’s Month Close was run on September 2. The From Transaction Date will be set to August 2 and the To Transaction Date will be set to September 2. CloseId will be for August.
-
If either Month Close is missing, the range is set to the selected calendar month, and the CloseID is not considered.
Example: August is selected for Billing Month. No month close was run for August. From Transaction Date will be set to August 1 and the To Transaction Date will be set to August 31.
Report Layout
The report appears differently depending on the selected criteria, but the following columns remain consistent.
| Column | Description |
|---|---|
|
Total |
The total unpaid amount. |
|
Current |
The unpaid amount for services dated within the last 30 days. |
|
30 Days |
The unpaid amount that is 30 days past due. |
|
60 Days |
The unpaid amount that is 60 days past due. |
|
90 Days |
The unpaid amount that is 90 days past due. |
|
120 Days |
The unpaid amount that is 120 days past due. |
|
150+ Days |
The unpaid amount that is over 150 days past due. |