Convert client data from ProSystem fx engagement

Objective

Conversion considerations and recommendations

We recommend you convert a smaller, easy-to-process client first. This will help you become familiar with the conversion options in Workpapers CS.
Some data items from ProSystem fx Engagement aren't converted because there's no exact equivalent in Workpapers CS.

Install the conversion program

Download the Prosystem fx to Workpapers CS conversion utility zip file.
Right-click on the
CSConvert.zip
file and select
Extract all
.
Copy the CSIConvert folder into
C:\Program Files
(NOT X86)
.
Go to
C:\Program Files\CSIConvert\Workpapers CS
.
Right-click on
pfwg_dotnet_registration_dos_cmds.bat
and select
Run as Administrator
.
When that's finished, go back to
C:\Program Files\CSIConvert
.
Right-click on
ConvertWorkpapersCS.exe
and select
Run as Administrator
.

Convert client data before importing into Workpapers CS

Verify that the ProSystem fx Engagement binder has been synced with the Local File Room and that any instances of this binder or workpapers are closed on your workstation.
Go to the download location of the ProSystem fx to Workpapers CS conversion utility. Right click on the
CSIConvert.zip
file and select
Extract All
. Inside the CSIConvert folder, right click on the
ConvertWorkpapersCS.exe
file and select
Run as Administrator
.
In the
Select Competitor
dropdown, select
ProSystem fx
.
In the
Select the export location for the converted files
field, select
Browse
to go to the location where the import files should be placed until imported into WorkpaperCS.
Select
Start Conversion
.
If prompted to close all open sessions of Word and Excel, close those sessions.
If prompted to select your user, select the sign in for the Local File Room you want to convert data for. This screen will open only if multiple sign-ins exist on the workstation.
In the Processing Type window, select either
Single
or
Multiple
.
note
Single converts 1 client at a time and allows for greater customization. Multiple allows for multiple clients, but the application makes more assumptions about the clients during the conversion.
In the
Select a Client
window or
Select client(s)
window, select the clients you want to convert then select
Continue
.
note
This window lists all available clients for conversion from ProSystem fx Engagement. Your selection of
Single
or
Multiple
in step 8 determines whether you can select 1 or multiple clients.
In the
Engagement Selection
window, which lists all of the binders and engagements for the selected clients, select an engagement type for each binder you want to convert, then select
Continue
.
If you selected a single conversion, an optional
Trial Balance Selection
screen may open if multiple Trial Balances existed in ProSystem fx Engagement. Workpapers CS supports only 1 Trial Balance per engagement. Select the Trial Balance. If you selected multiple conversions, the last accessed Trial Balance will be used.
Select
Continue
.
In the
Account classification Selection
window, select the ProSystem fx Engagement group that contains the account classification you want to use in Workpaper CS.
note
If you select
Skip
, the program won't convert any Account Classifications for the Trial Balance Accounts.
In the
Tax group Selection
window, select the set of tax codes to convert for your Trial Balance. If you selected multiple conversions, the last tax year will be used.
Select
Continue
to start the data conversion process, and then follow the prompts that appear on the screen.
At the prompt indicating the conversion process is complete, select
OK
to start importing the converted data into Workpapers CS.
In Accounting CS, select
File
,
Import
, then
ProSystem fx Engagement
to open the ProSystem fx Engagement conversion wizard.
Source Data: Select the location where your ProSystem fx Engagement export files are stored then select
Next
.
Source Data - Clients: Mark the checkbox next to the ProSystem fx Engagement client or multiple clients that you want to convert, then select
Next
.
Staff: Select the Workpapers CS staff member or multiple staff members to map to for each corresponding ProSystem fx Engagement staff in the list.
note
If a staff member isn't available from the dropdown in the Accounting CS Staff column, close the wizard and add that staff member at
Setup
Firm Information
Staff screen
then restart the conversion process.
Select
Finish
to complete the conversion.

Data transferred during conversion

Engagement-related data transferred during conversion

ProSystem fx Engagement Excel and Word demographic formulas

ProSystem fx engagement Excel and Word link formulas

Conversion notes and exceptions

Engagement tree structure
: The order and appearance of the engagement tree structure in Workpapers CS after the conversion may differ from the ProSystem fx Engagement binder. Note that all items are converted to the correct folder locations within the engagement. To provide maximum flexibility, Workpapers CS doesn’t automatically sort folders and workpapers.
Excel and Word workpaper add-ins, macros, and link
: Excel workpapers are modified during the conversion process for removal of add-ins, macros, and/or links.
Manual workpapers
: Manual workpapers are converted as text documents.
Tax codes
: If UltraTax CS® Tax Codes are desired during the conversion, a translation of ProSystem fx Engagement Tax Codes to UltraTax CS is available. Only 1Tax Code Group will convert.
Workpaper references
: Workpapers CS requires that workpapers have reference values. Workpapers without an index value are assigned a reference value during the conversion. You can rename the workpaper reference, if desired. If a duplicate reference exists in a folder, the duplicate references will be renamed.
Finalized binders
: Finalized binders will be converted as Active unfinalized binders. We recommend that you convert only active or unfinalized binders.

Items not converted

Workpapers not in a standard binder folder
: This includes workpapers within the Unfiled Workpapers, Conflicts, Incompatible Workpapers, Published Workpapers, and Trash folders. To convert these workpapers, you'll need to move the workpapers into a standard binder folder before the conversion process.
Trial Balance
: Consolidated trial balances.
Firm information
Client information
Engagement and workpaper password information
Engagement and workpaper history
Workpaper notes and templates
Staff
M3 Tax codes
Data Conversion Report
: The data conversion from ProSystem fx Engagement to Workpapers CS creates a report for each engagement converted. The Data Conversion report lists certain modifications made during the conversion process, such as truncations, abbreviations, and so on. Most items in the report are informational and don’t require immediate attention. To access the report, locate and open YYYYYY.html, where YYYYYY is the binder name. The report is placed in the user’s Documents folder.