Convert Your ComEd Bill to CSV

Upload a ComEd (Commonwealth Edison) bill PDF and get clean, structured data — total kWh, electricity supply and delivery charges, billing period, and per-meter rows — in about 30 seconds.

5/5 Pages

Anatomy of bill fields extracted

Upload a PDF, get clean CSV. Below is a sample electric statement with the structured fields you get back, labelled with their CSV column names.

EXAMPLE ENERGY CO.

P.O. Box 0000 · Sample City, IL · 1-800-555-0100

Statement · Page 1 of 3

SERVICE FOR

ACME RETAIL INC

100 Example Blvd
Sample City, IL 60000

Account # 01 23 45678 9001

Issued May 5, 2026

Supply ComEd default service

Rate Retail Delivery Service – 0 to 100 kW

AMOUNT DUE

$545.80

Due by May 24, 2026

Service from: Apr 3 – May 3, 2026 · 30 days

Statement currency: USD

Account summary

Previous balance	$402.15
Payment received — thank you	−$402.15
Balance forward	$0.00
New charges this period	$545.80
Total amount due	$545.80

Details of your electric charges

CHARGE	USAGE	RATE	AMOUNT
Customer Charge Fixed monthly · grid connection (Delivery)	—	—	$20.50
Electricity Supply Charge Supplier: ComEd default service	4,240 kWh	$0.07200	$305.28
Transmission Services Charge Moving power across the high-voltage grid	4,240 kWh	$0.01400	$59.36
Purchased Electricity Adjustment PEA · true-up, can be negative	4,240 kWh	−$0.00200	−$8.48
Standard Metering Charge Meter reading & billing (Delivery)	—	—	$7.20
Distribution Facilities Charge Billed on peak demand (Delivery)	18 kW	$4.50	$81.00
IL Electricity Distribution Charge Per-kWh delivery charge	4,240 kWh	$0.01100	$46.64
Taxes and other Environmental Cost Recovery, RPS, ZES & utility taxes	—	—	$34.30
Total new charges			$545.80

Usage this period

Peak demand 18 kW

Read type Actual

Total usage 4,240 kWh

Service information

Meter number MTR-6602184

Multiplier 40

Previous read · Apr 3 13,300

Current read · May 3 13,406

Supply type ComEd default

Rate class RDS 0–100 kW

utility_name, utility_phone

Utility issuer and contact number

customer_name, service_street1, service_city, service_state, service_zip

Service address where power is delivered

service_account_number, bill_service_agreement_number, tariff

ComEd account number and delivery-service rate class

previous_balance, payments_received, late_fee

Carry-over balance and last period's payment

bill_new_charges

New charges accrued this billing period

commodity_supplier

Who supplied the electricity — separates ComEd default service from a Retail Electric Supplier under Illinois choice

max_kw, demand_unit

Peak demand and unit (kW) — drives the Distribution Facilities charge on commercial bills

meter_total_volume, meter_total_unit, read_type

Total consumption, unit (kWh / therms / MJ / kL), and actual vs estimated read

bill_total, bill_due_date

Total amount due and payment due date

bill_start_date, bill_end_date, days_in_period, bill_frequency, currency

Service period span and statement currency

utility_meter_serial_number, point_of_delivery_id

Physical meter serial and grid delivery point ID

load_zone

Wholesale-market load zone (PJM / ComEd zone)

50+ structured fields per bill — including extraction metadata (extraction_status, extraction_confidence, source_filename ) — exported as CSV that opens directly in Excel, Google Sheets, or any accounting tool.

What every charge on your ComEd bill means

ComEd (Commonwealth Edison) bills split into two big halves — Electricity Supply Services (the cost of the power itself) and Delivery Services (moving it to you over ComEd's wires) — then add a set of state-mandated taxes and adjustments. Here's what each line means.

Electricity Supply Charge: The cost of the electricity you actually used, billed per kWh. Illinois has retail electric choice, so this can come from ComEd's default supply service or from a Retail Electric Supplier (RES) you chose — you can compare offers at pluginillinois.org. Either way it sits in the Electricity Supply Services section, separate from delivery. If you've switched to a RES, this line is replaced by your supplier's charge and ComEd bills only delivery.
Capacity & Transmission Services Charge: Part of supply: the cost of reserving generation capacity in the PJM market and moving power across the high-voltage transmission grid to ComEd's local system. Capacity is typically billed per kW and transmission per kWh. These are pass-through costs ComEd or your RES collects on behalf of the regional grid operator.
Purchased Electricity Adjustment (PEA): A true-up line that reconciles what ComEd's default supply actually cost against what it charged. It can be positive or negative — a negative PEA lowers your bill. It only appears for customers on ComEd default service, not for those buying from a Retail Electric Supplier.
Customer Charge: A fixed monthly charge in the Delivery Services section that covers the cost of connecting your account to ComEd's grid — your service line, account maintenance, and billing — regardless of how much electricity you use. ComEd always bills this, even when a Retail Electric Supplier provides your supply.
Standard Metering Charge: A fixed delivery charge covering the cost of the meter and reading it. On accounts that lease their meter, a separate Meter Lease line can appear instead of or alongside this charge.
Distribution Facilities Charge: The core delivery charge for ComEd's local poles, wires, and transformers. On small-commercial and larger accounts it is billed on peak demand in kW (the highest 30-minute draw in the period), which is why a demand reading shows up on those bills. Residential and very small accounts are billed per kWh instead.
IL Electricity Distribution Charge: A per-kWh delivery charge set by the Illinois Commerce Commission (ICC) that recovers ComEd's approved distribution-system revenue. It sits alongside the Distribution Facilities Charge in the Delivery Services section.
Taxes and other charges: A group of state-mandated riders and taxes ComEd collects: the Environmental Cost Recovery Adjustment, the Renewable Portfolio Standard charge, the Zero Emission Standard charge, any Meter Lease, plus state and municipal utility taxes (the Illinois Electricity Excise Tax and your city's utility tax). These are itemized near the bottom of the bill.

Frequently asked questions

My ComEd bill separates supply from delivery — does UtilityBillReader keep them straight?

Yes, and this is the defining structure of a ComEd bill. ComEd splits charges into Electricity Supply Services (the power itself, plus transmission, capacity, and the Purchased Electricity Adjustment) and Delivery Services (the Customer Charge, metering, and distribution charges that move power over ComEd's wires). UtilityBillReader captures the supplier and keeps each side's charges distinct in your CSV, so you can see exactly what is supply and what is delivery rather than collapsing everything into one total.

I buy my electricity from a Retail Electric Supplier, not ComEd — can UtilityBillReader read that bill?

Yes. Illinois has retail electric choice, so your supply can come from ComEd's default service or from a Retail Electric Supplier (RES) you picked at pluginillinois.org. When you're on a RES, ComEd bills only delivery and your supplier's charge replaces ComEd's supply line. UtilityBillReader reads both the ComEd-supplied bill and the alternate-supplier bill, capturing the supplier name and both the supply and delivery charges.

Does this work for residential ComEd bills, or only commercial?

Both. The sample above is a small-commercial bill with a demand-based Distribution Facilities charge, but UtilityBillReader reads residential ComEd bills just as well — they carry the same supply-vs-delivery split, just without the kW demand charge. Usage, billing period, rate, and the full charge breakdown all come back the same way.

Does UtilityBillReader capture how much electricity I used?

Yes — your total usage for the service period in kWh, the meter multiplier, and whether the read was actual or estimated. ComEd's Meter Information table lists register reads and a multiplier; UtilityBillReader reports the period total and notes the read type.

What is the Purchased Electricity Adjustment (PEA), and does it handle a negative value?

The PEA is a true-up that reconciles ComEd's actual default-supply cost against what it billed, so it can be positive or negative. UtilityBillReader captures the PEA with its sign — a negative PEA is read as a credit that lowers the total — so your extracted charges reconcile back to the bill total.

I run a business — does UtilityBillReader handle demand charges and commercial bills?

Yes. UtilityBillReader fully supports ComEd commercial bills, including peak demand in kW that drives the Distribution Facilities Charge, rate classes like Retail Delivery Service – 0 to 100 kW and Commercial Hourly, the meter multiplier, and the full supply-and-delivery breakdown. Each meter comes back as its own row.

What format do I get back?

Two downloads off the same extraction. A base CSV gives you one row per meter or service with a column for every field — utility, account, addresses, billing period, usage, cost, and rate — and opens directly in Excel, Google Sheets, or any accounting tool. An advanced Excel (.xlsx) workbook adds a second sheet of per-line charge detail (supply vs delivery splits, individual taxes and riders) keyed back to the first sheet so you can reconcile or pivot without losing structure.

Can I convert several bills at once?

Yes. Upload multiple bills — a year of statements, or bills across several properties — and get them back in one structured file, one row per meter. This is the common workflow for bookkeepers and property managers reconciling ComEd costs in bulk.

How accurate is UtilityBillReader?

Every extraction returns a confidence score and flags anything worth a second look, such as a bill covering multiple meters. UtilityBillReader lays each field out next to a clear label so it's quick to check the output against your original ComEd bill, and the confidence score tells you where to look first.

Do I need an account, and is UtilityBillReader really free?

You can convert your first 5 pages every day with no account — just upload and download. Paid plans add higher volumes for regular or bulk use, but there's no signup wall to try UtilityBillReader or handle a one-off ComEd bill.

Does UtilityBillReader work on my phone?

Yes. UtilityBillReader works in your phone's browser, so you can convert a bill from a photo or PDF without being at a computer.

What file types can I upload, and is my data secure?

PDF bills, digital or scanned, including multi-page bills in a single upload. Files uploaded without an account are deleted within 24 hours rather than stored indefinitely; account uploads follow your plan's retention window.

Use cases

Bookkeeping & accounting

Pull the total, billing period, and supply-vs-delivery charge breakdown straight into a CSV ready to import into Xero or QuickBooks, instead of keying ComEd utility expenses by hand.

Multi-site & tenant rebilling

Businesses and property managers running several ComEd meters or accounts can extract usage and cost per meter, producing a clean per-site breakdown for cost recovery and budgeting.

ESG & Scope 2 reporting

Extract actual kWh as activity data for greenhouse-gas accounting under the GHG Protocol — more accurate than estimating emissions from the dollar amount alone.

Supplier-switch analysis

Compare the supply charge across ComEd default service and a Retail Electric Supplier, month over month, to see whether switching at pluginillinois.org actually saved money once delivery is held constant.

Convert bills from other utilities

PG&E · SoCal Edison · PECO · BGE · Pepco · Atlantic City Electric · Delmarva Power · Ameren Illinois · Dynegy · Constellation

External resources

Ready to convert your ComEd bill?

Drop your PDF here — first 5 pages today are free, no account needed.

Need more than 5 pages a day?

Create an account to process more bills every month, keep your bill history, and share with teammates.

🚀 SIGN UP NOW

Last reviewed 28 June 2026