Utility Bill Analytics standard reports
Three Utility Bill Analytics report categories are available, which are cost analysis reports, consumption analysis reports, and normalization reports.
The following table lists the Utility Bill Analytics reports that are available in each category.
| Report category | Report name | Description |
|---|---|---|
| Utility Bill Analytics - Cost Analysis | Account Style Data Extract | This report extracts account items (invoices) for a single account style (for example, Electricity Large Market) which includes all line items captured in the invoice, if any, for example, Peak kWh, Off Peak kWh. |
| Account Items & Cost Audit | This report extracts original invoice records with total cost and total consumption information, also including additional information such as loading file name, loading date, and so on. | |
| Monthly Data Summary | A comprehensive report with data normalized by calendar month, that includes actual, accrual or estimated consumption and cost information for each account | |
| Monthly Data Summary (All Measures) | Similar to the Monthly Data Summary report with the inclusion of all cost and consumption measures (for example, Peak kWh, Off Peak kWh) normalized to calendar monthly values for each account. | |
| Utility Bill Analytics - Consumption Analysis | Account Style Data Extract | This report extracts account items (invoices) for a single account style (e.g., Electricity Large Market) which includes all line items captured in the invoice, if any, for example, Peak kWh, Off Peak kWh. |
| Account Items Audit | This report extracts original invoice records with total consumption information, also including additional information such as loading file name, loading date, and so on. | |
| Accounts Data Variance Exceptions | A variance checking report to compare account consumption with the account's historical average. | |
| Accounts Incomplete Data | This report provides details of accounts that contain missing or overlapping data across the period reported. The report also provides information on what data has been entered in the account if missing or overlapping data is reported. | |
| Monthly Data Summary | A comprehensive report with data normalized by calendar month, that includes actual, accrual or estimated consumption and cost information for each account. | |
| Monthly Data Summary (All Measures) | Similar to the Monthly Data Summary report with the inclusion of all cost and consumption measures, for example, Peak kWh, Off Peak kWh, with data normalized by calendar month for each account. | |
| Utility Bill Analytics - Normalization Reports | Bulk Regression Modeller - Accounts | Performs regression analysis for a selected range of accounts in bulk. The regression result for an account that meets its R2 acceptance criteria will be saved into the system when the report is run in Commit To Save mode. |
| Monthly Actual vs Expected (Weather Normalized) | This report uses both account and meter data, where applicable, to compare monthly actual against expected consumption for a given location. Expected consumption is derived by applying regression analysis using actual consumption, heating degree days (HDD) and cooling degree days (CDD) as variables. This report also provides a variance and variance % between the monthly actual and weather normalized consumption. | |
| Ranking Actual vs Normalized | This Excel report template uses both account and meter data, where applicable, to compare monthly actual and expected consumption for a given location. Expected consumption is derived by applying regression analysis using actual consumption, heating degree days (HDD) and cooling degree days (CDD) as variables. This report also provides a variance and variance % between the monthly actual and weather normalized consumption, and a ranking on accounts/meters and location. |