Migrate documents from Prosystem fx Document to GoFileRoom
The CCH® ProSystem fx® Document Migration Service uploads documents that have been extracted from CCH® ProSystem fx® Document to GoFileRoom. This document explains the migration process in detail and provides specific information about the migration of documents stored in CCH® ProSystem fx® Document to be stored in GoFileRoom.
Using the Document Migration Service
- Work with your Consultant on timing of when data should be sent to Thomson Reuters.
- Prepare and send your CCH® ProSystem fx® Document data for migration.
- Work with your Consultant to determine how uploaded documents will be indexed in GoFileRoom.
Your documents will be ready for use within GoFileRoom when the migration process is complete.
What to expect from the document migration
The document migration process is customized based on how your firm has stored documents in CCH® ProSystem fx® Document and how your firm has set up GoFileRoom. Your firm should expect to commit some time to the migration process. The amount of time needed typically depends on the number of documents being migrated and the consistency in naming conventions used to store documents in CCH® ProSystem fx® Document.
Due to differences between document management applications, your firm’s documents may be added to GoFileRoom using generic file location information. However, you can change the file location of your firm’s documents later, if necessary.
Confidentiality
We acknowledge that your firm will be sending confidential client information. Thomson Reuters and the Technical Services team will use the information solely to migrate documents in a secure environment so that the documents will be available to your firm. We treat all client information as confidential. We retain your source data for 60 days after providing your firm with a document reconciliation report to help you identify and manage any unprocessed data. For additional information, you can view our Privacy Policy from the bottom of any page on our website, CS.ThomsonReuters.com.
CCH® ProSystem fx® Document Migration Service Steps
Step 1: Scheduling your migration date
Upon receiving your signed agreement, Technical Services will contact you within three business days to confirm scope and schedule date to begin the migration. If you are migrating documents as part of a Guided Implementation, your Consultant will discuss timing with you. The typical turnaround time for the entire migration is eight weeks from the time we receive your data.
Step 2: Preparing and sending your client data for conversion
Thomson Reuters will discuss preliminary information with you that your firm can compile to minimize the turnaround time for document migration. For examples of this information, review the
Client cross-reference list example
at the end of this article.For the fastest and most efficient migration, we recommend that you send all your client data at one time and that you designate a person at your office through which your Consultant and Technical Services will facilitate the migration.
note
Failure to properly prepare and send client data will result in the delayed processing of your migration. For assistance with copying or sending your data, contact CCH® ProSystem fx® Document Support.
Complete the following steps to create a copy of your CCH® ProSystem fx® Document data.
- Verify that you have an external hard drive with sufficient space to store a copy of your CCH® ProSystem fx® Document data.
- Verify that all documents are checked in to the CCH® ProSystem fx® Document. For more information, go to CCH Support.
- Identify the storage location that contains your documents.noteThe standard storage location for documents in CCH® ProSystem fx® Document is \\Pfxdocument\.
- Navigate to the storage location you identified in Step 3, copy the entire folder, and paste it to an external hard drive.
- Browse to your SQL database location and backup the primary CCH® ProSystem fx® Document database and include this with the document files you copied to the external hard drive.
- Encrypt the data on the hard drive using a data-encryption program such as BitLocker, a free application that is available from Microsoft.
- Ship the encrypted hard drive to the Technical Services team at the following address.Thomson ReutersC/O Technical Services6300 Interfirst DriveAnn Arbor, MI 48108
- Send the password for the encrypted drive to a Technical Services representative via email.
Step 3: Determining how to index documents in GoFileRoom
Index values must be assigned to each document that is stored in GoFileRoom. These index values identify the who, what, and when of a document so that it can be quickly and easily located. You can customize index values to meet your firm’s needs. Your firm will need to determine how the documents that are migrating should be indexed in GoFileRoom. Below is an example of the indexing structure using our recommended best practices.
- Client Name:A unique, identifiable name. (This value can be transferred from your practice management application.)
- Client Number:A unique value (alphabetic, numeric, or alphanumeric) that is associated with a client name. (This value can be transferred from your practice management application.)
- File Section:Used to identify the type of work with which the document is associated. This value may also be used to identify correspondence or other permanent information. Examples include: Individual Tax 1040, Business Tax 1120, Audit, etc. (These values are controlled by your firm’s GoFileRoom administrator.)
- Document Type:Used to identify the type of information that is contained in the document. The Document Types that are available vary depending on the File Section. Examples include: Tax Return, Workpapers, Financial Statement, etc. (These values are controlled by your firm’s GoFileRoom administrator.)
- Description:Provides additional details about a document.
- Year:Used to identify the year of services to which the document applies. (These values are controlled by your firm’s GoFileRoom administrator.)
- Period End:Used to identify the period of services to which the document applies. (These values are controlled by your firm’s GoFileRoom administrator.)
- Document Date:Used to identify a specific date with which the document should be associated.
Documents extracted from CCH Prosystem fx Document are assigned GoFileRoom index values as follows.
CCH® ProSystem fx® Document | GoFileRoom index value | Additional information |
|---|---|---|
Client number | Client number | If the client number in CCH® ProSystem fx® Document does not match the Client Number in GoFileRoom, you must set up a cross reference. Review an example at the end of this article. |
Client name | Client name | Associated by the Client number. |
Class | File section | May be indexed under a generic file section. If your firm requires more specific mapping, provide a cross reference of Class and Subclass. Review an example at the end of this article. |
Subclass | Document type | May be indexed under a generic Document Type. If your firm requires more specific mapping, provide a cross reference of Class and Subclass. Review an example at the end of this article. |
Document name | Description | The file name as listed in CCH® ProSystem fx® Document. |
Year | Year | Can be determined by a year contained within the folder name or by the date on which the document was created. The date will be left blank for Permanent Documents. |
N/A | Period end | Can be determined through a cross-reference list. If period end cannot be determined through the folder name or cross-reference, period end of 12/31 will be used. |
Creation date | Document date | The date on which the document was created. |
Step 4: Index mapping approval and migration
After indexes have been assigned but before migrating documents, we will provide your firm with a review spreadsheet that shows the proposed index mapping for all documents that will be migrated, as shown in the sample mapping example at the end of this article. At this point, your firm can make any necessary changes.
After your firm has given final approval on the index mapping, we can begin the document upload process. Depending on the number and size of the documents, the upload can take between one and several days. Technical Services can typically determine how long the upload will take before starting the process.
note
The maximum number of documents that can be processed per night is 30,000. However, the presence of multiple large documents (over 1GB) may reduce this number.
When the migration process is complete, you will be provided a spreadsheet that contains document filenames, indexing information, and GoFileRoom document IDs, which are assigned to all documents that are uploaded to GoFileRoom.
Client cross-reference list example
note
If client numbers contain leading zeros, verify that the field is formatted as text.
Class/SubClass and File Section/Document Types mapping example
You can refer to the following example for mapping CCH® ProSystem fx® Document Class and Subclass classifications when determining how to index your documents in GoFileRoom. Thomson Reuters will provide you with a worksheet to complete if your firm is not able to extract this information from your SQL database location. For more information, review the CCH help topic How to get a list of your Class and Subclasses from Document.
Sample proposed mapping
The following example spreadsheet shows what the proposed mapping will look like.
