Creating and saving Excel spreadsheets for asset information (706)

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

MFA required for electronic filing

Effective May 3rd, the 2017 version of UltraTax CS requires multi-factor authentication (MFA) to transmit e-files from CS Connect. Find out more.

The Excel Import utility enables you to quickly and efficiently import asset information from a Microsoft Excel spreadsheet into UltraTax/706.

You must begin with the UltraTax/706 u7USAsset.xls template spreadsheet, which you must then save as an Excel comma separated values (CSV) file before you can import asset information from Excel into UltraTax/706. You can enter or modify the information in the Excel spreadsheet following the required guidelines.

  1. Copy the u7USAsset.xls template from your X:WinCSI\UT17\706US.ext,17,3,6#00000 folder (where X is the location where UltraTax/706 is installed) to another location.
  2. Open and save the template using another file name.
    1. Click the Office button, and select Save As.
    2. Browse to the location where you want to save the Excel spreadsheet.
    3. Select CSV (Comma delimited)(*.csv) from the Save as type field.
    4. Enter a file name in the File name field.
    5. Click the Save button.
  3. Enter the asset data in the spreadsheet.

    Note: Do not alter the order of the headings or alter the field names in the spreadsheet.

  4. After you enter all data, save and close the spreadsheet.

Related topics

Share This