Skip to main content
Integrate data with other applications

Tax export to ProSystem fx

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
, select
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.
  • In the Tax information section of the
    Chart of Accounts
     screen.
  • In the data-entry grid in the
    Enter Trial Balance
     screen. If the data-entry grid doesn’t include a
    Tax Code
     column, select
    View Maintenance
     at the top of the screen, and then add a column for tax codes.
note
  • 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 Accounting 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.

Process steps in ProSystem fx

Complete these steps in ProSystem fx to import the data you exported from
Workpapers CS
 in the procedure.
  1. Select
    File
     >
    Import
     >
    GL Bridge
    .
  2. Select the Accounting system from the dropdown list.
  3. Select
    Import File
     to select a file.
  4. Select the drive, folder, and filename extension for the file to use as the interface file.
  5. Select the file and select
    OK
    . The application imports data from the export file into the ProSystem FX Return.

Fields and buttons

Source Data
  • Client name:
    Select a client from the dropdown list or to export data for multiple clients at the same time, select the
    Perform batch export of client data
     checkbox.
  • Export to program:
     Select
    ProSystem fx
    .
  • File Location:
     Enter the path or go 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
     window.)
  • Balance Type
    : Choose the balance type for which to export data —
    Tax
     or
    Adjusted
    .
  • Tax Year:
     Select the tax year for which to export client data.
  • Format:
     Select the format to the export balance sheet information -
    Detail
     for itemized format or
    Summary
     for a condensed format.
Source Data - Clients
When you mark the
Perform batch export of client data
 checkbox in the
Source Data
 screen and select
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 filter the list of clients in the Clients grid.
  • 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.)

This article applies to:

  • Product: Workpapers CS,Accounting CS
  • Subject: Integration