Hydro Bill Comparison Excel - Free Template

1. Open the Bill Data sheet and start at row 5. Keep the sample records or replace them with your own bills; the workbook has prepared rows through row 104.
2. Enter the Bill ID, customer name, city, province and utility provider exactly as shown on the bill. Select the province from the list rather than typing a different spelling.
3. Enter the billing period start and end dates in YYYY-MM-DD format, followed by electricity usage in kWh and the four charge components.
4. Enter the prior-period bill when you want a comparison, then select Paid, Unpaid or Disputed in Payment Status and add a concise note if needed.
5. Leave calculated columns M through Q and S through T unchanged. Their formulas calculate the subtotal, tax rate lookup, tax, total, effective cost per kWh and bill movement.
6. Open Dashboard to review the updated KPIs, city and utility table, bill composition and charts. Use Instructions to confirm the tax reference values before relying on a comparison.

A household member usually opens this spreadsheet when winter consumption rises, a rental property changes occupants or a utility provider bill looks unusually high. An office manager at a trades company can use it for several locations, while a bookkeeper can review electricity costs before preparing the monthly income statement or discussing overhead with an owner.

Comparing real billing periods

Suppose a Toronto home records 820 kWh from 2026-01-01 to 2026-01-31. The bill includes $76.20 of electricity charges, $32.90 delivery, $5.10 regulatory charges and an $11.50 fixed charge, producing a $125.70 pre-tax subtotal before the Ontario tax lookup is applied. Comparing that result with a prior-period bill of $136.80 shows whether the change came from usage or from the bill’s other components.

The same approach works for a small business with four employees and two premises. Entering each location as a separate record lets you compare usage and total bills without mixing a workshop’s electric heaters with an office’s normal load.

Using the city comparison

The Dashboard lists cities and providers such as Toronto Hydro, Hydro Ottawa, Hydro-Québec, BC Hydro, ENMAX and EPCOR. It calculates the number of bills, average usage, average total bill, average cost per kWh and lowest monthly bill for each listed city.

For an online retailer operating from a warehouse, 12 monthly records can reveal that a $410 bill is not necessarily inefficient if usage was 3,500 kWh, whereas a $260 bill for 1,200 kWh may have a higher effective unit cost. Use the kWh measure alongside the dollar total; my preference is to investigate cost per kWh first, then examine fixed and delivery charges.

Electricity bills can show GST, HST or another provincial treatment, so you should copy the charge and tax information from the bill rather than assume every province uses the same rate. The workbook’s Instructions lookup contains 13% for Ontario, 15% for Nova Scotia, New Brunswick, Newfoundland and Labrador and Prince Edward Island, 14.975% for Quebec, and 5% for British Columbia, Alberta and Manitoba.

What the lookup actually does

When you select Ontario in Bill Data column D, the formula in column N uses VLOOKUP against Instructions F5:G13 and returns 13%. If the pre-tax subtotal is $125.70, the calculated tax is $16.34 and the total is $142.04 after rounding for display. The lookup values are editable reference values, not a replacement for checking the tax printed on the bill.

The workbook does not determine whether a charge is taxable, apply rebates or reconcile a utility statement to a CRA filing. A registered business claiming an input tax credit needs the original invoice and proper support; this spreadsheet is a comparison and monitoring tool.

Records for Canadian businesses

A sole proprietor normally considers electricity in the business-use portion of the T2125, while an incorporated company records the appropriate business expense in its books. If a home office uses 20% of a $200 monthly bill, the potentially relevant business portion is $40, subject to the applicable expense rules and supporting records.

Keep utility invoices and working papers for the CRA’s six-year record-retention period. If your business is registered for GST/HST, retain the bill showing the supplier, date, taxable amounts and tax; do not treat the workbook’s tax lookup alone as documentary evidence. My firm preference is to preserve the PDF or paper bill beside the spreadsheet, especially at fiscal year-end.

The most expensive mistake is entering the total bill into one charge column and leaving the other components empty. You may still obtain a total, but you lose the ability to explain why delivery, regulatory or fixed charges changed. On a $200 bill, misclassifying $35 of delivery as electricity makes a later rate review misleading even if the arithmetic appears correct.

Usage and date errors

A meter reading can cover 29 days in one month and 34 days in the next. Comparing $180 against $165 without checking the billing period can suggest a price increase when the second bill simply covers five extra days. The workbook records both billing dates, so use them before concluding that a provider or property is becoming more expensive.

Another common error is entering 820 as 8.20 kWh or leaving usage blank. The effective cost per kWh then becomes meaningless: a $142.04 bill divided by 8.20 produces $17.32 per kWh instead of approximately $0.17. Check the bill’s unit and decimal placement before reviewing the Dashboard.

Tax and prior-period problems

Users sometimes overwrite the calculated tax amount or total bill with a figure copied from the invoice. That breaks the comparison between the workbook’s component totals and the provider’s total. Enter the pre-tax components and prior-period bill, then investigate any difference rather than hiding it in a calculated cell.

Do not enter a prior-period value of $0 unless the previous bill genuinely had no amount. The percentage-change formula deliberately leaves the result blank when the prior bill is zero, because a percentage increase from zero is not a useful operating measure.

Finally, selecting the wrong province applies the wrong lookup rate. A $300 subtotal using 13% instead of 5% creates a $24 tax difference. Correct the province and verify the tax printed on the bill before using the result in a budget, tenant allocation or business expense review.

Make the spreadsheet part of the same routine as paying the utility bill. Set aside 10 minutes when each statement arrives: save the invoice, enter one Bill Data row, compare the prior-period amount and change Payment Status to Paid after the payment clears.

Use a fixed entry sequence

• Enter dates and kWh first, because they provide the period and volume context.
• Copy each charge component from the bill, without combining delivery or regulatory amounts.
• Enter the prior-period total and add a note for unusual weather, a vacancy, renovation or a meter issue.
• Open Dashboard after every entry and investigate a sharp change rather than waiting for year-end.

For a property with six units, entering six monthly records takes 72 rows per year, leaving 28 prepared rows. That capacity is adequate for one year of six-unit tracking, but not for a portfolio that adds properties every month. My practical preference is one workbook per property or reporting cycle once the rows become difficult to audit.

Protect the calculations

Keep the yellow input cells separate from calculated columns M through Q and S through T. Use the existing province and status lists so entries remain consistent; Ontario and ON, for example, must not become two categories in a later manual review.

At month-end, compare the Dashboard’s total taxes and average monthly bill with your payment records. If the workbook becomes a shared file containing names and addresses, remove unnecessary personal information and apply PIPEDA safeguards. Move to accounting or utility-management software when you need automated bill imports, user permissions, meter-reading history, allocations or more than the prepared 100 records.