FinoSutra LeaseWorks 116 — Ind AS 116 Excel Workbook (Single Lease Edition)
From lease deed to lease liability, ROU asset and journal entries — in minutes.Stop rebuilding the same Ind AS 116 lease working every time.FinoSutra LeaseWorks 116 is a formula-only Excel workbook designed to prepare complete Ind AS 116 accounting for one lease from a single input sheet. Enter your lease details once, and the workbook automatically generates the lease liability schedule, ROU asset schedule, depreciation, monthly summary, current / non-current split, dashboard and journal entries.Built by a Chartered Accountant working in Ind AS financial reporting — with the practical structure finance teams, reviewers and auditors expect.What this workbook does1) Lease Liability ScheduleMonth-by-month amortisation schedule for the full lease term with: Opening lease liability Lease payment Finance cost Principal reduction Closing lease liability 2) ROU Asset & Depreciation ScheduleAutomatically prepares: Initial ROU asset Initial direct cost impact Straight-line depreciation over the lease term Year-end carrying amount by FY 3) Monthly Accounting SummaryClean monthly output of: Cash rent paid Finance cost Depreciation Total P&L charge FY subtotals for review 4) Journal EntriesAuto-prepared accounting entries including: Initial recognition JE Year-end finance cost summary Year-end depreciation summary Lease payment impact Auto-written narrations 5) Current / Non-Current SplitUseful for Schedule III classification and reporting.6) Dashboard & Review OutputsA one-page summary view with key balances and review-friendly outputs.Supports practical lease cases like: Rent escalations / revised rent Rent-free periods Payment in advance or arrears Initial direct costs Indian FY (April–March) Single lease modelling up to 360 months Why this workbook is useful 100% formula-based — no macros, no VBA Excel 2016+ compatible Built for practical Ind AS 116 work Helpful for CAs, finance teams, corporate accountants and consultants Structured outputs for review, documentation and audit support Includes a pre-filled worked example What you get 1 Excel workbook (.xlsx) 1 Quick Start PDF Pre-filled worked example inside the workbook Important: What this edition does NOT coverThis edition is built for single-lease initial measurement and monthly accounting. It does not currently cover: Lease modifications / reassessments after commencement Security deposit accounting Variable or index-linked rentals Quarterly / annual payment frequencies Mid-month commencement Purchase options / residual value guarantees Full Ind AS 116 disclosure pack Multi-lease portfolio management If your lease includes the above scenarios, this workbook may not be the right fit for that case.Product Specs Format: Excel workbook (.xlsx) + Quick Start PDF Compatibility: Excel 2016 / 2019 / 2021 / Microsoft 365 Macros: None Lease capacity: 1 lease, up to 360 months Standard: Ind AS 116 – Leases FY basis: April–March Version: 1.0 SupportFor support, contact: fino.sutra07@gmail.comPlease include your order ID, Excel version and a short description of the issue.DisclaimerThis workbook is a calculation aid only and does not constitute accounting, legal or tax advice. Users are responsible for verifying lease inputs, assumptions and outputs for their own facts and circumstances.
Get it → finosutra.gumroad.com