Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate data with other applications

Tax export to Lacerte

Use the Export Client Data Wizard to export client tax data to your Lacerte tax application from
Workpapers CS
. Specify the export files (or files), tax year, balance type, and format of the data to export. The tax code assignments that you make in
Workpapers CS
 for specific general ledger accounts enable Lacerte to carry account balances to the proper lines on the appropriate tax forms.
Before you transfer account balances from
Workpapers CS
 to Lacerte, 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 Lacerte and other applications.

Pre-export steps

Assign the appropriate tax codes for the selected client in either of the following screens.
  • In the Tax information section of the
    Setup
     >
    Chart of Accounts
     screen.
  • In the data-entry grid in the
    Actions
     >
    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.

Fields and 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 dropdown or to select multiple clients at the same time, mark the
    Perform batch export of client data
     checkbox.
  • Export to program:
     Select
    Lacerte
    .
  • 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.)
  • Tax Year:
     Select the tax year for which to export client data.
  • Balance Type:
     Select the balance type for which to export data:
    Tax
     or
    Adjusted
    .
  • Format:
     select the format for the export data:
    Detail
     for an itemized format or Summary for a condensed format.
  • Include prior-year balances:
    Mark this checkbox to export the client's prior year's ending balances for balance sheet accounts.
Source Data - Clients
  • 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: Accounting CS, Workpapers CS
  • Subject: Integration