With the 5.42 release, there has been updates to the metrics used in Analytics Dashboard and Scorecards.
Sl. No | Metric Name | Existing Logic | Update in Logic |
1 | Cancellation Rate | Percentage of appointments (by appointment date) that were canceled out of all booked appointments in the selected date range. This was based on the duration of the appointment. | Based on number of appointments |
2 | No Show Rate | Percentage of appointments marked as ‘No Show’ out of all booked appointments, based on appointment date. This was based on the duration of the appointment. | Based on number of appointments |
3 | Rescheduled Appointments Rate | Percentage of appointments that were rescheduled out of all scheduled appointments. This was based on the duration of the appointment. | Based on number of appointments |
4 | Scheduled Patients | Number of patients with scheduled appointments in the selected date range, excluding no-shows, deletions, cancellations, & reschedules. | This metric is now distinct by date. Since this is distinct by date, the sum of this metric for individual locations/providers might not match with the metric value for all locations/providers. |
5 | Gross Collection (TXN) | Total money received from patient, insurance, and collection agency payments based on transaction date, excluding virtual credits and adjustments. Excludes: Receipts of type Income Reduction, Special Credits, Transfer, Membership Credits. | Excludes transaction charges as well |
6 | Gross Insurance Collection (TXN) | Total money received from insurance payments based on transaction date, excluding virtual credits and adjustments. Excludes: Receipts of type Transfer | Excludes transaction charges as well |
7 | Gross Patient Collection (TXN) | Total money received from patient, and collection agency payments based on transaction date, excluding virtual credits and adjustments. Excludes: Receipts of type Income Reduction, Special Credits, Transfer, Membership Credits. | Excludes transaction charges as well |
8 | Net Collection (Payment Date) | Total money received from patient, insurance, and collection agency payments based on payment date, excluding virtual credits after adjustments, refunds and transfers. Excludes: Receipts of type Income Reduction, Special Credits, Membership Credits, and Transaction Charges amount. | Calculates refund by refund date and collection adjustment by DOS. |
9 | Net Collection (TXN) | Total money received from patient, insurance, and collection agency payments based on transaction date, including adjustments and refunds. Excludes: Receipts of type Income Reduction, Special Credits. | Excludes transaction charges as well |
10 | Net Insurance Collection (Payment Date) | Total money received from insurance, and capitation payments based on payment date, excluding virtual credits after adjustments, refunds, membership credits and transfers. Excludes: Transaction Charges amount | Calculates refund by refund date and collection adjustment by DOS. |
11 | Net Insurance Collection (TXN) | Total money received from insurance, and capitation payments based on transaction date, including adjustments and refunds. Excludes: Receipts of type Income Reduction, Special Credits, and Transaction Charges amount. | Excludes transaction charges as well |
12 | Net Patient Collection (Payment Date) | Total money received from patient, and collection agency payments based on payment date, excluding virtual credits after adjustments, refunds and transfers. Excludes: Receipts of type Income Reduction, Special Credits, Membership Credits, and Transaction Charges amount. | Calculates refund by refund date and collection adjustment by DOS. |
13 | Net Patient Collection (TXN) | Total money received from patient, and collection agency payments based on transaction date, including adjustments and refunds. Excludes: Receipts of type Income Reduction, Special Credits, and Transaction Charges amount. | Excludes transaction charges as well |
14 | Patient Collection Rate (TXN) | Percentage of patient collection relative to net patient production, based on transaction date. | Uses the updated definition for net patient collection (TXN). |
15 | Collection Adjustment Rate | Percentage of collection adjustments compared to gross collections, based on transaction date. | Uses the updated definition for gross collection (TXN) |
16 | Collection Rate | Percentage of net collections relative to net production, based on transaction date. | Uses the updated definition for gross collection (TXN) |
17 | Insurance Receipt Transfer Rate | Percentage of insurance receipt amounts transferred to patient credit, relative to gross insurance collections in the selected date range. | Uses the updated definition for gross collection (TXN) |
18 | Insurance Collection Rate (TXN) | Percentage of net insurance collections relative to net insurance production, based on transaction date. | Uses the updated definition for gross collection (TXN) |
19 | Patient Visit | Number of patients with code completed in the date range | Number of patients who are considered as part of patient visit as set in settings. This configuration lets you configure patient visits based on treatment completed or appointment checked out. |
20 | New Patient Visit/Day | Average number of new patients visits per day within the selected date range. | Considers only the days on which at least one patient visit occurred. |
21 | Avg Daily Gross Prod (DOS) | The average gross production generated per day. | Considers only the days on which at least one patient visit occurred. |
22 | Avg Gross Prod per Appt (Appt Date) | The average gross production generated from appointments, calculated using production from procedure codes that are directly linked to appointments. | Blank appointments are not considered. |
23 | Avg Net Prod Per Appt (Appt Date) | The average net production generated from appointments, calculated using production from procedure codes that are directly linked to appointments. | Blank appointments are not considered. Based on treatment location, treatment provider. |
24 | Avg Daily Net Prod (DOS) | The average net production generated per day. | Consider only the days on which at least one patient visit occurred. |
25 | Scheduled Production | Total gross production value of procedures linked to appointments scheduled for a given day, frozen at 1:00 AM EST. | Based on treatment provider and treatment location. |