Help Articles

Intuit Help · ‎10-28-2020

The table below is a listing of all possible company data files.

A company's files will end with the same 3-digit file extension, which corresponds to the Company ID. For example, all files for a company with the ID AAA will end in .AAA (For example, genled.aaa, empl.aaa, and so on).
A company's files will vary based on what modules you use for that company. For example, if you don't use the Accounts Receivable module, most (or all) of the A/R files won't be present for that company.

Abbreviations key in the Table:

AMT = Amortization
AR = Accounts Receivables
AP = Accounts Payables
BR = Bank Reconciliation
DPR = Depreciation
EFT = Electronic Funds Transfer
PR = Payroll
WU = Write Up

List of Data Files

File Name	Purpose	Module
A41xxxxx	User Report Selections	AR
A4Bxxxxx	User Report Selections	BR
A4Exxxxx	User Report Selections	EFT
A4Gxxxxx	User Report Selections	WU
A4Pxxxxx	User Report Selections	PR
ADRDAT	Depreciation assets	DPR
ADRDATX	Index to assets	DPR
Amxxxxxx	Amortization schedule	AMT
AORDER	Customer information for automatic transactions	AR
AORDERX	Index to customer information for automatic transactions	AR
AORDITM	Individual line items for automatic transactions	AR
AORDITMX	Index to automatic transactions	AR
APCHKS	Check transactions	AP
APCHKSX	Index to check transactions	AP
APDIST	Account distribution for invoices	AP
APDISTX	Index for account distribution	AP
APJE##	Distribution of payables activity to the general ledger	AP, WU
APPOPS	Product purchase summary	AP
APPOPSX	Index to product purchase summary	AP
APTRAN	Invoice transactions	AP
APTRANX	Index to invoice transactions	AP
ARDIST	Transaction types	AR
ARDISTX	Index to transaction types	AR
ARJE##	Distribution of AR activity to general ledger	AR, WU
ARPSRS	Product sales and returns summary	AR
ARPSRSX	Index to sales and returns summary	AR
AUTOINV	Automatic transactions	AP
AUTOINVX	Index to automatic transactions	AP
AUTOTR##	Automatic entries posted by the general ledger	WU
B1AXXXXX	User Report Selections	AP
CASH##	Sales journal entries	WU
CASHTR##	Sales journal entries posted by the general ledger	WU
CASHX##	Index to the sales journal entries	WU
CBAxxxxx	Current bank transactions	BR
CBILL	Company billing information	WU
CBOxxxxx	Current book transactions	BR
CC	Computed checks (through Batch Payroll module)	PR
CCX	Index to computed checks	PR
COMPANY	General company information	ALL
COMPANY2	Additional company information	ALL
CUST	Customer information	AR
CUSTNOTE	Customer notes	AR
CUSTNOTX	Index to customer notes	AR
CUSTSHP	Customer shipping address	AR
CUSTCHPX	Index to customer shipping address	AR
CUSTX	Index to customer information	AR
CSHJE	Sales journal entry descriptions	WU
CWBILL	Company billing information	WU
DEFAULTS	Holds default methods and lives for assets set up in the Depreciation option	DPR
DRECX	Index to deleted records	ALL
EMPL	Employee payroll information	WU, PR
EMPLX	Index to employee primary files	WU, PR
EZBANKS	Bank file	BR, PR WU, EFT
EZBANKX	Index to bank file	BR, EFT, PR, WU
FORMAT	The financial report layout	WU
FORMATA	Financial Report Templates	WU
FORMATAX	Index to the Financial Statement Templates	WU
FORMATD	Custom Financial Statements	WU
FORMATDX	Index to the Custom Financial Statements	WU
GENLED	Chart of accounts and the account balances	ALL
GENLEDX	Index to the general ledger	ALL
GLGRAPH	Data entered for graphic presentations	WU
GLTRAN##	Transaction data file containing all the month's regular transactions. (The number of month is shown immediately after the name GLTRAN.)	WU
GROUP	Asset group names	DPR
LAYOUT	The automatic layout design	WU
LAYOUTA	Financial Statement Templates	WU
LAYOUTD	Custom Financial Statements	WU
Lexxxxxx	Employee letters	WU, PR
LFxxxxxx	Financial letters	WU
LVxxxxxx	Vendor letters	WU
LOCATION	Asset location descriptions	DPR
LTDAT	Local tax IDs, descriptions, and codes	PR, WU
ORDER	Customer information for Transactions	AR
ORDITM	Individual line items for AR transactions	AR
OTDAT	Other tax IDs, descriptions, and codes	PR, WU
PBAxxxxx	Prior bank transactions	BR
PBILL	Company billing information	PR
PBOxxxxx	Prior book transactions	BR
POTERMS	Purchasing Terms Codes	WU
PRDCOST	Products and Services Prices	AR
PRJE##	Payroll journal entry, the number of month is shown immediately after the name PRJE	PR, WU
PRMMDD##	File imported from Batch Payroll that contains direct deposit advices	EFT
PRODCODE	Product and Services Codes	AR
PRTRAN##	Payroll transaction data file containing all of the month's payroll entries. (The number of months is shown immediately after the name PRTRAN.)	PR, WU
PRTRAX##	Index to the monthly payroll file	PR, WU
RECJE	Recurring journal entries	WU
R#xxxxxx	Report selection files	WU
STDAT	State tax Ids	PR, WU
SUTA	SUTA rate information	PR, WU
TAXDATA	Used for printing of tax forms (Depreciation only)	DPR
TAXFEDWH	FICA and Federal Withholding tax deposit data	PR
TAXFUTA	Federal Unemployment tax deposit data	PR
TAXLIST	Used for printing of tax forms and transfers to tax programs (Depreciation only)	DPR
TAXSUTA	State Unemployment tax deposit data	PR
TAXxxxOTH	Other State Withholding tax deposit data	PR
TAXxxxLT	Local Withholding tax deposit data	PR
TAXxxST	State Withholding tax deposit data	PR
TR	Transaction data file (through Batch Payroll module)	PR
TSxxxxxx	Import/export file name	ALL
VENDOR	Vendor information	WU
VENDORX	Index to vendor files	WU
WCOMP	Workman's compensation information	PR
WCOMPX	Index to workman's compensation information	PR