CPA-Designed · One-time $195 · Updated for 2026

ASC 842 Lease Accounting Without the Headache

What takes 20+ hours to build from scratch takes 30 minutes with this template. Plug in your leases, and get a portfolio dashboard, ASC 842-aligned amortization schedules, journal entries, and footnote disclosure support — instantly.

Get the Template — $195

Instant download · 30-day money-back guarantee · See it in action

This template is a tool to assist with ASC 842 calculations and workpapers. It does not constitute accounting advice, does not create a CPA-client relationship, and does not guarantee GAAP compliance or auditor acceptance.

ASC842_Lease_Schedule.xlsx — Amortization
Month
Cash Rent
SL Expense
Interest
Lease Liability
ROU Asset
0
$267,546
$262,546
1
$5,000
$5,117
$1,376
$263,922
$258,806
2
$5,000
$5,117
$1,357
$260,280
$255,046
3
$5,000
$5,117
$1,338
$256,618
$251,268
4
$5,000
$5,117
$1,319
$252,937
$247,470
5
$5,000
$5,117
$1,300
$249,236
$243,653
6
$5,000
$5,117
$1,280
$245,516
$239,816
⋮
⋮
⋮
⋮
⋮
⋮
60
$5,500
$5,117
$28
$0
$0
Fully Amortized to $0 ✓
CPA-designed
Used in a real audit setting
One-time purchase, no subscription
See It In Action

Plug in your leases. Watch the schedule build itself.

Real footage of the template generating amortization, journal entries, and disclosures.

How It Works

From download to workpaper-ready in 30 minutes

1

Enter Your Leases

Set your fiscal year end, fill in the Lease Inputs tab (name, classification, start date, term, payment timing, annual escalation %, extensions), and enter base rents in the Rent Schedules tab.

2

Review & Manage

The Dashboard gives you a portfolio snapshot with expiration alerts. Select any lease from the dropdown to review its full monthly amortization schedule — IBR, PV, and every line generated automatically.

3

Book & Disclose

Copy journal entries — including major lease modification scenarios (rent changes, abatements, term extensions, partial terminations) — straight into your GL. Set any reporting date in the Disclosures tab — year-end, quarterly, or mid-year — and get footnote-supporting maturity schedules, lease cost tables, and supplemental metrics.

Inside the Template

Every tab, built for ASC 842 workpapers

Real screenshots from the template — what you'll see the moment you open it.

Lease input table showing lease name, address, entity, classification, start date, and term fields
Lease Inputs

Easily Input Lease Information

Enter lease name, address, entity, classification, start date, term, and payment details — all in one structured table. Supports up to 50 leases.

Lease incentives and other costs input table
Incentives & Costs

Add Lease Incentives & Other Costs

Capture initial direct costs, tenant improvement allowances, and short-term lease elections per lease.

Dynamic monthly rent schedule table
Rent Schedules

Fully Dynamic Rent Tables

Enter monthly cash rent by lease — only where rent changes. Blank cells inherit the prior month's rate automatically.

Full monthly amortization schedule showing cash rent, straight-line expense, and balances
Amortization

Full Amortization Table in Seconds

Select any lease from the dropdown and see the complete month-by-month schedule — cash rent, SL expense, interest, lease liability, and ROU asset balances.

ASC 842 journal entries for initial recognition and periodic entries
Journal Entries

Journal Entries All in One Spot

Initial recognition, cash payments, straight-line adjustments, and more — select a lease, fiscal year, and month to generate entries.

ASC 842-20-50 disclosure schedules showing lease cost and maturity analysis
Disclosures

Disclosure Calculations for Any Year

Set a reporting date and get ASC 842-20-50-oriented lease cost breakdowns, maturity analysis, and supplemental metrics.

Pricing

Skip 20+ hours of spreadsheet work for $195

ASC 842 Complete Template

10-tab Excel workbook — plug in your leases, support your ASC 842 workpapers

$195

One-time purchase

  • Portfolio dashboard with lease expiration alerts
  • Monthly amortization schedules (ROU asset + liability)
  • Handles major lease modification scenarios — rent changes, term extensions, abatements, partial terminations
  • ASC 842-20-50 disclosures for any reporting date — year-end, quarterly, or mid-year
  • Auto-IBR from 12,000+ Treasury rates · Auto rent escalations
  • Journal entries: initial recognition, monthly entries, and remeasurements
  • Configurable fiscal year end · Up to 50 leases
  • Built-in validation checks · Sample data included
Purchase Now
Instant download. The Excel file is delivered the moment your purchase is complete — no waiting, no shipping.
30-day money-back guarantee. Try it on your own leases. If it doesn't fit your situation for any reason, email us within 30 days and we'll refund 100% of your purchase — no questions asked.

Educational/informational tool only. Not accounting advice or a CPA service. No CPA-client relationship is created. Results depend on your inputs and assumptions, and professional judgment is required.

Built by a CPA, Used in a Real Audit
Used in a 13-lease ASC 842 audit workup

I built this template because I needed it myself. After pricing out enterprise lease accounting software for a portfolio of 13 leases, I realized a well-built spreadsheet could cover the core workpaper need — without the five-figure price tag. So I built one, used it to complete my own ASC 842 audit, and turned it into a product so other accountants don't have to start from scratch.

Jack Franken
Jack Franken Licensed CPA · Public & Private Accounting Experience This product is not a CPA service.
FAQ

Common questions

Immediately. As soon as your payment goes through, you'll get a download link on the confirmation page and in a follow-up email. The file is yours to keep — no expiration, no recurring fees, and you can re-download it anytime from the original purchase email.

Up to 50 individual leases with terms up to 100 years (1,200 months). The template supports both operating and finance leases, with up to 10 extension options per lease.

Yes. The Disclosures tab is built around a user-configurable reporting date — set any date you need (year-end, quarter-end, or any mid-year period for an interim audit, lender package, or M&A close), and the maturity schedule, lease cost breakdown, and supplemental metrics all calculate against that date automatically.

The template includes a built-in Treasury Rates tab with historical daily rates. It automatically matches the 30-year Treasury rate to your lease start date and adds your credit spread (entered in basis points) to calculate the incremental borrowing rate. You can also override with a manual IBR if preferred.

Many auditors accept well-structured Excel workpapers, and this template is designed to align with common ASC 842 expectations. It has been used in a real audit setting, and outputs include ASC 842-20-50 disclosure support — maturity analysis, lease cost breakdown, balance sheet classification, weighted-average term, weighted-average discount rate, and cash paid for operating leases. However, auditor acceptance ultimately depends on your specific auditor, inputs, assumptions, controls, and facts and circumstances. Professional judgment should be applied in all cases.

The template does not currently support variable lease payments, lessor accounting (sales-type or direct financing leases), or non-standard fiscal calendars (4-4-5, 13-period). It is designed for lessee accounting under ASC 842 on a standard monthly calendar. If your situation involves these, you may need a more specialized tool — we'd rather you know upfront.

Yes — full 30-day money-back guarantee. If the template doesn't fit your situation for any reason, just email support@asc842template.com within 30 days and we'll refund 100% of your purchase. No questions asked, no forms, no hassle.

Replace 20+ hours of spreadsheet setup with a 30-minute workflow

CPA-designed, used in a real audit setting, and built for accountants and business owners who need practical ASC 842 workpapers without the enterprise price tag.

Get the Template — $195

Tool-only template. Not accounting advice, not a CPA engagement, and no guarantee of GAAP compliance or auditor acceptance.