Skip to main content

How to Use the Authorization Utilization & Cancellation Report (Motivity Practice Management)

Learn how to run and read the Authorization Utilization & Cancellation Report, which compares scheduled, rendered, and canceled hours to authorization capacity.

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

  1. Go to Reports > Patient Reports > Authorization Utilization & Cancellation Report.

  2. Enter a Start Date and End Date. Both are required.

  3. Narrow the results with any of the optional filters (see the table below). Every filter defaults to All.

  4. Choose the columns you want to display. All columns are listed in the modal with checkboxes, so you can show only what you need.

  5. 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

Did this answer your question?