What Utility Data Do You Need for an Audit-Ready ESG Report?

An audit-ready ESG report starts with one simple discipline: clean, complete utility data. 

For many organizations, the reporting scramble does not begin with emissions math. It begins much earlier, when sustainability, facilities, and finance teams try to answer basic questions: 

• Which buildings are included? 
• Which meters belong to which sites? 
• Are we missing any utility bills? 
• Can we prove where every number came from? 
• Are Scope 1, 2, and 3 emissions calculated from defensible inputs? 

If your utility data is scattered across invoices, spreadsheets, portals, emails, and property managers, your ESG report may still get finished. But it will be harder to verify, harder to explain, and harder to trust. 

Here are the best practices for collecting utility data that can support a credible, audit-ready ESG report. 

 

1. Start with a clear reporting boundary

Before collecting bills or calculating emissions, define what the report covers. 

At minimum, document: 

• Which properties or facilities are included 
• Which business units, subsidiaries, or leased spaces are included 
• Whether the report covers owned, operated, or managed assets 
• The reporting period 
• Any exclusions and the reason for each exclusion 

This matters because ESG reporting is not only about totals. It is about transparency. If one building is included this year and excluded next year, reviewers need to understand why. 

A strong reporting boundary helps prevent double counting, missing sites, and last-minute debates about what “counts.” 

2. Build a complete site and meter inventory

An audit-ready report needs a reliable map between physical locations and utility accounts. 

For each site, collect: 

• Property name 
• Street address 
• Internal property ID, if available 
• Ownership or operational status 
• Square footage or other normalization metric 
• Utility providers 
• Utility account numbers 
• Meter numbers 
• Meter type 
• Service start and end dates 

The goal is to make every utility bill traceable to a specific location, meter, and reporting period. 

This is especially important for multi-property organizations. Without a clean site and meter inventory, teams can easily miss a meter, count one twice, or assign usage to the wrong property. 

3. Collect monthly utility consumption data

For most ESG reports, the core data set is monthly utility consumption. 

Common categories include: 

• Electricity 
• Natural gas 
• Water 
• Waste 
• Fuel 

For each bill or utility record, capture: 

• Service period start date 
• Service period end date 
• Usage amount 
• Unit of measure 
• Cost 
• Utility provider 
• Account number 
• Meter number 
• Bill image or source file 
• Date the data was collected 
• Any adjustments, estimates, or corrections 

Do not rely only on annual totals when monthly data is available. Monthly data makes it easier to identify gaps, spot anomalies, explain seasonal changes, and support more detailed emissions calculations. 

4. Preserve the original source documents

Audit-ready reporting depends on traceability. 

That means every number in the report should connect back to a source document, such as: 

• Utility bill PDFs 
• Utility portal exports 
• Waste hauler reports 
• Fuel purchase records 
• Landlord-provided utility statements 
• Submetering reports 
• Invoices or account summaries 

Source documents help answer the reviewer’s most important question: “Where did this number come from?” 

Best practice is to store source files in a consistent system and link them to the corresponding site, meter, account, and month. A spreadsheet with totals is useful, but it is not enough by itself. 

5. Standardize units before analysis

Utility data often arrives in different formats. 

Electricity may appear in kWh. Natural gas may appear in therms, MMBtu, or cubic feet. Water may appear in gallons, CCF, or cubic meters. Waste may appear in tons, pounds, cubic yards, or pickup counts. 

Before using the data in ESG reporting, standardize: 

• Units of measure 
• Naming conventions 
• Date formats 
• Property names 
• Account and meter identifiers 
• Emissions factor references 
• Cost categories 

This reduces errors and makes year-over-year comparison much easier. 

It also helps teams avoid one of the most common reporting problems: combining numbers that look similar but are measured differently. 

6. Separate actual, estimated, and missing data

Not all data has the same quality. 

A credible ESG report should distinguish between: 

• Actual data from bills, meters, or verified records 
• Estimated data based on historical usage, averages, or modeled assumptions 
• Missing data that still needs to be collected 
• Corrected data that replaces a previous entry 

This distinction matters because auditors and stakeholders may accept estimates in some cases, but they need to know where estimates were used and how they were calculated. 

Do not hide uncertainty. Document it. 

7. Track data quality issues as they happen

Utility data is rarely perfect. 

Common issues include: 

• Missing bills 
• Overlapping service periods 
• Gaps between billing periods 
• Duplicate invoices 
• Meter changes 
• Account number changes 
• Estimated utility bills 
• Unusually high or low usage 
• Properties added or sold mid-year 
• Tenant-controlled meters 
• Landlord-controlled utilities 

Best practice is to log these issues during collection instead of trying to reconstruct them at the end of the reporting cycle. 

A simple data quality log should include: 

• Site 
• Utility type 
• Billing period 
• Issue identified 
• Resolution status 
• Person responsible 
• Notes on how the issue was handled 

This creates an audit trail and prevents the same questions from being reopened every reporting cycle. 

8. Connect utility data to Scope 1, 2, and 3 emissions

Utility data is the foundation for many emissions calculations. 

In broad terms: 

• Scope 1 covers direct emissions from sources an organization owns or controls, such as onsite fuel combustion. 
• Scope 2 covers indirect emissions from purchased electricity, steam, heating, or cooling. 
• Scope 3 covers other indirect emissions in the value chain, which may include waste, business travel, purchased goods, or tenant-related activity depending on the reporting framework. 

For audit-ready ESG reporting, teams should document how each utility data category maps to emissions scopes. 

For example: 

• Natural gas usage may support Scope 1 calculations. 
• Purchased electricity may support Scope 2 calculations. 
• Waste data may support relevant Scope 3 categories. 
• Fuel purchases may support Scope 1 or Scope 3 depending on ownership and operational control. 
• The key is not only calculating emissions. The key is explaining the logic behind the calculation. 

9. Use consistent emissions factors and document the source

Emissions factors translate activity data, such as kWh or therms, into greenhouse gas emissions. 

To keep ESG reporting defensible, document: 

• Which emissions factor source was used 
• Which year or version was used 
• Which geography or grid region applies 
• Whether the calculation is location-based or market-based 
• Whether renewable energy certificates, offsets, or supplier-specific factors were used 
• Any assumptions or conversions applied 

Changing emissions factor sources without documentation can create confusion, especially when year-over-year numbers shift. 

Consistency makes the report easier to explain. Documentation makes it easier to defend. 

10. Reconcile totals before publishing

Before finalizing the report, reconcile the data. 

Useful checks include: 

• Compare utility totals against financial records. 
• Confirm all active properties have data for the full reporting period. 
• Check for missing months. 
• Look for duplicate bills. 
• Review unusually high or low usage. 
• Confirm units are consistent. 
• Verify that source documents exist for reported values. 
• Compare year-over-year changes and investigate large swings. 
• This step often reveals issues that are invisible during data entry. 

A report can look polished and still contain avoidable errors. Reconciliation is how teams catch those errors before external review. 

11. Keep reporting workflows repeatable

Audit-ready reporting should not depend on one person’s memory. 

Create a repeatable workflow that defines: 

• Who collects data 
• Where data is stored 
• How bills are named and organized 
• How missing data is flagged 
• How estimates are calculated 
• Who approves final numbers 
• When each review step happens 
• Where supporting documentation lives 

Repeatability reduces stress, especially for organizations reporting across multiple properties or programs. 

It also makes next year’s report easier because the process improves instead of restarting from scratch. 

12. Move beyond spreadsheets when the process gets too complex

Spreadsheets can work for a small portfolio or a first reporting cycle. But they become risky as the number of properties, meters, utility types, and reporting requirements grows. 

Signs that the process has outgrown spreadsheets include: 

• Multiple people are editing different versions. 
• Source documents are stored separately from the data. 
• Manual copy-paste work is common. 
• Missing bills are discovered late. 
• Emissions calculations are hard to trace. 
• Reports take too long to prepare. 
• Teams cannot easily explain where numbers came from. 

At that point, organizations need a more reliable system for tracking, analyzing, and reporting utility data. 

Verdafero helps organizations turn scattered utility information into fast, accurate Scope 1, 2, and 3 emissions reports. Its patented utility monitoring software securely tracks and analyzes electricity, natural gas, water, waste, and fuel across properties, while consulting support helps teams improve reporting, benchmarking, auditing, and sustainability workflows. 

Audit-ready utility data checklist 

Use this checklist before finalizing an ESG report: 

• [ ] Reporting boundary is defined. 

• [ ] Included properties and exclusions are documented. 

• [ ] Site inventory is complete. 

• [ ] Utility accounts and meters are mapped to properties. 

• [ ] Monthly usage data is collected. 

• [ ] Original source documents are stored. 

• [ ] Units are standardized. 

• [ ] Actual, estimated, missing, and corrected data are clearly labeled. 

• [ ] Data quality issues are logged. 

• [ ] Utility categories are mapped to Scope 1, 2, and 3 emissions. 

• [ ] Emissions factor sources are documented. 

• [ ] Totals are reconciled before publication. 

• [ ] The workflow is repeatable for the next reporting cycle. 

The bottom line 

An audit-ready ESG report is built long before the final document is written. 

It starts with utility data that is complete, traceable, standardized, and connected to clear reporting logic. When teams can show what was included, where the numbers came from, how calculations were made, and how issues were handled, ESG reporting becomes easier to trust. 

The best practice is simple: treat utility data as evidence, not just inputs. 

That shift makes reporting faster, reduces rework, and gives stakeholders more confidence in the final numbers. 

If your organization is ready to make ESG reporting easier to manage and easier to trust, visit Verdafero’s website to learn more and schedule a demo. See how utility data can become a clearer path to faster reporting, better decisions, and measurable environmental progress.