U of I Tax School QBI/QBID Calculator

Updated 8/23/2019 with 2019 threshold amounts. See list of updates below spreadsheet.

This calculator may be slow to display, as it is being loaded from a Microsoft Office website. You may need to refresh this page one or more times to get the Excel spreadsheet to fully load below. Reloading the page will reset the spreadsheet. Blue cells indicate where you can type in dollar amounts.

Updated August 23, 2019

  1. Updated with 2019 threshold amounts including the separate amount applicable to MFS taxpayers.

Updated February 7, 2019

  1. Net capital gain includes qualified dividends.
  2. Only the applicable % of gross QBI/QBL for SSBs is taken into account pursuant to Treas. Reg. §1.199A-1(d)(2)(i) for the QBI/QBL netting process.
  3. Deductions such as the deductible portion of the tax on self-employment income under section 164(f), the self-employed health insurance deduction under section 162(l), and the deduction for contributions to qualified retirement plans under section 404 are considered attributable to a trade or business to the extent that the individual’s gross income from the trade or business is taken into account in calculating the allowable deduction, on a proportionate basis (see Treas. Reg. §1.199A-3(b)(1)(vi)).