Tax export to ProSystem fx (Export Client Data Wizard)

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Use the Export Client Data Wizard to export client tax data to your ProSystem fx tax application from Accounting CS. 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 Accounting CS enable ProSystem fx to carry account balances to the proper lines on the appropriate tax forms.

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

Pre-export steps in Accounting CS

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

Notes

  • Accounting 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, Accounting CS creates the export file but includes only header information.
  • During the creation of the export file, the Accounting CS tax codes are converted to the ProSystem fx tax codes.
  • You can create custom tax codes in Accounting CS. When a custom tax code is assigned to an account, the standard Accounting CS tax code is mapped to the appropriate ProSystem fx tax code.
  • Accounting 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 Accounting 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.

  • 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.

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.)

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.

Related topics

Setting up file locations

Exporting client data to Lacerte, ProSystem fx, or ProSeries for tax reporting

Share This