IAS 38 intangible assets template
An Excel template that applies IAS 38 from the first research spend to the note. It tests each development project against the six criteria in IAS 38.57, runs an intangible asset register with monthly amortisation, impairment and disposals, applies the IFRIC agenda decisions on cloud computing arrangements, and produces the reconciliation by class, the journals and the disclosures. It comes with a fully worked example for a fictitious Irish health software company.
What it does
Tests up to 10 projects against the six criteria in IAS 38.57 and splits the year's costs into research and pre-criteria costs, directly attributable costs to capitalise and other costs to expense (IAS 38.54–67), without ever reinstating costs already expensed (38.71).
Runs a register of up to 15 assets by class and source – internally generated, separately acquired, business combination or government grant – with straight-line amortisation from the month each asset is available for use (IAS 38.97), on the remaining carrying amount after any impairment.
Handles indefinite-life assets and assets not yet available for use, flagging the annual impairment test (IAS 36.10), and records impairment losses, reversals and disposals with the gain or loss (IAS 38.112–113).
Applies the IFRIC decisions on software as a service: whether the entity controls software, and whether configuration and customisation costs are expensed when received, spread over the contract term as a prepayment, or capitalised as a separate resource.
Produces the IAS 38.118 reconciliation by class for the current and prior year, research and development expensed (38.126), indefinite-life and fully amortised assets still in use, and the journals.
Drafts the note – accounting policy, useful lives by class and other disclosures – with a 16-point checklist and 24 automatic checks.
What it does not do
It does not cover goodwill, the revaluation model, intangible assets held for sale or exploration and evaluation assets.
Impairment losses and the fair values of assets acquired in a business combination are entered, not calculated.
What you get
One Excel workbook (.xlsx) with Instructions, the blank template and a worked example: Boyne Health Analytics Ltd, with a development project that meets the criteria mid-year, a project still in research, a platform reaching the end of its life, acquired customer relationships and an indefinite-life brand, an impaired licence, a disposal and three cloud computing arrangements.
Clearly marked input cells, protected formulas and built-in checks, with a status line on every tab.
Works in Microsoft Excel 2010 or later (Windows or Mac). No macros.
Scope
IAS 38 Intangible Assets as issued by the IASB at October 2026, with the IFRIC agenda decisions on cloud computing arrangements (March 2019 and April 2021), for one entity in one currency under the cost model, with IAS 1 or IFRS 18 presentation. The full scope and limitations are set out in the Instructions tab.
Testing an asset or a cash-generating unit for impairment? Use the CGU impairment template. Valuing customer relationships and brands on an acquisition? See the IFRS 3 acquisition accounting template.
Designed for finance teams, auditors and advisers preparing or reviewing IFRS financial statements. It is a working aid: it does not replace the Standards or professional judgement, and its scope and limitations are set out in the Instructions tab. The worked example is fictitious.



