Triva isn't available right now.
Check out the support page for our phone number and hours
Legal
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
Questions? We are here to help
Tax & Accounting
-
Top products for corporations
-
Top products for accounting firms
Recommended Products
-
CoCounsel Tax, Audit, Accounting
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
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.- TheCell datafield in the Data Verification window displays the data that didn’t pass data verification. The reason for the error is displayed in theCell Data Statusfield following it.
- Use theCell datafield to edit the invalid information. TheCell Data Statusfield will indicate that the data is valid once it's correct.noteCertain 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 onlyT(for taxpayer),S(for spouse), orJ(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 enter16.2%as16.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.
noteTo skip a cell without changing the invalid data, selectNext Cell. To ignore all invalid data and continue with the import, selectImport. 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. - 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, selectCancelto close the Data Verification window and return to the Import Spreadsheet - Step 2 of 2 window.
- Once you have corrected or omitted the invalid data, selectImportto 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