Integration between UltraTax CS and Accounting CS

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Web text: ut-acs

Use the Accounting CS Import dialog in UltraTax CS to retrieve general ledger balances from Accounting 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.
  3. Choose Setup > File Locations in Accounting CS prior to integrating with UltraTax CS.

Import process

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

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

  4. In the Import from Accounting CS dialog, highlight the clients whose general ledger balances that you want to transfer and click Select.

    Note: Only data from Accounting 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 theAccounting 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 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 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. 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.

Share This