Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate data with other applications

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

In addition to using tax codes to integrate with UltraTax CS, licensed users of the application can export account numbers, account descriptions, and balances to the following tax applications.
  • Lacerte
    : Converts the application tax codes to an export file that contains Lacerte tax codes, account descriptions, and account balances. The export file can optionally include prior-year balances.
  • ProSystem fx
    : Converts the application tax codes to an export file that contains ProSystem fx tax codes, account descriptions, and account balances.
  • ProSeries
    : Creates a formatted file that contains account numbers, account descriptions, and account balances.
The tax data export feature is available for the following entity types: 1120, 1120S, 1065, 990 Exempt, and (for Lacerte and ProSeries only) 990 Private Foundation.
  1. Select
    File
     >
    Export
     >
    Client Data
    .
  2. In the
    Export Client Data Wizard
    , select the client from the dropdown or mark the
    Perform batch export of client data
     checkbox to select multiple clients. (You can select multiple clients on the next screen when this checkbox is marked.)
  3. Select the application (
    Lacerte
    ,
    ProSystem fx
    , or
    ProSeries
    ) to which the data file will be exported.
  4. 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.)
  5. Specify the tax year of the data to be exported by selecting it from the F4 dropdown list.
  6. For Lacerte or ProSystem fx only:
     Select the balance type (Tax or Adjusted) to specify the type of information to export.
  7. For Lacerte or ProSystem fx only:
     To export balance sheet information in itemized rather than summarized format, select the
    Detail
     (rather than the
    Summary
    ) option.
  8. For Lacerte only:
     If the client's prior-year balances are to be included in the export file, select the
    Include prior year balances
     checkbox.
  9. For a single-client export:
     select
    Export
     to create the export file for the selected client and then view or print the Tax Export Diagnostic report.
  10. For a batch export:
     select
    Next
     to select multiple clients for batch processing, select
    Export
     to create the export files for the selected clients, and then view or print the Tax Export Diagnostic report.

This article applies to:

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