ASC 842 Right-of-Use asset & lease liability spreadsheet — "Balance sheet mismatch between interest expense and operating lease cash flows"
Why the manual spreadsheet breaks financial controls and how a deterministic workflow replaces it.
ASC 842 right-of-use assets and lease liabilities live in a side workbook whose amortization columns are dragged by hand whenever a lease is signed, amended, or terminated.
Interest expense and operating lease cash flows diverge from the liability rollforward, so the balance sheet carries a plug that auditors re-perform every close.
Relational lease contract engine that versions each commencement, modification, and termination and posts the ROU, liability, and interest entries from the current schedule.
Lease assertion: remaining liability plus accrued interest must equal the present value of unpaid payments at the contract rate, or the period does not close.
Three-stage comparison between manual workbook reconciliation and automated rule-based execution.
ROU assets and liabilities computed in a workbook the ERP never sees.
Interest expense and lease cash never tie to the liability; the difference is plugged at close.
Each contract event produces an immutable schedule and posts from it.
Remaining liability plus interest equals the present value of unpaid payments before close.
Adjacent spreadsheet failure modes in the same APQC Category 9 process group.
Prepaid expense subledger sheet maintained outside NetSuite
Multi-subsidiary consolidation file & intercompany elimination schedules
Working trial balance workbook & executive monthly reporting packet
Scope the replacement architecture for lease accounting amortization schedules outside the erp or combine multiple failure modes in the directory.
