Lease classification + ROU asset + amortisation — asc 842 lease accounting software with tenor-matched IBR.
For mid-market retailers managing 50–500 store locations, ASC 842 lease accounting is one of the most time-intensive close tasks: a single retail lease can run 40–80 pages with renewal options, CPI escalators, percentage-of-sales rent and bundled CAM charges across dozens of exhibits. Four failure modes break the manual process predictably.
Renewal options, CPI escalation tranches, percentage-of-sales rent, and bundled CAM charges are buried across 20–30 exhibit pages. Manually extracting them into a spreadsheet model takes 3–5 days per quarter for a team of two — and that’s assuming no mid-period modifications.
ASC 842-20-30-3 requires the incremental borrowing rate to be tenant-specific and tenor-matched. A blended IBR applied across mismatched tenors silently misstates the lease liability flowing directly to the balance sheet — auditors flag this every cycle.
A 5-year base term with two 5-year renewal options is a judgment under ASC 842-20-30-5 (reasonably certain to exercise). Including options too liberally inflates the lease liability; excluding too conservatively under-recognises it — both produce restatement risk.
A landlord lease modification letter may or may not grant an additional right-of-use. Without an automated detection step it’s typically applied at year-end — meaning quarterly schedules carry the wrong ROU and lease liability for 3–9 months under ASC 842-20-45-3.
External auditors routinely identify ASC 842 schedules as a material weakness risk area for companies that grew store count after adoption. Misstated ROU or lease liability triggers audit adjustment, prior-period restatement, delayed close, and — for companies with covenants tied to net assets or EBITDAR — potential covenant breach.
ASC 842 (FASB Codification Topic 842, Leases) replaced ASC 840 and eliminated off-balance-sheet operating-lease treatment. The standard is prescriptive — four codified rules drive every calculation.
Five-criteria test for whether the lessee obtains substantially all economic benefits or assumes the risks of ownership. The specific criterion met (or not met) must be recorded per-lease in the audit workpaper.
Lease liability = PV of unpaid lease payments discounted at the rate implicit in the lease, or the lessee’s incremental borrowing rate — tenant-specific and tenor-matched. Mid-market companies without publicly traded debt must construct a synthetic IBR.
CPI escalators and percentage-of-sales rent must be separated from fixed payment streams; only fixed tranches enter the PV. Bundled CAM, insurance, and property tax are handled either via the practical expedient or allocated using observable standalone prices.
Modifications that grant additional ROU are treated as new leases with fresh commencement dates and remeasured IBR. Leases with a maximum term (incl. options) of 12 months or less qualify for the short-term exemption — straight-line expense, no capitalisation.
Eight deterministic steps that turn a 40–80 page lease PDF into a classification memo, ROU/lease liability, and a complete amortisation schedule in under 90 seconds — every output cell traceable back to the source clause.
Reads each lease PDF or Word doc, extracts commencement date, base term, rent schedule, escalation clauses (fixed / CPI / percentage-of-sales), option periods, purchase options, and bundled non-lease component charges.
Runs the five-criteria operating-vs-finance classification test, recording which criterion was met (or not met) per lease in the workpaper. Finance leases get separate ROU amortisation + interest schedules.
Surfaces each option clause and prompts the controller to assert whether exercise is reasonably certain under ASC 842-20-30-5. The lease term and PV update in real-time based on confirmed elections.
CPI escalators and percentage-of-sales clauses are separated from fixed payment streams per ASC 842-20-55. Only fixed tranches enter the PV calculation; variable components are flagged for footnote disclosure.
Bundled CAM, insurance and maintenance charges are identified. The workflow either applies the practical expedient (combining lease + non-lease) or allocates consideration using observable standalone prices per ASC 842-10-15-28.
Computes the PV of the fixed lease payment stream using a tenor-matched IBR from a controller-maintained input table, with per-lease override. The IBR, its basis, and the resulting lease liability are stored as a per-lease audit workpaper entry.
Leases with a maximum possible term (incl. all options) of 12 months or less route to the short-term exemption schedule under ASC 842-20-25-2 — straight-line expense JE rather than capitalised ROU asset.
On a modification event, detects the modification date and nature of the change, bifurcates into new-lease vs remeasurement per ASC 842-20-45-3, and generates separate updated amortisation schedules with correct commencement date and remeasured IBR.
The workflow ships with a battery of synthetic test scenarios that exercise every failure mode we have seen in real-world data. Each scenario produces a deterministic outcome that an auditor or controller can verify in seconds.
Seeded sample files used to demonstrate this workflow. Each one exercises a specific scenario or failure mode.
Multi-year retail store lease with graduated rent schedule, CAM charge provisions, two five-year renewal options, and a tenant improvement allowance clause; used to demonstrate term extraction, IBR application, and ROU asset calculation.
Amendment expanding leased square footage mid-term; demonstrates bifurcation between new-lease accounting and remeasurement of the original lease under ASC 842-20-45-3.
Controller-supplied IBR table indexed by lease tenor (1–15 years) and credit profile; imported by the workflow to discount each lease's future payments to present value.
System-generated output showing period-by-period ROU asset amortization, lease liability reduction, interest expense, and straight-line rent expense for each classified lease.
Across a 35-lease retail portfolio, this ASC 842 lease accounting software reduces a 3–5 controller-day quarterly exercise to ~90 minutes of supervised review — ~95% reduction in elapsed time. More importantly, it catches the four error classes that drive material weakness findings.
CPI escalators and percentage-of-sales clauses are isolated from fixed payment streams per ASC 842-20-55 — only fixed tranches enter the PV, variables are flagged for footnote disclosure. The most common ASC 842 audit finding eliminated.
Leases with max term of 12 months or less route to the short-term schedule automatically — preventing the silent ROU overstatement that prior spreadsheet models routinely produce on pop-up stores and seasonal locations.
Classification memo, IBR rationale, option-certainty assertion, PV calculation and full amortisation schedule packaged as a structured workpaper keyed to the source lease — satisfying AICPA AU-C 500 (Audit Evidence) with full traceability.
The questions accountants and finance controllers ask most often before deploying this workflow.
Under FASB ASC 842, all operating and finance leases with a term exceeding 12 months must be recognized on the balance sheet as a right-of-use asset and a corresponding lease liability. Cadel applies the five finance-lease criteria in ASC 842-10-25-2 (transfer of ownership, purchase option, lease term as major part of economic life, present value as substantially all of fair value, and specialized asset) to each extracted lease and routes the remainder to operating-lease accounting. The classification result and the specific criterion triggered are recorded in the output workpaper.
The current workflow is scoped to ASC 842 as issued by the FASB, which governs US GAAP reporters. IFRS 16, issued by the IASB, uses a single lessee model with no operating/finance bifurcation and different variable-payment rules. Cadel maintains a separate IFRS 16 workflow configuration; companies reporting under both frameworks can run parallel workpapers from the same source lease documents.
Cadel generates a period-close journal entry file in CSV format mapped to standard account codes for ROU asset, lease liability, interest expense, and amortization expense. Controllers can upload this file directly into NetSuite via the SuiteCloud CSV import, into QuickBooks via the batch transaction import, or into Tally using the XML voucher format. Direct API posting to NetSuite is available for companies that have enabled OAuth 2.0 credentials in their Cadel settings.
Every judgment input — incremental borrowing rate, reasonable-certainty assertion for renewal options, practical expedient elections, and modification classification — is time-stamped, tied to the user who entered it, and stored in an immutable workpaper attached to the lease record. External auditors reviewing under PCAOB AS 2101 or AICPA AU-C Section 315 can access the full evidence chain, including the source lease document, extracted fields, and overrides, without requesting separate schedules from the controller.
Yes. Cadel processes lease agreements in bulk; a portfolio of 200 leases is ingested, classified, and scheduled in a single run. Each lease is tracked by location code, commencement date, and expiry date, and the workflow produces a consolidated portfolio summary alongside individual amortization schedules. Remeasurement events — modifications, reassessments, or early terminations — are handled at the individual lease level without reprocessing the full portfolio.
Under ASC 842-20-30-5, a lease incentive receivable reduces the initial measurement of the ROU asset. Cadel extracts TIA amounts from the lease agreement, subtracts the receivable from the gross ROU asset at commencement, and adjusts the amortization schedule accordingly. If the TIA is paid directly by the landlord to a contractor rather than reimbursed to the lessee, the workflow flags the clause for controller review to confirm the correct accounting treatment.
