Taxable income, up to three businesses with their QBI, W-2 wages, UBIA and SSTB status, REIT dividends, PTP income and a loss carried in: the deduction for 2025 and 2026 side by side, with every step shown.
A household on a joint return has $470,000 of taxable income before the deduction in both years, three businesses and $3,000 of REIT dividends. In 2025 it sits 75.40 percent of the way through a $100,000 phase-in range, and its specified service business keeps a sliver of its deduction. In 2026 the range is $150,000 wide, the household is only 44.33 percent through it, and the deduction rises from $29,649 to $39,116 on the same income. The calculator lays out both years, ready for your own figures.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Section_199A_QBI_Deduction_Calculator.xlsx (12 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This calculator is a simplified version of the companion workbook of The Section 199A Handbook, which follows one household from 2024 to 2030: an S corporation and the owner's salary, an actuarial practice that is a specified service business, a rental partnership with a suspended loss, a loss carryforward, REIT and PTP income, the 2026 minimum deduction, Forms 8995 and 8995-A, and a multi-year model.
Four tabs. Inputs are blue; everything else is a formula; the Checks tab counts the failures.
| Measure | 2025 | 2026 |
|---|---|---|
| Zone of the year | Inside the range (75.40 percent) | Inside the range (44.33 percent) |
| Business 1 component | $23,936 | $28,907 |
| Business 2 component (an SSTB) | $1,113 | $5,609 |
| Business 3 component | $4,000 | $4,000 |
| REIT and PTP component | $600 | $600 |
| Combined amount | $29,649 | $39,116 |
| Income limit | $92,000 | $92,000 |
| Deduction | $29,649 | $39,116 |
| Federal tax saved at 32 percent | $9,488 | $12,517 |
The example household is fictional: Business 1 has QBI of $180,000, W-2 wages of $40,000 and UBIA of $300,000; Business 2, a specified service business, QBI of $90,000, no wages and UBIA of $5,000; Business 3, a rental, QBI of $20,000 and UBIA of $800,000; net capital gain is $10,000. Every input is a teaching assumption, separate from the book's case.
Rules described as read in November 2026 (26 U.S.C. 199A as amended by P.L. 119-21, Treas. Reg. 1.199A-1 to 1.199A-5, Rev. Proc. 2024-40, Rev. Proc. 2025-32). Education only, not tax advice: the facts of your own return govern, and your tax adviser decides.
On one set of inputs it computes 2025 and 2026 side by side: the zone of the year, the applicable percentage of a specified service business, netting with a loss carried in, the component of each of up to three businesses with the W-2 wage and UBIA limit and the phase-in, the REIT and PTP component, the income limit, the 2026 minimum deduction and the deduction, with the federal tax saved at the marginal rate you enter.
As read in November 2026: the thresholds of Rev. Proc. 2024-40 for 2025 and Rev. Proc. 2025-32 for 2026, the phase-in range of $100,000 on a joint return in 2025 and $150,000 from 2026 (P.L. 119-21), and the minimum deduction of $400 for at least $1,000 of QBI from active businesses from 2026.
Married filing separately, aggregation, a negative REIT and PTP amount, suspended passive losses, the K-1 presumption of zero, cooperatives and state rules. The book's full workbook covers most of them on one case.
No. It is built for a first pass and for learning the mechanics. Forms 8995 and 8995-A need your own records, and the conclusions belong to your tax adviser.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbook of The Section 199A Handbook goes further: a registry of income items with one class each, a passive loss freed over two years, the depreciable period of each asset, a qualified business loss carried from 2029 to 2030, Form 8995, salary and aggregation scenarios and a sensitivity, for seven years.