Report-08
Monthly Trends—One Page per Year
Report-08 is a line chart (with data table) helps you compare multiple objects (meters, buildings, etc.) in the same year. For example, a line chart with a line for each electric meter for the year 2021.
Report-01 vs Report-08
These reports may look similar, but they focus on different comparisons:
- Report-01 compares multiple years for one objects
Example: A site's total commodity cost for 2015 to 2020. - Report-08 compares multiple objects for one year
Example: Several sites' monthly commodity cost for 2020
Report-08 recommendations
- When you are reporting on Cost Avoidance, remember to run Cost Avoidance -> Calculate Savings first.
- If you use chargebacks, remember to use the appropriate Topmost place or Topmost cost center to avoid double counting use or cost.
Report-08 tip
Use the filter Group by to set what each chart line represents. It many be necessary to set a filter for a topmost or group to limit the number of lines in the chart.
Set your filters for Report-08
- Choose the type of data you want in your report with the 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 - First month
Set the month you want the report to start with. - Group by
Decide what each chart line represents. It may be helpful to set a topmost or group to limit the number of lines on the chart. - Include account charges
Decide whether to include one-time or periodic charges.
These are not linked to use or demand on the bill. - Value
Select the value you want to report on. - Date range
Try using prior year or prior 12 months so you don't have to reset this filter when using subscriptions or distributions.
Other filters to consider for Report-08
- Commodity category
Use this filter to view granular commodity data.
Helps break down charts and tables by specific utility types. - Active accounts only
Decide whether to include only active accounts.
If this filter is not applied, your report includes both active and inactive accounts. - Void bills
Include if you want a full audit history.
Exclude to focus only on valid financial activity. - Topmost place
When set to a specific organization, and paired with Group by site, the report shows one chart or table per site under that organization.
Available filters for Report-08
Required filters for Report-08
- Data type - You can select calendarized, billing period, or normalized.
- First month - Select the starting month (1 thru 12), this is a calendar month not a fiscal month.
- Group by - Determines what each chart line represents (commodity, buildings, meter). TIP: It may be helpful to set a topmost or group to limit the number of lines on the chart
- Include account charges - Account charges are separate from meter charges and not used in calculating unit cost. (For example, late fees, connection charges, or deposits)
- Value - Select the value you want to report on.
Recommended filters for Report-08
- Accounting period - You must select either Accounting period or Date range. When you use Accounting period you must set Data type to billing period data. Not compatible with the Date range filter.
- Date range
- Meter group - Lets you filter the report to a specific group of meters.
- Site group - Lets you filter the report to a specific group of sites.
- Topmost cost center code - When you use this filter you are selecting the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
- Topmost cost center name - When you use this filter you are selecting the topmost cost center you want to be included. When you set a topmost cost center it is the highest level of the accounting tree used, this lets you select a subset of data for reporting.
- Topmost place code - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
- Topmost place name - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
Optional Filters
- Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
- Account name
- Account number
- Accounts in cost center code
- Accounts in cost center name
- Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.
- Bill is void - If this filter is not included both void and not void are included.
- Commodity
- Commodity category
- Include accrual bills
- Meter code
- Meter name
- Meters in site code
- Meters in site name
- Vendor code
- Vendor name
Configured Report-08 options
Report-08 is flexible and has many options available to configure. To help you be successful two configured reports are available to help get you started.
Each report has its own preset filters and instructions.