Import and export files (IIF) can contain complete information about your chart of accounts. The keyword for the chart of accounts is ACCNT.
NAME
|
(Required) The name of an account in your chart of accounts. If the account is a subaccount, the account's name includes the names of the parent accounts, beginning with the highest level account. If you are creating an import file, use a colon (:) to separate subaccount names. |
TIMESTAMP
|
(Export files only) A unique number that identifies the company file from which you exported the chart of accounts. |
REFNUM
|
(Export files only) A unique number that identifies the account in the list. |
ACCNTTYPE
|
(Required) The type of account. If you are creating an import file, use one of the keywords below to indicate the account type:
AP
|
Accounts payable |
AR
|
Accounts receivable |
BANK
|
Checking or savings |
CCARD
|
Credit card account |
COGS
|
Cost of goods sold |
EQUITY
|
Capital/Equity |
EXEXP
|
Other expense |
EXINC
|
Other income |
EXP
|
Expense |
FIXASSET
|
Fixed asset |
INC
|
Income |
LTLIAB
|
Long term liability |
NONPOSTING
|
Non-posting account |
OASSET
|
Other asset |
OCASSET
|
Other current asset |
OCLIAB
|
Other current liability |
|
OBAMOUNT
|
The opening balance of the account. If you are creating an import file, enter the dollar amount WITHOUT a dollar sign. |
DESC
|
A brief description of the account. |
SCD
|
The tax line assigned to the account. To specify the tax line, enter its number (tax line numbers come from the file BUSTAX.SCD). If you don't know the correct number, leave this field blank. You can always assign the tax line later, after you import the chart of accounts into QuickBooks. |
ACCNUM
|
The account number of the account. |
EXTRA
|
Identifies an account as one of the special balance sheet accounts that QuickBooks automatically creates when the need for the account arises. If you are creating an import file, use one of these keywords to identify the account:
OPENBAL
|
Opening Balance Equity |
RETEARNINGS
|
Retained Earnings |
SALESTAX
|
Sales Tax Payable |
UNDEPOSIT
|
Undeposited Funds |
|