Print Topic

Chart of accounts (ACCNT)

Import and export files can contain complete information about your chart of accounts. The keyword for the chart of accounts is ACCNT.

Column headings

The following table shows the column headings for a chart of accounts. The NAME and ACCNTTYPE columns are required.

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. Leave the amount blank and import the account without an opening balance. 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. 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