Overview
Purpose
This report analyzes payments for the previous 12 accounting periods as they relate to the charges' dates of service. Presents the user with payment details over a 12 month rolling accounting period, displaying the date of service (months) in which the payments are posted.
Contains a mix of DOS information, as it relates to case count, charges, adjustments, and total payments, as well as accounting date information, as it relates to posted payments.
Category
Financial
Type
Summary
Mode
Accounting
Output Options
CSV or Excel
Sample Report
(Click the image to enlarge)
Field Definitions
Field | Calculation Formula | Description |
|---|---|---|
| Month (DOS) | Horizontal listing by month of the previous 12 months, including a 'Prior' to capture all payments outside of prior 12 months. | |
| Case Count | Number of cases performed for the DOS (month). | |
| Charges | Original Fee + Reversed Amount | Total Charges billed for the DOS (month). |
| Payment Distribution (Accounting Date) | One column for each accounting month (previous 12 months), plus one column for Prior. | |
| Payments | Payments Distributed + Payment Reversals + Suspense + Refunds | Total payments applied to DOS (month). |
| Adjustments | Contractual Writeoff + Withhold + Adjustments + External Collections | Total adjustments (CWO, Withhold, Miscellaneous Adjustments, External Collection Adjustments) for the selected DOS month. |
| Balance | Remaining balance for the DOS month. |
Available Report Filters
Field | Type | Additional Information |
|---|---|---|
| Accounting End Date | Free Text | Accounting Date associated to Payments |
| Practice | Drop Down | |
| Provider | Drop Down | |
| Facility | Drop Down | |
| Payer | Drop Down | |
| Plan | Drop Down |