Rounding Robin

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.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab and a list of every built-in check with its result.
InputsPeriod end date and the lease register: classification, commencement, term, payment, increases, discount rate, initial direct costs and incentives.
ScheduleFor each lease at period end: payment, interest, lease cost, liability with current and long-term portions, and right-of-use asset.
Lease DetailThe full month-by-month amortization table for one lease chosen from a dropdown.
Journal EntryThe monthly lease entry, and the entry for leases that commence in the month.
ReconciliationBalances compared with the general ledger, the maturity analysis, and weighted-average remaining term and discount rate.
WorkingsPayment and liability tables behind the schedule.
ListsGeneral ledger accounts and asset classes.

Features

Instructions

  1. On the Lists tab, enter your general ledger accounts.
  2. On the Inputs tab, enter the period end date and one row per lease.
  3. Confirm that each row shows OK in the Data check column.
  4. Review balances and cost on the Schedule tab.
  5. Post the entries on the Journal Entry tab.
  6. 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

More accounting templates

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.