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:
1065 Spreadsheet
Profit Transfers
Loss Transfers
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.