Description
The D1 report captures insurance-wise A/R with aging buckets. The report can also be filtered to display the A/R based on the contract amount (expected fee) instead of the gross values.
Significance
The purpose of the summary-Insurance Aging Report is to follow up on outstanding insurance balances. Items on the report are aged based on the date the claim was generated for the insurance plan (includes primary, secondary, and tertiary insurances). You can run this report in two ways: A. Based on the actual remaining amount or B. Based on the contract amount: If you have contracted rates set up under the fee schedule, you can run using the contracted amount to see the expected receivables.
Search Filters for the D1 Report
| Field | Description |
| LE | Legal entity or the billing entity |
| Insurance | Show results specific to an insurance |
| As per contract Amount | If results are to be shown as per contract amounts in the fee schedule (Expected receivables). |
| Oldest Aging Bucket | Select either 120, 150 or 180 |
| INS level | Insurance level(P/S/T) |
D1 Search Screen
Aging Summary Tab of the D1 report
Note: The “Estimated payment” column in Image 2 is calculated based on the allowed amount from the Fee Schedule.
A/R Aging Bucket Tab
Possible Outputs of D1 Report
| Output | Download and View Sample |
| Aging Summary Excel |  |
| A/R Aging Bucket Excel | |