Report-06

Year-over-Year Comparison

Report-06 is a data table that compares key metrics across meters, sites, and other objects over time.

Time Frame

  • Covers up to five years of data.

What It Shows

  • Use, demand, cost, and other key values
  • Percentage change between the two most recent years
  • Results are sorted alphabetically for easy scanning

Use Case

Ideal for identifying trends, growth, or reductions in utility usage and spending across your facilities over time.

Report-06 recommendations

  • Use the filter Group by equals Vendor to compare your use or cost per vendor.
  • When you are reporting on Cost Avoidance, remember to run Cost Avoidance -> Calculate Savings first.

Report-06 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 data for Data type because it gives a more accurate representation of cost by prorating it per day.

Set your filters for Report-06

  1. Choose the type of data you want in your report with the filter Data type.
    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. Set your End period. This sets the end month for the report.
  3. Group by determines what is on each row. TIP: A common selection is Sites; this creates a report with the sites in alphabetical order.
  4. Decide if you want to Include account charges. Account line item charges are one-time or periodic charges. A charge is typically assigned at the account level when it does not have a link or relation to the use or demand on the bill.
  5. Number of months set the months you want to report on. The months returned are based on the End Period filter.
  6. Set the Number of years you want in the report.
  7. Value is what is listed in each column.

Other filters to consider for Report-06

  1. Do you want to include all the Commodities, one, or a select few? If you don't add this filter, all the commodities are in your report. Use the Commodity category filter to view more granular commodity data in charts and reports.
  2. Do you want to include only Active accounts? If this filter is not included your report includes both active and inactive.
  3. Include or not include void bills?

Example Report-06

A calendarized three year cost report of all the sites in the organization.