Export apportionment information to Excel

Use the Excel Export tool to export apportionment information quickly and efficiently to a Microsoft Excel workbook. You'll need to complete these steps before you can enter or change the information in the Excel workbook (following the necessary guidelines) and import the updated data back into the UltraTax CS/1120 Apportionment Information window.
  1. Open the UltraTax CS client with the apportionment information you want to export to Excel.
  2. Attach all state and city returns to the client. Completing this step 1st lets you use automatic field shading, column footing, and row cross-foot formatting options.
  3. Select
    Utilities
    , then
    1120 Excel Export
    .
  4. Enter the path for the Excel file location in the
    Save in
    field.
  5. Enter a file name for the Excel file in the
    File name
    field. The default file name is the same as the client ID.
  6. Select
    Apportionment Data
    in the Information group box.
  7. Select
    Export
    .
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close