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
Retrieve general ledger balances from Accounting CS or Workpapers CS
You can use the Accounting CS or Workpaper CS
Import
window in UltraTax CS to retrieve general ledger balances from Accounting CS or Workpapers CS into the open UltraTax CS client.- Initial setup:
- Verify that the most recent version of the application is installed and that all updates have been applied.
- SelectSetup,User Preferences, thenFile Locationsto set up data paths in UltraTax CS.note
- For UltraTax CS, the default path isX:\WinCSI\UTYYData(whereXis where your applications are installed andYYis the year of UltraTax CS).
- For Accounting CS and Workpapers CS, the default paths areX:\\WinCSI\Accounting CS DataandX:\WinCSI\Workpapers CS Data. Enter 1 path for the application you want to integrate with.
- In Accounting CS or Workpaper CS, selectSetup, thenFile Locations.
- Assign tax codes to GL accounts in Accounting CS or Workpapers CS.
- Import process:
- Verify that the year of the posting period in Accounting CS or Workpaper CS matches the UltraTax CS year prior to reviewing the tax codes.
- Open the client in UltraTax CS.noteYou won't be able to do this from theUtilitiesmenu.
- SelectUtilities, thenAccounting CS (Import)orWorkpaper CS (Import).noteYou'll only be able to select an application that you have licensed and installed.
- Choose the clients, then useSelect.noteOnly data from Accounting CS or Workpaper CS clients that are the same entity type as the open UltraTax CS client are available for retrieval.
- Use theData to Importsection to specify the retrieval of the adjusted trial balance or the federal tax trial balance, whether to import detailed or summary tax code information, and the year end.
- SelectImport.note
- Fiscal year end clients:UltraTax CS imports balances based on the Accounting CS or Workpaper CS client's beginning fiscal year end. For example, a client with balances within a 4/1/2017 to 3/31/2018 accounting year will import into UltraTax CS version 2017.
- Detailimports every account coded to a tax code and displays it on its own line item in a statement window (or subschedule).
- Summarywill import only the total to the statement window.
- If the application finds an invalid tax code during the import process, it shows a message to alert you. Correct any errors with the tax coding in Accounting CS or Workpaper CS and import again.
- When you import balances into the same UltraTax CS client more than once, the previously imported amounts will be replaced, unless they were replaced within UltraTax CS.
- When you replace an imported amount, UltraTax CS doesn’t replace that amount with subsequent imports. You can enable notifications of overruled data, then delete any existing overrules before importing.
- If some or all of the balances aren't imported to UltraTax CS as expected, go to Accounting CS or Workpaper CS and change the client's posting period to the prior year, verify the tax codes, then change the posting period back to the current year. Complete theYear End Closewindow to move back to the current year. Import the data to UltraTax CS again.
noteIf you're troubleshooting an issue importing account balances that requires you to recreate the XML file, you'll need to do the following:- Close the client in UltraTax.
- Go to the data location where the XML files are saved (by default the location is \WinCSI\Accounting CS Data (or Workpapers CS Data)\Data\Integration\Tax.
- Rename the existing XML file by adding.OLDafter the file extension.
- Try the import again.
note- Accounting CS and Workpapers CS require a FIRM database for integration and data sharing to work with UltraTax CS. The format of the database name needs to beACS_<FirmID>_Firm. (For example,ACS_0_Firm,ACS_999_Firm,ACS_798046_Firm.) Workpapers CS standalone database will still be named beginning withACS_. Also, integration and data sharing doesn’t work if there are multiple FIRM databases.
- Integration data is stored inX:\WINCSI\Accounting CS Data\Data\Integration\Tax, or for Workpapers CS standalone inX:\WINCSI\Workpapers CS Data\Data\Integration\Tax. The files are named asClientID_BalanceInfo.xml. As part of troubleshooting, you may need to verify these files exist, whether they’ve been modified recently, and even open the files to verify the tax codes and corresponding balances that are included in the file.
- If 1 of the applications is on VO/SAAS and one is local, the option for importing balances won’t be available.
This article applies to:
- Product: Accounting CS, UltraTax CS
- Return type: 1040 Individual, 1120 Corporation
Related content
-
Recreate XML file when importing account balances
Format:
Article,
1 min read