Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

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.
note
  • Workpapers CS
     creates and saves the export data and in a file and uses the following naming convention:
    <ClientID>.?By
    , where
    ?
     represents the entity type and
    y
     represents the last digit of the year of the return
?= entity
y = year
C = Corporation
6 = 2016
P = Partnership
7 = 2017
R = Non-profit
8 = 2018
S = S Corporation
patter repeats
  • 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 doesn’t 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 Lacerte tax codes.
  • You can create custom tax codes in
    Workpapers CS
    . When a custom tax code is assigned to an account, the standard
    Workpapers CS
     tax code is mapped to the appropriate Lacerte 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.

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.
    note
    Lacerte doesn’t let detail format for every tax code.
  • 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.)
Internal use only
The Lacerte tax files should be placed in the following locations:
  • 1120 - C:\Lacerte\xxTAX\CDATA
  • 1120s - C:\Lacerte\xxTAX\SDATA
  • 1065 - C:\Lacerte\xxTAX\PDATA
  • 990 / 990PF - C:\Lacerte\xxTAX\RDATA
Instead of the XDATA folders, the application is creating a folder with the entity type. For example, 1120 files are being placed in the C:\Lacerte\xxTAX\1120 folder.

This article applies to:

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