How to Build an Audit-Ready Fixed Asset Depreciation Schedule

A fixed asset depreciation schedule is one of the core supporting schedules behind a company's balance sheet and income statement. At first glance, its purpose appears simple: calculate how much depreciation should be recognised for each asset.

In practice, a good depreciation schedule does considerably more.

It should explain what assets the business owns, when they were acquired, when depreciation started, how much depreciation has been recognised, which assets have been disposed of and how the closing balance reconciles with the financial statements.

When organised properly, the schedule also becomes an important part of the year-end accounting and audit process.

What Is a Fixed Asset Depreciation Schedule?

A depreciation schedule records the cost and depreciation history of a company's fixed assets. For each asset, it normally calculates:

Original cost − accumulated depreciation = net book value

The schedule may cover categories such as the following. Different categories will often have different useful lives and depreciation assumptions.

• Land

• Buildings

• Plant and machinery

• Motor vehicles

• Computer equipment

• Furniture and fittings

• Office equipment

  
  

Simple Depreciation’s PP&E movement schedule reconciles opening and closing fixed asset balances, including additions, disposals, depreciation and net book value, with current and comparative period views.

What Information Should a Depreciation Schedule Include?

A robust fixed asset schedule should include sufficient information to identify each asset and understand how its depreciation has been calculated. Important fields commonly include:

• Asset reference - Each asset should have a unique identifier. A reference such as FA0001 or VEH003 makes it easier to follow the asset through the register, journals and supporting documents.

• Asset description - The description should clearly identify the asset. Descriptions such as "equipment" or "computer" may be too broad once the register grows.

• Asset category - Grouping assets into categories makes it possible to apply consistent accounting assumptions. For example, all IT equipment could use one useful life while buildings use another.

• Acquisition date - This records when the business acquired the asset.

• In-use date - The date an asset was purchased is not necessarily the date depreciation should begin. Keeping an in-use date separately can therefore provide a more accurate record of when the asset became available for use.

• Original cost - This represents the capitalised cost attributed to the asset.

• Residual value - Where relevant, the expected residual value at the end of the asset's useful life reduces the depreciable amount.

• Useful life - The useful life determines the period over which the depreciable amount is allocated.

• Accumulated depreciation - This is the total depreciation recognised on the asset up to the reporting date.

• Net book value - The net book value is calculated as: Asset cost − accumulated depreciation

• Disposal information - Where an asset has been sold, scrapped or otherwise disposed of, the schedule should retain information such as: Disposal date, Disposal proceeds, Cost removed, Accumulated depreciation removed and Gain or loss on disposal

  
  

How Straight-Line Depreciation Works

Straight-line depreciation allocates the depreciable amount of an asset evenly over its useful economic life. The formula is:

Annual Depreciation = (Asset Cost − Residual Value) ÷ Useful Life

For example, assume a business purchases equipment for €100,000.

• The estimated residual value is €10,000 and the useful life is six years.

• The depreciable amount is: €100,000 − €10,000 = €90,000

• Annual straight-line depreciation is therefore: €90,000 ÷ 6 = €15,000

After the first full year, assuming no other adjustments:

• Cost: €100,000

• Accumulated depreciation: €15,000

• Net book value: €85,000

After the second full year:

• Cost: €100,000

• Accumulated depreciation: €30,000

• Net book value: €70,000

The calculation is simple for one asset. The challenge comes when hundreds of assets have different acquisition dates, useful lives, residual values and disposal dates.

Why Period-Based Depreciation Matters

Annual depreciation alone may not be sufficient. A business preparing monthly or quarterly management accounts may need depreciation calculated at different reporting dates. For example, an asset acquired halfway through a financial year may not receive a full year's depreciation depending on the company's accounting policy.

A fixed asset system should therefore be capable of applying the appropriate depreciation convention consistently. This is one reason automated depreciation schedules can become more useful as an asset register grows.

The Importance of the PP&E Movement Schedule

Individual asset calculations need to reconcile to the overall property, plant and equipment balance. A PP&E movement schedule provides this reconciliation.

For asset cost, the relationship is broadly:

Opening Cost + Additions − Disposals = Closing Cost

Accumulated depreciation follows a similar movement:

Opening Accumulated Depreciation + Depreciation Charge − Accumulated Depreciation on Disposals = Closing Accumulated Depreciation

Finally:

Closing Cost − Closing Accumulated Depreciation = Closing Net Book Value

These relationships provide useful control checks over the fixed asset register.

Example PP&E Movement

Assume a company begins the year with:

• Opening cost: €500,000

• Opening accumulated depreciation: €180,000

• Opening net book value: €320,000

During the year it purchases €80,000 of assets and disposes of assets originally costing €20,000.

• The closing cost becomes: €500,000 + €80,000 − €20,000 = €560,000

• If the depreciation charge for the year is €55,000 and accumulated depreciation of €12,000 relates to assets disposed of, Closing accumulated depreciation = €180,000 + €55,000 − €12,000 = €223,000

• Closing net book value is therefore: €560,000 − €223,000 = €337,000

  
  

This type of reconciliation helps demonstrate how the opening balance moved to the closing balance.

Calculating Gains and Losses on Disposal

Suppose a machine originally cost €50,000 and has accumulated depreciation of €35,000 when it is sold.

• Its net book value is: €50,000 − €35,000 = €15,000

• If it is sold for €18,000: Gain on disposal = €18,000 − €15,000 = €3,000

• If instead it is sold for €11,000: Loss on disposal = €15,000 − €11,000 = €4,000

The depreciation schedule should therefore interact with the disposal records rather than treating the two processes independently.

What Makes a Fixed Asset Schedule Audit-Ready?

There is no single format that guarantees an asset register is audit-ready. However, several characteristics make the process considerably easier.

• Clear asset identification - Each asset should have a unique reference and meaningful description.

• Consistent assumptions - Useful lives, depreciation methods and residual values should be applied consistently unless there is a justified reason for differences.

• Historical records - Disposed assets and changes should remain traceable.

• Supporting movement schedules - Opening balances should reconcile to closing balances through additions, disposals and depreciation.

• Reproducible calculations - Someone reviewing the schedule should be able to understand how the depreciation charge was calculated.

• Accounting-ready outputs - Depreciation and disposal calculations should be capable of supporting journal entries.

• Exportable reports - PDF and CSV outputs can make it easier to provide schedules to accountants, auditors and other reviewers.

Useful Reports to Prepare

A good year-end fixed asset reporting package could contain:

1. Fixed asset register

2. Asset additions schedule

3. Disposals schedule

4. Depreciation summary

5. PP&E movement schedule

6. Depreciation journal entries

7. Disposal gains and losses

8. Asset category summary

9. Supporting validation checks

Combining these outputs into an organised audit pack can reduce the amount of information that needs to be assembled manually at year-end.

Using Software to Maintain the Schedule

A spreadsheet can perform all these calculations, particularly when the asset population is small. However, managing formulas, reporting periods, disposal calculations and reconciliation schedules can become more difficult as the register expands.

Simple Depreciation brings these processes together within an online fixed asset management application. Users can maintain asset records, define categories and useful lives, calculate depreciation, record disposals and generate reporting outputs from the same underlying information.

The application also supports PDF and CSV reports and audit pack downloads, helping finance teams organise the information required for accounting and review purposes.

Dashboards Add Another Layer of Control

Fixed asset accounting is often viewed primarily as a compliance exercise.

However, the asset register also contains useful management information.

A dashboard can help finance teams monitor:

• Total asset cost

• Net book value

• Current depreciation

• Additions during the year

• Disposals

• Average asset age

• Assets by category

• Depreciation trends

For capital-intensive businesses in particular, understanding how the asset base is changing can support budgeting and capital expenditure planning.

Simple Depreciation’s dashboard brings together key fixed asset metrics, including asset cost, net book value, depreciation, additions and disposals, with visual summaries of asset categories and depreciation trends.

Build the Schedule Around a Clear Process

The quality of a depreciation schedule depends on more than the software used to prepare it. Businesses should establish a consistent process:

• Step 1: Define asset categories and useful lives.

• Step 2: Record new assets promptly.

• Step 3: Distinguish acquisition dates from in-use dates where required.

• Step 4: Review depreciation calculations periodically.

• Step 5: Record disposals rather than deleting assets.

• Step 6: Reconcile the register to the general ledger.

• Step 7: Review the PP&E movement schedule.

• Step 8: Produce depreciation journals and supporting reports.

• Step 9: Retain the information required for year-end and audit review.

Following a structured process makes the fixed asset register significantly easier to maintain throughout the year.

From Depreciation Calculation to Fixed Asset Control

A good fixed asset depreciation schedule should be more than a list of assets and depreciation formulas. It should provide a clear record of the company's asset base and explain the movement from opening balances to closing balances.

When additions, depreciation, disposals, journals and PP&E reporting are connected, the schedule becomes easier to review and significantly more useful to the finance team.

Whether maintained in Excel or dedicated fixed asset software, the objective should remain the same: clear records, consistent calculations, transparent assumptions and reliable reporting.

For businesses looking to simplify this process, Simple Depreciation provides an online way to maintain the asset register and produce depreciation and fixed asset reporting from one central source.

Explore Simple Depreciation here: https://simpledepreciation.com/