How to Enter Utility Bills into ENERGY STAR Portfolio Manager

Portfolio Manager needs consumption, cost, and start/end dates for every meter, every month. Keying that from PDF bills is the slow part — here's how to skip it.

What Portfolio Manager needs

For each meter and billing period, you need the consumption quantity, its unit (kWh, therms, CCF), the total cost, and the exact service start and end dates. Missing or misaligned dates are the most common upload error.

Extract the fields in the right shape

Upload each bill and the converter pulls those exact fields — one row per metered service, with the service period as clean start/end dates — so the output lines up with Portfolio Manager's meter-entry columns.

Batch a whole property portfolio

With Pro, convert a folder of bills into one combined workbook, then filter by property or meter. That turns a month of data entry across many buildings into a single upload.

Handle the bills the feeds miss

Automated data feeds cover big electric and gas utilities but skip water, waste, municipal, and tenant-paid bills. Those are exactly the ones this converter handles, so your benchmarking data isn't full of gaps.

Convert your utility bill now

Free — upload a PDF or image and download a clean spreadsheet.

Open the converter →