Most finance teams know they need to capitalize commissions under ASC 606 — but deciding which costs qualify, picking the amortization period, and building the actual schedule is where things break down. Here’s a step-by-step walkthrough with worked numbers, journal entries, and a practical Excel approach.
The ASC 606 Commission Accrual Workbook handles your full deferred commission asset — capitalization, amortization schedule, period journal entries, and rollforward — in a single audit-ready Excel file.
Everything a controller has to document to capitalize commissions under ASC 340-40 and survive the audit, built to match the workbook and drawn from the fact-checked guides on this site. Templates for the company’s own analysis, not advice.
Deferred revenue is the single largest liability on most SaaS balance sheets, and tracking it accurately in Excel gets painful fast. This guide walks through building a deferred revenue waterfall schedule from scratch, with working formulas, journal entries, and a reconciliation framework that holds up under audit.
Commission accrual and commission capitalization are two different entries that most closes tangle together. One worked month shows the accrual when the commission is earned, the capitalization of the same dollars as a contract cost asset, the payout, the true-up when a deal falls through, and the monthly amortization, with the Excel schedule that ties all of it to the general ledger.
A clawback touches three balances at once: the rep’s payout, the deferred commission asset, and the amortization already expensed. One paid-and-amortizing commission is worked through a full clawback, a 50% clawback, a no-clawback cancellation, and a downgrade, with the ASC 340-40 impairment test and the entries for each.
The five technical-accounting workbooks a SaaS controller maintains every close — leases, commissions, fixed assets, SaaS metrics, runway — at $249 instead of $693, plus the close checklist that ties them together.