This article applies to Motivity Practice Management. It explains how to run and read the Authorization Utilization & Cancellation Report, which shows scheduled, rendered, and canceled hours measured against authorization capacity. You will learn how to set filters, choose columns, understand each calculation, and export your results.
Why This Matters
Understanding whether cancellations are pulling authorization utilization down used to mean cross-referencing several screens. This report brings it all together in one place. It shows how many hours were scheduled, rendered, and canceled for each authorization, along with who canceled and how much notice was given. That makes it easier to spot patients, services, or authorizations that need attention, and to support your utilization management and operational planning.
Who Can Access This Report
The report appears only for users whose access level includes the Authorization Utilization & Cancellation Report permission. With that permission, users can view, filter, run, and export the report. If you don't see it under Patient Reports, ask your administrator to enable the access level for you.
How to Run the Report
Go to Reports > Patient Reports > Authorization Utilization & Cancellation Report.
Enter a Start Date and End Date. Both are required.
Narrow the results with any of the optional filters (see the table below). Every filter defaults to All.
Choose the columns you want to display. All columns are listed in the modal with checkboxes, so you can show only what you need.
Select Preview Report to preview your results, or select Download Report if you would like to export a copy.
Tip: Regenerating the report picks up any changes made to scheduling, rendering, authorization, or cancellation data, so run it again whenever you want the most current picture.
Available Filters
Filter | What It Does |
Start Date and End Date | Sets the reporting period. Required, and listed first. |
Line of Business | Limits results to a specific Line of Business. |
Primary Supervisor | Limits results to patients connected to the selected supervisor. |
State | Limits results by state. |
Patient Location | Limits results by patient location. |
Funding Source | Limits results to a specific funding source. |
Patient Status | Choose All, Active, In Process, or Terminated. |
Understanding the Utilization Columns
These columns appear for each authorization or service row and help you compare planned care with delivered care.
Column | What It Shows |
Auth Max Hours | The authorization's maximum hours. If Max Hours isn't set, the report uses Total Authorized Hours. |
Sched Hrs (All Statuses) | All scheduled hours in the period, across every appointment status. |
Rendered Hrs | Hours in all rendered statuses. |
Hrs in Scheduled Status | Active appointments that are still in Scheduled status. |
Rendered / Sched Hrs % | The share of scheduled hours that were rendered. |
Sched Hrs / Auth Max Hrs % | Attempted utilization: how much of the authorization has been scheduled. |
Rendered / Auth Max Hrs % | Actual utilization: how much of the authorization has been delivered. |
Understanding the Cancellation Columns
These columns explain how much was canceled, why, and with how much notice.
Column | What It Shows |
Canceled Hrs | Total canceled hours, including Late Cancels and all reason types. |
Canceled / Sched Hrs % | The share of scheduled hours that were canceled. |
Patient Canceled / Sched Hrs % | The share of scheduled hours canceled by the patient side. |
Canceled Hrs - <24 Hr Notice | Hours canceled with less than 24 hours of notice. |
Canceled Hrs - ≥24 Hr Notice | Hours canceled with 24 hours of notice or more. |
Late Cancellation | Hours canceled using the Late Cancel option. |
Canceled Hrs by reason | Separate columns for Provider, Patient, Admin, Supervisor, and Other. |
A built-in reference sheet in the report also defines each of the calculated fields, so you can check a definition at any time.
How the Report Calculates Results
Knowing a few of the report's rules will help you read the numbers with confidence.
Which authorizations appear. An authorization is included when its Start Date or End Date falls within your selected date range.
Hours are limited to your date range. Only hours inside the range are counted, even for an authorization that started earlier or ends later. This applies to every percentage as well.
Percentages use Sched Hrs (All Statuses) as the denominator. The report does not use Hrs in Scheduled Status for this calculation.
Cancellations are never double-counted. Each canceled hour falls into exactly one reason category and exactly one notice-window category. The reason columns add up to Canceled Hrs. Late Cancels count as canceled hours, and they also appear in their own Late Cancellation column.
Blank and zero values.
If Sched Hrs is zero or unavailable, the three percentage columns that depend on it are blank.
If there are scheduled hours but no cancellations, Canceled Hrs shows 0 and Canceled / Sched Hrs % shows 0%.
If Auth Max Hours isn't set on the authorization, the Auth Max Hours column and both Auth Max percentage columns stay blank.
Utilization is informational only. The report is not a determination of authorization exhaustion or clinical necessity.
Primary Supervisor Filter and Column
Filter: The Primary Supervisor filter lists all providers. A patient's authorizations are included when the selected provider matches the patient's Active Provider. For Multi-Line of Business clients, they are included when the selected provider matches any of the patient's Primary Supervisors.
Column: The Primary Supervisor column shows the supervisor assigned to the service's Line of Business. For multi-LOB patients, it shows the supervisor for the Line of Business the appointment is connected to.
Exporting the Report
The export contains the same data and column names as the on-screen report. A single-service authorization shows as one row. For a multi-service authorization, the hours, percentage, and cancellation columns are merged across its rows.
Historical Data
No migration is needed. Past authorizations and appointments appear automatically for any date range you choose. Keep in mind:
Historical cancellations that are missing a reason are counted under Other.
Cancellations that are missing a timestamp are left out of the notice-window columns (<24 Hr and ≥24 Hr).
Tips for Getting the Most From This Report
Compare Sched Hrs / Auth Max Hrs % with Rendered / Auth Max Hrs % to see the gap between planned and delivered care.
Use the reason columns to see whether cancellations come from the patient side or from internal causes.
Review the Late Cancellation column alongside the notice-window columns to find cancellations that came with short notice.
Quick Reference
What You Want to Know | Where to Look |
How much of an authorization has been scheduled | Sched Hrs / Auth Max Hrs % |
How much of an authorization has actually been delivered | Rendered / Auth Max Hrs % |
How much was canceled overall | Canceled Hrs and Canceled / Sched Hrs % |
Who canceled | Canceled Hrs for Provider, Patient, Admin, Supervisor, and Other |
How much notice was given | Canceled Hrs - <24 Hr Notice and ≥24 Hr Notice |
Cancellations made with the Late Cancel option | Late Cancellation |
What a calculated field means | The built-in reference sheet |
Last Updated: 11/12/26 by Tatum Winslow
