Aging Report shows difference between Claimed Amount and Paid Amount for all submitted claims (within a given date range) and received Remittance.Advice transactions divided by date ranges. It can be used to:
- determine which claims are overdue for payment;
- cross check other reports or reports generated by other systems to make sure data is consistent across all data sources.
Aging Report for Providers
The report contains the single worksheet: Aging Report.
The table below describes the columns presented on this worksheet.
Column | Description |
|---|---|
| Receiver | License number of an insurance company or TPA that is the receiver of Claim.Submission transaction. |
<=30 | The header shows the number of days from Transaction Date of Claim.Submission transaction and the date when the report is generated on. Cells values calculate as Claimed Amount - Paid Amount for all claims in the specified date range.
|
31-45 | |
46-60 | |
61-90 | |
91-120 | |
120+ |
The report contains duplicates for both Claim.Submission and Remittance.Advice transactions. The report also assumes all resubmissions are corrections as they do not yet have any internal complains resubmissions.
Aging Report for Payers
Aging Report for Payer has the following differences compared to Aging Report for Providers:
- Receiver (Provider?) column shows license number of a facility that is the sender of Claim.Submission transaction.
- If a claim has Remittance.Advice, then a payer considers no further payment is required for this claim. Therefore, pending amount for this claim is 0.00.