{"product_id":"ifrs-16-lease-schedule-excel-template","title":"IFRS 16 Lease Schedule Excel Template","description":"\u003ch3\u003eProduct Description\u003c\/h3\u003e\n\u003cp\u003eSimplify your lease accounting with this practical IFRS 16 Lease Schedule Excel Template. Designed to help businesses calculate and track lease liabilities, right-of-use assets, interest expense, depreciation, lease payments, and disclosure balances, this template provides a clear and structured way to manage IFRS 16 lease accounting requirements.\u003c\/p\u003e\n\u003cp\u003eWhether you are preparing monthly management accounts, year-end audit schedules, financial statement disclosures, or internal lease reconciliations, this template gives you an organised and easy-to-use format for tracking lease obligations over the full lease term.\u003c\/p\u003e\n\u003ch3\u003eKey Features\u003c\/h3\u003e\n\u003cp\u003eTrack lease details including lease start date, end date, payment amount, payment frequency, discount rate, and lease term\u003c\/p\u003e\n\u003cp\u003eAutomatically calculates opening lease liability, interest expense, lease payments, and closing lease liability\u003c\/p\u003e\n\u003cp\u003eCalculates right-of-use asset depreciation over the lease period\u003c\/p\u003e\n\u003cp\u003eProvides monthly IFRS 16 amortisation schedule\u003c\/p\u003e\n\u003cp\u003eIncludes current and non-current lease liability split\u003c\/p\u003e\n\u003cp\u003eIncludes lease maturity disclosure analysis\u003c\/p\u003e\n\u003cp\u003eGenerates basic journal entry outputs for lease accounting\u003c\/p\u003e\n\u003cp\u003eClean, professional Excel layout\u003c\/p\u003e\n\u003cp\u003eEasy-to-edit format for different lease agreements\u003c\/p\u003e\n\u003cp\u003eUseful for accountants, finance teams, auditors, and business owners\u003c\/p\u003e\n\u003ch3\u003eShort Product Summary\u003c\/h3\u003e\n\u003cp\u003eA professional IFRS 16 Lease Schedule Excel Template designed to help businesses calculate, track, and reconcile lease liabilities, right-of-use assets, interest, depreciation, and disclosure balances in one easy-to-use workbook.\u003c\/p\u003e\n\u003ch3\u003eBenefits Section\u003c\/h3\u003e\n\u003cp\u003eWith this template, you can quickly calculate the IFRS 16 impact of lease agreements and maintain a clear monthly record of lease accounting movements. It helps reduce manual calculation errors, supports audit preparation, improves lease reconciliation, and provides a structured view of lease liabilities and right-of-use asset balances over time.\u003c\/p\u003e\n\u003cp\u003eThe template is especially useful for businesses that need a practical working file to support monthly reporting, annual financial statements, and IFRS 16 disclosure requirements.\u003c\/p\u003e\n\u003ch3\u003eWhat’s Included\u003c\/h3\u003e\n\u003cp\u003eIFRS 16 Lease Schedule Excel file\u003c\/p\u003e\n\u003cp\u003eLease input register\u003c\/p\u003e\n\u003cp\u003eMonthly lease liability amortisation schedule\u003c\/p\u003e\n\u003cp\u003eRight-of-use asset depreciation schedule\u003c\/p\u003e\n\u003cp\u003eCurrent and non-current liability calculation\u003c\/p\u003e\n\u003cp\u003eLease maturity disclosure section\u003c\/p\u003e\n\u003cp\u003eJournal entry summary\u003c\/p\u003e\n\u003cp\u003eAutomatic calculation formulas\u003c\/p\u003e\n\u003cp\u003eProfessional formatted layout\u003c\/p\u003e\n\u003cp\u003eEditable fields for your own lease agreements\u003c\/p\u003e\n\u003ch3\u003eWho This Is For\u003c\/h3\u003e\n\u003cp\u003eThis template is perfect for accountants, bookkeepers, finance managers, auditors, business owners, and small to medium-sized businesses that need a simple and practical IFRS 16 lease accounting schedule.\u003c\/p\u003e\n\u003cp\u003eIt is ideal for anyone who wants to calculate and track lease liabilities, right-of-use assets, interest expense, depreciation, and IFRS 16 disclosure balances in a structured Excel format.\u003c\/p\u003e","brand":"TP Finance Templates","offers":[{"title":"Default Title","offer_id":47006702207132,"sku":null,"price":499.0,"currency_code":"ZAR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0746\/5772\/6620\/files\/ChatGPTImageJun3_2026_12_41_12PM.png?v=1780483292","url":"https:\/\/tpfinancetemplates.com\/products\/ifrs-16-lease-schedule-excel-template","provider":"TP Finance Templates","version":"1.0","type":"link"}