920-436-8299 [email protected]

Revenue Cycle Advisor

Optimize efficiency and maximize cash flow with easy-to-deploy application

More than 100 pre-built KPIs to help assess performance against targets

Your revenue cycle is integral to the financial strength and sustainability of your hospital or health system. It is also critical to your mission to serve your patients and community.

Managing and monitoring it requires a level of vigilance that’s only possible with reliable, well-defined and timely information. That information can help to continuously pinpoint your best opportunities to improve processes, stay ahead of emerging trends, and maximize cash flow.

But when it’s spread across multiple systems and applications, each with their own reporting and analytics tools, the picture is anything but clear.

Dimensional Insight’s Revenue Cycle Advisor helps you take on that challenge to get the most from all of your available information.

Benefits of Revenue Cycle Advisor

Maximize cash flow

Pinpoint sources of declining or increasing revenue early to help inform optimal business decisions

Collect revenue efficiently

Spot late and missing charge activity patterns in time to take timely corrective action

Minimize denials

Closely monitor patterns in denials by payer to take advantage of opportunities to ensure claims are accepted the first time around
f

Understand value-based measures

Effectively manage value-based care criteria by gaining visibility into integrated revenue cycle, operational, clinical and outcomes KPIs and details

Manage accounts receivable

Gain a comprehensive view of your account-level trial balance to stay on top of emerging trends and important operational KPIs such as unbilled balances and days outstanding

See Revenue Cycle Advisor in action

Learn about the features and functionality of Revenue Cycle Advisor in this 15-minute video.

Examples of Revenue Cycle Advisor dashboards

Revenue Cycle Advisor comes with a variety of off-the-shelf dashboards and reports. There is a consistent look and feel throughout both Revenue Cycle Advisor and the rest of the Dimensional Insight Library of Applications.

Access to industry standard out-of-the-box measures

Revenue Cycle Advisor comes with 100+ out-of-the-box measures that can be quickly implemented in your hospital. These measures include:
Revenue
  • Gross Pat Svcs Rev (K)The total amount of inpatient and outpatient charges, including charge credits, in Charges, in thousands of dollars, by posting date
  • Gross Pat Svcs Rev The total dollar amount of inpatient and outpatient charges, including charge credits, by posting date
  • Gross Pat Svcs Rev (K) by Svc Date The total amount of inpatient and outpatient charges, including inhouse and charge credits, in thousands of dollars, by service date
  • Gross Pat Svcs Rev by Svc Date The total dollar amount of inpatient and outpatient charges, including inhouse and charge credits, by service date
  • Gross Pat Svcs Rev Daily Avg The daily average of gross patient services revenue for the preceding three month period, in dollars, by AR date. The three month daily average is precalculated by AR date. AR dates are typically the last day of a month except for the current month, which uses 90 days instead. They represent a snapshot of outstanding accounts receivable as of that date.
  • Gross Pat Svcs Rev (K) Daily Avg The daily average of gross patient services revenue for the preceding three month period, in thousands of dollars, by AR date (Note: The three month daily average is precomputed in the data set used by this calculation by individual AR date. AR dates are typically the last day of a month except for the current month, which uses 90 days instead.)
  • Gross Pat Svcs Rev Monthly Avg The monthly average of gross patient services revenue dollars, by posting date
  • Gross Pat Svcs Rev (K) Monthly Avg The monthly average of gross patient services revenue, in thousands of dollars, by posting date.
  • Late Charges Amount (K) The absolute value of the total amount of charges posted more than three days after the service date, including charge debits and credits, in thousands of dollars, by posting date. This captures the true value of late charges by including the value of reversals (charge credits).
  • Late Charges Amount The absolute value of the total dollar amount of charges posted more than three days after the service date, including charge debits and credits, by posting date. This captures the true value of late charges by including the value of reversals (charge credits).
  • Late Charges % No Description found for this measure.
  • Late Charges Accounts The number of accounts with at least one late charge, by posting date
  • Late Charges % Gross Charges Late charge dollars as a percentage of the absolute value of total gross charges, including debits and credits, by posting date
  • Charge Lag Days Avg The average number of days for each charge between posting date and service date, excluding charge credits, by posting date.
Revenue Integrity
  • Net Pat Svcs Rev (K)The total of gross patient services revenue, excluding contractual adjustments, in thousands of dollars, by posting date.
  • Net Pat Svcs Rev The total of gross patient services revenue, excluding contractual adjustments, in dollars, by posting date
  • Net Pat Svcs Rev (K) Daily Avg The daily average of net patient services revenue for the preceding three month period, in thousands of dollars, by AR date. The three month daily average is precalculated by AR date. AR dates are typically the last day of a month except for the current month, which uses 90 days instead.
  • Net Pat Svcs Rev Daily Avg The daily average of net patient services revenue for the preceding three month period, in dollars, by AR date. The three month daily average is precalculated by AR date. AR dates are typically the last day of a month except for the current month, which uses 90 days instead. They represent a snapshot of outstanding accounts receivable as of that date.
  • Contractual Adjustments (K) The total amount of contractual adjustments, in thousands of dollars, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Contractual Adjustments The total amount of contractual adjustments, in dollars, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Contractual % Gross Pat Svcs Rev Contractual adjustment dollars as a percentage of gross patient services revenue
Unbilled Balances
  • Unbilled Balance (K) The total unbilled balance, including inhouse, discharged not final billed inpatient, and unbilled outpatient accounts, in thousands of dollars, by AR date
  • Unbilled Balance The total unbilled balance, including inhouse, discharged not final billed inpatient, and unbilled outpatient accounts, in dollars, by AR date.
  • Unbilled Inhouse Balance (K) The total unbilled balance for inpatient accounts that have not been discharged (inhouse), in thousands of dollars, by AR date
  • Unbilled Inhouse Balance The total unbilled balance for inpatient accounts that have not been discharged (inhouse), in dollars, by AR date
  • Unbilled IP DNFB Balance (K) The total unbilled balance for discharged not final billed (DNFB) inpatient accounts, in thousands of dollars, by AR date.
  • Unbilled IP DNFB Balance The total unbilled balance for discharged not final billed (DNFB) inpatient accounts, in dollars, by AR date
  • Unbilled Outpatient Balance (K) The total unbilled balance for outpatient accounts, in thousands of dollars, by AR date
  • Unbilled Outpatient Balance The total unbilled balance for outpatient accounts, in dollars, by AR date.
  • Unbilled Accounts The number of accounts with an unbilled balance, by AR date.
  • Unbilled % Total AR Balance The unbilled balance as a percentage of the overall accounts receivable balance, by AR date.
Financial Management
  • Bad Debt Adjustments (K) The total amount of bad debt adjustments, in thousands of dollars, in Adjustments, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Bad Debt Adjustments The total amount of bad debt adjustments, in dollars, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Bad Debt Adjustment Accounts Bad debt adjustment dollars as a percentage of net patient services revenue, by posting date
  • Bad Debt % Net Pat Svcs Rev The percentage of ED visits with an ESI triage acuity rating of Level 4 (Less Urgent), by arrival date
  • Charity Adjustments (K) The total amount of charity adjustments, in thousands, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Charity Adjustments The total of charity adjustments, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Charity Accounts The number of accounts with at least one charity adjustment, by posting date.
  • Charity % Net Pat Svcs Rev Charity adjustment dollars as a percentage of net patient services revenue.
  • Denial Adjustments (K) The total amount of denial adjustments, in thousands of dollars, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Denial Adjustments The total amount of denial adjustments, in dollars, by posting date. The values retain the negative sign from the source data for adjustments and payments, consistent with standard accounting practices.
  • Denial Adjustment Accounts The number of accounts with at least one denial adjustment, by posting date
  • Denial Adjustments % No Description found for this measure.
  • Denials % Net Pat Svcs Rev Denials adjustment dollars as a percentage of net patient services revenue
Aging – Balances
  • AR Aged Balance (K) The total aged accounts receivable balance, in thousands of dollars, by AR date
  • AR Aged Balance The total aged accounts receivable balance, in dollars, by AR date.
  • AR Aged Balance % The percentage of the aged accounts receivable balance distributed across a selected dimension, such as financial class or aging category, by AR date.
  • AR Insurance Balance (K) The aged accounts receivable insurance balance, in thousands of dollars, by AR date
  • AR Insurance Balance The aged accounts receivable insurance balance, in dollars, by AR date
  • AR Patient Balance (K) The aged accounts receivable balance for which patients are responsible, in thousands of dollars, by AR date.
  • AR Patient Balance The aged accounts receivable balance for which patients are responsible, in dollars, by AR dat
  • AR Total Balance (K) The total accounts receivable balance, including unbilled, aged, and bad debt balances, in thousands of dollars, by AR date
  • AR Total Balance The total accounts receivable balance, including unbilled, aged, and bad debt balances, in dollars, by AR date
Credit Balances
  • AR Credit Balance The aged accounts receivable balance for credit balance accounts, in dollars, by AR date.
  • Credit Balance Accounts The number of accounts in aged accounts receivable with a credit balance, by AR date.
Aging – Ratios
  • Gross Days in AR The ratio of the total accounts receivable balance, including unbilled, aged, and bad debt balances, to average daily gross patient services revenue, by AR date.
  • Net Days in AR The ratio of the total accounts receivable balance, including unbilled, aged, and bad debt balances, to the average daily net patient services revenue, by AR date.
  • Gross Days in DNFB The ratio of the discharged not final billed (DNFB) balance to average daily gross patient services revenue, by AR date.
  • Gross Pat Svcs Rev Daily Avg The daily average of gross patient services revenue for the preceding three month period, in dollars, by AR date. The three month daily average is precalculated by AR date. AR dates are typically the last day of a month except for the current month, which uses 90 days instead. They represent a snapshot of outstanding accounts receivable as of that date.
  • Net Pat Svcs Rev Daily AvgThe daily average of net patient services revenue for the preceding three month period, in dollars, by AR date. The three month daily average is precalculated by AR date. AR dates are typically the last day of a month except for the current month, which uses 90 days instead. They represent a snapshot of outstanding accounts receivable as of that date.
  • AR Bal 90+ D (K) The accounts receivable balance outstanding for more than 90 days, not including bad debt accounts, in thousands of dollars, by AR date
  • AR Bal 90+ D The percentage of the accounts receivable balance outstanding for more than 90 days, not including bad debt accounts, by AR date
  • AR Bal 90+ D % The median elapsed time, in minutes, between arrival to the ED and the first result from a head CT order, by arrival date
  • AR Bal 90+ D Accounts The number of accounts in the accounts receivable balance outstanding for more than 90 days, by AR date.
AR Balance %
  • AR Bal 0-30 D % The percentage of the aged accounts receivable balance outstanding for 30 days or less, by AR date

  • AR Bal 31-60 D % The percentage of the aged accounts receivable balance outstanding for 31 to 60 days, by AR date

  • AR Bal 61-90 D % TThe percentage of the aged accounts receivable balance outstanding for 61 to 90 days, by AR date.

  • AR Bal 91-120 D % The percentage of the aged accounts receivable balance outstanding for 91 to 120 days, by AR date.

  • AR Bal 121-150 D % The percentage of the aged accounts receivable balance outstanding for 121 to 150 days, by AR date.

  • AR Bal 151-180 D % The percentage of the aged accounts receivable balance outstanding for 151 to 180 days, by AR date.

  • AR Bal 180+ D % The percentage of the aged accounts receivable balance outstanding for more than 180 days, by AR date

AR Aging Balance
  • AR Bal 0-30 D (K) The aged accounts receivable balance outstanding for 30 days or less, in thousands of dollars, by AR date.
  • AR Bal 0-30 DThe aged accounts receivable balance outstanding for 30 days or less, in dollars, by AR date.
  • AR Bal 31-60 D (K) The aged accounts receivable balance outstanding for 31 to 60 days, in thousands of dollars, by AR date.
  • AR Bal 31-60 DThe aged accounts receivable balance outstanding for 31 to 60 days, in dollars, by AR date
  • AR Bal 61-90 D (K) The aged accounts receivable balance outstanding for between 61 and 90 days, in thousands of dollars, by AR date.
  • ED 72 Hr Index w/ Return-AdmitThe number of ED visits (ED index accounts) which were followed by another ED visit by the same patient arriving within 72 hours of the previous ED departure that resulted in an admission. ED index accounts include all ED visits including patients those who expired, departed against medical advice, or were transferred from the ED. If arrival or departure times are not available, 3 days will be used instead of 72 hours.
  • AR Bal 61-90 D The aged accounts receivable balance outstanding for between 61 and 90 days, in dollars, by AR date
  • AR Bal 90+ D (K) The accounts receivable balance outstanding for more than 90 days, not including bad debt accounts, in thousands of dollars, by AR date.
  • AR Bal 90+ D The accounts receivable balance outstanding for more than 90 days, not including bad debt accounts, in dollars, by AR date
  • AR Bal 91-120 D (K) The aged accounts receivable balance outstanding for between 91 and 120 days, in thousands of dollars, by AR date.
  • AR Bal 91-120 D The aged accounts receivable balance outstanding for between 91 and 120 days, in dollars, by AR date.
  • AR Bal 121-150 D (K) The aged accounts receivable balance outstanding for 121 to 150 days, in thousands of dollars, by AR date/span>
  • AR Bal 121-150 D The aged accounts receivable balance outstanding for 121 to 150 days, in dollars, by AR date
  • AR Bal 151-180 D (K) The aged accounts receivable balance outstanding for 151 to 180 days, in thousands of dollars, by AR date.
  • AR Bal 151-180 D The aged accounts receivable balance outstanding for 151 to 180 days, in dollars, by AR date
  • AR Bal 180+ D (K) The aged accounts receivable balance outstanding for more than 180 days, in thousands of dollars, by AR date.
  • AR Bal 180+ D The aged accounts receivable balance outstanding for more than 180 days in dollars, by AR date
AR Bad Debt
  • Bad Debt Balance The portion of the accounts receivable balance classified as bad debt, by AR date.
  • Bad Debt Balance (K) The portion of the accounts receivable balance classified as bad debt, in thousands, by AR date.
  • Bad Debt Accounts The number of accounts with at least one adjustment classified as bad debt, in Adjustments, by posting date
  • Bad Debt % Total AR Balance Bad debt balance as a percentage of total accounts receivable balance, by AR date.
Hospital Operations – IP
  • Total Admissions No Description found for this measure.
  • Total Discharges No Description found for this measure.
  • Total Discharge Days No Description found for this measure.
  • Inpatient Charges The total amount of charges with patient service type of ‘inpatient’, including inhouse accounts, in dollars, by posting date (if this information is not available at the charge detail level, account inpatient-level charges are used instead).
Hospital Operations – OP
  • Total Outpatient Visits No Description found for this measure.
  • ED Visits No Description found for this measure.
  • Observation Visits No Description found for this measure.
  • Outpatient Charges The total amount of charges with patient service type of ‘outpatient’, in dollars, by posting date (if this information is not available at the charge detail level, account outpatient-level charges are used instead).
Utilization & Other
  • Overall All Payer Case Mix No Description found for this measure.
  • Acute All Payer Case Mix No Description found for this measure.
  • Medicare Case Mix No Description found for this measure.
  • Acute ALOS No Description found for this measure.
  • Overall ALOS No Description found for this measure.
  • Avg IP Charges Per Discharge No Description found for this measure.
  • Avg OP Charges per Visit No Description found for this measure.
  • IP/OP Charge Ratio The ratio of discharged inpatient charges to departed outpatient charges in dollars, by posting date.

Part of Dimensional Insight’s Library of Applications

Revenue Cycle Advisor is built on Dimensional Insight’s enterprise analytics platform. Deploying these applications results in deep and sustained clinical, financial, and operational improvements that impact patient care and your organization’s bottom line. Diver Platform and Dimensional Insight’s Library of Applications satisfy your health system’s enterprise reporting needs.

Benefits to the Library of Applications approach

w

Data trust across departments

Data governance ensures the use of consistent, standardized, validated, and documented business rules and measures across applications. This means all departments are using the same definitions for decision-making.

}

Quick to implement

Dimensional Insight uses a proven process that leads to short implementation times and quick time to value. Applications build on previously implemented Dimensional Insight apps, leading to even shorter deployment times, especially when compared to department-specific apps from multiple vendors.

Lower overall costs

Because Dimensional Insight Applications are all built upon Diver Platform, hospitals do not incur the high costs associated with licensing and supporting solutions from multiple vendors.

Consistent look and feel across application areas

Applications all have a consistent, intuitive look and feel.  Moving from one application to another is seamless. Executives and other users do not have to learn several applications.

g

Designed to be customizable

Users access 1,000s of off-the-shelf industry-standard business rules that can be deployed “as is” or adjusted to your unique requirements.

Built on the award-winning, healthcare enterprise analytics platform: Diver Platform®

8 time Best in KLAS winner from 2010 to 2021

Our customers have perennially rated Diver Platform #1.

Leading edge technology

Enterprise analytics platform combines ETL, data management, and self-service analytics to provide a powerful engine that generates results for all types of users.

f

Data governance

Rigorous processes that manage and protect data ensure data trust and consistency across the organization.

Custom development

Since Diver is a development platform, customers can modify existing Dimensional Insight applications or build new ones on their own.

Data when and where you want it

Users can easily access data from their desktop, laptop, tablet, or phone.

Multiple deployment options

Organizations can host deployment on site, in the cloud, or via SaaS.

Explore these resources for more information

Read blog post

How Hospitals Can Better Manage Revenue Cycle in a Value-Based World

Improve your Revenue Cycle

Download brochure