How to Create an Energy Cost Breakdown: A Full Guide
An energy cost breakdown splits a utility bill into the things that actually consume the money. Heating, lighting, ventilation, equipment, and the fixed charges that appear whatever you do. Most teams have twelve PDFs and a total. This guide turns those into a breakdown you can act on, and sets it against published national figures.
What an energy cost breakdown shows
A bill gives you one number and a meter reading. That answers "how much" and nothing else.
A breakdown answers four questions instead. Where does the money go by end use. How much of the bill is fixed regardless of consumption. How the split changes with the season. And whether your mix looks unusual for a building like yours.
The fourth question is the one people skip, and it is the one that tells you whether a number is worth investigating. A lighting share of 18% means nothing on its own.
It means something the moment you know what comparable buildings run at. That is why a breakdown is worth building against a published baseline, not against last year alone. The public survey data below matters more than it first appears.
What you need before you start
Three things, and two of them you already have.
- Twelve months of bills, as PDFs or a billing export. Twelve, because anything shorter cannot separate season from trend.
- Building context: floor area, operating hours, and what the space is used for.
- A benchmark to compare against, which is where public data comes in.
If you have interval or half-hourly meter data, use it. If you do not, monthly bills still support a usable energy cost breakdown, because the seasonal swing does most of the separation work for you.
One practical note on the bills themselves. Tariffs change mid-contract more often than people expect, so keep the rate per unit as its own column from the start. Recovering it later from a total and a consumption figure is possible but tedious, and it is the step most likely to be skipped.
How to build it manually
Option 1: Total the bills and divide by floor area
This gives you energy cost per square foot, which is the single most quoted figure in facilities work.
It is a real number and a shallow one. It tells you whether you are expensive without telling you why.
Option 2: Split fixed charges from consumption charges
Read one bill carefully and separate the standing charge, demand charge, and any capacity element from the per-unit consumption cost. Then apply that structure across the year.
This is the first genuinely useful step, because it shows how much of the bill would survive turning everything off. In many commercial tariffs that share is larger than people expect.
Option 3: Estimate end-use shares from the seasonal shape
Compare summer and winter consumption against the shoulder months. What remains flat all year is base load, largely lighting, ventilation, and equipment. What swings is conditioning.
This is the version that produces an actual energy cost breakdown, and it is slow. Every month is a separate PDF, the tariff may change mid-year, and one cold January distorts the whole picture.
The base load estimate is the part worth getting right. Take what your building consumes in a mild shoulder month, when neither heating nor cooling is working hard. That figure is close to the floor you pay every month of the year, and projects aimed at conditioning will not move it.
How to build the breakdown with AI
Step 1: Upload the bills and the building details
Open Powerdrill Bloom and upload all twelve bills together, plus a short note of floor area, operating hours, and building type. PDFs are fine; they do not need to be converted first.
Then describe in natural language what you want separated: fixed against variable, and base load against seasonal. Say which months are your shoulder months, because that single fact anchors the whole estimate.
Step 2: Ask for the structured table before any chart
Ask for one row per billing period carrying consumption, fixed charges, variable charges, unit rate, and degree-day context if you have it. Ask to see any month where the unit rate changed.
That rate-change list is the quality check. A tariff switch mid-year will otherwise look like a consumption change, and the breakdown will attribute it to the wrong thing.
Only once the table is right should you ask for the split.
Step 3: Compare against the public benchmark and export
Ask for your end-use shares set against published figures for commercial buildings, then export both the table and the comparison.
The comparison is the point of the whole exercise. This is where open data earns its place. The platform can search built-in open data sources. The benchmark and your bills can therefore sit in the same answer, rather than in two browser tabs.
What the national picture looks like
The US Energy Information Administration runs the Commercial Buildings Energy Consumption Survey, and its commercial buildings page publishes the resulting shares. The most recent survey was conducted in 2018, and the page was last updated in June 2023.
| Measure | EIA figure (2018 CBECS) |
|---|---|
| Commercial buildings in the US | About 5.9 million |
| Total floorspace | About 96.4 billion square feet |
| Space heating share of energy use | About 32% |
| Ventilation share | About 10% |
| Lighting share | About 10% |
| Electricity share of total energy use | 60% |
| Natural gas share of total energy use | 34% |
EIA notes that space heating is "the largest single energy end use in U.S. commercial buildings." Ventilation and lighting were next, each at about 10%. It also records that office buildings "consumed more energy than any other type of commercial building."
One caution the same page supports directly. Regional mixes differ. In the South Census Region, electricity accounted for 69% of commercial building energy use and natural gas for 26%, against the national 60% and 34%. EIA also states that "climate and weather affect the relative shares of space heating and cooling annually and by region of the country."
So use the regional figure where you can. A nine-point gap in the electricity share is more than enough to make a building look anomalous when it is simply somewhere warm.
Best practices and common mistakes
Normalise before you compare anything. Cost per square foot, or per square foot per operating hour. Raw totals only tell you which building is bigger.
Separate rate changes from usage changes. A bill that rose 12% because the unit rate rose 12% is not an efficiency problem, and treating it as one wastes a quarter.
Weather-correct the seasonal months. A mild winter flatters your numbers and a harsh one indicts them. Degree-day data is the standard adjustment, and EIA's own commentary on climate and regional shares is the reason it matters.
Benchmark against your region, not the country. See the nine-point electricity gap above.
Keep fixed charges visible in every view. Efficiency work moves the variable part only, so a breakdown that buries the standing charge overstates what any project can save.
State the survey year on the page. The EIA shares above come from the 2018 survey, published on a page last updated in June 2023. That is the most recent data available from this source. Readers comparing a current bill against it should be told so, rather than left to assume the baseline is from this year.
Read the result next to the budget. The breakdown explains variance that a finance view only records. Our guide to the budget versus actual report covers that pairing. Our walkthrough on the burn rate report covers the cash-side view of the same spend.
Make it a standing view if it recurs. For a monthly refresh, our guide on building a KPI dashboard from a spreadsheet covers the format. The make graphs from Excel page covers the chart route.
Conclusion
Twelve bills contain more than a total. They contain the fixed-versus-variable split, the base load, the seasonal swing, and enough structure to say where the money actually goes.
Pull the structured table first, check for rate changes, then split. Set the result against the regional EIA figures rather than the national ones. Within an hour you will know whether your building is unusual or simply ordinary.
Have a year of bills sitting in a folder? Try Powerdrill Bloom and turn them into one table.
Frequently asked questions
What is an energy cost breakdown?
It is a split of your utility spend into end uses and charge types, rather than a single bill total. A useful version separates fixed charges from consumption and base load from seasonal use.
How much of a commercial building's energy goes to heating?
EIA's 2018 survey puts space heating at about 32% of energy use across US commercial buildings, making it the largest single end use. Ventilation and lighting were next at roughly 10% each.
Can I do this without interval meter data?
Yes. Twelve months of bills is enough to separate base load from seasonal consumption, because the shoulder months approximate the flat portion of your usage.
Why compare against EIA figures rather than last year?
Last year tells you the direction; a benchmark tells you whether the level is reasonable. Use the regional figures, since the electricity share in the South was 69% against 60% nationally.
What causes a sudden jump that is not extra usage?
Most often a tariff or unit rate change, or a shift in fixed charges. Check the rate per unit before treating any increase as a consumption problem.