Integration between UltraTax CS and Accounting CS

Alerts and notices
Web text: ut-acs

Use the Accounting CS or Workpaper CS Import dialog in UltraTax CS to retrieve general ledger balances from Accounting CS/Workpapers CS into the open UltraTax CS client.

Initial setup

  1. Verify that the most recent version of the application is installed and that all software updates have been applied.
  2. Choose Setup > User Preferences > File Locations to set up data paths in UltraTax CS prior to importing data from Accounting CS or Workpaper CS.
    • For UltraTax CS, the default path is X:\WinCSI\UTYYData (where X represents the server or computer where your programs are installed and YY represents 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.
  3. Choose Setup > File Locations in Accounting CS or Workpaper CS prior to integrating with UltraTax CS.

Import process

  1. Verify that the year of the posting period in Accounting CS or Workpaper CS matches the UltraTax CS year prior to reviewing tax codes.
  2. Open the client in UltraTax CS.
  3. Choose Utilities > Accounting CS  (Import) or Workpaper CS (Import) in UltraTax CS to import balances from Accounting CS or Workpaper CS.

    Note: This command is not available if Accounting CS or Workpaper CS is not installed on the workstation in which UltraTax CS is installed.

  4. In the Import from Accounting CS or Workpaper CS dialog, highlight the clients whose general ledger balances that you want to transfer and click 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.

  5. Use the fields in the Data to Import section to specify the retrieval of adjusted trial balance or the federal tax trial balance, whether to import detailed or summary tax code information, and year end.
  6. Click the Import button.

Notes

  • 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 vs. Summary: Detail imports every account that is coded to a tax code and displays it on its own line item in a statement dialog (or subschedule). Summary will import only the total to the statement dialog.
  • If the application encounters an invalid tax code during the import process, it displays following dialog with the data grayed out; you cannot modify the data from this dialog. The invalid tax codes are indicated by a red bar to the right of the tax code. 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 overwritten, unless they were overruled within UltraTax CS.
  • When you overrule an imported amount, UltraTax CS does not overwrite that amount with subsequent imports. Follow the steps in the Input screen overrule article in the UltraTax CS Help & How-To Center to enable notifications of overruled data, and then delete any existing overrules before importing.
  • If some or all of the balances are not 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 dialog to move back to the current year. Import the data to UltraTax CS again.

Internal notes


  • Accounting CS and Workpapers CS requires a FIRM database for integration and data sharing to work with UltraTax CS. The format of the database name must 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 does not 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 have been modified recently, and even open the files to verify the tax codes and corresponding balances that are included in the file.

  • If one of the applications is on VO/SAAS and one is local, the option for importing balances will not be available.