In our post “Smarter Facility Financial Planning Starts with Better Data,” we made the case for high-quality facility data and why it’s essential for long-term planning, budget forecasting, and risk reduction. But knowing why “better data” matters is only the first step. The next is figuring out whether the data you have is actually usable and where you may have gaps to fill.
That’s where a facility data audit comes in. Before you can plan capital improvements, justify funding, or streamline operations, you need to know whether your data is complete, current, and well-structured. This post walks you through how to audit your facility data so you can move from assumptions to confident, data-driven planning.
A facility data audit is a systematic review of the information you use to manage buildings, such as inventory lists, condition assessments, maintenance records, drawings, and more. Done well, it helps you understand what you have, what you’re missing, and how to strengthen your foundation for planning and decision-making.
Here’s how to get started.
1. Can You Access All Your Data?
This may sound simple, but one of the most common issues in a facility portfolio is data fragmentation. Information lives in different formats and systems, creating silos. This often looks like Excel spreadsheets on personal drives, outdated PDFs, binders of notes, and maintenance databases that don’t talk to each other.
Begin by identifying:
- Where your facility data is housed – both planning and operational levels
- Who owns it
- What systems it’s stored in
- Whether those systems can share data easily
Tip: Create a central inventory of all your data sources and note any access limitations or redundancies.
2. Is the Data “Clean”?
“Clean” data means it’s free from errors, inconsistencies, and duplication. It also means the formatting is standardized, so assets are listed consistently (e.g., “RTU-01” and not “Rooftop Unit 1” in one place and “RTU#1” in another). This sounds trivial, but it’s a big deal. Spelling, spacing, and formatting all matter here.
To assess data cleanliness:
- Look for duplicate entries, inconsistent naming, or outdated fields
- Check for gaps in key fields (e.g., missing ID’s, install dates, expected useful lives, replacement values, year of next replacement, quantity, etc.)
- Confirm the structure of your data matches how your team works-if you call a building “Stern” colloquially but refer to it as “03-001-2A” in your files, there’s no way to cross-walk information.
Why it matters: Clean data supports automation, dashboards, and reporting. Messy data leads to confusion, miscommunication, wasted resources, and poor decision-making.
3. Is It Complete?
Having access to some data isn’t enough. Ask yourself:
- Do we have records for all critical systems (HVAC, roofing, electrical, etc.)? Often we see dynamic equipment accounted for and foundation, roofing, building envelope, and finishes isolated or omitted. This leads to a big underestimate of money needed to maintain your facilities.
- Are all locations and buildings accounted for—not just the new buildings or most used buildings? What about your shops, warehouses, and outbuildings? What about all of your site assets?
- Are the key attributes filled in for each asset, such as like condition rating, age, replacement cost, expected lifespan, and remaining useful life?
It’s OK if not everything is perfect but knowing what’s missing helps you set priorities for improvement.
4. When Was It Last Updated?
Outdated data is almost as risky as no data at all. Conditions change, equipment fails, prices rise, renovations happen. If your data is several years old, you may be making planning decisions based on false assumptions.
Be sure to track:
- The last date of assessment or update for each building/system
- Whether that update included cost escalation or reflected completed work
Tip: Consider setting up a regular review cycle, such as once a year or every five years, depending on the criticality and pace of change in your facilities. Project closeout can be another great opportunity to document updated conditions.
5. Is There a Work Breakdown Structure?
One of the most overlooked but powerful tools in facility planning is a Work Breakdown Structure (WBS), a hierarchical framework that organizes assets into logical groupings.
Using a standard like ASTM Uniformat II, you can:
- Aggregate data at system or component levels (e.g., “HVAC” vs. “AHU-1”)
- Enable both strategic (portfolio-level) and operational (site-specific) planning
- Improve communication across stakeholders by using shared language
If your data isn’t structured this way, it can still be organized post-audit but make note of where and how it would help your planning efforts. This also is a great way to identify gaps. Are you missing all of your “A” assets?
Wrapping Up: From Audit to Action
A facility data audit doesn’t have to be overwhelming. Think of it as a health check that helps you understand the strengths and weaknesses of your current information. Once you know what you have – and what you don’t – you can create a roadmap for improvements that support more reliable forecasting, better budgeting, and stronger capital planning.
Whether you’re managing a single facility or a diverse portfolio, better data starts with better awareness.