Why Depreciation Schedules Break During Audits

By Gregg Hopfeldt · 2025-05-20

If you're a finance manager dealing with depreciation audit failures, here is how to get a defensible schedule without spreadsheet drift and manual reconciliation.

Auditors ask three questions:

1. Show me the original cost
2. Prove the method election
3. Demonstrate the placed-in-service date

If your depreciation schedule cannot answer all three without a manual rebuild, the audit fails before it begins.

Most failures are not arithmetic errors—they are missing evidence. Depreciation is not complex because of the calculations. It is complex because the assumptions behind the calculations must be documented, consistent, and verifiable across the asset's entire life.

The Boring Math Auditors Expect

Straight-Line Depreciation

Annual Depreciation = Cost ÷ Useful Life

The straight-line method spreads the cost evenly over the asset's useful life. The auditor will verify that the cost basis is correct, the useful life matches your stated policy, and the method election is applied consistently.

Reducing Balance Depreciation

Annual Depreciation = Carrying Value × Rate (%)

The reducing balance method applies a fixed percentage to the remaining book value each year. The auditor will verify the rate is appropriate, the calculation logic does not shift between years, and any switch to straight-line is documented.

Disposal Gain or Loss

Gain/Loss = Sale Price − Book Value at Disposal

Book Value = Cost − Accumulated Depreciation to Disposal Date

The Reconciliation Check

Auditors expect a reconciliation that traces:

Opening Balance + Additions − Disposals − Depreciation = Closing Balance

If this equation does not hold, the schedule is broken.

Why Depreciation Schedules Break During Audits

Audit failures fall into six categories. Most are not math errors—they are assumption and documentation failures.

1. Wrong Asset Classification

An asset is placed in the wrong category, and the depreciation rate or useful life does not match the asset's actual economic life.

2. Incorrect Placed-in-Service Date

Depreciation begins when the asset is placed in service, not when it is purchased. If the date is wrong, every subsequent calculation is wrong.

3. Method or Rate Changes Without Documentation

A rate or method is changed mid-life, and the historical depreciation is either recalculated retroactively or left inconsistent with the new election.

4. Missing or Late Disposals

An asset is sold, scrapped, or stolen, but the disposal is never recorded. The asset continues to depreciate, inflating accumulated depreciation and understating net income.

5. Spreadsheet Formula Drift

A formula is edited, a row is deleted, or a cell is overwritten. The schedule no longer reconciles, and there is no audit trail to identify when the break occurred.

6. Weak Documentation

The auditor requests support for the cost basis, the method election, or the useful life assumption. The documentation does not exist or cannot be located.

The Audit Trail Problem

Spreadsheets do not maintain an audit trail. If a cell is changed, the prior value is lost. If a row is deleted, the asset disappears from the schedule with no record of its existence.

A defensible audit trail requires:

• Historical depreciation values that cannot be retroactively edited
• A record of each asset's classification, method, rate, and placed-in-service date
• A disposal record that includes the date, sale price, accumulated depreciation, and gain/loss
• A reconciliation that traces opening to closing balance with no unexplained differences

From Spreadsheet to Defensible Register

Simple Fixed Assets replaces the spreadsheet with a structured register that preserves calculation logic and prevents drift. When you change a rate or method in Simple Fixed Assets, the historical depreciation is not rewritten. The change applies prospectively, and the prior values remain as a locked record.

The Reconciliation Report

The Asset Depreciation Report includes cost, accumulated depreciation, and carrying value for each active asset, plus a reconciliation section tracing opening balance through additions, disposals, depreciation, and closing balance.

From the Fixed Asset Register, click More and select Generate Audit Report. Export via PDF or Excel for auditor delivery.

Zero Ghost Assets

A ghost asset is an asset that has been physically disposed but remains on the register, continuing to depreciate. Simple Fixed Assets prevents ghost assets by requiring disposal recording before the asset is excluded from depreciation. The disposed asset remains in the register with a full record of the disposal transaction.

Tax Depreciation vs. Financial Reporting Depreciation

GAAP and tax rules use different depreciation methods. Maintain separate schedules for tax and financial reporting and document each independently.

The Payoff

Depreciation schedules break during audits because the assumptions behind the math are undocumented, inconsistent, or unsupported—not because the arithmetic is wrong. A defensible schedule requires locked historical values, a reconciliation that traces opening to closing balance, and documentation that survives auditor questioning. Simple Fixed Assets provides the structure to maintain that schedule without manual reconstruction.

For the practical steps, see how to generate a defensible audit report.

Stay Depreciated,

Gregg