Contract modifications are where most SaaS and services companies quietly accumulate accounting errors. Here's the classic SUMPRODUCT approach and the one-formula 365 SCAN fix that auto-classifies modifications and calculates cumulative catch-up — plus a free workbook blueprint.
Product notes, engineering deep-dives and launch news. No spam, unsubscribe anytime.
subscribers and counting
Fresh engineering notes, design deep-dives and launch news.
Lease modifications trigger full remeasurement under ASC 842, but every Excel template on the internet is inception-only. Here's the classic PV + OFFSET approach and the 365 SCAN engine that handles mid-lease renewals, rate changes, and scope changes automatically.
Most amortization tables are a fragile ladder of copy-down formulas that shatter the moment you insert a row. Here's the classic PMT/IPMT/PPMT build, and the Excel 365 dynamic-array version that spills the whole schedule from a single cell — plus a free workbook.
Excel's NPV function quietly assumes your first cash flow lands one full period in the future — so it discounts the whole project by an extra period and hands you a number that's off by thousands. Here's the classic fix, the XNPV/XIRR way for real dates, plus a free workbook.
The most-read pieces right now.
Excel 365
Build an ASC 842 Lease Modification Tracker That Auto-Remeasures Liabilities and ROU Assets
4 min read
Excel 365
Build an ASC 606 Contract Modification Engine That Auto-Classifies and Calculates Catch-Up Adjustments
4 min read
Excel 365
Build a Loan Amortization Schedule in One Formula (No Helper Columns)
5 min read
