Best practices for setting up the ACCT dimension and statistics

The ACCT dimension contains records for each account in the General Ledger (GL) of your organization, which includes balance sheet, income statement, hours, and statistics accounts. This topic focuses on best practices for statistics and hours accounts in Axiom Budgeting and Performance Reporting.

Overview

You can easily configure Axiom Budgeting and Performance Reporting system to use two types of statistics:

  • Key Statistic (ACCT.Type is KeyStat)
    • For revenue producing departments, we recommend that you use a Key Statistic that is the most directly connected to the resulting revenue.
      • Inpatient Care Areas - Patient days
      • Surgical Care Services - Operating Cases or Operating Minutes
      • Outpatient Care Areas - Visits, Encounters, Procedures, or Cases
    • For non-revenue producing departments, we recommend that you use a Key Statistic that is the most directly connected to the activity of those operations.
      • Housekeeping - Square footage
      • IT - Number of Devices
      • Other Overhead Areas - Adjusted Patient Days
  • Non-key Statistics (ACCT.Type is Statistic)
    • Non-key statistics are statistics captured by the department for reporting purposes but are not a primary driver of revenue and expenses. For example, a Labor and Delivery department may track procedures, but Deliveries is the designated key statistic as it is most directly connected to revenue and expense.

Designing the statistic account structure

We recommend creating a statistic account structure to include the following categories of Key Statistics:

  • Inpatient Statistics (KeyIP) – Used for hospital-billed patient revenue producing departments. These statistics drive inpatient revenue calculations. If an individual department contains multiple key statistic categories, the sum of KeyIP, KeyOP, and KeyOth will drive variable expense calculations.
  • Outpatient Statistics (KeyOP) – Used for hospital-billed patient revenue producing departments. These statistics drive outpatient revenue calculations. If an individual department contains multiple key statistic categories, the sum of KeyIP, KeyOP, and KeyOth will drive variable expense calculations.
  • Key Other Statistics (KeyOth) – This category serves a different purpose depending on department type. For physician-billed patient revenue producing departments, these statistics drive other patient revenue calculations. If an individual department contains multiple key statistic categories, the sum of KeyIP, KeyOP, and KeyOth will drive variable expense calculations. For non-revenue producing departments, this statistical category drives expenses.

A similar approach should be also considered for Non-Key Statistics:

  • Inpatient Non-Key Statistics – Used for revenue producing departments. These statistics do not drive inpatient revenue calculations, but they may be included for tracking purposes and other reporting requirements.
  • Outpatient Non-Key Statistics – Used for revenue producing departments. Tese statistics do not drive outpatient revenue but may be included for tracking purposes and other reporting requirements.
  • Other Non-Key Statistics – Can be used for both revenue and non-revenue producing departments. These statistics do not drive expenses and may be included for tracking purposes and other reporting requirements.

Other considerations

Many organizations track summarized statistic values such as Total Patient Days, Total Discharges, or Adjusted Discharges. In some cases, these are tracked in a single department, such as “Facility Statistics” or an administrative department. In other cases, the summarized statistic values are tracked in multiple departments. For example, the key statistic for a Nursing Administration department may be Total Patient Days and the key statistic for an Education department is also Total Patient Days. You should also consider GL account numbers that enable easy identification of facility statistics versus those used for department statistics.

Units of Time (Hours) accounts

When considering Units of Time accounts, your account structure can be easily established based on salary accounts. You may also want to capture hours by job classification.

TIP: If you do not currently track hours in your GL, we recommend prefixing the GL salary account with a “9” to allow you to track hours with the related salaries.

NOTE: If payroll hours are not coming through your GL Import, you can now move your hours from the Payroll12 data tables created from the previous process to your Financial tables by running the Monthly to GL Accrual utility.

To determine Units of Time, first identify whether or not hours are included in your FTE calculations:

  • Productive Hours
    • Units of Time easily defined
      • Regular
      • Overtime
      • Agency
    • More difficult to define
      • Education
      • Orientation
      • Call-Back
      • Call-Pay
    • Treatment of premium pay
      • Differentials
      • Call Pay
      • Incentive Pay
  • Non-Productive Hours
    • Units of Time easily defined
      • PTO
      • Sick
      • Bereavement
    • More difficult to define
      • Education
      • Orientation
      • Jury Duty

Stat account example