Preparing Excel data for import into UltraTax CS statements

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.

Before you can import data from Excel (or another application) into UltraTax CS statements, you may need to take additional steps to prepare the information for processing.

Save the Excel spreadsheet containing the data you want to import to a local or network hard drive, or embed it in FileCabinet CS. If the spreadsheet was sent from a client as an attachment to an email message, use Excel to save the file to the hard drive.

Note: If the data is not in Excel format (it was created and saved in a application other than Excel), copy the data to the Windows Clipboard. To do this, open the spreadsheet file, highlight all the data to be imported, then choose Edit > Copy. Consult the help for the spreadsheet application for more information on copying a range of cells.

Formatting guidelines for Excel spreadsheets

Consider the following information when creating or formatting an Excel file that will be imported into an UltraTax CS statement. Also, review the examples of data that must be verified for information on formatting certain values.

  • If a password is required to open the Excel file, you will be prompted to enter the password to select the file for import.
  • If a password is required to modify the Excel file, you will not be prompted for the password because UltraTax CS uses read-only access to extract the information from the Excel file.
  • Certain formatting in Excel will not affect the data that is imported into UltraTax CS. For example, if a date is formatted in Excel as 18-Mar-2009, the value of 3/18/2009 is imported into UltraTax CS. Dollar amounts can be formatted as either numerals or currency.
  • Columns that are hidden in Excel will be displayed in the grid on the Import Spreadsheet - Step 2 of 2 dialog in UltraTax CS.
  • If the Excel spreadsheet contains headings, subtotals, totals, and footnotes, you can use the Import Spreadsheet - Step 2 of 2 dialog to omit these rows and prevent unwanted data from transferring into the UltraTax CS statement.

Note: If the spreadsheet has column headings, include them in the range to copy so they will be available for reference when mapping columns in UltraTax CS.

Next step: Select the spreadsheet to import

Related topics

Importing Statement Data from Excel overview

Was this article helpful?

Thank you for the feedback!