Lease Amortization Schedule Template (Excel)

A lease amortization schedule is a detailed plan that outlines the payment schedule for lease liabilities, including principal and interest components, over the life of the lease. It’s essential for accurate lease accounting and compliance with accounting standards like ASC 842 and IFRS 16.

Our Excel template is designed to be user-friendly. Simply input your lease details—such as lease term, interest rate, and payment schedule—into the designated fields. The template will automatically calculate lease liabilities, interest expenses, and right-of-use assets for each period.

A lease amortization schedule is crucial for ensuring compliance with accounting standards like ASC 842 and IFRS 16. It helps you accurately track lease liabilities and expenses over time, ensuring that your journal entries and financial statements reflect the true cost of your leases.

Yes! Our lease amortization schedule Excel template is flexible enough to handle multiple leases. You can manage individual leases within the same template or create separate schedules for each lease, depending on your preference. If you have 10 or more leases, we recommend exploring lease accounting software tools for this.

Amortization expense on a lease is calculated by dividing the ROU asset value at commencement by the lease term, resulting in a straight-line amortization charge recorded each period.