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
Option | Type | Description |
|---|---|---|
| Accounting End Date | Free Text | Filters by the specified date for the ending period. Accounting Date associated to Payments. |
| Practice | List Selection | Filters by all practices or one or more practices for which charges were billed. By default, this filter is set to All Practices. |
| Provider | List Selection | Filters by all providers or by one or more providers for which transactions were posted. By default, this filter is set to All. |
| Facility | List Selection | Filters by all facilities or by one or more facilities for which transactions were posted. By default, this filter is set to All Facilities. |
| Payer | List Selection | |
| Plan | List Selection |