Combined Utility Bills
Combined Utility Bill represents monthly statement of services owned by a home containing multiple utility information (like any combination of electricity, gas or water).
API Upload
The api_type parameter is utility_bill_combine for the Upload endpoint.
Field Descriptions:
The model automatically detects data such as:
| Session N | Field Name | Data Type | Description |
|---|---|---|---|
| Basic Information | Account Number | String | Customer's unique account number |
| Basic Information | Customer Name | String | Full name of the customer |
| Basic Information | Vendor Name | String | Vendor name |
| Basic Information | Invoice Name | String | Invoice name (if available) |
| Basic Information | Service Address | String | Service location address |
| Basic Information | Service State | String | Service location state |
| Basic Information | Service City | String | Service location city |
| Basic Information | Service Zip Code | String | Service location ZIP code |
| Basic Information | Previous Balance | Number | Previous balance |
| Basic Information | Payment Received | Number | Payment received |
| Basic Information | Adjustments | String | Any adjustments made |
| Basic Information | Balance Forward | String | Balance carried forward |
| Basic Information | Current Charges | Number | Total current charges |
| Basic Information | Taxes and Misc Charges | String | Taxes and miscellaneous charges |
| Basic Information | Total Amount Due | Number | Total amount due |
| Basic Information | Issue Date | Date | Invoice issue date |
| Basic Information | Service End Date | Date | Service end date |
| Basic Information | Service Start Date | Date | Service start date |
| Basic Information | Due Date | Date | Due date for payment |
| Electric | Meter Number1 | String | Electric meter number |
| Electric | Tariff Name1 | String | Electric tariff name |
| Electric | Consumption1 | String | Electric consumption details |
| Electric | Consumption UOM1 | String | Units of measurement for electric consumption |
| Electric | Demand1 | String | Electric demand details |
| Electric | Demand UOM1 | String | Units of measurement for electric demand |
| Electric | Line Items | Table | List of electric charges |
| Electric | Meter Information | Table | List of electric meter information |
| Gas | Meter Number1 | String | Gas meter number |
| Gas | Tariff Name1 | String | Gas tariff name |
| Gas | Consumption1 | String | Gas consumption details |
| Gas | Consumption UOM1 | String | Units of measurement for gas consumption |
| Gas | Demand1 | String | Gas demand details |
| Gas | Demand UOM1 | String | Units of measurement for gas demand |
| Gas | Line Items | Table | List of gas charges |
| Gas | Meter Information | Table | List of gas meter information |
| Water | Meter Number1 | String | Water meter number |
| Water | Tariff Name1 | String | Water tariff name |
| Water | Consumption1 | String | Water consumption details |
| Water | Consumption UOM1 | String | Units of measurement for water consumption |
| Water | Demand1 | String | Water demand details |
| Water | Demand UOM1 | String | Units of measurement for water demand |
| Water | Line Items | Table | List of water charges |
| Water | Meter Information | Table | List of water meter information |
Coverage
- Majority USA Utility Provider
- Battle tested on
| Utility Companies |
|---|
| AEP Energy, Inc |
| Ameren Missouri |
| Appalachian Power |
| Atmos Energy |
| Atlantic Energy MD |
| CenterPoint Energy |
| Central Hudson Gas and Electric |
| City of Inglewood |
| City of Long Beach |
| City of North Las Vegas Utilities Department |
| Columbia Gas |
| Consolidated Edison Solutions, Inc. |
| Consumers Energy |
| Constellation New Energy Inc |
| Constellation NewEnergy, Inc. |
| Core Electric Cooperative |
| CPS Energy |
| Delta Natural Gas Co Inc |
| Direct Energy |
| Direct Energy Business |
| DTE Energy |
| Duke Energy |
| Duquesne Light Energy |
| EDF Energy Services |
| East Valley Water District |
| Engie Resources |
| Energy Plus Holdings |
| Entergy Texas Inc |
| Exelon Energy Company |
| First Energy |
| Golden State Water Company |
| Hudson Energy Services |
| KU a PPL Company |
| Long Island Power Solutions DBA New York Power Solutions |
| Los Angeles Department of Water & Power |
| National Grid Keyspan |
| New York State Electric & Gas |
| Northwest Natural |
| NRG Controllable Load Services |
| NV Energy |
| Ohio Edison |
| Orange and Rockland Utilities |
| Pacific Gas and Electric Company |
| Pacific Power |
| PECO Energy |
| Penelec, A FirstEnergy Company |
| Penn Power |
| Portland General Electric |
| PSEG Long Island |
| Puget Sound Energy |
| Reliant-NRG |
| Rochester Gas and Electric |
| Seattle City Light Bill |
| Snohomish County Public Utility District |
| Southern California Edison |
| Southern Federal Power |
| Southwest Gas |
| Spire |
| Tri-County Electric |
| Warren County Water District |
| Warren Rural Electric Cooperative Corporation |
| West Penn Power Co. |
| Xcel Energy |
The model might also work with other utility provide of US and other countries too. You can use this as a base model or fine-tune your own new model using just 50 samples. Here are the details: Fine-tune model on your data
Version
- Beta
Sample Utility Bill
Sample JSON Output
[
"data": {
"Basic Information": {
"Account Number": {
"value": "1234567890-00002",
"position": [
363,
241,
579,
266
],
"confidence": 1.0,
"review_required": false
},
"Customer Name": {
"value": "JOHN Q CUSTOMER",
"position": [
361,
286,
579,
308
],
"confidence": 1,
"review_required": false
},
"Vendor Name": {
"value": "We Energies",
"position": [
200,
1995,
341,
2029
],
"confidence": 0,
"review_required": true
},
"Invoice Name": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Service Address": {
"value": "123 MAIN ST",
"position": [
361,
314,
495,
336
],
"confidence": 1,
"review_required": false
},
"Service State": {
"value": "WI",
"position": [
481,
340,
508,
362
],
"confidence": 1,
"review_required": false
},
"Service City": {
"value": "ANYTOWN",
"position": [
361,
340,
475,
362
],
"confidence": 1,
"review_required": false
},
"Service Zip Code": {
"value": "53221",
"position": [
514,
340,
576,
362
],
"confidence": 1,
"review_required": false
},
"Previous Balance": {
"value": 220.35,
"position": [
1047,
397,
1127,
419
],
"confidence": 1,
"review_required": false
},
"Payment Received": {
"value": -220.35,
"position": [
1039,
422,
1127,
444
],
"confidence": 1,
"review_required": false
},
"Adjustments": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Balance Forward": {
"value": 0.0,
"position": [
1071,
448,
1127,
470
],
"confidence": 1,
"review_required": false
},
"Current Charges": {
"value": 253.78,
"position": [
1047,
472,
1128,
494
],
"confidence": 1,
"review_required": false
},
"Tax and Misc Charges": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Total Amount Due": {
"value": 253.78,
"position": [
1042,
241,
1132,
266
],
"confidence": 1,
"review_required": false
},
"Total Amount Due Line": {
"value": 67.1,
"position": [
1047,
1285,
1123,
1310
],
"confidence": 1,
"review_required": false
},
"Issue Date": {
"value": "02/03/2023",
"position": [
123,
241,
248,
266
],
"confidence": 1,
"review_required": false
},
"Service End Date": {
"value": "02/02/2023",
"position": [
1491,
336,
1602,
358
],
"confidence": 1,
"review_required": false
},
"Service Start Date": {
"value": "01/05/2023",
"position": [
1349,
336,
1460,
358
],
"confidence": 1,
"review_required": false
},
"Due Date": {
"value": "02/28/2023",
"position": [
1399,
241,
1524,
266
],
"confidence": 1,
"review_required": false
}
},
"Billing Information": {
"Customer Name": {
"value": "JOHN Q CUSTOMER",
"position": [
237,
1822,
438,
1852
],
"confidence": 0,
"review_required": true
},
"Customer Address": {
"value": "ANYTOWN WI 53221",
"position": [
237,
1890,
452,
1912
],
"confidence": 1,
"review_required": false
},
"Vendor Name": {
"value": "We Energies",
"position": [
200,
1995,
341,
2029
],
"confidence": 0,
"review_required": true
},
"Vendor Address": {
"value": "Stream IL 60197-6042",
"position": [
265,
2063,
513,
2097
],
"confidence": 0,
"review_required": true
}
},
"Electric": {
"Meter Number1": {
"value": "NZT123456",
"position": [
115,
592,
233,
614
],
"confidence": 1,
"review_required": false
},
"Tariff Name1": {
"value": "Residential Electric Service Rg1",
"position": [
50,
560,
388,
582
],
"confidence": 1,
"review_required": false
},
"Meter End Reading1": {
"value": 11126.0,
"position": [
889,
592,
951,
614
],
"confidence": 0,
"review_required": true
},
"Meter Start Reading1": {
"value": -10089.0,
"position": [
882,
618,
951,
640
],
"confidence": 1,
"review_required": false
},
"Consumption1": {
"value": 1037.0,
"position": [
901,
644,
951,
666
],
"confidence": 0,
"review_required": true
},
"Consumption UOM1": {
"value": "KWH",
"position": [
956,
644,
1007,
666
],
"confidence": 1,
"review_required": false
},
"Demand1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Meter Information": [
{
"Tariff Name": {
"value": "Residential Electric Service Rg1",
"position": [
50,
560,
388,
582
],
"confidence": 0.99,
"review_required": false
},
"Start Date": {
"value": "01/05/2023",
"position": [
1349,
336,
1460,
358
],
"confidence": 1.0,
"review_required": false
},
"End Date": {
"value": "02/02/2023",
"position": [
1491,
336,
1602,
358
],
"confidence": 1.0,
"review_required": false
},
"Meter End Reading": {
"value": 11126.0,
"position": [
889,
592,
951,
614
],
"confidence": 0.83,
"review_required": false
},
"Meter Start Reading": {
"value": -10089.0,
"position": [
882,
618,
951,
640
],
"confidence": 0.93,
"review_required": false
},
"Consumption": {
"value": 1037.0,
"position": [
901,
644,
951,
666
],
"confidence": 0.79,
"review_required": false
},
"Consumption UOM": {
"value": "KWH",
"position": [
956,
644,
1007,
666
],
"confidence": 0.95,
"review_required": false
},
"Demand": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
}
}
],
"Line Items": [
{
"Description": {
"value": "Customer Charge 29 Days at $0.49315",
"position": [
62,
702,
654,
724
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
702,
654,
724
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 14.3,
"position": [
978,
698,
1136,
724
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "Energy Charge 1,037 KWH at $0.16580",
"position": [
62,
728,
687,
750
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
728,
687,
750
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 171.93,
"position": [
978,
724,
1136,
750
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "Environmental Control Charge 1,037 KWH at $0.00043",
"position": [
62,
780,
687,
802
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
780,
687,
802
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 0.45,
"position": [
978,
775,
1136,
801
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "State Low Income Assistance Fee",
"position": [
62,
806,
398,
828
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
806,
398,
828
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 3.15,
"position": [
978,
801,
1136,
827
],
"confidence": 1.0,
"review_required": false
}
}
]
},
"Gas": {
"Meter Number1": {
"value": "0WG0987654",
"position": [
115,
964,
253,
986
],
"confidence": 1,
"review_required": false
},
"Tariff Name1": {
"value": "Residential Gas Service (WGC) Rg-1",
"position": [
50,
932,
433,
954
],
"confidence": 1,
"review_required": false
},
"Meter End Reading1": {
"value": 9668.0,
"position": [
901,
964,
951,
986
],
"confidence": 1,
"review_required": false
},
"Meter Start Reading1": {
"value": -9614.0,
"position": [
894,
990,
951,
1012
],
"confidence": 1,
"review_required": false
},
"Consumption1": {
"value": 54.0,
"position": [
925,
1016,
950,
1038
],
"confidence": 1,
"review_required": false
},
"Consumption UOM1": {
"value": "CCF",
"position": [
956,
1016,
1001,
1038
],
"confidence": 1,
"review_required": false
},
"Demand1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Meter Information": [
{
"Tariff Name": {
"value": "Residential Gas Service (WGC) Rg-1",
"position": [
50,
932,
433,
954
],
"confidence": 0.99,
"review_required": false
},
"Start Date": {
"value": "01/05/2023",
"position": [
1349,
336,
1460,
358
],
"confidence": 1.0,
"review_required": false
},
"End Date": {
"value": "02/02/2023",
"position": [
1491,
336,
1602,
358
],
"confidence": 1.0,
"review_required": false
},
"Meter End Reading": {
"value": 9668.0,
"position": [
901,
964,
951,
986
],
"confidence": 0.97,
"review_required": false
},
"Meter Start Reading": {
"value": -9614.0,
"position": [
894,
990,
951,
1012
],
"confidence": 0.98,
"review_required": false
},
"Consumption": {
"value": 54.0,
"position": [
925,
1016,
950,
1038
],
"confidence": 0.98,
"review_required": false
},
"Consumption UOM": {
"value": "CCF",
"position": [
956,
1016,
1001,
1038
],
"confidence": 0.99,
"review_required": false
},
"Demand": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
}
}
],
"Line Items": [
{
"Description": {
"value": "Customer Charge 29 Days at $0.33000",
"position": [
62,
1099,
654,
1121
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
1099,
654,
1121
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 9.57,
"position": [
986,
1092,
1141,
1119
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "Distribution 56.9 Therms at $0.3549",
"position": [
62,
1125,
685,
1147
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
1125,
685,
1147
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 20.19,
"position": [
986,
1119,
1141,
1145
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "Base Gas 56.9 Therms at $0.5088",
"position": [
62,
1177,
685,
1199
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
1177,
685,
1199
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 28.95,
"position": [
986,
1171,
1141,
1197
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "PGA 56.9 Therms at $0.13670 (27/29 Days)",
"position": [
62,
1203,
831,
1225
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
1203,
831,
1225
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 7.24,
"position": [
986,
1197,
1141,
1224
],
"confidence": 1.0,
"review_required": false
}
},
{
"Description": {
"value": "PGA 56.9 Therms at $0.29260 (2/29 Days)",
"position": [
62,
1229,
819,
1251
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
62,
1229,
819,
1251
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 1.15,
"position": [
986,
1224,
1141,
1250
],
"confidence": 1.0,
"review_required": false
}
}
]
},
]
Updated about 1 year ago