Importing account balances into UltraTax CS

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

The tax code assignments that you make in Accounting CS for specific general ledger accounts enable UltraTax CS to carry account balances to the proper lines on the appropriate tax forms. Use the procedures below to transfer a client's general ledger account balances from Accounting CS to UltraTax CS.

See also: Write-up process workflow

Prior to transferring account balances from Accounting CS to UltraTax CS, print the following reports.

  • Tax Code Groupings
  • Tax Code Worksheet (if applicable)
  • Tax Reconciliation Worksheet (if applicable)

Steps in Accounting CS

Assign the appropriate tax codes for the selected client. You can enter these codes in either of the following screens.

Notes

  • The entity types are the same in Accounting CS and UltraTax CS.

    1040, 1120 or 1065, 1041, 990, and 5500

  • For multiple-unit entities, select the unit to designate the input screen location when transferring data to your tax application. For example, if you are transferring utilities expenses for a farm to the UltraTax CS Farm input screen and the tax code for the first unit's utilities is 632 and the unit is 1, you would transfer the second unit's utilities with a tax code of 632 and a unit of 2.
  • If the data-entry grid does not include a Tax Code column, click the View Maintenance link at the top of the screen, and then add a Tax Code column. (Mark the Include Unit Column checkbox if you want to include Units in the view for the trial balance.) Show me.
    trial bal tax and unit col

Steps in UltraTax CS

  1. In UltraTax CS, choose Setup > User Preferences and click the File Locations tab.
  2. Click the CS Accounting Products option and verify the location for the Accounting CS client data file type. If it is not the location where your Accounting CS client data resides, click the Modify Location button, browse to the correct location, and then click OK to close the Modify Location dialog. Click OK to close the User Preferences dialog.
  3. Open the UltraTax CS client and choose Utilities, then Accounting CS (Import).

    Note:

    • Accounting CS (Import) won't be available unless you've installed Accounting CS and set up the correct data location.
    • If you've opened a 1040 client, make sure that you have not selected View, then Client Organizer. If you're in Client Organizer view, the Import icon will be inactive and Accounting CS (Import) won't be available from the Utilities menu.
  4. In the Clients available to transfer pane, highlight the client(s) whose account balances you want to import into UltraTax CS and then click the Select button to move them to the Clients to transfer pane.
  5. In the Data to import group box, specify the type of trial balance data to retrieve and whether you want detail or summary information, and then click the Import button.

    Ultratax import dialog 1

    Notes

    • Choose the Adjusted Trial Balance option to import the adjusted balances from Accounting CS. Choose the Federal Tax Trial Balance option to import the tax balances as defined in the Setup > Clients > Accounting Information tab in Accounting CS.
    • To list each account description and amount when importing to a field in UltraTax CS that includes a statement, select Detail. To have the import process combine all amounts and only show one description and total in the statement, select Summary. Show me.

    Detail

    Detail option

    Summary

    Summary option
  6. When the import is complete, click the Done button.

Notes

  • UltraTax CS will import data from the Accounting CS FIRM database only. If client data is stored in a different database, that data will not be available for import into UltraTax CS.
  • For more information on tax codes and the import procedures in UltraTax CS, see UltraTax CS integration with other applications.

Was this article helpful?

Thank you for the feedback!

Internal only

ACS requires a FIRM database for integration and data sharing to work with UltraTax CS. The format of the ACS 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.