Tax export to Lacerte
Use the Export Client Data Wizard to export client tax data to your Lacerte tax application from
Accounting 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 Accounting 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
Accounting CS
to Lacerte, verify that the data paths are set up correctly in both applications. To do this in Accounting 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 theSetup>Chart of Accountsscreen.
- In the data-entry grid in theActions>Enter Trial Balancescreen. If the data-entry grid doesn’t include a Tax Code column, selectView Maintenanceat the top of the screen, and then add a column for tax codes.
note
- Accounting CScreates and saves the export data and in a file and uses the following naming convention:<ClientID>.?By, where?represents the entity type andyrepresents 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 | pattern 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,Accounting CScreates the export file but includes only header information.
- During the creation of the export file, theAccounting CStax codes are converted to the Lacerte tax codes.
- You can create custom tax codes inAccounting CS. When a custom tax code is assigned to an account, the standardAccounting CStax code is mapped to the appropriate Lacerte tax code.
- Accounting CSalways 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 thePerform batch export of client datacheckbox.
- Export to program:SelectLacerte.
- 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 theSetup>File Locationswindow.)
- Tax Year:Select the tax year for which to export client data.
- Balance Type:Select the balance type for which to export data:TaxorAdjusted.
- Format:select the format for the export data:Detailfor an itemized format or Summary for a condensed format.noteLacerte 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.
