Microsoft Excel Export/Import utility guidelines for partner information

Excel Export/Import utility guidelines

• Always start by exporting partner information to Excel. UltraTax CS/1065 assumes that the initial Excel workbook template was generated using the process of exporting the partner information from UltraTax CS/1065. Though highly recommended, you don't 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  make sure 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 doesn't 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 can't transfer Excel spreadsheet columns that contain special allocation data among different UltraTax CS/1065 clients.
• For importing data into UltraTax CS/1065 from Excel, UltraTax CS/1065 assumes that you haven't 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:
  1. 1065 Spreadsheet
  2. Profit Transfers
  3. Loss Transfers
  4. Capital Transfers
• You can insert or delete rows in the workbook. However, you'll need to maintain consistency within the workbook. Therefore, insert or delete rows in all 4 worksheets in the identical location.
• You can't change row height or column width.
• You can't insert or delete columns in the worksheet entitled 1065 Spreadsheet.
• You can't 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'll need to enter all percentages in the xxx.xxxxxx format. For example, if a partner was allocated 28.5685 percent, you'd enter the percentage as 28.568500.
• You'll need to enter units of ownership in 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 won't 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.