We moved!
Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!
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, choose Setup > File Locations > Export tab to set up file locations for Lacerte and other applications.
Pre-export steps in Workpapers CS
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 does not include a Tax Code column, click the View Maintenance link at the top of the screen, and then add a column for tax codes.
Notes
- 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. Show me.
- 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 does not 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 & buttons
The Export Client Data wizard presents the following pages as it steps you through the export process.
Was this article helpful?
Thank you for the feedback!
Per ADO 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.