-
Excel workbook preview
Energy Management (ISO 50001, DOE 50001 Ready)
Monthly Energy Consumption Tracker (all fuels)
3 downloads per free account, no card needed.
Who this is for
The person who has to answer the finance director's or an auditor's question on how much energy each site used last month and what it cost.
What is inside
- One row per meter or account per month, with source, quantity, unit and cost
- Units sheet with kWh factors (therm, MMBtu, GJ, litres of diesel and petrol from DESNZ 2025)
- Live kWh and cost per kWh, with a Unit? warning for unknown units
- Estimated bills highlighted until replaced with actual reads
- Summary of 12 months from a start month you choose, and totals and shares by energy source
- 12 worked sample rows (electricity, gas in m3, diesel) and 24 blank rows
How to use it: Set the first month of your year on the Summary sheet, replace the example gas factor with your bill's value, and add one row per bill each month.
Files & formats
- XLSXmonthly-energy-consumption-tracker-template.xlsx14 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



