Solving Problems

Practical Applications for Behavioral Health Analytics

Automate Budget Tracking




























Spreadsheet example for developing a budget to track Revenue vs. Actual

















Automated, Real-Time Revenue Tracking vs. Budget by Program and Contract

It is typical that Behavioral Health CFO’s and finance teams are using spreadsheets and manual data collection processes to develop and maintain complex budgets. This spreadsheet above shows the construction of the revenue budget for programs and contracts including Inpatient, Residential, Partial Hospitalization and Outpatient & Emergency Services.

Budgets are typically constructed just like this example tracking by type of service, numbers of units, and the corresponding unit rate.

It should be mentioned that these “types of services” correspond to the contract measures feature of the iCentrix Analytics Financial Performance Management analytics. That capability allows for tracking of each relevant type of service contributing to the budget individually.

This is a common structure in financial departments (for example, one organization called these their “strategic measures”). These measures correspond to a combination of activity codes per program type - in the contract measures (also known as the fee-for-service measures).

The iCentrix Analytics Financial Performance Management analytics tool automates the process represented by the above spreadsheet, providing the basis for daily updates per organizational structure, budget vs actual, and being able to automatically distribute the information to program directors in the form of dashboards. This sample budgeting spreadsheet has no capability to updated itself in real-time, is not interactive such that one can drill into the data and cannot be easily tied back to the EMR or General Ledger except by labor intensive data extraction and spreadsheet massaging processes.

Budgets are established per organizational element (usually program, but it could be other structures from the GL). As we can see, the budgets are based on billed units usually, and the revenue generated from those units, per the service mix.)


Talk to us to hear more about automating your budgeting process!

Spreadsheet Website.jpg
Revenue vs Budget website.jpg