Excel Import utility guidelines for asset information (706)

Show expandable text

New (tax) year, new help!

Fixed Assets and UltraTax CS 2023 help is now on Help and Support. We're still moving articles, but you can find most content for the 2023 tax year there. Continue using the Help & How-To Center for tax years 2022 and older.

Consider the following guidelines when you modify an Excel spreadsheet to import data into UltraTax CS 706.

  • The Excel templates to create the spreadsheet are available at X:\WinCSI\UT18\706US.ext,18,1,0 (where X is the location where UltraTax CS 706 is installed). The following template is available: 

    • u8usasset.xls - Save this template as a CSV file and then use the file to enter asset information.

  • Always copy and save the Excel template to a location other than your X:\WinCSI\UT18\706US.ext,18,1,0 folder before you enter data in the spreadsheet. Saving the template to another location ensures that you will not alter the template in your X:\WinCSI\UT18\706US.ext,18,1,0 folder.
  • Subsequently created import spreadsheets will always overwrite any previously created spreadsheets with the same name.
  • Do not alter the order of the headings in the Excel spreadsheet. UltraTax CS 706 recognizes the order of the headings in the spreadsheet that you create via the template.
  • Do not alter the field names in the spreadsheet.
  • If the asset information changes, you must enter changes in the Excel spreadsheet and save the updated spreadsheet before you re-import the data into UltraTax/706.
  • You can insert or delete rows in the spreadsheet. You must, however, maintain consistency within the spreadsheet.
  • You cannot insert or delete columns in the spreadsheet.
  • You must enter all percentages in the following format: xxx.xx. For example, for Co-tenant: Percentage, you would enter the percentage as 67.50.
  • The following table summarizes valid entries for contributor items in the spreadsheet titled u8usasset.xls.

    Heading Entry
    State State postal code
    Description

    Description of asset 

    (must not exceed 32 characters)

    Schedule

    A = Real Estate

    B = Stocks and Bonds

    C = Mortgage, Notes, and Cash

    D = Life Insurance

    E-1 = Qualified Joint Interests

    E-2 = All Other Joint Interests

    F = Other Miscellaneous Property

    G-1 = Gift Tax Paid

    G-2 = Transfers Includible

    H = Powers of Appointment

    I = Annuity

    NA = Nonresident

    CUSIP or EIN

    CUSIP = xxxxxxxxxxxx

    EIN = xx-xxxxxxx

    Included in gross estate outside the US X
    Co-tenant: Name Name
    Co-tenant: Percentage Percentage (xxx.xx)
    Beneficiary / Ratio Beneficiary or ratio name
    Marital Share X
    QTIP Property X
    Unit value Unit value
    Alternate valuation date MM/DD/YY
    Alternate value Alternate value
    Value at date of death Value at death
    Community property X

Note: If you do not plan to import the Excel spreadsheet intoUltraTax CS 706, you can save the spreadsheet as an XLS file and/or modify the CSV spreadsheet using Microsoft Excel guidelines.

Was this article helpful?

Thank you for the feedback!