Home › How the Calculators and Templates Are Tested
How the calculators and templates are tested
Each tool on this site is checked before it is published, and again whenever it changes. This page describes those checks and their limits.
Calculators
- Formulas are published. Every calculator page shows the formula and a worked example, so any result can be reproduced by hand.
- Automated tests. The calculator library has 1,376 tests that compare results with known values, including published tables such as IRS depreciation percentages. The site cannot be built if a test fails.
- Same code everywhere. The figures on quick-answer pages are produced by the same code as the calculators, so they cannot drift apart.
- Rates are dated. Where a calculator depends on an official rate, such as the IRS mileage rate, the page states the rate and the period it applies to.
Excel templates
- Formulas, not typed values. Every calculated cell is a formula, so the workbook recalculates when inputs change.
- Zero formula errors. Each workbook is fully recalculated before release and is not published if any cell returns an error.
- Stress tests. Each workbook is recalculated with every input cleared, and again with extreme values in every input, and must still return no errors.
- Independent checks. Key results are compared with a separate calculation. For example, lease liabilities in the ASC 842 template and option values in the stock-based compensation template agree with independent calculations to the cent.
- Built-in proofs. Workbooks contain their own checks, listed on the Instructions tab: journal entries must balance, schedules must agree to their summaries, and roll-forwards must agree to closing balances.
Limits
Testing shows that a tool calculates what it says it calculates. It does not show that the tool fits your circumstances. Accounting standards require judgment, tax rules change, and each template states what it does not cover. Review the results and consult a qualified professional before relying on them.
Corrections
Reports of errors are reviewed and confirmed errors are corrected. Use the feedback form and include the inputs used and the result expected.