Excel-Skills.com

Basic or IFRS fixed asset register: which do you need?

Both fixed asset register templates record acquisitions and disposals, calculate monthly and year-to-date depreciation, summarise assets by class and category for the financial statements and produce a journal report. Both roll forward or back by changing one review date.

The choice comes down to depreciation methods, and whether you need revaluations, impairments and deferred tax.

Quick answer: which template should you choose?

Feature comparison

Feature Basic Fixed Assets RegisterIFRS Fixed Assets Register
Depreciation methods Straight-line, diminishing value, double diminishing value Straight-line only
Additions and disposals ✓Yes ✓Yes
Revaluations and impairments –No ✓Yes
Tax values and deferred tax –No ✓Yes
Summaries by asset class and category ✓Yes ✓Yes
Journal report ✓Yes ✓Yes
Roll forward or back from one review date ✓Yes ✓Yes

The templates in detail

Basic Fixed Assets Register Template

Fixed asset register with multiple depreciation methods.

Best for:
Businesses that need depreciation on straight-line, diminishing value or double diminishing value
Not suitable for:
Revaluations, impairments, tax values or deferred tax (use IFRS Fixed Assets Register)

View the Basic Fixed Assets Register template

IFRS Fixed Assets Register Template

Create a fixed asset register which includes revaluations.

Best for:
Businesses that report under IFRS and need revaluations, impairments, tax values and deferred tax
Not suitable for:
Reducing balance or other non-straight-line depreciation (use Basic Fixed Assets Register)

View the IFRS Fixed Assets Register template

Frequently Asked Questions

Which depreciation methods do the asset registers support?
The Basic register supports straight-line, diminishing value and double diminishing value depreciation, on a monthly or daily basis. The IFRS register supports straight-line depreciation only.
Which asset register do I need for revaluations or impairments?
The IFRS Fixed Assets Register. The Basic register only records additions and disposals.
Can the asset register calculate deferred tax?
Yes, the IFRS register calculates tax values and deferred tax. The Basic register does not include tax values.
How many asset classes can I use?
Both registers accommodate up to 30 asset classes, with an unlimited number of assets and asset categories.