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. Only data from Accounting CS clients that are the same entity type as the open UltraTax CS client are available for retrieval.

Verify that the most recent version of the application is installed and that all software updates have been applied.

  1. Choose Setup > User Preferences > File Locations to set up data paths in UltraTax CS prior to importing data from Accounting CS.
  2. Choose Setup > File Locations in Accounting CS prior to creating an import file for UltraTax CS.
  3. Open the client in UltraTax CS.
  4. Choose Utilities > Accounting CS (Import) in UltraTax CS to import tax codes from Accounting CS. (Note that this command is not available if Accounting CS is not installed on the workstation in which UltraTax CS is installed.)
  5. Verify that the year of the posting period in Accounting CS matches the UltraTax CS year prior to reviewing tax codes. (For example, you will need to move Accounting CS to 2016 to review the tax codes in 2016 UltraTax CS for a 1120 fiscal year end.)
  6. In the Import from Accounting CS dialog, highlight the clients whose general ledger balances that you want to transfer and click Select.
  7. Use the fields in the Data to Import section to specify the retrieval of adjusted trial balance or the federal tax trial balance, year end, and whether to import detailed or summary tax code information.
  8. Click the Import button.

Notes

  • Fiscal year end clients: UltraTax CS imports balances based on the Accounting CS client's beginning fiscal year end. 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. You must first correct any errors in Accounting 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.

Internal notes


Accounting CS requires a FIRM database for integration and data sharing to work with UltraTax CS. The format of the Accounting CS database name must be ACS_<FirmID>_Firm. (For example, ACS_0_Firm, ACS_999_Firm, ACS_798046_Firm_.) Also, integration and data sharing does not work if there are multiple FIRM databases.

Share This