- Home
- Skills
- Finance & Accounting
- Lease Accounting Engine (Ind AS 116 / IFRS 16)
More screenshots
Works with the AI Agents you already use
Lease Accounting Engine (Ind AS 116 / IFRS 16)
Turns lease agreements into a live-formula Excel Ind AS 116 / IFRS 16 model: liability and ROU schedules, FY summary, journal entries, maturity analysis and IGAAP rent view.
$5
Lease Accounting Engine (Ind AS 116 / IFRS 16)
Example session with this skill installed
Two leases: Office A from 1 Apr 2024, 60 months, Rs 1,00,000 a month in advance, 5% annual escalation, IBR 10%, Rs 50,000 brokerage. Warehouse B from 1 Oct 2024, 36 months, Rs 50,000 in arrears, IBR 9%. FY April-March.
- Read your context and instructions
- Compiled the lease accounting engine
Initial lease liability: Office A Rs 52.47 lakh and Warehouse B Rs 15.80 lakh. ROU asset for A is Rs 52.97 lakh including brokerage. FY2025: interest Rs 5.25 lakh, depreciation Rs 13.23 lakh, closing liability Rs 58.52 lakh (current Rs 13.80 lakh). P&L is Rs 3.47 lakh higher than IGAAP rent in FY2025 and reverses in later years. Every lease ends at zero, and the Excel file recalculates if you change the IBR.
Connects securely to your tools. The creator never sees your data.
About this skill
Built by a listed-company CFO who ran Ind AS 116 for dozens of office leases and defended the workings to auditors every quarter.
Share lease agreements or your lease register. The skill applies the judgements auditors check: lease term with renewal and lock-in options, short-term and low-value exemptions, non-lease components, index-linked rent, and interest-free security deposits. It then builds an Excel model where every number is a live formula.
You get:
- Monthly liability and ROU schedules per lease, handling escalations, advance or arrears payments, initial direct costs, incentives and restoration
- A financial-year summary with the current/non-current split and closing ROU NBV
- Commencement journal entries
- An undiscounted maturity analysis for disclosure
- An IGAAP view showing the P&L difference against straight contractual rent, ideal for branch and management reporting
Built-in checks: every liability runs to zero, and total principal equals the initial liability. A tested Python engine is included.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Lessee accounting; lease modifications and ASC 842 operating-lease straight-line presentation are flagged for separate handling. Judgements (lease term, IBR) need your confirmation.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 23 days ago
- Software
Python 3openpyxl
- Optional
- LibreOffice
LibreOffice recalculates and verifies the workbook.
Permissions
File Scopes
No network access.