From inventory lists to BI tools: The 5-level maturity model for asset data

by Michael Lehnert · CEO, seventhings

73% of companies with an ERP system still maintain parallel Excel spreadsheets for their fixed assets (Forrester, 2023). ERP systems track book values, not the physical location of a tool or office chair. To this day, most teams close this gap manually. This article helps you categorize your company into one of five maturity levels and shows you the tangible benefits of moving to the next stage.

Key Takeaways

• 18% of corporate assets cannot be located during audits (KPMG, 2024): a classic symptom of maturity level 1 or 2.
• Companies with structured asset data close their annual financial statements significantly faster (Deloitte Financial Close Survey, 2024).
• The five levels range from unstructured Excel lists to a robust data foundation that supports investment and ESG decisions.
• seventhings covers levels 2 through 4, providing the structured raw data that your ERP, DATEV, or BI tool needs to operate at level 5.

‍

What is an asset data maturity model?

An asset data maturity model describes how structured, current, and interconnected information about a company's physical assets is. It ranges from level 1 (unstructured lists without location or condition data) to level 5 (data that directly supports investment, compliance, and ESG decisions). Each level builds on the previous one: without linked location and ownership data (level 3), reliable maintenance planning (level 4) is impossible.

Based on our project experience, most mid-sized companies with 200 to 5,000 employees are between levels 1 and 2. While they have a digital list, they lack real-time integration between assets, locations, people, and condition. An inventory software that automatically keeps location and condition data up to dateis the technical foundation for every subsequent stage.

‍

Why do so many companies get stuck at stages 1 and 2?

The leap from a list to a connected database rarely fails due to a lack of will. It fails because of the collection method. Anyone counting inventory once a year with a clipboard ends up with an outdated list the moment the first device is moved.

These symptoms all point to the same cause: a database that does not evolve between inventories. This is the core of stages 1 and 2.

‍

The five maturity levels in detail

Each stage has a clear identifying feature and a clear trigger for the next step.

Stage 1: The unstructured list

Assets are listed in Excel, often multiple times, with inconsistent naming and no fixed location. Updates happen irregularly, usually only when accounting asks. A typical mid-sized company has between €50,000 and €200,000 worth of unused equipment sitting in cabinets and storage rooms (McKinsey, 2024). A direct result of this stage.

Stage 2: The digital inventory list

The list is now centralized and digital, usually in a cloud spreadsheet or simple inventory software. Locations are recorded but not updated in real time. Tools and mobile equipment continue to go missing: a 12 to 18% annual tool loss rate is normal at this stage if there is no scanning process in place (Nexess Solutions, 2024).

Stage 3: Connected asset data

Every asset carries a QR code or barcode. Location, assigned personnel, and condition are updated with every scan, even without the device itself having a network connection. This is where the biggest difference from stage 2 becomes apparent, especially for inventory spread across multiple locations. This is precisely the leap that most companies—based on our experience with over 450 clients—underestimate: the difficult part isn't the initial recording, but the ongoing updates every time a location or user changes.

Stage 4: Process-integrated data

Maintenance intervals, inspection deadlines, and lending processes are managed directly via the asset record. A piece of test equipment automatically reports when the next DGUV V3 inspection is due. Reminders arrive via email—not as push notifications, but they reliably reach the right person. This stage is the prerequisite for audit compliance: the 41% audit failure rate associated with purely manual records can be reduced to nearly zero here (ISACA, 2024).

Level 5: Data-driven decision-making

Asset data is clean, current, and structured enough to be integrated into financial planning, ESG reporting, and investment decisions. 67% of CFOs cite capital tied up in assets as one of their top three liquidity concerns (Deloitte CFO Signals, 2024). Companies at this level answer this question in minutes rather than weeks because the data is ready for export into DATEV, SAP, or a BI tool.

‍

Where does your company stand, and what does the next level offer?

A rough self-assessment is usually enough. Do you maintain a central but static list? Level 2. Does the location update automatically with every scan? Level 3. Are inspection deadlines and maintenance schedules managed directly on the data record? Level 4.

The economic difference between these levels is measurable. According to studies, companies using asset tracking achieve a significant reduction in equipment downtime (Machine Tracking ROI Study, 2024). Those who also feed structured data into their annual financial statements noticeably shorten this process (Deloitte Financial Close Survey, 2024).

For test equipment and DGUV V3-compliant assets , the effect is particularly clear: maintaining digital compliance records significantly reduces the effort required for the next audit.

‍

Why seventhings covers levels 2 through 4, but not level 5

seventhings is not a BI tool or an ERP replacement. We are the middleware that captures, links, and enriches your 80% of non-networked physical assets with process data. This raw data then flows into your reporting, your DATEV system, or your BI tool. Based on our experience with customers across all industries, this is exactly where projects fail: teams try to jump directly from level 1 to level 5 without building the linked data foundation of levels 2 through 4. Without current location and status data, any BI dashboard is only as good as the last manual inventory.

This also applies to asset classes that are rarely in the spotlight: Anyone who manages furniture and equipment throughout its entire lifecycleoften reaches level 3 faster than with more complex asset groups.

Isn't an Excel spreadsheet enough for a medium-sized company? For very small inventories, yes, in the short term. Once you have several hundred assets across multiple locations, manual maintenance becomes a full-time job: according to IDC (2023), employees spend 5.3 hours a week just searching for devices. seventhings replaces this search with a single QR scan per asset.

At what maturity level does it make sense to switch to an asset intelligence platform? From level 2, as soon as more than one location or more than one responsible department is involved. The effort required for manual reconciliation grows faster than the number of assets itself. seventhings typically supports customers in making the leap from level 2 to level 4.

What distinguishes level 4 from level 5? Level 4 means: processes such as maintenance, testing, and lending are structured around the asset record. Level 5 means: this data flows into strategic decisions, such as investment planning or ESG reporting. seventhings provides the data foundation for level 4 and makes it exportable for level 5.

‍

What now?

1. Assess your maturity level. Use the five levels to check where your largest asset categories currently stand. The maturity level often differs significantly between IT equipment, tools, and furniture.
2. Identify the biggest levers. Which asset group caused the most discrepancies according to your last inventory or audit?
3. Request an asset potential analysis. Based on your current inventory data, we will show you which level is realistically achievable and how much tied-up capital the leap will release.

‍

Frequently asked questions about the asset data maturity model

What is the difference between an inventory list and asset intelligence?

An inventory list documents what is on hand. Asset Intelligence goes further by linking location, condition, responsible parties, and process data in real time. The difference is equivalent to the leap from maturity level 2 to level 3 or 4.

How long does it take to jump from level 2 to level 4?

The first assets are recorded in the system for seventhings customers in under 14 days. Full process integration across all asset groups takes several weeks to months, depending on the size of the company.

Can I skip multiple maturity levels at once?

Technically, a platform can be set up quickly. However, data quality grows with every scan cycle. A direct jump from level 1 to level 5 usually fails due to a lack of a data foundation, not a lack of software.

Which asset categories benefit most from a higher maturity level?

Mobile equipment without a fixed assignment benefits the most: DGUV V3 equipment, test equipment, PPE, tools, company phones without MDM, and pool vehicles without telematics. With an annual tool loss of 12 to 18% (Nexess Solutions, 2024), every maturity level pays off directly.

Does a higher asset data maturity level replace the ERP system?

No. seventhings complements SAP, DATEV, and other ERP systems with the physical layer that is usually missing there. Book values remain in the ERP, while the middleware provides the linked location and condition data.

‍