Importing account balances into UltraTax CS

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

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


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

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.

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 > Accounting CS (Import). (Accounting CS must be installed and the correct data location set up for this option to be available.)
  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.

Related topics

Account balance workflow and adjustments via the Trial Balance screen

Adding custom tax codes

Using tax codes to import general ledger balances into multiple-unit input screens (UltraTax CS)

Video: Exporting data to a Microsoft Excel file for tax reporting

Exporting client data to Lacerte, ProSystem fx, or ProSeries for tax reporting

Internal notes


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.

Share This