Overview
During the billing process, there are situations where actual meter readings are not available for all customers. This can happen for various reasons:- Meter reading was not submitted.
- Field staff could not access the property.
- Smart meter communication failed.
- Data upload was incomplete.
- A reading was missed during the billing cycle.
Why Estimation Is Needed
For metered services, bill calculations depend on consumption. Consumption is typically calculated as:| Previous Reading | Current Reading |
|---|---|
| 12,500 | Missing |
How Estimation Works
The estimation process identifies customers who are missing current readings and calculates estimated usage based on previous billing history. The system then:- Calculates estimated consumption units.
- Derives an estimated current reading.
- Marks the reading as estimated.
- Makes the record available for bill processing.
Example
Suppose a customer has the following history:| Month | Usage |
|---|---|
| January | 450 Units |
| February | 500 Units |
| March | 550 Units |
| April | Missing |
What Gets Updated?
When estimation is performed, the billing system updates:Estimated Consumption
The calculated usage units for the billing period. Example:| Usage |
|---|
| 500 Units |
Estimated Current Reading
A new current reading is derived from:| Previous Reading | Estimated Usage | Estimated Reading |
|---|---|---|
| 12,500 | 500 | 13,000 |
Estimation Flag
The system marks the reading as estimated rather than actual. This provides visibility during audits and billing reviews.Supported Estimation Methods
Each metered service parameter can be configured with a specific estimation method. Examples of metered parameters include:- KWH
- M3 Gas
- Water Consumption
- Utility Usage
Estimation Method 1: Average of Last Year
The system calculates the average consumption from the previous calendar year.Example
| Month | Usage |
|---|---|
| Jan | 450 |
| Feb | 500 |
| Mar | 550 |
| … | … |
| Dec | 600 |
Best For
Customers with relatively stable consumption patterns.Estimation Method 2: Same Month Last Year
The system uses consumption from the same month in the previous year.Example
Current Billing Period:| Month | Usage |
|---|---|
| January 2024 | 700 Units |
Best For
Seasonal services where consumption varies throughout the year. Examples:- Electricity
- Gas
- Water
Estimation Method 3: Greater of Average and Same Month
The system calculates:- Average of Last Year
- Same Month Last Year
Example
| Calculation | Result |
|---|---|
| Average Last Year | 450 Units |
| Same Month Last Year | 600 Units |
Best For
Conservative billing approaches where underestimation should be avoided.Estimation Method 4: Maximum Usage of Last Year
The system uses the highest recorded consumption from the previous calendar year.Example
| Month | Usage |
|---|---|
| January | 450 |
| February | 500 |
| July | 900 |
| December | 650 |
Best For
Organizations that prefer high-confidence recovery of potential revenue.Estimation Method 5: Minimum Usage of Last Year
The system uses the lowest recorded consumption from the previous calendar year.Example
| Month | Usage |
|---|---|
| January | 450 |
| February | 500 |
| March | 320 |
| April | 600 |
Best For
Conservative customer-friendly estimation strategies.Example Billing Scenario
Consider the following customer:Meter Information
| Item | Value |
|---|---|
| Previous Reading | 15,000 |
| Current Reading | Missing |
| Estimation Method | Average of Last Year |
Historical Usage
| Month | Usage |
|---|---|
| Jan | 500 |
| Feb | 550 |
| Mar | 450 |
| Apr | 500 |
| Item | Value |
|---|---|
| Estimated Usage | 500 |
| Estimated Reading | 15,500 |
| Estimated Flag | Yes |
How to Estimate All:\
1-Go to BillSpree →Bill Runs →Term


