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

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

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


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

In addition to using tax codes to integrate with UltraTax CS, licensed users of Accounting CS can export account numbers, account descriptions, and balances to the following tax applications.

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. Choose File > Export > Client Data.
  2. In the Export Client Data Wizard, select the client from the drop-down list or mark the Perform batch export of client data checkbox to select multiple clients. (You can choose 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 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.)
  5. Specify the tax year of the data to be exported by selecting it from the F4 drop-down list.
  6. For Lacerte or ProSystem fx only: Choose 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, choose 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, mark the Include prior year balances checkbox.
  9. For a single-client export: Click the Export button to create the export file for the selected client and then view or print the Tax Export Diagnostic report.
  10. For a batch export: Click the Next button to select multiple clients for batch processing, click the Export button to create the export files for the selected clients, and then view or print the Tax Export Diagnostic report.
Note: For information on the import procedure to use within Lacerte, ProSystem fx, or ProSeries, please refer to the documentation for those applications.

Related topics

Setting up file locations

Video: Exporting data to a Microsoft Excel file for tax reporting

Top of page

Share This