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 (current, 1 month old, 2 months old, etc.).
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 transaction must meet every setting you select to be included.
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 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.
When you select a specific carrier, the plan will have those specific plans, the report will print information for that plan associated with that carrier. If you do not select a plan, and leave the field blank, the report will be generated for all plans.
When you select a location / office, the report will print information for claims associated with that office. If you select All Locations Selected, the report will print information for all offices.
When you select a patient, the report will print information for patient claims associated with that office. If there is no selection, the report will print information for all patients.
With the Total By drop-down list, you can view the report totals by:
- Location and carrier (which creates a summary report)
- Carrier
- 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
- Carrier Only: Includes claims with a Ready to Bill or Billed status.
- Patient Only: Includes claims with a Ready to Bill Patient or Billed to Patient status. (The balance moves from Carrier to Patient when the status changes to Ready to Bill Patient.)
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 and Last Deposit Date fields.
Billing Month
Allows you to select a billing month.
- For practices using general ledger (GL), the billing month is the period starting with the date the previous month was closed and ending on the date the current month was closed. (The current month is the month for which you want to generate the report.)
- For practices not using GL, the billing month is the calendar month.
Report Layout
The following information is provided in the report.
| Column | Description |
|---|---|
|
Total |
The total amount owed. |
|
Current |
The current amount owed. |
|
30 Days |
The amount owed that is 30 days past due. |
|
60 Days |
The amount owed that is 60 days past due. |
|
90 Days |
The amount owed that is 90 days past due. |
|
120 Days |
The amount owed that is 120 days past due. |
|
150+ Days |
The amount owed that is over 150 days past due. |