Overview
Purpose
This report analyzes overall performance of the practice by comparing case count and units, payments versus charges billed, and percentage collected versus expected amount.
Category
Financial
Type
Summary
Mode
Accounting
Output Options
CSV or Excel
Sample Reports
(Click an image to enlarge)
Portal
Back Office
Field Definitions
Field | Calculation Formula | Description |
---|---|---|
Payer | The primary insurance payer on the case with financial responsibility for the outstanding debt. | |
Case Count | The number of cases in the period for which the payer is responsible. | |
Case Mix % | The percentage of total for which the payer is responsible. | |
Billed | The total amount billed to the payer. | |
Expected | The total amount expected to be paid on the case. | |
Payments | The sum of payments received from the payer. | |
Refunds | The total amount of refunds, or payments reversed, and posted from the account for the specified date range. | |
Base Units | The number of base units for each procedure on the case. | |
Physical Status Units | The number of physical units for each procedure on the case. | |
Time Units | The number of time units for each procedure on the case. | |
Total Units | The sum of all units for which the payer is responsible. | |
Gross Collection % | (Payments – Refunds) / Billed Charges | The percentage of gross receivables. |
Net Collection % | (Payments Distributed + Payment Reversals + Suspense - Refunds) / [(Original Fee + Reversed Amount) – Contractual Writeoff] | The percentage of net receivables. |
Collected Percentage of Billed | The percentage of the amount billed that has been collected from the payer. | |
Collected Percentage of Expected | The percentage of the expected amount that has been collection from the payer. | |
Payment Lag Days | The number of days from the time the case is billed to the time the payer remits payment on the cases. |
Available Report Filters
Option | Type | Required | Description |
---|---|---|---|
Date | Drop Down | Yes | Filters transactions displayed by the selected time period. Options include: Custom Date Range, Last # of Days, Today, Previous Day, Current Month, Previous Month, Current Year, and Previous Year. If Custom Date Range is selected, the From and To fields are enabled to enter specific dates to run the query on. If Last # of Days is selected, the Last # of Days field is enabled to enter a specific number of days to run the query on. The maximum timespan for the report is 31 days. |
Practices | List Selection | No | Filters by all practices or one or more practices. By default, this filter is set to All. Only active practices are returned in the search results. |
Facilities | List Selection | No | Filters by all facilities or one or more facilities. By default, this filter is set to All. |
Financial Classes | List Selection | No | Filters by all financial classes or by one or more financial classes. |
Report Folder | Drop Down | Yes | Designates where to place or save the output from the executed report. |