You do not need a $200-a-month dashboard to know whether last year’s boiler swap actually paid off. You need twelve months of utility bills, a free spreadsheet, and a way to correct for weather. Everything a platform sells you â the charts, the alerts, the score â is built on the same data that already arrives in your mailbox and your utility’s web portal, and most of it can be rebuilt in an afternoon for nothing.
The method has a name: measurement and verification, or M&V. The whole-building version â Option C of the IPMVP protocols â runs on monthly bills, and it is how auditors settle performance contracts on buildings far larger and messier than a 1920s walk-up. What follows is the workbook I have kept since 2019 for the nine old buildings I help manage: a baseline, a weather correction, a six-column spreadsheet, and the messy parts vendor demos never show you â estimated reads, one master meter, an oil tank in the basement, wiring that was old before the vendor was born.

What âSavingsâ Actually Means (and Why Your Bills Are Enough)
Savings is not âthis January cost less than last January.â Weather moves a heating bill more than most retrofits do. A number you can defend has three parts:
- A baseline: at least twelve months of usage before the change, from a building that was running normally.
- A post-period: twelve months after the work, under whatever weather actually showed up.
- A weather correction: so a cold winter does not take the blame for a good retrofit, or the credit for a bad one.
That structure is the whole-building method from the IPMVP protocols â Option C â the same framework used to settle six-figure performance contracts. It runs on monthly utility bills, which makes it the rare standard that fits a twelve-unit building with one gas meter and a filing cabinet.
One rule before anything else: track units, not dollars. Therms, kilowatt-hours, gallons. Rates change mid-year, delivery fees get restructured, and a dollar comparison will happily tell you the insulation failed because the supplier raised prices in October.
Step One: Build a Baseline From Bills You Already Have
Log into the utility portal or call and request twelve to twenty-four months of statements. Most utilities keep them as PDFs, and many support Green Button downloads that drop straight into a spreadsheet. For each bill, record five things:
- Read dates and the number of days between them. Billing cycles run 28 to 34 days, and a 29-day month next to a 33-day month is a 13 percent difference before anything in the building changed.
- Usage in units: therms or CCF for gas, kWh for electricity, gallons for oil or propane.
- Whether the read was actual or estimated.
- Any rate change, noted in the margin.
- Occupancy notes: a vacant unit, a new laundry machine, a boiler down for a week.
Your own memory is the cheapest sensor in the building, and it expires. Write the events down while they are happening. If you want more than bills can give before committing to a retrofit, start with the low-cost measurement tools we test before any purchase â but for tracking savings, the bills are the instrument.
Step Two: Correct for Weather With Degree Days
A heating degree day is a bookkeeping unit, not a mystery. Take 65, subtract the day’s average outdoor temperature, and add the result up across the billing period. A day that averages 35°F is 30 degree days; a month of those is about 900. You can pull degree days for the weather station nearest your building, matched to your exact read dates, free of charge, from degreedays.net. NOAA publishes the underlying station data if you want to check the source.
Then divide: therms per degree day, baseline year against post year, side by side. That one ratio is the weather correction for a small gas-heated building, and it is honest enough for any argument you will actually have â with an owner, a buyer, or a rebate program.
If you want the version engineers use, a two-variable regression in any spreadsheet â usage equals a constant plus a slope times degree days â gives the same answer with a confidence range, and earns its keep on buildings with cooling loads or two years of clean history. Start with the ratio. It is right more often than the fancier version, because you can check it by hand.
Step Three: The Spreadsheet, Column by Column
One tab per fuel, one row per bill, six columns: read date, days in the period, usage, degree days for the same dates, usage per degree day, and notes. The fifth column is the weather-corrected number. The sixth is where the building talks to you.
| Read date | Days | Therms | Degree days | Therms per degree day | Notes |
|---|---|---|---|---|---|
| Feb 2023 (baseline) | 31 | 512 | 740 | 0.69 | Actual read; cold snap |
| Feb 2024 (post) | 29 | 396 | 750 | 0.53 | Actual read; new boiler |
| Mar 2024 (post) | 31 | 344 | 620 | 0.55 | Boiler tune March 12 |
Twenty minutes a month, per building. The workbook costs an afternoon to build and nothing to run.
A Worked Example: A Boiler Swap in a 1920s Twelve-Unit
The building I will use is real in every way that matters for the math: a 1926 twelve-flat, one master gas meter, steam heat, tenants on separate electric meters. In the summer of 2023 the owner replaced a boiler from the Johnson administration and air-sealed the attic hatch and rim joists. By October 2024 the question was whether it had paid.
The baseline year burned 3,850 therms across 5,500 degree days â 0.70 therms per degree day. The first full year after the work burned 3,150 therms across 5,900 degree days â 0.53. The raw bills say 18 percent less gas. The corrected numbers say 24 percent, because the post year was colder and had been hiding part of the win. In therms: 0.17 per degree day across 5,900 degree days is about 1,000 therms, roughly $1,400 at the $1.40 a therm we paid that year. The raw comparison had understated the retrofit by a third of its real size. That is what weather correction is for, and it is why âcompare January to Januaryâ keeps lying to people.

The Messy Parts: Estimated Reads, Master Meters, and One Oil Tank
Estimated reads
Most utilities estimate some reads and true up later. Flag every estimated read in the notes column. Three estimated months in a row smear usage across the wrong months, and the reconciliation bill arrives looking like a spike â that is bookkeeping, not behavior. Request an actual read before you close out a post-period, and never draw a conclusion from a month that contains a catch-up bill.
One shared meter
A single master meter is the easy case for savings tracking, not the hard one: one meter, one number, no allocation argument. Splitting costs among tenants is a separate problem with separate tools â submeters, or a written ratio formula in the lease. Do not confuse the two, and do not let a vendor sell you tenant billing when what you asked for was savings verification.
Oil and propane heat
No monthly bills arrive, so use delivery slips: gallons delivered, and the degree days since the previous fill. Fuel dealers have done exactly this for decades â the K printed on your slip is degree days between fills divided by gallons delivered. Copy their method. A $20 tank gauge read once a week turns irregular deliveries into a usable consumption curve in between.
Imperfect data
Old buildings come with gaps: a missing year of bills, a meter swapped out mid-decade, a stretch of estimated reads. Use the cleanest twelve months you can assemble, write down exactly which months you used, and let anyone reading the workbook see the seams. A number with visible seams beats a clean number nobody can check.
Free Tools That Earn Their Keep â and When Paid Software Is Worth It
ENERGY STAR Portfolio Manager is free, built for exactly this work, and does property-level benchmarking with weather correction. Use it to answer âhow does this building compare to similar ones.â It will not tell you the savings came from the boiler rather than the mild winter â that attribution lives in your workbook, because only you logged the work.
Paid platforms earn their keep in specific situations: portfolios past twenty buildings, tenant submetering and billing, or interval-data alerts, where a smart meter flags a stuck damper in days instead of at the next bill. For one to five buildings, a subscription at $40 to $200 per building per month often costs more than the savings it finds.
When a vendor pitches you, ask three questions: What baseline period did you use? What weather correction? What did you adjust for occupancy? If the rep cannot answer from the product itself, the dashboard is a chart of your own bills with a monthly fee attached.

Tie the Numbers to a Maintenance Log
Savings tracking and maintenance logging are the same document. Every intervention gets a date and a line: boiler tune, steam vents replaced, thermostat schedule changed, basement door sealed. Then the workbook stops being a scorecard and becomes a diagnosis. When therms per degree day jump 15 percent in March, the log tells you why â a technician turned the aquastat up during a service call, or the door seal failed â weeks before the bill arrives. We keep ours in the format described in our guide to a maintenance log built for old buildings. After five years, that log is worth more than any chart: it is the evidence trail for warranties, for the next buyer, and for the rebate program that asks how you know.
Frequently Asked Questions
How many months of bills do I need before the numbers mean anything?
Twelve before the work and twelve after. Same-season comparisons of six months can work for heating-only loads, but a full year absorbs vacancy, holidays, and rate changes instead of leaving them baked into the numbers.
Can I track savings on a building with one shared meter?
Yes â that is the standard whole-building case, and it is easier than multiple meters. One meter, one number. Splitting savings among tenants is allocation, a separate problem with separate tools.
What if my utility sends mostly estimated reads?
Flag them, request an actual read at least quarterly, and read across the estimated months rather than into them. Estimates usually wash out within a cycle or two; the catch-up bill that looks like a spike is bookkeeping, not a change in the building.
Is a free tool like Portfolio Manager enough on its own?
For benchmarking, yes. For verifying a specific retrofit, no â it normalizes at the property level and cannot know your boiler was down for a week in February. Run it beside the workbook, not instead of it.
How do I present this to a lender or a rebate program?
Print the workbook: baseline, post-period, degree-day correction, and a one-page method note naming the framework you followed. Reviewers who check savings recognize whole-building bill analysis, and a method you can explain beats a glossy dashboard PDF nobody can audit.
The Short Version
The bills are the instrument. The spreadsheet is the software. The maintenance log is the memory. Total cost: an afternoon to build, twenty minutes a month to keep, and nothing left to correct but the weather. For a building that will never be replaced, that is the savings tracker worth having â and it is already arriving in the mail.













