Generate an Audit-Ready Depreciation Schedule

By Gregg Hopfeldt · 2025-05-19

A defensible depreciation schedule provides auditors and stakeholders with a stable, verified record of how asset values reduce over time—consistent calculation logic, no formula drift, and a clear trail from cost to carrying value.

What Makes a Depreciation Schedule Audit-Ready?

An audit-ready schedule is defined by three things: consistency in calculation logic, a clear reconciliation of asset movements (additions and disposals), and a locked historical trail that prevents "post-closing" surprises. When these elements are in place, the schedule becomes a document you can hand to an auditor with confidence—not something you scramble to reconstruct when the questions start.

Purpose

Producing an audit-ready depreciation schedule ensures your fixed asset register reflects accurate, repeatable figures that reconcile to your general ledger and remain unshakeable under external review.

Logic

The schedule draws from category-based depreciation settings that govern how each asset class reduces in value. Two verified methods apply:

  • Straight Line — Reduces the asset by an equal amount each year over its useful life.

  • Diminishing/Reducing Balance — Applies a fixed percentage to the remaining book value each year, producing higher depreciation in earlier years.

Every asset inherits its rate and method from the category configuration. The calculation logic remains consistent across the register—no manual overrides, no ad-hoc adjustments, and no last-minute reconciliations.

I've seen too many accountants "force" a spreadsheet to reach the number they want for a year-end close. They think it's a one-time fix, but they roll that broken logic forward into the next year, and the year after that. By the time an auditor looks at it, the document is unusable. We built the Audit Report to be the antidote to that "manual force"—it produces the truth, not a convenience.

The register calculates depreciation up to the beginning of the current financial year and for the current year, anchored to the financial year start date in your settings. This produces a stable, point-in-time view suitable for audit workpapers.

Steps

Verify depreciation settings

Open the Fixed Asset Register, select Settings, and confirm each category has the correct Rate (%) and Method. Ensure the Start of the Financial Year is accurate. See Set depreciation rates and methods.

Complete all disposals

Record any assets sold, scrapped, or otherwise removed during the period. Disposed assets are excluded from the schedule, preventing ghost assets in your figures. See Dispose of assets in your register.

Generate the audit report

Click More and select Generate Audit Report. In the dialog, verify the header fields—Company Name, Report Title, Prepared By, Report Date—and adjust via Edit Header if needed. Export as PDF for a formatted document or Excel for a CSV suitable for spreadsheet import.

Review the output

Confirm the summary section shows Cost, Accumulated Depreciation, and Carrying Value by category. Verify the Reconciliation Section traces opening balance through additions, disposals, depreciation, and closing balance. The footer notes whether straight-line or reducing balance was applied.

This is the moment where the "Protective Expert" hands you the shield. The Reconciliation Section in Simple Fixed Assets does the heavy lifting for you, tracing every movement from opening to closing balance so you can answer an auditor's question before they even ask it.

Outcome

A stable, audit-ready depreciation schedule: a clear ledger with zero ghost assets, a reconciliation that traces every movement, and verified calculation logic that aligns with your accounting policy. The exported file provides a quietly confident record you can attach to audit workpapers or file for internal review—defensible, consistent, and free of surprises.

Before year-end close

If you are producing this schedule as part of a year-end process, the final step is to archive the current period and roll forward. See Roll over to a new financial year. The rollover creates a history record that documents the transition between periods—an additional layer of audit trail for your fixed asset records.

Common issues

  • Stale depreciation values: Run Recalculate before generating the report to ensure all figures are current. This refreshes the register so your output reflects the latest entries.

  • Missing assets in the schedule: Clear filters and verify the register is not grouped in a way that hides rows. A quick filter reset often reveals what appeared to be missing.

  • Figures do not reconcile: Confirm depreciation settings match your accounting policy and that all disposals are recorded. The reconciliation can only trace what the register contains.

  • Wrong period: Verify the Start of the Financial Year in settings and complete rollover if reporting on a prior year. The schedule always anchors to the financial year date in your configuration.

For the practical steps, see our help guide on generating an audit report.

Stay Depreciated,

Gregg