Shareholder spreadsheet

Show expandable text

New (tax) year, new help!

Fixed Assets and UltraTax CS 2023 help is now on Help and Support. We're still moving articles, but you can find most content for the 2023 tax year there. Continue using the Help & How-To Center for tax years 2022 and older.

The Shareholder spreadsheet displays the total as well as each shareholder's pro-rata share of beginning-of-year shares, ownership percentage, shareholder health insurance, distributions, deemed dividends, loan repayments, beginning-of-year stock basis, and beginning-of-year loan basis.

  • To add a new shareholder, click the Add Add button button and enter the shareholder's information in the Shareholder tab.
  • To delete a shareholder, highlight the appropriate shareholder in the Shareholder Name column, then click the Delete Delete button button.
  • To update a shareholder's information, highlight the appropriate name in the Shareholder Name column. Then, update the shareholder's information in the tabs at the bottom of this window. The information entered in the tabs is used to complete both the federal and state returns. UltraTax CS automatically updates the information in the Shareholder spreadsheet when data is entered in the Shareholder and Other Info tabs at the bottom of this window.

Was this article helpful?

Thank you for the feedback!