Tax export to Lacerte (Export Client Data Wizard)

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 Workpapers CS phone support is available on that date from 9 AM - 5 PM ET.

Use the Export Client Data Wizard to export client tax data to your Lacerte tax application from Workpapers CS. Specify the export file (or files), tax year, balance type, and format of the data to export.

Choose File > Export > Client Data.

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.

Prior to transferring account balances from Workpapers CS to Lacerte, verify that the data paths are set up correctly in both applications.

For Workpapers CS: Choose Setup > File Locations > Export tab to set up file locations for Lacerte and other applications.

Use these procedures to transfer a client's general ledger account balances from Workpapers CS to Lacerte.

Pre-export steps in Workpapers CS

Assign the appropriate tax codes for the selected client. You can enter these codes in either of the following screens.

Notes

  • The export data is created and saved within a file that contains the filing year entity type represented in the extension of the file name, as required by Lacerte (for example, ClientID.?BY, where ? is the entity type and Y is the last digit in the year of the return). For more details about the Lacerte export see, Lacerte export troubleshooting.
  • If a file of the same name already exists in the specified location for the export file, the application overwrites the existing file.
  • If a tax year is selected for which client data does not exist, the export file is created 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.
  • Custom tax codes are always exported in a summary format, which means that all accounts assigned to the same custom tax code are combined in a single record in the export file.

Top of page

Screens, fields, and buttons in the wizard

Source Data

Select a client from the drop-down list in the Client name field, or (to select multiple clients) mark the Perform batch export of client data checkbox.

To select multiple clients for the data export, mark the checkbox and then click Next. In the Source Data - Clients screen, mark the checkbox for each client to include for the export.

Enter the path or browse to the client data file. (The default data file location can be defined in the Export Data tab of the Setup > File Locations dialog.)

Specify the tax year to export by selecting it from the drop-down list.

Specify the balance type to export by choosing one of the following options:

  • Tax
  • Adjusted

To export balance sheet information in itemized format, click the Detail option (rather than the Summary option).

Note: Lacerte does not allow detail for every tax code.

To export the client's prior year's ending balances for balance sheet accounts, mark this checkbox.

Source Data - Clients

Mark the checkbox for each client to be included with the export. (The application will create a single export file for each selected client.) Click Next to begin the export.

Export Complete

The application automatically displays a summary of the information included in the export files: Accounts, Description, Tax Code, Beginning Balance, and Ending Balance.

To print the diagnostic information, click the Print button.

Top of page

Related topics

Setting up file locations

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

Lacerte export troubleshooting

Top of page

Internal notes


Per TFS 971563, 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.

Development is hoping to fix this by Q1 2017. Until then, we need to tell users that they need to copy the files to the Lacerte data folders listed above.

Share This