Home › Templates › ASC 842 Lease Schedule Template
ASC 842 Lease Schedule Template
A lessee lease schedule under ASC 842 for up to 20 leases. It calculates the lease liability and right-of-use asset for operating and finance leases, the monthly cost and journal entries, and the maturity analysis and weighted averages needed for disclosure.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab and a list of every built-in check with its result. |
| Inputs | Period end date and the lease register: classification, commencement, term, payment, increases, discount rate, initial direct costs and incentives. |
| Schedule | For each lease at period end: payment, interest, lease cost, liability with current and long-term portions, and right-of-use asset. |
| Lease Detail | The full month-by-month amortization table for one lease chosen from a dropdown. |
| Journal Entry | The monthly lease entry, and the entry for leases that commence in the month. |
| Reconciliation | Balances compared with the general ledger, the maturity analysis, and weighted-average remaining term and discount rate. |
| Workings | Payment and liability tables behind the schedule. |
| Lists | General ledger accounts and asset classes. |
Features
- Operating and finance leases in one register, plus short-term leases that are not capitalized.
- Payments at the start or end of the month, with an optional annual percentage increase.
- Initial direct costs and lease incentives included in the right-of-use asset.
- Operating leases: straight-line lease cost, with the right-of-use asset reduced by the difference between cost and interest.
- Finance leases: interest on the liability and straight-line amortization of the asset.
- Current and long-term portions of the liability for each lease.
- Maturity analysis of undiscounted payments by year, reconciled to the liability.
- Weighted-average remaining lease term and discount rate.
Instructions
- On the Lists tab, enter your general ledger accounts.
- On the Inputs tab, enter the period end date and one row per lease.
- Confirm that each row shows OK in the Data check column.
- Review balances and cost on the Schedule tab.
- Post the entries on the Journal Entry tab.
- Enter general ledger balances on the Reconciliation tab.
Notes
Covers fixed monthly payments for terms of up to 240 months, commencing on the first day of a month. Variable payments, purchase options, modifications, remeasurements and impairment are not covered. Classification is an accounting judgment made before entering the lease.
Guides
Related calculators
- Lease Liability CalculatorCalculate the present value of lease payments, the opening lease liability under ASC 842 and IFRS 16, with total interest over the term.
- Present Value CalculatorCalculate what a future sum of money is worth today at a given discount rate and number of years.
- Car Lease CalculatorCalculate a monthly lease payment from the negotiated price, residual value, interest rate and term, with the money factor shown.
More accounting templates
- Depreciation Schedule TemplateFixed asset register with monthly depreciation, disposals, roll-forwards by class, journal entries and general ledger reconciliation.
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
Need a version built for your process? Request a custom template quote.
To report an error or request a calculator or template, send feedback.
Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.