Utility Bill
Utility bills are monthly or periodic invoices sent to individuals or businesses for the consumption of public services.
API Upload
The type parameter is utility_bill 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
Sample JSON Output
{
"data": {
"Basic Information": {
"Account Number": {
"value": "1234",
"position": [
1152,
144,
1297,
161
],
"confidence": 1.0,
"review_required": false
},
"Customer Name": {
"value": "XXXXX Technology",
"position": [
158,
548,
482,
574
],
"confidence": 1.0,
"review_required": false
},
"Vendor Name": {
"value": "Spire",
"position": [
1101,
1884,
1158,
1906
],
"confidence": 1.0,
"review_required": false
},
"Invoice Name": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Service Address": {
"value": "1945 Jersey Rd",
"position": [
1153,
174,
1308,
194
],
"confidence": 1.0,
"review_required": false
},
"Service State": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Service City": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Service Zip Code": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Previous Balance": {
"value": 58.07,
"position": [
1509,
348,
1570,
365
],
"confidence": 1.0,
"review_required": false
},
"Payment Received": {
"value": -58.07,
"position": [
1494,
379,
1571,
402
],
"confidence": 1.0,
"review_required": false
},
"Adjustments": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Balance Forward": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Current Charges": {
"value": 242.35,
"position": [
1493,
416,
1570,
433
],
"confidence": 1.0,
"review_required": false
},
"Taxes and Misc Charges": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Total Amount Due": {
"value": 242.35,
"position": [
487,
1788,
590,
1811
],
"confidence": 1.0,
"review_required": false
},
"Issue Date": {
"value": "08/03/2023",
"position": [
1151,
114,
1288,
131
],
"confidence": 1.0,
"review_required": false
},
"Service End Date": {
"value": "07/31/2023",
"position": [
347,
914,
481,
937
],
"confidence": 1.0,
"review_required": false
},
"Service Start Date": {
"value": "07/06/2023",
"position": [
176,
915,
309,
938
],
"confidence": 1.0,
"review_required": false
},
"Due Date": {
"value": "08/14/2023",
"position": [
1462,
516,
1569,
535
],
"confidence": 1.0,
"review_required": false
}
},
"Electric": {
"Meter Number1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Tariff Name1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Consumption1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Consumption UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Line Items": [],
"Meter Information": []
},
"Gas": {
"Meter Number1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Tariff Name1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Consumption1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Consumption UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Line Items": [
{
"Description": {
"value": "Customer Charge",
"position": [
74,
941,
579,
968
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
74,
941,
579,
968
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 145.43,
"position": [
579,
941,
830,
968
],
"confidence": 0.9892672101656595,
"review_required": false
}
},
{
"Description": {
"value": "Usage : 69 @ $0.15689",
"position": [
74,
968,
579,
994
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": 69.0,
"position": [
74,
968,
579,
994
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 10.83,
"position": [
579,
968,
830,
994
],
"confidence": 0.993079948425293,
"review_required": false
}
},
{
"Description": {
"value": "Pipeline Upgrade Charge (ISRS)",
"position": [
74,
994,
579,
1021
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
74,
994,
579,
1021
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 2.67,
"position": [
579,
994,
830,
1021
],
"confidence": 0.9886123090982437,
"review_required": false
}
},
{
"Description": {
"value": "Usage",
"position": [
74,
1050,
579,
1078
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
74,
1050,
579,
1078
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 53.54,
"position": [
579,
1050,
830,
1078
],
"confidence": 0.9894915223121643,
"review_required": false
}
},
{
"Description": {
"value": "Sales Tax",
"position": [
74,
1107,
579,
1134
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
74,
1107,
579,
1134
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 8.53,
"position": [
579,
1107,
830,
1134
],
"confidence": 0.9907745271921158,
"review_required": false
}
},
{
"Description": {
"value": "State Tax",
"position": [
74,
1134,
579,
1161
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
74,
1134,
579,
1161
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 8.98,
"position": [
579,
1134,
830,
1161
],
"confidence": 0.9901701360940933,
"review_required": false
}
},
{
"Description": {
"value": "Maryland Hts Tax",
"position": [
74,
1161,
579,
1188
],
"confidence": 1.0,
"review_required": false
},
"Quantity": {
"value": "",
"position": [
74,
1161,
579,
1188
],
"confidence": 1.0,
"review_required": false
},
"Charges": {
"value": 12.37,
"position": [
579,
1161,
830,
1188
],
"confidence": 0.9921892285346985,
"review_required": false
}
}
],
"Meter Information": [
{
"Meter Number": {
"value": "",
"position": [],
"confidence": 1.0,
"review_required": false
},
"Tariff Name": {
"value": "Large General Service",
"position": [
483,
851,
720,
875
],
"confidence": 0.91,
"review_required": false
},
"Start Date": {
"value": "07/06/2023",
"position": [
176,
915,
309,
938
],
"confidence": 0.89,
"review_required": false
},
"End Date": {
"value": "07/31/2023",
"position": [
347,
914,
481,
937
],
"confidence": 0.97,
"review_required": false
},
"Consumption": {
"value": 69.0,
"position": [
438,
819,
467,
837
],
"confidence": 0.94,
"review_required": false
},
"Consumption UOM": {
"value": "(CCF)",
"position": [
410,
782,
471,
804
],
"confidence": 0.94,
"review_required": false
},
"Demand": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Charge": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
}
}
]
},
"Water": {
"Meter Number1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Tariff Name1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Consumption1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Consumption UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Demand UOM1": {
"value": "",
"position": [],
"confidence": 0,
"review_required": true
},
"Line Items": [],
"Meter Information": []
}
}
}
Updated 6 months ago