Skip to main content
Import assets from Excel into a 706 return
Search
Search UltraTax CS Support Help and Support.

This article applies to:

  • Product: UltraTax CS
  • Return type: 706 Estate Tax
  • Subject: Import,Depreciation

Excel template guidelines for 706 Import Utility

Once you've made a copy of the Excel template, consider the following when adding or modifying data before you import into UltraTax CS 706.
  • Don't change 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.
  • Don't change the field names in the spreadsheet.
  • If the asset information changes, you'll need to enter changes in the Excel spreadsheet and save the updated spreadsheet before you reimport the data into UltraTax/706.
  • You can insert or delete rows in the spreadsheet. However, you'll need to maintain consistency within the spreadsheet.
  • You can't insert or delete columns in the spreadsheet.
  • You'll need to enter all percentages in the following format: xxx.xx. For example, for Co-tenant: Percentage, you'd enter the percentage as 67.50.
  • The following table summarizes valid entries for contributor items in the spreadsheet titled
    uYusasset.xls
    .
    Excel Heading
    Accepted Data 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 don't plan to import the Excel spreadsheet into UltraTax CS 706, you can save the spreadsheet as an XLS file and/or modify the CSV spreadsheet using Microsoft Excel guidelines.

Related Content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close