Configuring Variance Comments Collection

Before you can collect variance comments for a new month, you must do the following:

  1. Set variance thresholds and alert flags.
  2. Set VCC Payroll mapping.

  3. Set additional data requirements

    Confirm that all necessary monthly data has been loaded, the payroll accrual process has been completed, and that periods have been set properly for the following data sources:

    Datasource Definition
    Financial Monthly GL & Statistics loaded and proper period set
    Payroll12

    Biweekly payroll (Payroll27) accrued to Payroll12 with EMPLOYEE NAME

    • PP26to12_Hours– Act_Pay27_YYYY to Act_Pay12_YYYYHours sequence
    • PP26to12_Dollars – Act_Pay27_YYYY to Act_Pay12_YYYY Dollars sequence
    • EmpIDDesc

    Use the PP27to12 utility report to filter hours properly as well as transfer employee names from Payroll27 tables to Payroll12 tables.

    Drilling Down to Detail

    The following data is necessary to enable the corresponding drill-downs to detail.

    • GLDetail – Journal entry transaction data imported for current period.
    • GLTransactions - AP/MM/AR transaction data imported for current period.
    • RevUsage – Monthly Gross Charges and Volumes by patient type (IP and OP) by CDM Code