Fixed Asset Accounting: What Excel Can’t Do (And Why It Annoys Auditors)

An asset auditor requests the complete fixed asset schedule for 2025. The accounting department opens an Excel file with 340 rows, multiple tabs, and three different handwriting styles. This is exactly where the problem begins for many mid-sized companies: the figures in the ERP system and the reality in the warehouse do not match. According to Forrester, 73% of ERP users continue to maintain parallel Excel lists to fill gaps in the system (Forrester, 2023). For fixed asset accounting, this means: duplicate maintenance, double the sources of error, and a fixed asset schedule that won't hold up during the next audit.

This article explains why Excel is insufficient as the sole basis for fixed asset accounting, what auditors specifically criticize, and how an Asset Intelligence Platform bridges the gap between the ERP system and physical inventory—without replacing your existing ERP.

Key Takeaways

• 73% of ERP users maintain additional Excel lists for their fixed asset accounting (Forrester, 2023).
• 18% of assets cannot be located during audits (KPMG, 2024).
• Manual fixed asset schedules result in a 41% audit error rate, compared to 8% with automated tracking (ISACA, 2024).
• 67% of CFOs cite tied-up capital as one of their top 3 concerns (Deloitte CFO Signals, 2024).

‍

What is a fixed asset schedule—and why isn't Excel enough?

A fixed asset schedule is a tabular overview of all a company's assets: acquisition cost, depreciation, additions and disposals, and net book value. It is a mandatory, auditable component of the annual financial statement. The problem rarely lies within the ERP system itself, but in the data foundation behind it. An ERP knows the book value of a machine—but it doesn't know if it is still at the stated location, if it has been scrapped, loaned out, or moved to another department.

This is the exact gap that employees have been filling manually in Excel. Every additional spreadsheet is another point where data becomes outdated or inconsistent. After a while, book values and physical inventory contradict each other—and no one in the company can say for sure which version is current.

What is a fixed asset schedule? A fixed asset schedule documents the acquisition cost, depreciation, and additions and disposals of all assets over a fiscal year. It is a mandatory component of the audited annual financial statement under the German Commercial Code (HGB). seventhings automatically keeps the physical inventory status in sync with the fixed asset schedule.

‍

Why auditors look closely at Excel-based fixed asset accounting

Auditors don't just evaluate whether figures are booked correctly. They check whether the underlying data collection is traceable and audit-proof. An Excel spreadsheet without a history, without unique identification of individual assets, and without an audit trail only partially meets these requirements. ISACA puts the audit error rate for manually maintained fixed asset schedules at 41%, compared to 8% for automatically tracked inventory (ISACA, 2024).

For an audit, one thing matters most: can every item in the fixed asset schedule be traced back to the physical object? KPMG audits show that 18% of assets are not locatable at the time of the audit (KPMG, 2024). Every item that cannot be found leads to inquiries—and every inquiry costs time, which is in short supply during the audit period.

What requirements do auditors have for fixed asset accounting? Auditors expect a complete, traceable history for every asset as well as a clear link between book value and physical location. According to ISACA, manual fixed asset schedules lead to an audit error rate of 41% (ISACA, 2024). seventhings documents every movement automatically and in an audit-proof manner.

‍

The costs of opaque fixed asset accounting

Opaque fixed asset accounting costs more than just audit time. McKinsey estimates that the average SME has between 50,000 and 200,000 euros in unused equipment still on its balance sheet (McKinsey, 2024). This capital is tied up without providing any benefit—and it remains invisible as long as no one knows where the items actually are. For 67% of CFOs, tied-up capital is one of their top three financial concerns (Deloitte CFO Signals, 2024).

Then there is the time required for the annual closing process itself. Observations from customer projects show that manual reconciliation between Excel inventory lists and fixed asset accounting often takes several weeks in medium-sized companies—time that controlling and accounting departments can ill afford during the tight window of the annual closing. Deloitte notes that companies with end-to-end, real-time asset data can significantly shorten their closing cycles (Deloitte Financial Close, 2024).

‍

How an Asset Intelligence Platform changes fixed asset accounting

seventhings does not replace your ERP or financial accounting system. The platform bridges the gap between book value and physical inventory, which affects 80% of assets that lack IoT sensors. Each item is assigned a unique identifier via a QR code. Movements, location changes, and status updates are recorded directly on-site and documented in an audit-proof manner—eliminating the need for subsequent Excel reconciliation.

For fixed asset accounting, this means the asset register can be reconciled with the actual inventory at the push of a button. Discrepancies between book value and physical reality become visible before the auditors find them. Anyone already working with inventory data is familiar with the basic principle from traditional inventory management – seventhings applies this principle to ongoing fixed asset accounting.

How does an Asset Intelligence Platform support fixed asset accounting? An Asset Intelligence Platform links every asset to its location, condition, and movement history via a unique identifier. Discrepancies with the book value become visible on an ongoing basis rather than only during the annual audit. seventhings provides this reconciliation without replacing your existing ERP system.

‍

Modernizing fixed asset accounting step by step

In practice, the transition from pure Excel-based fixed asset accounting to data-driven inventory management follows a recurring pattern. First, the existing asset register is reconciled with the physical inventory to identify ghost assets. Next, the remaining assets are assigned a unique identifier. In the third step, the ongoing recording of movements and status changes takes place directly at the object, rather than retrospectively at a desk.

For controllers, it is particularly relevant that this reconciliation is not limited to a single inventory count but takes place continuously. A structured, compliance-compliant inventory process thus reduces the preparation effort for every subsequent audit.

Why is Excel not enough for fixed asset accounting? Excel lists lack a unique, tamper-proof history and are often edited by multiple people simultaneously. As a result, discrepancies between book value and physical inventory are only discovered during an audit. seventhings replaces this manual Excel maintenance with continuously updated, uniquely identified inventory data.

This shifts the focus for controllers: away from manual reconciliation and toward analyzing variances and their root causes.

‍

What's next?

1. Fixed asset register check: Assess data quality and variances against physical inventory in 15 minutes.
2. Request an asset potential analysis: Identify concrete savings potential for your fixed asset accounting.
3. Book a personal demo: See live how seventhings synchronizes your fixed asset register with your physical inventory.

‍

‍

‍

Frequently asked questions about fixed asset accounting

What is the difference between fixed asset accounting and physical inventory?

Fixed asset accounting records acquisition costs, depreciation, and book values over time. Physical inventory checks at specific points in time whether the physical stock matches these book values. Without regular inventory, fixed asset accounting remains a purely numerical exercise with no connection to reality.

Which software is suitable for fixed asset accounting in medium-sized companies?

For the book value itself, your existing ERP system is usually sufficient. To reconcile this with physical inventory, medium-sized companies additionally need an asset intelligence platform like seventhings, which works without IoT sensors and integrates with existing ERP systems.

How often must a fixed asset register be updated?

The audited fixed asset register is prepared annually for the balance sheet date. However, the underlying inventory data should be maintained continuously, as retroactive corrections shortly before an audit significantly increase the error rate according to ISACA (ISACA, 2024).

What are the consequences of inaccurate fixed asset registers during an audit?

Incorrect or unsubstantiated items lead to audit queries, additional reconciliation efforts, and, in the worst case, qualifications in the audit opinion. KPMG estimates the share of unlocatable assets in audits at 18% (KPMG, 2024).

Can seventhings replace my ERP system for fixed asset accounting?

No. seventhings does not replace an ERP system or financial accounting. The platform provides ongoing reconciliation between book value and physical inventory and feeds this data into your existing fixed asset accounting system.

‍

Conclusion

Excel will not be disappearing from mid-sized company asset accounting anytime soon—but as a sole data source for physical inventory, it is no longer sufficient. Auditors are increasingly evaluating the traceability of the underlying data, not just the book values themselves. An Asset Intelligence Platform closes exactly this gap without calling your existing ERP system into question. Those who perform the reconciliation between book value and physical inventory on an ongoing basis rather than just once a year reduce audit effort and make tied-up capital visible.

‍