Report-47

Bill Calendarization Details (Excel only)

This report provides an Excel view of calendarized cost, use, and emissions for each bill over a 12-month period. It helps you understand how bill data is distributed across months during the calendarization process.

Note: This report includes emissions data from utility bills only.

What the report shows

  • Data for a selected 12-month period.
  • Bill and meter details.
  • Billed use and calendarized use by month.

The report includes three tabs:

  • Use
  • Cost
  • GHG

Why it’s useful

Use this report to:

  • Understand how bill data is allocated across months

  • Review differences between billed and calendarized values

  • Analyze cost, use, and emissions trends in Excel

Report-47 is available as: Excel

Set your filters for Report-47

  1. Set the Date range.

Other filters to consider for Report-47

  1. Decide if you need to narrow the focus of the report.
    • Select a specific group of sites or meters.
    • Set the filter Topmost place name or Topmost place code.
    • Select a specific commodity or vendor.

Available filters for Report-47

Required filters for Report-47

  • Date range - When you select less than or equal to this sets the end date for the report.

Recommended filters for Report-47

  • Market based - Location based emissions are used if this filter is not selected or set to No.
  • 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 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 for Report-47

  • Commodity - Select one or more commodities for the report. This filter is not compatible with commodity category.
  • Commodity category - Select one or more commodity categories. This filter is not compatible with commodity.
  • Meter code - Filter to one or more meters. Not compatible with topmost filters.
  • Meter name - Filter to one or more meters. Not compatible with topmost filters.
  • Vendor code - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. TIP: You can combine with other filters if you want to refine your results.
  • Vendor name - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. TIP: You can combine with other filters if you want to refine your results.