Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

Lacerte Data - File Structure and Extensions

Intuit

Lacerte Data - File Structure and Extensions

Lacerte Data - File Structure and Extensions.

Solution

The Data Path is the most important path Lacerte interacts with. The program utilizes the information found in the path to calculate/print returns.

The Data Path can be found by pressing F10 to open the Technical Support Information window.  Your Data Path will be listed in the System Information tab.
You can also view your data path by going to the Settings menu and clicking  Options.  The Data Path can be found on the Setup tab.

The default Data Path is X:Lacerte??Tax#Data

  • X: is the drive letter that the user has specified the data to be
  • ?? is the year of the program.
  • The # is the module letter that data is set to.

For example, "I" would indicate "Individual" data, where "C" would imply "Corporate". 

Complete listing of Lacerte  modules:

  • I = Individual 1040
  • P = Partnership 1065
  • C = Corporate 1120
  • S = S-corporation 1120S
  • F = Fiduciary/Trust 1041
  • R = Exempt Org 990
  • B = Benefit Plan 5500
  • T = Estate 706
  • N = Gift 709

Inside the Data Path you will see a list of *.DBF Files. These files that contain information such as Client Information (Screen 1) and Subclient Information.

     Note: Subclients are Dependents (Individual), Partners (Partnership), Officers (Corporate, Exempt Organization), Shareholders (S-Corporate), Beneficiaries (Fiduciary, Estate), Donees (Gift), and Participants (Benefit Plan).

You will also see a list of *.MDX Files. These are index files used to find records in the *.DBF files.
The Detail folder contains all Detail Screens except Client Information, Subclient Information, and Notes. In the Detail folder there will be exactly one file for every client in that particular tax type. Those client files will have a 3 digit file extension with the letter of the tax type, follow by the letter D, then the last digit of the tax year. For example, a file extension of .ID9 would indicate an Individual 2009 client file.
Other folders stored in the Data Path:
  • NOTES: contains the clients notes information from the client Detail (Screen 47) and other miscellaneous things. There will be several files with different extensions for each client.
  • BAD: stores Defective Bridge and Detail Files.
  • DCDATA: contains custom templates for the Data Conductor.
  • EF: contains E-File transmission and acknowledgement files.
  • ESignature: contains files related to ESignature.
  • EXPORT: default location for Export files.
  • Link: contains files related to Intuit Link.
  • RefundsN: contains information used by Refunds Now for Rapid Anticipation Loans
  • TaxImport: contains files related to Scan and Submit, and Financial Institution Download
  • TBData: contains Trial Balance Data for all clients combined into a set of database files.
  • URN: contains information regarding users in the program.
Note: this list is not conclusive as we may add folders in support of new features in the program. Not all folders are applicable to all tax modules.

Was this helpful?

You must sign in to vote, reply, or post
Labels (1)