Free Excel templates

A free section 199A QBI deduction calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

Four tabs. Inputs are blue; everything else is a formula; the Checks tab counts the failures.

1. Read me
What the calculator does, the rules it applies with their dates and sources, the convention used for the minimum deduction, and what it leaves out.
2. Calculator
Filing status, taxable income, net capital gain, REIT dividends, PTP income, a loss carried in, your marginal rate and up to three businesses; below them, 2025 and 2026 side by side: the zone, each business's applicable percentage, netting, the wage and UBIA amount, the reduction, each component, the income limit, the minimum deduction, the deduction, the tax saved and the loss carried out.
3. Rules
The thresholds and ranges of 2025 and 2026 for joint and other returns, the minimum deduction amounts and the percentages of section 199A, each with its source.
4. Checks
The combined amount against its parts, netting against the total, the loss carried out, the deduction against its two caps, and the filing status entered.

What the worked example returns

Measure20252026
Zone of the yearInside 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.

How to use it on your own return

  1. Close taxable income before the deduction first, with every other line of the return, and enter net capital gain including qualified dividends.
  2. For each business, enter QBI after the owner's salary and guaranteed payments are taken out, the W-2 wages and the UBIA of its qualified property, and whether it is a specified service business.
  3. Answer the material participation question for each business: it decides the 2026 minimum deduction.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

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.

Questions people ask

What does the QBI deduction calculator do?

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.

Which rules does it apply?

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.

What does it leave out?

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.

Can I rely on it for a filing?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading