Excel Export / Import utility guidelines for apportionment information (1065)

Alerts and notices

Consider the following guidelines when you modify the Microsoft Excel workbook data you want to import into UltraTax/1065.

  • Always start by exporting apportionment information to Excel. UltraTax/1065 assumes that the initial Excel workbook template was generated via the process of exporting the apportionment information from UltraTax/1065.
  • Always save the Excel workbook before you import the data back into UltraTax/1065 to ensure that UltraTax CS imports all changes.
  • Subsequently created export / import spreadsheets always overwrite any previously created spreadsheets by the same name.
  • For the purpose of importing data into UltraTax/1065 from Excel, UltraTax/1065 assumes that you have not modified the order of the worksheets in the Excel workbook. The worksheets are imported into UltraTax/1065 in the order in which the worksheets were initially exported to Excel as follows:
    1. Apport Info Property
    2. Apport Info Payroll
    3. Apport Info Sales
  • You cannot insert or delete rows in the workbook.
  • You cannot add or delete any column heading rows or add or delete any factor components.
  • You can export apportionment information from one UltraTax/1065 client to an Excel workbook and subsequently import the information into a different UltraTax/1065 client. You can also export apportionment information from one UltraTax/1120 client to an Excel workbook and subsequently import the information into a different UltraTax/1120 client. However, you cannot export and import apportionment information between UltraTax/1120 and UltraTax/1065 clients.
  • You cannot export or import information from the state tabs.
  • Year-end property amounts for depreciable property are not imported when you use detailed asset data entry to classify assets for apportionment.
  • You cannot export or import statement dialog detail. When you import apportionment information from Excel, total amounts are imported into the UltraTax/1065 Apportionment Information window. You must then open the statement dialogs and update the statement detail, or you can import the statement dialog detail from Excel or from the Windows clipboard as described in Importing statement data from Excel overview.

    Note: If the Statement dialog Statement dialog button (underlined and purple) button is underlined and purple, then the amount imported from Excel does not equal the amount in the statement dialog. Open the statement dialog, and update the detail.

  • Column shading, column totals, and the cross-footing of state columns into the Everywhere column mimics the shading, footing, and cross-footing behavior in the Apportionment Information window for states, cities, and other returns exported to Excel. If you add a column to Excel, the column will have no shading and no column totals, and the column will not cross-foot into the Everywhere column. For more information about column shading in the Apportionment Information spreadsheet, see UltraTax/1065 Apportionment procedures and reference information and Apportionment Information spreadsheet.
  • You cannot import data from the Everywhere column in Excel into UltraTax/1065.

    Note: Components that are overridden in the Everywhere column in the UltraTax/1065 Apportionment Information spreadsheet will still be overridden after you import data from Excel. To delete the overrides, choose Edit > Overrides.

  • When you import apportionment information from the Excel workbook back into UltraTax/1065, all data already entered in the Apportionment Information spreadsheet is overwritten with the information from the Excel workbook.
  • The first time you export apportionment information into an Excel workbook, the states attached to the client are listed in alphabetical order in the Excel workbook. If there are city or other returns attached to the client, these returns are listed after that state in the workbook.
  • You can insert and delete state, city, and other return columns in the Excel workbook. (See the next bullet item for information about naming conventions for column headings.) Although you can add these columns in Excel, we recommend that you add the state, city, and other returns to the client in UltraTax/1065 before you export the apportionment information to Excel.
  • If you add columns for state, city, or other returns in Excel, the column headings must be completed pursuant to the following guidelines to import the data into UltraTax/1065. If the column headings are not added correctly, the information cannot be imported into UltraTax/1065.
    • To add a state column, enter the state's name in row three of the column heading. Do not use the state's postal code.
    • To add a city or other return column, enter the state's postal code in row two of the column heading. Then, enter the name of the city or other return in row three of the column heading, exactly as the city or other return appears in the Apportionment Information spreadsheet.
  • If the column headings in Excel do not exactly match the column headings in the Apportionment Information spreadsheet, then UltraTax CS will not import the data from these columns into UltraTax/1065. Instead, UltraTax/1065 will display the Apportionment Import Error Messages dialog, which identifies the column(s) that were not imported.
  • If a state's column heading in Excel is spelled correctly, but the state return is not attached to the client in UltraTax/1065, the amounts from the state column in Excel will accumulate in the Other column in the UltraTax/1065 Apportionment Information spreadsheet.
  • If a city or other return's column heading in Excel is spelled correctly, but the city or other return is not attached to the client in UltraTax/1065, the amounts will not import. Instead, UltraTax/1065 will display the Apportionment Import Error Messages dialog, which identifies the columns that were not imported.

Note: If you do not plan to import the Excel file into UltraTax/1065, you can modify the file in accordance with Microsoft's Excel guidelines.


Was this article helpful?

Thank you for the feedback!