What is a lease amortization schedule?

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.

How do I use the Lease Amortization Schedule Excel template?

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.

Why is a Lease Amortization Schedule important for lease accounting?

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.

Can I use this template for multiple 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.

How do you calculate amortization expense on a lease?

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.

Lease Amortization Schedule

With our Lease Amortization Schedule Excel Template, seamlessly calculate your lease liability and ROU asset for your lease portfolio.

As any commercial tenant knows, a solid lease amortization schedule is crucial for ensuring compliance with accounting standards like ASC 842 and IFRS 16. We built this free calculator to help you with:

Complex calculations — Accurately track interest, principal, and payments.
Centralize lease data — Organize all payment schedules in one sheet.
Stay audit-ready — Maintain clear, GAAP-compliant lease records.

‍

Lease Amortization Schedule – Excel Template

Occupier’s lease amortization schedule is crafted to streamline your lease accounting processes, from creating journal entries to measuring leases. Effortlessly calculate lease liabilities, interest expenses, and right-of-use assets—all within a user-friendly Excel template. This template isn’t just a tool; it’s your go-to resource for ensuring compliance and staying organized. Whether you’re managing a single lease or an entire portfolio, our template adapts to your needs. Managing a large lease portfolio? We’ve got software that scales with you, making lease measurements a breeze.

‍

Frequently Asked Questions

Occupier Lease Management

Never miss a critical date again.

See how Occupier keeps Real Estate and Finance teams ahead of every deadline

Request Demo

arrow_right_alt

Boston HQ

Size:
15,000 sq ft

Renewal options:
90 days notice

Lease expiration:
March 2026

Status:
Action required

Amend Lease

Set Alert