More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Lease Accounting Engine (Ind AS 116 / IFRS 16)

    1

    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

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    Lease Accounting Engine (Ind AS 116 / IFRS 16)

    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.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    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

    Requires

    Python 3
    openpyxl

    Permissions

    File Scopes

    leases.json
    and
    the
    generated
    .xlsx
    in
    working
    folder

    No network access.

    Listed23 days ago

    What's inside

    Frequently Asked Questions

    No. Every number is a live formula linked to the Inputs sheet, so you can change the rate, rent or escalation and everything recalculates.

    Yes, both advance and arrears, with escalation every N months, initial direct costs, incentives, restoration and prepaid rent.

    Yes. The FY Summary shows IGAAP rent and the P&L impact versus Ind AS 116, which is useful for branch and management reporting.

    New in Finance & Accounting