Claim Submissions Details (Excel)
- Katerina
Claim Submissions Details shows claims that are part of the calculated value on Claim Submissions Summary Report clicked by the user.
Data is grouped by claim using using Claim ID from the respective transaction. The report contains the only worksheet: Claim Submission Details.
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. |