Importing asset information from Excel (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.

With the Excel Import utility, you can quickly and efficiently import asset information from a Microsoft Excel spreadsheet into UltraTax/706.

You must begin with an Excel spreadsheet that contains the asset data that you want to import into UltraTax/706 before you can import information from Excel. For details, see Creating and saving Excel spreadsheets for asset information. You can enter or modify the information in the Excel spreadsheet following the required guidelines.

Importing asset information from Excel

You must be in Screen Asset to import asset information into UltraTax/706.

  1. Choose Edit > Import spreadsheet.
  2. Click the Select button to browse to the location of the spreadsheet file.
  3. Highlight the file you want to import, and click the Open button.
  4. Click Yes when prompted to remove existing input screen data if you want to overwrite existing data. If you click No, the import process will be canceled.
  5. Click OK when prompted that the data was successfully imported.

Note: If any errors occur during the import process, UltraTax CS generates a warning that no data was imported. If UltraTax CS generates this error message, you need to correct any errors in the Excel spreadsheet and re-import the data.

Related topic: Excel Import utility for asset information overview (706)

Share This