Claim Submissions Summary Report (Excel)
- Katerina
Claim Submissions Summary Report shows the summary of all submitted claims, resubmitted claims and their respective remittances.
Data is grouped by months using using Encounter Date from the respective transaction. The report contains the only worksheet: Claim Submissions Summary.
The table below describes the columns presented on this worksheet.
| Column | Description |
|---|---|---|
| Claim ID |
|
Initial Claim Submissions | Claimed Amount | Sum of all Activity.Net of the initial claim submissions (without Resubmission). |
Paid Amount | Sum of all Activity.PaymentAmount of the respective claims that are part of the Claimed Amount calculation. | |
Rejected Amount | Denied amount of the respective claims that are part of the Claimed Amount calculation. | |
Unremitted Amount | =Claimed Amount-Paid Amount-Rejected Amount. | |
Claim Resubmissions | Claimed Amount | Sum of all Activity.Net of the resubmitted claims. |
Paid Amount | Sum of all Activity.PaymentAmount of the respective resubmitted claims that are part of the resubmitted Claimed Amount calculation. | |
Unremitted Amount | This is the Claimed Amount of those resubmitted claims that have no Remittance.Advice yet. | |
Totals | Claimed Amount | Claimed Amount of the claims considering initial claim submission and all resubmissions. |
Paid Amount | = Initial Claims Paid Amount + Resubmitted Claims Paid Amount. | |
Unremitted Amount | = Initial Claims Unremitted Amount + Resubmitted Claims Unremitted Amount. |