One unlocked four-tab Excel calculator covering ASC 350-40 after ASU 2025-06, cloud computing implementation costs, and ASC 985-20 greater-of amortization and NRV testing.
Enter your eligible engineering hours, loaded hourly rate, contractor fees, cloud hosting term, or external product revenue forecast. In the pre-loaded example, 4,000 direct hours at $95 per hour plus $100,000 of contractors capitalize $480,000 ($160,000 annual amortization), $300,000 of cloud setup amortizes at $60,000 per year over 60 months, and ASC 985-20 records $108,000 of Year 1 amortization.
One unlocked Excel workbook, zero macros, zero circular references. Free: enter your email address and the download opens at once, along with the other free accounting models.
Software_Cost_Capitalization_Model.xlsx (9 KB)
You join the reader list: one email when a new free model or book comes out. Unsubscribe in one click. Already subscribed? Enter the same address. How your address is used.
This calculator is a clean standalone extract of the seven-tab workbook in The Software Costs Accounting Handbook, which walks a complete US GAAP company through Legacy ASC 350-40 vs. ASU 2025-06, agile sprints, stock-based compensation, capitalized interest, abandonment write-offs, cloud ERP vs. IFRIC 2021, ASC 985-20 NRV write-downs, EBITDA covenants, transition adjustments and Section 174A deferred taxes.
| Measure | Value |
|---|---|
| Internal-use software capitalized cost (ASC 350-40) | $480,000 |
| Internal-use annual straight-line amortization (36 months) | $160,000 |
| Cloud implementation capitalized asset (ASU 2018-15) | $300,000 |
| Cloud annual implementation amortization (60 months) | $60,000 |
| External-use software Year 1 amortization (ASC 985-20 greater-of) | $108,000 |
| External-use software Year 1 ending NBV | $132,000 |
Every number in the template is an illustrative teaching example, independent of the book's case. On the Internal-Use Software tab, 4,000 direct hours at $95 per hour produce $380,000 of eligible payroll plus $100,000 of third-party coding fees for $480,000 capitalized ($160,000 per year over 36 months). On the Cloud Implementation tab, $300,000 of setup costs amortizes over 60 months ($60,000 per year) alongside $180,000 in annual hosting fees. On the External Software 985-20 tab, $240,000 of post-feasibility cost faces Year 1 revenue of $900,000 out of $2,000,000 total anticipated revenue (45.0%), so revenue-ratio amortization ($108,000) exceeds straight-line ($80,000), leaving $132,000 at year-end.
Rules described as read in November 2026 (FASB ASC 350-40, ASU 2025-06, ASU 2018-15, and ASC 985-20). Education only, not accounting or audit advice.
Yes. The Internal-Use Software tab includes both ASU 2025-06 gates: management funding commitment and probable-to-complete clearance (no unresolved significant development uncertainty). If either gate is set to 0, capitalized cost drops to $0.
The Cloud Implementation tab amortizes eligible setup, configuration, and integration costs over the non-cancelable term plus reasonably certain renewals, and pairs that amortization with the annual SaaS fee to show the combined operating expense impact.
Yes. The External Software 985-20 tab computes the greater of the revenue-ratio method and straight-line amortization on a product-by-product basis, and runs the mandatory year-end Net Realizable Value write-down check.
No. Every input cell is blue, every calculated cell is an unlocked live Excel formula, there are zero circular references, and the Checks tab verifies all four reconciliations equal zero.