A lease liability reconciliation ties the ledger balance for each lease to its amortization schedule, confirms each lease payment against the bank statement, and checks that the right-of-use asset moved as it should. Under ASC 842 the schedule is the source: present value at commencement, interest accreted each month, payments deducted, balance remaining.
The lease amortization schedule as the reconciliation source
The lease amortization schedule is the table that starts with the lease liability at commencement, the present value of the remaining payments, and shows each month's interest, payment and closing balance. For a lease liability reconciliation it plays the role a bank statement plays for cash: the ledger should match it at every month end.
Build one schedule per lease. Each needs, at the top:
- Commencement date and lease term, including renewal periods you are reasonably certain to take.
- Payment amount, timing (start or end of each month) and any scheduled increases.
- Discount rate used to measure the liability, with a note on where it came from.
- Initial liability, the present value of the payments at that rate.
A worked example
The figures below are examples. A 36-month equipment lease has payments of 2,000.00 at the end of each month and a discount rate of 6 percent a year, or 0.5 percent a month. The present value of 36 payments is 65,742.03, which is the liability at commencement.
| Month | Opening liability | Interest at 0.5% | Payment | Principal reduction | Closing liability |
|---|---|---|---|---|---|
| 1 | 65,742.03 | 328.71 | 2,000.00 | 1,671.29 | 64,070.74 |
| 2 | 64,070.74 | 320.35 | 2,000.00 | 1,679.65 | 62,391.09 |
| 3 | 62,391.09 | 311.96 | 2,000.00 | 1,688.04 | 60,703.05 |
At the end of month 3, the ledger should show a lease liability of 60,703.05 for this lease. A total across all leases should equal the account balance on the trial balance, with each lease listed so a difference can be traced to one of them.
Matching lease payments from the bank to the lease schedule
Every lease payment on the schedule should appear once on the bank statement, for the scheduled amount, in the month it is due. Matching the two proves that the payments deducted from the liability were actually made, and it catches the missed, doubled or changed payments that make the ledger drift from the schedule.
Work through each month's payments:
- List the schedule's payments for the month, by lease and amount.
- Find each on the bank statement. Lease payments are often automatic debits with the lessor's name in the description.
- Flag differences. A payment of a different amount often means a rent increase, a late fee or tax added by the lessor.
- Flag extra payments. A second debit for the same lease is either a duplicate, which you should recover, or a payment for a different charge that belongs elsewhere.
Lessors often add property tax, insurance or maintenance to the same invoice. Those amounts are usually variable payments, expensed as incurred rather than run through the liability. Split them out so the schedule carries only the fixed payment, and accrue any variable charge that relates to the month but has not been billed. The accrual reconciliation template for Excel shows how to track those estimates until the invoice arrives.
Very small rentals settled in cash, such as a one-day equipment hire, rarely belong on a lease schedule at all. They still need a voucher, and the petty cash reconciliation form is where those payments should be accounted for.
Current and noncurrent lease liability split at each close
The current portion of a lease liability is the principal that will be paid in the next twelve months; the rest is noncurrent. The split matters for the balance sheet, and it changes every month as the schedule moves forward, so recompute it at each close rather than once a year.
Sum the principal reduction column for the next twelve rows of the schedule. In the example, at the end of month 3, the principal in months 4 to 15 totals 20,927.08. That is the current portion. The noncurrent portion is the remaining 39,775.97, and the two together equal the 60,703.05 balance.
Two errors are common here. One is using the next twelve payments, 24,000.00, as the current portion, which includes interest that has not yet accrued. The other is leaving last year's split in place, so the current portion slowly drifts out of date. Add a formula to the schedule that recomputes the split from the balance date, so the figure updates as the months pass.
How do lease modifications change the lease liability reconciliation?
A lease modification, such as an extension, a change in payments or added space, usually means the liability is remeasured from the modification date using the remaining payments and an updated discount rate. The old schedule stops on that date and a new schedule starts, so the reconciliation shows a break that needs its own line.
In practice:
- Close the old schedule at the balance immediately before the modification.
- Compute the new liability from the revised payments and the rate at the modification date.
- Record the difference as an adjustment to the liability, with the matching change usually made to the right-of-use asset.
- Keep both schedules in the workpaper, so a reviewer can see the old balance, the adjustment and the new opening balance.
Treat a modification as an event to document, not as a change of figures in the existing schedule. Overwriting the old schedule erases the months already reconciled, and the next reviewer has no way to see why the balance jumped. Some modifications are accounted for as a separate new lease rather than a change to the old one; record which treatment applied and why.
Right-of-use asset tie-out beside the lease liability
The right-of-use asset is the lessee's right to use the leased item, recorded at commencement at about the same amount as the liability, adjusted for prepaid rent, incentives and initial direct costs. It should be reconciled alongside the liability, because the two move together for an operating lease and apart for a finance lease.
For an operating lease with level payments and no incentives, the lessee records a single straight-line lease cost, here 2,000.00 a month. The right-of-use asset is reduced by the difference between that cost and the interest on the liability. In the example, that is 1,671.29 in month 1, the same as the principal reduction, so the asset and the liability stay equal at 64,070.74.
For a finance lease, the asset is amortized on its own schedule, often straight line, while interest is charged separately. With the example figures, straight-line amortization over 36 months would be 1,826.17 a month, so the asset falls faster than the liability early in the lease. That gap is expected and should be explained, not adjusted away.
When the asset and the liability differ for an operating lease
A gap between the two for an operating lease is usually explained by prepaid rent, a lease incentive or initial direct costs. Each should be listed in the tie-out with the amount from commencement and how it has been released since. An unexplained gap points to a payment booked against one account but not the other.
Lease liability mistake: booking the whole payment to rent expense
Booking the whole lease payment to rent expense means the liability and the right-of-use asset never move. Cash goes out and expense goes up, but the balance sheet keeps the commencement figures. For an operating lease the expense may look right, while both balance sheet accounts are overstated by the accumulated principal.
In the example, after three months of payments booked to rent, the ledger still shows a liability of 65,742.03. The schedule says 60,703.05. The 5,038.98 difference is the total principal for months 1 to 3. For an operating lease, the correction debits the liability 5,038.98 and credits the right-of-use asset the same amount, and the 6,000.00 in expense stays as recorded. For a finance lease, the expense also needs splitting into interest and amortization.
This mistake is easy to spot in the reconciliation, because the ledger balance stays exactly at its commencement figure month after month. A liability that never changes is the first thing to check.
Which leases stay off the lease liability schedule?
Leases with a term of twelve months or less at commencement can be left off the balance sheet if the company elects the short-term lease exemption, and many do. Their payments are expensed as they fall due. The election is made by class of asset and should be written into the accounting policy, so the schedule list matches it.
Check each year that a short-term lease has not turned into a long one. A twelve-month lease renewed every year, where renewal is reasonably certain, may need to come onto the schedule.
Other arrangements fall outside the schedule for different reasons. Service contracts that do not give control of an identified asset are not leases at all. If your company is the lessor rather than the lessee, the balance to reconcile is a receivable from the tenant, and the accounts receivable reconciliation template with aging is the better starting point.
Firms that reconcile many leases across clients usually want tools that keep the schedule, the payments and the evidence together, and the reconciliation software guide for accountants covers what to look for. On the payment side, PreciseBankFlow matches bank statement lines to the ledger and lists the debits with no match, which shows a missed or doubled lease payment before the schedule drifts. It is in early access, and the lease accounting judgments remain yours.