Chart of accounts (ACCNT)

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