Free ASC 842 Lease Template (Excel)

What's in the ASC 842 template

The workbook has two tabs. The Classification Test lists the five ASC 842-10-25-2 criteria - ownership transfer, purchase option, lease term versus economic life, present value versus fair value, and specialized asset - with a Yes/No answer per row and an automatic result.

The Lease Calculator takes your monthly payment, term, discount rate, initial direct costs, incentives, and prepaid rent, and turns those into the day-1 balances and term-level totals you need for your accounting entries.

Answer any single criterion Yes and the classification result reads FINANCE LEASE; answer No to all five and it reads OPERATING LEASE - that single result drives which numbers matter most for your entry.

Lease amortization schedule in Excel: what this template calculates instead

If you're searching for a lease amortization schedule in Excel, it's worth being precise about what this file gives you: it does not produce a month-by-month amortization table showing the liability balance declining period by period.

What it does calculate is the initial lease liability - the present value of your lease payments using the formula PMT x (1 - (1 + rate/12)^-n) / (rate/12) - along with the initial ROU asset, total interest over the full term, and the monthly straight-line expense for an operating lease.

For most small businesses and bookkeepers, those figures are what you actually need for the initial journal entry and the monthly expense recognition. If you need a full period-by-period amortization table showing the liability and ROU asset balance every single month, this template isn't built for that.

Initial lease liability, ROU asset, and total interest

The initial lease liability is the present value of your remaining lease payments at your incremental borrowing rate. Add initial direct costs and any prepaid rent, subtract lease incentives received, and you get the initial ROU asset.

Total interest over the term is simply your total undiscounted payments minus that initial liability - the cost of financing the lease across its life. The straight-line monthly expense averages total payments (plus initial direct costs, minus incentives) evenly across every month of the term, which is what an operating lease recognizes each period.

Who this template is for

Bookkeepers and small-business finance teams who need to classify a lease and get the day-1 numbers - lease liability, ROU asset, and monthly expense - into their books quickly, without a full lease accounting software subscription.

It's a planning and preparation tool: work through the classification and the calculator here, then take the results into your accounting system or your accountant's review, rather than treating this as your final audit workpaper.