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.

Consider the following guidelines when modifying the Microsoft Excel workbook data you want to import into UltraTax CS.

• Always start by exporting shareholder information spreadsheet data into Excel. UltraTax CS assumes that the initial Excel workbook template was generated via the process of exporting the shareholder information spreadsheet from UltraTax CS. Though we highly recommend it, you do not need to enter all of the data into the Shareholder Information spreadsheet (in the UltraTax/1120 Shareholder Information window) before you export the spreadsheet into Excel.
• Always save the Excel workbook before importing the data into UltraTax CS. This ensures that all recent changes will be imported into UltraTax CS.
• Subsequently created export / import spreadsheets will always overwrite any previously created spreadsheets by the same name.
• You can export shareholder client data, stock basis, loan basis, suspended losses, and change of ownership amounts from one UltraTax/1120 client to an Excel workbook, and then subsequently import that data from Excel into a different UltraTax/1120 client.
• For the purpose of importing data into UltraTax CS from Excel, UltraTax CS assumes you have not modified the order of the Excel worksheets in the workbook. The worksheets are imported into UltraTax/1120 in the order in which they were initially exported to Excel, which is as follows:
  1. 1120 Shareholder Information
  2. Shareholder Basis
  3. Weighted Average
• You can insert or delete rows in the workbook. You must, however, maintain consistency within the workbook. Therefore, you must insert or delete rows in all three worksheets in the identical location.
• You cannot change row height and column width.
• You cannot insert or delete columns in the 1120 spreadsheet worksheet.
• You can enter a maximum of 24 changes of ownership in the Weighted Average worksheet. If more than 24 changes of ownership are entered, only the first 24 will be imported into UltraTax CS.
• You can enter a maximum of 400 shareholders in the 1120 Shareholder Information worksheet. If more than 400 shareholders are entered, only the first 400 shareholders will be imported into UltraTax CS.
• The change of ownership dates must be within the UltraTax CS client's tax year.
• You should enter override percentage ownership in the following format: xx.xxxxxx. For example, if a shareholder was allocated 28.5685 percent, you would enter the percentage as 28.568500.
• You should enter units of ownership in the following format: xxxxxxx.xxx.
• UltraTax CS accounts for change of ownership dates and shares in the Weighted Average worksheet. You should enter change of ownership dates sequentially.
• The Supplemental Information statement dialog detail is not exported or imported. When importing from Excel, total amounts are imported into the Shareholder spreadsheet. You can then open the Supplemental Information statement dialog and update the statement detail.

  Note: If the color of the Statement dialog button is purple, then the amount imported from Excel does not equal the amount within the statement dialog. Open the statement dialog and update the detail information.

• The following table summarizes valid entries for data in the 1120 Shareholder Information worksheet.

Related topic: Excel Export / Import utility for shareholder information overview

Video: Exporting and importing partner, shareholder, and apportionment data (approx. 3.5 minutes)

Was this article helpful?

Yes No

Submit