Finance Dashboards

Finance Dashboards

Administrators, Executives

SETWorks is happy to announce updated and simplified Business Intelligence views into your service delivery.  These new views are based on all of your activity records, authorizations, service billing rules and rates as well as electronic remittance advice if applicable. 

View our Finance Dashboard Webinar:

Authorization BI Reports

There are seven reports available that are recommended for use by executives for fiscal analyses of your organization or for detailed authorization overview. 

Telling the Financial Story

The Authorization Financial Overview and Utilization Dashboard is a great place to start. This dashboard shows the billable dollar amounts by departments and months as well as some insight into overall authorization utilization. In the Authorization Overview table, the Authorization Total reflects the total dollar amount based on the authorization hours/ service as they are entered in SETWorks. The Total Charge Amount is what you've logged based on Activity Records. Learn more. 

The Authorization Financial Overview has more of a focus on finding where we might not be fully providing authorized services and where we might have extra room to deliver needed services. It is important to remember that all of these amounts are calculated based on the authorization hours/ units entered into SETWorks.

The Authorization Hours Overview and Authorization Units Overview tell the story of your utilization along with percentages and overall target and weekly hours/unit suggestions.
 
The Authorization Utilization By Consumer Trellis and Authorization Utilization by Department Trellis give an at-a-glance view of how well we're utilizing our authorizations by Consumers and by Departments.

Finally, the Authorization Financial RA has a focus of your remittance advice information and how it relates to service delivery.

Details

- Behind the scenes, a new service evaluates all Activity Records logged in SETWorks based on configured billing rules, rates and units to provide strategic insight into service delivery.
- Data for our Business Intelligence Dashboards is processed every 24 hours
- The service currently evaluates the past 700 days of applicable authorizations and all dates into the future based on authorizations that are currently active. 
- All Billable Activity Records as well as billable appointments are included.
- Default service rate changes or major non-passive changes to rates and billing rules may take up to 72 hours to reflect in Business Intelligence.
- The service works well for services that are based on any kind of minute based increment.
- Monthly and day rate services are not explicitly excluded but have some applicable exceptions covered below. 
- A staff filter is not included because we're evaluating everything from a service delivery perspective.

Definitions

Auth Charge: This reflects the total dollar amount if all the units in the authorization are provided. 
Minutes:  The precise number of minutes that can be billed after applying billing rounding rules.
Minutes Logged:  The total number of minutes logged prior to rounding.
Charge Loss Due To Rounding:  The prorated charge loss amount based on fractional rounding.
Target Units / Minutes / Charge:  The target for evenly distributing services over the span of an authorization.
Ideal Target Units / Minutes / Charge:  The ideal target to maximize services based on remaining days in an authorization.
Charge Amount:  The $ amount based on Activity Records that could be billed for.
Paid Amount:  The $ amount based on remittance advice data received (may not be applicable).

Exceptions

Minutes / Units / Minutes Logged exceptions:
- Monthly rate and Day rate minutes, units and minutes logged are set to the currently logged minutes.

Target Charges/ Minutes/ Units exceptions:
- All TCM Services (G9212) are set to 0
- Monthly Rate Target Charge is calculated by distributing the monthly rate across every day in the month for plotting purposes
- Monthly Rate Target Minutes and Target Units are set to 0

Ideal Charges/ Minutes/ Units exceptions:
- If the authorization has no remaining days left the ideal values are set to 0
- Day Rate Target Charge is evaluated based on an assumption of 24 hours service delivery (certain rules cannot be considered for future plotting purposes)
- Day Rate Target Minutes are set to 0 and Target Units are set to 1 per day.
- Day Rate Ideal Target Charge is evaluated based on an assumption of 24 hours service delivery (certain rules cannot be considered for future plotting purposes)
- Day Rate Target Ideal Minutes are set to 0 and Target Ideal Units are set to 1 per day

Accessing Reports

Settings > Provider Build > Configure Report Access




    • Related Articles

    • SETWorks Webinar - May 2023 - Finance Dashboards

      On May 17th 2023, SETWorks hosted a live webinar about Finance Dashboards in SETWorks. You can view the recording from the link below: https://youtu.be/Q-LnNDcyCe0 References: General Help: SETWorks Webinar - April 2023 - Business Intelligence (BI) ...
    • Consumer Finance

      What Is the Consumer Finance tab? Finance The Finance tab is used to document consumer financial transactions. Within the Finance tab is a tab for Accounts and a tab for Transactions. Accounts The Accounts tab lets you define the account details for ...
    • Demographics Dashboards

      What are the Demographics Dashboards? SETWorks offers several different reports that include demographics details for consumers. Some of the most robust are Business Intelligence dashboards that are focused on pulling demographics information for ...
    • Business Intelligence Dashboards - Filters Panel

      Why Can't I See Any Filtering Options on the Business Intelligence Dashboards? All Users The Business Intelligence Dashboards have a filters panel. Look for a small gray arrow to control whether the filters panel is displayed.  Filters Panel The ...
    • SETWorks Webinar - April 2023 - Business Intelligence (BI) Dashboards

      On April 19th 2023, SETWorks hosted a live webinar about Business Intelligence (BI) Dashboards in SETWorks. You can view the recording from the link below: https://youtu.be/7OPWoAHtdiY References: Reports Business Intelligence Dashboards - Tips and ...