Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate data with other applications

Lacerte export troubleshooting

In addition to using tax codes to integrate with UltraTax CS, you can export account numbers, account descriptions and balances to Lacerte.
If the Diagnostics window within Lacerte contains nothing after completing the export process, review the following areas before exporting again.
  • Verify the client’s current posting period is the year you're exporting to Lacerte. You can view the
    Current Posting Period
     in the Accounting Information tab of
    Setup
     >
    Clients
    .
  • Go to
    Actions
     >
    Enter Trial Balance
     and verify that there are balances in accounts. You may find it helpful to set up a view in the Trial Balance grid to verify tax codes are assigned to the general ledger accounts too
  • Verify the file location is correct. Go to the Export Data tab in
    Setup
     >
    File Locations
     >
    Lacerte
    . The path should be
    C:\Lacerte\yyTax
    ,
    yy
     being the last 2 digits of the tax year you're importing into Lacerte.
  • Verify the client ID is the same in the application and Lacerte. Lacerte ID's are limited to 8 characters or less. You'll need to rename the client ID in the application to match Lacerte's specifications.
Naming convention for export file: ClientID.
?
B
y
? = entity
y = year
C = Corporation
6 = 2016
P = Partnership
7 = 2017
R = Non-profit
8 = 2018
S = S Corporation
N/A
The application will create the subfolders for each type of entity during the export process. The export file is placed in the appropriate folder based on entity type. The following entity type subfolders are automatically created when the Export Data tab in
Setup
 >
File locations
 for Lacerte is set to
C:\Lacerte\17Tax\
.
C:\Lacerte\17Tax\CDATA = Corporation\1120
C:\Lacerte\17Tax\PDATA = Partnership\1065
C:\Lacerte\17Tax\RDATA = Non-Profit\990/990PF
C:\Lacerte\17Tax\SDATA = S Corporation\1120

This article applies to:

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