Workpapers CS data sharing overview

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

You can automatically share general client and employee data based on EIN or SSN in many of our CS Professional Suite applications and in Onvio. The data sharing features enable the application to do the following.

  • Share general client with UltraTax CS.
  • Share general client data with Practice CS. Example.

    Your firm has an existing 1120S client already set up in Practice CS and you now want to set up that client in Workpapers CS.

    1. Choose Setup > Clients in Workpapers CS and then click the Add button. Enter a Client ID and Name in the Identification section and select the services your firm provides for this client.
    2. Click the Add button to create the new client record.
    3. Click the Accounting Information tab, click the Edit button, and select 1120S from the drop-down list in the Entity field.
    4. Click the Main tab and enter the client's EIN.
    5. If the EIN you enter exactly matches the client's EIN already recorded in Practice CS, Workpapers CS prompts you (via a Data Sharing dialog) either to accept the client's basic information from Practice CS or to postpone that acceptance. If you choose to accept, Workpapers CS automatically completes many of the fields in the Clients screen with current information from Practice CS (including names, addresses, phone numbers, and other contact information).
  • Share general client data with Onvio.
  • Share general information between multiple clients in Workpapers CS.

Setup details for data sharing

  • Before you can share data between two CS Professional Suite applications and/or Onvio Link, you need to define the data locations in both of those applications. In Workpapers CS, click the CS Professional Suite tab of the Setup > File Locations screen and specify the data locations for all of your firm's other CS Professional Suite applications and/or Onvio.

    Note: Shared data files are created in the X:\WINCSI\Accounting CS Data\clientID folder and named as follows: AxxxxxXP.XX16 (where xxxxx represents the first five characters of the client's ID).

  • Be sure to first specify the client's correct entity (the default entity is 1120C) in Workpapers CS before entering the client's EIN in the Setup > Clients screen. This step is critical to enabling the data sharing features to work correctly.

    Note: The primary address is the only one that is shared with other applications and that address is automatically defined as the mailing address for the entity.

  • For client information to be shared, EIN and SSN information must match exactly across CS Professional Suite applications and/or Onvio.
  • Verify that the Enable data sharing checkbox is marked in the Setup > Firm Information > Firm > Preferences tab.
  • Rebuild data sharing if you have marked the Enable data sharing checkbox after it was previously cleared, or if the Allow use of the data sharing feature checkbox has been marked in the Data Sharing tab of the Setup > Office Configuration dialog in UltraTax CS. While in the Enter Transaction, Setup > Client screen, or Employees screen, click the data sharing icon to rebuild for all clients or the current client. Show me.
    rebuild

Steps in UltraTax CS

  1. Choose Setup > User Preferences > File Locations tab, click the option for CS Accounting Products, and verify that the file locations are listed correctly for that application.
  2. Verify that the EIN/SSN that is listed in the File > Client Properties dialog is the same as the EIN/SSN in Workpapers CS.
  3. Verify that data sharing features are enabled - that is, that the Allow use of the data sharing feature checkbox has been marked in the Data Sharing tab of the Setup > Office Configuration dialog.
  4. In the UltraTax CS client, go to File, then Client Properties.
  5. In the Advanced Properties tab, make sure the Exempt this client from all Data Sharing functionality is not marked. 
  6. Verify that the entity type for the client is the same in both applications.

Steps in Practice CS

  1. Verify that the setup steps noted in the Steps in Workpapers CS section are complete.
  2. In Practice CS, choose Setup > Firm > Preferences tab and verify that the Integrate this Firm with other solutions is marked.

Sharing client and employee information with Onvio

You must be licensed for Onvio and have Onvio Link installed to be able to share client and employee information between Accounting CS and Onvio. Based on matching EIN/SSN, the client or employee information in Accounting CS is shared with a contact in Onvio.

Steps in Workpapers CS

  1. Verify that the setup steps noted above have been completed in the CS Professional Suite tab of the Setup > File Locations dialog.
  2. Verify that data sharing features are enabled - that is, that the checkbox to disable data sharing has not been marked in the Preferences tab of the Setup > Firm Information > Firm screen.

Steps in Onvio Link

  1. Install Onvio Link.
  2. In Onvio Link, enable data sharing and set up the appropriate data locations for Workpapers CS and Onvio.

Information that data shares

Client information

  • Telephone number
  • Address
  • Email address

Note: Client information can data share from Onvio Clients or Contacts.

Was this article helpful?

Thank you for the feedback!

Internal only

Accounting CS requires a FIRM database for integration and data sharing to work with UltraTax CS. The format of the Accounting CS database name must be ACS_<FirmID>_Firm. (For example, ACS_0_Firm, ACS_999_Firm, ACS_798046_Firm_.) Also, integration and data sharing will not work if there are multiple FIRM databases.