Aging Report (Excel)
- vickyp
- Katerina
Aging Report shows difference between Claimed Amount and Paid Amount for all submitted claims and received Remittance.Advice transactions. 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 only worksheet: Aging Report.
The report consists of the following sections:
- Initial Claim Submissions;
- Claim Resubmissions;
- Totals.
The table below describes the columns presented on this worksheet (all 3 sections will have same structure).
Column | Description |
|---|---|
| Payer | License number of an insurance company or TPA that is the receiver of Claim.Submission transaction. |
| 0 - 7 | 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.
|
| 8 - 14 | |
| 15 - 21 | |
| 22 - 30 | |
31 - 35 | |
36 - 45 | |
46-60 | |
61-90 | |
> 90 | |
Total | Total unremitted amount. |
| Overdue | The unremitted amount for claims submitted or resubmitted 46 days ago or more. |
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:
- 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.