Report-10

Two-Year Comparison

Report-10 is a data table and bar chart that ranks objects AND compare two years of data. The end period entered is used to determine the two-year period.

Report-10 recommendations

  • The filter Group by determines the objects on each row, a common option is sites.
  • If you use chargebacks, remember to use the appropriate Topmost place or Topmost cost center to avoid double counting use or cost.

Report-10 tip

When comparing USE year-to-year you many want to use normalized for Data type because it removes weather as a variable.

When comparing COST it is recommended to use calendarized for Data type because it gives a more accurate representation of cost by prorating it per day.

Set your filters for Report-10

  1. In the Data type field, choose the data set you want to use for the report.
    Data set When to use it Why it helps
    Billing Period Accounting, chargebacks, or any task that needs the exact bill dates Uses the raw start and end dates from the utility bill
    Calendarized Month-to-month or year-over-year cost analysis Spreads each bill across true calendar months so totals line up with financial periods
    Normalized Year-over-year usage analysis Adjusts energy use for weather, removing temperature as a variable
  2. End period.
    This sets the end of the two year period.
  3. Group by
    Decide the objects on each row with the filter.
  4. Include account charges.
    Decide whether to include one-time or periodic charges. 
    These are not linked to use or demand on the bill.
  5. Number of months
    Sets the number of months for each column. Enter 3 for a quarterly report or 12 for a full year report.
  6. Value
    Select what you want to report on.

Other filters to consider for Report-10

  1. Active accounts only
    Decide whether to include only active accounts.
    If this filter is not applied, your report includes both active and inactive accounts.
  2. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.

Example filters for Report-10

This set of filters creates a 2 year cost comparison report of sites for the years 2019 and 2020 using calendarized data.