Right-of-Use Assets Calculation Template for IFRS 16

Key benefits & value for audit teams and accountants

Designed specifically for firms applying IFRS 16, this Right-of-Use assets template converts complex lease terms into structured, verifiable calculations and disclosures. It reduces manual work, improves consistency across engagements, and supports auditors in forming evidence-based conclusions.

Concrete benefits

• Faster engagement setup: Pre-built input forms for lease contracts, options, and variable payments cut modelling time by up to 60% compared to building models from scratch.
• Stronger audit evidence: Automated reconciliations, sensitivity tables and disclosure notes align with ISA documentation expectations and SOCPA local requirements.
• Reduced risk of errors: Transparent formulas and locked control cells prevent accidental overwrites while leaving inputs editable for client-specific terms.
• Adaptable for reviews: Use the template for client preparation, interim testing, or final reporting — with clear change logs for quality control reviewers.

Use cases & real-life scenarios

Practical examples of how firms use the IFRS 16 ROU template in daily audit and accounting workflows:

1. Year-end audit of a retail chain

Populate multiple lease contracts, select discount rates per currency, and produce consolidated ROU asset schedules with movements (additions, depreciation, remeasurements). Export the schedule to include in the audit file and cross-reference to the fixed asset register.

2. Interim review for a manufacturing client

Use the template’s sensitivity module to test the impact of a change in lease term assumptions and prepare working papers demonstrating significant judgement areas for the engagement partner.

3. Client advisory on transition to IFRS 16

Model different transition approaches and prepare comparative disclosures that show the balance sheet and profit or loss effects to support client decisions and board reporting.

Who is this product for?

Specifically targeted at:

• Audit and accounting firms preparing or reviewing IFRS 16 calculations for multiple clients.
• Legal auditors and statutory auditors who must document lease accounting under ISA and local SOCPA guidance.
• Internal accounting teams that need a reliable lease accounting Excel template to standardise monthly and annual close processes.

How to choose the right version

Not all templates are identical — select based on the complexity of your portfolio:

• Single-entity simple version: Best for small portfolios with straightforward leases (single currency, limited variable payments).
• Multi-lease consolidated version: For firms handling many contracts across currencies and complex indexation clauses.
• Audit pack edition: Includes formatted PDFs, pre-filled workpaper headers and reviewer checklists for immediate audit file integration.

If you are unsure, choose the Multi-lease consolidated version for maximum coverage; it can be simplified for smaller engagements without losing audit trail integrity.

Quick comparison with typical alternatives

When evaluating options, consider these trade-offs:

• Build in-house: Higher initial time and error risk; limited standardisation across teams unless governed tightly.
• Generic accounting software: May automate posting but often lacks transparent audit worksheets and editable calculation cells that auditors need for evidence.
• Specialised template (this product): Balanced — transparent, auditable Excel logic plus documentation tailored to ISA & SOCPA expectations, with immediate usability.

Best practices & tips to get maximum value

• Start each engagement by entering master lease data to create a single source of truth for subsequent reconciliations.
• Lock formulas before sharing with clients; use the change log to record assumptions and reviewer initials.
• Use the sensitivity module to document judgement areas and include summary tables in the audit file to support partner review.
• Train your staff on the template’s structure — a 60‑minute firm-wide walkthrough reduces review time and increases consistency.

Common mistakes when buying/using lease templates and how to avoid them

• Buying the cheapest file: Low-cost, poorly documented templates increase audit risk. Choose a template that includes documentation and a change history.
• Over-customisation without testing: Avoid extensive ad-hoc edits to formula cells. Instead, add client-specific inputs in designated input sheets.
• Ignoring disclosure needs: Ensure schedules map to required IFRS 16 disclosure points; our template includes standard disclosure text blocks for refinement.

Product specifications

• File format: Microsoft Excel (.xlsx), compatible with Excel 2016 or later and Office 365
• Sheets included: Inputs, Lease Ledger, PV calculations, Amortisation, Remeasurements, Sensitivity, Disclosure Notes, Audit Pack
• Functions used: Standard Excel functions; no macros required (optional macro-enabled version available)
• Currencies: Multi-currency with manual consolidation support
• Guidance: Embedded instructions and sample data rows for quick setup
• Support: One month email support for setup questions and a user guide PDF
• Updates: Minor formula updates and guidance notes provided free for 12 months

Frequently asked questions