Import client information from UltraTax CS

You can import client setup information from existing client records in UltraTax CS to
Workpapers CS
. This time-saving process removes the need to create a tax engagement client from scratch in
Workpapers CS
.

Before you begin

  • You'll need UltraTax CS (v.2013.3.0 or later) installed on the same machine or server as
    Workpapers CS
    .
  • You'll need to enable
    Accounting and/or the Workpapers service
    in the application.
    1. Go to
      Setup
      , then the
      Clients
      screen.
    2. Select the
      Main
      tab.
    3. Enable the
      Accounting and/or the Workpapers service
      .
  • Each client record in UltraTax CS needs to have information in the following fields.
    • Client ID.
    • EIN/SSN.
    • Address.
    • State.

Steps in UltraTax CS

  1. Select
    Help
    , then select
    Repair
    .
  2. Select the
    Misc
    tab, then select
    CS Accounting Products
    .
  3. Select
    Populate
    to create an export file.

Steps in
Workpapers CS

  1. Select
    File
    , then select
    Import
    .
  2. Select
    Populate Clients from UtraTax CS
    .
  3. Select an entity, a single client, or multiple clients.
The populated fields in UltraTax CS determine the information created for the client in
Workpapers CS
. The following tables identify the data fields in UltraTax CS and the corresponding fields in
Workpapers CS
.
UltraTax CS 1040 clients
UltraTax CS field name
Workpapers CS
field name
ID
ID
SSN
EIN/SSN
Taxpayer First Name
Client Name
Spouse First Name
Client Name
Taxpayer Last Name
Client Name
Taxpayer Daytime Phone
Business Phone
Taxpayer Home/Evening Phone Number
Home Phone
Taxpayer Client Contact Information
All Other Taxpayer Phone Numbers
Taxpayer Other Phone Numbers
All Other Taxpayer Phone Numbers
Address
Business Address Line 1
Apartment Number
Business Address Line 2
City
City
State
State
Zip
Zip
Taxpayer Email
Email
Type (1040)
Entity
Year End Date
Current fiscal year end date
UltraTax CS 1120 or 1065 clients
UltraTax CS field name
Workpapers CS
field name
ID
ID
EIN
EIN/SSN
Name
Client Name
Doing business as
DBA Name
Address
Business Address Line 1
City
City
State
State
ZIP Code
Zip
Email address
Email
Client Phone Number/Telephone Number
Business Phone Number
Client Contact Information
All Other Phone Numbers
Other Phone Numbers
All Other Phone Numbers
Type (1120C, 1120S, 1065)
Entity
Tax year ending
Current fiscal year end date
UltraTax CS 1041 clients
UltraTax CS field name
Workpapers CS
field name
ID
ID
Employer Identification Number
EIN/SSN
Name
Client Name
Telephone Number
Business Phone Number
Client Contact Information
All Other Phone Numbers
Other Phone Numbers
All Other Phone Numbers
Street
Business Address Line 1
City
City
State
State
Zip
Zip
Email
Email
Tax year ending
Current fiscal year end date
Type (1041)
Entity
UltraTax CS 990 clients
UltraTax CS field name
Workpapers CS
field name
ID
ID
EIN/SSN
EIN/SSN
Name
Client Name
Doing business as
DBA Name
Telephone Number
Business Phone Number
Client Contact Information
All Other Phone Numbers
Other Phone Numbers
All Other Phone Numbers
Address & Room
Business Address Line 1
Suite Number
Business Address Line 2
City
City
State
State
Zip
Zip
Email
Email
Tax year ending
Current fiscal year end date
Type (990,990PF)
Entity
UltraTax CS 5500 clients
UltraTax CS field name
Workpapers CS
field name
ID
ID
EIN/SSN
EIN/SSN
Name of Sponsor
Client Name
DBA Name
DBA Name
Telephone Number
Business Phone Number
Client Contact Information
All Other Phone Numbers
Other Phone Numbers
All Other Phone Numbers
Address
Business Address Line 1
City
City
State
State
Zip
Zip
Email
Email
Tax year ending
Current fiscal year end date
Type (5500)
Entity