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.

You can quickly and efficiently export and import partner information to and from UltraTax/1065 and a Microsoft Excel workbook. When you export partner information from UltraTax/1065, the Excel Export / Import utility creates Excel worksheets for partner information, profit transfers, loss transfers, and capital transfers (from the Partner Information, Allocations, and Changes of Ownership windows in Partner Data Entry) as follows:

• 1065 Spreadsheet: This worksheet contains columns for partner demographic data and other information, profit sharing percentage, loss sharing percentage, ownership capital percentage, ownership capital amount, and special allocations.
• Profit Transfers: This worksheet contains columns for changes in partner profit sharing percentages or units of ownership by date.
• Loss Transfers: This worksheet contains columns for changes in partner loss sharing percentages or units of ownership by date.
• Capital Transfers: This worksheet contains columns for changes in partner ownership capital percentages or units of ownership by date.

The table identifies the UltraTax/1065 spreadsheet information that exports to Excel and the Excel worksheet that contains the corresponding information for import into UltraTax/1065.

For detailed information about UltraTax/1065 Partner Data Entry, see UltraTax/1065 Partner Data Entry procedures and reference information.

Follow this basic procedure to use the Excel Export / Import utility to export or import partner information to and from UltraTax CS.

Basic procedure for importing and exporting partner information

1. Export information from UltraTax/1065 to Excel. To import partner information from Excel, you must first export the partner information from UltraTax CS into Excel to create the Excel workbook template. Though not required, you should enter partner demographic information for at least one partner prior to export.
2. Modify and save the Excel workbook. After you generate the Excel workbook, you can modify the worksheets. To modify the worksheets, follow the guidelines in Excel Export / Import utility guidelines for partner information. If you do not plan to import the Excel file back into UltraTax/1065, you can modify the file using Microsoft Excel guidelines.
3. Import information from the Excel workbook into UltraTax CS. After you create the Excel workbook and, if necessary, modify the information, you can Import the information back into UltraTax/1065.

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

Was this article helpful?

Yes No

Submit