Skip to main content

Legal

Featured

Questions? We are here to help
Contact us

Tax & Accounting

Featured

Questions? We are here to help
Contact us

Trade & Supply

Featured

Questions? We are here to help
Contact us

Risk & Fraud

News & Media

Books

Developers

Import-export

Microsoft Excel Export/Import utility guidelines for partner information

Excel Export/Import utility guidelines

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 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.

This article applies to:

  • PRODUCT: UltraTax CS
  • Return type: 1065 Partnership
  • Subject: Export,Import,schedule-k1-subject

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close