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 you modify the Microsoft Excel workbook data you want to import into UltraTax CS/1065.

• Always start by exporting partner information to Excel. UltraTax CS/1065 assumes that the initial Excel workbook template was generated via the process of exporting the partner information from UltraTax CS/1065. Though highly recommended, you do not need to enter all of the data into the Partner Information, Allocations, and Changes of Ownership windows (in UltraTax CS/1065 Partner Data Entry) before you export the spreadsheet into Excel.
• Always save the Excel workbook before you import the data back into UltraTax CS/1065 to ensure that UltraTax CS imports all changes.
• Subsequently created export / import spreadsheets always overwrite any previously created spreadsheets by the same name.
• The Excel Export / Import utility does not import or export information from the Partner Information window state tabs or the Transfers of Capital window in Partner Data Entry.
• You can export partner demographic data and the profit, loss, and ownership of capital percentages from one UltraTax CS/1065 client to an Excel workbook and subsequently import the data into a different UltraTax CS/1065 client.
• You cannot transfer Excel spreadsheet columns that contain special allocation data among different UltraTax CS/1065 clients.
• For the purpose of importing data into UltraTax CS/1065 from Excel, UltraTax CS/1065 assumes that you have not modified the order of the worksheets in the Excel workbook. The worksheets are imported into UltraTax CS/1065 in the order in which they were initially exported to Excel as follows:
  1. 1065 Spreadsheet
  2. Profit Transfers
  3. Loss Transfers
  4. Capital Transfers
• 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 four worksheets in the identical location.
• You cannot change row height and/or column width.
• You cannot insert or delete columns in the worksheet entitled 1065 Spreadsheet.
• You cannot change the behavior of or repurpose columns in the worksheet entitled 1065 Spreadsheet.
• You can insert a maximum of 254 columns in the Profit Transfers, Loss Transfers, and Capital Transfers worksheets.
• You must enter all percentages in the xxx.xxxxxx format. For example, if a partner was allocated 28.5685 percent, you would enter the percentage as 28.568500.
• You must enter units of ownership in the xxxxxxxxxx.xxx format.
• UltraTax CS/1065 accounts for transfer dates and percentages in the Profit Transfers, Loss Transfers, and Capital Transfers worksheets, with the following restrictions.
  • You should enter transfer dates sequentially.
  • You should enter dates and percentages for the transfers in the same column in the Profit Transfers, Loss Transfers, and Capital Transfers worksheets.
  • Enter End of Year as the date for the last change of ownership to enter a change as of the last minute of the last day of the client’s tax year end. UltraTax CS will not calculate a prorated percentage, but will display the end of year percentages on the return. If you enter the date of the last day of the client’s tax year end, UltraTax CS will calculate a prorated percentage using the new ownership percentage for one full day.
• The table summarizes valid entries for items in the worksheet titled 1065 Spreadsheet.

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

Was this article helpful?

Yes No

Submit