Ontario electricity
Ontario electricity bills, broken down and exported to Excel
Ontario electricity bills come from dozens of local utilities, including Hydro One, Toronto Hydro and Alectra, and every one lays its bill out differently. Underneath, they share the same building blocks set by the Ontario Energy Board and the IESO: an energy charge that depends on your price plan, the Global Adjustment, delivery and regulatory charges, HST and the Ontario Electricity Rebate.
This page explains what each part of an Ontario bill means, and how EnergyExtract turns the PDFs into one consistent Excel table you can use for budgeting, benchmarking and reporting.
What's on an Ontario electricity bill
Electricity (energy)
The price of the electricity itself. On the Regulated Price Plan it is split by price plan: on-peak, mid-peak and off-peak for time-of-use; an ultra-low overnight period (plus weekend off-peak) for ULO; or Tier 1 and Tier 2 for tiered pricing. Customers on a retailer contract or the market price see a contract or market energy line instead.
Global Adjustment
Not a separate line on Regulated Price Plan bills, because it is built into the prices the Ontario Energy Board sets. Other customers see it on its own: Class B as a per-kWh charge, Class A as their share of the cost based on peak demand.
Delivery
Getting electricity to the building: a fixed customer or service charge, distribution charges, and transmission network and connection charges. Line losses are usually reflected by a loss factor, so the billed (adjusted) kWh is slightly higher than the metered kWh.
Regulatory
Charges that run the electricity system, such as the Wholesale Market Service charge, the Smart Metering Entity charge and the Standard Supply Service administration charge.
Demand
For larger general service accounts: billed kW or kVA, with distribution and transmission charged on demand as well as kWh.
HST and Ontario Electricity Rebate
HST is added to the bill, and eligible accounts get the Ontario Electricity Rebate as a credit. The rebate percentage is set by the province and changes from time to time.
The Global Adjustment, explained
The Global Adjustment covers the cost of building and maintaining Ontario's generation, and of conservation programs, on top of the wholesale market price. How it shows up depends on who you are:
- Regulated Price Plan customers (most homes and small businesses) pay it inside their time-of-use, ULO or tiered prices. There is no separate line.
- Class B customers not on the Regulated Price Plan, including those with a retailer contract, pay a per-kWh Global Adjustment rate published monthly by the IESO, shown as its own line.
- Class A customers pay a share based on their peak demand factor: their contribution to the five highest peak hours of the May 1 – April 30 base period. Facilities averaging over 5 MW qualify automatically; those over 1 MW, and some manufacturing, industrial and greenhouse facilities over 500 kW, can opt in.
Because Class A costs depend on a handful of hours a year, tracking demand and Global Adjustment month by month across all your accounts is one of the most useful things to have in a spreadsheet.
Hydro One, Toronto Hydro, Alectra: same parts, different layouts
Each utility labels and groups charges its own way. One bill shows a single delivery total, another itemizes distribution, transmission and line losses; one prints the regulatory charges separately, another rolls them up. General service accounts add demand and power factor. Retyping these into a spreadsheet means deciding, bill by bill, which number goes in which column.
EnergyExtract reads each bill and maps every line to a fixed set of columns, so a Hydro One bill and a Toronto Hydro bill end up side by side in the same table, ready for Excel, Power Query or Power BI.
What you get in Excel
A sample of the Ontario export for a time-of-use account (illustrative values, not current prices). Columns for ULO, tiered, demand and Class A or Class B Global Adjustment sit alongside, and columns a bill doesn't use are hidden.
| provider | billing_period_start | billing_period_end | rate_class | consumption | On Peak kWh | On Peak Rate | On Peak Cost | Mid Peak kWh | Mid Peak Cost | Off Peak kWh | Off Peak Cost | Delivery Charges | Regulatory Charges | HST | Ontario Electricity Rebate | total_due |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Toronto Hydro | 2026-09-01 | 2026-09-30 | tou | 750 | 150 | 0.2000 | 30.00 | 140 | 21.98 | 460 | 45.08 | 52.40 | 7.10 | 20.35 | -20.51 | 156.40 |
- Metered and adjusted kWh, loss factor and meter readings, so usage can be checked against the bill.
- Mid-period price changes kept as printed, with the change date and the days at each price.
- Checks for duplicate bills, missing billing periods and bills whose own figures don't add up.
- One row per bill and the same columns every time, so a Power Query or Power BI file keeps working as you add months.
Questions
Why is there no Global Adjustment line on my bill?
If you are on the Regulated Price Plan (time-of-use, ULO or tiered), the Global Adjustment is already included in your electricity prices. A separate Global Adjustment line appears on bills for customers who are not on the Regulated Price Plan, including those with a retailer contract.
Does it handle Class A and Class B bills?
Yes. Class B bills get the Global Adjustment rate and total cost alongside the market energy price. Class A bills get the Global Adjustment billed amount and peak demand factor, plus kW and kVA demand.
What happens when prices change partway through a billing period?
Bills that straddle a price change usually print the same charge twice, at the old and new prices. EnergyExtract keeps both, records the change date and the days in each period, and still totals the charge in one column.
Can I mix Ontario bills with bills from other provinces?
Yes. An export that contains only Ontario bills uses a dedicated Ontario layout with full time-of-use and Global Adjustment detail. If an export includes bills from other provinces, every bill goes into one national layout so they can sit in the same table.
Which Ontario utilities are supported?
Bills from any Ontario local distribution company, including Hydro One, Toronto Hydro, Alectra, Hydro Ottawa and Elexicon. Layouts and labels differ between utilities, but each line is mapped to the same columns.
Try it on your own Ontario bills
12 free credits on signup, no credit card required. Each credit covers one bill of up to 4 pages.
Start free trialSources: IESO, Global Adjustment and Global Adjustment Class A eligibility. Related: Data privacy FAQ.