Tax export to ProSystem fx (Export Client Data Wizard)

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!

Use the Export Client Data Wizard to export client tax data to your ProSystem fx tax application from Workpapers CS. Exporting client tax data to ProSystem fx Axcess is currently unavailable. You can specify the export file (or files), tax year, balance type, and format of the data to export. The tax code assignments that you make for specific general ledger accounts in Workpapers CS enable ProSystem fx to carry account balances to the proper lines on the appropriate tax forms.

Before you transfer account balances from Workpapers CS to ProSystem fx, verify that the data paths are set up correctly in both applications. To do this in Workpapers CS, choose Setup > File Locations > Export tab to set up file locations for ProSystem fx and other applications.

Pre-export steps in Workpapers CS

Assign the appropriate tax codes for the selected client in either of the following screens.

Notes

  • Workpapers CS creates and saves the export data as an ASCII file, as required by ProSystem fx.
  • If a file of the same name already exists in the specified location for the export file, the application overwrites the existing file.
  • If client data does not exist for the selected tax year, Workpapers CS creates the export file but includes only header information.
  • During the creation of the export file, the Workpapers CS tax codes are converted to the ProSystem fx tax codes.
  • You can create custom tax codes in Workpapers CS. When a custom tax code is assigned to an account, the standard Workpapers CS tax code is mapped to the appropriate ProSystem fx tax code.
  • Workpapers CS always exports custom tax codes in a summary format, which means that it combines all accounts assigned to the same custom tax code into a single record in the export file.

Processing steps in ProSystem fx

Complete these steps in ProSystem fx to import the data you exported from Workpapers CS in the procedure above.

  1. Choose File > Import > GL Bridge.
  2. Select the appropriate Accounting system from the drop-down list.
  3. Select Import File to select a file.
  4. Select the appropriate drive, folder, and filename extension for the file to use as the interface file.
  5. Highlight the file and click OK. The application imports data from the export file into the ProSystem FX Return.

For more information on the import procedure in ProSystem FX, see the documentation on the ProSystem FX website. External link ( What's this?)

This icon appears alongside links to resources that are not developed or maintained by Thomson Reuters. We provide access to these resources for your convenience, but we are not responsible for their accuracy. If you need additional assistance, please consult your qualified technician and/or the vendor who developed the resource.

Fields & buttons

The Export Client Data wizard presents the following pages as it steps you through the export process.

Source Data

  • Client name. Select a client from the drop-down list or, to export data for multiple clients at the same time, mark the Perform batch export of client data checkbox.
  • Export to program. Select ProSystem fx.
  • File Location. Enter the path or browse to the client data file. (The default data file location for each export type can be defined in the Export Data tab of the Setup > File Locations dialog.)
  • Tax Year. Select the tax year for which to export client data.
  • Balance Type. Choose the balance type for which to export data — Tax or Adjusted.
  • Format. Choose the format fo the export balance sheet information — Detail for an itemized format or Summary for a condensed format.

    Note: ProSystem fx does not allow detail format for every tax code.

Source Data - Clients

When you mark the Perform batch export of client data checkbox in the Source Data screen and click Next, the wizard opens this screen to enable you to select the clients whose data you want to export.

  • Search and Filter. Use these fields to narrow the list of clients in the Clients grid below. See Searching and filtering data for details.
  • Clients grid. Mark the checkbox for each client to include in the export file. (The application creates a single export file for each selected client.)

Export Complete

Diagnostics. The application automatically displays a summary of the information included in the export files — Accounts, Description, Tax Code, Beginning Balance, and Ending Balance.

To print the diagnostic information, click the Print button.

Was this article helpful?

Thank you for the feedback!