ASC 340-40 Commission Capitalization Calculator

Determines whether a sales commission is capitalizable, runs the commensurate-renewal test that sets the amortization period, checks whether the one-year practical expedient is actually available, and rolls the contract asset forward to a carrying amount with an impairment test — built for SaaS controllers and revenue accountants who inherited a commission spreadsheet that worked for a year and then quietly stopped agreeing with itself.

✓ Runs the commensurate-renewal test that decides between contract term and expected customer life✓ Flags when the one-year practical expedient is unavailable — the misapplication the SEC staff has commented on✓ Includes employer payroll tax on the commission as an incremental cost, and excludes non-incremental sales costs✓ Tests impairment against remaining consideration less remaining direct costs, and reports the trigger point✓ Free Excel download✓ No signup required

Download This Calculator

Get the Excel spreadsheet behind this calculator to use offline, customize for your own commission plan and contract profile, and publish as a web tool using Sheetflow.

The Commensurate-Renewal Test

Compares the renewal commission rate against the initial rate and decides whether the asset amortizes over the contract term or the expected customer life — the judgment that actually gets challenged in audit, with the threshold left as an input because it is a policy choice rather than a rule.

The Expedient, Priced

Determines the amortization period first and only then tests the one-year practical expedient against it — then prices the misstatement if you apply it anyway, per contract and across the portfolio.

Impairment with a Trigger Point

Tests the carrying amount against remaining consideration less remaining direct costs, and reports how far consideration would have to fall before a loss is required — a number you can monitor against your churn-risk list instead of re-running the test blind every quarter.

Frequently Asked Questions

Which sales commissions have to be capitalized under ASC 340-40?

Two tests, both of which must pass. The cost must be incremental — you would not have incurred it if the contract had not been won — and you must reasonably expect to recover it through future revenue from that customer.

That's narrower than "sales expenses." A commission paid only on closed deals is incremental. A sales rep's base salary is not, because you pay it whether or not the deal lands. Neither is travel to a pitch that lost, or the sales manager's time, or marketing spend. The calculator's defaults carry $2,500 per deal of non-incremental sales cost specifically so you can see it excluded — $100,000 across a 40-contract book that stays in operating expense.

One item people miss in the other direction: employer payroll tax on the commission is itself incremental. You wouldn't have paid the FICA if you hadn't paid the commission. At the defaults that's $459 on a $6,000 commission, and leaving it out understates the asset by 7.65% on every contract.

Fulfilment costs are a separate bucket under the same topic. Direct setup and implementation costs that meet the criteria get capitalized too — $3,000 in the defaults — which brings the total capitalized contract cost to $9,459.

The judgment that actually gets challenged in audit isn't usually whether to capitalize. It's the period, which is the next question.

How do I determine the amortization period for capitalized commissions?

Not by looking at the contract term. The asset is amortized on a basis consistent with the transfer of the goods or services it relates to, and for a subscription business that period is usually the expected customer relationship rather than the initial term.

The deciding question is whether the renewal commission is commensurate with the initial one. If you pay the same rate on renewals as on new business, the sales effort is being compensated afresh each period, and the amortization period is typically the initial contract term. If renewals carry no commission or a significantly lower rate, the initial commission is buying the whole relationship, and the period should extend to cover the anticipated customer life including renewals.

The defaults show the common SaaS pattern: a 10% initial commission and a 2% renewal rate. Renewal is 20% of initial — not commensurate — so the period is the 48-month expected customer life, not the 12-month contract term. Monthly amortization is $197.06, and at month 18 the contract asset is carrying $5,911.88.

ASC 340-40 sets no bright line for "commensurate." The calculator takes the threshold as an input, defaulted to 50%, because that's a policy choice rather than a rule — and the threshold genuinely decides the answer. Set it at 25% and this contract amortizes over 48 months; set it at 10% and the same facts give you 12 months and a completely different P&L. Document your threshold and apply it consistently.

When can I use the one-year practical expedient?

Only when the amortization period would genuinely be one year or less. And notice the order of operations: you determine the period first, then test the expedient against it. Running it the other way round is how the misstatement happens.

The expedient exists for real reasons — a transactional business paying small commissions on annual deals with commensurate renewals shouldn't have to maintain a subledger. But it is frequently misapplied to avoid capitalization on multi-year contracts, and the SEC staff has commented on registrants using it where long-term customer relationships are funded by large upfront commissions expensed immediately.

The calculator prices exactly that error. At the defaults, expensing the full $9,459 in year one against the correct $2,364.75 of amortization overstates year-one expense by $7,094.25 per contract. Across 40 similar contracts that's $283,770 of understated income — on a single year, for a single cohort.

Watch the override input if you want to see the manoeuvre in action. Forcing the period to 12 months re-enables the expedient and zeroes the asset. Nothing in the arithmetic stops you; the only thing standing between that and a restatement is the documented reasoning behind the period.

If your expected customer lifetime is three or more years and the commission economics only work over that horizon, arguing the amortization period is one year or less is hard, and auditors know it.

How do I test a capitalized contract cost for impairment?

Compare the carrying amount against the remaining consideration you expect to receive for the goods or services the asset relates to, less the costs directly related to providing them. If carrying exceeds that, recognize the excess as an impairment loss immediately.

At the defaults: $150,000 of remaining consideration less $42,000 of remaining direct costs gives a recoverable amount of $108,000, against a carrying amount of $5,911.88. Headroom is comfortable and no loss is required.

That's typical, and it's why the test gets skipped. Commission assets are small relative to contract value, so impairment almost never bites on a healthy customer — it bites when a customer signals non-renewal or downgrades. The calculator reports the trigger point for exactly this reason: remaining consideration would have to fall below $47,911.88 before a loss is required. That's a number you can monitor against your churn-risk list instead of re-running the test blind every quarter.

Two features of this model that differ from what you may expect. It's tested at each reporting period, not annually. And the loss cannot be reversed in later periods even if expectations improve — a sharp distinction from the long-lived asset impairment model, and one that makes a hasty write-down expensive.

Does capitalizing commissions create a book-tax difference?

Yes, and it's a deferred tax liability that grows with your book.

ASC 340-40 is a financial reporting standard. It does not change the tax treatment — commissions generally remain deductible when paid under IRC §162. So you deduct the full commission on the return in the year you pay it, while recognizing it in book income gradually over the amortization period. Book income is higher than taxable income by the unamortized balance, and that difference reverses as the asset amortizes.

At the defaults the contract asset carries $5,911.88 at month 18, producing a $1,241.49 deferred tax liability at a 21% rate. Across the 40-contract book that's $49,659.75 — and the gross capitalized cost is $378,360 with $236,475 still on the balance sheet.

The practical consequence is that the deferred tax balance scales with growth, not with profitability. A company adding contracts faster than the existing book amortizes will see the liability climb every quarter even while cash tax stays flat.

One honest note on scope. This is a policy calculator, not a subledger. It answers whether a cost capitalizes, over what period, whether the expedient applies, and whether the asset is impaired — for one contract profile scaled to a portfolio. It does not maintain per-contract schedules, link renewals to original grants, or propagate churn events. Once you're past a few dozen distinct contract shapes, you need a system that stores per-contract data. Use this to set and defend the policy; use the system to run it.

Transform Your Excel Models into Web Tools

Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.

Calculations are for estimation and planning purposes and do not constitute accounting or tax advice. Capitalization, the amortization period, and impairment under ASC 340-40 depend on facts and judgments specific to each contract and commission plan. Users should verify important results for their specific situations. No signup required. Calculations performed securely.