Lease Data Pack – IFRS 16 Inputs – Excel Templates
63.56 $
IFRS 16 Lease Contracts Input Pack: Consolidates contract details, payment schedules, renewal/termination options, and IBR into a standardized input file. Delivers a measurement-ready data pack and liability schedules for multi-contract adoption.
Lease Data Pack (IFRS 16 Inputs for Lease Contracts)
A standardized Excel template for preparing IFRS 16 Inputs for lease contracts: contract data, Lease Payment Schedule, Extension and Termination Options, and documentation of Incremental Borrowing Rate (IBR) — ensuring inputs are “complete and auditable” before any calculations or postings.
Value Proposition:
Most IFRS 16 errors stem not from the calculation model, but from the data:
a contract without a correct start date, an incomplete payment schedule, an “undocumented” extension option, or inconsistent IBR across contracts.
This Lease Data Pack transforms each contract into a “Data Card + Payment Schedule + Decision File for Options + Discount Rate Reference”.
The result: Lease Liability and ROU figures become traceable and reviewable from the first instance.
In 20 seconds: What will you get?
- Lease Contract Master: A standardized record of contracts (Contract ID / Lessor / Asset / Location / Currency).
- Payment Schedule: Lease Payment Schedule (Fixed/Step-up/Free Rent/Indexed) with due dates.
- Options Register: Extension and Termination Options + “Reasonably Certain” assessment with documented rationale.
- IBR Table: Incremental Borrowing Rate (IBR) by currency/term/risk classification + approval date and source.
- Indexation & Variable Payments: Documentation of variable payments and what is included/excluded in initial measurement.
- Non-lease Components: Separation of service components (if any) prior to measurement (optional).
- Portfolio Tags: Portfolio classification (Real Estate/Vehicles/Equipment/Branches) for cleaner reporting.
- Controls: Data completeness alerts (Missing IBR / Missing Payments / Dates Issues).
- Export Views: Pages ready for export to any IFRS 16 calculator or Lease Accounting system.
Suitable for
- Finance teams consolidating lease contracts from multiple branches needing a “standardized dataset”.
- Companies working in Excel or transferring data to an IFRS 16 system.
- Entities needing a robust “Inputs” file for auditor delivery (Audit-ready Inputs Pack).
Not Suitable for
- Companies not applying IFRS 16 or lacking significant lease contracts.
- Those seeking only an “IFRS 16 calculator” without organizing inputs — this product focuses on data quality as the foundation for calculations.
Without Lease Data Pack / With Lease Data Pack
| Item | Without the Pack | With the Pack |
|---|---|---|
| Contract Data | Scattered/Incomplete | Standardized Contract Master + Mandatory Fields |
| Payment Schedule | Missed periods/Free rent/Indexation | Organized Schedule + Payment Types + Accurate Dates |
| IBR | Inconsistent/Undocumented | IBR Table with Reference + Approval Date + Selection Logic |
| Options | Undocumented decision | Options Register + Reasonably Certain rationale |
| Audit | Comments on completeness and assumptions | Checks + Evidence fields + export-ready views |
Before Use: 5 Symptoms That Your IFRS 16 Inputs Are “Not Accurate”
- Differences in Lease Liability between each update cycle due to missing payments or incorrect dates.
- Extension/termination options decided “verbally” without rationale, creating disputes with auditors.
- IBR used uniformly across contracts despite differing terms/currencies/risks.
- Variable payments (Indexation) included or excluded without documentation.
- Difficulty in preparing a single file for audit delivery as an “Inputs Pack”.
After Implementation (Two Points Only)
- Consistency: Each contract has a standardized dataset (Contract + Payments + Options + IBR) without gaps.
- Auditability: Each decision (IBR/Options/Payments) is documented with reference, date, and selection logic.
How Does the Lease Data Pack Work in Practice?
1) Building the Contract Master
- Unique Lease ID + Lessor data + Asset description + Location + Contract currency.
- Commencement date + lease term + payment frequency + payment timing (advance/arrears).
- Separation of lease/non-lease components if necessary (optional).
2) Preparing the Lease Payment Schedule
- Recording Payment/Period: Due Date + Amount + Type (Fixed / Step-up / Free rent / Index-linked).
- Documenting variable payments: what is included in initial measurement and what is treated as period expense.
3) Documenting Options (Extension / Termination Options)
- Identifying the option and its activation date/impact on the term.
- Assessing Reasonably Certain + rationale: (Termination penalties, strategic location, relocation costs, renewal dates…).
4) Determining the Discount Rate (IBR) and Linking it to the Contract
- IBR Table by currency/term/credit rating/portfolio.
- Linking IBR to the contract with approval date and source of methodology (internal/external/financing).
5) Data Quality Checks (Controls)
- Missing fields: Commencement/Term/IBR/Payments.
- Illogical dates: end before start, payments outside the term.
- Consistency: Frequency does not match the number of payments, contract currency does not match IBR table.
Deliverables Included in the Excel File
- Contracts (Master): Core contract data.
- Payments: Detailed Lease Payment Schedule.
- Options: Extension and termination options + rationale.
- IBR Table: Discount rates with selection rules.
- Index/Variables: Documentation of variable payments (optional).
- Controls: Completeness/consistency checks + alerts.
- Export Views: Pages ready for upload into IFRS 16 system or auditor delivery.
If you want IFRS 16 results to be “correct from the first time,” start with the inputs
| المسمّى الوظيفي | |
|---|---|
| Duration | |
| المستوى | |
| التحديثات | |
| القطاع | |
| الصيغة |

Reviews
Clear filtersThere are no reviews yet.