Import account balances into UltraTax CS

Before you begin

Tax Code Groupings
Tax Code Worksheet
Tax Reconciliation Worksheet

Steps in

Workpapers CS

In the Tax information section of the
Setup
,
Chart of Accounts
screen.
In the data-entry table in the
Actions
,
Enter Trial Balance
screen.

Steps in UltraTax CS

In UltraTax CS, select
Setup
, then
User Preferences
.
Select the
File Locations
tab.
Select
CS Accounting Products
, then verify the location for the
Workpapers CS
client data file type.
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 select
OK
again to close the window.
Open the UltraTax CS client, select
Utilities
, then select
Workpapers CS
(Import)
.
note
Workpapers CS
(Import)
won't be 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
. If you're in the Client Organizer view, the Import icon will be inactive, and
Workpapers CS
(Import)
won't be available from the
Utilities
menu.
In the Clients available to transfer pane, select the clients whose account balances you want to import into UltraTax CS, then choose
Select
to move them to the Clients to transfer pane.
Select your options in the Data to import section, then select
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 field in UltraTax CS that includes a statement.
Select
Summary
to have the import process combine all amounts and only show 1 description and total in the statement.
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

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

Resolve import issues for account balances

Close the client in UltraTax.
Go to the data location where the XML files are saved (by default the location is \WinCSI\Accounting CS Data (or Workpapers CS Data)\Data\Integration\Tax.
Rename the existing XML file by adding
.OLD
after the file extension.
Try the import again.

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.