NAME

(Required) The name of an account in your chart of accounts. import files^IIF, . If the account is a subaccount, the account's name includes the names of the parent accounts, beginning with the highest level account. import files^IIF, . 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. import files^IIF, . 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. import files^IIF, . Leave the amount blank and import the account without an opening balance. import files^IIF, . If the account must have an opening balance, use the TRNS keyword to create an opening balance transaction for the account.

DESC

A brief description of the account.

SCD

The tax line assigned to the account. import files^IIF, . To specify the tax line, enter its number (tax line numbers come from the file BUSTAX.SCD). import files^IIF, . If you don't know the correct number, leave this field blank. import files^IIF, . 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. import files^IIF, . 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