Report-13

Bill Analysis

Line charts (and data table) help you identify and analyze abnormal bills. This report uses a quadratic regression equation to find outlier bills. The data table is valuable not only in showing one page per outlier bill, but also in providing historical data to help you quickly verify if the bill requires further investigation.

Report-13 recommendations

Because this report is designed to audit current bills you should either set the Billing period to a recent month, choose a recent Batch, or set the Bill entry date to see bills recently entered.

The filter Outlier analysis sensitivity lets you decide what bills to include and reports on the most probable problems (Severe only) or be less sensitive and include High and Moderate problems.

The filter Value analyzed for outliers lets you pick use, cost, demand, or any combination of the three.

Report-13 tip

You can subscribe to Report-13 to get emails when problematic bills are entered. Configure the report and subscribe to the report. Use the option to Only send report if data is available.

Set your filters for Report-13

1. Active accounts only
   Decide whether to include only active accounts.
   If this filter is not applied, your report includes both active and inactive accounts.
2. Void bills
   Include if you want a full audit history.
   Exclude to focus only on valid financial activity.
3. Number of comparison years
   Choose how many past years to include.
4. Outlier analysis sensitivity
   Adjusts how sensitive the system is to detecting unusual bills.
5. Value analyzed for outliers
   Set the values you want analyzed to determine if the bill is an outlier.

Other filters to consider for Report-13

1. Limit the size of the report
   Set the Billing period, Batch, or Entry date.
2. Cost
   Reduce the report size by filtering out low-cost bills that may not need review.