Importing asset information from Excel

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

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

Characters left:

Change to CS Support service hours

Our Support department is closed on [[date]]. However, limited UltraTax CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline.

Links to our most popular tax processing topics are available in the Alerts and notices section on the right side of most pages.

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 cancelled.
  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