What Ind AS 116 changed
The Institute of Chartered Accountants of India notified Ind AS 116 effective from 1 April 2019, aligning Indian accounting with IFRS 16. The standard fundamentally changed how lessees report leases: virtually every operating lease — office space, retail outlets, equipment, vehicles — must now be capitalised as a right-of-use (ROU) asset with a corresponding lease liability.
For a listed Indian company with 200 leased outlets, this transformed quarterly close from a process running on Excel into a process that genuinely cannot be done well in Excel.
The mechanics that drive the complexity:
- 1Present value calculation. Every lease's future cash flows must be discounted at an appropriate rate (typically the incremental borrowing rate) to compute the opening ROU asset and lease liability. A 9-year retail lease with a 6% annual escalation has 108 distinct monthly cash flows; doing this in Excel for 200 leases is technically possible but operationally fragile.
- 1Periodic re-measurement. When lease terms change (option exercise, modification, escalation revision, scope change), the ROU asset and liability must be re-measured with cumulative-effect adjustment to the P&L. Every modification triggers a recalculation.
- 1Interest unwinding. The lease liability unwinds with interest expense each period; the ROU asset depreciates over the lease term. Both must be journalised correctly, and they do not amortise on the same schedule.
- 1Disclosure requirements. The annual report must show ROU by class of asset, lease liability maturity buckets, weighted-average incremental borrowing rate, and reconciliation of opening to closing balances. These disclosures are auditor-tested every year.
- 1Practical expedients. Companies can choose to apply practical expedients (short-term leases under 12 months, low-value leases) but the application must be consistent and disclosable. The choices interact with the accounting in complex ways.
The Excel approach to all this typically takes 10-14 days per quarter, requires a small army of finance analysts, and almost always contains errors that the auditor surfaces during year-end audit.
What proper Ind AS 116 software handles
A purpose-built lease accounting platform does five things that Excel cannot do well at scale:
1. Lease abstraction with classification
Every lease — operating or finance — is abstracted into structured fields: start date, end date, payment schedule, escalation clauses, options to extend, options to terminate, residual value guarantees, and variable lease payments. The platform classifies the lease (Ind AS 116 covers most operating leases under the lessee model) and applies the appropriate accounting treatment.
For lessor accounting (commercial landlords), the platform also handles the operating vs finance lease classification under the lessor model, which Ind AS 116 retained largely from Ind AS 17.
2. Discount rate management
The incremental borrowing rate (IBR) used for present value calculation must reflect the lessee's borrowing cost for a similar asset over a similar tenure. Companies typically maintain a yield curve by tenure (e.g. 7.5% for 3-year leases, 8.2% for 5-year, 9.0% for 9-year) updated quarterly based on actual borrowings or market data.
The platform applies the correct IBR to each lease at inception and re-measurement. The IBR history is audit-trailed so external auditors can verify the rate was set objectively.
3. Monthly journal generation
At each period close, the platform generates the standard journal entries: - ROU asset depreciation (debit P&L, credit ROU asset) - Interest on lease liability (debit P&L, credit lease liability) - Lease payment (debit lease liability, credit bank) - Any modification entries (re-measurement to ROU and liability)
These journals flow into the ERP (SAP, Oracle, Microsoft Dynamics, Tally) via standard connectors. The lease accounting platform is effectively a sub-ledger for leasing that feeds the main GL.
4. Modification and remeasurement engine
When lease terms change, the platform identifies the modification type (scope increase, scope decrease, term extension, payment revision, option exercise) and applies the correct accounting treatment. A scope increase that is not a separate lease triggers re-measurement; a scope decrease triggers de-recognition; an option exercise that was not previously reasonably certain triggers re-measurement.
These rules are mechanical in the standard but very difficult to apply consistently in spreadsheets. A platform applies them deterministically.
5. Disclosures and audit support
The platform auto-generates the standard disclosures: - ROU asset roll-forward by class - Lease liability maturity (< 1 year, 1-5 years, > 5 years) - Weighted-average IBR - Total lease expense for the period - Cash outflow for leases - Future lease commitments - Short-term and low-value lease expense
These flow directly into the financial statements draft, saving the finance team 2-3 days per quarter and eliminating the most common audit observations.
The Excel-vs-platform breakpoint
Below 30 leases, Ind AS 116 in Excel is laborious but feasible. Above 50 leases, it becomes operationally fragile. Above 100 leases, the probability of a material misstatement in any given quarter exceeds 50%.
For a company with 200+ leases, the breakpoint is decisively in favour of a platform. The annual cost of a lease accounting platform (₹8-25 lakh depending on lease count) is far less than:
- The 30+ analyst-days per year spent on Ind AS 116 in Excel (₹15-30 lakh equivalent)
- The audit-fee premium for Ind AS 116 testing of an Excel-based process (₹5-15 lakh)
- The reputational cost of an audit observation or restatement (immeasurable)
What auditors look for
External auditors of Ind AS 116 lessees typically focus on five areas during year-end:
- 1Completeness of lease population. Are all qualifying leases captured? Companies frequently miss vehicle leases, software-licence-as-lease arrangements, and embedded leases in service contracts.
- 1IBR support. Is the discount rate justifiable? The auditor will ask for documented derivation (yield curve from bank, comparable bond yields, etc.).
- 1Modification accounting. When leases were modified during the year, was the right treatment applied?
- 1Disclosure accuracy. Do the maturity buckets reconcile? Does the IBR weighted average tie back to the underlying rates?
- 1Reconciliation to GL. Does the sub-ledger of leases tie to the general ledger ROU and lease liability balances?
A platform that produces clean output across all five areas takes the audit from a multi-week exercise to a few sessions of evidence review. Audit teams (and audit fees) reflect this.
What to look for when evaluating Ind AS 116 software
Five capabilities that separate enterprise-ready platforms from limited tools:
- 1Multi-GAAP support. If the parent reports under IFRS and the Indian entity under Ind AS, the platform should handle both treatments in parallel. Subtle differences (e.g. IBR methodology) exist between IFRS 16 and Ind AS 116.
- 1Modification engine. Test the platform with a real lease modification. It should classify the modification type correctly and apply the right accounting without manual intervention.
- 1ERP integration. Out-of-the-box connectors to SAP, Oracle, Microsoft Dynamics, and Tally with bi-directional sync. CSV uploads are not enterprise-grade.
- 1Audit trail. Every input change, every IBR application, every modification — all logged with user, timestamp, and before/after values. Auditors will ask for this.
- 1Reporting flexibility. Standard disclosures should be one-click. Ad-hoc reporting for management (lease commitment by region, by asset class, by maturity bucket) should not require IT involvement.
A platform that passes all five tests is enterprise-ready. One that misses two or more will create more work than it saves.
The bottom line
Ind AS 116 lease accounting is a structural change to how Indian listed companies handle leases. The complexity is real, the audit scrutiny is intense, and the Excel approach becomes uneconomic above 50 leases.
For finance teams running 100+ leases, the question is not whether to invest in a lease accounting platform — it is which platform fits the company's GAAP scope, ERP environment, and audit relationship.
