This template helps you to calculate the PV of lease payments, ROU asset, lease liability and cash payments. Tailor made for everyone who are using QuickBooks Online and struggling to comply with ASC 842.
Download Template
Sheets
About template
This ASC 842 lease accounting template for QuickBooks Online is designed to simplify lease management and ensure compliance with the latest U.S. GAAP standards. The template helps businesses and accountants calculate the initial recognition amount for both the Right-of-Use (ROU) asset and the corresponding Lease Liability under ASC 842. At the start of a lease, companies are required to record the ROU asset and lease liability at the present value (PV) of future lease payments, and this template makes that process straightforward. By entering key lease details—such as payment amounts, payment frequency, discount rate, and lease term—you can quickly calculate the PV and generate accurate initial journal entries for QuickBooks Online or other accounting systems. In addition to initial recognition, this template supports subsequent measurement of operating leases as required under ASC 842. Each lease payment is split into interest expense on the outstanding lease liability and the reduction of principal, while the ROU asset is amortized systematically, often on a straight-line basis. The built-in amortization schedule ensures proper lease expense recognition, accurate liability reduction, and transparent ROU asset amortization, making it easier to comply with ASC 842 reporting requirements. This finance lease template for QuickBooks is especially useful for small and mid-market companies that lack a dedicated lease accounting module. By automating PV calculations, journal entry schedules, and monthly posting requirements, it reduces manual errors and saves significant time. The template also provides clear documentation for audits, financial disclosures, and reconciliations, making lease accounting easier and fully auditable. Whether you are an accountant, controller, or small business owner, this ASC 842 lease accounting tool ensures accurate, compliant, and streamlined management of Operating leases.
Browse by category
2025 FinBoard










