EI Reports using Billed Consumption

This page shows examples of the Reports using the Billed Consumption View, along with a link to take you to the Report in your Energy Intelligence.


Click on the link in the table to take you directly into the Report in Energy Intelligence in your own database.

Report Link - click on the link to log into Sigma and view the Report

ThumbnailReport Description

Accruals per Account by Month

Accruals per Account by Month

Attempts to calculate an estimated bill cost for an Account for a year and month period. It will use recent, historic bill data or metered consumption, depending on the “quality” of metered consumption available. It will only accrue where it there is no actual billing data for the complete month. It will calculate the accrual based on the best data available. The Accrual Type column outlines the accrual methodology that has been used.

Click here for a detailed explanation of this report

Billed Consumption and Cost by Provider and Commodity

Billed Consumption and Cost by Provider and Commodity

Provides an overview of the total consumption and gross cost by Provider and Commodity, displaying the information in four separate charts.

Bill Consumption Vs HH Consumption by Account



Billed Consumption and Cost by Provider and Commodity

Shows both the Daily Billed consumption AND the HH (Periodic) consumption plotted on the same graph.

Billed Consumption vs Previous bill and Last Years bill

Billed Consumption vs Previous bill and Last Years bill

Details the daily consumption from the current bill, the previous bill and the previous years bill, showing the percentage differences and potential savings.

Uses the Sigma Bill Consumption (primary view), Sigma Bill & Charges and Sigma Bill Consumption Views.

Billed Cost, Consumption and Carbon Emissions

Billed Cost, Consumption and Carbon Emissions

Breaks down the billed Cost, Consumption and Carbon Emissions per Commodity across all Sites. 5 years of data will be displayed unless the Date filter is used. All Commodities will be displayed unless the the filter is used.

Billed Cost, Consumption and CO2 by Commodity (Stacked bar chart)

Billed Cost, Consumption and CO2 by Commodity (Stacked bar chart)

Details the consumption and gross cost for selected Site(s) in a stacked bar chart.

Billed Cost per Commodity for the last Calendar Month



Billed Cost per Commodity for the last Calendar Month


Details the total billed by Commodity for bills with an invoice date within the last calendar month.

Billed Cost Year on Year Comparison



Billed Cost Year on Year Comparison

This report shows a calendar year on year comparison of the billed gross amount based on the bill read date using set analysis.
The graph shows the Gross Costs, but the tabular data shows the Gross and Net Costs.

Click on a point on the graph or the Month Number in the tabular data to drill down to show the Weeks, then drill down further to view the daily data.

Billed Electricity Consumption vs HH Consumption - 2 Period Comparison

Billed Electricity Consumption vs HH Consumption - 2 Period Comparison


This report compares the Electricity Billed Consumption and the HH Consumption for any MPAN across
two selected periods.

Billed Vs HH Cons Graph

Billed Vs HH Cons Graph

Daily Billed and HH consumption plotted on the same graph.

Consumption Validation

Consumption Validation

A newer version of this report called 'Forensic Validation - Consumption' now exists

Days Since Last Actual Billed Reading (Electricity)

Days Since Last Actual Billed Reading (Electricity)

Details the amount of days since an actual reading was included in your bill. Days will display in red where this is more than 90 days. The report is restricted to active accounts and includes bills that have the A&R reporting flags applied.

Days Since Last Actual Billed Reading (Gas)

Days Since Last Actual Billed Reading (Gas)

Details the amount of days since an actual reading was included in your bill. Days will display in red where this is more than 90 days. The report is restricted to active accounts and includes bills that have the A&R reporting flags applied.

Days Since Last Actual Billed Reading (Water)

Days Since Last Actual Billed Reading (Water)

This report shows the date of the latest Water bill with an Actual Meter reading and how many days since that bill. Days are highlighted in red where this is more than 90 days. The report is restricted to active accounts and includes bills that have the A&R reporting flags applied.

Energy Management Overview Dashboard

Energy Management Overview Dashboard

An Energy Management Dashboard that delivers a series of different objects to provide strategic level information across your estate, helping you start exploring your energy data.

Estimated Cost of Overdue Bills

Estimated Cost of Overdue Bills

Displays Accounts that have overdue bills and shows a rough estimate of cost accrued since the last bill was received

Forensic Validation - Billed Vs HH Consumption

Forensic Validation - Billed Vs HH Consumption

This report compares the Billed and HH consumption and gives an estimated cost to query when there is a difference in the 2.
When HH data is not 100% for the given period the query amount will use estimated HH consumption for the missing data.

Forensic Validation - Consumption

Forensic Validation - Consumption

This report compares the consumption on an invoice to its immediate predecessor and the invoice for the same period in the previous year and provides a percentage difference between the invoices and the potential savings.

The option to filter on the value of the potential savings and date bills were loaded into Sigma is available.

Gaps in Monthly Billed Cost and Consumption (by Account)

Gaps in Monthly Billed Cost and Consumption (by Account)

The date range is pre-filtered to show the last year, but can be changed in the filter. This report breaks down the billed Cost and Consumption per Account for up to 5 years, highlighting the months where no Cost or Consumption is present.

There are also options to filter by Commodity, Site or Site Group.

Selecting a Site Group is mandatory.

Indicative Cost of Missing Bills (10 Most Expensive)

Indicative Cost of Missing Bills (10 Most Expensive)

This report determines the total number of days where bills are missing for an account and calculates an indicative cost based on the daily average bill amount for the existing bills.

An account can be selected to go to the 'Missing Bill Days for Account (Drill Through)' report to see which particular periods of time are missing bills.

Missing Bill Days for Account (Drill Through)

Missing Bill Days for Account (Drill Through)

This report outlines the individual days where a bill does not exist.

In the chart, 1 represents where a bill does exist and 0 where one doesn't exist.

This is a Drill Through from the 'Indicative Cost of Missing Bills (10 Most Expensive)' report.

Monthly Billed Consumption, Cost and average PPU for today minus 12 months

Monthly Billed Consumption, Cost and average PPU for today minus 12 months

Details the monthly consumption and costs (net, gross and average PPU) for the selected Site Group(s), Site(s) or Commodity for a period of today minus 12 months.

Monthly Billed Cost, Consumption and Average Daily Consumption

Monthly Billed Cost, Consumption and Average Daily Consumption

Details the monthly average and total consumption and costs for the selected Account(s). Restricted to A&R flagged Bills.

Monthly Billed Cost and Consumption (per Account)

Monthly Billed Cost and Consumption (per Account)

This report breaks down the billed Cost and Consumption per Account for 5 years, showing where no Cost or Consumption is present. There are options to filter by Date, Commodity, Site or Site Group.

Monthly Billed Cost and Consumption Year on Year

Monthly Billed Cost and Consumption Year on Year

This report details the billed cost and consumption for Electricity, Gas and Water for a rolling 12 months compared to the same months in the previous calendar year. This report only includes those Bills with A&R Flags.

Filtering options include Commodity, Site Group and Site. Choosing a Site Group is mandatory

Site Billed CO2 (stacked by Commodity)

Site Billed CO2 (stacked by Commodity)

Details the kg CO2 from the Accounts in selected Site(s), broken down by Commodity. The table of data includes the total consumption and gross cost.

Site Billed CO2 Emission Comparison for a Period

Site Billed CO2 Emission Comparison for a Period

Details the total CO2 emissions in kg for a Site(s)  compared against a figure for a previous period. Values are displayed by commodity and include the present consumption and gross cost. The Move represents the changes in CO2 for each site.  Also known as League Table CO2 Emissions.

Site Billed Consumption Comparison for Selected Periods (includes Cost and CO2)

Site Billed Consumption Comparison for Selected Periods (includes Cost and CO2)

Details the consumption for a Site(s) compared against a figure for a previous period. Values are displayed by commodity and include the present kg CO2 and gross cost. The Move column in the results table represents the changes in Consumption for each site.  Also known as League Table Any Period.

Site Billed Consumption, CO2 and Cost per m2

Site Billed Consumption, CO2 and Cos per m2

Details the total consumption, CO2 and cost for a Site(s) normalised by the floor area in m2

Site Billed Consumption, CO2 and Cost per Person

Site Billed Consumption, CO2 and Cost per Person

Details the total consumption, CO2 and cost for a Site(s) normalised by 'Population'

Site Cost by Commodity for the Last Financial Year

Site Cost by Commodity for the Last Financial Year

Details the gross cost (£) for selected Site(s), broken down by commodity for the last financial year.

Site Cost by Commodity (Stacked) for the last Financial Year

Site Cost by Commodity (Stacked) for the last Financial Year

Details the gross cost (£) for selected Site(s), broken down by commodity for the last financial year displayed in a stacked bar chart

Site Monthly Billed Gas and Electricity Cost and Consumption vs. Previous Year (Drill Through)

Site Monthly Billed Gas and Electricity Cost and Consumption vs. Previous Year (Drill Through)

This is a Drill Through Report.
Details the billed cost and consumption for gas and electricity for 1 month compared to the same month in the previous year. 

Site Performance (Year to Date) League Table Summary - 10 Worst Performing

Site Performance (Year to Date) League Table Summary - 10 Worst Performing

This report is for Gas and Electricity Consumption.

It details the total Billed Gas and Electricity Consumption and also Consumption per m2 of floor area for the current year to date . This report is ordered by consumption per m2 to highlight the worst performing Sites.
You can also see how the total Site Consumption compares to the same period in the previous year.

A Site Name can be selected to drill down further and provide a view of the Monthly Billed Costs and Consumption for the Site.

Drill through to the 'Year to Date Monthly Site Cost and Consumption per Commodity)' report.

Total CO2 by Commodity

Total CO2 by Commodity

Details the total CO2 emissions in kg by commodity.
Results are available for the following commodities where applicable: electricity, gas, water, oil and propane.

Year to Date Billed Energy Overview

Year to Date Billed Energy Overview

Provides a year to date overview of billed electricity, gas and water cost and consumption for the current year, alongside the same period in the previous year, with the applicable percentage change and trend.
Also, a summary of all billed costs and all emissions for the current year are displayed.

Year to Date Monthly Site Billed Cost and Consumption per Commodity (Drill Through)

Year to Date Monthly Site Billed Cost and Consumption per Commodity (Drill Through)

This report displays the monthly billed cost and consumption for electricity and gas for the current year to date.

A month can be selected to show the billed cost and consumption for that month and how it compares to the same month in the previous year.

Drills through to the 'Site Monthly Billed Gas and Electricity Cost and Consumption vs. Previous Year (Drill Through)' report.