Convert Your Duquesne Light Bill to CSV

Upload a Duquesne Light Company bill PDF and get clean, structured data — total kWh, billing demand in kW, DLC distribution and supplier charges, billing period, and rate class — 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, PA · 1-800-555-0100

Statement · Page 1 of 3

SERVICE FOR

ACME RETAIL INC

100 Example Blvd
Sample City, PA 15000

Account # 1234567890

Bill date May 5, 2026

Rate class GM-Medium Comm > 25

Price to Compare $0.0850/kWh

AMOUNT DUE

$1,304.18

Due by May 24, 2026

Billing period: Apr 3 – May 3, 2026 · 30 days

Statement currency: USD

Account summary

Previous Account Balance	$1,210.55
Payment received — thank you	−$1,210.55
Balance forward	$0.00
New charges this period	$1,304.18
Total Amount Due	$1,304.18

Details of your electric charges

CHARGE	USAGE	RATE	AMOUNT
Customer Charge Fixed monthly · DLC service	1 mo	$52.00	$52.00
Distribution charges (DLC) Delivery over DLC poles & wires	8,420 kWh	$0.04200	$353.64
Demand charge Billing demand × rate	28 kW	$4.50	$126.00
Transmission charges	8,420 kWh	$0.01500	$126.30
Supply / Generation charge Supplier: Example Energy Co.	8,420 kWh	$0.06800	$572.56
Universal Service & PA riders	8,420 kWh	$0.00400	$33.68
PA gross receipts tax	—	—	$40.00
Total new charges			$1,304.18

Usage and demand this period

Billing demand 28 kW

Avg daily usage 281 kWh

Read type Actual

Total kWh usage 8,420 kWh

Service information

Meter number MTR-DL-0099812

Voltage 120/208V

Previous read · Apr 3 41,205

Current read · May 3 49,625

Price to Compare $0.0850/kWh

Rate class GM-Medium Comm > 25

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, tariff

Account number and rate class / tariff name (e.g. GM-Medium Commercial > 25)

previous_balance, payments_received, late_fee

Previous account balance and last period's payment

bill_new_charges

Charges accrued this billing period

commodity_supplier

Who supplied the electricity — separates DLC delivery from your competitive supplier under PA retail choice

max_kw, demand_unit

Billing demand and unit (kW) — drives demand charges on commercial rates

meter_total_volume, meter_total_unit, read_type

Total kWh consumption, unit, and actual vs estimated read

bill_total, bill_due_date

Amount due and payment due date

bill_start_date, bill_end_date, days_in_period, bill_frequency, currency

Billing period span and statement currency

utility_meter_serial_number, point_of_delivery_id

Physical meter serial and delivery point ID (with service voltage)

load_zone

Wholesale-market load zone (PJM sub-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 Duquesne Light bill means

Duquesne Light bills separate the cost of delivering your electricity (DLC Charges) from the cost of the energy itself (Supply Charges), then add demand, regulatory riders, and Pennsylvania taxes. Here's what each line means.

Customer Charge: A fixed monthly charge that covers the cost of connecting your service to Duquesne Light's grid — metering, billing, and basic account service — regardless of how much electricity you use. It appears under the DLC (delivery) portion of the bill and does not change with your usage.
Distribution charges (DLC Charges): The cost of moving electricity over Duquesne Light's local poles, wires, transformers, and substations to your meter. Duquesne Light always provides and bills distribution, even if you buy your energy from a competitive supplier under Pennsylvania's retail-choice program. This is the core of the DLC Charges section.
Supply / Generation charge: The cost of the electricity you actually used. If you take "default service" from Duquesne Light, DLC supplies this at the Price to Compare. If you've chosen a competitive supplier through PA Power Switch, that supplier's charge appears in the Supply Charges section instead — it's not an extra fee, the generation simply comes from your chosen supplier.
Transmission charges: The cost of carrying electricity over the high-voltage regional grid (operated within PJM) before it reaches Duquesne Light's local distribution system. It is billed per kWh and is part of the delivery side of your bill.
Demand charge: On commercial rate classes such as GM-Medium Commercial > 25, Duquesne Light bills a charge based on your Billing Demand — the highest 15- or 30-minute average power draw during the period, measured in kilowatts (kW). Two businesses using the same total kWh can pay different demand charges if one has sharper peaks.
Universal Service & PA riders: A set of per-kWh charges Duquesne Light collects on behalf of state programs and approved riders — including universal service and customer-assistance programs such as the Dollar Energy Fund, energy efficiency, and other Pennsylvania PUC-approved cost-recovery riders.
Pennsylvania gross receipts tax: A state tax on the utility's gross receipts that is passed through on your bill. It applies to the electric service Duquesne Light provides and is set by Pennsylvania law rather than by the utility.
Meter reads & voltage (Service Information): Not a charge, but the section that lists your meter number, service voltage (for example 120/208V), and the previous and current meter reads that determine your total kWh usage. This is where the meter reads UtilityBillReader extracts come from.

Frequently asked questions

What's the difference between the DLC Charges and Supply Charges on my Duquesne Light bill?

DLC Charges are the cost of delivering electricity over Duquesne Light's local distribution system — distribution, the customer charge, and related riders. Supply Charges are the cost of the energy itself, from either Duquesne Light's default service or a competitive supplier you chose under Pennsylvania retail choice. UtilityBillReader captures both sides separately, along with the supplier name, so the delivery-versus-supply split is preserved in your CSV.

What is the "Price to Compare" on my Duquesne Light bill?

The Price to Compare is the per-kWh supply rate Duquesne Light charges for default service. It's the number to weigh against competitive supplier offers on PA Power Switch. UtilityBillReader reads the Price to Compare ($/kWh) as a field so you can track it across months or compare it against quotes.

I switched to a competitive supplier under PA retail choice — does UtilityBillReader read both supplier and Duquesne Light charges?

Yes. When you buy energy from a competitive supplier through PA Power Switch, Duquesne Light bills only delivery (DLC Charges) and your supplier's generation charge appears in the Supply Charges section. UtilityBillReader reads the consolidated bill as a whole, capturing the supplier name, the tariff/rate class, and both the delivery and supply charges so nothing is lost.

Does UtilityBillReader capture how much electricity I used?

Yes — your total kWh usage for the billing period, the average daily kWh, and whether the read was actual or estimated. UtilityBillReader reports the period total and the previous and current meter reads it was calculated from.

My commercial bill shows a Billing Demand in kW — does UtilityBillReader pick that up?

Yes. On commercial rate classes like GM-Medium Commercial > 25, Duquesne Light bills a demand charge based on your peak Billing Demand in kilowatts (kW). UtilityBillReader captures the billing demand, its unit, the demand charge, and the rate class so the full commercial breakdown comes back structured.

What is my rate class, like GM-Medium Commercial > 25?

Duquesne Light assigns each account a rate class that determines the charges and whether demand is billed — for example a small commercial class versus GM-Medium Commercial > 25 for larger demand-metered accounts. UtilityBillReader extracts the rate class as a field so you can group or filter bills by tariff.

What format do I get back?

Two downloads off the same extraction. A base CSV gives you one row per meter with a column for every field — utility, account, addresses, billing period, usage, billing demand, cost, and rate class — 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 (distribution, supply, transmission, riders, taxes) 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 Duquesne Light accounts or sites — and get them back in one structured file, one row per meter. This is the common workflow for bookkeepers and property managers reconciling utility 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 Duquesne Light 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 Duquesne Light 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 DLC-versus-supply charge breakdown straight into a CSV ready to import into Xero or QuickBooks, instead of keying Duquesne Light expenses by hand.

Multi-site & tenant rebilling

Property managers and operators with several Duquesne Light accounts can extract usage, billing demand, and cost per meter, producing a clean per-site or per-tenant breakdown for cost recovery.

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.

Demand & usage analysis

Compare total kWh, billing demand in kW, and the cost breakdown across months to see how your usage, peaks, and Price to Compare change over time.

Convert bills from other utilities

PG&E · SoCal Edison · PECO · PPL Electric · West Penn Power · Penelec · Met-Ed · BGE · ComEd · PSE&G

External resources

Ready to convert your Duquesne Light 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