Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Import statement data from Excel

Verify imported spreadsheet data

Before you can import the data in the Import Spreadsheet grid into the statement columns specified in the column mapping, UltraTax CS needs to verify that the data is correct for the type of column. The Import Spreadsheet - Step 2 of 2 window will display a red border around each cell containing invalid data. You can edit the data on the grid before importing, but note that any data changed in the grid won’t change in the source file.
If you select
Import
 before correcting the invalid data on the Import Spreadsheet - Step 2 of 2 window, the Data Verification window opens, prompting you to edit the values in the invalid cells.
  1. The
    Cell data
     field in the Data Verification window displays the data that didn’t pass data verification. The reason for the error is displayed in the
    Cell Data Status
     field following it.
  2. Use the
    Cell data
     field to edit the invalid information. The
    Cell Data Status
     field will indicate that the data is valid once it's correct.
    note
    Certain spreadsheet values need to conform to specific formatting to ensure that the data imports into UltraTax CS correctly.
    • Some UltraTax CS statement columns need you to make a selection from a dropdown list, and won’t accept any values not contained in the list. For example, the T/S/J column will accept only
      T
       (for taxpayer),
      S
       (for spouse), or
      J
       (for joint). If data is imported into the T/S/J column, the data verification process requires that only T, S, or J be imported. Any other values are marked as invalid.
    • UltraTax CS accepts percentages in a format of xxx.xx, meaning that you should enter
      16.2%
       as
      16.2
      . Since this same percentage is entered into Excel as
      .162
      , the data verification process will convert percentages into the format that UltraTax CS accepts. Format percentages as percentages in Excel to ensure that the data remains correct after the import.
    • Verify that certain numbers are in the correct format. For example, Social Security numbers should be in the xxx-xx-xxxx format.
    note
    To skip a cell without changing the invalid data, select
    Next Cell
    . To ignore all invalid data and continue with the import, select
    Import
    . If you proceed with the import, all invalid data won’t be included with the import, and the corresponding fields will be left blank in the UltraTax CS statement window.
  3. If you find that all data in a row or column is invalid, and you want to omit the row or modify a column's mapping, select
    Cancel
     to close the Data Verification window and return to the Import Spreadsheet - Step 2 of 2 window.
  4. Once you have corrected or omitted the invalid data, select
    Import
     to transfer the spreadsheet data into the UltraTax CS statement window. If the statement already includes data (from a previous spreadsheet import, proforma, data sharing, an accounting data import, or manual data entry), you will be asked whether you want to append imported data to existing data, replace all existing data with imported data, or replace only previously imported data with the new spreadsheet data.
    After the transfer is complete, the statement window will open and display the data that you imported. Each row that was imported will have an Excel icon next to the row number to signify that it was imported from a spreadsheet. If necessary, you can edit any imported data in the statement window.

This article applies to:

  • Product: UltraTax CS

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close