Skip to main content
Integrate with CS Professional Suite

Import account balances into UltraTax CS

Transfer general ledger account balances from
Workpapers CS
 to UltraTax CS using tax code assignments to populate the correct tax form lines.

Before you begin

important
Verify that you've installed the most recent version of
Workpapers CS
 and UltraTax CS, and that you've applied all updates.
Before transferring account balances from
Workpapers CS
 to UltraTax CS, print the following reports.
  • Tax Code Groupings
  • Tax Code Worksheet
  • Tax Reconciliation Worksheet

Steps in
Workpapers CS

Assign the proper tax codes for the selected client. You can enter these codes in either of the following screens.
  • In the
    Tax information
     section of the
    Setup
    ,
    Chart of Accounts
     screen.
  • In the data-entry table in the
    Actions
    ,
    Enter Trial Balance
     screen.
Make sure that the entity types (1040, 1120 or 1065, 1041, 990, and 5500) are the same in
Workpapers CS
 and UltraTax CS.
For multiple-unit entities, select the unit to designate the input screen location when transferring data to your tax application.
For example, if you transfer utilities expenses for a farm and the 1st unit uses tax code 632 with unit 1, transfer the 2nd unit's utilities using tax code 632 with unit 2.
If the Trial Balance grid doesn't have a Tax Code column, select
View Maintenance
 and add it. If you want to include
Units
 in the trial balance view, mark the
Include Unit Column
 checkbox.

Steps in UltraTax CS

  1. In UltraTax CS, select
    Setup
    , then
    User Preferences
    .
  2. Select the
    File Locations
     tab.
  3. Select
    CS Accounting Products
    , then verify the location for the
    Workpapers CS
     type of client data file.
    • If it's not the location where your
      Workpapers CS
       client data is stored, select
      Modify Location
      . Go to the correct location, select
      OK
      , then
      OK
       again to close the window.
  4. Open the UltraTax CS client, select
    Utilities
    , then select
    Workpapers CS
     (Import)
    .
    note
    • Workpapers CS
       (Import)
       isn't available unless you've installed
      Workpapers CS
       and set up the correct data location.
    • If you've opened a 1040 client, make sure that you haven’t selected
      View
      , then
      Client Organizer
      . In the Client Organizer view, the Import icon is inactive, and
      Workpapers CS
       (Import)
       is unavailable from the
      Utilities
       menu.
  5. In the
    Clients available to transfer
     pane, select the clients you want to import into UltraTax CS, then
    Select
     to move them to the
    Clients to transfer
     pane.
  6. Select your options in the
    Data to import
     section, then
    Import
    .
    note
    • Select
      Adjusted Trial Balance
       to import the adjusted balances from
      Workpapers CS
      .
    • Select
      Federal Tax Trial Balance
       to import the tax balances as defined in the
      Setup
      ,
      Clients
      ,
      Accounting Information
       tab in
      Workpapers CS
      .
    • Select
      Detail
       to list each account description and amount when importing to a statement field.
    • Select
      Summary
       to have the import process combine all amounts and only show 1 description and total in the statement.
  7. Select
    Done
     when the import is complete.
    note
    UltraTax CS will import data from the
    Workpapers CS
     FIRM database only. If client data is stored in a different database, that data won’t be available for import into UltraTax CS.

Best practices for tax codes

UltraTax CS tracks assets, capital gains, retained earnings/partner's capital, and other fund balances in detail. To avoid conflicts, exclude these tax code areas when you import from
Workpapers CS
 into UltraTax CS:
  • All entities:
    • Depreciation amounts
    • Capital gains - specifically book figures for the sales of capital assets
    • Section 179 expenses
  • 1120/1120S - Retained earnings
  • 1065 - Partners capital account
  • 990 - Unrestricted fund balances, accumulated income, other funds
note
In
Workpapers CS
, assign either the 88888 or 99999 tax codes to these accounts to exclude them from importing. Tax code units shouldn't be assigned to tax codes 88888 or 99999.
  • Tax code 88888 - account will print on the Tax Code Groupings Report in
    Workpapers CS
    .
  • Tax code 99999 - account won't print on the Tax Code Groupings Report in
    Workpapers CS
    .

Resolve issues with importing for account balances

If you're troubleshooting an issue importing account balances that requires you to recreate the XML file, you'll need to do the following:
  1. Close the client in UltraTax.
  2. Go to the XML file location (default: \WinCSI\
    Workpapers CS
     Data\Data\Integration\Tax).
  3. Rename the existing XML file by adding
    .OLD
     after the file extension.
  4. Try the import again.
Internal use only
  • Accounting CS and Workpapers CS require a FIRM database for integration and data sharing to work with UltraTax CS. The format of the database name needs to 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 doesn’t 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’ve been modified recently, and even open the files to verify the tax codes and corresponding balances that are included in the file.
  • If 1 of the applications is on VO/SAAS and one is local, the option for importing balances won’t be available.

This article applies to:

  • Product: Workpapers CS
  • Subject: Integration

Related Content