# Utility Bill PDF to Excel: Usage and Charges by Month

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Other financial documents
- Canonical: https://fastbankconvert.com/blog/utility-bill-pdf-to-excel

> Turn a utility bill PDF to Excel: pull usage, rates and charges from each bill, build a month-by-month table, and handle estimated readings.
To turn a utility bill PDF to Excel, take a small set of values from each bill rather than the whole page: the billing period dates, the meter reading type, the usage, and the current charges. Put one bill per row, then add days in the period and cost per unit so uneven months and estimated readings compare fairly.

## What on a utility bill PDF belongs in Excel?

A utility bill PDF mixes a few useful numbers with a lot of print you never need in a sheet. The useful ones are the service period, the meter readings, the usage, the rate lines and the current charges. Marketing panels, payment slips, usage bar charts and contact details stay on the PDF.

Most utility bills follow a similar shape, whatever the service. The first page carries the account summary and the amount due. A detail section lists the meter, the previous and current readings, the usage between them, and then the line items that make up the charge. Water, gas and electric bills all do this, only with different units.

### Fields worth keeping

From each bill, keep:

- **Service period**: the start and end dates of the reading period.
- **Reading type**: whether the current reading was actual or estimated.
- **Previous and current readings**: the two meter numbers.
- **Usage**: the difference, in kWh, therms, cubic feet, gallons or whatever unit the bill prints.
- **Current charges**: the total for this period only.
- **Line items**, if you want to track them: a fixed customer charge, usage charges, taxes and fees.

### Why copy and paste goes wrong here

Utility bills are designed to be read, not parsed. Values sit inside shaded boxes, labels and numbers share a line, and charts sit beside tables. A pasted page tends to come out as one column of mixed text and numbers. Picking the handful of fields by hand, or with a tool that reads a fixed box on each bill, is usually quicker than cleaning a full paste.

A bill is closer to an invoice than to a statement: one document, one total, a short list of line items. The same field-picking approach works on [purchase orders turned into Excel line items](/blog/purchase-order-pdf-to-excel), where you also want a header row of key values plus the lines underneath.

## Usage, rate and charge columns for a utility bill sheet

A utility bill sheet needs usage and money in separate columns, with the unit in the header rather than in the cell. Put kWh, therms or gallons in one column, the current charges in another, and derive cost per unit with a formula. That keeps every cell a real number Excel can sum and chart.

### A column layout

| Column | Example header | Notes |
| --- | --- | --- |
| A | Period start | Real date |
| B | Period end | Real date |
| C | Days | `=B2-A2` |
| D | Reading | Actual or Estimated |
| E | Usage (kWh) | Number only, no unit text |
| F | Current charges | This period only |
| G | kWh per day | `=E2/C2` |
| H | Cost per kWh | `=F2/E2` |

### Fixed charges and tiered rates

Many bills combine a fixed monthly charge with a per-unit charge. Some add tiers, where the first block of usage is billed at one rate and the rest at another. Do not try to copy the tier table into every row. The cost per unit column already shows the combined effect: in a low-usage month, the fixed charge is spread over fewer units, so the cost per unit goes up even though the rate did not change.

If you want the fixed charge on its own, give it its own column and enter it from the line items. Then `(F2-I2)/E2` gives the usage-only rate, which is the number to compare against a new tariff or another supplier's offer.

### Several services on one bill

A combined gas and electric bill holds two meters and two sets of charges. Use two sets of columns, one per service, or two rows per bill with a Service column. Two rows per bill is easier to pivot. Never put both usages in one column, since kWh and therms cannot be added together.

## Is an estimated utility bill reading safe to total?

An estimated utility bill reading is a guess by the utility, made when nobody read the meter. Its charges are real money you paid, so the money column is safe to total. The usage is not reliable on its own, because the next actual reading corrects it, often by moving units into the following bill.

Bills usually mark an estimated reading with a letter or a word beside the meter number, such as E or Estimated. Look for that mark on each bill before you type its usage. Put Actual or Estimated in the Reading column every time, not only when you notice an estimate, so a filter shows them all.

### What the correction looks like

Suppose one month's reading was estimated high and the next month's was actual. The second bill measures from the estimated number to the real meter number, so its usage comes out low. Neither month is right on its own. Added together, they are exactly right, because the actual reading at the end fixes the total.

That gives a simple rule. When an estimate appears, judge usage over the estimated bill and the next actual bill together. Charts of monthly usage will show a spike and a dip around the estimate. That pattern is the reading correcting itself, not a change in how much you used.

### Corrected or rebilled periods

Sometimes a utility reissues a bill for an earlier period, with a credit for the old charge and a new charge. Enter the rebill as its own row with a note, and keep the original row. If you delete the original, your payment history and the charges on the sheet stop matching.

## Utility billing periods that do not match calendar months

Utility billing periods usually run from one meter reading to the next, so they cover anything from about 28 to 34 days and rarely start on the first of the month. Comparing raw usage between bills mixes length with consumption. Divide usage by the days in the period, and compare usage per day instead.

### Naming the month

You still need a month label for reports. Pick one rule and keep it. Using the month of the period end date is common, because that is roughly when the bill arrives. Using the month that holds most of the period is more accurate for seasonal comparisons. Either is fine if every row uses the same rule.

### Splitting a bill across months

For budgets that must be by calendar month, split each bill by days. A period from March 9 to April 7 has 23 days in March and 6 in April, counting the start date and not the end date. Multiply the charges by 23/29 for March and 6/29 for April. Do it in formulas rather than by hand, so a change to a date updates both parts. This matters most for a business that reports by calendar month, since the books expect costs in the month they were used.

## Past-due balances that inflate a utility bill total

The amount due on a utility bill is often not this period's cost. It can include an unpaid balance from the last bill, late fees, a deposit, or a payment plan installment. Copy the current charges line instead of the amount due, or a single missed payment will make one month look twice as expensive as it was.

This is the most common error in utility spreadsheets. The amount due is the biggest number on the page and the easiest to find, so it is the one people copy. Then a month after a late payment shows double, and the year total counts the same usage twice.

### Find the right line

The bill's account summary usually lists previous balance, payments received, current charges and total amount due. Current charges is the one that belongs in the usage sheet. Previous balance and payments describe the account, not the energy.

### Keep payments in a separate sheet

If you want to track what you paid, keep payments in their own sheet, with the date and amount from your bank. A bank statement shows every bill payment as one line. For a business paying many accounts, [a bank statement converter for small business books](/blog/bank-statement-converter-for-small-business) explains how to get those payment lines into a sheet quickly. FastBankConvert is built for that side: it is designed to read a digital bank statement into date, description and amount columns in seconds. It is not open yet, and [the get-started page](/get-started) takes sign-ups for launch. The bills themselves still need the field-picking described above.

## A twelve-month utility bill table with cost per unit

A twelve-month utility bill table is the finished product: one row per bill, the period dates, the days, the reading type, usage, current charges and the two derived columns. With it, you can see seasonal patterns, spot an estimate, check a rate change and total the year in one place.

### A worked example

The six rows below are made-up electric bills for one meter. In this example, the utility charges a fixed 12.00 per bill plus 0.145 per kWh.

| Period start | Period end | Days | Reading | Usage (kWh) | Current charges | kWh per day | Cost per kWh |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 2026-01-08 | 2026-02-06 | 29 | Actual | 812 | 129.74 | 28.0 | 0.160 |
| 2026-02-06 | 2026-03-09 | 31 | Estimated | 760 | 122.20 | 24.5 | 0.161 |
| 2026-03-09 | 2026-04-07 | 29 | Actual | 598 | 98.71 | 20.6 | 0.165 |
| 2026-04-07 | 2026-05-07 | 30 | Actual | 455 | 77.98 | 15.2 | 0.171 |
| 2026-05-07 | 2026-06-08 | 32 | Actual | 690 | 112.05 | 21.6 | 0.162 |
| 2026-06-08 | 2026-07-08 | 30 | Actual | 1,104 | 172.08 | 36.8 | 0.156 |

Three things stand out. The February bill was estimated, and March came in low as the actual reading corrected it; together they give 1,358 kWh over 60 days. April has the highest cost per kWh, only because the 12.00 fixed charge is spread over the fewest units. June has the lowest cost per kWh and the highest usage, which fits air conditioning in summer.

### Totals that should tie

Add a total row with `=SUM` on days, usage and current charges. The days should add up to the span from the first start date to the last end date, here 181. If they do not, a bill is missing or two periods overlap. That one check catches most gaps in a year of bills.

### Where the table goes next

For a household, this table is enough. For a business, utility costs feed the expense side of the accounts, and the year's total ends up in the reports alongside everything else. When those reports arrive as PDFs too, [a balance sheet PDF turned into Excel with its totals intact](/blog/balance-sheet-pdf-to-excel) shows how to bring them into the same workbook.