Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Integrate with CS Suite

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.
  1. Initial setup:
  2. Verify that the most recent version of the application is installed and that all updates have been applied.
  3. Select
    Setup
    ,
    User Preferences
    , then
    File Locations
     to set up data paths in UltraTax CS.
    note
    • For UltraTax CS, the default path is
      X:\WinCSI\UTYYData
       (where
      X
       is where your applications are installed and
      YY
       is the year of UltraTax CS).
    • For Accounting CS and Workpapers CS, the default paths are
      X:\\WinCSI\Accounting CS Data
       and
      X:\WinCSI\Workpapers CS Data
      . Enter 1 path for the application you want to integrate with.
  4. In Accounting CS or Workpaper CS, select
    Setup
    , then
    File Locations
    .
  5. Assign tax codes to GL accounts in Accounting CS or Workpapers CS.
  6. Import process:
  7. 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.
  8. Open the client in UltraTax CS.
    note
    You won't be able to do this from the
    Utilities
     menu.
  9. Select
    Utilities
    , then
    Accounting CS (Import)
     or
    Workpaper CS (Import)
    .
    note
    You'll only be able to select an application that you have licensed and installed.
  10. Choose the clients, then use
    Select
    .
    note
    Only data from Accounting CS or Workpaper CS clients that are the same entity type as the open UltraTax CS client are available for retrieval.
  11. Use the
    Data to Import
     section 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.
  12. Select
    Import
    .
    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.
    • Detail
       imports every account coded to a tax code and displays it on its own line item in a statement window (or subschedule).
    • Summary
       will 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 the
      Year End Close
       window to move back to the current year. Import the data to UltraTax CS again.
    note
    If you're troubleshooting an issue importing account balances that requires you to recreate the XML file, you'll need to do the following:
    1. Close the client in UltraTax.
    2. 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.
    3. Rename the existing XML file by adding
      .OLD
       after the file extension.
    4. Try the import again.
    note
    Internal use only
    • 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 be
      ACS_<FirmID>_Firm
      . (For example,
      ACS_0_Firm
      ,
      ACS_999_Firm
      ,
      ACS_798046_Firm
      .) Workpapers CS standalone database will still be named beginning with
      ACS_
      . Also, integration and data sharing doesn’t work if there are multiple FIRM databases.
    • Integration data is stored in
      X:\WINCSI\Accounting CS Data\Data\Integration\Tax
      , or for Workpapers CS standalone in
      X:\WINCSI\Workpapers CS Data\Data\Integration\Tax
      . The files are named as
      ClientID_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,Workpapers CS
  • Return type: 1040 Individual,1120 Corporation,1065 Partnership,1041 Fiduciary

Related Content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close